Highly motivated and detail-oriented professional with expertise in data analytics, ETL development, and SQL development, leveraging strong technical skills in ETL, data warehousing, and a passion for writing complex SQL queries. I am open to opportunities across various industries and am committed to driving informed business decision-making through data analysis. With a track record of successful project completion and two certifications in data analytics, I am eager to contribute to the growth and success of an organization across any industry or sector, helping them achieve their business objectives through valuable insights and informed decision-making.
Data Engineer & ETL Developer
March 2020 - Present
• Designed and executed ETL scripts to extract data from transactional data stores to an ODS, Data Warehouse, or Data Mart.
• Created reports and dashboards using SSRS and Power BI visualization tools.
• Provided production support and resolved ETL and reporting incidents.
• Ensured optimal performance and quality in ETL packages, stored procedures, and SQL.
• Documented solution architecture, data, design, ETL technical specifications, and production support artifacts.
• Designed and developed interactive SSRS dashboards utilizing matrixes, drill-through reports, charts, graphs, and gauges.
• Utilized data analysis tools and techniques to generate actionable insights and design informative SSRS dashboards.
• Identified Key Performance Indicators (KPIs), analyzed past trends, and uncovered data patterns for informed business decision-making.
• Prepared visually appealing and interactive dashboards in SSRS, incorporating measures, parameters, calculated columns, and data transformations.
• Utilized SSIS for data cleaning, transformation, validation, and integration to ensure data quality and consistency.
• Leveraged SSIS for file processing, ETL operations, error handling, and data warehousing, ensuring efficient and reliable data movement.
• Scheduled regular data loading tasks using SSIS and SQL Server Agent, automating the process and ensuring timely availability of updated data.
• Optimized T-SQL queries, including stored procedures, user-defined functions, and joins, to enhance data loading performance and efficiency.