Summary:

• Eight plus years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• ExtensiveBI and Data warehousingexperience usingOBIEE11.1.1.x/10.1.3.x, OBIA 7.9.6.x/7.9.5.x, Siebel Analytics7.x, Informatica9.x/8.x/7.x, DAC 10.1.3.4, SQL and PL/SQL.
• Experience in Installation and Configuration of OBIA (including Informatica, DAC and OBIEE) Out of the Box Reports.
• Customized OBIA Out of Box Reports to meet the requirements by doing Business Analysis, Technical Analysis and RPD Modifications.
• Extensive experience in OBIEE Administration Tool, OBI Answers, OBI Intelligent Dashboards, OBI Publisher, Delivers and iBots with OBIEE Applications.
• Experience in developing Dimensional Hierarchies/Creating Aggregate Measures/Aggregate Tables/New logical columns/Filters/Variables/Time Series Functions as per business requirements.
• Proficient in configuring Security settings at various levels both in Repository level (OBIEE Administration Tool to setup Groups, Access Privileges and Query Limits) and Presentation Catalog level.
• Experience Integrating LDAP Server for authentication of users and working in Multi User Development Environment (MUDE).
• Experience developing reports & dashboards inOBIEE(BI Publisher, Dashboard, Answers, Delivers, Oracle BI for Microsoft Office).
• Expertise in Creating Dynamic Dashboards and OBIEE Answers using Prompts, Filters, Calculations, Charts, Pivot tables, View Selector and Conditional Formatting.
• Configured, Designed and developed BI Publisher reports by integrating them with Microsoft Office application according to client’s requirement.
• Experience in migration techniques forOBIEE, Informatica and DACcomponents into various test and production environments.
• Experience using OBIEE 11g, especially in configuring Security settings using Weblogic Server (Users and Groups), Oracle Enterprise Manager (OEM for Roles and Privileges) and Presentation Catalog.
• Strong Knowledge and Understanding of upgrading and implementing OBIEE 11g.
• Strong Knowledge and understanding of Relational Databases (Oracle and SQL Server), data warehousing concepts and querying tools.
• Skilled in data warehouse methodology, data analysis and modeling, business intelligence architectures, report development, ETL development and database design.
• Created Test cases and Tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.
• Experience in designing and testing mappings, mapplets and workflows using Informatica Power Center.
• Experience and strong Working knowledge with Oracle EBS and People soft modules of Financial Analytics, Procurement and Spend Analytics, Sales Analytics, Project Analytics, Marketing Analytics, HR Analytics, HCM Analytics and Supply Chain modules.
• Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements.
• Very strong in Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other objects.
• Excellent Written and Verbal Skills; Ease to learn and apply new technologies and improve

processes.

Education:

• Bachelors in Computer Science and Information Technology

Technical Skills:

• Oracle Business Intelligence EE 10.x (Admin, Presentation Services, Publisher), Hyperion Brio 8.x/7.x
• Siebel Analytics 7.x (Admin, Web, Answers, Dashboards), Scheduler (iBots)
• Informatica 7.x/6.x (PowerCenter / PowerMart), Datawarehouse Administration Console (DAC)
• Oracle 8i/9i/10g, SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x
• C, C++, VC++, Java, HTML, XHTML, XML, VBScripts, Javascript
• Unix, Linux, Windows NT/2000, XP, Vista, 7

Work Experience:

Confidential,CA May’11 – To Date
Senior OBIEE Consultant
The Customer Care and Billing Data Warehouse (CCBDW) project provides Customer Billings, Collections and Service Requests Analytics solution to Sempra personal to enhance decision making process with respective to revenue and service management.

Responsibilities:

• Interacted with Business users for gathering Reporting Requirements.
• Designed and Developed the OBIEE metadata Repository using OBIEE Admin tool by importing the required objects with integrity Constraints into physical layer using connection pool
• Created Aliases for all physical tables to avoid circular joins and self joins.
• Created Drill-Down Hierarchies and set the estimated levels in Hierarchies, Logical columns & manipulated Fact column in BMM Layer as per requirement using Calculation Wizard.
• Created Time Series objects for comparing business performance with previous time periods using Ago and ToDate Functions.
• Created various Presentation Catalogs in presentation layer with tables and sub tables.
• Designed Usage tracking table and also imported prebuilt Usage Tracking Repository.
• Developed Different Reports with different Analytic Views (Tables, Pivot Tables, Charts, Column and View Selectors, Narrative, Tabular with Global and Local Filters) using presentation services.
• Generated Drill down Reports, Drill down Charts, Summary Reports, Navigational Reports, Sub Reports, Linking Reports etc.
• Designed Dashboards based on requirements.
• Configured Scheduler by creating Scheduler tables in database.
• Configured iBots and delivered reports to users through different devices like email, mobile etc.
• Integrated BI Publisher with OBIEE.
• Generated reports using BI Publisher.
• Installed Briefing Books, Excel Add-In and customized Login screen.
• Extensively used SQL for testing the Data and Comparing report result.
• Performed Unit, Integration Testing to Validate the Report.
• Worked closely with Users, Modelers and Administrators to resolve ongoing production Problems.

Environment: OBIEE 10.1.3.x, BI Publisher, Oracle 10g, SQL, Windows XP, UNIX.

Confidential,CA Aug ‘10 – Apr ’11
Business Intelligence Consultant
Confidential,for Product Partners that helps measuring company performance (Orders from EBS, Payments, Service Notes, and Continuity levels associated with Orders), getting new customers, keeping existing customers and delivering flexibility.
Responsibilities:

• Conducted Interviews for Business Requirements & Prepared the detail Functional Specification document.
• Determined Facts & Dimensions, Date & Time relationships, Granularity, Data Consistency across Dimensions and Identified Business Users & Group Security,).
• Identified Data Sources and Browsed Data Content.
• Installation of OBIEE Server on Linux.
• Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Names for Source Columns, Reports and Dashboard Layouts).
• Created Physical Model, Build BMM / Creation of Star & Presentation Layer, Configured Appropriate Security for Identified Users.
• Created Dashboards and Pages, Created 26 Critical Reports and other weekly & monthly reports in Answers, Configured Security, and Worked with PP to mature reports.
• Migrated OBIEE repository and Webcat to various environments.

Environment: Oracle Business Intelligence (OBI) EE 10.x, Oracle10g, Linux

Confidential,Peoria, IL Sep ‘09 – Jul ’10
OBIEE Consultant/BI Publisher/OBIA Consultant
Responsibilities:

• Involved in full life cycle implementation of Financial and Supply Chain Analytics including installation, configuration, extension and customization.
• Gathered requirements from the client for GAP Analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Extensively worked on SRs as per the client’s requirement to get the reports for the Business Analyzation.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Define the data mart data structures using ERWIN.
• Design and develop the BI business model in OBIEE and BI Publisher Reports
• Worked on integrating and configuring BI Publisher with OBIEE.
• Configured OBIEE iBots to deliver Analytics content based on schedule and automated iBot queries to obtain daily and weekly reports.
• Responsible for customizing the out of box reports and creating new reports and dashboards.
• Developed Reports/Dashboards by implementing different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).Created Environment Variable on Unix/Linux Environment.
• Designed and Developed Custom Mappings in Informatica to bring the data from Legacy system.
• To implement incremental logic for Stage load mappings and Insert/update logic for all Fact mappings.
• Extracted various sources like Oracle tables and imported Flat files using Informatica Power center.
• Extensively developed mappings on various business areas in the project by employing the available Transformations.
• Responsible for extracting Data from Oracle Apps Modules & loading into stage system and warehouse system.
• Designed Schemas using Fact, Dimensions, Physical, Logical, Alias and Extension tables in OBIEE Administrator tool.
• Used Template, sub Template method for a creating single report with multiple Layouts.
• Used the Totals/Subtotals/group/sort features of XML/BI Publisher to make data intense operations happen at the template level.

Environment: OBIEE 10.1.3x, BI Apps 7.9x, Oracle E-Business Suite 11.5.10, OBIEE 10g, Unix, Oracle BI Publisher (Oracle XML Publisher Builder 5.6.3), OBIA and Informatica.

Confidential,AL Nov ’07 – Aug ’09
OBIEE Consultant

Energen Corporation is a diversified energy company headquartered in Birmingham, AL. Through its two subsidiaries Energen Resources and Alagasco, Energen develops domestic American oil and gas properties and distributes energy-efficient natural gas in Alabama.

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.
• Involved Dimensional Data modeling based on Requirements.
• Involved in modifications on the Repository Metadata.
• Developed Logical Columns in Business Model Layer based on Business Requirements by using Time Series Objects and business logic’s, and creating the Presentation catalogs in Presentation Layer.
• Developed different kinds of Reports using Table and Pivot Views, View Selectors, Column Selectors, Narrative Views, Static Views, Chart and Plot Views, Title Views and Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.
• Developed different kinds of complex reports using Unions.
• Developed different kind of reports using BI Publisher.
• Extensively used Dynamic Section Prompts and Guided Navigation in dashboards.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Performed the Performance Tuning of Dashboards/Reports and made required changes to repository and database.
• I wrote SQL queries for testing and comparing the SQL result with report result.
• Performed Unit testing to validate report.
• Involved in UAT and post Production Support.
• Migrated Web Catalog and RPD from different environments by using PVCS.
• Worked closely with Users, Developers, Administrators and Testers to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository.

Environment: OBIEE, BI Publisher, Oracle E-Business Suite, Oracle 9i/10g, SQL, JavaScript, HTML, PVCS, Windows XP, UNIX.

Confidential,Pune, India Jan ’05 – Oct ‘07
Oracle/PL/SQL Developer
Responsibilities:

• Interface with Customers Management Team to capture and analyze business requirements.
• Worked with a team of IT developers in the Initial Database Design/Data Modeling/Data approval.
• Creating database objects including tables, indexes, clusters, sequences, roles, and privileges.
• Loading data from flat files into database tables using SQL* loader.
• Used the technical document to design tables.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Created Database triggers to maintain the database security.
• Optimized the SQL queries for improved performance.
• Used SQL loader to import data from large flat files and Excel sheets to Oracle tables
• Calculating and monitoring size and space for tables, clusters and indexes.
• Creating and maintaining triggers, packages, functions and procedures.
• Created users and established the application security by creating roles.
• Writing PL/SQL Stored Procedures, Functions, views, & Triggers for the application.
• Optimized the embedded SQL queries using statement level optimizer hints when essential, to adhere to the defined OLTP response time.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
• Unit testing and monitoring performance and providing System support.

Environment: Oracle 8i, Flat files, MS Access, SQL Plus, SQL LOADER, and Windows NT.