SUMMARY:

• Having 8 years of software development experience in IT Industry. Proficient in DW Concepts, Data Modeling, Star Schema, Dimensional Modeling, OBIEE Repository Development, Creating Dashboards and Reports in OBIEE Projects.
• Expertise in complete SDLC which involves requirement gathering, proof of concept, gap analysis, converting functional to technical specification, design, development, testing and implementation of OBIEE/ Informatica/ETL/Data Ware housing.
• 7+ years of strong experience in OBIEE 11.1.1.x &OBIEE 10.1.3.x which include building and configuring repository (rpd).
• Experience in Data warehouse Extraction, Transformation and Loading (ETL) using Informatica Power Center.
• Expertise in configuring Data Warehouse Administration Console (DAC) for creating execution plans and metadata management.
• Expertise in OLTP/OLAP system study, analysis and E - R modeling, developing and experience working with multi-dimensional data model, star schema and snowflake schema.
• Worked extensively on OBIEE Administration Tool, OBIEE Answers (ad-hoc querying, reports), OBIEE Dashboards, OBIEE Delivers (alerts) and Oracle BI Applications that are complete pre-built BI solutions.
• Experienced in design and development of all the 3 layers of OBIEE repository (Physical Layer, Business Model & Mapping and Presentation Layer).
• Experience in Security setup at both Data and Object levels, which involved creation of users/groups and LDAP authentication setup.
• Extensive experience in configuring Interactive Dashboards with drill-down capabilities using global and local filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experienced in writing, testing and implementation of Stored Procedures, Triggers, Functions, and Packages at database level using PL/SQL.
• Extensive experience in performance tuning, identifying bottlenecks and resolving to improve performance at database and reporting level.
• Familiar in configuring and customizing of Oracle BI Publisher/XML Publisher.
• Experience in extracting data from RDBMS, OLTP, flat files and loading data to OLAP systems.
• Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Responsible for Unit, System and Integration Testing and performed data validation for all the reports that are generated from OBIEE/Siebel Analytics.
• Excellent problem solving skills with a strong technical background and result oriented team player with excellent communication and interpersonal skills.

TECHNICAL SKILLS:

Business Intelligence Tools: OBIEE 11.1.1.6/1.5 /1.3, 10.1.3.4, OBIA 7.9.6.X / 7.9.5

ETL Tool: InformaticaPowercenter

RDBMS: Oracle 11g, 10g, MS SQL Server 2008R 2/2008/2005/2003

Languages: XML, HTML, PL/SQL, SQL.

Front End Tool: TOAD, SQL *Plus, SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, MD

Sr. OBIEE Developer

Responsibilities:

• Performed gap analysis and feasibility study for the given requirement.
• Created mockup reports and dashboards for review by the business users.
• Customized the OBIEE Repository (physical, BMM, and presentation layers).
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Worked on repository and session variables.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Created materialized views and aggregates to improve performance.
• Created different Time series reports(using Month ago, To date) to develop more enhanced reports.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Performed Data Validation of data in the reports and dashboards.
• Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.
• Worked extensively with BI Publisher 11g.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Documented the design for intuitive understanding and future reference.
• Performed production support for the project.

Environment: OBIEE 11.1.1.6/1.5, BI Publisher 11g, Informatica Power Center 9.5/9.x, SQL *Plus, PL/SQL Developer, SVN Tortoise.

OBIEE Admin/Developer

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Worked with Oracle BI Apps, Oracle BI Server, Presentation Server, Oracle BI Administration Tool and Oracle BI Publisher.
• Performed GAP analysis between existing database tables and Business Process Requirements and recommended enhancements to metadata reporting in all 3 layers.
• Configured OBIEE repository (rpd) with 3 layers i.e., Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Configured dimensional hierarchies for drill down, aggregate navigation, level based measures and time series functions based on the requirements.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Implemented OBIEE Security (Object level and Data level Security in the OBIEE repository and answers) using repository variables, session variables and initialization blocks.
• Created security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Developed User Interface (UI) components folders, dashboards, pages columns, sections, requests/answers, filters, global filters, navigation links, and views/charts using Oracle BI Presentation Services.
• Developed different kinds of reports (pivots, charts, tabular) using global and local filters.
• Configured many Dashboards with different views (Pivot Table, Chart, Tabular and View Selector), dynamic dashboard prompts and guided navigation links.
• Performed performance tuning of dashboards/reports and made recommendations for changes to database.
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Created Oracle BI Publisher reports based on Oracle BI Answers request and designed using Microsoft Word.
• Worked on Multi-user development environment (MUDE) and created different projects.
• BI Apps/OBIEE implementation of Financial Analytics Subject Areas.
• Financials - AP Balance, Financials - AP Invoice Aging, Financials - AP Overview, Financials - AP Transactions, Financials - GL Balance Sheet, Financials - GL Budget and Expenses, Financials - GL Cash Flow, Financials - GL Detail Transactions.
• Worked with Financial Analytics Dashboards.
• General Ledger: Overview, Balance Sheet, Cash Flow, Budget vs. Actual, GL Balance.
• Payables: Overview, AP Balance, Payments Due, Effectiveness, Payment Performance, All AP Transactions.
• Involved in merging and migrating applications from development to production for deployment.

Environment: OBIEE 10.1.3.4, Oracle 11/10g, DAC, Erwin, OBIA 7.9.6,TOAD,Informatica Power Center 8.6, Oracle SQL, BI Publisher, Windows XP.

OBIEE Consultant

Responsibilities:

• Worked with Business analysts as well as other business teams on requirement gathering.
• Developed OBIEE repository (rpd) at 3 layers i.e., Physical Layer, Business Model & Mapping Layer and Presentation Layer.
• Designing and developing physical and logical star schema using OBIEE admin tool.
• Developed the metadata repository (rpd) as per the requirements collected by data analysis and applied business rules in the BMM layer.
• Import/create tables and add/change physical joins/keys.
• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Modified presentation layer dimensions and attributes to match user requirements.
• Created dimension hierarchies, time comparisons and level based measures.
• Created time series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions.
• Administered Nqsconfig.ini and Instanceconfig.xml configuration files.
• Created session and repository variables to achieve desired functionality.
• Worked extensively on various Cache Management techniques to increase the performance of the reports.
• Security management for users, groups and web-groups using the various authentication systems such as LDAP, Database; and Database table authentication using Session variable features, as well as Dashboard / Report-level security by creating initialization blocks.
• Developed many complex reports/ad-hoc queries and dashboards with different analytics views drill-down/dynamic, pivot table, chart and column selector, with global and local filters using Oracle BI Presentation Services.
• Administered analytics intelligence dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables.
• Utilized delivers for sending real-time, personalized alerts via intelligence agents (iBots) to intelligence dashboards for subscribed users.
• Involved in creating the highly formatted parameterized BI Publisher reports that use various data sources such as BI Answers and Subject Areas.
• Actively involved in implementation of Oracle Financial (General Ledger, Payables and Receivables) & HR Analytics and developed custom reports and created ad-hoc reports according to the client needs.
• Life-cycle support for migration efforts from development to QA to production analytics.
• Involvement with ETL (Extract-Transform-Load) development team to communicate the specification for the required dimensional, aggregate and indexed data tables.
• Involved in Unit testing and documentation.

Environment: OBIEE 10.1.3.3, Oracle 10g, Informatica Power Center 8.6, SQL Developer, Oracle BI Apps 7.9.5, Financial Analytics, TOAD, Windows XP.

OBIEE/Siebel Analytics Developer

Responsibilities:

• Worked closely with Business Analyst in understanding the analytics requirements and generated reports as per the user requirements.
• Presented the overall repository (rpd) metadata development methodology.
• Configured Analytics repository (rpd) with implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Modeling activities which included building star schema as per the business requirements and configuration of logical layer, logical tables, dimensions and columns in business model and mapping layer. Established the logical joins/keys required to support drill-down aggregation.
• Created aggregate tables, imported and configured in Admin tool to perform aggregate navigation.
• Implemented security by creating roles and web groups, checks with LDAP Authentication.
• Worked extensively on OBIEE answers to create the reports as per the client requirements.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.
• Implemented the delivery of iBots using Siebel Delivers to alert the associated teams.
• Extensive experience in performance tuning, identifying bottlenecks and resolving to improve performance at database and reporting level.
• Migrated the rpd metadata and web catalog contents to test and production environment.
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality.
• 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 the repository.
• Involved in developing Initial and Incremental ETL process i.e., Mappings &Mapplets using various Transformations and Workflows with Sessions/Tasks.

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8, Informatica Power Center 7.1,Oracle 9i/10g, Windows 2000.