Sonu

Project Details

Unity Enhancements:This project is mainly built for analysis and reporting purpose in which we are moving policy data which are coming from duck reek application into data warehouse, after that we are creating various kinds of report for analysis purpose. We need to cater with every part for the project as per requirement.

Duration July 2021– Till Date Role Senior Software Engineer.

Project Type ETL and ReportingDevelopment Technology SSIS, SSAS,SSRS, SQL Server

My Responsibilities Creating Different kinds of SSIS package to meet the business requirements.

Used various sources like (SharePoint, JSON API, Flat File and Excel) to fetch the data.

Used various task (Data flow, Execute SQL, Script Task, Send Mail, Expression Task), transformation (Lookup, Conditional Split, Multicast, Union All, Merge Join, Aggregate and Sort), and enumerators (ADO Enumerator, ADO.NET Schema Row Set Enumerator, File Enumerator) in SSIS.

Used third party tool (Kingsway soft SSIS integration toolkit and Zappy SYS) to connect to various sources which are not available in SSIS.

Package deployment and automation of package.

Daily production environment Check.

Debugging of Issues, Defect-fixing, End to end Unit Testing and technical Documentation.

Extensively used SQL Queries to verify and validate the Database Updates.

Creating Database objects like Stored Procedures, Functions and Views.

Writing complex queries using joins and sub queries involving multiple tables.

Involved in the table partitioning of SQL Server Database.

Creating tabular model in analysis service and deployment of model.

Creating KPI, Measure, Hierarchies and Perspectives in SSAS Tabular model.

Creating partition of table in SSAS tabular model for faster processing.

Creating SSRS new subscriptions if requirementscome.

Keepingeye on failed SSRS subscriptions.

Involved in daily meetings to identify issues and assign work.

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 reporting related stuff.

Duration Sep 2019– May 2021 Role Report and ETL Development.

Project Type ETL and ReportingDevelopment Technology SSIS, SSRS, Power BI, SQL Server

My Responsibilities 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.

Worked on various types of transformations (Split Column, Replace Values, Pivot, Format and Extract) that are available in Power bi query editor.

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.

Involved in daily meetings to identify issues and assign work.

Project Details

Unity Enhancements:This project is mainly built for analysis and reporting purpose in which we are moving policy data which are coming from duck reek application into data warehouse, after that we are creating various kinds of report for analysis purpose. We need to cater with every part for the project as per requirement.

Duration July 2021– Till Date Role Senior Software Engineer.

Project Type ETL and ReportingDevelopment Technology SSIS, SSAS,SSRS, SQL Server

My Responsibilities Creating Different kinds of SSIS package to meet the business requirements.

Used various sources like (SharePoint, JSON API, Flat File and Excel) to fetch the data.

Used various task (Data flow, Execute SQL, Script Task, Send Mail, Expression Task), transformation (Lookup, Conditional Split, Multicast, Union All, Merge Join, Aggregate and Sort), and enumerators (ADO Enumerator, ADO.NET Schema Row Set Enumerator, File Enumerator) in SSIS.

Used third party tool (Kingsway soft SSIS integration toolkit and Zappy SYS) to connect to various sources which are not available in SSIS.

Package deployment and automation of package.

Daily production environment Check.

Debugging of Issues, Defect-fixing, End to end Unit Testing and technical Documentation.

Extensively used SQL Queries to verify and validate the Database Updates.

Creating Database objects like Stored Procedures, Functions and Views.

Writing complex queries using joins and sub queries involving multiple tables.

Involved in the table partitioning of SQL Server Database.

Creating tabular model in analysis service and deployment of model.

Creating KPI, Measure, Hierarchies and Perspectives in SSAS Tabular model.

Creating partition of table in SSAS tabular model for faster processing.

Creating SSRS new subscriptions if requirementscome.

Keepingeye on failed SSRS subscriptions.

Involved in daily meetings to identify issues and assign work.

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 reporting related stuff.

Duration Sep 2019– May 2021 Role Report and ETL Development.

Project Type ETL and ReportingDevelopment Technology SSIS, SSRS, Power BI, SQL Server

My Responsibilities 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.

Worked on various types of transformations (Split Column, Replace Values, Pivot, Format and Extract) that are available in Power bi query editor.

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.

Involved in daily meetings to identify issues and assign work.