Piyush Tiwari Mobile: +1-860-***-**** E-mail: acqese@r.postjobfree.com

PROFESSIONAL SYNOPSIS

Currently Working with Syntel Inc as Analyst Programmer/ETL Designer for an Insurance client with overall experience of 5 years and 5 moths in design of ETL Flow and creating accelerators that would enhance the RAD model .

Earlier worked as a Senior Software Engineer with Accenture India for where I was responsible for multiple modules of the same client.

I have previously worked for a Insurance client using ETL tools (Ab-Initio) and database. Presently, I am working as an ETL developer in the current project. Technically, I am proficient in different ETL approaches and have handled complex assignments in all my projects.

Skill Set

SDLC Phases – Requirements Gathering, Analysis and Design, Build, Testing-QA, UAT, Production Release

SDLC Model – Waterfall Model, Agile Model, Iterative Model

Technology – ABINITIO (BI ETL Tool), Oracle, UNIX- Shell Scripting, Teradata, Erwin, HTML5

ETL Solution Implementation –Integrated Dimensional Model, Metrics Processing Engine, Operational Data Store, DW Data Marts, XML Processing

Domain Experience – Insurance (Current) .

Design Experience – E-R Design (Subject Area), Dimension and Fact Modelling using Ralph Kimball methodology

People Management – Managed Large Team with Diverse Backgrounds, Mentoring Junior Developers, Task Allocation and Distribution, Global Delivery Model

Clients Engagement – Track Progress, Status Reports, Business Lunches, Customer Health Checks

Career Contour

Syntel Inc Software Engineer

Project: Policy MDM Duration: Nov 2014 till End

Domain:-Personal Line Insurance

Project Description:

A key initiative of the Enterprise Data Strategy is the implementation of a single, consolidated view of policy data from across Policy Administration systems - The Policy MDM (Master Data Management).

The scope of this is ALL policy data across the enterprise, including all brands, all channels, and all products. The use of an abstraction layer, or format for the output (off ramp) that is common between the current PIM (Policy Information Management) and the future Policy MDM will minimize the changes experienced by consuming systems when the transform to Policy MDM is done.

Below process is followed -

a.Load the AC-XML provided into Policy MDM (PIM and the DataHub)

b.Extract data from the Encompass system and form an AC-XML and load it into the Policy MDM

c.Extract data from the PIM and provide an AC-JSON file to the ARMS system (HDFS Data Nodes).

d.Create Hive table and queries for Unit testing

Technologies Used: Abinitio, UNIX,SQL 11g,Hadoop,Hive,Tivoli

Responsibilities:

Lead a team

Grooming Fresher’s & Mentoring Newcomers.

Deep Understanding of the Data flow and data mappings rules and implementations.

Direct Client interaction while understanding business application rules

Design and development for Graphs of Abinitio

Design and development of UNIX scripts Integration design of the different components of the projects.

Accenture Senior Software Engineer

Project: SBIS Prod_ops Duration: Aug 2012 till Oct 2014

Client :-Personal and Commercial Insurance client (Financial Services), Second largest P&C insurance company in the US

Project Description

Prod-ops team was setup to look after more the prod operation of more than 50 applications of sbis .the responsibility of the team was to make data delivery on time and any hot fixes to make sure the SLA was not breached create operational metrics for senior management and provide feedback to application owners on performance improvement scheduling and dependencies of the application

Technologies Used: Abinitio, UNIX,Teradat,Mainframe,Cognos,Sql,Autosys

Responsibilities:

Lead a team

Grooming Fresher’s & Mentoring Newcomers.

Deep Understanding of the Data flow and data mappings rules and implementations.

Direct Client interaction while understanding business application rules

Design and development for Graphs of Abinitio

Design and development of UNIX scripts.

Review the interfaces developed by team

Data delivery on Time (SLA Bounded)

Automation of Manual or Repetitive task

Project: CMI Prod Support Duration: Jan 2011 till Aug 2012

Project Description:

Team was responsible for taking care of enhancement for the CMI application which included prof2,Controllable and other sbis application .

Technologies Used: Abinitio, UNIX,Teradat,Mainframe

Responsibilities:

Lead a team

Grooming Fresher’s & Mentoring Newcomers.

Deep Understanding of the Data flow and data mappings rules and implementations.

Direct Client interaction while understanding business application rules

Design and development for Graphs of Abinitio

Design and development of UNIX scripts.

Review the interfaces developed by team

Project: Technical conversion from Datastage to Abinitio Duration: Dec 2010 to Dec 2011

Project: A leading Insurance Company

Project Description:

Travelers decided to go with the one ETL tool (i.e. - Abinitio) on the enterprise wide. Travelers had many systems using the datastage as ETL tool. This project had to do a technical conversion from datastage as ETL tool to Abinitio.

Technologies Used: Abinitio, UNIX,Teradat,Mainframe

Responsibilities:

Building Complex Ab initio Plans and Graphs.

Creating Unix Scripts BTEQs.

Implementing Source to Target Mappings and performance tuning

Implementation of Change Requests (CR’s) in the mappings and performing regression testing.

Doing Code Review and Code optimization.

Migration of code from development server to test and then to Production

Professional Trainings

Trained in Database Technology and Data warehousing

Trained in ETL tool Abinitio

Domain training on Insurance

Internal certified in Abinitio.

Extra-Curricular

Table Tennis Tennis Reading

Education

Degree

Board

Institution

Percentage/

CGPA

B.E. (Information Technology)

U.P.T.U

Kanpur Institute of Technology

72

12th

I.C.S.E

C.C.A

74

10th

I.C.S.E

C.C.A

76.67

Personal Details

Date of Birth : 06/29/1987.

Marital Status: Single

US Address: 1501 S Wold Road apt 247, Prospect Heights 60070

Declaration:

I hereby declare that the information furnished above is true to the best of my knowledge.

Date 03/24/2015 Piyush Tiwari

Contact this candidate