PROFESSIONAL SUMMARY:

• Proactive, result oriented, creative Datawarehouse specialist and a multi role SDLC player.
• An IT professional having an Industrial Experience of 26 years
• 17 years of excellent work base experience on ETL Process using Ab Initio and Data Profiling, ETL, ELTL, Data Integration...etc. ( MFS and SFS Staging, Extraction, Business rules transformation and implementation, Loading, Data quality routines ).
• 17 years of strong experience with Multifile ( MFS ) and Serial File ( SFS ) process, Parallel processes using Abinitio.
• Strong experience on developing re - usable generic / dynamic Abinitio applications for high-volume DWH environment ( ~ 50 TB )
• Experienced with PDL, metaprogramming graphing
• 20+ years of strong experience with Financial Industry
• 20+ years of strong experience on Data Warehouse Technology and its SDLC Phases
• 18+ years of excellent work base experience on ETL Process Design, Development and implementation 12+ years of strong experience on Logical & Physical Design process, Data Mapping, Impact Analysis and Root Cause Analysis
• 20+ years of excellent work base experience on Unix O/S and Unix Korn Shell Programming
• Strong experience on conducting Review Meetings and Process Documentations
• Strong hands on experience with Change Management processes of major Corporations
• 7+ years of experience on Abinitio Enterprise Metadata Environment ( EME )
• Extensive experience with data conversion projects ( Extraction from legacy COBOL datasets to Oracle database and Unix file system)
• Excellent work base experience on OLTP/ALTP/OLAP application development using Oracle ( PL/SQL Functions, Procedure and packages)
• Excellent work base experience on Disaster Recovery process
• 12+ years of strong experience on Oracle DBA routines, SQL Tuning, Application Design & Development and Data Analysis
• 15+ years of strong experience on design, development and maintenance of STAR, SNOWFLAKE schemas, Fact Tables, Dimensional Tables ( Type 1, Type 2, Type 3) , and Surrogate Keys etc.,
• Extensive experience on SQL, PL/SQL, Pro*C, Forms 3, 5 & Developer/2000 Rel 1 & 2
• 8+ years of extensive work base experience with Tivoli and 1 year with Autosys
• Strong Communication Skills and Team Management

TECHNICAL SKILLS:

Operating Systems: Ab Inito Co>Op 2.11 /2.13 / 2.14 / 2.15/ 3. x, IBM AIX, Sun SolarisHP-UX 11, Unix, Super Max Unix (AT&T Compatibl-e), Linux RedhatMCS/AS (Master Control Program / Advanced System), Windows platforms, DOS

Hardware: Sun Sparc Stations, Sun Solaris, HP ServersORG SuperMax R3000 Server, Unisys A3K Mainframe System, Intel Platforms

Database: Oracle7.x, Oracle 8.x, Oracle 9.x, Oracle 10g, Teradata

Languages: Unix KShell, SQL, PL/SQL, Pro*C, CDBMS-COBOL74, HTML, DHTML, JavaScript

Packages: SQL*Forms3.0/4/5, Developer/2000 Rel 1 & 2, GEMCOSTMS, Harvest Version Control, Clear Case Version ControlIBM Tivoli Scheduling, Autosys, SQL Navigator, TOAD

ETL / BI Tools: Ab Initio GDE 1.11, 2.11, 2.13, 2.14, 2.15, 3.x Data Profiler, Abinitio EMEBusiness Objects (BO5, Webi5) Informatica 9.x

Database Tools: ERWin, Visio

PROJECT EXPERIENCE / WORK HISTORY:

Confidential, Herndon, VA

Sr.ETL Lead

Environment: Ab Initio ( Co>Op 3.X / GDE 3.1.2 ), Informatica 9.x, Oracle, Unix, Agile-Scrum

Responsibilities:

• Certified Agile Scrum Master, leading multiple teams
• Tech lead for Abinitio and Informatica development teams.
• Leading “Innovation-Automation” process for Confidential CSPi and Convergence projects
• Design and review patterns and process patterns.
• Contributing member of multiple Tech committees such as ETL architecture Forum, Metadata Forum, ETL Forum, Batch Processing Forum

Confidential, Herndon, VA

Sr.ETL specialist

Environment: Ab Initio ( Co>Op 3.X / GDE 3.1.2 ), Oracle, Unix

Responsibilities:

• Designed and developed ETL applications for Confidential Credit Data Repository
• Designed and developed semi-coupled tool free Metadata Layer for Credit Data Repository ( CDR ) and National Underwriting Center (NUCDM )
• Framework design / development, Application re-engineering, end-to-end ETL design.
• Dynamic, metadata driven ETL application development using PDL and Metaprogramming
• ETL / Abinitio and ETL process optimization
• Manage defect, implement enhancements and perform SDLC procedures and standards
• Requirement analysis, Data analysis

Confidential, Chicago, IL

Sr.ETL specialist

Environment: Ab Initio ( Co>Op 3.X ), DB2, Unix

Responsibilities:

• 120 Hours scoped ETL ( Abinitio ) optimization project
• Process Analysis, Design, develop PDL and metaprogramming based re-usable dynamic components for the existing process
• ETL / Abinitio and ETL process optimization
• Design and develop new database load process

Confidential, Franklin Lakes, NJ

Sr.ETL specialist

Environment: Ab Initio ( Co>Op 3.X / GDE 3.1.2 ), DB2, Unix, Agile

Responsibilities:

• Working with “Ab Initio Corporation Team” as an Abinitio technical resource
• Design and develop dynamic, re-usable, complex Abinitio applications for Confidential applications using PDL and Metaprogramming
• Continuous graphing for PBM ( Preferred Benefit Management ) process
• XML / XLS data process, implement highly complex health care business rules
• Abinitio - Graph optimization.
• Functional and Technical documentation and its review process
• Contributing member of COE and infra structure team.

Confidential, Warren, NJ

Sr.ETL specialist

Environment: Ab Initio ( Co>Op 1.15 / GDE 2.15.8 ), Oracle, Unix ( Kshell )

Responsibilities:

• CoE / DQP team member
• Onsite coordinator/Lead for CITI - DMS-SPIDER-DQP project with Oracle Corporation resources.
• Work closely with all DMS-SPIDER stakeholders and facilitate accurate / required data needed for the end user.
• Work closely with AML ( Anti Money Laundry ) stakeholders for Data Analysis, Mapping and development.
• Continuous graph development for AML project.
• Develop robust Abinitio, Unix KShell, Oracle based applications (Abinitio, Unix ) for Data Analysis process.
• Sr ETL resource (Data Analysis and Development ) for AML X-Sector and DRAMS projects.
• Prepare different functional and technical documents and get it reviewed
• Develop PDL based Abinitio based applications for Global Receivables warehouse applications. (Abinitio, Unix )

Confidential, NC

Lead Abinitio - Oracle - ETL Consultant .

Environment: TeraData, Ab Initio ( Co>Op 1.15 / GDE 2.15 ), Meta Data, Unix ( Kshell )

Responsibilities:

• Develop Abinitio, Terradata and Unix KShell based applications
• Prepare different functional and technical documents and get it reviewed
• Develop PDL based Abinitio and Teradata based applications to handle Provider, Membership business areas
• Develop Error Reporting Frame work for existing ETL processes.
• Coordinate with BCBS leads and deliver the assignments as planned.

Confidential, Chappaqua, NY

Lead Abinitio - Oracle - ETL Consultant

Environment: Oracle 10g, SQL, PL/SQL, Ab Initio ( Co>Op 1.14 / GDE 2.14 / 2.15 ), IBM Unix ( Kshell ), Harvest PVCS, Visio, Perl.

Responsibilities:

• Develop Abinitio, Oracle and Unix KShell based applications
• Perform MSR ( Marketing System Replacement ) Data Warehouse system study
• Identify and analyse the Unix KSH, Perl and Abinitio code base to get the knowledge transfer to Confidential offshore employees
• Identify and analyse Oracle DB objects and its related PL/SQL scripts
• Be a mentor to the Confidential onsite employees for Unix Korn Shell Sripts and Abinitio application.
• Identify and analyse the EME elements to be documented and addressed
• Learn and document the Business Rules Engine practices and its maintenance
• Prepare different functional and technical documents and get it reviewed
• Develop new Abinitio graphs to improve transformation and Load process (Abinitio, Unix )
• Develop new components for the weekly process ( Abinitio, PL/SQL, Unix )
• Support weekly ETL process.

Confidential, Wilmington, DE

Sr. Appl Developer/ Lead Abinitio - Oracle Developer

Environment: Oracle 9.x, 10g, SQL, PL/SQL, Ab Initio ( Co>Op 1.14 / GDE 2.14, 2.15 ), IBM AIX Unix ( Kshell ), Harvest PVCS, Visio, Tivoli

Responsibilities:

• Lead Developer for JPMC - Chase Credit Card datawarehouse applications.
• Design ETL application and develop Datawarehouse applications based on the technical / functional specifications
• Implement Re-startability, Recovery Options, Extract / Load Staging, DIM / FACT loading, ETL Audits
• Design and implement ETL staging ( Seriel and multi ) and loading applications using Ab Initio
• Implement Disaster recovery routines and documentions
• Work closely with the Business Analysts and Application Leads to get the business/technical requirements and develop datawarehouse applications using Ab Initio, Oracle PL/SQL and Unix Korn shell scripts for JPMC’s Very Large Database ( VLDB .. ~ 50 TB )
• Design, develop and maintain MFS ( Multi File System ) and SFS ( Single File System )
• Design and develop and implement Data quality process using Data Profiler
• Create logical and physical design documents for each processes and provide approved one to the Corporate DB Achitecture team and DB maintain capasity plans
• Conduct process status meetings with all stakeholders and publish dashboards
• Lead developer, point of contact for data conversion processes ( COBOL dataset from legacy system) and develop Ab Initio applications , PL/SQL (Functions, Procedures and packages ) and Unix K shell scripts
• Lead developer for migration project ( Internet Channel Marketing Data Mart, Customer Opt-Out Process )
• Application development using PL/SQL batch process using collections, bilk processing, hints .
• Load batch process data onto partitioned tables and its performance tuning .
• Lead developer for CORE and Non-CORE applications for Confidential Datawarehouse department ( COBOL dataset from legacy system) ( Ab Initio, PL/SQL and Unix KShell)
• Worked on EME elements to improve process improvements, Metadata management, Rules Engines extracts.
• Conduct functional / technical reviews, DMC presentations .. etc
• Lead developer for Disney Stored Value Cards and Business Cards Webfeed Applications ( Ab Initio, PL/SQL and Unix KShell)
• Worked closely, as a lead developer, with BankOne Privacy groups and Enterprise data warehouse team for Enterprise privacy process to facilitate the needs of Risk management and customer development group ( Ab Initio, PL/SQL and Unix KShell)
• Generate Customer information details from the TSYS feeds for Consumer and Business customers based on the analytical charactoristics ( COBOL dataset from legacy system) ( Ab Initio, PL/SQL and Unix KShell)
• Analyze the data feeds from Enterprise Datawarehouse and daily customer feeds and report the current / possible issues to Application lead and take necessary actions from IT perspective
• Lead developer for Internet Channel Marketing Datamart applications ( Ab Initio, PL/SQL and Unix KShell)
• Developed 3 Ab Initio applications to process SASDATASET and loading into different DW schema for the datamart process
• Perform crucial roles on system testing / QA implementation and production jobs maintenance
• Key technology resource for Disaster Recovery process and maintenance

Confidential, Shelton, CT

Sr. Abinitio - Oracle ETL Consultant

Environment: Oracle 9.x, SQL, PL/SQL, Ab Initio, Solaris, HP UX ( Kshell ), Harvest PVCS, Autosys

Responsibilities:

• Lead Developer for Confidential Credit Card datawarehouse applications.
• Worked closely with Business Analysts to gather business requirements and convert them into IT specifications ( Business + Tech Analysis )
• Design and implement corrective measurements based on the production issues and tickets.
• Work closely with Offshore and onsite development team and Confidential resources.
• Conduct process status and review meetings with all stakeholders and publish dashboards
• ETL (Extraction, Transformation, Loading) process using Ab Initio (Data Warehouse)
• Pre-ETL data quality check / sanity validations using Data Profiler.
• Worked on EME elements to improve process improvements, Metadata management, Rules Engines extracts.
• Transaction process routines using SQL, PL/SQL and Korn shell scripts (Korn Shell)
• Design, develop and maintain MFS ( Multi File System ) and SFS ( Single File System )
• Application development using Abinitio, SQL, PL/SQL and Korn shell scripts (Korn Shell)
• Issue based analysis on the tickets raised by the Confidential Consumer Finance on data warehouse applications and resolve them in the speculated window ( SQL, PL/SQL, KShell and Abinitio )
• Work closely with the offshore Satyam Technology development team to develop and maintain Confidential data warehouse data and applications
• Handle FDR data loading Process and data conversions
• Application development using PL/SQL batch process using collections, bilk processing, hints .
• Load batch process data onto partitioned tables and tune its performance .
• Revisit the process specifications / component specifications and work with necessary groups to keep the Confidential data warehouse intact
• Data scrubbing based on the process requirements and production process and its maintenance (Abinitio, SQL, PL/SQL and Kshell (Korn Shell)

Confidential, Horsham, PA

Sr. Programmer Analyst / Abinitio - Oracle Developer

Environment: Oracle 8.x/9x,SQL,PL/SQL, Ab Initio ( Co>Op 2.11 / GDE 1.11 ), ERWin, Kshell, HP-UX 11, Sun OS 5.8, Visio, Clear CaseTivoli, Autosys

Responsibilities:

• Lead Developer for Confidential / Fleet Credit Card datawarehouse applications.
• Handle campaign processes, Data loading, Account Review Process, Business Card process etc
• Create technical specifications and conduct review meetings
• Gather production issues, report to management and implement through future releases
• ETL (Extraction, Transformation, Loading) process using Ab Initio, PL/SQL and Kshell
• Transaction process routines using SQL, PL/SQL and Kshell (Korn Shell)
• Design, develop and maintain MFS ( Multi File System ) and SFS ( Single File System )
• Application development using SQL, PL/SQL and Korn shell scripts ( Korn Shell )
• Worked extensively on Abinitio EME.
• Perform data analysis for “Database Marketing” and “Data In” teams. (SQL, PL/SQL and Kshell (Korn Shell), Abinitio )
• Data scrubbing based on the process requirements (Ab Initio and PL/SQL )
• Application development using PL/SQL batch process using collections, bilk processing, hints .
• Load batch process data onto partitioned tables and tune its performance.
• Productionisation process ( Version control, QA process and maintenance )
• Disaster Recovery process and maintenance

Confidential, MA

Software Engineer ( Oracle Developer )

Environment: Oracle 8.1.6, PL/SQL, Business Objects, Win/NT4.0, MS ACCESS, VB6, Sun Solaris ( Kshell )

Responsibilities:

• Installation and Administration of Oracle 8.1.6 Database on Win/NT Server
• Oracle Application Turning, Develop Oracle components, testing and implementation
• Conduct data analysis using SQL, PL/SQL and Kshell (Korn Shell), Abinitio
• Transaction process routines using SQL, PL/SQL and Kshell (Korn Shell)
• Develop Business Object repositories and components for clients
• Create and maintain proper documentations like Component Specification Document, Changes List etc