Summary

• Senior Professional with over 20 years of IT consulting experience in various roles like Technical Lead, Ab Initio ETL Developer/Architect, Data Architect, Data Warehouse Architect, Database Architect and Solution Design Architect in Ab Initio / Oracle / Unix / Windows environments. Proficient in Data Architecture, Design, Development and Implementation of high volume transaction processing and analytical Data Solutions.
• Expert level hands on experience in Ab Initio ETL Design and Development, Data Modeling, Data Warehouse, Database Administration, UNIX, SQL, PL/SQL.
• Proven leadership in the selection of Technology and Tools, definition of Data Architecture Standards and Guidelines. Skilled in Planning, Design, Development, Implementation and Maintenance phases of the project. Expertise includes Estimation, Proposal, SOW, Project Planning, Project Budget Control, Data Modeling, Architectural Design, Detailed Design and Development of applications.
• Functional expertise includes Financials, Retail, Pharmacy claims and Billing, Healthcare, Insurance, Airlines - Ticketing and Booking, Credit Card Processing and Manufacturing. Experience in ERP includes Customer Data Management, Customer Data Hub, Order Entry, Billing, General Ledger, Accounts Receivable, Accounts Payable, Inventory, Purchasing, Budgeting Costing modules.

Technology Experience Summary:

Role Summary:

Technical expertise includes:

Databases: Oracle 11.x Oracle 10.x, Oracle 9.x, Oracle 8.x, Oracle 7.x, UDB DB2 8.x, iSeries DB2, Ingres 6.x,

Design and Development Tools: Ab Initio Cooperating System version 3.1, 2.13.1, Ab Initio Graphical Development Environment GDE Versions 1.16, 3.0, 3.1, Ab Initio Enterprise Meta Environment EME , Unix Shell Scripts, SAP FICO, SD, MM, PM, , Oracle Financials, Oracle Developer Release 6.0, Oracle Development Server, Oracle Application Server, Oracle Fail Safe 3.0, Developer 2000 Oracle Forms, Oracle Reports, SQL Forms 3.0, SQL Reports 1.1, PL/SQL, COBOL, C, Designer 2000, EasyCase, Erwin, Power Designer, SQLPLUS, SQL DBA, SQL Loader, SQL, TOAD, SQL Developer, PRO C, Vifred, PeopleSoft - PeopleTools, PeopleCode, Crystal Reports, Brio, Essbase, Rational ClearQuest, Rational ClearCase

Project Experience

Confidenital

Role: Data Architect

Responsible for Data Model, ETL architecture and Tech Lead for Loss Given Default LGD Project which measures the percentage of loss over the total exposure when bank's counterparty goes to default using Data Stage against Oracle 11.2 database. Created Logical and Physical Data Model, Database objects Tables, Views, Indexes, performance tuning of long running SQLs, provided Solution Design in terms of Data Flow and Process Flow, Also, in the capacity of Tech Lead, led a development team in planning, control and execution of ETL Development and Implementation. Proactively supervised day to day operational issues that arose during data conversion and test cycles and worked with other teams and Business to track issues and close defects.

Confidenital

Role: Data Migration ETL Lead

Responsible for entire ETL Architecture of Data migration of 40 databases from DB2/400 to Oracle 11.2 on Solaris using Ab Initio, Responsible for ETL Design and development of Ab Initio Graphs, Unix Shell scripts, creation of Job Dependency Diagrams, planning of execution of jobs in Production. Architected an Ab Initio Solution to read XML data stored as BLOB in Oracle Database and invoking Ab Initio graphs as a Web Service using SOAP XML from Java EE Application Server to create hundreds of data files to be sent to Mainframe.

Confidenital

Role: Data Lead

As Data Lead responsible for Data Cleansing and Data Conversion activities of SAP deployment of Finance and Control FICO , Sales and Distribution SD , Materials Management MM Inventory Management and Warehouse Management, Production Planning and Control and Plant Maintenance PM at multiple sites.

Confidenital

Role: ETL Architect and Data Architect

• Achieved recognition for dramatically improving the batch run time from more than 14 hours to around 7 hours. Using Ab Initio tools and Oracle performance tuning capabilities in a multi-terabyte Oracle database on AIX , I was single-handedly responsible for several such performance improvement initiatives. Both batch and online processes saw remarkable performance improvements saving the company millions of dollars and enabling multiple service level agreements to be exceeded.
• Lead Data Architect for development of many Ab Initio graphs to process multi-million rows of data from various sources and apply complex logic and load them into Oracle 9.x, 10.x database tables. Key contributor for Data Modeling, Data Sizing, Logical and Physical Design of tables and creation of DDLs. Responsible for assisting project manager in project tasks, estimation of timelines and project risk.

Confidenital

Role: ETL Architect and Data Architect

• Responsible for design and development of terra byte size data mart in Enterprise Data Warehouse using Ab Initio on UDB DB2. Responsible for development of many Ab Initio graphs in Ab Initio EME environment to read large volume of data, apply complex logic and load them into data mart tables. Responsible for creation of Meta data for tables and columns of data mart tables. Responsible for creating data and outline files for building Essbase OLAB Cubes.
• Designed and developed an application to match billing transactions from various Global Distribution Systems against Internal Booking data in Enterprise Data Warehouse and store them in Enterprise Data Warehouse. This project followed the Sarbanes-Oxley requirement guidelines. Responsible for design of tables, creation of Meta data for tables and columns, development of many Ab Initio graphs and development of Unix Shell scripts.
• Led a team of professionals in global implementation of Web based application to track performance against plan for international sales managers using Java, Web Sphere and Oracle 9.x database. Responsible for project planning and coordination, review of statement of work, business analysis, data model physical and logical, design.
• A team member in implementation of Oracle Application E-Business suite Customer Data Management Customer Data Hub module, for centralized storage of customers with single source of truth.

Confidenital

Role: Technical Lead, ETL Architect and Data Architect

As the Technical Module Lead for development team responsible for multi-terabyte Prospect Pool Oracle Database with scoring models. Responsible for Design and Development of many graphs using ETL Tool Ab Initio, creation of dynamic DMLs for file layouts, Dynamic Transform Functions, setup of Unix environments and development of shell scripts. Designed and developed a code generator for Ab Initio transform functions using Shell scripts. Designed and developed a Meta data driven dynamic code generation environment. Responsible for assisting project manager in project tasks, estimation of timelines and project risk.

Confidenital

Role: Technical Manager and Lead Database Administrator

As the primary Oracle DBA for Wireless Application Protocol WAP Gateway Implementation for the Mobile Client and Instant Messaging project, administered high availability implementation of Oracle Database 8i using Oracle Fail Safe on Windows NT and also responsible for Data Modeling, Physical and Logical Database Design, Installation of Oracle 8i, Creation of Databases, Creation of Tablespaces, Data Files, Creation of Database Objects like Tables, Views, Indexes, Synonyms, Oracle procedures calling external C functions in DLL, Development of Database Scripts, Solaris Unix Shell Scripts, Performance Tuning and General Database Support.

Role: Data Architect

Responsible for data modeling, development of stored PL/SQL procedures, database triggers and web enabled forms and reports using Oracle Developer 6.0 and Oracle Designer on Oracle 8.0 database and Oracle Application Server 4.0.

Confidenital

Role: Technical Lead and Data Architect

Responsible for Statement of Work, Project Management, Project Budget, Function Point analysis, project planning, Business analysis, data modeling, architectural design, Detailed Design for the project and development of data interfaces for a Managed Care Project.

Confidenital

Manager, Oracle Practice

• Managed a team in custom development of Accounts Receivable application using Oracle Developer 2000 tool set on Oracle 7.x on Unix. Responsible for Project Proposal, Statement of Work, Project Management, Budget, Function Point analysis, project planning, Business analysis, data modeling, architectural design, Detailed Design and map and gap analysis of customer requirements with Account Receivable module of Oracle Applications.
• Managed a team in implementation of Purchase module of PeopleSoft on Oracle 7.x using EasyCase, PeopleTools, People Code, SQR, nVision, Crystal Reports, SQL Loader, SQL DBA, PL/SQL. Responsible for Project Feasibility Analysis, Statement of Work, Project Management, Project Planning, Project Budget, logical and physical data modeling, architectural design and detailed design, map and gap analysis, customization of PeopleSoft Purchasing, defining operator security and development of data interfaces.
• Involved in testing and Quality Assurance effort of a conversion project and responsible for analysis, design and development of validation reports for the core functionality of the business system developed database procedures PL/SQL , forms and reports using developer 2000 tools - Oracle Forms 4.5 and Oracle Reports 2.5. Responsible for staffing and mentoring of few developers.

Confidenital

Role: Project Manager and Technical Lead

Responsible for Project Proposal, Statement of Work, Project Management, Function Point analysis, project planning, Business analysis, data modeling, architectural design, Detailed Design and development of Workers Compensation system using Oracle 7.x on Unix using structured Systems Analysis and Design Methods

Confidenital

Role: Lead Designer and Developer

Customized and fine-tuned reports in Budgeting and Purchasing modules of Oracle Financials for the corporate division of Honeywell using Oracle Reports 2.0.. Played a major role in the customization of existing SQL Forms 3.0 based applications running against Oracle 7.x database and in the development of few PL/SQL database procedures and triggers.

Confidenital

Role: Team Manager and Lead Architect

Led a team of 14 professionals in full life cycle development of Order Entry, Billing, Accounts Receivable, General Ledger, Accounts Payable, Inventory and Purchase modules using ISO 9000 quality Responsible for Project Proposal, Project Management, Function Point analysis, project planning, Project Budget Control, Business analysis, data modeling, architectural design, Detailed Design, development of data interfaces and mentoring few developers. Managerial responsibilities included Performance Appraisal, Project Cost Control, Customer Satisfaction, Employee Development, training coordination, and staffing