SUMMARY

• Having 10+ years of strong experience in Design, Development, Analysis, Implementation, Administration, Maintenance and Support of OBIEE 12C,11G,10G, OBIA, OAS, ODI
• Expertise in designing and development of Data Warehouse/Data Mart Analysis & Dashboard using Oracle Business Intelligence Enterprise Edition (OBIEE).
• Experience on development of BIAPPS with Oracle Business Intelligence (OBIEE) and Oracle Data Integrator (ODI) as Analyst and Developer
• Extensive experience in Oracle BI Administration Tool, BI Analysis, BI Dashboard, BI Publisher, BI Delivers, and iBots with OBIEE applications Manage resources from different vendors working from different geography
• Conduct Project Status meetings, mentor and provide architecture expertise
• Experienced in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Answers, Interactive Dashboards
• Expertise with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series & Caching.
• Experienced in Building Reports, different charts, narrative view, column selector, view selector, pivot table in corporate them into Dashboard pages and Dashboards with Prompts
• Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and pdf.
• Implemented the Security (Data level/Object level) and Value based Fragmentation.
• Worked with Presentation, Repository and Session variables.
• Worked on different types of navigations from one report to another.
• Working knowledge in Informatica Power Center and scripting languages python, java
• Good experience on OBIA Finance (Core GL Account Payables and Account Receivables), HR(Workforce, Payroll), Project (Project Costing, Purchase and Budget), Procurement and Spend(Purchase Order, Invoice Lines),Worked on ODI 11g and ODI 12c studios.
• Developed, Deployed and supported complex SSIS Packages for Data Migration and Transferring Oracle/Access/Excel Sheets using SQL Server SSIS.
• Experienced in BI Publisher, MS Office Plug - in for rich reporting.
• Experience in OBIEE Administration, configuring MUDE, OBIEE Schedule, usage tracking. Repository Sever and Presentation Server configuration changes, Cache management, space management.
• Experience in Deployment, Migration and upgrades of RPD and Web Catalog across instances and environment.
• Expertise in building solution driven OBIEE Dashboards using all the views in OBIEE 12c/11g along with Visual Analyzer Smart View and Word plugin, creating OBIEE Map Reports, Mobile Apps for BI Mobile, Scorecards and Key Performance Indictors (KPI) and tuning the reports for good performance
• ConfiguredAgentsto deliver BI content to subscribers based on schedule and events
• Involved in unit testing, integration testing of the reports generated by OBIEE.
• Worked on Oracle Analytics Desktop, OAS
• Migrated Oracle Hyperion Interactive Reports (Brio) to OBIEE
• Have worked on ODI to pull the tables to the warehouse using different mappings
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses
• Worked on the Crystal Reports and migrated crystal reports to OBIEE Reports.
• Good knowledge on ODI knowledge modules like RKM, LKM, CKM, IKM, and JKM.
• Worked in Informatica
• Worked on Oracle Analytics Cloud (OAC)

TECHNICAL SKILLS

TECHNOLOGIES: OBIEE 11G, 12c, OAS, OAC,OBIEE 10.1.3.4/ 11.1.1.6/11.1.1.7 /12.2.1.2.0 , OBI Apps 7.9.5/7.9.6/ 11.1.1.10.2 , Tableau 9.1

Database: Oracle 10g/11g, MS SQL Server 2005/2000, Sybase

Languages: C, C++, SQL, PLSQL

SOFTWARE PRODUCTS: SQL Developer / Toad

OPERATING SYSTEM: Windows, Linux Red Hat, Unix

BUSINESS AREAS: Business Intelligence Data warehouse

ETL Informatica: PowerCenter 8.6.1/9.1/9.5 , SSIS, ODI 11.1.1.9

PROFESSIONAL EXPERIENCE

Confidential, Florham Park, NJ

Sr BI Consultant

Responsibilities:

• Involved in all the requirement gathering meetings to understand the business requirement.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, and Tabular with global and local Filters) using OBIEE
• Trained and used OBIEE 12c and its data visualization tool.
• Created multiple reports using 12c Data Visualizer
• Modified OBIEE 11g RPD, so that it can work with OBIEE 12c
• Collaborate and work with end users to ensure that data and reports meet their business needs
• Design and monitor end-user reporting tools and systems, ensuring reports are accurate and up to date
• Analyzed and resolve data discrepancies, performance issues, defects and bugs
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer
• Implemented Hierarchies, Aggregates, Level based measures and Partitions to meet the business requirements.Migration of OBIEE to OACS
• Implemented a Change Data Capture (CDC) in ODI which increases efficiency of the job.
• ConfiguredAgentsto deliver BI content to subscribers based on schedule and events
• Involved in creating Users, Groups and managing the object level and data level security
• Worked on AP, AR, GL and Budget reports and customized them for new requirements
• Developed several Aggregate Tables and used them in rpd modelling for performance improvement
• Used the Catalog manager and maintained theOracle BI web catalogto manage Dashboards, Answers.
• Involved in unit testing, integration testing of the reports generated by OBIEE.
• Integrated BI Publisher with OBIEE answers and performed configurations.
• Created OBIEE 12c RPD, reports and dashboards using queries generated from PeopleSoft.
• Worked on RPD and report development for the AR & GL reports
• Developed good knowledge on EBS Functional modules with understanding its tables and models and able to resolve issues quickly.
• Developed OBIEE 11g/12c, Hyperion Interactive Reports, Oracle BI Publisher reports and Crystal reports 8.5, Cognos, designed dashboards, published jobs.
• Working knowledge in Informatica Power Center and scripting languages python, java
• Created ODI mappings, variables, procedures, load plans and Experience on Product Development of BIAPPS.
• Worked on Oracle BI Applications for EBS Financials - Financial Analytics, HR Analytics and US Federal Financials.

Environment: s: Oracle 12c, OBIEE 12c version 12.2.1.3, SQL Developer, ODI 12c (Oracle Data Integrator), OBIEE 12c VM, MS PowerBI, SQL, Toad, Linux, Informatica, Python, Hadoop, MapReduce, Jira, OACS, Angular JS, Peoplesoft, ETL and Jenkins.

Confidential

Sr BI Application Developer

Responsibilities:

• Developed Several Reports with different views using OBIEE for Oracle Financial Services Analytical Applications (OFSAA)
• Provided full-lifecycle support for migration efforts from development to QA to production analytics
• Involve in all the requirement gathering meetings to understand the business requirement.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Helped refine and determine feasibility, correctness, and completeness of end-user's requirements.
• Worked different sources ORACLE, SQL SERVER, SYBSASE and SALESFORCE
• Created various Drill -Down Reports.
• Worked on Cache mechanism to improve performance of the reports
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Developed various BI Publisher reports
• Implemented a Change Data Capture (CDC) in ODI which increases efficiency of the job.
• Implemented Hierarchies, Aggregates, Level based measures and Partitions to meet the business requirements.
• Experience on Product Development of BIAPPS.
• Worked on different types of Variables, Migration of OBIEE to OACS
• Worked on Financial reports by using oracle EBS as a source system.
• Created ODI Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Router, Joiner
• Developed OBIEE 11g/12c, Hyperion Interactive Reports, Oracle BI Publisher reports and Crystal reports 8.5, Cognos, designed dashboards, published jobs.
• Performance tuning of Dashboards / Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes

Environment: s: Oracle 12c, OBIEE 12c version 12.2.1.3, SQL Developer, ODI 12c (Oracle Data Integrator), OBIEE 12c VM, MS Power BI, SQL, Toad, Linux, Informatica, Python, Hadoop, MapReduce, Jira, OACS, Angular JS, Peoplesoft, ETL and Jenkins.

Confidential

System Dev Sr BI Specialist

Responsibilities:

• Developed the interactive dashboards with different types of navigations like navigating to different dashboard and reports.
• Implemented cache management and enhancing query performance,As a part of performance tuning
• Testing and validation of variousODIMappings and associated Workflows
• Involved in all the requirement gathering meetings to understand the business requirement.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer
• Involved in building logical dimensional hierarchies based on the reporting requirement.
• Implemented security both at rpd level and at catalog level.
• Lead the team from beginning, responsible for work break down structure and tasks / open issues tracking and status update to the project sponsors
• Developed various BI Publisher reports
• Providing technical support in various OracleEBSmodules like Inventory, Fixed Assets, Accounts Receivables, Accounts Payables, General Ledger.
• Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data.
• Added users and configured security in web logic console of OBIEE 11g.
• Trained End Users and Pilot Users about OBIEE Tools and BICS.

Environment: s: Oracle 12c, OBIEE 12c version 12.2.1.3, SQL Developer, ODI 12c (Oracle Data Integrator), OBIEE 12c VM, MS Power BI, SQL, Toad, Linux, Informatica, Python, Hadoop, MapReduce, Jira, OACS, Angular JS, Peoplesoft, ETL and Jenkins.

Confidential

Data Visualization Engineer

Responsibilities:

• Ensure quality and continuity of the desired deliverable
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer
• Involved in building logical dimensional hierarchies based on the reporting requirement.
• Done customization on oracle financials and added segmentation data into existing subject areas.
• Done customization on oracle financials and added segmentation data into existing subject areas.
• Performed Data Validation of data in the reports and dashboards.
• Performed production support activities/trouble shooting the issues.
• Worked on Oracle Application Express and developed few reports
• Worked on Financial reports by using oracle EBS as a source system.
• Prepared and maintained documentation for all new or modified RPD objects and ETL mappings.
• Development of RPD in MUD environment.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.
• Developed the interactive dashboards with different types of navigations like navigating to different dashboard and reports.
• Developed Master Detail reports, with drilling at various levels.
• Manage resources from different vendors working from different geography
• Worked on Object level and Data level security.
• Worked on different types of Variables.
• Ensure smooth Ops transition by KT and documentation

Environment: s: Oracle 12c, OBIEE 12c version 12.2.1.3, SQL Developer, ODI 12c (Oracle Data Integrator), OBIEE 12c VM, MS Power BI, SQL, Toad, Linux, Informatica, Python, Hadoop, MapReduce, Jira, OACS, Angular JS, Peoplesoft, ETL and Jenkins.

Confidential

Report Developer

Responsibilities:

• Analyzed and decoded Python scripts used for building reports and dashboards
• Developed the interactive dashboards with different types of navigations like navigating to different dashboard and reports.
• Developed some out of box components using JavaScript and html encoding
• Developed pop up hover windows that will display drill down detail reports
• Developed different types of graphs.
• Developed Custom Search functionality using Oracle BI AutoComplete.
• Worked on conditional formatting on both pivot and chart views.
• Worked on Object level and Data level security.

Confidential

Data Visualization Developer

Responsibilities:

• Understanding the existing bqy (BrioQuery-HYPERION IR Report) files.
• Understanding and analyzing the feasibility of existing report-query section, results section, report sections, dashboard pages.
• Developed the reports with different views.
• Developed the interactive dashboards with sub-reports that are currently available in HYPERION IR
• Developed custom java scripts for creating buttons(enabling/disabling) and downloading the reports in various formats.
• Created Agent for Scheduled Reports on weekly, monthly basis.
• Performance tuning of Dashboards / Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes

Confidential

BI Report Developer

Responsibilities:

• Importing the metadata tables from the database to the OBI Administration Tool for customizing and modifying the Physical, BMM Layer and Presentation Layers of the metadata repository.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer
• Involved in building logical dimensional hierarchies based on the reporting requirement.
• Implemented security both at rpd level and at catalog level.
• Developed different kinds of Reports, pivots, Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.
• Worked on Fragmentation mechanisms.
• Used Variables in the process of making the reports and in implementing data level security.
• Developed several Aggregate Tables for performance improvement
• Created Agents (Ibots) for Scheduled Reports on weekly basis.

Confidential

OBIEE Report Developer

Responsibilities:

• Understanding reports requirements and customizing the Repository to meet the business requirements.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer.
• Developed various Interactive Dashboards
• Developed Reports in different views like charts, narrative view, column selector, pivot table.
• Created various Drill -Down Reports.
• Worked on Cache mechanism to improve performance of the reports
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Used Row-Level Initialization to implement data level security