PROFESSIONAL SUMMARY:

• Proactive, result oriented, creative Datawarehouse specialist and a multi role SDLC player.
• An IT professional having an Industrial Experience of 13 years
• 12 years of excellent work base experience on ETL Process Design, Development and implementation using Ab Initio and Data Profiling. ( MFS and SFS Staging, Extraction, Business rules transformation and implementation, Loading, Data quality routines ).
• Strong experience on developing re - usable generic / dynamic Abinitio applications for high-volume DWH environment ( < 50 TB )
• Experienced with PDL, metaprogramming graphing
• 10+ years of strong experience with Financial Industry and Data Warehouse Technology and its SDLC Phases
• 8+ years of strong experience on Logical & Physical Design process, Data Mapping, Impact Analysis and Root Cause Analysis
• 11+ years of excellent work base experience on Unix O/S and Unix Korn Shell Programming
• Strong experience on conducting Review Meetings and Process Documentations, Change Management processes of major Corporations
• 5+ years of experience on Abinitio Enterprise Metadata Environment ( EME )
• Excellent work base experience on OLTP/ALTP/OLAP application development using Oracle ( PL/SQL Functions, Procedure and packages)
• 10+ 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
• 4+ years of extensive work base experience with control M 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 Compatible), 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, Exadata

Languages: Unix KShell, SQL, PL/SQL

Packages: Control M

ETL / BI Tools: Ab Initio GDE 2.11, 2.13, 2.14, 2.15,3.x Data Profiler, Abinitio EME

Database Tools: ERWin, Visio

PROJECT EXPERIENCE / WORK HISTORY

Confidential, Columbus

Sr.ETL specialist

Environment: Ab Initio (Co>Op V3-1-2/ GDE 3.1.2.1), Exadata, Unix, control M v8

Responsibilities:

• Design new ETL based load process and build documents for team.
• Lead a team of eight and assign the work day to day basis.
• Performed Detailed Technical Architecture and Design to coordinate and guide teams in onshore/offshore model, facilitated meeting with business and cross functional teams for business requirements definitions and refinements, provided expert guidance on database, ETL design and development, conducted requirements/design/development/test reviews with strong contributions providing guidance and direction to ensure On time Quality Deliverables .
• Process Analysis, Design PDL re-usable dynamic components for the existing process
• Process integrations, data quality and meta data management, data modeling, systems upgrades and migration, application design, testing and production maintenance and enhancements.

Confidential, Columbus

Responsibilities:

• Design Abinitio, Unix KShell based applications for the requirement.
• Prepare different functional and technical documents and get it reviewed
• Design and Develop prototype PDL based Abinitio applications to handle Provider, business areas
• Design and Develop prototype Error Reporting Frame work for existing ETL processes.
• Identify and analyze Oracle DB objects and its related PL/SQL scripts
• Be a mentor to the TCS onsite employees for Unix Korn Shell Sripts and Abinitio application.
• Design scheduling process for AI jobs.

Confidential

Lead ETL Consultant

Environment: Oracle 10G, SQL, PL/SQL, Ab Initio, IBM Unix ( Kshell ), Control M .

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 HCL offshore employees
• Identify and analyse Oracle DB objects and its related PL/SQL scripts
• Be a mentor to the TCS 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

Lead Developer

Environment: Oracle 10g, SQL, PL/SQL, Ab Initio ( Co>Op Co>Op V3-1-2/ GDE 3.1.2.1 ), IBM AIX Unix ( Kshell ), Control M V8

Responsibilities:

• Lead Developer for Confidential - Enterprise data warehouse 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 Confidential ’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 )
• 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)
• Developed 3 Ab Initio applications to process SASDATASET and loading into different DW schema for the datamart process

Confidential

Sr. Appl Developer/Lead Developer

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

Responsibilities:

• Lead Developer for L&G 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 GE 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 GE 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 GE 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 GE 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, Columbus

Sr. Programmer Analyst / Abinitio Developer

Environment: Ab Initio ( Co>Op 2.11 / GDE 1.11 ), ERWin, Kshell, HP-UX 11, Sun OS 5.8, Autosys

Responsibilities:

• Lead Developer for JPMChase datawarehouse applications.
• Handle campaign processes, Data loading, Account Review Process, Business Card process etc
• Create technical specifications and 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

Software Engineer ( Abinitio Developer)

Environment: Ab Initio ( Co>Op 2.11 / GDE 1.11 ), Oracle 8.1.6, PL/SQL, Business Objects, Win/NT4.0, MS ACCESS, VB6, Sun Solaris ( Kshell )

Responsibilities:

• Developing the Ab Initio Graphs, Data study, Unit testing, Deployment activities, Support activity
• ETL and back-end development using PL/SQL components ( SQL, PL/SQL and Korn Shell)
• ETL (Extraction, Transformation, Loading) process using Ab Initio, PL/SQL and Kshell