OBIEE Developer

RAHUL ARORA

********@*******.*** / 510-***-****

CAREER SYNOPSIS

An accomplished Senior Technical Lead with an overall experience of 15 years in IT industry of which 8+ years in Metric Analysis & Reporting and 6+ years as a Technical Lead for developing various BI reporting capabilities

Record of success in managing analysis, design and development of various BI/Analytical Solutions

Skilled at leading cross functional teams for migration of OBIEE dashboards, Informatica and database upgrades

Rich experience in managing project team size of 10 – 15 members in BI & DW domain, across technologies such as Oracle, OBIEE, Tableau, Informatica, Oracle Data Integrator (ODI11g) and SAP Business Objects

Strong problem solving, troubleshooting, analytical, communication and interpersonal skills

Experience in collaborating effectively with geographically diversified teams located in different Time zones

Experienced in Data Analytics with sound Data Visualization skills

Strong understanding of ITIL processes

Robust understanding of project management principles, practices, techniques, and tools

CERTIFICATION & TRAINING

CCNA (Cisco Certified Network Associate) Certified

ITIL Trained

TECHNICAL SKILLS

BI Technologies

OBIEE 11G/10g, Siebel, Tableau 9.2, SAP Business Objects

ETL

Informatica 9.6.1/9.5.0, Oracle Data Integrator (ODI11g)

Databases

Oracle 11g/10g/9i

Programming

PL/SQL, R

Tools and Utilities

SQL Developer, TOAD, MS Project, Kintana, Quality Center, BMC Remedy, PVCS (Version Control)

WORK EXPERIENCE

Veritas Technologies, Mountain View, CA Aug’17- Till date

Senior BI Consultant

Responsibilities:

Oracle Sales Analytics OBIEE reporting platform provides the Global Sales Ops and Renewals team near real-time view to analyze Pipeline, Leads, Forecasting and Quota.

Participate in Standup meetings with Sales Team.

Assist in Data Model design.

Develop and merge Repository in a MUD setup.

Create Dashboards and Adhoc reports.

Perform data validation and QA testing.

Work with integrations team for data extraction issues.

Provide Adhoc data extracts per Business Requests

Environment: OBIEE 11g, ODI 11g, SQL Developer, Oracle 11g.

Cisco Systems Inc., San Jose USA Mar’17 – Jul’17

Project Lead

Responsibilities:

Workforce analytics Platform is a centralized data ecosystem for individuals and teams to store data and enable diverse access to it. Tableau/OBIEE based dashboards provides visibility into metrics needed to understand and analyze workforce activities.

Managed multiple tracks through defined processes such as Project Planning, estimation, tracking issues identifying risks, creating mitigation plans etc.

Participate in gathering attribute and reporting requirements.

Work with SMEs for source system integration analysis, data extraction, transforming and loading.

Collaborate with Architects to setup environments.

Created Dashboards in OBIEE and Tableau.

Environment: OBIEE 11g, Oracle 11g, TOAD, MS Project, Tableau 9.2

Cisco Systems Inc., San Jose, CA Feb’13 - Mar’17

Senior Technical Lead

Responsibilities:

Metrics role-based OBIEE/Tableau dashboard that contains simplified, actionable Metrics aligned to IT Scorecard Metrics. The dashboard provides a real-time view of the current operational state of services.

Lad a multi-offshore team to provide 24x7 support and development services.

Oversaw ETL (Informatica), BI Reporting (OBIEE) design and development

Participated in data modelling and code review sessions.

Created Tableau Dashboard to monitor Planned and Unplanned downtime metrics.

Conducted Project team meetings to facilitate discussions for risk assessment and mitigation plans.

Environment: OBIEE 11g, Oracle 11g, TOAD, Informatica 9.6.1, BMC Remedy, Quality Center, SAP Business Objects

Cisco Systems Inc., San Jose, CA Nov’12-Feb’13

Senior OBIEE/ODI Lead

Responsibilities:

Real-Time view of various Program team’s data and information in support of learnings conducted across Cisco.

Lead the migration of OBIEE reports/dashboards from version 10.1.3.4 to 11.1.1.6.0

Coordinated with cross functional teams, for UAT, pre-production and Go-live phases

Worked on Oracle Data Integrator (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database

Environment: OBIEE 11g/10g, Oracle 11g, TOAD, ODI, Quality Center

Viasat Inc, Carlsbad, CA Sep’12 - Oct’12

Senior OBIEE Consultant

Responsibilities:

Installation and configuration for ViaSat’s OBIEE 11g instance along with End User and Administration Training.

RCU schema creation and OBIEE 11.1.1.6.0 installation

Set up Secured LDAP authentication and enabled SSL

Enable Write back, Integrate OBIEE with map viewer, Configure Scheduler

Trained End Users and Pilot Users on OBIEE 11g Tools.

Environment: OBIEE 11g, Oracle 11g.

Cisco Systems Inc., San Jose, CA Aug’07 - Sep’12

Senior OBIEE Consultant

Responsibilities:

COVC-BI project is a decision support system that assists the business to analyze the actual manufacturing trends, collaborative planning and analysis with the end goal to track results. It also helps the Business to bring together metrics that reflect more globally coordinated activities of marketing and quality control of the hardware products.

Identified risks to programs success and create mitigation plans.

Reviewed requirements, provide SME support and case management

Provided project status report to management.

Participated in technical document and architecture reviews for OBIEE/Informatica

Prepared effort estimation document

Environment: OBIEE 10g, Oracle 9i, TOAD, Informatica 9.5.0, Quality Center, Kintana, PVCS

Cisco Systems Inc., Pune India Mar’06 - Aug’07

Senior Siebel Developer

Responsibilities:

CS Team Dashboard provided metrics information regarding customer and sales behavior and the productivity & performance of CS staff and processes, using appropriate security and access controls. It provided extensive analytical, drill-down, exception and “early warning” notification capabilities. Additionally, this access point provided up-to-date and reliable access to critical KPI’s to improve productivity and user satisfaction.

Gathered requirements from Client through day-to-day client meeting and preparing functional specification documents accordingly.

Designed and developed the report prototypes to facilitate the client to better understand the final design.

Environment: OBIEE 10g, Oracle 9i, TOAD, Informatica 9.5.0, Quality Center, Kintana, PVCS

Delta Airline, Pune India Oct’05 - Mar’06

Siebel Developer

Responsibilities:

Involved in Requirement Analysis, Design, Development, Testing, and deployment of Siebel, Informatica and DAC.

Primary responsibility is to develop reports, Build Repository and create dashboard.

Environment: Siebel, Oracle 8i, TOAD, Informatica

Dell Inc., Pune India Jan’02 - Sep’05

Siebel Developer

Responsibilities:

Development of Siebel Analytics Repository

Develop Informatica mappings

Environment: Siebel, Oracle 8i

Contact this candidate