• Cut data warehouse load run time by two thirds and maintenance time by an order of magnitude by building an SSIS integrated dynamic code generation engine.• Reduce stored procedure and view complexity and run time, often by an order of magnitude or more.• Made major improvements to data quality and integrity of data warehouse, reports, and other critical business processes.• Improve SQL code quality of other developers and train them in writing efficient T-SQL.• Increase transactional database code maintainability and data quality by refactoring similar code scattered throughout multiple objects into a single object to be called by the others.• Improve database integrity and performance by tuning or removing inappropriate triggers, and adding appropriate constraints and indexes.• Maintained, tuned, & enhanced high availability databases/SQL servers supporting a 24x7 web site.

• Achieved order of magnitude performance gains by tuning queries on multi-billion row tables.• Built complex, high-performance queries, often with limited indexing on underlying tables.• Researched & fixed data issues & code bugs involving thousands of SQL objects & terabytes of data

• Completed a legacy SQL Server database replacement project well ahead of schedule, reducing down time from days to hours when the legacy server failed unexpectedly.• Substantially reduced database maintenance requirements by consolidating multiple SQL Server database clones into a single database without sacrificing performance.• Enhanced integrity, security, and accessibility of critical data by streamlining integration of legacy SQL databases and .NET applications with newer SQL 2016 databases and locking down sensitive data.• Greatly increased software reliability and flexibility by consolidating multiple similar C# based programs into a single configurable application.• Improved readability, appearance, and data quality of customer reports while eliminating the need for manual edits.• Setup and administered multiple SQL Servers, with many databases of varying sizes (one over a TB with over a billion rows in one table) and complexity (hundreds of tables, views, and stored procedures).

• Greatly increased the speed and reliability of ETL processes pulling data from disparate global accounting systems into a SQL Server data warehouse and standardizing time and culture specific data for a global manufacturing firm.• Improved client business analytics by designing and building multidimensional and tabular SQL Server data warehouses and the ETL processes to populate them.• Migrated data into a new finance/trading accounting system with minimal disruption to the business by merging data from two legacy systems based on different databases. Also updated numerous applications and integrations to work with the new system.• Enhanced database security by designing and building software for automatically securing Microsoft SQL Server databases.• Served as “Go To” expert for database design, performance tuning and SQL optimization questions related to both transactional databases and data warehouses for multiple clients.• Solved a seemingly unsolvable problem by using mathematical analysis to generate an artificial unique key where the source database had none.• Enhanced performance, functionality, and flexibility of a legacy VB application by converting code to C# & VB.NET and optimizing data storage and management.• Minimized program and database update risks by writing comprehensive unit tests and designing highly configurable software.• Greatly reduced system update complexity through the use of interface-based design patterns.• Optimized performance and resource usage via asynchronous and multi-threaded services.• Sped adoption and eased continuing maintenance by writing clear, concise user and technical documentation.

• Improved speed and accuracy of retirement plan management for a major insurance company by developing a custom plan management application that fully integrated with their SQL Server based accounting system.• Streamlined financial management for numerous clients by installing, configuring, and customizing SQL Server based accounting software to meet their specific needs.