Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Rahul Arora

Fremont

Summary

Senior Technical Lead having 13+ years of extensive IT experience with 9+ years in Metric Analysis & Reporting and 7+ years as Technical Lead for developing various BI reporting capabilities. Managed analysis, design and development of various BI/Analytical Solutions. Lead cross functional teams for migration of OBIEE dashboards, Informatica and database upgrades. Managed 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, data visualization and interpersonal skills. Collaborated with geographically diversified teams located in different Time zones. Providing End User Training, Power user training & Admin training on OAC. Expertise in building Workbooks with various visualization. Handy with IDCS, User management, groups and roles creation and handling the same as per the need. Worked Extensively on Oracle BI EE Administration Tool 10g/11g/12c, Presentation Services, Answers & Interactive Dashboards and Security Implementation. Extensively used Informatica PowerCenter for modifying the existing logic based on user requirements, pulling new columns from source to target tables. Monitoring Jobs, looking into session logs and finding the error upon failure, back tracking the source columns. Good knowledge on Data warehouse concepts like Star Schema, Snow Flake, Dimension and Facts. Conducting the sessions to technical team or development team to explain the business requirements. Expertise in Preparation of Technical Design Documentation, Estimations for Requirements, Impact Analysis for Change Requests. Provided Knowledge transition sessions to Business users on reporting.

Overview

23
23
years of professional experience
1
1
Certification

Work History

Senior BI Consultant

Rosendin Electric Inc
10.2019 - Current
  • OAC reporting platform provides Executive teams and Filed employees a view to analyze Key Performance metrics such Billings(under/over), Manloading hours, Backlogs and Bluesky
  • OBIEE 11g to OAC Upgradation
  • Extensively worked with Oracle support on tool bugs and limitations
  • Deploying RPD, managing snapshots
  • Implemented Usagetracking in OAC
  • Assists in Data Model design
  • Design Automation and data validation reports in BI publisher and OAC agents
  • Business enhancement request analysis and provide estimates
  • Create Adhoc reporting/Dashboards in Oracle Analytics Cloud (OAC)
  • Prepare MD120 document for deployments to non-prod and prod environments
  • Code check in into PVCS
  • Work with integrations team for data extraction issues in Oracle Data Integrator and Informatica
  • Handle customer tickets
  • Analyze data issues and work with the team to implement fixes

Senior OBIEE Lead

SRS Consulting Inc
02.2013 - Current

Senior BI Consultant

Riverbed Technologies
05.2018 - 10.2019
  • Partner Performance and Renewals OAC reporting platform provides Channel Ops and Sales Finance teams with a view to analyze partner metrics such On Time Renewal Rate, Dividends and Case Escalation Rate
  • Drive requirements and design sessions with Channels Team
  • Translate business requirements and source system understanding into technical design
  • Communicate with business users and PMO team at regular project status meetings
  • Create reports in BICS or DV for adhoc requirements
  • Conduct UAT
  • Work with Oracle EBS/Salesforce teams for data integration
  • Design and implement data security
  • Embedding of OAC into external portals

Senior BI Consultant

Veritas Technologies
08.2017 - 05.2018
  • Oracle Sales Analytics and Renewals 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
  • Assists in Data Model design
  • Develop and merge Repository in a MUD setup
  • Create Adhoc reports in Oracle Business Intelligence Cloud Service
  • Perform data validation and QA testing
  • Work with integrations team for data extraction issues
  • Provide Adhoc data extracts per Business Requests

Project Lead

Cisco Systems Inc
03.2017 - 07.2017
  • 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

Senior Technical Lead

Cisco Systems Inc
02.2013 - 03.2017
  • 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
  • Lead a multi-offshore team to provide 24x7 support and development services
  • Oversee ETL (Informatica), BI Reporting (OBIEE) design and development
  • Participate in data modelling and code review sessions
  • Create Tableau Dashboard to monitor Planned and Unplanned downtime metrics
  • Conduct Project team meetings to facilitate discussions for risk assessment and mitigation plans

Senior OBIEE Lead

Cisco Systems Inc
11.2012 - 02.2013
  • 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

Senior OBIEE Consultant

Zensar Inc
08.2007 - 02.2013

Senior Siebel Developer

Zensar Technologies
03.2006 - 02.2013

Senior OBIEE Consultant

Viasat Inc
09.2012 - 10.2012
  • 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

Senior OBIEE Consultant

Cisco Systems Inc
08.2007 - 09.2012
  • COVC-BI/Quality Data Mart 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 for Customer Experience & Quality Management System
  • It also tracked the quality of manufacturing data right from the smallest piece of hardware which CISCO manufactures right up to RMA
  • Validate data for Hardware Quality Dashboard metrics like InstallBase, Mean Time Between Failures, ShipBase
  • Review requirements, provide SME support and case management
  • Create Adhoc reports in OBIEE
  • Participate in technical document and architecture reviews for OBIEE/Informatica

Senior Siebel Developer

Cisco Systems Inc
03.2006 - 08.2007
  • 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
  • Gathering 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

Siebel Developer

Delta Airline
10.2005 - 03.2006
  • 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

Siebel Developer

Wipro BPO
01.2002 - 03.2006

Siebel Developer

Dell Inc
01.2002 - 09.2005
  • Development of Siebel Analytics Repository
  • Develop Informatica mappings

Education

Bachelor of Engineering - Electronics

University of Mumbai
01.2001

Skills

  • OAC (Oracle Analytics Cloud)
  • OBIEE 10g
  • OBIEE 11g
  • OBIEE 12c
  • OBIA
  • Oracle Business Intelligence Cloud Service (BICS)
  • SAP Business Objects
  • Tableau
  • Oracle Data Integrator (ODI11g)
  • Informatica 9x
  • Informatica 8x
  • Oracle 12G
  • Oracle 11i
  • Oracle 10g
  • Oracle 9i
  • Remedy
  • Smart Sheet

Certification

CCNA Certified

Timeline

Senior BI Consultant

Rosendin Electric Inc
10.2019 - Current

Senior BI Consultant

Riverbed Technologies
05.2018 - 10.2019

Senior BI Consultant

Veritas Technologies
08.2017 - 05.2018

Project Lead

Cisco Systems Inc
03.2017 - 07.2017

Senior OBIEE Lead

SRS Consulting Inc
02.2013 - Current

Senior Technical Lead

Cisco Systems Inc
02.2013 - 03.2017

Senior OBIEE Lead

Cisco Systems Inc
11.2012 - 02.2013

Senior OBIEE Consultant

Viasat Inc
09.2012 - 10.2012

Senior OBIEE Consultant

Zensar Inc
08.2007 - 02.2013

Senior OBIEE Consultant

Cisco Systems Inc
08.2007 - 09.2012

Senior Siebel Developer

Zensar Technologies
03.2006 - 02.2013

Senior Siebel Developer

Cisco Systems Inc
03.2006 - 08.2007

Siebel Developer

Delta Airline
10.2005 - 03.2006

Siebel Developer

Wipro BPO
01.2002 - 03.2006

Siebel Developer

Dell Inc
01.2002 - 09.2005

Bachelor of Engineering - Electronics

University of Mumbai
Rahul Arora