SUMMARY

• Total 18 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.
• 13 years of strong Data Warehousing/ETL experience using Ab Initio GDE and EME Continues flows, Plans,
• 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.
• One year of experience in UAT Test Support, and code build
• 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

Application Developer

Responsibilities:

• Worked many Jira requests to implement changes in current ab initio graphs of existing process
• Incorporated changes to CMPL extracts for using the files intraday files changed source system files
• Worked on Sybase to oracle conversion for CMPL, GMI, RDI, VMDR ab initio Projects
• Converted VMDR Sybase procedures to oracle stored procedures and associated Abinitio Graphs
• Developed generic dynamic diff Graph to identify diff in oracle extracts and Sybase extracts to validate conversion process
• Created many new auto sys jobs for oracle based extracts and delete old Sybase autusys jobs
• Worked on sourcing GPTM Files into oracle tables
• Developed common graphs, plans and pset to implement common frame for extract distribution to different clients
• Developed Generic Plan extract to generate extract based on table driven

Environment: Ab initio 3.2 Oracle Sybase, Windows, Linux

Confidential

Application Developer

Responsibilities:

• Worked on average 2/3 work requests/ per day t for TQMS team
• Enhanced the existing feed copy shell script to accommodate new feed on fly
• Worked on deployment of Jira tagging script for month end release and hand over to SSPM team
• Worked on Jira to deploy components containing unix scripts. Informatica, DB2 Sql,, Sqlserver Auto sys objects
• Mentored for new team member to work on WR and build team of 10 members

Environment: Informatica, Phyton scripts, UNIX Script, DB2, Sql Server, XP .

Confidential

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

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

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