Developer Data
Resume:
CAREER OBJECTIVE
Seeking a challenging and rewarding career in DATABASE and BI (SSIS, SSAS, SSRS) professional, where I can contribute my knowledge and skills for growth and development of the Organization and to be able to implement solutions that meet the customer requirements using my variety of development skills and technical expertise.
PROFESSIONAL PROFILE
1. Currently Working as a Lead Consultant for Genpact Headstrong, Noida from 15th Oct 2018 to till now.
2. Worked as a Sr. BI Consultant for AWC Software (Genpact Client), Noida from 27th June 2018 to 10th Oct 2018.
3. Worked as a Sr. MSBI Developer for HCL Technologies, Noida from 12th May 2016 to 1st June 2018.
4. Worked as Sr. MSBI Developer for D2K Technologies, Navi Mumbai from 30th Nov 2013 to 9th May 2016.
5. Worked as SQL Server Developer for DARCL LOGISTICS LTD., Hisar from 2nd April 2012 to 28th Nov 2013.
6. Having Working Knowledge in Banking, Finance and Transport Domain.
SQL Server 2008, 2012
Having knowledge of SQL SERVER & MSBI (SSIS, SSAS AND SSRS) & POWER BI.
knowledge and experience in:
SQL Server Programming Concepts.
Designing and Deploying Reports (SSRS).
Designing Packages (SSIS).
Having knowledge in creating SSIS Packages by using different data Transformations and tasks load data from different data sources into application database, database objects and logins in SQL Server Integration Services.
Having Knowledge of Data Warehousing and implementation knowledge of SCD2 concept.
Aware of Working in Cluster Environment.
Working Knowledge of Always ON Functionality of SQL SERVER.
Knowledge about Windows Failover Cluster.
Having Knowledge of SQL Server Performance Tuning.
Hands-on experience with SQL Server installations, maintenance plan, DB backups, High Availability-Clustering, Always ON.
Create and Maintain SSAS CUBE, cube Partitioning, different types of Fact and Dimension table creation, MDX calculations.
Create different types of schema based dimensions, calculated members, named queries, and different types of calculations in MDX.
Create partition of large measure groups based on different types of conditions
Use different types of cube, fact and dimension processing.
Power BI reports development (Desktop and mobile).
Use of tabular model for POWER BI Source.
Use of POWER BI as a self-service tool.
Knowledge of Power BI Services (Publishing, Sharing, Security etc.)
EDUCATION
Bachelor of Technology (Computer Science) from Apex Institute of Technology, with 72.50% in the Year 2011.
Intermediate (12th) from Govt. College, Gadarpur, with 70.80% in the Year 2006.
Higher Secondary (10th) from R.K.S.V.M, Bazpur, with 75 % in the Year 2004.
TECHNICAL SKILLS:
DB proficiency : SQL Server 2008, 2012 with MSBI (SSIS, SSAS AND SSRS).
Web Applications : Power BI and Microsoft Azure (Basic Knowledge).
Oracle : SQL plus, SQL Developer, PUTTY (Basic Knowledge).
Operating Systems : Windows XP, WIN 7, WIN 8
Agile : Working knowledge and experience in Agile Methodology.
PROFESSIONAL EXPERIENCE
A.AT Genpact :
PROJECT: 1: Finance Reporting
Client : Genpact ind.
Position : Sr. Power BI Consultant
Significant Contributions:
Creation of dimension and fact tables to load the master and transactional data into Data warehouse.
Creation of views with Fact data to be used in OLAP cubes.
Cleaning data using different transformations in Power BI Query Editor.
Creation of OLAP cubes (Multidimensional/ Tabular) for the Data warehouse.
Deploy Cubes and Reports to Azure and Power BI Services.
Create Power BI Reports from SSAS CUBE Data.
Use Power BI for Developing Data and Chart based Reports as per user requirement.
Use Power BI reports for Mobile Reports.
Use Excel File data as source for POWER BI Report.
PROJECT: 2: Home Office Dashboard
Client : Morgan Stanley
Position : Lead Consultant (MSBI)
Significant Contributions:
Creation of dimension and fact tables to load the master and transactional data into Data warehouse.
Creation of views with Fact data to be used in OLAP cubes.
Designed and created SSIS packages to load the data into Data Warehouse from OLTP system.
Build and Deployed packages to SQL server and Scheduling Packages for Intra Day and End of Day execution.
Use Power BI for Developing Data and Chart based Reports as per user requirement.
B.AT HCL Technologies:
PROJECT: 1: Finance Reporting
Client : HCL (Hindustan Computers Ltd.)
Position : Sr. MSBI Developer
Significant Contributions:
Creation of dimension and fact tables to load the master and transactional data into Data warehouse.
Creation of views with Fact data to be used in OLAP cubes.
Designed and created SSIS packages to load the data into Data Warehouse from OLTP system.
Cleaning data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast, SQL Command, CDC Splitter transformations etc.
Maintained Event handlers and log information in SQL table to track Errors and recording package execution status.
Build and Deployed packages to SQL server and Scheduling Packages for Intra Day and End of Day execution.
Creation of OLAP cubes for the Data warehouse.
As per requirements developed the reports using basic MDX in the form of Matrix and Table using SQL Server 2012 Reporting Services.
Deploy Cubes and Reports to multiple servers.
Create SSRS Reports.
Use Power BI for Developing Data and Chart based Reports as per user requirement.
Use Power BI reports for Mobile Reports.
Implement RLS Security in POWER BI and Sharing Data with the Users.
Create Apps for the Sharing data with Different types of Users.
Use Excel File data as source for POWER BI Report.
Transform SSRS Reports to Power BI reports.
C.AT D2K Technologies:
PROJECT: 1: MIGRATION
Client : PNB (Punjab National Bank)
Position : Sr. MSBI Developer
Significant Contributions:
Migrate Data from Old system to new system, using SQL Server 2012.
Designing Packages using SSIS based on different types of requirements.
Design and Develop Tables in SQL server as per our product requirements.
Developed SSRS Reports for different Loan Modules of Bank.
Create and Maintain SSAS CUBE, cube Partitioning, different types of Fact and Dimension table creation, MDX calculations.
Create different types of schema based dimensions
Create partition of large measure groups based on different types of conditions
Create calculated members, named queries, and different types of calculations.
Create complex and simple mdx calculations.
PROJECT: 2: LADDER+
Client : PNB (Punjab National Bank)
Position : Sr. MSBI Developer
Significant Contributions:
Extract data from Finacle (oracle) to SQL Server Using SSIS, SQL plus and PUTTY.
Designing Packages using SSIS based on different types of requirements.
Create Database Design Flow from Finacle to SQL, For Maintain Historical Data.
Design and Develop Tables in SQL server as per our product requirements.
Developed SSRS Reports for different Loan Modules of Bank.
Create and Maintain SSAS CUBE for PNB Bank.
Create MDX queries for presenting date in CUBE and SSRS reports as per requirement.
D.AT DARCL Logistics:
PROJECT: 1: VIHAAN-1
Client : Darcl Logistics Ltd.
Position : Database Developer
Significant Contributions:
Developed SSRS Reports for Balance and Profitability (for SD, FI and HR Modules).
Design and Maintain SSAS CUBE for Balance and Profitability and HR.
PROJECT: 2 CDC (INCREMENTAL PROCESSING)
Client : Darcl Logistics Ltd.
Position : Database Developer
Significant Contributions:
Create and Maintain Tables for Incremental Data Processing.
Create and Maintain Database for incremental Data Processing.
Created SSRS Reports.
Developed SSAS CUBE.
PROJECT: 3: BP Cube
Client : Darcl Logistics Ltd.
Position : Database Developer
Significant Contributions:
Design Dimensions as per user requirements.
Create many types of calculations based on MDX Expressions.
Developed Reports for Balance and Profitability (for SD, FI and HR Modules) using CUBE Data.
Design and Maintain SSAS CUBE for Balance and Profitability and HR.
PERSONAL DETAILS:
Father’s Name : Shri. Shyam lal Agrawal
Marital Status : Single.
Date of Birth : 23 Aug 1989
DECLARATION:
I hereby declare that all the information mentioned above is true to the best of my knowledge.
SHUBHAM AGRAWAL
Contact this candidate