SUMMARY

• Working as a Application Architect / Senior Tech Lead with American Express
• 11+ years of commendable experience in requirement gathering, analysis, designing, development, testing and implementation phases of various ETL/Data warehousing projects involving AbInitio, UNIX and Oracle/DB2
• Skilled Enterprise DW/BI solutions architect who transforms strategic plans into workable solutions.
• Skilled in designing optimized enterprise process across business segments using robust data handling processes. Architect solutions that are reusable, maintainable.
• Developed many large AbInitio graphs (with best performance) with complex transformation rules using Ab Initio and Unix
• Extensive experience working in Agile as well as conventional software development models.
• Extensively worked on the Performance Tuning of AbInitio Graphs and ETL process
• Expertise knowledge in dimensional data modeling, star schema, snow flake schema, creation of fact and dimension tables, OLAP, OLTP and thorough understanding of data warehousing concepts.
• Well versed with various Ab Initio performance & parallelism techniques and implemented Ab Initio Graphs using Data, Component and Pipeline parallelism.
• Developed various UNIX shell scripts to run Ab Initio and Database jobs.
• Experience in providing support for huge ETL Systems on AbInitio graphs and scheduling runs.
• Worked with EME for AbInitio jobs migration, version control, and Dependency Analysis operation.
• Executed numerous ETL and Ab Initio projects in Insurance, Finance & Communications sector
• Experience in leading a team size of 10+ for long term.
• Won multiple awards and accolades for exceptional work and achievements in project.
• Hands on experience in project planning, estimation, resource planning and project management.
• Certification completed on Agile Training and Rally tool.
• Team player with great leadership qualities and excellent management skills.
• Technically adept with exceptional skills in coding and debugging.
• Good communication skills, interpersonal skills, self - motivated, quick learner, team player
• Attended 5 day training session on Advanced Abinitio in Chicago, IL from Abinitio Corp, USA.

TECHNICAL SKILLS

ETL Tool: Abinitio 3.X

Reporting Tool: Business Objects, Oracle D2K (entry level)

RDBMS: Teradata, Oracle, DB2 & SQL Server

Scripting: UNIX Shell Scripting, PL/SQL programming

Scheduling Tools: IBM TWS/TDWB, CA Unicenter, Control M

QA Tools: Mercury Quality Center, HP ALM

Tools: TOAD, Oracle SQL Developer, JRS, HP Service Manager

Project lifecycle Tools: Rally (for Agile)

PROFESSIONAL EXPERIENCE

Confidential Phoenix, AZ

Technical lead/Application

Responsibilities:

• Working on Data File Factory and Global Air File Project for AMEX GCST Portfolio.
• Have discussions with the client and freeze the requirements
• Design and Overlook End-to-End flow of the project and highlight risks in advance.
• Performance tuning for long running jobs
• Help the team understand the requirements and guide them in the development and testing phases.
• Being involved in all the phases of the project and making sure that deadlines are met with utmost quality deliverables by adhering to quality procedure as laid out by the client.
• Develop and maintain generic abinitio graphs for transformation process.
• Helping the team to follow the best design principles, efficiency guidelines and naming standards in designing and developing the graphs
• Developed UNIX wrapper scripts for the applications
• Preparation of Test Cases for UNIT and SIT.
• Used Mercury Quality Center to keep track of bugs.

Environment: Ab Initio 2.14, UNIX

Project lead

Responsibilities:

• Worked as Project Lead on ETL Floor Sweep Project
• Designing the entire infrastructure in new ETL environment.
• Coming up with RAID (Risk, Assumptions, Issues & Dependencies) for the project in the initial planning stage.
• Creating a blue print and HLD of entire program
• Estimating the project cost and resource planning.
• Leading the front for any technical challenges.
• Mentoring, guiding and motivating team members.
• Analyzing Source System's and making them redirect the feeds to new host.
• Converting the graphs from compatibility mode to native mode which includes updating the graphs and making PDL's for the start script parameters.
• Reviewing team's deliverables and making sure that quality is been maintained across all deliverables.
• Fixing Defects / Bugs discovered during System Testing.
• Prepare Unit test plans and review test results.
• Getting actively involved in all the phases of project.
• Create and maintain the defect report sheet.
• Awarded with IBM Eminence and Excellence award - 2012 for my extraordinary contributions towards IBM and client projects
• Honoured with IBM & Vodafone UK Certificate for the excellent work done to lead and guide a dynamic team for splendid achievements to a very critical and complex project

Environment: Ab Initio 3.0, UNIX, Maestro/TWS, Oracle

project lead

Responsibilities:

• Mentoring, guiding and motivating team members.
• Analyzing Source System data.
• Understanding the requirement and developing Abinitio graphs.
• Reviewing team's deliverables and making sure that quality is been maintained across all deliverables.
• Fixing Defects / Bugs reported by the Testing Team.
• Prepare Unit test plans and review test results.
• Getting actively involved in all the phases of project.
• Create and maintain all the SQA documents like CAR (Casual Analysis Report) and QM (Quality Metrics) reports.

Team Size: 8 Offshore, 2 Onsite

Environment: Ab Initio, UNIX, SQL Server, Oracle, HP Service Manager

Confidential, IL, USA

project/onsite lead

Responsibilities:

• Providing maintenance and support for around 70 Applications (18,000 Abinitio job scripts) developed by Syntel.
• Mentoring, guiding, training and motivating other team members.
• Coordinating with different Subject areas and SME's for requirement gathering and test results validation.
• Work on adhoc queries raised by end users.
• Getting transition of new application & then transitioning it to offshore team.
• Preparation of Weekly and Monthly reports which depicts the hour's utilized under enhancements & support activities and various other project metrics.
• Preparation of Graphs, LLD and Detail Design Document for any new development/enhancement & tuning existing graphs for better performance.
• Making sure that all predefined SLA's are met on time.
• Fixing data defects by preparing audits involving Abinitio graphs and PL/SQL's
• Working on production job aborts, doing root-cause analysis and making sure that it doesn't get repeated.
• Understanding the requirement and developing Abinitio graphs.
• Mentoring, guiding and motivating other team members.
• Analyzing Source System data.
• Fixed Defects / Bugs reported by the Testing Team.
• Prepared and Executed the Unit test scripts.
• Involved in Unit Testing and Integrated Testing.

Environment: Ab Initio, UNIX, SQL Server, Oracle, HP Service Manager

ADW Financial Metrics

Confidential, IL, USA

Responsibilities:

• Analyzed Functional Requirement, interactions with end user and source Programmers for proper business understandings.
• Assisting SME's in designing overall application and Abinitio graphs.
• Created High Level and low level design documents.
• Development of Abinitio graphs.
• Offshore task delegation and client interaction.
• Analyzing Source System data.
• Mentoring, guiding and motivating other team members.
• Fixed Defects / Bugs reported by the Testing Team.
• Involved in Unit Testing and Integrated Testing.
• Was awarded with Syntel "Extra Mile" award for my extraordinary leadership skills and stretching beyond regular hours to deliver project within timelines.

Environment: Ab Initio, UNIX, SQL Server, Oracle, HP Service Manager

Confidential

Senior developer

Responsibilities:

• Providing maintenance and support for around 70 Applications (18,000 Abinitio job scripts) developed by Syntel.
• Work on Adhoc queries raised by end users.
• Preparation of Weekly and Monthly reports which depicts the hour's utilized under enhancements & support activities and various other project metrics.
• Preparation of Graphs, LLD and Detail Design Document for any new development/enhancement & tuning existing graphs for better performance.
• Making sure that all predefined SLA's are met on time.
• Fixing data defects by preparing audits involving Abinitio graphs and PL/SQL's
• Working on production job aborts, doing root-cause analysis and making sure that it doesn't get repeated.

Environment: Ab Initio, UNIX, SQL Server, DB2, Oracle, HP Service Manager

Confidential

Software developer

Responsibilities:

• Responsible for Writing complex SQL Queries and PL/SQL code for generation of various reports in Business Objects
• Designing Universe as per user requirement, where user can run the query independently.
• System analysis & finalization of various technical & functional specifications.
• Design, development, testing, troubleshooting & debugging of the application.
• Oversee smooth implementation of the application at User location.
• Provide post-implementation & enhancement support.
• Creating tables and applying constraints,
• PL/SQL Programming
• Writing triggers, packages and stored procedures as per requirements
• Designing forms & reports in D2K

Environment: Oracle, Oracle Developer 2000