Summary

• More than 7 yrs of experience on Abinitio
• Extensively worked on Abinitio Tool using various components like rollup, join reformat and techniques like parallel processing, component folding etc
• Working with EBCIDIC,XML,flat unix files processing
• Well versed with the Financial and Banking Domains
• Worked on Large Datawarehouses, to size of 25 TB
• Designed/Involved in creating code for data processing system up to a volume of 4TB.
• Strong working knowledge of Data Warehousing techniques and Concepts experience including ETL processes, Star Schema/Snowflake Schema
• Worked on all the phases of SDLC from requirement gathering to product support.
• Won client accolades numerous times
• Worked on the Mainframe screens
• Worked on Solaris, AIX, Redhat, Windows, Z O/s operating Systems
• Worked on Databases like Oracle, SQL Server, DB2
• Worked on the Automation of the ETL jobs using Autosys and Tivoli Work Schedulers
• Worked on the Quality Analysis of the products, responsible for the Defect tracking and Classification
• Exposure to other ETL tools like Data Stage, Informatica
• Exposure BI tools like Business Objects, Cognos, Essbase

Roles:

• ETL Designer
• ETL Team Lead
• ETL Developer
• Abinitio Trainer
• EME Administrator
• Application Owner
• Subject Matter Expert

Trainings

Advanced Abinitio
Business Objects
Data Stage
Data Modeling
Defect Tracking

Accolades

Won most valuable performer Award From Cognizant Tech.
Identified As Star Performed by GE Finance
Got letters of Appreciation from the IT team of Wells Fargo Co. , Key Bank & Chase.
Rated among the top 10% Employees In a strength of 40k+

Skills:

ETL: Abintio GDE(1.15 to 1.13) Abinitio Co>Opsys(3.0 to 2.12),Data Stage EE 7.5
Database: Oracle(10g, 9i) Db2, SQL Server 2005,Teradata
Operating Systems: Sun Solaris, IBM AIX,Redhat Linux, IBM Z/os, Windows
Languages: Shell Scripting, PL/SQL, SQL
Scheduling: AutoSys, Tivoli WorkLoad Scheduler

Project Details

Receivables Vision

Client: Confidential
Duration: Nov 2011-Till date
Role: Sr. DeveloperTeam Size: 5

Environment: AIX, Abintio 3.0/2.15,Oracle, Autosys R11

Citi is one the largest Banks in the world.
The objective of this assignment to complete the Receivables Data acquisition for the North America region Public sector clients of the Citi’s ICG(Institutional Clients group), Normalize the data, Load it into the Global Information Warehouse and the Marts, so that the data can be displayed on the Front End.
As a part of this Assignment the activities I would get involved are

• Work with the global/Regional product owners to understand the requirement and get a BRD walk through
• Work with the source system team(product processors) to understand/Standardize the data layout
• Work with other developers/BA to create a Best in class ETL solution.
• Work with Front end(Reporting) teams to understand their data display capability and create the necessary Dimension & Fact tables and populate them.
• Create a design and framework for the generic Abinitio Code to handle the multiple and ever expanding list of data files coming from source(10+)
• Create a Validation layer and response file creation system to validate and provide an automated response to the source systems indicating the errors in the data they sent over & schedule those using Autosys.
• Create a transform and load code in Abinitio and Shell scripts & schedule those using Autosys.
• Work with the PMO team to provide regular update and adjust the time lines if necessary.

MAC Applications Enhancements

Client: Confidential
Duration: Feb 2010-Nov-2011
Role: Sr Developer/Lead
Team Size: 8

Environment: AIX, Abintio 2.14,Oracle, TWS

Chase Bank is one of the largest Banks in US.
The objective of this Assignment is to enhance/develop and maintain all the Applications under the MAC block with the latest business requirements. As the Information technology owners of the application covered under the accounting subject area, we are responsible for the creation/maintain/up gradation of the IT assets.
As a part of this Assignment we would take up various activities, such as tech refreshes and projects initiated by the business teams, which include

• Disputes Information processing

• This project is to reduce the latency of the Disputes information processing between the various decision making systems
• Creation of a whole new ETL system to extract the Dispute data from Web service by a SOAP request and extract the XML.
• Processing the XML information, transforming it as per the standards of downstream systems and providing them with this information.
• Creating TWS schedules for the processes
• Design walk through with the internal and external stake holders of the project.
• Code review /guiding the offshore team in Application creation.

• Teradata Conversion & Abinitio Upgrade of the Apps

• This project is convert all the Applications in MAC to use teradata as database from oracle
• Converting the oracle SQL scripts to teradata SQLs
• Upgrading Abintio CO>Opsys to 3.0 from 2.15 and making relavant changes in graphs
• Converting the Oracle table components to Teradata Table Components in Abinitio Graphs
• Configuration changes in the environment to use teradata
• Writing Teradata scripts for Fast export and Multi load

• Enterprise Name and Address upgrade

• This is a project under taken by JPMC at enterprise level, whose aim was to standardize the name and address
• As a part of this project I had to perform data profiling using the Abintio Data profiler
• Created new graphs which had data manipulation logic for which join, rollup, reformat components were used.
• Created new TWS schedules
• Coordinated with QA off shore for the testing

• ACME virtual interface creation

• This project is a initiative from the IS side to make the code generic to prevent frequent code changes.
• As a lead developer, was responsible for the design and analyze the impact.
• Worked with off shore developers to help them understand the design and perform code review for their work product.
• Created new graphs, shell scripts and SQL scripts which were replacing and existing code.
• Worked with QA team to review their test cases.
• Worked with business UAT users to ensure there was no functional impact's.

• Abinitio Upgrade from 2.15 to 3.0.

• For this assignment I was responsible for checking the compatibility issue of our existing code at component level
• Working with the QA offshore team and coordinate the testing efforts and review their test plans
• Coordinate with the Architecture team for installation of the new Co>Opsys on the ETL servers

• Installation and use of password vault, for the regular password resets and encrypting them in the log files

• The new password management technique deployed across the firm had to be adopted and used for IT assets under our team, for which we had modify our application to use password management tool called Cyber Ark password vault
• Creating a new design for the password retrieval and use by the scripts to cover up the inherent deficiency of the new tool(Cyber Ark password vault).This new design created by me decreased the password retrieval time by about 200%.

KCM Data Masking

Client: Confidential
Duration: Dec 2009 – Jan 2010
Role: Team Lead/Sr Developer
Team Size: 4

Environment: Linux, Abintio 2.14,Sql Server, TWS

Key National Bank is one of the large Banks in US, Spread Across the Midwest and the East coast
The objective of this Project is the make available the production like data to the developers of this ever expanding Application.
Roles and Responsibilities

• Requirement gathering from the business team
• Develop design strategies to Mask the production data
• Coordinating the work between the Offshore and Onsite
• Develop the frame work for the Data masking using Abintio
• Validate the work products created by other team members
• Creation of wrapper scripts
• Facilitating UAT

Client Experience Product Support

Client: Confidential
Duration: April 2009 – Dec 2009
Role: Subject Matter Expert/Application Owner
Team Size: 10

Environment: Linux, Abintio 2.14,Oracle, TWS,Cognos

Key National Bank is one of the large Banks in US, Spread Across the Midwest and the East coast.
The Client Experience is one the Vital application used by the business teams in Key Bank.As product support team responsibe for Batch monitoring, Ticket resolution,and as Subject matter expert advise the users about the product and guide the data architecture team in improvising the product.

Roles and Responsibilities

• Interaction with the Business teams and Database Administrators
• Providing expert resolution to technical/Functional problem being a Subject Matter Expert for the Application
• Onsite-Offshore coordination
• Providing technology(Ab initio ) support to various other Applications
• Ticket Resolution
• QA Support
• Code Fixes

Cache Data Facility Phase -2(CDF)

Client: Confidential
Duration: Nov2008 – Apr 2009
Role: Team lead/ Sr Developer
Team Size: 8

Environment: Solaris, Abintio 2.15,Oracle, Autosys

Wells Fargo & Co. is a leading bank in the US spread across the West coast and some parts of Midwest.

Leveraging the Architecture of the existing CDF application, expanding the functionality of the Application to include data from other Subject Areas is the objective of this application.

Roles & Responsibilities:

• Onsite-Offshore coordination
• Work Delegation and review of the work products
• Designing of the ETL system
• Data profiling
• Creation Abinitio graphs to read EBCDIC data and convert into ASCII
• Application of complex business rules into Abinitio using components like rollup,join,reformat etc
• Unit Testing
• QA Support.
• Performance enhancing the existing/new features of application using techniques like parallel processing and batch optimization
• Creation of Automation jobs using Autosys

Cache Data Facility (CDF)

Client: Confidential
Duration: Jan2008 – Nov2008
Role: Sr Developer
Team Size: 8

Environment: Solaris, Abintio 2.15,Oracle, Autosys

Wells Fargo & Co. is a leading bank in the US spread across the West coast and some parts of Midwest.

Developing a new Application for the business, which can as act as a ODS to support/reduce the querying on the OLTP. Data from the various OLTP sources is being consolidated and loaded into the ODS. The data loading is being done at real time as well in batch processing.

Roles & Responsibilities:

• Onsite-Offshore coordination
• Designing of the ETL system
• Data profiling
• Creation Abinitio graphs
• Application of complex business rules into Abinitio using components like rollup,join,reformat etc
• Unit Testing
• QA Support.
• Performance enhancing the existing/new features of application.
• Creation of Automation jobs using Autosys

AML Hub

Client: Confidential
Duration: Oct2007 – Dec2007
Role: Developer
Team Size: 5

Environment: AIX, Data Stage EE 7.5Oracle, Autosys

Wells Fargo & Co. is a leading bank in the US spread across the West coast and some parts of Midwest.

AML Hub is one the down stream utilities of the Enterprise Warehouse, primarily used for detecting the money laundering. In this project we need to extract the data from the Enterprise data warehouse modify them accordingly then provide them to the AML hub.

Roles & Responsibilities:

• Coding the Data stage jobs as per the design provided.
• Preparing the Unit test cases, and unit testing the jobs.
• Preparing the Shell scripts which acts as the wrapper to the Data stage and aid in the command line firing of the jobs.
• Conducting peer code review of the Jobs that were developed by other team mates

JCP Migrations

Client: Confidential
Duration: May2007 – Oct2007
Role: Team Lead
Team Size: 5

Environment: Solaris, Abintio 2.14,Oracle, Autosys, Business Objects

GE Consumer Finance is the world’s one largest credit card service provider having wide range of client spread all over America.

This project involves the data migration from various pre existing warehouses like CDW, JCP, ADS and Fraud etc to a single warehouse called JCP-RCF. Major challenges involved in this project are data-modeling, data cleansing before migration as well create the ETL and reporting strategies for the go forward data.
The go forward strategies include conversion of existing code from SAS, perl to abinitio
The module that I handled is called JCPDC. This involves creation of various scheduled extracts, as well creation of a data mart for the JCP RCF which can contain the very important data for the store keepers of JCP.

Roles & Responsibilities:

• Conducting the Proof Of Concept Test.
• Understating the Client requirement
• Designing and Coding the Abintio Graphs
• Task Allocation
• Conducting peer review
• Migrating the BO reports from 5.x to Xi
• EME Administration

CDCI WareHouse

Client: Confidential
Duration: Jul2005 – May2007
Role: Developer
Team Size: 20

Environment: Solaris, Abintio 2.14,Oracle, Autosys, Business Objects

GE Consumer Finance is the world’s one largest credit card service provider having wide range of client spread all over America.
CDCI program involves the migration of the existing legacy warehouses to the newer warehouse, and also add newer subject areas of data being reported.The data reporting is done using business Objects reports build over the warehouse or by sending the snap shots of data to downstream datamarts.

Roles & Responsibilities:

• Constructing the ETL code using the Abintio GDE which involved reading the EBCIDIC, Flat files and applying complex transformations on them to load to the target tables
• Automation of Ab initio graphs using Autosys Jobs
• Testing - unit testing & integration testing
• Post production support and ticket resolution within the warranty period
• Responsible for overseeing the Quality procedures related to the project
• Improvising the existing process by performance tuning of the graphs
• EME Administration

Tasks performed outside the Project execution

• Imparted Training on Abintio
• Helped create a question bank on Abintio which could be used for internal certification
• Undertook interviews of the shortlisted prospective employees
• Helped the Sales team by providing the technical details to complete the RFPs.