AMBREESH P Mobile: +91-799*******

E-mail: ac9xn9@r.postjobfree.com

Professional Summary:

Having 3 years of Professional Software development experience in the areas of Microsoft Business Intelligence (MSBI) and Having Knowledge in Data Warehousing (DW) applications primarily using Microsoft SQL Server 2008R2/2012 stack/powerBI.

Expertise SQL in joins, views, indexes, sub Queries, constraints and T_SQL in procedures, functions .

Hands on experience in Extract, Transform &Load (ETL) development using SQL Server Integration Services (SSIS).

Hands on experience in SQL Server Reporting Services (SSRS).

Proficiency at data transformations like Lookup, conditional split, sort, data conversion, multicast, derived column, union all, merge join, merge and scd to load data into sql server destination.

Hands on experience in Scheduling and deploying reports on report manger.

Generating drill-through reports, drill-down reports, parameterized reports, and sub-reports in SSRS.

Through Knowledge on Data Warehouse concepts like Star Schema, Snow Flake, Dimension and Fact Tables.

Having Knowledge in Dimensional Data Modeling, Cube development and Manipulation in SQL Server Analysis Server (SSAS).

Experience:

Working as Software Engineer for IBM, Bangalore from March2017 to Till date.

Worked as Associate Software Engineer for BIRLA SOFT, Bangalore from SEP 2015 to FEB 2017.

Education:

I have completed Master Of Computer Application from JNTUA UNIVERSITY, Anantapur.

Skill Set:

Microsoft Business Intelligence:

Databases : SQL Server 2008R2/2012.

ETL Tools : SQLServer 2008R2/2012 Integration Services.

Reporting Tools : SQLServer 2012Reporting Services,Power BI

OLAP Tools : SQLServer 2008R2/2012Analysis Services.

Operating Systems : Windows Family.

Project Experience:

Project #1 : Exide Life Insurances.

Client : Exide Life Insurances.

Period : March 2017 to Till Date

Role : MSBI Developer.

Environment : SQL Server 2008R2 Integration Services, SQL

Server 2008R2 Reporting Services

Description:

Exide Life Insurances is a retail business company of consumer goods spread over INDIA. MyWorkways is currently available for CB channel in the form of Portal & Mobile App through My Connect. RHYTHM is being implemented for CB channel, for which few enhancements are required for both the portal & Mobile App platforms of MyWorkways. Reports have been generated using SQL Server 2012 Reporting Services and scheduled.

Responsibilities:

Understanding the Business and its Requirements.

Developing Store Procedures according to the client Business Documents.

Creating shared Datasource Form the database, to access the database multiple times in the BIDS.

Creating Table, matrix, drill- down and drill – through reports and Charts using SSRS.

After preparing RDL preparing steps to deploy the RDL from front Application (My Connect).

Involving in deploying Reports.

Project #2 : Business Process Management for Nexant

Client : Nexant Inc, United States of America.

Period : Mar 2016 to Feb 2017

Role : MSBI Developer.

Environment : SQL Server 2012 Integration Services, SQL

Server 2012 Reporting Services.

Description:

Nexant is a retail business company of consumer goods spread over United States of America (U.S.A). The Data warehouse has many applications and it has a high volume of transactions and data. Data warehouse has many functional and technical groups and ETL is one among them performing the development activities for Data warehouse.

Retail project is to provide a single source of reporting for managing store/retail operations using data warehousing ETL SQL Server 2012 Integration Services. This will provide a mechanism to allow a uniform approach to manage all the retail operations.

Responsibilities:

Understanding the Business and its Requirements.

Involved in the ETL phase of the project.

Getting data from different data sources.

Creating, manipulating & deploying the packages.

Participated in Unit Testing and Reviews.

Using different transformations like excel source, data conversions, lookup, derived columns, OLEDB destination, etc.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

Designed and developed the reports according to the requirements using Tableau and Power Map.

Loading these data into data warehouse like sql server.By using these data warehouse, based on client requirement we generate the multi value reports in SSRS.

Identifying of performance bottlenecks, Performance tuning of packages.

Project #3 : Sangam Darily ERP

Client : Sangam Darily.

Period : SEP 2015 to FEB 2016

Role : MSBI Developer.

Environment: SQL Server 2008R2.

Description:

Dairy ERP on Web for Dairy Procurement and Distribution comprised of industry

Leading functionalities for Enterprise Resource Planning (ERP). Milk Procurement is a complex Process that needs to be executed swiftly on a continuous basis .Dairy ERP helps Dairies to organize the procurement process.

Dairy ERP provides a sophisticated solution to distribute milk and milk products to retail outlets and also to end –customers.

Responsibilities:

Understanding the Business and its Requirements.

Involved in designing, developing and unit testing of the project to accommodate business log. .

Creating Schema, Views, Stored Procedures, Functions and Tables required for project.

Creating SSIS packages for implementing ETL by using various control flow items execute SQL and data flow transformations conditional split, multicast, derived columns,lookup, sort, union all etc..

Implemented package configuration in packages for better reusability.

Worked on Deployment & scheduling of SSIS packages.

Created datasets using stored procedures and reports using multi value parameters.

Contact this candidate