Senior Database Developer
Excel Automotriz,
Jan 2016 - Jan 2024 (8 years 1 month)
• Led data migration and optimized legacy T-SQL code, enhancing performance from SQL Server 2005 to SQL Server 2015 by applying SQL Performance Tuning and leveraging the SQL Server Query Optimizer.
• Created process diagrams for key business operations, improving team comprehension and reducing incident response times, leading to enhanced efficiency.
• Restructured complex processes, utilizing insights from SQL Server Internals to boost performance and scalability.
• Developed, tuned, and optimized advanced SQL queries, implemented ETL processes with SSIS, and conducted technical data analysis to generate actionable insights. Leveraged Power BI, Power Query, and DAX (Data Analysis Expressions) to design interactive dashboards and data