Sugunakar Reddy

MSBI Developer with 4+ years of experience in designing and developing ETL pipelines using SSIS and SQL Server. Strong expertise in Data Warehouse concepts, T-SQL, and SSRS reporting solutions. Experienced in handling large datasets, optimizing queries, and improving performance. Currently learning Azure Data Factory to transition into modern data engineering roles.

Experience in building end-to-end ETL pipelines and supporting data warehouse solutions for business reporting.

MSBI Developer at Sparkviz Technologies (2023-09 – Present)

Project: LVFS (Liverpool Victoria Financial Services, UK). Developed SSIS ETL pipelines and SSRS reporting solutions for data warehouse environment.

• Developed SSIS ETL pipelines processing 2M+ records daily, reducing data load time by 30%
• Optimized T-SQL queries and stored procedures, improving performance by 25%
• Designed and deployed 15+ SSIS packages for data integration workflows
• Automated ETL workflows using SQL Server Agent, reducing manual effort by 90%
• Developed 20+ SSRS reports including drill-down and parameterized reports for business users
• Handled data integration from SQL Server, Excel, and CSV files
• Improved report performance by 20% through query tuning and indexing
• Worked in Agile environment using Jira
• Collaborated with business stakeholders to gather requirements and deliver data solutions supporting reporting needs

Software Engineer at Hexaware Technologies (2022-06 – 2023-08)

Project: Sales Tracking (CMIS – ConAgra Foods, USA). Designed and developed ETL pipelines for data warehouse environment.

• Designed and developed 10+ SSIS ETL packages using transformations like Lookup, Derived Column, and Conditional Split
• Built ETL pipelines processing ~1-2M records daily from SQL Server, CSV, and Excel sources
• Loaded data into data warehouse (fact and dimension tables) for reporting and analytics
• Automated ETL workflows using SQL Server Agent, reducing manual effort by 90%
• Improved data load performance by 25% through query optimization and efficient package design
• Worked in Agile environment using Jira and maintained code using Git/GitHub

Bachelor of Engineering in B.E. – Ramaiah University of Applied Sciences, Bangalore (2021)