PROFESSIONAL SUMMARY:

• AB Initio Designer Developer and Data Warehouse with 9 years of quality experience.
• More than 8 years of experience in Analysis, Design, Development, Testing, Implementation and Support of Ab Initio, Unix and Mainframe applications in Core Banking and Healthcare domain
• 8+ years of experience in Data warehousing applications (ETL) using Ab Initio GDE, Co - operating System and UNIX/Linux operating system.
• Extensive development experience in Extraction, Transformation and Loading of the data from multiple sources into Data warehouse. Well versed with various Ab Initio parallelism techniques including Data, Component and Pipeline parallelism.
• Extensively performed Testing, Debugging, Troubleshooting, Monitoring and Performance Tuning of Ab Initio graphs.
• Strong knowledge of Data Modeling methodologies such as Star Schema and Snowflake Schema.
• Good exposure to multiple relational databases including Oracle, DB2.
• Good knowledge on Banking and Healthcare Domain.
• Experience in scheduling process using job schedulers such as CA 7, ZEKE.
• Experience in developing wrapper scripts for scheduling Ab Initio Graphs.
• Well versed in analyzing and identifying performance tuning opportunities in plans, graphs and transformation rules
• Experience in Unix shell scripting to build various ad-hoc reports, tools and value adds
• Highly Skilled in writing simple and complex SQL queries in dealing with tables from databases such as DB2 and Oracle
• Excellent leadership quality and managerial skills including experience in driving teams from remote locations
• Excellent analytical and problem solving skills. Good communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS:

ETL Tools: Ab Initio GDE 1.14.x/1.13.x/1.12.x, 3.x, Co>Operating System 2.14.x/2.13.x/2.12.x, 3.x

Operating Systems: AIX UNIX, Linux, Windows 95/98/NT/2000/XP

Databases: DB2 7.2/8.2, Oracle 12c/9.x/8.x/7.x.

Languages: SQL C, JAVA.

Scheduler Tools: CA 7, Zeke.

Version Control Tools: Ab Initio EME

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Technology Lead

Responsibilities:

• Handling maintenance activities. Acting as SME to this Project and an on-site coordinator.
• Building strategies and setting standards for application and code development.
• Handling Problem Tickets, Production Migration, Service Requests
• Unit Testing of application and handling migration activities to QA and Production
• Analysis of requirement document.
• Building strategy, setting standards for application.
• Code Review and enhancements.
• Presenting Weekly Reports to the client on ongoing production activities.

Confidential, Atlanta, GA

Technology Lead

Responsibilities:

• Designed, developed the ETL code on Ab-intio to convert SQL Loader scripts and other CRON jobs.
• Working across the teams to update the Oracle database version from 9i to 12c.
• Documented current state and future state of Consumer Lending applications. This contained applications overlaps/dependencies, end to end flows, detail level data mappings, gap analysis and future architecture proposal)
• Performing Integration & Performance testing in QA environment and creating process flow for scheduling in CA-7 scheduler.
• Performing Implementation tasks to migrate the code to PROD and handing over the project to Prod Support Team.
• Supporting the project for any change control in the code while the project is in PROD for warranty period.

Environment: Ab Initio GDE 3.2.x, Co>Operating System 3.2.x, Linux HP-UX, Unix script, Oracle 12c, Toad, CA-7 Scheduler.

Confidential, Atlanta, GA

Technology Lead

Responsibilities:

• Gathering requirements from business users on change controls and enhancements to the applications.
• Development of new jobs Unit testing and Integration testing of the developed jobs in QA environment and developing mainframe JCLs for scheduling in CA-7 scheduler.
• Analyzing the user requirements and providing optimal solutions accordingly.
• Onshore/Offshore co-ordination for seamless support to production tasks/applications.
• Automating and fine tuning existing production processes.
• Status reporting to client and stakeholders, managing SLA and coordinating change request.
• Conducting impact analysis on the change controls and contributing to the project plan based on the analysis.
• Supporting and handling production tasks. Fixing production issues.
• Developing graphs and wrapper scripts based on the design related to change controls .

Environment: Ab Initio GDE 3.2.x, Co>Operating System 3.2.x, Linux HP-UX, Unix script, Oracle 12c, Toad, CA-7 Scheduler.

Confidential

Technology Analyst

Responsibilities:

• Analyzing the user requirements and providing the solutions for various Data warehouse related documents.
• Creating detailed Level design document and Component Specification design document based on business requirements and Functional Specifications including Detailed Impact analysis.
• Development of new jobs and enhancement/modification of existing jobs using Ab-Initio 3.0/2.14.
• Performance Tuning and End to End Testing of Jobs/Components.
• Unit testing and Integration testing (if required) of the developed jobs. Preparing the Test Document based on Business Requirements and Functional Specifications and executing test cases manually.
• Migration and Dry Run of jobs in Test environment.

Environment: Ab Initio GDE Ab-Initio 3.0/2.14, Co>Operating System 2.15.x, DB2, Oracle

Confidential

System Engineer

Responsibilities:

• Lead the team of 5 members from offshore for multiple critical financial and reporting applications
• Developed and optimized and ETL code to make it more standardized and streamlined
• Identified potential shortfalls in the Zeke scheduling and other technical issues and in result, brought down the production incidents to 80%.
• Started and maintained successful communication channels with the customer to improve customer reporting
• Learnt the business process and improved on Abinitio, Perl scripting and SQL queries in a very short span of time..

Environment: Ab Initio GDE Ab-Initio 3.0/2.14, Co>Operating System 2.15.x, DB2, Oracle, UNIX, MAINFRAME SYSTEMS (RUMBA).