Project Data

NIRANJAN

Email: ********.**********@*****.***

Mobile: +91 - 949-***-****

Objective

Having 4 + Years of Experience and Extensive expertise in Abinitio ETL Consultant individuals will be responsible for requirements and analysis designing and ETL Development Phase and Production support in data warehouses.

Professional Summary

Having 4 Plus Years of Experience in ETL development, Testing, Admin and Production Support of Abinitio Data Warehousing projects and their maintenance

Abinitio Testing, Data Validation Testing and Migration.

Data processing knowledge in Designing and Implementing Data Warehouse applications, mainly Transformation processes using ETL tool Abinitio

Experience with various Partition and De partition components such as Partition by key, Partition by Round Robin, Partition by Expression, Gather, Merge, Interleave, Lookup etc

Constructed Ab Initio Graphs using components like Join, Lookups, Reformat, Sort, Rollup, Filter by expression, Dedup Sorted, and Replicate etc.

Familiar with Parallelism techniques available in Ab Initio.

Have a good Knowledge of Data Warehousing Concepts.

Unix Shell commands,produce LLD, work with testers, work with PMO and develop graphs, schedules, 2nd,3rd level Production support

Employment Summary

Working as an ETL Consultant in TCS, Bangalore through INTEL, Bangalore, from Augest’2015 to till date.

Worked as an ETL Consultant in TCS, Bangalore, from September’2011 to July’2015

Technical Experience

Operating Systems : Windows XP, 2000, NT,Unix

Databases : Teradata, SQL, Oracle11g

O/S : Windows 2000/NT,UNIX,shell

ETL Tool : Abinitio, GDE, EME,Co>Opsystem

Scheduling : Autosys, Control M

Summary of Qualifications

B.Tech from J.N.T University

Project Engagement Overview

Project # I

Title : WFDS (Workflow Data Sharing), INTEL

Client : INTEL, Bangalore

Environment : Abinitio, Co>Opsystem UNIX, Autosys, Teradata

Duration : Aug 2015 to Till Date.

Role : ETL Consultant

Responsibilities

Studied the ETL design document users requirements

Development of graphs for the ETL process

Used Lookups with Reformat component to fetch matching records based on for the downstream process.

Used Sort component to sort the tables, and used Dedup Sort to remove duplicate values.

Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check in and checkout were used for this purpose.

Creating sav files, migration and running the jobs.

Performance Tuning of the Abinitio graphs

Project # I

Title : Customer Level View project

Client : ANZ Banking services, Australia

Environment : Abinitio, Co>Opsystem UNIX, Autosys

Duration : Dec 2013 to Till Date.

Role : ETL Consultant

Description:

The ANZ Bank is one of the largest banks in the world. The current project is about their Consumer Finance, which includes providing credit cards and personal loans. In order to the business requirement this project is to cater many to many relationships between an ANZ customer and Account and to identify duplicates in ANZ source customer. To store different types of addresses for a customer and also to store history of address changes for an ANZ customer. They have maintained a data mart by name Customer level view project using AB initio where the data comes from various types of sources like Oracle, MS Excel and flat files. In this project different types of reports are generated for end user support to know about the total sales of the products and about the interest paying details and month end balance details of the customers.

Responsibilities

Studied the ETL design document users requirements

Development of graphs for the ETL process

Used Lookups with Reformat component to fetch matching records based on for the down stream process.

Used Sort component to sort the tables, and used Dedup Sort to remove duplicate values.

Used Rollup component to populate monthly, quarterly and annual summary tables.

Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check in and checkout were used for this purpose.

Worked with de-partition components Gather, Merge which will be used for add the files which is done partition for fast process of data files.

Performance Tuning of the Abinitio graphs

Project # II

Project Name : Mutual Life Insurance.

Client : Northwestern Mutual Life Insurance, US.

Role : ETL Developer

Duration : Nov 2012 to Nov 2013.

Environment : Windows2000 Oracle8i Abinitio GDE Co>op system

Description

Northwestern Mutual Life Insurance Company, the US’s oldest mutual insurance of automobiles. The company is a national writer of automobile, homeowners, marine and personal excess liability insurance. It has 42 offices across the country. The project’s goal was to migrate a legacy system for issuing bond insurance quotes from a flat file system to client/server architecture. Build a Data Warehouse for auto insurance application. The focus is to provide the system with greater control, user functionality, robustness, scalability and security.

Responsibility

Understanding the Requirement Specifications.

Development of Abinitio graphs.

Worked with Partition components like partition by

Key, Partition by Round Robin, partition by Expression.

Performing transformations of source data with Transform components like Replicate, Redefines, Filter-by-Expression, Rollup etc.

Used Lookups with Reformat component to fetch matching records based on for the down stream process.

Used Data Parallelism, Pipeline Parallelism and Component Parallelism in Graphs, where huge data files are partitioned into metafiles and each segment is processed simultaneously.

Worked in a sandbox environment while extensively interacting with EME to maintain version control on objects. Sandbox features like check in and checkout were used for this purpose.

Worked with de partition components Gather, Merge which will be used for combining the files from multiple flow partitions

Performed Unit Testing.

Project # III

Project Name : AFT Modeling, Development and Testing

Client : Allstate Insurance Company (USA)

Environment : Abinitio Unix SQL server windows 2008

Duration : Sept 2011 to Oct 2012.

Role : Associate Team Member

Description:

Allstate Insurance Company, Chicago, US. It is specializing in various insurance products to markets around the world. The main objective of this project is to deliver the data warehouse as a central repository to access the data from segments to make data available for analysis and reporting. It focuses on providing information for analysis on new business growth. Strategic Package 1 entails capturing data from identified sources of Quote and Issue and Distributor data, loading the data into a data warehouse.

Responsibility

Analysis of the specifications provided by the clients

Unit and Integration testing for the developed graphs

Worked with Partition components like partition by Key, Partition by Round Robin, partition by Expression

Used Sort component to sort the tables, and used Dedup Sort to remove duplicate values.

Unit testing of New and existing Graphs.

Contact this candidate