OnBenchMark Logo

Sonu

Senior MSBI Developer
placeholder
Location Delhi
view-icon
Total Views56
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 6 Year
  • Cost
    Hourly Rate$15
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnApril 17, 2024
Key Skills
SQLSSISSSRSPower BI
Education
2013-2017

(Computer Science)
GGSIPU

Summary

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.



Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon