PROFESSIONAL EXPERIENCE:

Stancorp Financial Group
Senior Consultant Nov 2004- Current

 Lead ETL developer/architect for a Data Warehouse implementation
 Designed, developed and documented ETL best practices
 Designed and developed ETL jobs for Data warehousing using Data Integrator
 Full project life cycle experience including analysis, requirements gathering, data modeling, ETL, reporting and maintenance
 Optimized Database, and ETL processes for improved performance

Capgemini (Cap Gemini Ernst and Young)
Principal Consultant Nov 2000- Nov 2004

 Lead technical consultant for a global DW implementation
 Full project life cycle experience including analysis, requirements gathering, data modeling, ETL, reporting and maintenance
 Developed ETL using Business Objects Data Integrator (Acta)
 Performed database and SQL tuning for ETL, Reporting and Data analysis
 Designed and developed incremental load strategies for net change extraction and loading
 Designed and developed PL/SQL procedures for handling complex ETL processes
 Troubleshoot and fix production ETL and Reporting issues
 Oracle database administrator for a global Data warehouse and SAP R/3.
 Responsible for Oracle logical and physical databases design, implementation and maintenance on Sun Solaris.
 Designed and implemented database and application level security
 Designed and developed Business Objects Universes and Reports
 Created Perl scripts for interface architecture and system monitoring.

Solutia Inc, Houston, Texas
Lead ETL Analyst Sep 98- Nov 2000

 Served as Extract, Transform, Load (ETL) lead for a large-scale data warehouse implementation having multiple sources including SAP, LIMS etc
 Defined strategy, methods, processes and tools for ETL and storing it within Oracle data warehouse
 Developed complex SQL, PL/SQL and shell scripts for ETL
 Worked with developers to design and develop Business Objects reports from the data warehouse
 Provided Oracle database administrative support to Solutia Inc.
 Responsible for Oracle7/8/8i logical and physical databases design, implementation and maintenance on Windows NT, HP UNIX and VMS.
 Member of Enterprise DBA team responsible for developing standards for enterprise
 Provided database and application tuning
 Mentor for application developers

Shipco Logistics, Houston, USA
DBA/ Basis Admin March 98 – Sep 98

 Performed Basis Administration for SAP R/3 development system
 Database and application performance tuning
 Designed and developed SAP interfacing systems for barcode reading and paperless transactions using Remote Function Calls.
 Programmed in ABAP/4, 'C' and Power Builder

Center for Geographic Information Systems, State of Qatar
Technical lead April 96 - March 98

 Modeled Business Geographic data warehouse using Designer/2000.
 Developed strategy, methods and processes for extracting , transforming and loading data to Oracle data warehouse
 Supported development efforts towards achieving integrated and user friendly applications.
 Responsible for Oracle 7 logical and physical databases design, implementation and maintenance on UNIX.
 Tuned ETL and Reports
 Mentor for application developers

Center for Geographic Information Systems, State of Qatar
Analyst/Programmer May 95 - March 96

 Developed Decision Support System for Vehicle Routing and CGIS Inventory Tracking system using ArcView and Oracle Developer/2000
 Developed Forms, Reports, PL/SQL packages and stored procedures
 Provided User Support & Documentation

Tata Electric Companies, Bombay, India
Analyst/Programmer March 94 - March 95

 Developed Perpetual Inventory Control and Cash Purchase System for IMMMS (Integrated Materials and Maintenance Management System)
 Developed PL/SQL procedures and triggers
 Team Member - Business Process Reengineering


MICO, Bangalore, India
Application developer/ Mathematical Modeler June 93 - Feb 94

 Developed Distribution Center Replenishment System
 Performed Mathematical modeling, application design and development of the system in Turbo 'C'.

EDUCATION:

 Oracle Certified Professional (OCP)
 M.S. in Management Studies from Indian Institute of Science, Bangalore, 1994
 B.S. in Engineering from Kerala University, 1991