PROFESSIONAL SUMMARY:

• I have more than 8 + years of hands - on experience on Ab Initio ETL, Data Mapping, Transformation and Loading in complex and high-volume of data processing applications.
• Experience in full life cycle of software design process (SDLC) including requirement gathering, design, development, documentation, implementation and Testing.
• Hands on experience on various Ab Initio components, EME, PDL, XML Data and worked on both serial file system & multi file system.
• Implemented various UNIX shell scripts for job control and for automation various manual tasks.
• Worked on Schedulers for jobs automation processes Using Autosys and crontab.
• Investigating ETL job failures due to resource constraints, missing/invalid data/files, and bugs and infrastructure component issues on time to meet the SLA’s.
• Interaction with Client to discuss critical issues and taking the acknowledgement and providing the resolution and provide Daily/weekly status report to Customer.
• Have worked with different source/target systems and written complex transformations/transform functions.
• Working on in house rules engine/frame work called RULES HARMONY.
• Having good knowledge on Data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables.
• Proven abilities at Guiding, Leading, Mentoring, and Training ETL Trainees inside the team and across.
• Quick learner and highly motivated individual with ability to handle challenges as an individual (or) team contributor. Good in analysis and debugging skills.

TECHNICAL SKILLS:

ETL Tools: Ab-Initio ( 3.0.3/3.0.4/3.2.2.9/3.2.5.7)

Database: SybaseIQ, Oracle

Version Control: EME, SVN, Bit Bucket

Scheduling Tools: Autosys, Crontab

Scripting: UNIX Shell Scripting

Other Tools: CA Workload control center, JIRA, SQL Developer, and PUTTY, Interactive SQL

Programming Languages: SQL, JIL, Core Java

Domain Experience: Banking and Financial Services (BFS) and Mortgage

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Module lead/ Ab Initio Programmer

Responsibilities:

• Participated in SAS to Ab Initio Migration as part of the project.
• Designed and developed automated processes to extract, transform and load data with appropriate error handling mechanism.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Translating the functional requirements into mapping designs.
• Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.
• Redesigned the existing graphs for performance improvements.
• Design and develop ETL jobs which extract information from Oracle Database, Sybase Database, flat files and load them into application specific tables and/or create files to be transferred to downstream systems.
• Responsible for performing ETL unit and development tests, monitors results and take corrective action, when necessary.
• Responsible for all the UAT and Production deployments and Post-Production Check out.
• Developed generic graph to compare the result generated from SAS and Ab Initio which helped to validate the results
• Responsible for delivery of all enhancements, maintenance and meeting SLA on all support related incidents.
• Co-ordination of development work with team members, review ETL jobs, and create shell scripts for scheduling jobs.

Confidential, Warren, NJ

Module lead/ Ab initio Programmer

Responsibilities:

• Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.
• Developed monthly and daily batch graphs since LLR application runs on daily and monthly basis.
• Participating in periodic meetings, maintaining all applications for production, and planning appropriate strategies.
• Investigating ETL job failures due to resource constraints, missing/invalid data/files, and bugs and infrastructure component issues.
• Ensure root cause analysis is done and that proactive/preventative measures are taken to avoid a reoccurrence.
• Created Job Information Language (JIL) and capabilities to recommend suggestions that will comply with internal standards and best practices.
• Coordinating with other teams as the LLR module takes the source data from the other applications.
• Responsible for delivery of all enhancements, maintenance and meeting SLA on all support related incidents.
• Prepared the mapping documents as the application is under migration to Java.

Ab initio Developer

Responsibilities:

• Design and develop process to create scenario files using the market factors, shocks and Spreads given by Risk Analytics.
• Design and develop the processes to extract, transform and create transaction request for OTCs/SFTs.
• Responsible for Running the process and generate the stress results using VCS (Var Calculation Service) engine for given scenarios.
• Responsible for validating the results and submission to the Risk Analytics.
• Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.

Jr Ab initio Developer

Responsibilities:

• Prepared the internal mapping Documents as part of the analysis and design phase.
• Developed generic graphs with PDL features, Re-usable shell scripts to reduce development efforts & re-usability.
• Have written the Unit test cases to make sure the business logics implemented properly.
• Involved in code migrations to UAT and PROD environments.
• Investigating ETL job failures due to resource constraints, missing/invalid data/files, and bugs and infrastructure component issues.