Puneet Arora

**** ******* ******, *********, **********, United States Ph: 714-***-**** Email - rg8kg2@r.postjobfree.com

Summary of Experience

• 10+ years of experience in Business Intelligence – Functional Head and DWH Solution Architect.

• Business Planning, Financial Forecasting & Budgeting and analyzing the economic conditions and draft business expansion plans and strategies

• Business strategy to aid organizational goals and performing the root cause analysis to evaluate the failure or diversions on implementation of BI plans

• Evaluation of the BI plans, judge the feasibility and effectiveness of the BI plans and managing the functioning of the BI Department and making sure the success of its activities

• Perform market research to gather information about current market trends and analyzing the prevailing economic conditions and judge the receptiveness of the markets towards the business projects

• Advise the organization on tapping the business opportunities and managing risks and suggesting ways to raise finance or improve goodwill on studying the market behavior

• Perform market research and analysis to provide foundation to the management for drafting business plans

• Collect statistics of previous profit and sales targets and evaluate the trends and support the organizational heads in drafting departmental goals and policies

• Working as Project Manager for CSC and responsible for building and enhancement of the customer operation applications for BI Apps in an integrated environment with Oracle Apps - EBS, Siebel CRM and SAP

• Managed Development and Migration projects (data migration, source migration and software migration) and led Product life-cycle processes.

• Prepared resource planning, project management planning and roadmap planning followed by Report Requirement Documents (RRD) and Business Requirement Documents (BRD)

• Extensive hands on experience in Business Process Analysis, Designing and Dimension Modeling.

• Experience in more than eight domains – Healthcare, Finance, Banking, Pharmaceutical, Telecom, Service, Supply Chain, Automotive, Call Center and Campaign Management

• Extensive experience with different version of EBS (R11, R12) and OBIEE

• Comprehensive experience on all versions of Oracle BI (beyond 7.7 to 10.1.3.3), Siebel – CRM (7.5 – 8.0) and Informatica (6.0 – 8.0)

• Implemented 10 BI projects with 9 in OBIEE and 1 in Business Objects

• Extensive experience with the latest technologies -

1. EBS

2. SAP

3. Siebel – CRM

4. OBIEE

5. Business Objects

6. Informatica

• Multi cultural work experience across different countries including US, UK, Sweden, India and Australia

Industry Experience

Computer Science Corporation Project Manager - Principal Oct 2010 – Present

Managing a team of 18 members and responsible for building up of the BI Financial Analytics Application with EBS R12.

Responsibilities include designing the architecture of the OBIEE Financial Analytic Application and ETL for data transformation from EBS System to Data warehouse

Industry Applications Role Major Responsibilities Duration

Healthcare

Los Angeles, CA • OBI

• Oracle Apps EBS

• Informatica

• DAC

• SQL/PL-SQL Advanced Project Director

Team size - 24 • Managing a team of 24 members

• Project Management

• Project Planning and Risk Management

• Responsible for Customer Operations Apps

• Interfacing with different business teams for requirement analysis and path making

• Designing the architecture for the data warehouse

• Dimensional Modeling

• Designing the ETL Architecture 12+ months - Present

Capgemini Consulting Project Lead Nov 2006 – Oct 2010

I have worked as Program Director with Capgemini for deploying numerous Business Intelligence Applications which includes Marketing Analytics as well.

Accomplished 4 project overseas in countries, Australia, Sweden, Germany and Denmark and rewarded as the Project Star award for all the projects.

Project Experience:

Industry Applications Role Major Responsibilities Duration

Computers Manufacturer

Austin, TX • OBI

• Siebel - CRM

• Informatica

• DAC

• SQL/PL-SQL Advanced Project Director

Team size – 50+ • Project Planning and Management

• Requirement Analysis with Business Requirement Document

• Sr. Architect of the data warehouse

• Data Transformation from Siebel CRM to data warehouse

• Designing STAR/Snowflake schemas in OBI Repository and Dimensional Modeling

• Scheduling the data load through DAC

• Deployment of the phased releases 18 months

Telecom

San Jose, CA • OBI

• Siebel - CRM

• Informatica

• Dollar U

• SQL/PL-SQL Advanced Project Manager

Team Size – 80+ • Interface between the business and the team

• Responsible for the design of the star schema in OLAP

• Data Transformation from 3 systems to data warehouse

• Report Requirement Document on Supply Chain

• Scheduling the data load through Dollar U

• Creation of iBots, dashboards, complex reports 6 months

Telecom

Atlanta, GA • BO Xi R2

• Siebel - CRM

• SAS

• Informatica

• DAC

• SQL/PL-SQL Advanced Senior Technical Analyst /Business Analyst

Team Size - 34 • Requirement Analysis with the business teams

• Architect of the data warehouse

• Data Transformation from 6 systems to data warehouse

• Data filtration through PL/SQL logic

• Scheduling the data load through DAC

• Statistical computation of the data through SAS

• Report Requirement Document on telecom regulations

• Creation of dashboards, pages and reports embed in iBots 10 months

Automobile

Goteborg, Sweden • OBI

• Siebel - CRM

• Informatica

• DAC

• Marketing Analytics

• SQL/PL-SQL Advanced Project Manager

Team Size – 22 • Creation of High Level Design and Detailed Design Document on the basis of Business Req. Document

• Campaign Designing and Segmentation of target customers based on different business criteria

• Data transformation from Siebel CRM to OBIEE

• Designing of the campaign STAR model

• Implementation of Marketing Application from scratch 8 months

Real Estate

Sydney, Australia • OBI

• Siebel - CRM

• Informatica

• DAC

• Marketing Analytics Project Lead

Team Size - 13 • Designing the STAR model for the historical Analytics

• Designing snowflake model for the campaign designing

• Data transformation through Informatica

• Scheduling the loading of the data through DAC 3 months

Banking

Sydney, Australia • OBI

• Siebel - CRM

• Informatica

• DAC

• SQL/PL-SQL Advanced Project Lead

Team Size - 18 • Requirement gathering from different divisions of bank

• Designing STAR and Snowflake schema in OBI RPD

• Implementation of ETL routines in Informatica

• Director to the release of 7 applications

• Deployment of the applications through ‘Control M’ 4 months

Cognizant Technology Solutions Data warehouse Architect May 2003 - Jun 2006

Senior DWH Architect to data warehousing applications comprising technologies Oracle BI and Informatica

Project Experience:

Industry Applications Role Major Responsibilities Duration

Retail

London, UK • OBI

• Siebel - CRM

• Informatica

• DAC

• Marketing Analytics

• SQL/PL-SQL Advanced Senior Architect

Team Size - 15 • Requirement gathering from different business teams

• Designing STAR and Snowflake data model for campaign designing

• Data massaging through Informatica

• Designing the architecture of OLAP data model 5 months

Pharmaceutical,

India • OBI

• Siebel - CRM

• Informatica

• DAC

• SQL/PL-SQL Advanced Senior Architect

Team Size - 20 • Architect of the data warehouse

• Preparation of Business Requirement Document

• Creation of High Level and detailed design Documents

• Extraction of data from Siebel CRM through Informatica

• Designing STAR model in OBI Repository

• Scheduling the data load through DAC

• Deployment of the phased releases 2 years

Detailed Experience by project (in reverse chronological order):

Project 10

Client: Healthcare, Los Angeles, CA

Description: The project is to revamp the existing application in OBIEE 10g followed by up gradation to 11g for AMERICAS and EMEA region together with the R12 EBS Apps.

Key Responsibilities:-

• Working as Project Manager responsible for the implementation and enhance of the Customer Operations BI Apps

• Project Planning and Project Management

• Risk planning and management

• QA Analytics

• Requirement gathering from the business teams

• Designing the architecture of the data warehouse

• Solely responsible for the designing of the of the dimensional model of the data warehouse

• Leading a team of 24 with responsibility for the GO LIVE of the various phased releases

• Desinging the ETL architecture through Informatica

• Expertise with the extraction of data from different source systems such as SAP, EBS and Siebel - CRM and flat files

• Structuring the nightly refresh of data load and scheduling it through DAC (Data warehouse administration Console)

• Implementation of the data level and view level security

Accomplishments:-

• Implemented re-structuring of DAC which reduces nightly refresh from 12 hours to 5 hours

• Upgraded OBIEE 10g to 11g successfully with 10g being a 70% customized BI Apps comprising Service, SCM, HR< CommOps and sales module

Project 9

Client: Computer manufacturer, Round Rock, Tx

Description: The project is to build an application in OBI (Oracle Business Intelligence) for AMERICAS, EMEA and APAJ region. It involves the system study and henceforth building up of the application on software quality and tracking of the activities over a geographical region

Key Responsibilities:-

• Working as a Technical Project Manager responsible for requirement gathering from the business teams followed by preparation of BRD

• Solely responsible for the designing of the of the data model of the data warehouse

• Architect for the data warehouse

• Leading a team of 3 with responsibility for the GO LIVE of the various phased releases

• Developed star schema and complete data model in the OBIEE repository as per the best practices by Oracle/Siebel

• Extraction of data through ETL - Informatica from OLTP and flat files

• Near real time reporting by an ETL – Informatica process which brings the data in 3 minutes in business hours

• Nightly load scheduled through Data warehouse administration Console

• Designing of High Level and Detailed Design Documents comprising details of 4 STAR created in OBI repository

• Involved in the creation of complex reports, dashboards and iBots for various business users of the application across geographical regions incl. NA, EMEA, APAJ

• Implementation of the data level and object level security

Accomplishments:-

• Invented new methodology for near real time reporting with OBIEE with a lag of just 3 minutes from transactional system

• Deployed 9 releases in record breaking time of 14 months

Project 8

Client: Telecom, San Jose, CA

Description: The project is to build an application in OBI (Oracle Business Intelligence) which helps business in making faster decisions on the supply chain management. It involves the system study followed by building up of the business reporting application Key Responsibilities:-

• Project Director for all the phased release for the BI Apps

• Responsible for requirement analysis from different business teams/users

• Responsible for Business Requirement Document (BRD) and Report mockups

• Creation of High Level Design Document on the basis of BRD and getting it approved from change management team

• Designing of High Level and Detailed Design Documents

• Diemnsional modeling in OBIEE

• Extracted data from 6 different legacy systems to the warehouse through Informatica

• Scheduling the data load via Dollar U

• Creation of iBots, reports and embedding them into the dashboards

Accomplishments:-

• Implemented an OBI supply chain management reporting application based on three analytics repositories

Project 7

Client: Telecom, Atlanta, GA

Description: The project is a challenge to convert existing 138 systems to 18 systems. There were four modules of reporting:

PAP Reports - Performance Assurance Plan

PUC Report - Public Utility Commission

Regulatory Reports - Reports needed by Regulatory Authority of United States

Wholesale Reports - Reports meant for accountability of the wholesale business

Kenan, Siebel, Metasolv, Remedy, Wisor, etc were the source systems to the data marts of warehouse. The development comprises extraction of data from these source systems through Informatica followed by filtration through PL/SQL proc.

Key Responsibilities:-

• Developed nine business models in the repository. Developed several reports for Kenan Billing System, Siebel System, WISOR System, Metasolv System and Remedy System

• Responsible for successful deployment of performance assurance plan, public utility commission of United States, wholesale and regulatory reports

• Gathered and documented requirements using BRDs and developed several reports, dashboards and star schemas on Sales and Finance data

• Extraction of data through five transactional systems to the warehouse with sources in XML through ETL - Informatica and data massaging using PL/SQL

• Created STAR model in 7 Universe in BOXiR2 repository metadata

• Designing of High Level and Detailed Design Documents

• Solely responsible for the Design Phase of the project and for the designing of the Data Model of the Warehouse

• Developed the architecture of the warehouse and implementation of the reporting solutions. Also involved in the creation of complex reports

Accomplishments:-

• Extracted data of telecom products from 8 legacy systems and used a unique concept of USOC’s for de-duplication

• Designed product matrix for 8 systems by assigning product code to each telecom product

Project 6

Client: Automotive, Sweden

Description: The project involves implementation in ORACLE BI v7.9.3 from scratch on Marketing Analytics. The development comprises extraction of data from SIEBEL OLTP and loading to SIEBEL SRMW with the help of ETL Tool – Informatica v7.1.4 in addition to the designing of conventional Analytics and major Marketing Analytics Application together with Informatica Repository. DAC is implemented to run the ETL Routines

Key Responsibilities:-

• Project Planning and Management

• Managing a team of more than 30 members

• Designing of High Level and Detailed Design Documents

• Solely responsible for the design and implementation of the Data Model of the Warehouse with GO LIVE

• Creation of ETL Routines for the extraction of data from the Siebel Marketing to the warehouse along with slowly changing dimensions type 2 for reporting solutions on historical data

• Scheduling of the ETL Routines through new latest version of DAC 7.9.3

• Designed Data Model for List Export Functionality and Campaign Load Formats

• Designed Data Model for Campaign Management used in Marketing Analytics

• Implementation of Segmentation metadata incl. Segmentation Catalog and Target Levels

• Implementing metadata for cache tables and management of Marketing Jobs

• Implementation of write-back into the Siebel Transactional Database from Analytics

• Configuring DAC for Oracle BI application v7.9.3

Accomplishments:-

• Implemented Marketing Analytics Application alone as an independent contributor on v8.0 in OBI

Project 5

Client: Real Estate, Sydney-Australia

Description: Project is to track the activities of the Order Line Items till the activity is closed followed by performance, revenues and profit check. Marketing Analytics Application was also implemented with write back functionality. Creation of Segmentation Catalog, Cache Management and Target Levels were key highlights. Project was accomplished in Sydney

Key Responsibilities:-

• Project owner and Lead to the BI Apps which includes deployment of the BI Apps followed by its maintenance

• Requirement gathering from client and preparation of the BRD followed by High Level and Detailed Design Documents.

• Designing and Implementation of the architecture of the Ware house for the Marketing metadata as well as OBI metadata

• Building of the Informatica repository with creation of new mappings responsible for the extraction of data from Siebel Transactional and Siebel Marketing module of Siebel CRM to the warehouse

• Scheduling of the data load from DAC on a daily, weekly and monthly basis

• Designing of Data Model for the reporting to be based upon the activity along with List Export Functionality and Campaign Load Formats and Campaign Management used in Marketing Analytics

• Implementation of Segmentation metadata incl. Segmentation Catalog and Target Levels

• Implementing metadata for cache tables and management of Marketing Jobs

• Implementation of write-back into the Siebel Transactional Database from Analytics

• Working as an independent consultant right through the design phase to development and deployment

Accomplishments:-

• Implemented Marketing OBI and historical analytics application alone as an independent contributor

Project 4

Client: Bank, Sydney-Australia

Description: The project involves End-to-End Implementation with data extraction from SIEBEL Relational Management to Data Warehouse through ETL – Informatica followed by creation of data model in OBI repository and creation of numerous dashboards and iBots for the business users. Project was accomplished in Sydney, Australia

Key Responsibilities:-

• Director of the annual release of seven applications for the bank, one of which is designed and implemented alone by me

• Implementation of a credit card application, Oregon, and the profit and loss analysis application of each branch of the bank across the nation. It includes 27 standard reports along with 15 adhoc reports

• Responsible for the Design of the data model and the star schemas within the warehouse

• Extraction of the data through ETL – Informatica from the Siebel Transactional System to EDW

• Implemented alone as an independent consultant right through the design phase to development and deployment

Accomplishments:-

• Director at the client side to 7 applications. Responsible for the successful deployment of the applications in production

Project 3

Client: Machine Manufacturer, UK

Description: The project comprises implementation of Marketing Analytics application from scratch. Project was accomplished at UK followed by demonstration before the client in London

Key Responsibilities:

• Design the Architecture of the data warehouse and responsible for dimensional modeling

• Creation of ETL Routines through Informatica and scheduling of the mapping through DAC

• ETL includes Creation of SCDs’ (Slowly Changing Dimensions) to capture history data

• Designing of the Repository metadata for conventional Analytics application and Marketing Analytics metadata

• Designing of Data Model for List Export Functionality and Segmentation

• Creation of Reports in Oracle Business Intelligence Web

Accomplishments:-

• Implemented Marketing Analytics in OBI, being the first in the organization

Project 2

Client: Pharmaceutical, EMEA

Description: Project comprises implementation of ECMS (Electronic Customer Management System) Application in Siebel Analytics 7.7. Challenge was to develop the core application and customize it in order to meet “country specific requirements” of for 27 countries worldwide

Key Responsibilities:-

• Senior developer & KMO (Knowledge Management Owner)

• Using the Siebel Administration tool to develop and enhance the meta-data

• Creation of Detailed System & Technical Documents

• Creation of STAR models in the OBI repository

• Using Siebel Answers to design new dashboards, graphical reports, prompts and filters

• Customizing the look and feel of the Dashboards in Oracle Business Intelligence

• Leading a team of developers

Accomplishments:-

• Implemented customized OBI application with multi-lingual feature which was launched 27 countries worldwide

Project 1

Client: Pharmaceutical, EMEA

Description: Implementation of a multi-lingual application in Siebel Analytics 7.7 for three countries Denmark, Norway and Finland

Key Responsibilities:-

• Designing the Data Model of the repository with multi-lingual feature

• Creation of dashboards with drill-down feature, designing graphical and tabular reports, developing prompts and filters

• Application was created in three phases which was launched in 27 countries in APAC, EMEA and US region.

• Interfacing with business for requirement gathering and building up the design of the data model for the warehouse.

• Responsible for the creation of ETL Routines through Informatica and scheduling them through DAC

• ETL includes Creation of SCDs’ (Slowly Changing Dimensions) to capture historical data

Accomplishments:-

• Implemented OBI application with teradata as the database of size 2.8 terabytes

• Imparted training to 8000 business users for the expertise use of sales force automation and OBI application

Education:

MMMEC Gorakhpur, India (Consistently ranked in top 15 technology schools in India)

Relative Cumulative GPA: 3 .90 / 4.0

BS in Electrical Engineering – Merit List and Scholarship Winner in all four years

Skills: Strong expertise in following areas –

Database: Oracle, Teradata, MS-Access

Database language: PL/SQL Advanced, SQL Advanced

Reporting Applications - Oracle Business Intelligence (OBI), Business Objects

Scheduler - Data warehouse Administration Console, Dollar U

Known Source System Applications - Siebel – CRM, Kenan, Metasolv, Remedy, Billing Revenue Management

Data massager and data loader Applications - Informatica, Data stage

Deployment Application – Control M

KPI’s:

Build Business Intelligence Practice in Cap Gemini and Cognizant Technology Solutions

Initiated Marketing Analytics and Campaign Designing in Cap Gemini

Imparted training to more than 40 professionals in Marketing Analytics, OBI and Informatica in Cap Gemini

Contact this candidate