Data Engineer
Current• Participated in collaborative business analysis and technical design sessions involving both business and technical teams to craft comprehensive requirements documents and ETL specifications. Worked closely with business users, clients, and product owners to clarify and translate requirements into detailed technical specifications. Facilitated productive meetings with stakeholders and department managers to provide project status updates and elucidate ongoing data engineering processes.• Developed intricate SQL Stored Procedures to enhance the validation process and facilitate the seamless transfer of data from staging areas to production tables. Conducted in-depth SQL Index analysis for tables, devising more efficient solutions by implementing Clustered and Non-Clustered Indexes to significantly boost the performance of existing product databases.• Created advanced SQL queries and stored procedures to support web applications and generate data reports. Customized and optimized existing SQL stored procedures in alignment with technical specifications and executed troubleshooting on pre-existing stored procedures.• Leveraged Azure DevOps, Terraforms, and GIT Hub for version control and streamlined code deployment to subsequent environments. Operated within an Agile environment, delivering daily status updates to supervisors.• Demonstrated expertise in relational and multidimensional data modeling, particularly in the transportation industry, with a strong command of concepts such as Star/Snowflake Schema, Fact, and Dimension
