SUMMARY:

• Working as an ETL Consultant with 20+ Years of experience in the field of Software design, development, implementation and Operations.
• 13 years of experience in ETL (Extract, Transform and Load) with Ab Initio as a Lead, Architect and EME Administrator.
• 4 years of extensive experience working with Health Insurance industry data.
• Strong working experience in data warehousing applications, directly responsible for Extraction, Transformation and Loading of large volumes of data from multiple sources into Data Warehouse.
• Extensive experience in Logical and Physical Data Modeling, Database Design and Development as Developer/Analyst using Oracle 8i/9i/10g, DB2 UDB, SQL, PL/SQL.
• Extensively worked in diverse fields like Financial and retail relational Databases with an extensive use of ETL techniques, Dimensional Modeling Design techniques, Data Management and Data Integration Techniques.
• Effectively Tuned and Monitored RDBMS both at application and database level for better performance.
• Provided 24/7 Active Data Warehouse Production Support as part of on - call rotation for both Incremental and Complete refresh.
• Extensive experience in writing efficient and well tuned SQL Queries and UNIX Scripts (K-Shell) and awk on Sun Solaris, HP and IBM AIX to provide reporting, process and validate data on DB2 and Oracle.
• Involved in identification of Facts, Measures, Dimensions and Hierarchies for OLAP models.
• Extensively worked in design and development of client-server applications using C, C++, CORBA, Java, HTML, SQL, PL/SQL and relational databases DB2, Oracle on UNIX and Windows NT environment. dat includes Complete System Life Cycle from Analysis and Design to Implementation.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and Possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Attended formal Ab Initio from Ab Initio Corporation, Leading People and Leading Team s.
• Credits include excellent communication skills, ability to work with different teams and a clear understanding of business rules.

TECHNICAL SKILLS:

ETL Tools: Abinitio V2.1x,V3.x, ACE, BRE, Data profiler, Informatica V7.2, V9.5.1, Datastage

Source Code Control: Abinitio EME, Clearcase, Subversion

Programming Languages: C, C++, J2EE, JSP, Shell, Perl, Awk, PL/SQL

Databases: Oracle 11i/10g/9.x/8.x, DB2 UDB, Teradata 7, SQL Server

RAD / IDE Tools: Visual C++, Lotus Notes, Jbuilder

Reporting Tools: Business Objects 6.5, Cognos, Microstrategy

Scheduling Tools: Autosys, Control M

Middleware: CORBA, BEA ICEBERG, MQ Series, JMS

Case Tools: Rational Rose

Methodologies: BOOCH, UML, RUP, SDLC

Operating Systems: UNIX AIX, HP, SUN, Windows XP, 2000, NT

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Ab-Initio Sr. Developer/ Architect

Responsibilities:

• Working as ETL Architect to develop CSPi Project.
• Analyzed the existing servers CPU/Memory utilization and built new Abinitio servers for different environments based on the requirements.
• Involved in development of highly complex Ab-Initio graphs.
• Developed the metadata driven generic graphs using PDL.
• Involved in reviews and provided Tuning Techniques on Ab-Initio Graphs.
• Tuned the Ab-Initio Graphs to improve the performance.

Environment: Ab Initio GDE 3.1.7; Ab-Initio co>operating system 3.1.7; PL/SQL, SQL*Plus, GNU/Linux, shell scripts (K-Shell), Oracle 11g, AutoSys

Confidential, Jacksonville, FL

Developer III

Responsibilities:

• Involved in Full Life Cycle of the Projects and worked as Lead developer.
• Involved in Design and Development of Ab-Initio Graphs.
• Responsible for Planning, scheduling, and coordinating activities related to system development projects.
• Tuned the Ab-Initio Graphs to improve the performance.
• Written technical design documents (TDD) following SDLC. Rational Clear Case was used as document source control.
• Written K-Shell wrapper scripts to automate the development and execution of ETL processes.

Environment: Ab Initio GDE 3.15, Ab-Initio co>operating system 3.0, AIX UNIX, shell scripts (K-Shell), DB2 8.2 UDB EEE, Oracle 10g, Control M

Confidential, NJ

Ab-Initio Developer

Responsibilities:

• Working as ETL developer Genesis Data Archival Project.
• Involved in analyzing the functional requirements, High level/Detail Design documents.
• Involved in development of highly complex Ab-Initio graphs.
• Developed the Abinitio plans and implemented these plans to run in a loop (ForEachLoop, SubscribeLoop).
• Developed ACE templates and Appcons.
• Involved in reviews and provided Tuning Techniques on Ab-Initio Graphs.
• Tuned the Ab-Initio Graphs to improve the performance.

Environment: Ab Initio GDE 3.1, Ab-Initio co>operating system 3.1, Abinitio OC, ACE, BRE, Linux, shell scripts (K-Shell), Netezza 7.0

Confidential

Ab-Initio Architect/Developer

Responsibilities:

• Worked as ETL Architect to develop CDR/NUCDM Projects.
• Designed Target State Architecture and developed CDR/NUCDM projects to compliance with Target State Architecture.
• Involved in analyzing the functional requirements, mapping documents, solution spec documents, Interface control documents, High level/Detail Design documents.
• Involved in development of highly complex Ab-Initio graphs.
• Developed the generic graphs which includes extract (complete extract or with SQL query), load (API mode or utility mode), delete, ref/lookup table extract, ref/lookup table load with Change Detection Capture (CDC) process.
• Developed the separate Change Detection Capture (CDC) common components for dimension and fact tables.
• Involved in reviews and provided Tuning Techniques on Ab-Initio Graphs.
• Imported the metadata from excel spreadsheet and database to the EME repository to use it in CDC and dynamic generation of transformations.
• Tuned the Ab-Initio Graphs to improve the performance.

Environment: Ab Initio GDE 3.0; Ab-Initio co>operating system 3.0; PL/SQL, SQL*Plus, GNU/Linux, shell scripts (K-Shell), Oracle 11g, Autosys, Clear Case and Clear Quest

Confidential, Jacksonville, FL

Developer

Responsibilities:

• Involved in Full Life Cycle of the Projects and worked as Lead developer.
• Involved in Design and Development of Ab-Initio Graphs.
• Responsible for Planning, scheduling, and coordinating activities related to system development projects.
• Tuned the Ab-Initio Graphs to improve the performance.
• Written technical design documents (TDD) following SDLC. Rational Clear Case was used as document source control.
• Written K-Shell wrapper scripts to automate the development and execution of ETL processes.

Environment: Ab Initio GDE 1.15, Ab-Initio co>operating system 2.15, AIX UNIX, shell scripts (K-Shell), DB2 8.2 UDB EEE, Oracle 10g, Control M

Confidential

Ab-Initio Developer and EME Administrator

Responsibilities:

• Working as ETL Lead Developer to develop the interfaces to EVOLV (Non Performing Loans accounting package) Project.
• Involved in Design and Development of flexible Ab-Initio Graphs with changing requirements and data conditions.
• Involved in Design and Development reviews and provided Tuning Techniques on Ab-Initio Graphs.
• Involved in providing consulting and mentoring services to technical resources concerning methods, procedures, and standards to be used during design, development, and unit testing phases of system development projects.
• Tuned the Ab-Initio Graphs to improve the performance.
• Involved in Ab-Initio 3.0 and tested new features of the product.
• Involved in Building & configuring new Test and Production servers with all AI software for HAMP project.
• Responsible for Administration, License Management and infrastructure support of AI servers.
• Involved in EME upgrade from and 2.15 to 3.0
• Also responsible for resolving any type of Ab-Initio related issues by coordinating with Ab-Initio customer support.
• Responsible for new project set ups, branch creations, project migrations and troubleshooting development issues.

Environment: Ab Initio GDE 1.15, 3.0; Ab-Initio co>operating system 2.15, 3.0; PL/SQL, SQL*Plus, Sun Solaris UNIX, shell scripts (K-Shell), Oracle 10g, Autosys, Clear Case and Clear Quest

Confidential, Jacksonville, FL

Developer III

Responsibilities:

• Involved in Full Life Cycle of the Project. Lead many projects to success by analyzing complex business process rules.
• Involved in Design and Development of Ab-Initio Graphs.
• Used BRE (Business Rules Environment) to write the rulesets and rules and generated the components/transformations from these rulesets.
• Developed Ab-Initio Graphs to read the XML files and load the data into EDW database.
• Responsible for new project set ups and troubleshooting development issues.
• Tuned the Ab-Initio Graphs to improve the performance.
• Written technical Design Guidelines documents (TSD) following RUP methodology. Rational Clear Case was used as document source control.
• Written K-Shell wrapper scripts to automate the development and execution of ETL processes.

Environment: Ab Initio GDE 1.14, Ab-Initio co>operating system 2.14,BRE, AIX UNIX, shell scripts (K-Shell), DB2 8.2 UDB EEE, Oracle 10g, Control M

Confidential, Wilmington, DE

Ab Initio Consultant

Responsibilities:

• Working as a Consultant to build the CDM data mart with consumer and business card customer data.
• Analyzed the data from different sources (RDM, DCAP, CB ARMaster, Demog, ACTION HISTORY and ASE) to bring all the fields into the CDM
• Involved in Design and Development reviews and provided Tuning Techniques on Ab-Initio Graphs.
• Created Ab-Initio graphs for CDM project using GDE.
• Added Business card customer data as part of Phase2a and created ad hoc graphs to integrate the data.
• Prepared design spec document for CDM project.

Environment: Ab Initio GDE 1.14, Ab-Initio co>operating system 2.14, PL/SQL, Sun Solaris UNIX, shell scripts (K-Shell), Oracle 10g

Confidential

Sr. Developer

Responsibilities:

• Worked as a Sr. Developer to Develop the Pool Setup and Aggregation components.
• Provided technical leadership to technical resources to meet project deadlines and ensure project objective are met.
• Responsible for Planning, scheduling, and coordinating activities related to system development projects. Created project plans using MS Project for different modules and worked with technical resources to meet the project deadlines.
• Involved in providing consulting and mentoring services to technical resources concerning methods, procedures, and standards to be used during design, development, and unit testing phases of system development projects.
• Provided system or technical development expertise to the technical resource team.
• Responsible for providing support to technical resources in setting up the ETL jobs into batch control framework.
• Involved in Design and Development reviews and provided Tuning Techniques on Ab-Initio Graphs.
• Worked with different team Leads to integrate the project with all the components.
• Responsible for communicating issues and status information to the Higher Management concerning system development activities.

Environment: Ab Initio GDE 1.14, Ab-Initio co>operating system 2.14, PL/SQL, SQL*Plus, Sun Solaris UNIX, shell scripts (K-Shell), Oracle 10g, Autosys, Clear Case and Clear Quest

Confidential, Dulles, VA

Architect

Responsibilities:

• Worked as an Architect to Design, Develop the Sub A/R project and Data validation tools using Ab-Initio ETL Tool.
• Responsible for Offshore team to Design and development of the validation graphs to validate the source data for Legacy and Sub A/R systems.
• Providing technical leadership to offshore technical resources to meet project deadlines and ensure project objective are met.
• Involved in Design and Development reviews and provided Tuning Techniques to offshore on Billed Revenue Repository (BRR) projects.
• Created Ab-Initio graphs for different ad hoc jobs using GDE.

Environment: Ab Initio GDE 1.13, Ab-Initio co>operating system 2.13, PL/SQL, SQL*Plus, HP UNIX, shell scripts (K-Shell), Oracle 9.2, Autosys

Confidential

Ab Initio Technical Lead

Responsibilities:

• Worked as a Technical Lead for Design, Development of Business Planning Project using Ab-Initio ETL Tool.
• Used dataprofiler to profile and validate the data at the analysis stage.
• Responsible for CPI and BDM Applications for different enhancements.
• Plan, schedule, and coordinate activities related to development projects in gathering requirements, Analysis and Design of different modules in Business Planning project.
• Involved in design reviews of All ETL Modules for Business Planning project.
• Providing technical leadership to technical resources while creating Ab-Initio graphs for different Modules using GDE.
• Involved in tuning the graphs of CPI and BDM projects to improve the performance.
• Responsible for EME administration, License Management and infrastructure support.
• Also responsible for resolving any type of Ab-Initio related issues by coordinating with Ab-Initio customer support.
• Reviewed the Wrapper scripts which written in Shell Scripts and PERL.
• Involved in gathering requirements from business users for different reports and lead responsible for developing Business Objects reports.

Environment: Ab Initio GDE 1.13, Ab-Initio co>operating system 2.13, Dataprofiler, PL/SQL, SQL*Plus, Sun Solaris 8 Unix, shell scripts (K-Shell), Oracle 9.2, Business Objects 6.5

Confidential, Irving TX

Lead Analyst

Responsibilities:

• Worked as a Technical Lead and responsible for development, EME Repository administration and maintenance.
• Involved in building Ab Initio graphs for different interfaces using Graphical Development Environment.
• Used Ab Initio built in components to extract, transfer, integrate and load (ETL) the data from multiple legacy systems to DB2 tables.
• Responsible for EME administration, License Management and infrastructure support.
• Also responsible for resolving any type of Ab-Initio related issues by coordinating with Ab-Initio customer support.
• Maintain the Ab Initio Co-operating system and the EME Repository on Development, QA and Production nodes.
• Provide support and disaster recovery for ad-hoc and scheduled production jobs by creating ad-hoc graphs and shell scripts on the need basis.
• Responsible for migrating the Ab Initio graphs to production and scheduling the jobs through OPS scheduler to run on regular basis.
• Created Ab Initio EME Repository, Captured metadata information through EME for current and existing Ab Initio graphs for dependency analysis and job tracking information.
• Involved in migration of the DB2 UDB EEE database to Teradata 7 database and migrated the production data. Written FAST Load scripts to load the data during the conversion time.
• Converted all the graphs to support Teradata and written MULTILOAD scripts to Update/Insert the data and FAST Load scripts to load the data if the table is empty.

Environment: IBM p690 (Regatta) nodes, DB2 8.2 UDB EEE, Teradata 7, Ab Initio GDE 1.12, Ab Initio co>operating system 2.12, Data Profiler, PL/SQL, SQL*Plus, AIX 5.2 Unix, shell scripts (K-Shell).