SUMMARY:

• 8+ years of experience in design, implementation and maintenance of Business Intelligence (OBIEE) and ETL using Oracle Data Integration (ODI) and Informatica
• Design, develop and maintained public facing budget reporting solution for the Confidential using OBIEE. State budget is approx. $25 Billion
• Revenue recognition project helping executives at Confidential better understand revenue growth and profitability. Developed using OBIEE and ODI
• Global Spend Management (GSM) project reports all Confidential spending around the globe helping executives and management in all business units to make better decisions
• Supply chain Management Reporting to understand CRD, CSD lateness and inventory management
• Excellent Data warehousing knowledge - OLAP/OLTP, Star Schema, Snow Flake Schema modeling, Slowly Changing Dimensions, conformed dimensions, surrogate keys, normalization techniques
• Worked independently and manage multiple tasks, projects with excellent troubleshooting skills.
• Always on-time delivery with 100% end user and management satisfaction
• Helped IT Directors with Project road maps, achievements and deadlines for executive meetings

TECHNICAL SKILLS:

Reporting Tools: OBIEE 11.1.1.x, 10.1.3.x, OBIA HR Analytics 11.1.1.8

ETL Tools: ODI 10.1.3.6, 11.1.1.x, Informatica 8.x, 9.x

RDBMS: Oracle 11g, 10g, SQL Server

ERP: Oracle EBS R12 GL, AP, AR, PO, ONT

Languages: SQL, PLSQL, Shell Scripting, JavaScript, Python

Front End Tool: SQL Developer, PLSQL Developer, SQL*Plus

MS Tools: MS Excel, Power Point, Visio

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle BI Consultant, Boston, MA

Responsibilities:

• Installation and Configuration of OBIEE 11.1.1.6 on clustered architecture in Dev, Test and Prod
• Applied patches using opatch utility, Upgrade the environment to 11.1.1.7 using upgrade assistant
• Held meetings with Business users and gathered requirements
• Documentation - Functional Design, Requirement Traceability, Specifications
• Configured MUD, Usage Tracking, Event Polling, Scheduler configuration
• Modeling metadata in RPD - Dimensional hierarchies, Aggregate Navigation, Level based measures, Time series functions, Dynamic and Session Variables, Implicit fact column
• Create OBIEE analysis reports with bar, pie, line chart, table, pivot table, narrative, static text, title, view selector, column selector views
• Created Dashboards with reports, prompts, conditions, action links and static content - images, text
• Used Action Links with conditions on dashboard sections (Guided Navigation in 10g)
• Created and scheduled Agents/ibots to Seed Cache and send Alerts about data related issues
• Materialized Views, Indexes to improve report performance
• Managed security by creating Users, Groups, Roles and applying data filters
• Customization of OBIEE user interface - Styles and Skins - banner, logos and images, custom messages, menu bar links, export data links, menu links, error messages, CSS using JavaScript
• Admin tasks using Catalog Manager - Catalog, RPD migrations
• Enterprise Manager - Server Monitoring, Restarts and Parameters Setting
• Write Shell scripts for daily backup of Catalog and RPD and clearing cache and monitoring the server
• Involved in architecting Data warehouse design and creating staging tables and data warehouse Dimension and Fact tables
• Created and reverse engineered the models to import the data stores
• Define business rules and convert them to creating Lookups, joins, filters in Interfaces
• Imported knowledge modules and created Interfaces, Procedures, Variables, Packages and Scenarios and deployed them into production using import export
• Used knowledge modules like LKM File to SQL, LKM SQL to Oracle, IKM Oracle Incremental Update, IKM Oracle Incremental Update(MERGE), IKM Oracle Slowly Changing Dimension, CKM Oracle, JKM Oracle Consistent
• Used ODI Tools to send email, move and zip files
• Used IKM Incremental Update and IKM Slowly Changing Dimensions and to load the SCD Type 1 and Type 2 Dimensions
• Setup Journalizing using Oracle Simple and Consistent Set CDC JKM
• Used Native database sequences to load the surrogate keys in dimensions
• Used Flow Control and Static Control to perform data checking
• Version Management of projects using ODI solutions

Environment: OBIEE 11.1.1.7, 11.1.1.6, ODI 11.1.1.6, Oracle Database 11g, SQL Server

Confidential

Responsibilities:

• Gathered requirements from business users and created mockup reports and dashboards for review
• Upgrade OBIEE RPD and Catalog to 11.1.1.7 using upgrade assistant
• Designed the data warehouse according to OBIEE Dashboard and report requirements
• Administration of Web Catalog, RPD, BI Server, Weblogic Admin, Managed Servers and HTTP Server
• Modeled RPD for Aggregation Navigation using materialized views in the database
• Create, Modify and Format views in Analysis
• Dashboard pages with action links, prompts, conditions
• Created Agents/ibots to seed cache and send personalized alerts to users based on requirements
• Used Time series functions in reports - Ago, To-date, Period Rolling
• Create indexes to improve the report performance.
• Develop Test cases for OBIEE Dashboards, reports data testing and Performance testing
• Wrote SQL code for Report testing - Compare data in staging and data warehouse tables with OBIEE generated SQL Queries
• Created dynamic repository variables and session variables
• Used Static Control and Flow Control to enforce data quality in Interfaces

Environment: - OBIEE 10.1.3.4, Oracle Database 11g, SQL Server

Confidential

Responsibilities:

• Involved in the Installation and configuration of OBIEE software 10.1.3.4 on Dev, test and Prod
• Created reports with filters on requests, and format results in Answers
• Created Specification document, functional design documents for the project
• Involved in the design of staging area and data warehouse in oracle database
• Work with multiple teams and collect reporting requirements
• Dimensional modeling and design of the Data Warehouse and Staging Tables
• Used Catalog Manager to migrate the code to test and prod environments
• Write PLSQL code for dropping indexes, refreshing materialized views as part of the ETL process
• Write analytic SQL queries to provide data to the clients
• Created Master and work repositories and set the Topology for the complete project
• Define business rules and convert them to creating Interfaces using filters, joins, lookups in ODI
• Created Interfaces, procedures, packages, scenarios using ODI Tools, variables, user defined functions
• Used Native Sequences to create surrogate keys for dimension tables
• Generated, Migrated and Scheduled scenarios to different environments using export import features
• Used Static and Flow Control to enforce data quality in Interfaces

Environment: - OBIEE 10.1.3.4, ODI 10.1.3.6, Red Hat Linux 6, Windows Server 2008, Oracle Database 11g, SQL Server

Confidential

Programmer Analyst

Responsibilities:

• Develop SQL code to create reports of company financial figures
• Create Informatica ETL code to move data from flat files to Oracle database
• Develop reports with Drill down and dashboards with guided navigation
• Create ibots to seed cache
• Develop external table authentication using session variables
• Developed PLSQL triggers, functions, procedures and packages, sequences
• Used MERGE statement to load dimensions with new and updated data