SUMMARY

• 7+ years of experience as Sr. Oracle BI Consultant in OBIEE with experience end - to-end life cycle starting from initiating the kick-off meetings, requirements definition, preparation of effort estimates, handling client approvals, solution design, statement of work / business requirement documents, coordinating UAT with the client.
• Extensive BI and Data warehousing experience using reporting Solutions and Informatica PC 9.0.1, 9.6.1,8.1/7.x.
• Deep hands on expertise in configuration and implementation of OBIA apps 7.9.6.4 Oracle Loyalty Analytics and OBIA 7.9.6.3 Marketing Analytics/Sales Analytics.
• Good domain knowledge & experience in Business Intelligence & Data Warehousing in CRM based Applications.
• High proficiency in SQL and relations Database, hands on in SQL developer and Toad.
• Analyze business requirements and translate them into functional and technical design specifications and implementation plans.
• Experience in developing various types of reports - Bar, Pie, Graph, Gauge, and Pivot, etc.
• Extensive Experience in modification and development of all three layers of RPD - Physical Layer, Business Model Mapping Layer (BMM), and Presentation Layer.
• Expertise in Data Modeling (design, analyze and implement) conceptual, logical and physical data model, Data conversion and Data integration specialization in the area of Data Warehouse and Business Intelligence.
• Proven Experience in SDLC, Design documentation, Unit/Functional testing.
• Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy for both OLAP and OLTP system.
• Extensive BI and Data warehousing experience using reporting Solutions and Informatica PowerCenter 9.0.1, 9.6.1, 8.1/7.x.
• Experience in implementing security by creating roles and web groups, and defined Object Level and Data Level Security.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Self-driven and passionate performer with yearn to learn new technologies and techniques.
• Extrovert with strong command over spoken and written language.

TECHNICAL SKILLS

Business Intelligence: OBIEE 12.2.1.x, 11.1.1x, 10.1.3.x, OBIA 7.9.6.4

DAC: DAC 11.1.1.6.4/ 10.1.3.4.1/7.9.4 / 7.9.6. x

ETL Tools: Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1/ Informatica Power Center 8.6.1

Agile Methodology Tool: Rally

Defect Tracking Tool: Jira

Siebel Applications: Siebel7.X/8.0,Siebel Call Center

Utilities: MS Office Suite (Word, Excel, PowerPoint,Visio)

CRM Verticals: Siebel eSales, Siebel e-Pharma, Siebel Call Center, Microsoft Dynamics CRM

Operating System: Windows 95/98/2000/XP, UNIX, AIX OS, MS-DOS

DBMS: Oracle 10g, Oracle 11g, IBM DB2, SQL Server

PROFESSIONAL EXPERIENCE

Confidential - Los Angeles, CA

Senior BI consultant

Responsibilities:

• Interacted with business representatives and business analysts forrequirements analysisand to define business and functional specifications.
• Analyzed the Reporting Requirements and participated in the documentation of Business Requirements.
• DevelopedOracle BI Metadata repositoryusing BI Administration tool.
• Developed interactiveDashboards and ReportsinOracle BI Answersas per the reporting specifications.
• Defined and createdInitialization Blocks, Repository and Session Variablesfor generating filters and defining security.
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Developed measure for time comparison using time functions,To-Date and Ago.
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Configured Measures in the Business Model Layer and mapped to multiple logical table sources.
• Created schedulers and developediBotsto deliver reports and dashboards to the subscribers as per the schedules and alerts.
• Coordinating with the offshore team for the production support related activities and testing of the migrated reports
• Createdreport prototypesand presented them to users to get approval.
• Attended weekly meetings with BA and Stakeholders for project status updates.
• Performedunit and integration testingof reports and dashboards.

Technologies Used: OBIEE 12.2.1.2.0 , Oracle 12c, Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1

Confidential - Riverside, CA

BI consultant

Responsibilities:

• Involved in requirement gathering and interaction with end users to understand the requirements.
• Involved in modifications of Physical, Business and Presentation layers of metadata repository using OBIEE Administration Tool.
• Implemented Out-of-the-box Analytics Reporting Functionality of Data mart Reporting. Incorporating Analytics will help users especially Recruiters, employer to analyze the performance of organization by Market, Finance, Manager.
• Configured Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Configured different types of Reports Drilldown techniques, Aggregation rules to meet client requirements.
• Configured groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business and User requirements.
• Implemented caching and aggregate table techniques to improve the performance.
• Customized business reports using BI Answers as per requirements.
• Implemented different kinds of Reports pivots, charts, tabular using global and local Filters.
• Configured proactive agent’s iBots and interactive Dashboards to alert the technical team and managers about business changes.
• Expertise in implementing the Oracle BI Security Setup (groups, data access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Responsible for updating/ tracking and documenting the development changes at bothETL levelandrpd level.
• Documented the complete project details like Best Practices, development standards, promotion and demotion policies and migration standards.

Technologies Used: OBIEE 11.1.1.9.0 , Oracle BI Applications, PeopleSoft HR Analytics, Informatica 9 Hot fix 2

Confidential - Dallas, TX

OBIEE Developer

Responsibilities:

• Configured Oracle BI Applications Informatica, DAC and OBIEE, implemented Oracle out of the box Prebuilt Apps
• Worked extensively to customize DAC Execution Plans, Subject areas, Task Definitions and Tables for OBI Loyalty Analytics
• Assisted in Upgrade of Informatica Power center from 9.0.1 to 9.6.1.
• Customized some out of the box ETL Mappings.
• Hands on ETL Design for OLAP and OLTP systems.
• Creating Workflows with Worklets & Tasks and scheduling using both Workflow Manager and DAC.
• DevelopedMappings, Sessions, Workflows and Shell Scripts to extract, validate, and transformdata according to the business rules.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console (DAC) and Informatica.
• Hands on OBIEE (10g/11g/12c) to generate genuine reports for the stake holders.
• Involved in DAC upgrade from 10.1.3.4.2 to DAC 11.1.1.6.4.
• Highly professional in SQL and Informatica PC to populate data to Oracle System, performed performance tuning.
• Worked on DAC for creation of Tasks, Task Groups, Subject Areas, Execution Plan, and to configure, monitor and schedule ETL routines.
• Performed Unit/System Testing, worked with users for UAT and done Performance tuning according the users feedback.
• Deployment of code to production

Technologies Used: OBIEE 11.1.1.7.0 , OBIA Apps 7.9.6.4, Informatica Power Center 9.0.1/ Informatica Power Center 9.6.1

Confidential

OBIEE Developer

Responsibilities:

• Requirements Gathering and Business Analysis. Project coordination, End User meetings
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Oracle Data Integrator (ODI)
• Involved in system study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables
• Responsible for creating Logical and Physical models for dev, test, staging and Production Warehouses.
• Responsible for configuration of Master and Work Repository on Oracle
• Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up Reports.
• Integrated OBIEE with EBS for Single Sign On (SSO)
• Worked on integrating and configuring BI Publisher with OBIEE.
• Created ODI Packages, Jobs of various complexities and automated process data flow
• Configured Security manager for multiple users and assigned the required profile to those users.

Technologies Used: OBIEE 11.1.1.7, BIP 11.1.1.7, ODI 11g

Confidential

Jr. OBIEE Developer

Responsibilities:

• Participated with SME’s and users in gathering and analyzing the business reports requirements.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Developed new reports, dashboards, Ibots and debugged many dashboards using different analytics views (pivot table, pie / bar chart, and view / column selector, page and dashboard prompts), interactive dashboards with drill-down capabilities using global and local filters.
• Generated around 24 Different Reports based on Document Letters and Proof of Marriage and Statistical Reports
• Generated Graphical Reports in BI Publisher to give Comparative Study of Number of Letters Attested Vs on Organization, Attester Names etc.
• Maintained development, test and production mapping migration using repository.
• Used Informatica Power Center Designer for developing mappings, using transformations, which included aggregation, updating, lookup, and summation.
• Developed sessions using Server Manager and improved the performance details.
• Worked with Informatica Designer tool in developing mappings and mapplets to extract and load the data from flat files.
• Extensively used Informatica for loading the data from various tables for different departments.
• Created and granted privileges for the users using Analytics Catalog Manager.
• Performed unit and integration testing to validate reports and mapping functionality.
• Worked closely with users, developers and administrators to resolve ongoing production problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE repository.
• Handled all the Reporting Requirements in BI Publisher and OBIEE and invoked the same from Siebel Application.

Technologies Used: Siebel, OBIEE 10.1.3.4.2 , Oracle BI Publisher 10g, Informatica Power Center 9.0.1, OBIA 7.9.6Database: Oracle