Contact: - 955-***-****

Email:- ac6zh3@r.postjobfree.com

Ankit Ostwal

(ETL - Ab Initio Developer)

Ab Initio Developer with 3.4 years of experience, specializing in ETL – Ab Initio Tool, Data Warehousing, Data Analysis, ETL Design, development and maintenance using Ab Initio.

Objective is to promote myself accomplished professional, by integrating all my talents and expose them for the development of the organization.

Ab Initio Developer (Apr‘15- till date)

Organization Name- Accenture Solutions Pvt Ltd.

Client- TRAVELERS – American Insurance Company (April 2015 – till date)

The Travelers is an American Insurance Company. It is the second largest writer of U.S. commercial property casualty insurance and the third largest writer of U.S. personal insurance through independent agents.

Projects Experience

Project 1 : Pipeline & Strategic Profitability 3(From Apr’15 to Dec'18)

Description :

It maintains the Data Warehouse of Business Insurance giant of USA. Here we do extraction from the source i.e. Mainframe files or XML data and then do the transformations according to the business requirements given to us by the BSA and generated Surrogated IDs on the basis of new or old data. Then we do the Change data Capture between new and old data and keep the latest data as open records and close the previous records with the timestamp of latest records by implementing SCD type 2 and after that load these data into corresponding teradata tables for the business user who could create mart on this data and use these marts for their business decision making.

Project 2 : Revdb Earnings and Balancing(From Jan'18 till date)

Description :

In Earnings process we extract one of the warehouse tables,data which has as an

activity in between a certain time period,perform transformations and create a summarised

data which gives the business a better picture of the earnings at a summarised level.

In Strategic Profitability we use premium warehouse and loss warehouse as the source,combine

these two,perform transformations and based on certain factor values we calculate around 300

measures(columns),which defines the profit for a particular policy.We maintain 20 snapshots in

the target table.

Role :

Ab Initio Developer

Responsibilities :

Have been leading a module of 4 people.

Designed, developed, tested and implemented Ab Initio ETL graphs.

Developing graphs using Ab Initio according to High Level Design. Troubleshoot security/authorization related problems.

Worked with QA, UAT and SIT teams to resolve incidents during object testing phase.

Change requirement driven development.

Introduced parallel processing in the existing Ab Initio mapping to improve performance and save runtime.

Used parameterization of components in the ETL code to encourage code reusability and accept user inputs dynamically.

Extensively used reformat, rollup and scan, filter by expression and partitioning components to develop the graphs.

Operating Systems: Windows, Unix

Data Warehousing Tools : Ab Initio 3.2.4

RDBMS : Teradata, MySQL

Software Development Methodologies : Agile Methodology

Adapt to any kind of environment.

Good Interpersonal skills, effective communication, and excellent team player.

Certified Hadoop and Big data training from Edureka.

Have won performance achievement award in 2 quarters.

Appreciation from Client in the walkthroughs.

oCompleted Bachelor of Engineering (E&TC) from Sinhgad College of Engg,Pune in 2014 with 65.66%

Gender : Male

Date of Birth : 07-04-1992

Nationality : Indian

Languages Known : Hindi and English

Email : ac6zh3@r.postjobfree.com

I hereby declare that the information that I have furnished is authentic, and true to the best of my knowledge.

Ankit Ostwal

PROFESSIONAL EXPERIENCE

OTHER TECHNICAL AND PERSONAL SKILLS

ACHIEVEMENTS

EDUCATION

PERSONAL DETAILS

Contact this candidate