SUMMARY

• Around Eight years of experience in Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Business Intelligence Apps(OBIA).
• Very Knowledgable in Oracle Data Integrator (ODI).
• Installation and configuration of BI APPS 11.1.1.7.0 , integrating it with Oracle Data Integrator (ODI) 11.1.1.
• Worked closely with Toad Data Modeler for use of making out the data co - relation within the model.
• Use of APEX for sketching out some reports from this transactional system mainly used them for compensation and personnel reporting and also for some data loading into unloading.
• Knowledgeable with PL/SQL in writing complex queries.
• Patching Perl scripts as part of the configuring of BI Apps.
• Enable the specific BI Application offerings and configure the duty roles for the user and grant access to the configuration manager and functional setup manager.
• Setting up BI Applications instance through Configuration Manager, managing domain load plans as part of the system setup.
• Expertise in ERP analytics applications such as Financial Analytics, Procurement and spend Analytics, HR, and Project Analytics.
• Experience in configuring interactive Dashboards with drill-down capabilities using global and local filters, OBI Security Setups (groups, access / query privileges), Metadata objects, and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Ability to design and develop ad hoc queries, reports, analytics through OBIEE solutions
• Experienced in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact and Dimensions tables and Physical and Logical data modeling in the OBIEE Administration tool.
• Schedule Delivers through configuring agents to send alert messages based on the threshold value to the users
• Experience in gathering business requirements, Design / Modeling with Star and Snowflake Schemas
• In depth knowledge managing SDE and SIL using the Data Warehouse Administration Console (DAC)
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local filters
• Strong in de-bugging, optimizing and performance tuning of Oracle BI Dashboards / Reports
• Manage security privileges for each subject area and dashboards according to user requirements
• Intermediate skill in developing mappings using various transformation son data imported from multiple sources to data Warehouse, creating workflows with work-lets & tasks and scheduling using workflow manager
• Intermediate knowledge working with Informatica Server and Client tools like Power Center Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Server Manager
• Working closely with the database developers on indexes and the data in the tables with the appropriate facts and dimension measures
• Participate in gathering customer requirements & use it for dimensional modeling
• Working with DBA’s, Java Developers, QA and the entire team throughout the project and sort out some developmental and administrative tasks
• Hands on experience with SQL Developer for access to database tables, create new tables and update/delete the data as per the requirement

TECHNICAL SKILLS:

• OBIA 11.1.1.7
• ODI 11.1.1.
• OBIEE 11.1.1.x/10.1.3.x
• Siebel Analytics 7.8/7.7/7.5 and Publisher
• Oracle 10g 11g 9i and 8i
• SQL Server 2000/ 2005
• My SQL
• MS Access
• Informatica
• Data stage and Meta Data
• SQL developer
• TOAD
• Data Warehouse Application Console
• C
• C++
• C#
• SQL
• Java script
• Windows
• Linux and UNIX
• Microsoft suite - Excel
• Outlook
• Word and PowerPoint
• MS Project and MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh

OBIEE/ODI Developer

Responsibilities:

• Used Oracle Data Integrator (ODI) primarily for loading data across to the dimensional and transactional schemas.
• Skilled in ODI in working with complex mappings.
• Setup OBIEE, ODI installations in Sandbox and in the development machines on Windows Server 2008, 2012.
• Use of Oracle application express (APEX) and built a few reports of this transactional system for personnel and compensation.
• Using Toad Data Modeler to understand the data and the information is linked and getting an idea on the enterprise’s model.
• Repository modeling using the OBIEE Admin Tool and making deployments for custom skins styling.
• Setting up security at the data level for business users to view only their respective reports and catalog.
• Making calculations at the report level and at the logical model and mapping level for attaining the business requirements.
• Rpd deployments and requesting for imaging of the box.
• Worked with advanced Trellis views and pivot table views and other basic data visualizations for the look and feel good reporting.
• Understanding the business in the best possible way to make things easier by meeting with the business analysts.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.7.1 , ODI 11.1.1, Linux, APEX, Toad Data Modeler, Toad developer, SQL developer.

Confidential, Chicago, IL

Senior OBIA/ OBIEE Consultant

Responsibilities:

• Emdeon was our end client while Confidential . was the implementer I work for. Emdeon is a health insurance company based out in Nashville, TN. I worked as an OBIA Consultant performing an out of the box for them focused on Financials, Project Analytics and Procurement & Spend Analytics.
• Extensively worked on Financials, Procurement & Spend, and HROOTB reports and dashboards as part of the OBIA full cycle implementation for Emdeon.
• Actively interacted with project managers & team members to discuss timely deliverables, project status & documented technical specifications from functional specifications in reporting point of view.
• Financials, Proc& Spend dashboards customization as per user requirements.
• Data Visualization in choosing what columns to present and employing the right presentation techniques for easy understanding and analysis by users.
• Worked on data formatting custom reports that involve look and feel customizing.
• Used custom filters & dashboard prompts appropriately to avoid excessive data showing up in reports and maintained effectiveness in creating the dashboards by using guided navigational links & drilldowns.
• Report debugging using sql developer, informatica, data lineage to see where the data is getting populated and also checking .csv files to see correct data is being used in the mappings.
• Developed several dashboards and reports which are used by managers to identify most profitable customers and analyze revenue trends by customer to identify opportunity/risk.
• Worked on three way repository merging, report switching in dashboards, configuring role based security for users, defining the permissions for users to access subject areas, catalog, and dashboards and ad-hoc analysis.
• Implemented descriptor id functionality on dashboard prompts for handling double columns.
• Extensively used OBIEE Analytics Administration Tool for customizing and modifying the Physical layer, BMM and Presentation layers of the repository (.rpd)as per the additional columns needed in the analytics for reports and dashboards.
• Created dimension hierarchies & level based measures in BMM layer based on requirements.
• Developed many Reports/Dashboards with different Analytics Views using Drill-Down & Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters within Oracle BI Analytics.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Involved in the migration of RPD and catalog files from TEST to PROD environment.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.7.1 , OBIA 7.9.6.4, EBS R12, Oracle 11g, SQL Developer, Informatica, Windows.

Confidential, St. Louis, MO

Sr. OBIEE Developer

Responsibilities:

• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel / Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design of Reports / Dashboards, Analytical Data Model (Metadata / .rpd) and performed Fit/Gap Analysis between existing Sales, Call center reports and new requirements.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer, customized the existing model and Created hierarchies, variables, and event poll strategies in the repository.
• Developed and customized OTB reports and new Reports, cosmetic changes to Dashboards with different subject matter Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / Oracle Business Intelligence (OBI) Presentation Services for the various work streams and sales force.
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table execution path by making use of hints, Creation / Re-building of Indexes and managing Cache etc.
• Created Week Ago and Month Ago and Year Ago Fact Measures and Dimension attributes.
• Created and customized reports with different views - Table, Pivot Table, Charts, Column Selector, etc using Answers
• Migration performed from OBIEE 10g to OBIEE 11g using Upgrade Assistant and performed OBIEE 11.1.1.6 fresh install on windows based boxes.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Configured and automated iBots to deliver Analytics content.
• Customized OTB mappings for Financial Analytics, Procurement and Spend Analytics.
• Prepared the Test Plans and Test cases for validating the reports/dashboards.
• Written many SQL statements for validating the reports and used the same in Test documents.
• Created new mapping for extension and bridge tables that were not supported in OTB.
• Created the OBIEE environment for Development, QA and Production environment.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Identified complex bugs in production and resolved them.

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.x/10.1.3.x, Oracle 10g, Linux, TOAD

Confidential, Phoenix, AZ

Sr. OBIEE Consultant

Responsibilities:

• Experience working with Analysis (11g) to build reports and customizing them based on requirements
• Develop and support creation of Ad-hoc answers requests in OBIEE.
• Customize reports look and feel using column formatting, conditional formatting.
• Implement external database authentication security by creating tables in the database, encrypting the passwords and assigned roles and permissions for the users in the Administration tool as well as in the presentation service areas.
• Perform validation of data on the reports and monitor the performance.
• Prepare monthly reports and present it to the management for additional analysis.
• Scale out and configure for high availability, identify and point out single point of failure
• Manage performance and availability which includes managing services levels and tuning performance
• Manage and resolve issues, which includes diagnose errors and establish facts
• Implement sensitive tasks like starting and stopping server when required, which includes bringing the server box up & down in during maintenance tasks
• Configuring securities, which include security access to the business intelligence system, metadata, and data configure secure socket layer (SSL) and single sign on (SSO) and integration with management system
• Administer and create documentation on reports and system environment
• Provide system integration support to other teams and troubleshoot critical issues
• Work in collaboration with development and software support team
• Using ETL solutions to aid the reporting process across the enterprise

Environment: OBIEE 11g, 10.1.3.4.1 Clustering, Web logic 10.3.2, Informatica 8.6.1, BI Scheduler, Oracle Client 11g, TOAD

Confidential, Columbia, MD

OBIEE Developer

Responsibilities:

• Experience working on OBIEE 11.1.1.5 version for creating BI Publisher Reports for Fiscal Year 2014 under the Program End-Stage Renal Disease (ESRD).
• Work on the performance score Summary and performance score Reports for CMS in English and Spanish Languages.
• Create data models for reports including the RTF Templates, defining table styles, paragraph styles and defining deader and footers.
• Also adding translations to the style templates to support Spanish translated RTF, which involved XLIFF (.xlf) files for style templates.
• Worked with inserting data fields, charts and performed calculations on fields within the template along with conditional formatting.
• Worked in both connected and disconnected modes.
• Loading data from the sample XML files and also uploading the Layout template file to the BI Publisher Catalog.
• Use field browser to edit, review and update to refresh the form fields added or modified.
• Configure report general properties including caching, formatting, font mapping and currency Formats.

Environment: OBIEE 11g., Oracle 10g, PL/SQL Developer, Windows Vista, MS Word 2007, JDK 1.5,Oracle Application Server 10.1.3.1, Explorer 7.0

Confidential, Rosemont, IL

OBIEE Developer

Responsibilities:

• Proficient in use of filters to narrow down the analysis part for easy understanding to the business users and managers
• Develop reports with different Analytics Views (Drill-Down, Pivot, View Selector and Tabular with Filters) using OBIEE Answers
• Acquainted with Multi-User Development Environment (MUDE)
• Experience on OBIEE Skin & Branding as per client requirement
• Analytics Application Response-time Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views
• Implementation of criteria filters to narrow-down the result set from the analytics requests
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations Deal with on-shore and off-shore clients and ensure project delivery on time
• Configure, manage application role & policies for user group using Enterprise Manager (EM)
• Maintain and monitor the data documentation for all data warehouse and reporting formats
• Manage and configure security settings (groups, roles, and access/query/report privileges) and schedule using iBots
• Centrally manage Oracle BI system components using oracle web logic server administration controller
• Proficient in design and customization of BI Answers/Analysis, Reports, Dashboards, Oracle Delivers
• Manage and configure the system for development after installation which includes configuring metadata and content general ps and default system settings
• Perform Unit and Regression testing on all the reports developed to maintain consistency and efficiency to meet the user’s requirement

Environment: OBIEE 11.1.1.5.0 , OLAP, Informatica, SQL Developer,Windows 2008 Server,TOAD, PL/SQL Procedures.

Confidential

Siebel Developer

Responsibilities:

• Extensively worked on Answers, Dashboards, Security and creating complex reports using Seibel
• Experience setting up security at both object and data levels, which includes creation of users/groups, and permissions.
• Work on Aggregates, Hierarchies, Calculation wizard in the Logical Layer
• Develop and Schedule workflows using workflow Manager created and modified parameter files according to the business requirements
• Useof aggregator, sequence Generator, expression, transaction control, Normalizer transformations according to the need
• Perform requirement gathering, scope analysis and finalize the functional points.
• Design and develop design document for common functions and packages
• Develop and test PL/SQL for errors and diagnose them
• Design, develop, and test PL/SQL procedures, functions and packages.
• Impemented group level security in OBIEE to setup access privileges to users.
• Implement materialized views, bulk binding and collections to achieve performance for PL/SQL programs
• Prepare technical specifications and common function manuals for the releases
• Demonstrated knowledge in PL/SQL, performance tuning, trouble shooting and OBIEE administration.

Environment: Siebel Answers 7.5, Informatica Power Center 5.1, PL/SQL, Oracle 8.1, SQL Server 2000, SQL 6.5, Windows XP