Sonu Kumar

• Integrated legacy claims data (POINT7, POINT8, UNITY, etc.) into the Snapsheet platform and built extract pipelines to support legacy-based reporting.
• Developed various SSIS packages to meet diverse business requirements.
• Implemented multi-level data validations to ensure data quality and integrity.
• Utilized a wide range of SSIS components, including tasks (Data Flow, Execute SQL, Script Task, Send Mail, Expression Task), transformations (Lookup, Conditional Split, Multicast, Union All, Merge Join, Aggregate, Sort), and enumerators (ADO Enumerator, ADO.NET Schema Row Set Enumerator, File Enumerator).
• Implemented SQL Server temporal tables to capture the history of Snapsheet claims, as the platform does not store historical data by default.
• Created stored procedures and functions in SQL Server to support ETL and business logic requirements.
• Deployed and automated SSIS packages for seamless production operations.
• Conducted daily checks in the production environment to ensure smooth data pipeline execution.
• Performed issue debugging, defect fixing, end-to-end unit testing, and maintained comprehensive technical documentation.
• Designed and deployed SSRS reports aligned with business reporting needs.
• Collaborated closely with business stakeholders to understand requirements and translate them into scalable technical solutions.
• Actively involved in Production Release (PR) activities, including release planning, deployment coordination, validation, and post-release support to ensure smooth delivery and minimal downtime.
• Mentored junior developers, fostering professional growth and enhancing team productivity.

BTM: In this project I have fetched data from Genesys Server into data warehouse using ETL, Genesys was handling all the ERP application for our client (BCD travel) and our company (Shree Partners) was handling all the ETL and reporting related stuff.

• Used SSIS as ETL tool to create various types of SSIS package to meet the business requirements.
• Package deployment and automation of package.
• Creating Different kinds of SSRS reports Like (Drill Down, Drill through, and Tabular and Matrix report) to meet the business requirements.
• Creating Different kinds of Power Bi reports using various visuals (Column Chart, Bar Chart, Pi Chart, table and Matrix)
• Used various sources to pull data into Power BI and SSRS such as SQL Server, excel, analysis services.
• Used various Dax formulas for calculated columns and measures
• Debugging of Issues, Defect-fixing, End to end Unit Testing and technical Documentation
• Extensively used SQL Queries to verify and validate the Database Updates.
• Writing complex queries using joins and sub queries involving multiple tables.
• Created stored procedures and functions in SQL Server to support ETL and business logic requirements
• Assisted in the migration of legacy reports to newer platforms, ensuring minimal disruption during the transition period.

SAHI PAY: SAHIPAY is a Digital Platform that allows the large Industry Service Providers to serve their end customers most efficiently by enabling entities involved in accepting payments like retail merchants, professionals, schools etc. to accept payments through multiple digital channels. It also provides a mechanism of achieving increased revenue numbers for these entities through customized Value-Added Services.

• Created appropriate stored procedure and functions to meet the business requirements.
• Created different kind of SSIS packages to meet the business requirements.
• Used various task, transformation, and enumerators in SSIS.
• Used various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
• Deployed SSIS package and used environment variables to run the SSIS package on different environments.
• Created different kinds of SSRS report (Drill Down, Drill Through, Linked report).
• Created subscription.
• Created Views, complex Stored Procedures, effective functions to assist efficient data manipulation and data consistency.
• Writing complex queries using joins and sub queries involving multiple tables.
• Creating database objects like procedures, function and views.
• Creating Jobs and schedule that Job to run the SSIS package automatically.
• Involved in daily meetings to identify issues and assign work.

Project PIIMS: PIIMS is a patient information management system to manage administrative tasks and store patient records. It aims at improving your practice efficiency, delivering timely care, and improving patient experience and outcomes.

• Created different kinds of SSRS report (Drill Down, Drill Through, Linked report).
• Deployed SSRS report and created and managed subscription of reports.
• Debugging SSIS package in case of failure.
• Created SSIS package to meet the business requirements.
• Provided manual report in excel to the billing team.
• Validate reports in case of data mismatch.
• Writing complex queries using joins and sub queries involving multiple tables.
• Daily production environment check.