Avinash Sain

About Avinash Sain

Data Engineer with 3+ years of experience in building and optimizing scalable ETL pipelines and data warehousing solutions using SSIS, SQL Server, and SSRS. Proven expertise in SQL performance tuning, achieving 35–40% query improvements and reducing pipeline execution time by 30%. Experienced in dimensional modeling and SCD implementation to improve historical data accuracy by 20%. Delivered reliable client-facing reports and analytical data feeds, improving reporting usability by 25% and ETL reliability to 99.9%.

Experience

1. Software Engineer

   EVERSANA

   Dec 2024 — Present · Pune, IN

   Owned and enhanced SSIS ETL pipelines supporting batch and near real-time analytical data feeds, improving end-to-enddata availability by 30%.• Developed parameterized ETL solutions, increasing package reusability and reducing development effort by 25%.• Optimized complex SQL transformations using indexes, window functions, and CTEs, achieving 35–40% query performance improvement.• Led ETL and database performance tuning initiatives, reducing overall pipeline execution time by 30%.• Designed dimensional models aligned with OLAP reporting, implementing SCD to improve historical data accuracy by20%.• Developed and delivered SSRS reports and client-facing analytical data feeds, enabling faster insight generation andimproving reporting usability by 25%.• Implemented robust error handling, logging, and monitoring frameworks, increasing ETL reliability to 99.9%.• Acted as primary production support owner, performing root cause analysis and reducing repeat incidents by 20%.

Education

• National Institute of Technology , Patna

  Master of Computer Applications - MCA, Computer and Information Sciences and Support Services

  2021 — 2023

• University of Rajasthan

  Bachelor of Science - BSc, Mathematics

  2017 — 2020