Data Analyst
Mercer India Pvt ltd
Skills
SSIS, SSRS, SSAS 2012/2008, SQL server, RDBMS, Tables, User Defined Data Types, Indexes, Web Interface, Data Warehousing Concepts, MS-SQL Server 2005/2008/2008 R2/2012/2016, ETL tool, SQL Server Reporting Service, PowerBi, Tableau Integration Services (SSIS), Parveji, data Integrator, AZURE Data factory, Win XP/2000/2003/2008 Server/Win 7, MSBI, Analytics, ETL, SSIS package, Power BI, Excel, Flat file, Servers, FTPs, Azure, SQL server 2012, SSAS, SAP CRM, SQL, SQL Server 2008/2012, CSV, FTP, Multicast, Data Conversion, Parameterized, SQL Server Agent, MS Access, T-SQL, MS TFS, SQL server 2008 R2, Stored Procedures, T-SQL code
SSIS,SSRS,SSAS,PowerBi,Azure data Factory,ADLS,ADLA
SSIS,SSRS,SSAS,PowerBi,Azure data Factory,ADLS,ADLA
Project history
10/2019
-
10/2019
11/2014
-
02/2018
Sr.MSBI Developer
Times of India
2. Project RSVP
* This Project contains more than 50 reports and Dashboard, KPI's. For the
requirement we used SQL server 2012 with SSRS, SSIS, and SSAS.
Extract data from multiple sources like (SAP CRM), Excel, SQL, txt also.
I have created multiple dashboards for forecast revenue, sales Pipeline, Top 10
customer, leads, opportunity according to future ads and their value etc. where we can
track customer records.
3. Project :SCM Dashboards
* This project Contains 9 KPIS and 20 Dashboards this is supply chain management project
which defines cost of newsprint, Consumption and material cost.
4. Project: * Sunrise.
* This project contains Multiple Dashboards, KPIS, at what time customer get the
newspaper, vehicles of newspaper reach on time to depot and circulation of newspaper by
city area etc.
Responsibilities:-
* Designed and develop SSIS packages to Extract transform and load data from various data
sources into SQL server.
* Extracted data from various sources like HTML data links, SAP, SQL Server 2008/2012, CSV,
Excel and Text file from Client servers and through FTP.
* Involved in Technical decisions for Business requirement, Interaction with Business Analysts,
Client team, Development team, Capacity planning.
* Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out
topology.
* The packages created included a variety of transformations, for example Slowly Changing
Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and
Data Conversion.
* Created reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports,
Drill down, Drill Through reports as well as interactive reports according to business
requirements in time restricted environment.
* Environment: SQL Server 2012, SSRS, SSIS, SSAS, Import/Export tools, SQL Server Agent , MS
Access, T-SQL, MS TFS.
* This Project contains more than 50 reports and Dashboard, KPI's. For the
requirement we used SQL server 2012 with SSRS, SSIS, and SSAS.
Extract data from multiple sources like (SAP CRM), Excel, SQL, txt also.
I have created multiple dashboards for forecast revenue, sales Pipeline, Top 10
customer, leads, opportunity according to future ads and their value etc. where we can
track customer records.
3. Project :SCM Dashboards
* This project Contains 9 KPIS and 20 Dashboards this is supply chain management project
which defines cost of newsprint, Consumption and material cost.
4. Project: * Sunrise.
* This project contains Multiple Dashboards, KPIS, at what time customer get the
newspaper, vehicles of newspaper reach on time to depot and circulation of newspaper by
city area etc.
Responsibilities:-
* Designed and develop SSIS packages to Extract transform and load data from various data
sources into SQL server.
* Extracted data from various sources like HTML data links, SAP, SQL Server 2008/2012, CSV,
Excel and Text file from Client servers and through FTP.
* Involved in Technical decisions for Business requirement, Interaction with Business Analysts,
Client team, Development team, Capacity planning.
* Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out
topology.
* The packages created included a variety of transformations, for example Slowly Changing
Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and
Data Conversion.
* Created reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports,
Drill down, Drill Through reports as well as interactive reports according to business
requirements in time restricted environment.
* Environment: SQL Server 2012, SSRS, SSIS, SSAS, Import/Export tools, SQL Server Agent , MS
Access, T-SQL, MS TFS.
06/2012
-
11/2014
Senior MSBI Developer
iYogi Technical Services Pvt. Ltd.
* BI Reports (Project):
* This Project contains more than 500 reports and Dashboard, KPI's. For the requirement
we used SQL server 2008 R2 with SSRS, SSIS, and SSAS.
* The module has a base of 250 reports to track the information for Accounting, Finance,
Human Resources, Marketing, and MIS.
Responsibilities:-
Designed and develop SSIS packages to Extract transform and load data from various data sources into
SQL server.
* Creating SSRS Reports Graphs like Column, Pie, Line, Shape, Bar, Area etc. using SQL.
* Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL
code and SQL joins for applications.
Environment: SQL Server 2012, SSRS, SSIS, SSAS, Import/Export tools, SQL Server Agent , MS Access,
T-SQL, MS TFS.
* This Project contains more than 500 reports and Dashboard, KPI's. For the requirement
we used SQL server 2008 R2 with SSRS, SSIS, and SSAS.
* The module has a base of 250 reports to track the information for Accounting, Finance,
Human Resources, Marketing, and MIS.
Responsibilities:-
Designed and develop SSIS packages to Extract transform and load data from various data sources into
SQL server.
* Creating SSRS Reports Graphs like Column, Pie, Line, Shape, Bar, Area etc. using SQL.
* Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL
code and SQL joins for applications.
Environment: SQL Server 2012, SSRS, SSIS, SSAS, Import/Export tools, SQL Server Agent , MS Access,
T-SQL, MS TFS.
Local Availability
Open to travel worldwide
Yes able to travel as I am working we can travel only regarding Buisness Requirement.after that will work remotly .
If i get fulltime opportunity then we can relocate as well if its long time.
If i get fulltime opportunity then we can relocate as well if its long time.
Other
MCA having 8+ years of Total IT experience. PROFESSIONAL SUMMARY
- Having 6+ years of experience as Microsoft Business Intelligence (MSBI) Developer with SQL SSIS, SSRS, SSAS 2012/2008 R2/2005 in Production, Development and Staging Environments
- 1.5 + year of exp in ADF, ADLA,ADLS,AD Authentication ,Storage etc.
- Knowledge of Data Warehousing Concepts like Star Schema and Snow-Flake Modelling.
- Have worked on SCD types – Type 1, Type 2.
- Designed and develop SSIS packages to Extract transform and load data from various data sources into SQL server.
- Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures.
- Expertise in Performance tuning, Optimization, Data integrity and Performance Monitoring and Execution Plans (Estimated and Actual Plans).
- Created reports through Power BI with different sources.
- Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
- Knowledge on Data Warehousing Concepts, and creation of cubes (SSAS)
- Experience in developing parameterized, Multi-valued parameters, Charts, Filters, Sub Reports, Drill down and Drill Through reports using SSRS.
- Experience in writing expressions in SSRS and Expert in fine tuning the reports.
- Monitoring of SQL Agents jobs and ETL schedule.
- Project Documentation, Project brief, end stage reports, highlight reports and business cases.
- Done Poc in Azure Data Factory for Data Lake Ingestion
