EDUCATION :

Post-Graduation Diploma

Centre For Development Of Advanced Computing(CDAC) – Bengaluru Aug’13-Feb’14

System Software Development

Graduation

Ramrao Adik Institute of Technology (RAIT) – Mumbai Jun’09-July’13

Electronics and telecommunication

Experience:

Syntel Ltd. PUNE - March’14-Till date

Software Developer

2.5 Years of experience in Data Warehouse implementation using ETL tool Informatica Power Center and Informatica MDM as ETL Developer.

Experience as a Data Warehouse Consultant in Enterprise Data Warehouse Development and Maintenance, Data Analysis and Loading of huge data.

Extensively used ETL methodology for supporting Data Extraction, Transformation and Loading processing in a corporate-wide ETL Solution using Informatica.

Worked with Relational Sources and Flat file as source systems for ETL process.

Extensively worked on Informatica Power Center Designer components like Source Analyzer, Target Designer, Transformation Developer and Mapping Designer.

Experienced in developing Mappings, Sessions, Tasks, Mapplets and Workflows.

Experience in Development of Mappings using needed Transformations using Informatica Power Center.

Worked with Import/Export.

Strong understanding of Data Warehouse project development life cycle. Expertise in documenting all phases of DWH projects.

Good knowledge in performance tuning in Informatica mapping level, session level and database level.

Roles and Responsibilities:

Involved in the ETL design & its documentation.

Extracted source data from flat files, Sql Server and XML file sources.

Created mappings to build business rules to load data using transformations.

Developed mappings in Informatica Power Center Designer to load the data from flat file to staging environment and from staging environment to warehouse.

Designed & developed the data transformations for source system data extraction; data staging, movement and aggregation, performance tuning.

Extensively worked on mapping variables, mapping parameters and session parameters.

Developed several reusable transformations and mapplets that were used in their mappings.

Involved in creating sessions and workflows using workflow manager.

Performance tuning by optimizing the sources and targets mapping and sessions.

Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.

Testing the ETL objects in all kinds of aspects and fixing the issues if exists.

Prepared the migration documents from DEV to DEMO and DEMO to PROD.

Project Experience:

Project No. : 1

Project Name: Digital service 2

Client Name: U.S Client

Project Description:

Today, Policy owner primarily update their address/phone number by calling service center. This project will enable the ability to allow policy owner to update their information online, reducing calls to service center. In addition, we are complying with requirements for ACH authorization. Implementing e-consent will allow future e-delivery capabilities to policy owner.

Project No. : 2

Project Name: MCLS

Client Name: U.S Client

Project Description:

This MCLS Project has divided into two part operational support and Google Analytics. so the MCLS has two releases as follow :

MCLS web release -1(Operational Support):

In this release we are populating data into ODS Application and Application Thin table from Ebix source tab delaminated flat file via stage table.

MCLS web release -2(Google Analytics - Changes):

This release is an extension of Google analytics project which was completed earlier.

We have already implemented the process for pulling the data from Google Analytics for 4 views.

We need to pull additional 2 views data for web release 2

MCLS web release -3(Signed name - Changes):

In this release we are populating data into ODS Application and Application Thin table from Ebix source tab delaminated flat file with logic implemented for the Signed date and Signed name field .

Project No. : 3

Project Name: Service Dashboard

Client Name: U.S Client

Project Description:

The purpose of the project is to provide greater transparency into the volume and reason for services calls taken, as well as, the effectiveness of sales leads resulting in referrals using enhanced, meaningful analytics based on data housed in the Customer Operations Data Warehouse (CODW).

Project No. : 4

Project Name: Consumer Analytics

Client Name: U.S Client

Project Description:

This project was mix of ETL and reporting works. First phase of the project involved building various ETL mappings in Informatica to populate the ""ODS"" into data warehouse and the second phase involved generation of business reports from the warehouse. In ETL part Informatica mappings were created and scheduled to load data from flat files to stage and from stage to ODS database and then from ODS to Data warehouse. DataMart Mapping were also created for the generation of Business reports.

Contact this candidate