ULYSSES B. BROWN JR., MCP
Web: http://ulysses.azurewebsites.net/ | Email:
TALENTS:
17yr SQL Server -2016 & lower(T-SQL Developer-DBA-Lead) / 12yr SSIS
(Develop-Deploy-Manage-Troubleshoot) / 9yr SSRS
(Rpts-Dashboards-KPIs) / 5yr SSAS
(Tabular-Marts-Cubes-Warehouse)
Procs, Functions, Dynamic SQL, Triggers, CTEs/Windowing, etc. / OLTP Tuning, Monitoring, Optimization, Capacity Planning, Partitioning / BI-Analytics, Power BI, Tableau, Visualization / OLAP, Star Schema, Facts-Dimensions, Measures, PowerPivot, PowerQuery
Database Modeling, Deployment, Capacity Planning, Implementation, Reverse Engineering / Architecture & Design, Standards, Requirements, Strategic Decisions, Operations, Automation, Baselining / Database Monitoring, Security, Best Practices, Assessments, Features / PowerShell, R, Python, XML, XSLT, XQuery, XPath, DAX, MDX, LINQ, Expressions
Backup/Recovery, High-Availability, Change/Configuration Management / Oracle, NoSQL, PostgreSQL, Hadoop, MySQL, Excel, Access, Dynamics, Sybase / .NET, VB/Java Script, JSON, JQuery, HTML5, CSS / SDLC, SaaS, Web Services, Cold Fusion
Windows & SQL Azure, Linux (Red Hat), Active Directory, Kerberos (SPN), Domain Administration / TFS, VSTS, SalesForce, Rally, Documentation, Quality Assurance, Jenkins, Docker / DevOps, Tier-2 Support, Triage, 24x7 On-Call, Customer Service, Testing / Director, Team Lead, Project Management, Business Liaison
Financial Applications / Healthcare Applications / Warehouse/Logistics Applications / Mentoring, Tutoring, Subject Matter Expert, Trustworthy, Dependable
RECENT MAJOR SUCCESSES:
“Leading The Way”
o Issue: Vendor provided LTW a hardcopy of a “Non-donor conversion report” in the form of an Excel workbook. LTW did not want to continue to pay the vendor for this product. LTW wanted a real-time version built internally but they did not have any insight on how the complex report was generated.
ü Resolution: Reverse engineered the report to produce a real-time … run-time version. Wrote complex T-SQL stored procedures into a process that produced the exact output, an identical match, of the Excel spreadsheet. The T-SQL involved was complex (760 lines) based on some of the latest functions included in SQL Server 2016 and included pivots and unpivots and T-SQL tricks to produce the matching layout in the code instead of relying on an additional step in Excel to produce the desired layout.
“Peoplenet”
o Issue: Clients want real-time reports. Company needs to keep existing interface, business rules and process flow
ü Resolution: Wrote 1st SSRS solution to seamlessly integrate with existing report engine written in VB/ColdFusion
o Issue: Existing reporting engine unable to produce reports to wireless non-intranet Apple IOS devices (tablets, time clocks)
ü Resolution: Wrote 1st SSRS solution to provide authentication and reporting capability of non-intranet Apple IOS devices
o Issue: Daily production nightmare. System crashes when new ETL process ran plus process produced severely bad data & results, it was only tested against known good data sources (not real-world scenarios) … the ETL code & data model from off-shore team
ü Resolution: I was able to troubleshoot and resolve all issues, including fixing the data using profiler and reverse engineering and writing a scrubbing process using advanced T-SQL
PROFESSIONAL EXPERIENCE:
SQL Server T-SQL/Dev/DBA & .Net (Web) / “Freelance” -- (Consultant/Tutor) -- Current -- Atlanta, GAo Tutor adults and college students in writing T-SQL, MySQL, PL-SQL and in SQL Administration
o Provides consulting services including T-SQL Stored Procedures for business logic, Website/Report enhancements, updates, and modifications for individuals and non-profits
SQL BI Developer (T-SQL/SSRS/SSIS) / “Leading The Way” -- (Consultant) -- Feb 2017 to Contract -- Atlanta, GAo Gathered requirements and wrote advanced T-SQL stored procedures to reverse engineer and support application and reports
o Provided guidance and suggestions on existing T-SQL for optimization, performance and new T-SQL coding best practices
o Develops prototype data views and reports of financial data and work with business users and SMEs to refine requirements
o Create, maintain, and support complex reports, dashboards with multipart formulas, stored procedures, custom tables and customized functions utilizing SSRS, SharePoint, Excel Power Tools and other BI tools to visualize the data
o Creates, modifies, and enhances SQL 2012 SSIS packages used to import call center data into staging and production systems
o Act as key point of contact for data requests to produce data analytics key to driving business intelligence insight
o Identify and analyze data discrepancies and data quality issues and work to ensure data consistency and integrity
o Test and evaluate business rules, master data services and ETL and reconcile any differences from expected results
Senior App-Dev Support (Cricket Wireless) / “DISYS” -- (Consultant) -- Nov 2016 to Nov 2016 -- Atlanta, GAo Implement DevOps Best Practices for Software Deployment, Continuous Integration/Automation, Application Stability/Reliability, and Business Continuity ensuring Maximum Production Systems Uptime
o Provided advanced T-SQL query troubleshooting and performance tuning for SQL Server 2012 applications
o Monitor, report, troubleshoot, and resolve application performance issues for multiple Applications and Services
o Provided application support and new documentation, ERDs & process workflow diagrams around data transfer, file transfer, logins, compliance (permissions, security settings), application deployments, application layer ETL and system development
o Developed PowerShell scripts to automate and simplify status reporting of SQL Agent and Task Schedule Jobs w/ color coding
SQL Server Dev/DBA & .Net (Web) / “Freelance” -- (Consultant/Tutor) -- On Going since 2015 -- Atlanta, GAo Tutor adults and college students in advanced T-SQL and SQL Server Administration
o Provide services including Website/Report enhancements, updates, and modifications for individuals and non-profits
o On-line/Telecommute technical support, troubleshooting, query performance tuning, backup-recovery, training, reverse engineering
o 9-month sabbatical to Richmond, VA (EOL preparation assistance & handicap accessibility for very elderly parents)
o Returned to Atlanta, GA beginning of October 2016
Senior SQL Server Developer (DevOps) / “Peoplenet” -- (Employee) -- Oct 2013 to Dec 2015 -- Sandy Springs, GAo Provide advanced/complex database development including stored procedures, triggers, functions, dynamic T-SQL, views, and ad-hoc queries for SQL 2016 & 2008R2 … including new features Windowing Functions, CTEs, etc
o Provide production support and technical expertise requiring advanced SQL understanding & experience for query troubleshooting, performance tuning, index analysis, data compression, encryption, etc.
o Use Agile/DevOps development & collaboration methods to improve integration, automation, testing, delivery and reliability of software releases and infrastructure changes with goal of no negative impacts with continual improvements
o Maintain integrity of SQL Scripts, Cold Fusion scripts, and VB code and development using source control, best practices, and company procedures to ensures availability and reliability of applications
o Occasional BA/PM role gathering/clarifying requirements, objectives, and goals from key stake holders, SMEs, upper management
o Mentor, train, and provide assistance to new team members as required
o Provide report development, processing, dashboards and analytical presentation using SSRS, Crystal Reports, VB, Power BI, others
Sr. SQL Server DBA/Dev (Expert-Mentor) / “B2B” -- (Consultant) -- Feb 2013 to Oct 2013 -- Richmond, VAo Provide expert level database administration, modeling, and development for SQL 2012 & 2008R2 environments
o Provide support and technical expertise for advanced SQL options including failover cluster, replication, database mirroring, AlwaysOn Availability Groups, log shipping, table & index partitioning, data compression, snapshots, encryption, filestream, etc.
o Plan, develop and implement architecture, processes, baselines, best practices, and procedures to ensures availability and reliability of SQL instances and applications
o Plan, develop and implement automation of monitoring and alerts via T-SQL PowerShell scripts and SQL Agent
o Provide security audit, security findings report, and security strengthening of SQL environments
o Provide 24/7 on-call readiness as necessary
o Perform capacity planning, re-design, server consolidation, virtualization, high availability, disaster recovery, service packs, and version upgrades
o Provide SQL performance audit and recommendations based on detailed analysis. Perform effective query/stored procedure performance tuning
o Provide SQL Server licensing audit and recommendations
o Mentor, train, and provide customized hands-on tutoring and presentations of advanced SQL DBA/Development theories, principals, technologies, and skills
o Write and troubleshoot complex stored procedures, triggers, functions, dynamic T-SQL, views, and ad-hoc queries to meet specific business requirements
o Integrate and migrate data from other RDBMS (including Oracle, DB2, MySQL, Sybase, Access, etc.) using SSIS, OpenQuery, OpenDataSource, Linked Servers and other methods
o Provide report development and presentation using SSRS, Cognos, Crystal Reports, Proclarity and other tools
o Gather and clarify requirements, objectives, and goals from staff, management, and owners. Create design documents/diagrams, data models, functional requirements, prototypes, and test cases
Lead SQL Server DBA/Developer / “Patient First” -- (Employee) -- Sep 2011 to Jan 2013 -- Richmond, VAo Responsible for senior level database administration and high availability of production SQL 2012 & 2008R2 Servers
o Responsible for SQL security, capacity planning, server consolidation, and disaster recovery
o Responsible for backup and recovery model, service pack and patches, performance baseline, and overall SQL Server health
o Planned and Implemented upgrades/migrations of SQL versions from 2005 to 2008R2 and from 2008 to 2012
o Developed, maintained, and deployed complex SSIS packages for SQL 2008 R2 and 2012 (project deployment model)
o Wrote complex SSIS packages for large multi-step ETL processes utilizing multiple connection types, error handling, alerts, etc.
o Monitored and maintained SQL Server 2008 failover cluster (on Windows 2008 Clustering Service)
o Implemented best practices for database administration in virtual environment (VMware) and non-virtual environments
o Developed detailed complex SSRS solutions to support internal processes
o Developed tabular model SSAS data warehouse for processing and analysis of internal data
o Wrote SQL Server ETL processes for migration of data from multiple data sources
o Trained junior staff in SQL best practices
o Wrote complex T-SQL stored procedures, triggers, functions, and complex queries
o Maintain and monitor SQL Server systems using email alerts and key performance indicators
Senior SQL Server DBA/Developer / “Richmond Cold Storage” -- (Contractor) -- Feb 2010 to Jul 2011 -- Richmond, VAo Development and administration of PROD, TEST, & DEV SQL 2005 & 2008R2 Servers in hosted virtual environment
o SLDC and maintenance cycle including detailed code reviews and requirements gathering and quality control measures
o Wrote SQL Server ETL application for migration of warehouse inventory and setup data from Oracle to SQL Server
o Developed SSIS for complex ETL processes as necessary and feasible
o Lead Developer on several production software builds
o As Senior SQL DBA maintained best practices for SQL environment including baseline monitoring and business continuity
o Responsible for managing production software releases through all phases including testing and promotion
o Rotating 24x7 On-Call support of core application and database
o Developed senior level complex T-SQL stored procedures, triggers, functions, and complex queries for extraction, evaluation, scrubbing, transformation, reporting, and analysis of food industry warehouse data from Oracle to SQL Server
o Maintain and monitor SQL Server systems using email alerts and key performance indicators
o Developed SSRS application for tracking SQL performance and data statistics, KPIs and progress towards company goals
Senior 2 SQL Server DBA/Developer / “MadisonGrey” -- (Employee) -- Sep 2008 to Nov 2009 -- Sandy Springs, GAo Senior DBA/Developer responsible for all corporate SQL Servers (local and remote)
o Developed complex SSIS packages and ETL processes for remote data collection from many different, sources, platforms and data types. Evaluate data for consistency, accuracy, and completeness eliminating duplicate or missing data and ensuring reliability
o Responsible for SSIS deployment across DEV and PROD environments
o Most of SSIS development work was done using configuration files paradigm for scalability and portability
o Functioned as technical lead in planning, modeling, design and implementation of corporate SQL environment, including hardware requirements, configurations and security
o Wrote complex SQL Server 2000 - 2005 stored procedures, triggers, functions, and complex queries for extraction, evaluation, scrubbing, transformation, reporting, and analysis of financial data from various internal and external sources and formats
o Assisted in development, implementation, productivity, and documentation of SQL Server components for end-user BI dashboards and status reports, and production reports
o Planned and implemented best practices for optimal performance, tuning, optimization, troubleshooting, and availability of local and remote SQL Server systems
o Worked with LAN/WAN and Domain administrators to evaluate and resolve remote connectivity and performance issues and maintain security updates and service packs of servers
o Provided detailed documentation of physical environment, ERD and data models, logical processes, and methodologies for all SQL Servers as peer-user documentation and ensure business continuity in disaster recovery scenarios
o Proactively maintained and monitored internal and remote SQL Server systems. Set up email alerts and key performance indicators
o Assisted web developers and .NET developers in developing, testing and implementing integrated applications by writing complex SQL components and by providing technical support and expertise of all SQL Server components and processes
IT/SQL (CEO-Lead Consultant) / “SOTATS” -- (Owner) -- Jan 1996 to Mar 2008 -- Marietta, GAo Own and operate all aspects of upstart IT consulting firm
o Primary responsibility to perform competent work to the complete satisfaction of existing clients
o Other roles include new client sales. Provide technical specifications of job, and negotiating job contracts that benefit clients
o Performed installation, configuration, and maintenance of all hardware, software, network, and communication components for computer systems ranging from personal desktops to Client/Server LAN/WAN based networks using Windows Server OS, Exchange Server, Microsoft BackOffice, SQL Server, SharePoint, and SMS
o Troubleshot, torn apart, and repaired hundreds of PCs and Servers for issues ranging from motherboard replacement, new memory or other cards, incompatible drivers, etc.
o Designed and developed, user-friendly customized, relational database applications for small businesses, churches, dentist offices, and other organizations (clients) using SQL Server 2000, MS Access, and Visual Basic. The specific application components vary depending on client needs but most all include customized data entry forms, data analysis queries, and summary reports
o Developed web sites and web pages for clients. Help identify and setup available hosting packages for clients