SUMMARY:

• Over 7 years of experience in Complete Software development Life cycle SDLC of Database, Data warehouse and Business Intelligence Applications.
• Having experience in OBIEE 11.1.1.5, 10.1.3.x, which includes Administration tool, Intelligent Dashboards, Answers, Delivers, iBots, Oracle BI Publisher.
• Experience in using OBIEE Answers for creating different Requests, Filters, Views, Charts, Interactive Dashboards with page and dashboard Prompts.
• Installed and configured different versions of OBIEE Informatica.
• Very strong experience in building Siebel Analytics/OBIEE Repository .rpd file at three layers Physical Layer, Business Model and Mapping Layer Presentation Layer using Administration Tool.
• Experience in creating Logical tables and columns, Dimensional Hierarchies, Level Based Measures and Repository Variables.
• Experience in security tasks like creating user groups, users and managing users by setting up their privileges and profiles.
• Experience in implementing Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables.
• Strong expertise in Implementing MUD Multi User Development Environment.
• Good hands on experience in using BI Publisher to create reports from BI Answers, BI server.
• Working experience in using OBI Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts.
• Knowledge over BI Publisher on converting Oracle Interactive reports, crystal, or actuate to BI Publisher.
• Expert in writing SQL queries, creating different PL/SQL Objects, Fine Tuning the code, and also in using SQL Loader for loading data into Data Warehouse/Data Mart.
• Experience in preparing Technical Documentation Training Users on DW/BI Products.

TECHNICAL SKILLS:

• BI Tools/Analytics : OBIEE 11.1.1.5, 10.1.3.x
• Database : Oracle11g/10g/9i/8i/7.x,SQLServer2005/2000,DB29.1.4,MSAccess
• Languages : SQL, PL/SQL, C, Java 1.3/1.4/1.5/1.6, HTML, XML
• Oracle Tools/Utilities : SQL Loader, Oracle Designer, SQL Explorer ,TOAD.
• Operating System : Windows Vista, Win 95/98/2000/XP, Win NT 4.0, Linux, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. OBIEE Developer

Responsibilities:

• Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of concept in translating functional requirements into technical requirements, designed, developed and making Technical designs and Unit test scripts for both real time and non-real time reports.
• Gathered requirements from the users and generated prototype reports to help the business to visualize the design.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes and for scheduling using DAC and reporting using OBIEE
• Configured DAC Data warehouse Access control for running of ETL jobs
• Worked with all three layers in the repository Physical, Business, and Presentation Layer.
• Implemented the Cache Purging Strategy and usage tracking of Reports.
• Created reports according to user requirements and also created corresponding dashboards for the reports.
• Trained the users on how to use the Dashboards and Answers and also modify the stored reports in Answers.
• Worked extensively with Oracle BI Publisher to develop custom reports where the Data Sets are SQL Query and BI Answers.
• Experience in designing Technical Specifications and developing reports in AP, AR, GL, KK and CDM modules.
• Expert in writing complex SQL queries for developing reports in BI Publisher.
• Performed Row level and Data level security for BI publisher reports.
• Used Dynamic Grouping, Dynamic Sorting, Pivot table, Cross tab calculations, Conditional formatting features in the RTF template to achieve the report functionality.
• Performed Page Level and Row Level calculations in RTF template.
• Involved in Unit Testing the reports based on the Unit Test plans, also performed negative testing.
• Implemented Row Level, Data Level and Column Level security for the repository.
• Performed several administrative tasks like setting up Oracle single sign on, setting up integration with Oracle BI Presentation services and setting up common report header.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Involved in post testing stage of the development and responsible for fixing the defects.
• Developed highly complex RTF templates for the reports and modified them according to the desired layout.
• Developed Ad hoc reports in BI publisher and implemented report parameters and List of Values SQL Query Based .
• Worked with Business Users for gathering the requirements and to define business and functional and technical specifications.
• Design, develop, test and maintain software to support the PeopleSoft Finance AP, GL, AR, CM and PO / PeopleSoft HRMS Core HR, Payroll, Benefits Administration and Base Benefit .
• Involved in Unit Testing and Systems Integration Testing during up gradation of PeopleSoft. Proficiency in upgrade, development maintenance of PeopleSoft Applications.

Environment: OBIEE 11.1.1.5, ODI 11g/10.1.3.4, Oracle 10g, PeopleSoft Financials 9.0.

Confidential

Position: Sr. OBIEE Contractor

Responsibilities:

• Created numerous Executive Level reports and generated Dashboards to provide insight into the financial data.
• Created Portfolio Dashboards by embedding reports and providing intuitive drilldowns, links to exploit the full benefit of Analytics.
• Enhanced existing Business Models created Customized Dashboards for Cash, Deal Portfolio reports in Asia, Europe US Regions.
• Created custom messages to make users choose particular Business Unit for Security reasons with respect to their Region.
• Created Report at each level of the responsibility Hierarchy, in order to allow managers and top Executives to enter their Comments, Review and Aggregate to the next level until they are finally consolidated at the top level of the Hierarchy.
• Worked closely with Users and Analysts to resolve ongoing Production Problems by reviewing design changes made to production systems.
• Performance Tuning of Dashboards / Reports and made required changes to database.
• Worked on Security Management for Users, Groups and Web-groups on LDAP authentication using Session Variables, as well as Dashboard / Report-level Security.

Environment: OBIEE 10.1.3.4.1, Oracle 8i/9i, SQL, Windows XP/2003 server.

Confidential

Role: OBIEE Developer

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements.
• Involved in the installation of different OBIEE components.
• Created a multi-user developer environment MUDE to enable multiple developers to work on one repository.
• Worked on OBIEE publisher to publish the reports in different formats.
• Configured and scheduled iBots to deliver the weekly and monthly reports.
• Involved in developing the dimensional modeling of STAR schema with fact and dimensional tables.
• Designed and developed the Metadata Repository .RPD Semantic layer using OBIEE Server Admin tool by importing the required objects Dimensions, Facts Aggregates with integrity constraints into Physical Layer using connection pool, developed multiple Dimensional hierarchies Drill-Downs Logical Facts / Measures objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• 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.
• Used Filters global and local and provided customized Prompts to avoid excessive data showing up in the reports.
• Created Aggregated Tables and configured the content in Business Model Layer to use the Aggregate tables for better performance.

Environment: Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4.1, Windows XP, UNIX/LINUX Oracle 11g/10g, SQL, PL/SQL, and TOAD 9.7.2

Confidential

Role: OBIEE Developer

Responsibilities:

• Business requirement gathering, understanding business objectives and analysis.
• Involved in Capturing User Requirement using technical specs.
• Creating reports and publishing them in the dashboards using answers
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Involved in creating ibots/Delivers for various requests.
• Involved in the analysis of the existing system reports and modification of the reports, created new reports based on the user requirements.
• Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the Presentation layer in the repository .rpd
• Involved in the removing the duplicate hierarchies and duplicate fields in the business layer when extract a query from the physical layer
• Performed OBIEE Administration including creation of Users and cache management
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters for performing the customer insights / trends using Presentation Services
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented caching to improve performance
• Granting access to users and maintain security by using database authentication and authorization.
• Organize Presentation Layer in a format that is easy for end-user to use as a basis for reporting
• Developed various report templates for different types of formatted reports.

Environment: Oracle Business Intelligence 10.1.3.4.1, HTML, XML, JavaScript, windows XP

Confidential

Role: OBIEE Developer

Responsibilities:

• Installed and configured OBIEE Admin tool and web components including Intelligence Dashboards, answers, and requests.
• Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
• Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
• Tested and validated the unit test cases
• Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting
• Worked on creation of repository variables and session variables.
• Worked with the Security settings in OBIEE Admin Tool to set up users, groups, access privileges.
• Designed and developed interactive navigational drill down reports in OBIEE, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.
• Using the Presentation Variable in prompts Report filters.

Environment: OBIEE 10.1.3.4.1, UNIX, Putty, SQL Developer