Professional Summary

• Highly pro-active individual with a ‘Can Do’ attitude, having more than 14 yrs of IT experience spanning across datawarehousing, software development and Oracle Financials.
• Skilled professional in Business Intelligence & Data warehousing design, development, testing and deployment.
• Excellent in providing Data Warehouse and ETL Design including solutions for handling large volume of data and near real time data warehousing.
• Excellent in data warehouse concepts and dimensional modeling (Star Schema) using Kimball methodology.
• Strong in writing Oracle stored procedures (PLSQL), Complex SQLs, Performance tuning of SQL & PLSQL codes. Excellent in using oracle features such as partitioning, partition pruning, regular expressions, SQL loader, external table and analytical functions.
• Excellent in designing ETL mappings using Oracle Warehouse Builder (OWB) 11gR2/11g/10g/9i. Experience includes using other ETL tools such as Informatica and Objects Data Integrator (BODI).
• Have a fair understanding of UNIX shell scripts required for formatting files, custom written scheduling tools and wrapper scripts to call oracle procedures.
• Trained and hands on experience in using Business Objects XI R2 and Oracle Business Intelligence Enterprise Edition (OBIEE).
• Have experience of around 5 yrs in Oracle Applications
• Have a good experience of working with Oracle Applications as a source to load data into Datawarehouse.
• Strong in transforming user requirement into technical specifications. Excellent in writing solution design, mapping specification and test cases. Involved in review of Impact Assessment, Solution design, Specifications, code and test cases.
• Very good at production support, solving critical problems and answering to business user queries.
• Developed templates for Solution Design, Detailed Speciation, Unit Test Cases and Coding Standards, Checklists & Module tracking templates. And Contributed to the development of Enterprise Data warehouse strategies and standards.
• Excellent team leader/player, good at time management, ability to prioritize tasks, meets deadlines and work under pressure. Proven track record of learning new technologies. Hands on experience in technically leading a development team.
• Can effectively communicate problems and solutions to the team members and non-technical staffs through presentations and documents.
• Functional knowledge includes Health, Utility, Asset Management and Railway traffic management.
• Supporting programme and project managers in planning, estimating and controlling the project delivery.
• Experience in complete System Development Life cycle.

Technical Skills

Primary Skills

ETL Tools:

OWB 11g R1, 11gR2, 10g ,9i 3.0, Informatica 7.5, WhereScape Red, BODI

Database:

Oracle 8.x, 9i, 10g & 11g

Database Tools:

Oracle SQL & PLSQL, SQL Loader, Oracle Enterprise Manager, Process Flow, Oracle CDC

Case Tools:

Visio, Erwin 7

Developer Tools:

SQL Developer 7.0, Toad 9.x

Scripting Language:

UNIX Shell Script, OMBPlus Scripting

Version Control Tools:

CVS, PVCS

ERP System:

Oracle Financials 11i

Business Intelligence Tools:

Business Objects XI 3.0, OBIEE

Project Details

Client: Confidential,Sept ’06 – Till Date

Project: Business Intelligence for Confidential,

• Accountable for overall architecture of the solution and ETL design aiming for agile development methodology.
• Accountable for designing ETL for loading Staging Layer, Foundation Layer and Presentation Layer (Datamart).
• Mentored and guided the development team and acted as interface to the test team.
• Accountable for performance improvement of OWB mappings, framework testing, Business Objects universe and report development.
• Data was sourced from Oracle ERP and other Oracle database.

Tools used are Wherescape Red, Oracle OWB, Oracle CDC, Oracle 11g on RAC, Oracle workflow / process flow and Business Objects XI R2

Project: KPI Programme

• Improved team productivity by creating unit test case, KPI design and mapping specification templates.
• Performed code reviews to ensure compliance with detailed design.
• Design and built ETL process flow, error recovery and data load automation.

Tools used are Business Objects Data Integrator (BODI) and Oracle 10g Database.

Project: Shiftlogic

• Accountable for designing ETL for loading data from a Oracle Database into Oracle HRMS
• Created OWB mappings and Process Flows.
• Created Oracle Scheduler jobs to be called from Oracle Apps

Tools used are Oracle HRMS, Oracle OWB, Oracle 11g, Oracle workflow / process flow

Project: Migration OWB 9i to OWB 10g to OWB 11gR1

• Involved in upgrading the existing Datawarehouse by including the new source and migrating from OWB 9i to OWB 10g and then finally to OWB 11gR1
• Developed OMBPlus Scripts to automate the migration process.
• Installed and Create OWB11g environment for all migrating projects
• Produced documents to support the migration routines and testing.
• Mentored the team to learn OMB Scripting

Tools used are Oracle OWB, Oracle 11g, and Oracle workflow / process flow

Client: Credit Suisse, Aug ’05 – Aug ’06

Project: Confidential,Datawarehousing Project

• Re-designing and tuning performance hindered Data Warehouse jobs developed using Informatica 7.1 and Oracle PLSQL.
• Involved in creating few Informatica Mappings and creating Pl/Sql packages
• Was also involved in the ETL Testing
• Tuned SQLs, PLSQL procedures & packages.

Tools used are Informatica Powercenter 7.11, PLSQL, UNIX scripts, Oracle 9i, Sql*Loader.

Client: Confidential,Jul ’04 – Jul ’05

Project: Datawarehousing Project

• Was responsible to install and create an OWB environment
• Involved in developing OWB mappings to source data from Oracle HRMS system
• Was also responsible to set the best practices for OWB Development
• Involved in performance tuning and managing the Oracle Development database.
• Involved in creating Discoverer Reports and administer the Discoverer EUL.
• Was also responsible to assist the testing team

Tools used are OWB9i, Oracle Discoverer 9i, PLSQL, Oracle 9i, TOAD, SqlPlus, and Oracle Workflow
Client: Confidential,Feb ’03 – May ’04

Project: Datawarehousing Project

• Involved in developing, and testing OWB mappings
• Involved in writing OMBPlus scripts to create generic mappings
• Involved in performance tuning and managing the Oracle Development database.
• Was also responsible to assist the testing and the support team
• Involved in mentoring the team members to learn OWB

Tools used are OWB9i, PLSQL, Oracle 9i, TOAD, SqlPlus, SqlLoader and Oracle Workflow
Client: Confidential,Sept ’01 – Nov ’02

Project: Datawarehousing Project

• Involved in developing, and testing OWB mappings
• Involved in performance tuning and managing the Oracle Development database.
• Involved in developing OWB mappings to source data from Oracle ERP system
• Was also responsible to assist the testing team

Tools used are OWB3.0, PLSQL, Oracle 8x, TOAD, SqlPlus, SqlLoader
Project: Oracle Financials 11i

• Involved in creating bespoke procedures as per Oracle Standards to meet the business requirements.
• Involved in performance tuning and managing the Oracle Development database.
• Involved in creating EDI process to load vendor data onto the ERP system
• Involved in creating Oracle Forms and Oracle Reports

Tools used are Oracle Financials 11i, Oracle 8x, PLSQL, TOAD, SqlPlus, SqlLoader
Oracle Financials Modules : AR/AP/GL/INVENTORY/ ASSETS

Company : Confidential,Apr ’97 – Aug ’01

Client: Confidential,

Project: Siebel CRM

• Involved in creating batch applications to load data into Siebel tables.
• Involved in performance tuning and managing the Oracle Development database.
• Involved in creating procedures to run the scheduled jobs.
• Assisted the testing team

Tools used are SqlPlus, PLSQL, Oracle 7x, TOAD, SqlLoader

Client: Confidential,

Project: Oracle Financials 11i

• Involved in creating bespoke procedures as per Oracle Standards to meet the business requirements.
• Involved in performance tuning and managing the Oracle Development database.
• Involved in creating Oracle Forms, Oracle Reports and bespoke plsql routines

Tools used are Oracle Financials 11i, Oracle 8x, PLSQL, TOAD, SqlPlus, SqlLoader, Oracle Forms 4.5, Oracle Reports 4.5
Oracle Financials Modules: AR/AP/GL/INVENTORY/ ASSETS

Client: Confidential,

Project: DataLoad To Sage

• Involved in understanding the business requirements.
• Involved in creating and designing a Oracle Framework to load data from Oracle tables to SAGE.
• Involved in Testing and documenting the process

Tools used are SqlPlus, PLSQL, Oracle 7x, SqlLoader