Software Engineer
• Orchestrated the development of an automated ETL pipeline for Heavy Equipment DMSSOR, streamlining data extraction processes and increasing data accuracy by 90%. • Led the maintenance, support, and development efforts for DMSSOR environments and ETL import/export processes, resulting in a 20% reduction in system downtime.• Engineered and implemented a complex database architecture featuring 100+ tables, 200+ columns, and indexes to optimize data warehouse infrastructure.• Integrated foreign key constraints to bolster data relationships, resulting in a 35% decrease in query execution time and a 20% enhancement in data retrieval efficiency.• Designed and managed SSIS packages for seamless data movement among 37 SQL Servers, increasing data transfer speed by 80% and enhancing overall database efficiency.• Improved a streamlined process to analyze and cross-reference data from import files to the data archive, resulting in a 100% increase in data accuracy and efficiency.• Constructed and administered SQL Agent Jobs to facilitate automated database updates, performance tracking, and notification mechanisms, optimizing data management processes and minimizing downtime risks.• Crafted detailed Runbooks for error handling and Knowledge Transfer, resulting in a 90% increase in team collaboration and knowledge sharing.• Streamlined troubleshooting procedures and documentation, leading to a 30% reduction in average resolution time and enhancing overall system stability during non-business hours.• Directed and executed a planned data transfer operation involving SQL servers, leveraging SSIS packages, SQL Agent jobs, and custom SQL code during designated Sunday maintenance windows.• Developed Data Archival processes to process, publish, and store RAW data from imported records.
