
Sugunakar Reddy
SSIS/SQL/SSRS Developer
Hire this person
Send a job offer directly to this candidate
About
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.
Experience
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
Education
Bachelor of Engineering in B.E. – Ramaiah University of Applied Sciences, Bangalore (2021)
