SUMMARY:

• Having 8+ years of experience in Analysis, Application Development, Maintenance, Implementation on Oracle 11g/10g/9i/8i, Oracle business Intelligence (OBIEE) Reporting.
• Expertise in providing end to end BI solution by configuring metadata and building Analytics Repository, dimensional modeling design, building business models, generating reports and creating dashboards using Analytics and OBIEE.
• Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.
• Expertise in fine tuning reports by using view selector, column selector, is prompted, drill down - drill through analysis, creating master/detail reports, using database, numeric, date and time functions etc., where ever necessary to increase performance.
• Expertise in developing all 3 layers of the Analytics Repository (Physical Layer, Business Model & Presentation Layer).
• Proficient in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer), Time Series Objects, configuring metadata, Answers, Delivers / Interactive Dashboards / Reports with drill-down & drill-across capabilities using global & local Filters, Security Setup (Groups and Access Privileges), Web Catalog Objects and scheduling iBots.
• Experience in Debugging, Optimizing and Performance Tuning of Oracle BI Analytical Dashboards/Reports.
• Extensive experience with SQL and PL/SQL.
• Experience in OBIEE/BI Apps (OBIA) with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analyticsand HR Analytics.
• Experience on Data Warehouse (Star Schema, Snow Flake and Extended Star Schema, ETL, DW, DM) and testing as well.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Analytical Dashboards/Reports.
• Expertise in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Work lets & various Tasks and scheduling them using both Workflow Manager and Unix Shell scripts (pmcmd).
• Good experience with configuring Data Warehouse Administration Console (DAC) for Creating Execution plans, metadata management and monitoring the Informatica ETL Process.
• Configured and registered the custom workflows in DAC.
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellent communication skills.

TECHNICAL SKILLS

Reporting Tools: OBIEE 11g, 10.1.3.x, Siebel Analytics 8.x/7.x, OBIEE Analytics 10.1.3.4/7.8/7.7.1/7.5 (Oracle BI Administration, Oracle BI Presentation, Oracle BI Answers, Oracle BI Dashboards, Oracle BI Delivers, Oracle BI Publisher, Catalog Manager), Oracle BI Applications 7.9.x(DAC, Informatica, OBIEE Platform), Scheduler (iBots).

ETL: Informatica-9.x/8.x/7.x, DAC 11g, 10.1.3.4.1, ODI 11g, SQL Loader.

Databases: Oracle 11g/10g/9i, SQL Server 2005, 2008.

ERP: EBS R 12, 11.5.10,Seibel CRM,PS HCM 9.x, PS CRM 9.1

Query Tools: TOAD, SQL*PLUS, SQL Developer.

Testing tool: Quality Center.

Languages: PL/SQL, XML, C#.

Operating System: Unix, Linux, Windows 7/Vista/XP/2003/2000.

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

OBIEE/ODI Developer (Lead)

Responsibilities:

• Involved in building detailed project schedule, gathering the requirements, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and made Technical designs and Unit test scripts.
• Installing, upgrading and configuring OBIEE tools. Setting up Load balancing (Clustering) and OBIEE Linux/Windows environment.
• Setting up Usage Tracking.
• Setting up OBIEE MUD environment.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support
• Exceptional background in analysis, design, development, customization and implementation and testing of software applications and products
• Demonstrated expertise utilizing ETL tools, including Oracle Data Integrator (previously known as Sunopsis), Informatica.
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• Strong leader with experience training developers and advising technical groups on ETL best practices.
• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE/Siebel Analytics Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Configured metadata objects (Subject Area, Table, and Column) and Web Catalog Objects (Dashboard, Pages, Folders, and Reports).
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services/Siebel Analytics Web.
• Upgrading OBIEE 10g to 11g and fixing the errors coming on the way.
• Implemented Security by creating roles and web groups, checks with External tables and LDAP.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the SQL execution path by making use of hints etc.
• Created VPD security for reports in OBIEE.
• Migration of existing reports in Oracle EBusiness Suite (such as Purchase Orders, Deposit slips, checks etc.) to BI Publisher.
• Involved in setting up integrated maps, working with spatial analytics
• Life-cycle support for migration efforts from Development to Integration Test to Production Analytics.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• 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 OBIEE/Siebel Analytics Repository.
• Performed Data Validation of data in the reports, Fixed all the errors and warnings in the repository and web catalog.
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.
• Supporting Informatica Server and related components within the Oracle BI Package
• Involved in Upgrading the OBI Apps from 7.9.6.2 to 7.9.6.3 and also involved in setting up of the DAC which has the backup of your DAC client and Server and DAC metadata files.

Environment: Oracle 11G,OBIEE 11.1.1.3/10.1.3.4, OBIA 7.9.6.3,Oracle BI Apps (HR Analytics & Financial Analytics) Data Modeling(ER Win),BI Publisher, DAC, Informatica Power Center, TOAD.

Confidential, New Orleans, LA

OBIEE Developer

Responsibilities:

• Interacted with managers, financial business team and other business users to gather the reporting requirements.
• Involved in installing and configuring the Manufacturing analytics - BI Apps 7.9.6.4. Also, involved in providing the proof of concept to the management team.
• Providing high level estimate of the Fit-Gap Analysis by comparing business requirement and OOTB reports and dashboards.
• Developed the OBIEE repository by Involved in designing the physical, BMM & presentation layer using the OBIEE Admin tool.
• Involved in creating data filters in OBIEE Admin tool based upon the division.
• Developed ad-hoc manufacturing reports and manufacturing sales, production performance and inventory dashboards as per the BRD document using OBIEE UI.
• Designed the web page action link to navigate from OBIEE report to a more detailed BO report.
• Implemented MSAD authentication using OBIEE web logic console.
• Involved in creating custom application roles to implement role based security in OBIEE 11g.
• Created Data filters to implement row level security in OBIEE Admin tool.
• Involved in migrating the OBIEE contents from one environment to other.
• Involved in implementing the Usage Tracking for users - query counts report.
• Installing, upgrading and configuring OBIEE tools. Setting up Load balancing (Clustering) and OBIEE Linux/Windows environment.
• Setting up Usage Tracking.
• Setting up OBIEE MUD environment.
• Developed Custom Mappings and Workflows in Informatica to bring the data from Oracle EBS system.
• Involved in customizing the DAC execution plan.
• Monitored Incremental and full load of data through Data Warehouse Administration Console (DAC).
• Worked on customizing the design, setup and execute tab of DAC on a custom created source system container.
• Involved in unit testing and integration testing of OBIEE reports and dashboards.
• Co-ordinated with testing team to fix the reports issues.
• Trained end users and DWH core team in using the OBIEE 11g.
• Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage

Environment: BI Apps 7.9.6.4, Oracle BI 11g, EBS 11.5.10, Oracle 11g, SQL Server 2008, Business Object, Toad, Informatica 9.x.

Confidential, New York, NY

OBIEE Consultant

Responsibilities:

• Responsible for the installation of BIApps 7.9.5.
• Installed and Configured OBIEE, DAC and Informatica on Unix/Linux Environment.
• Integrated OBIEE with EBS for Single Sign On (SSO).
• Developed the Common Processes (Mapplets, reusable Expression Transformations and Lookups) for the data validation and Exception Handling
• Used error routines and exceptions handling techniques as per business rules
• Precise Documentation was done for all mappings and workflows.
• Worked on Map Gap Analysis for Financial/Procurement Analytics.
• Worked on SR’s with Oracle in solving issues.
• Used ETL processes to load data from Flat files, Oracle Databases into the target OLAP databases.
• Designed and Developed Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard.
• Designed and Developed Procurement and Spend and Supplier Performance, General Ledger, Payables, Receivables, Profitability, Dashboards in OBIEE.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• 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.
• Used BI publisher for special reporting requirements.
• Designed, implemented and tested security privileges on Dashboards and reports.
• Configured and validated OOTB Profitability and Payables Analytics.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Worked on the testing and validating the Repository in OBIEE.
• Customized Dashboard Pages Like Total Spend Overview, Trends, Exceptions, Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee Expenses in Procurement and Spend Dashboard in OBIEE.
• Designed and Developed Sessions and Workflows.
• Customized Purchase Requisitions, Purchase Orders, Purchase Receipts and Employee expenses OOB dashboard pages in Procurement and Spend Analytics.
• Imported and Exported Execution Plan in DAC from one Instance to other Instance.
• Developed RMA Detail Report in Order Management by using OBIEE.

Environment: BI Apps(OBIA) 7.9.5, OBIEE 10.1.3.4.0, Informatica 8.1.1, Data Warehouse Administration Console 7.9.5, Human Resource Analytics, Financials Analytics, Order Management Analytics, Procurement & Spend Analytics, Oracle 10g, SQL*PLUS, SQL*Loader, TOAD, Unix.

Confidential, LA

System Engineer

Responsibilities:

• Java Programming.
• Developed batch upload processes for cameo web application.
• Developed better techniques to optimize current web applications and services.
• Setting up OBIEE on Linux and Windows servers, and using it for generating reports and data analysis.
• Creating technical/application design specifications, hands-on coding, building and deploying the code in lower environments, unit testing and troubleshooting applicationissues and fixes.
• Develop/update scripts forOracle Database.
• Assisting in setting up build environments.
• Identifying the tasks and provide the level of effort to complete the tasks.
• Creating unit test results report.
• Contribute to new technology projects as assigned and provide operations maintenance support for existing.

Environment: Java, BI, Oracle, Windows.