SUMMARY

• Total 15 years of IT experience in Requirement Analysis, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Testing of Database and Data warehousing and Data Marts for Financial, Insurance industry.
• 10 years of strong Data Warehousing/ETL experience using Ab Initio GDE and EME, Dependency analysis and Ab Initio web.
• 4 years of experience in providing Architecture solution
• 2 years of Data warehousing ETL with Informatica.
• Extensive experience in reverse engineering the existing applications in Java, Sql and Cobol.
• Extensive experience loading data and compare target systems like Teradata, DB2, Oracle, SQL Server and Netezza
• Excellent knowledge of complete data warehouse life cycle, testing methodologies and reporting.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema and ODS architecture for modeling a Data Warehouse by using tools like
• Extensive knowledge in Data warehouse concepts and methodologies
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville Florida

Lead Application Developer

Responsibilities:

• Developed abinitio Graph to recycle unprocessed messages in regular flow of message processing
• Implemented R4 changes for Blue square xml messages in continues flows
• Developed abinitio graph to generate data quality report for avility messages
• Prepared xml test data for Blue square messages for unit test and system test
• Crafted ETL Detail Design document form preliminary design documents for data masking Project for offshore team
• Analyzed existing code issues for Blue square messages processing
• Identified opportunities to improve some of processing in CF, and initiated those improvements in code

Environment: Ab Initio (GDE, Co - Op 3.0), EME, continues flows, xml, Unix, UNIX Script (KShell), DB2, main frame, XP.

Confidential, Jersey City

Application Developer Lead

Responsibilities:

• Managed June 4 release with Team of 10 Dev team and 4 designers
• Standardized build tracker and trained other on this
• Managed to reduce noises in daily team status calls
• Analyzed impacts APTP,EMEATP/IFTP, MIS, BASEL, LRI Project Bo servers Upgrade and implemented required changes around 190 interfaces independently
• Learned and implemented CTM Jobs Related to Bo servers Upgrade
• Implemented strutting mapping documents so that generation of xfr ( code)can be automated for 70%
• Implemented new interface form source OMINI with 2 data feeds data into common frame work
• Modeled after OMINI interface to get 36 Monthly Olympic feeds in CF
• Independently worked on 12 CR for Nov 2013 with minimal issues
• Identified opportunities to improve some of processing in CF, and initiated those improvement them

Environment: Abinitio 3.0, EME, Oracle10g,Windows, Linux, Business objects

Confidential, Jersey City

Abinitio Expert

Responsibilities:

• Reveres engineered the existing Saturn Project code to elicit the current business logic and mapping rules
• Provided Architecture solution web services Graph for POC and helped other teams for implementing web services
• Designed and implemented extract and Transform common Graphs .for SMC Product
• Developed common graphs, plans and pset to translate SMC data to Secore farmat
• Developed Graph to identify the differences in field level from GSM and SMC Data sources
• Involved with tem to construct XML Payload to publish messages from DDI Cache for Downstream systems
• Worked the Java teams on nailing down the flow for creation of new securities on fly
• Worked with other team member to design custom API for temporal implementation
• Designed canonical model XML for Data distribution
• Analyzed data product coverage and attribute coverage IN SMC and GSM
• Created plan and shell scripts loading SOI and lookup related date

Environment: Abinitio 3.0, EME, Oracle10g, Windows, Java, flex

Confidential, Richmond, VA

ETL Specialist

Responsibilities:

• Crated shell script to parse existing sql scripts and generated Preliminary data requirements
• Worked with EDW abinitio Teams to establish common Projects for all EDW Projects
• Developed shared Graphs in common project to Load table like mailing addr, phone Etc
• Crated 90 pset, sql,xfrs to load consumer date into where hose
• Created plan and shell scripts to schedule loading all consumer application related date
• Leaded research involved data mapping issues and data Steward in UAT region.
• Created an extract specification documents, High level design documents and implementation Plans related to consume data
• Developed Referential integrity check script in Sql
• Created plan to and shell scripts loading all consumer history for application and Applicant related date
• Evaluated solutions for XML and flat file based solution for Moody”s ratings file for history
• Developed Graphs for parsing loading XML data into reference database for Basel 2 initiative

Environment: Ab Initio (GDE 1.15, Co-Op 2.15), EME, Teradata Sql server, Oracle10g, Windows 2003 professional.

Confidential, FOSTER CITY CA

Sr. Abinito Developer/Designer

Responsibilities:

• On site coordinator for 4 abinitio developers in India
• Crafted ETL Detail Design document form preliminary design documents for Mars Authorization
• Updated the existing plans Graphs as per requirement
• Implemented required changes parent search shell script for MARS project
• Implemented required changes for existing insert main shell script
• Implemented the required changes for B1-B2 match graphs
• Analyzes the change impact of MARS project on ODS, DWAUTH, CMLS, GLOBALS abinitio projects
• Implemented the Sftp part for MRCH automation project
• Crafted Detail Design document for ETL form functional Specks document for Authorization Result code reporting
• Implemented the required change for B1-B2 match
• Analyzed the change impact of Au Result Code project on ODS, DWAUTH, CMLS, GLOBALS abinitio projects
• Created graph to generated test data for parent search used by QA Team
• Analyzed the sizing requirements on FERA related RTNS

Environment: Ab Initio (GDE 1.14, Co-Op 2.14), EME, Plan >It and Conduct >It, Unix, UNIX Script (KShell), DB2, main frame, MVS, Windows XP.

Confidential, WARREN NJ

Sr Abinito developer

Responsibilities:

• Designed, implemented and maintained warehouse load graphs
• Developed type 2 change graphs for dimensions such as account, product, and desk
• Developed and rolled out ETJ - EQDW reconciliation project
• Developed and rolled out graphs for loading landing, staging and fact tables
• Developed Perl programs to parse Fix4.2 data, log files from smart server
• Developed many shell scripts for system health check of systems
• Worked on many projects to enhance spectrum of data
• Mentored production support, Autosys Jil, DDL, Ab Initio, and UNIX package promotions to India, Brazil Teams
• Developed stored procedures for partitioning tables on all schemas in GEDW
• Developed many shell scripts to send statues reports, compliance mails and pull data from various sources
• Initiated and stabilized UAT environment for production parallel run to have integrated QA data .
• Responsible for the automation and production deployment of Ab Initio Graphs using Korn shell scripts
• Developed many ad hock graphs for data quality, data spectrum enhancements, query retrieval analysis
• Created and maintained autosys Calenders,Cycle boxes

Environment: Ab Initio GDE 2.14, EME, autosys Unix solaris, linux Toad, UNIX Script (KShell), Oracle 9i/10g,Windows XP .

Confidential, Wilmington DE

Ab Initio Developer

Responsibilities:

• Designed and developed on enterprise privacy module for upgradations by adding Ab Initio graphs and analysis of logs
• Maintained circuit city privacy module
• Developed log analysis methodologies for Quality assurance purpose.
• Developed and maintained Texas conversion project in merger project of bank one and Chase
• Written and analyzed several Custom Components and called in Ab Initio.
• Developed and Responsible for maestro Job scheduling implementation
• Involved in writing Stored procedures to access data from Oracle 9i.

Environment: Ab Initio (GDE 1.12, Co-Op 2.12.2), EME, Tivoli, Unix AIX, Sql Developer Sql Navigator, UNIX Script (KShell), Oracle 9i,,Windows 2000 professional.

Confidential, Boston MA

Ab Initio Developer

Responsibilities:

• Performing transformations of source data with Transform components like Join, Sorted, Dedup Sorted, Denormalize, Reformat, Filter-by-Expression, Rollup etc.
• Designed and implemented sub graph for Record count for load balancing
• Developed initial and incremental load graphs for 11 dimensions.
• Developed data validation Graph for validating 200 info usa source data files
• Developed wrapper scripts for loading fact tables and load status tables
• Develop and modify several application scripts in UNIX in order to pass the environment variables and to implement run controls for various graphs
• Involved in writing Stored procedures to access data from Oracle 9I.
• Developed QA scripts to generate report from table logs.
• Responsible for cleansing the data from source systems reporting the data quality levels on file-by-file basis using Ab Initio.

Environment: Ab Initio (GDE 1.12, Co-Op 2.12.2), EME, Data profiler, Linux, Unix, Pl-Sql Developer Toad, UNIX Script (KShell), Oracle 9i,E-Piphany, Windows 2000 professional.

Confidential, Chicago, IL

Ab Initio Developer

Responsibilities:

• Developed 90 Xfr for various components like scan, rollup, join, reformat Components of Ab Initio.
• Developed 8 parameterized graphs witch will cater for transformation of 55 tables
• Generated Dml s from Cobol copybooks for various graphs
• Implemented the Parallel application by replicating the components- datasets and processing modules into number of partitions.
• Analyzed many Cobol programs and JCL.
• Developed wrapper scripts for loading fact tables and load status tables
• Strong experience loading data into target systems like main frame DB2, Oracle
• Replicate operational tables into staging tables, Transform and load data into warehouse tables using Ab Initio GDE and responsible for automating the ETL process through scheduling and exception-handling routines

Environment: Ab Initio (GDE 1.12, Co-Op 2.12.2), EME, Ab Initio Web, HP-UX, Toad, COBOL, MVS,, UNIX Script (KShell), Oracle 9i, Test Director, Windows 2000 professional.