OBIEE Consultant

Experience Summary

** ***** ** **** ********** in defining, architecting and implementing Business Intelligence and Analytics solutions for various organizations

Experience in business requirements gathering, data warehousing, data mapping and data modeling

Expertise in installing, configuring, customizing, developing and upgrading OBIEE, Oracle Business Intelligence Application (OBIA) and Oracle DSR

Expertise in rpd and dashboards development in OBIEE 10g/11g/12C versions

Ability to build strong relationships with all stakeholders and manage their expectations

Expertise in creating Business Requirement Document (BRD) & Functional Specification Document (FSD)

Determining optimal approach for obtaining data from diverse sources, platforms to move data into Business Intelligence platform

Estimating system capacity to meet near and long-term data insertion, extraction and processing and spacing requirements by coordinating with appropriate team

Response to RFPs, tool selection, estimation, High level and activity level Project Planning

To liaise among development/support team, onsite-offshore and business users, developing technical design documents and presenting to development team

Developing disaster recovery, backup and archival strategies

Assisting business decision makers with strategic direction for business intelligence

Defining data, code and tools standards and best practices

Continue to investigate and evaluate emerging BI technologies

Skills Summary

Domain

Finance, Banking, Consumer Goods Manufacturing, HR

Operating System / ERP Version

Windows, Linux, Aix

Tools / DB / Packages / Framework / ERP Components

OBIEE 12c/11g/10g, OBI Apps 7.9.x, Oracle Demand Signal Repository

Oracle Exalytics, BICS

ETL Tool: Informatica 9.x,ODI, DAC 10g

Database: Oracle 12c/11g, MS SQL Server2008, Netezza, Dash DB

MS Office, MS Visio, MS Project Plan, JIRA, Cloudera Hadoop

Professional Certifications/ Trainings

Oracle Business Intelligence Foundation Suite Certified Implementation Specialist

Successfully completed Oracle training on ODI & BIP

Successfully completed Hadoop training

Career Summary

L&T InfoTech, NJ, USA

Working as Senior Consultant from May-2019 to till date

L&T InfoTech, Chennai

Working as Consultant from Feb-2017 to Mar-2019

Optimum Solutions, Shanghai, China

Worked as Senior Consultant from Sep-2015 to 31-Dec-2016

Sutherland Global Services, Chennai

Worked as Sr. Associate Manager from Dec-2014 to Aug-2015

IBM India Pvt Ltd, Bangalore

Worked as Package Solution Consultant from May-2013 to Dec-2014

HCL Technologies, Bangalore

Worked as Sr. Software Engineer from Feb-2012 to May-2013

Hexaware Technologies, Chennai

Worked as Software Engineer from Apr-2011 to Feb-2012

FCS, Hyderabad

Worked as Associate Software Engineer from Apr-2010 to Mar-2011

Vaxgen Technologies, Tanjore

Worked as Application Programmer from May-2008 to Mar-2010

Work Experience

Project 1 - Securitas INC, New Jersey, USA (Oct 2018 to till date)

Project Name

OBIA Upgradation & Production Support, USA

Team Size

6

Project Description

Client is an industry leading security provider and focuses on ways to continuously improve their operational structure, the knowledge of their employees and the processes surrounding service delivery.

The project aims to upgrade their on-premise Financial Analytics from 11g to 12c and merge HR analytics deployed on BICS analytics to have one consolidated BI system.

Role & Contribution

Role: Solution Architect & Team Lead/OBIEE Consultant

Architecture design for new environment

Assessment of customization and preparing roadmap for upgrade

Upgrade and post upgrade retrofitting of EP, RPD, reports, dashboards and fixing complex upgrade issue

Designing and configuring security in upgraded environment

Develop and manage the BI dependency plan, job scheduling and cycle management

Migrating objects across environments

Validation of upgraded reports, dashboards & underlying tables

Offshore coordination of all ongoing activities, updating client with the updates and progress

Leading the production support team

Technology & Tools

OBIEE 12C/11g, BICS, Informatica 9.1/9.6, DAC 10g/11g, Aix7.1/7.2 & Oracle database 12C

Project 2 - Eaton Corporation USA (Feb 2018 – Sep 2018)

Project Name

Warranty Analytics, USA

Team Size

8

Project Description

Client is a multinational power management company. It is a global technology leader in electrical components and systems for power quality, distribution and control; hydraulics components and various sophisticated systems.

The solution aimed at creating an intuitive analytical solution to improvise the offered services, parts, repairs and service requests and to improve the overall decision-making process.

Role & Contribution

Role: Solution Architect/OBIEE Consultant

Defined BI data architecture, including Extract-Transform-Load (ETL) processes, Operational Data Store (ODS), Enterprise Data Warehouse (EDW), data marts, and data lakes

Developed architecture artifacts, technical designs, strategy documents and other technical artifacts for data warehouse and BI applications

Engaged in feasibility study, requirement gathering, develop and maintain the artifacts through all the phases of SDLC

Provided BI technical and architectural guidance to projects and teams, ensuring that new initiatives enable effective data reporting

Developed and maintained data architecture, data management standards/conventions, data dictionaries, naming and metadata standards

Collaborated with BI Administrators, Developers, and Data Analysts for successful development of BI reporting and analytic solution

Technology & Tools

OBIEE12 C, Oracle 11g, Red Hat Linux 6,Informatica,DAC11g

Project 3 – Fidelity, USA (Feb 2017 till Jan 2018)

Project Name

Financial Data Hub, USA

Team Size

12

Project Description

Client is a multinational financial services corporation based in USA.

Financial Data Hub program was aimed at creating a single on-going data program and sustainable business management processes that delivers reliability and consistency for analytical data for Finance process.

Role & Contribution

Role: Senior BI Consultant

Responsible for maintaining the quality of the solutions and assuring that the solution meets the business owner requirements

Involved in understanding the business requirement

Lead, design and document the conceptual and logical data models, and assist the technical team in the development of the physical models required to support project deliverables

Worked with other Architects, defined the overall data warehouse architecture (e.g. ETL process, Operational Data Store, Data Marts & Lake)

Collaborated with Domain Architects and Enterprise Architects to develop the technology "roadmap" (Business Initiative Roadmap) for the project, and to plan the transition from the current architectural framework to the target architecture of the future

Verify the content developed by the technical team during the development phase is compliant with the proposed solution architecture

Technology & Tools

MS Office, MS Visio, MS Project Plan, JIRA,OBIEE12 C/11g,Oracle 11g,Red Hat Linux 6,Informatica,Netezza,Cloudera Hadoop, Impala, Dash DB

Project 4 – Standard Chartered Bank,Tianjin,China (Sep 2015 – Dec 2016)

Project Name

Financial Markets Balance Sheet Management, UK

Team Size

7

Project Description

Client is a British multinational banking and financial services company head-quartered in London.

The project involved development and enhancement of financial markets balance sheet reports and liquidity risk analysis reports in OBIEE.

Role & Contribution

Role: Technical Manager

Responsible for technical design specification for OBIEE and data warehouse, application deployment instruction, verify stability & portability and security

Engage in feasibility study, requirement gathering, develop and maintain the artifacts through all the phases of SDLC

Project Planning, team management and coordination of ongoing activities

Communication management, status updates and progress

Coordinating with application owners and business users for queries and clarifications

End to End Data validation, Code review and implementing best practices

Technology & Tools

OBIEE 11g, Oracle 11g, Red Hat Linux 6, PL/SQL

Other Experience

5.DC Analytics

(OBIEE 11g,Oracle Exalytics, Oracle Essbase 11g,Sql server 2008)

Client – Sutherland Global Services, USA

Client is a global provider of business process and technology management services offering an integrated portfolio of analytics-driven back-office and customer facing solutions that support the entire customer lifecycle.

The project involved creating a custom analytics solution based on Oracle’s EPM BI application functionality. The sophisticated features and self-service functionality available in DC OBIEE Analytics enabled to have an important insight into DC data and trends and helped with strategic business goals and objectives

6.HR Analytics, USA

(OBIA 7.9.6.4)

Client – Nisource, USA

Client is a Fortune 500 company engaged in natural gas transmission, storage and distribution, as well as electric generation, transmission and distribution.

The project aimed at creating an intuitive, role-based analytical solution. The solution included transforming and integrating data from various sources, such as PeopleSoft & corporate data warehouses into actionable insight, to enable decisions making across various process such as Workforce, Recruitment, Compensation etc.

7.OBIEE 10g to 11g upgrade

(OBIEE 11.1.1.6.x, Oracle 11g)

Client – Wipro,India

Client is an India-based information technology, consulting and business process services company headquartered in Bengaluru, India.

The project involved upgrading from OBIEE 10g to 11g and to re-host OBIEE servers on 11g (11.1.1.5) environment in Red Hat Enterprise Linux (RHEL) 5.6 version, based out of a new data center.

8.Opera

(OBIEE 11g,Oracle 11g,Informatica 9.0,Hyperion Essbase 9.0)

Client – Banorte Bank, Mexico

Client is dedicated to the production, distribution and marketing of products in the form of financial services, with various areas of marketing and management for their services, as well as areas for support and attention to their business units.

The project involved management and support of BI Application. This includes generation of daily and monthly reports, control, monitoring & end to end support.

9.Oracle DSR

(OBIEE 10.1.3.4.1, OWB 10g R2,Oracle 10g)

Client – Activision Blizzard, USA

The customer is a worldwide pure-play online and console game publisher with leading market positions across various categories.

The Oracle Demand Signal Repository (DSR) helps manufacturers collect detailed retailer POS and other demand data, analyze it to identify issues and opportunities.

10 .Cholayil Sales Analytics

(OBIEE 11g,MS-Excel)

Client – Cholayil Group,India

Client is an illustrious and esteemed Ayurveda group, which has a deep history in providing holistic health Care.

This project aimed to improve the decision-making process for the Sales division to improvise sales across regions.

Educational Qualification

Education & Credentials

Bachelor of Engineering (Computer Science & Engineering) - 2004

Master of Engineering (Computer Science & Engineering) - 2006

Contact this candidate