Eric Jerome Email & Phone Number

Austin, Texas, United States

• 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.

Dallas, Texas, United States

• 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

Lakeland, Florida Area

• 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).

Greater Denver Area

• 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.
• 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.
• 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.

Greater Denver Area

• 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.