Professional Summary

Education

Experience

Confidential

Abinitio Lead/Designer/Developer

March 2009-till date

Confidential

Abinitio Lead/Designer/Developer

December 2008 – March 2009

Confidential

ETL Architect/Project Lead

Jan 2007-December 2009

Confidential

Senior Software Engineer

March 2006-December 2006

Confidential

Software Engineer

Dec 2003-March 2006

Confidential

IT Trainee

June 2003-Dec 2003

Technical Expertise

Hardware:

Microprocessors (8085,8086)

Operating Systems:

UNIX, WINDOWS 2000/XP/98, DOS

Languages:

PL/SQL, C /C++ Language

Databases/Tools:

ORACLE 8i/9i/10g/11g ,Teradata,DB2, MS – Access, SQL Server
Erwin.

GUI:

Visual Basic 6.0

Reporting Tools:

Business Objects, Hyperion

Web Related:

HTML

ETL Tools
and UTILIES:

Ab-Initio (GDE 1.15.5,1.14/1.13.4/1.13.19,
Co>Operating System 2.15.2,2.14/2.12.2/2.11.8/2.10),
Ab-Initio EME Abinitio with XML,TIBCO,Informatica

Domain Knowledge:

Data warehousing concepts , Finance, Credit
Card Business, Retail ,T&L,Insurance,Telecommunications

Projects Profile

Client –Confidential,

All corps Data Warehouse (ADW) is Allstate’s Data Warehouse to consolidate data from different sources.ADW warehouse capture most of information like policy information, claims, billing, HRM area. Data is extracted from different sources.ADW architecture is divided into three layers.Raw, Standard, Presentation.Raw layer is image of source with minimum transformation. Standard layer is mostly normalized data. Presentation layer is for reporting purpose.
Implementation of ADW included migrating the current data from legacy to Oracle in the first phase called as History Migration and the second phase consisted of loading the daily transaction updates to ADW referred to as incremental.

07/2009 – Till date Confidential,Chicago IL

Role Abinitio Lead/Designer/Developer
Environment Abinitio GDE(1.15),Co>Ops (2.15),EME,TIBCO,Oracle(SQL/PLSQL),Unix, Erwin, Teradata v2r5,DB2,SQL SERVER

Project Description:
The purpose of this project is to get agent credit card data into Allstate Data warehouse (ADW).This project is an exception to ADW as instead of implementing Raw, Standard, and Presentation we have implemented Dimension modeling. The data is extracted from different source like Citi files, MS Excel, Oracle database and Teradata Database, DB2 and SQL Server. This data go through different transformation and load into Dimensions (Type1, 2, 3) and Fact tables. Due to complexity of logic various audit implemented to ETL process.
Responsibilities

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model
• Study the relation at the source systems
• Worked as an architect to work on developing designing strategies, database design/analysis and data migration techniques.
• Provided end to end Architecture solution for the project.
• Worked on Data Model with team and created flexible model considering the needs of future.
• Implement the ETL solution using Abinitio (2.15) tools and involved in whole development life cycle of project like design, coding, testing, migration and production support.
• Developed continuous flows and also develop graphs for batch processing
• Developed shell scripts for automation of environment setup, wrapper scripts for process, batch execution and other process.
• Track the project progress and provided daily status report to client.
• Maintained the issue log, identify risks and provide solutions.
• Worked on project estimates and SOW of project.
• Worked on Onsite-Offshore development model.

05/2009 – 10/2009 Confidential,Chicago IL

Role Abinitio Lead/Designer/Developer
Environment Abinitio GDE(1.15),Co>Ops (2.15),EME, TIBCO, Oracle(SQL/PLSQL),Unix, Erwin, DB2

Project Description:
The purpose of this project is to extract billing related information of policy holders and load in ADW .The data is extracted from mainframe DB2 table using BMC unload technique on daily basis. In raw layer data is extract and go through minimum transformation and then load into tables. In Standard layer, the data transactional data load directly after transformation but some tables go through chaining process to maintain history. History migration includes migration of 2TB of data from 9 different sources.
Responsibilities:

• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model
• Study the relation at the source systems
• Worked as an architect to work on developing designing strategies, database design/analysis and data migration techniques.
• Provided end to end Architecture solution for the project.
• Worked on Data Model with team and created flexible model considering the needs of future.
• Analyzed functional requirements and convert them to technical requirements and design
• Created technical detail design documents and conduct code reviews with different groups
• Implement the ETL solution using Abinitio (2.15) tools and involved in whole development life cycle of project like design, coding, testing, migration and production support.
• Worked in providing better solution to improve the performance of over all ETL cycle.
• Developed continuous flows and also develop graphs for batch processing
• Developed shell scripts for automation of environment setup, wrapper scripts for process, batch execution and other process.
• Responsible for the design, development and testing of Ab Initio graphs
• Responsible for the design of system integration test plans.
• Maintained the issue log, identify risks and provide solutions.
• Worked on project estimates and SOW of project.
• Worked on Onsite-Offshore development model.

12/2008 – 05/2009 Confidential,Chicago IL

Role Abinitio Lead/Designer/Developer
Environment Abinitio GDE(1.15),Co>Ops (2.15),EME,Oracle(SQL/PLSQL),Unix, Erwin, Teradata,DB2,SQL SERVER

Project Description:
The purpose of this project is to extract claim related information of policy holders and load in ADW .There are multiple project.

• Develop a common dimension process in standard layer

This project is to build a common process to load dimension table and create file for facts.

• Develop an Auto Dashboard scorecard project.

This project is to build 2 facts tables from standard layer into presentation layer. One fact table captures Cycle time and other Quality measure.
Responsibilities:

• New requirement gathering.
• Responsible for understanding source data ,data analysis, data mining
• Setup the environment for metadata management and ETL process
• Provide innovative Data warehousing solution to create scalable and flexible data warehouse.
• Design the flexible and expandable ETL process.
• Developed graphs for batch processing.
• Developed shell scripts for automation of environment setup, wrapper scripts for process, batch execution and other process.
• Develop and maintain reports for each status.
• Responsible for the design, development and testing of Ab Initio graphs
• Analyzed functional requirements and convert them to technical requirements and design
• Created technical detail design documents and conduct code reviews with different groups
• Responsible for the design of system integration test plans
• Provide support to offshore team in development and testing.
• Provided schedules, status reports, and issue resolutions to the Project team, Business Users, and Project Managers. Kept peers and upper management well informed with weekly status reports on project status / risks and test issues.
• Performed Data Validations and Setting up Audit mechanisms using/building data stage custom codes.
• Responsible for implementation of project.
• Responsible for overseeing the Quality procedures related to the project

Client – Confidential,

FORD is one of the leading automobile company. FORD IT is having various applications which is loading data about automobile order, billing, parts, make model information in warehouse. FORD IT is having 1000 application running on different platforms and load data into different databases like Oracle, Teradata, DB2, and SQL Server. The applications build in various front end languages like Java, VB, MS tools.

10/2008 – 12/2008 Confidential,Dearborn,MI

Role Business Analyst/Project lead
Environment Datastage 8.x,Oracle(SQL/PLSQL),Teradata,DB2,SQL SERVER, Unix, Erwin

Project Description:
Tata Motors bought Jaguar and land Rover from Ford Motor Company. There are many applications currently running in Ford environment which is having Jaguar and land rover data. This project deals with to clone all applications for JLR currently exist in Ford system and to migrate only JLR data to new systems.
Responsibilities:

• New requirement gathering.
• Responsible for understanding existing system and designing strategies to separate JLR data from existing FORD system.
• Performed various interview sessions to understand the application and determine the separation rules.
• Performed extensive process modeling and data modeling of the old system as the foundation for reengineering the business processes for a new high performance data warehouse.
• Develop the code to migrate and separate JLR data using data stage.
• Established Integration test team and worked with the team in evaluating risks involved at different stages when data is migrated from Ford environment to JLR environment.
• Provided schedules, status reports, and issue resolutions to the Project team, Business Users, and Project Managers. Kept peers and upper management well informed with weekly status reports on project status / risks and test issues.
• Performed Data Validations and Setting up Audit mechanisms using/building data stage custom codes.
• Responsible for overseeing the Quality procedures related to the project.

Client - Confidential,

FEDEX global is one of the leading service providers in travel and logistics. FEDEX IT is having various verticals and maintains data for each vertical separately into different Databases like Oracle, Teradata.

02/2008 – 10/2008 Confidential,Collierville,TN

Role Data Architect/Abinitio lead/Data Modeler
Environment Abinitio GDE(1.15),Co>Ops (2.15),EME,Oracle(SQL/PLSQL),Teradata,Unix, Erwin

Project Description
Confidential,is one of the leading service providers in travel and logistics. The project is basically to replace the automated pricing existing system into new system which should work for Global pricing system. The transactional information extracted from US pricing system and send to different subsystem in form of data file or XML.
The pricing warehouse is having information about customer details, sales, revenue, and proposal information, type of pricing discounts like market based or strategic. The new APL extract data from USPRS and GPRS apply common business rules and retransform data into XML layout.
Downstream process pull XML data and send to different downstream subsystem in there respective layouts.
Responsibilities:

• Client Liaison.
• New requirement gathering
• Detailed analysis of the specifications provided by the clients and performed impact analysis
• Analyze the source systems data and the current reports at the client side to gather the requirements for the Data Warehouse Data Model
• Study the relation at the source systems
• Worked as an architect to work on developing designing strategies, database design/analysis and data migration techniques.
• Provided end to end Architecture solution for the project.
• Worked on Data Model with team and created flexible model considering the needs of future.
• Design the new ETL process after analysis of AS IS system and define the different areas (interface) and process flow for each subsystem
• Design the approach for handling USPRS and GPRS using common transformation
• Develop the graphs for new APL using Abinitio with XML.
• Unit testing, system testing of graphs
• Review and sign off process with client.
• Supported UAT includes ticket solving and fixing issues in graphs.
• Responsible for overseeing the Quality procedures related to the project.

Client - Confidential,

Confidential,takes a fresh approach to banking by focusing on simplicity. In a world of clutter, GE Money is dedicated to providing everyday financial solutions — with speed, simplicity and ease.
Based in Stamford, Connecticut, GE Money is the consumer and small business financial services unit of General Electric. Our expertise in financial services dates back more than 75 years, when the GE Credit Corporation was formed to finance the purchase of home appliances. Today, more than 118 million customers in 50 countries around the world turn to GE Money for their everyday financial solutions.
GE Consumer Finance is a leading provider of financial services to retailers, manufacturers, and consumers in over 35 countries around the world. It has different business verticals like Collections, Consumer, CDCI and Commercial.

05/2007 – 02/2008 Confidential,India

Role Business UAT Lead
Environment Informatica 8.x,Oracle(SQL/PLSQL),Unix, Erwin

Project Description
Confidential, is a Global Integrated warehouse for countries like Mexico, Australia,
Canada etc.The Integrated Base Data Model is prepared for all countries. The ETL process is defined and developed using ETL tool Informatica.
GE is having business in various countries and deal in different product like Credit Card, Mortgage, Auto loan, personal load, vehicle loan. This integrated Data Model capture all GE business for each country.
Responsibilities

• Interaction with Business to get requirement for IDW data analysis.
• Understanding the functional part of GE business to validate properly
• Validate the IDW Data with source.
• Prepare UAT test plan with estimates, timelines.
• Prepare Test cases/scenarios.
• Prepare SQL Test scripts and Test results.
• Issue log and UAT dashboard for daily Status.
• Review ETL design and mapping in INFORMATICA 8.x.
• Responsible for overseeing the Quality procedures related to the project.

02/2006 – 05/2007 Confidential,Shelton,CT

Role Abinitio Designer/Developer/lead/Data Analysis
Environment Abinitio GDE(1.14),Co>Ops (2.14),EME, Oracle(SQL/PLSQL),Unix, Erwin

Project Description
Confidential,is having information related to delinquency accounts. In collection warehouse, there are three types of information.
1) Delinquency related like total balance, outstanding amount, and writeoff accounts.
2) Dialer related like dial attempt, promise, and comments.
3) HR related like collector information, collector timesheet, and manager
The Collection warehouse “AS IS” system is having around 15000 jobs with lots of technologies such as SAS,perl,Unix scripting,PL/SQL.The project is for conversion of existing cumbersome process into more flexible process using ABINITIO as a ETL tool.
Responsibilities

• Client Liaison.
• New requirement gathering
• Detailed analysis of the specifications provided by the clients and performed impact analysis
• Design the new ETL process after analysis of AS IS system and define the different areas (interface) and process flow for Dialers.
• Design the approach for handling Dimension at ETL layer in MFS datasets.
• Design the rejection handling process, audit process based on the analysis from AS IS system and new requirement specification.
• Developed graphs for batch processing.
• Developed shell scripts for automation of environment setup, wrapper scripts for process, batch execution and other process.
• Develop and maintain reports for each status.
• Responsible for the design, development and testing of Ab Initio graphs
• Analyzed functional requirements and convert them to technical requirements and design
• Created technical detail design documents and conduct code reviews with different groups
• Responsible for the design of system integration test plans
• Design the ETL process for History Migration of 2TB of data from AS IS system to new system, also involve in defining rejection, keying strategy for migration process.
• ETL Administration activities like defining the mount point, Project creation, setting up parameters, creating sandbox, migration of graphs etc.
• Review and sign off process with client.
• Supported UAT includes ticket solving and fixing issues in graphs.
• Responsible for overseeing the Quality procedures related to the project.

02/2006 – 02/2007 Confidential,Shelton,CT

Role Data Modeler/Abinitio Lead
Environment Abinitio GDE(1.14),Co>Ops (2.14),EME, Oracle(SQL/PLSQL),Unix, Erwin

Project Description
The Collection warehouse was having new requirement for creation of Data mart so that dashboard can be prepared. Business users used to prepare spreadsheet manually. We have designed a data mart having dashboard data at all different hierarchy levels .Also designed a customized process that gave them flexibility to change data. There are different P&L with different currency, actual and plan data and are at different hierarchy levels.
Whole ETL process is designed in ABINITIO and reporting on BOXI .Performance manager tool was used for delivering dashboard to users.

• New requirement gathering
• Analysis of the specifications provided by the clients
• Detailed analysis and design of the interface from the client’s RDD (Requirement Design Document).
• Design the ETL process flow, Rejection handling, audit process
• Developed graphs for batch processing
• Developed shell scripts for automation of environment setup, wrapper scripts for process, batch execution and other process.
• Develop and maintain reports for each status.
• Responsible for the design, development and testing of Ab Initio graphs
• Analyzed functional requirements and convert them to technical requirements and design
• Created technical detail design documents and conduct code reviews with different groups
• Responsible for the design of system integration test plans
• Design the updating process, that provide flexibility to Biz to send feed files any day in a month for performing updating on previous month data.
• Design the scheduling process which needs to run based on functionality of feed i.e. for insert or update.
• Review and sign off process with client.
• Responsible for overseeing the Quality procedures related to the project.
• Client site for implementation.

12/2003 – 02/2006 Confidential,Shelton,CT

Role Abinitio Lead/Abinitio Developer/Abinitio Designer
Environment Abinitio GDE(1.13/1.14),Co>Ops (2.13/2.14),EME, Oracle(SQL/PLSQL), SAS, Unix

Project Description
The CDCI–RCF project deals with the credit card related data processing and loading. All the credit card related information like demographic,transaction,billing related information etc are being received as flat file/EBCDIC files, which will be processed under ETL using Abinitio Graphs, then the processed data will be loaded in to the target tables, which are in oracle.
Responsibilities

• KT process for acquiring project from vendor, understanding the ETL process and documenting the client process, the knowledge was further evaluated by client using deep dive presentations
• Team building – distributed the knowledge gained and evaluated the same
• Worked on various Data warehousing enhancement projects, such as column addition, client addition, client decommission, process improvements
• Involve in Designing ETL process for the new interface came as a part of different phase of project
• Graph development using Ab Initio and Unix Shell scripts. Development of Interfaces (Graphs) and Loading the EBCDIC data through them into Warehouse after applying critical transformations.
• Developed graphs for batch processing
• Developed shell scripts for automation of environment setup, wrapper scripts for process, batch execution and other process.
• Develop and maintain reports for each status.
• Responsible for the design, development and testing of Ab Initio graphs
• Analyzed functional requirements and convert them to technical requirements and design
• Created technical detail design documents and conduct code reviews with different groups
• Responsible for the design of unit testing,system integration test plans
• Testing - unit testing & integration testing
• Supported UAT includes ticket solving, and post production issues
• Responsible for overseeing the Quality procedures related to the project.
• Involve in defining parameters and performance tuning of graphs like unload from Oracle table, utilizing the Abinitio parallelism in correct phase, avoid using costly components etc
• Worked in construction of reusable components like reading feed files based on project level parameter, reconciliation components etc

12/2004 – 08/2005 Confidential,India

Role Abinitio Developer
Environment Abinitio GDE(1.13/1.14),Co>Ops (2.13/2.14),EME, Oracle(SQL/PLSQL),Unix

Project Description
There are also processes running on the Acxiom Open system (referenced as CRMS) for RCF and RSF. There is a project underway to shutdown the Acxiom Mainframe processes. New processes are required to send the data that was going to the Acxiom Mainframe to the Acxiom Open System. The historical data needs to be converted from the Acxiom Mainframe to the Acxiom Open System.

• Graph development using Ab Initio and Unix Shell scripts. Development of Interfaces (Graphs) and Loading the EBCDIC data through them into Warehouse after applying critical transformations.
• Preparing Function and technical documents
• Preparing test cases and test results
• Testing – End to End testing of the process for verifying the impacts caused due to the enhancements.
• EME admin work like creation of EME,project creation, parameters setup etc