EXPERIENCE SUMMARY:

• Over 8 years of experience in the IT industry involving requirement analysis, design, development of database and implementation of reporting tools, RDBMS and Client Server applications under different environments.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers includingPhysical, Business Model and Mapping, and Presentation layer using Oracle BI Administration Tool in both OBIEE 11g, 10g Environments.
• Experience in building Reports, Prompts and Dashboards using Answers with different Analytics Views (Drill - Down/ Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle BI Presentation Services in both OBIEE 11g, 10g Environments.
• Strong experience as BI Developer in developing/modifying repositories and reports using OBIEE.
• Good understanding of functional specs and converting them into technical specs in accordance with SDLC guidelines.
• Good Knowledge in translating high-level business requirements into logical business dimensional model.
• Practical understanding of the Data modeling (Dimension & Relational) concepts like Star Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series.
• Experience in building, configuring and managing repository, creating and managing OBIA Dashboards, OBIA Answers, Delivers and iBots.
• Experienced in configuring OBIEE/OBIA Reports & Dashboards, OBIEE Delivers, advance Reports.
• Experience in setting up Object level and data level security. Configured OBIEE Variables and security Users and Groups.
• Experience in building Reports, Prompts and Dashboards using Answers.
• Experienced in development & customization of BI publisher (XML publisher) reports
• Expert in usingOBIEE Answersto create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
• Experience in performance improvement using SQL tuning.
• Experience in Migration of RPD and Web Catalogue across Instances.
• Analytics security at the data and object levels.
• Extensive experience in writing Technical specifications, Scenarios, Business processes, Workflows, Process flows, Unit Test cases.
• Experience of working with technical architects and application designers in defining and maintaining metadata of the enterprise.
• Provide technical support to User Acceptance and Integration testing environments by researching suspected anomalies and periodically refreshing the environments.
• Experienced in troubleshooting production issues and production support for projects
• On the other hand, Expert in using MS-Excel which makes data validation very easy.
• Quick learner with an ability to rapidly assimilate job requirements, come up with and employ new ideas, methods and technologies.
• Energetic and self-motivated team player with good problem solving skills and interpersonal skills.

TECHNICAL SKILLS:

Reporting Tools: OBIEE 10G/11G

Operating Systems: Windows, UNIX, LINUX

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

ETL Tools: Informatica Power Center 8.1.1, ODI 11.1.1.6

Database Tools: TOAD, SQL*plus, ODBC, SQL*Loader, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidentia, Englewood, CO

Sr. OBIEE Admin

Environment: OBIEE 11.1.1.7.1, ODI 11.1.1.6, Oracle 11g/10g, Toad, UNIX.

Responsibilities:

• Created Functional and technical design documents for all the requirements gathered.
• Implemented, installed and configured OBIEE 11g.
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance.
• Customized Physical, Business and Presentation layers in Oracle Business Intelligence Administration Tool.
• Created logical tables and assigned levels and custom aggregation rules.
• Designed and implemented Physical and Logical Star Schemas/Diagrams using Fact, Dimension, Alias and Extension tables as well as Foreign and Complex Joins.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Performance tuning of database objects.
• Involved in creating the Star Schema, Logical and Physical Modeling.
• Created Time series functions like To-Date (YTD, MTD and QTD), period rolling and AGO functions for comparison of data.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Customized/Created Presentation Layer Catalog folders to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Implemented Dimensional Hierarchies, Aggregate navigation, Fragmentation content, and other various features to meet the business requirements.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Parent child hierarchies based on the Requirements.
• Used the best practices of business intelligence to administer the analytical solutions.
• Created Repository, system and non-system session variables and initialization blocks for various repository needs.
• Authenticate users and maintained Object and Data level security.
• Created role based dashboards, pages, reports with various views i.e. table, pivot, charts, narrator, column selector etc. and various report prompts.
• Implemented MUD environment for multiple developers to modify a repository simultaneously.
• Designed and developed complex interactive OBIEE reports, including prompts, filters, different views (charts, views, filters, tables and bins), drill-down capabilities, and navigation links; detailed designing and developing of custom dashboards, including customized appearance.
• Developed report level and dashboard level prompts.
• Implemented cache management and enhancing query performance.
• Involved in Testing the reports and writing Test cases for Reports developed.
• Tested reports and dashboards for data integrity.

Confidential, Detroit, MI

Sr. OBIEE Developer/Admin

Environment: OBIEE 11.1.1.6.5, Informatica Power Center 8.1.1, Oracle 10g, SQL Server 2000, SQL, TOAD, UNIX.

Responsibilities:

• Installed and configured OBIEE repository Server, OBIEE Presentation Sever, oc4j, JDK.
• Migrated and merged OBIEE Repository and Catalogs.
• Monitoring the overall usage and taking necessary steps to improve the performance if needed
• Server Space management as per the need.
• Did the Necessary RPD and Catalog upgrades and applied patches as part of admin team.
• Provided extended production support based on the demand and complexity of the issue.
• Implemented Over all security, OBIEE content and Data level security.
• Create/Manage Repository/Web Users and Groups and assigning permissions using Enterprise Manager and Console.
• Configured Bi Scheduler and created iBots to schedule and deliver Analytics content to multiple delivery destinations and also a Cache Seeding mechanism.
• Implemented the Caching Strategy according to the client's data load frequency.
• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Analyzing and understanding sources of SQL Server and target with Oracle.
• Extensively used mapping parameters, mapping variables and parameter files.
• Involved in migration of folders from development to Integration and then to QA.
• Configured analytics repository with logical dimensional modeling using star schema.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers to create the reports as per the client requirements.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents (iBots) and interactive dashboards to alert the agents.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Design various reports, i.e. Drill down, Pivot, Narrative Reports in Siebel Answers.
• Implemented Prompts to provide dynamic filter condition to End users.
• Providing object level security for different web groups based on responsibilities.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.
• Performed Unit and Integration testing.

Confidential, Minnetonka, MN

OBIEE Developer/Admin

Environment: OBIEE 11.1.1.5, Oracle11g/10g, Toad, UNIX.

Responsibilities:

• Involved in translating high-level business requirements into logical business dimensional models.
• Worked on developing OBIEE repository at three layers- Physical Layer, Business Model and Mapping Layer and Presentation Layer.
• Developed Business Facts and Dimensions and defined logical relationship between them at the Business Model and Mapping Layer.
• Created Web groups for security purpose with access privileges and also assigned data Level and object Level security to users.
• Created Reports and Dashboards by using Views like Pivot tables, charts, column selector and view selector.
• Configured Metadata Repository (.rpd) using OBIEE Administration Tool.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Experience in configuring complex reports and dashboards from multiple subject areas.
• Created Dimension Hierarchies, Aggregates and Keys in the Business Model and Mapping Layer.
• Created Repository and Session Variables to achieve desired functionality.
• Worked with Global Prompts, Column Selectors, Automatic Drill-Down and navigation.
• Worked on customizing Reports’ look and feel using Column Formatting and Conditional Formatting.
• Regularly interacted with Admin team for migrating RPD and Web catalog to higher environments.
• Performed Cache management.

Confidential, Atlanta, GA

OBIEE Developer

Environment: OBIEE 10.1.3.4.1, Oracle10g, UNIX.

Responsibilities:

• Interacted with Case Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Designed and developed the OBIEE Metadata Repository (.rpd) using Oracle Business Intelligence Admin tool by importing the required objects (Dimensions, Facts & Aggregates) with integrity constraints into Physical Layer using connection pool, developing Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Implemented security by creating roles & web groups, External tables and LDAP.
• Created Dashboard prompts global filters and combined similar requests in Answers.
• Created Service Request reports based on call and email resolution.
• Configured Briefing Books and used Excel Office Plug in to download and refresh reports.
• Involved in troubleshooting and debugging of report errors and metadata inconsistencies.
• 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.,
• Performed Unit, Integration, and Regression testing of various Dashboards / Reports and Repository.

Confidential

Oracle SQL Developer

Environment: SQL Developer, SQL plus, Oracle 8i.

Responsibilities:

• Written PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Used SQL*Loader to load data from Excel file into temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Developed numerous programs using PL/SQL and many packages to do the validations as per requirements.
• Used Dynamic SQL (DBMS SQL, DBMS DDL) in function and procedure.
• Generate SQL Scripts and create views for reports.
• Used Toad to Extract and test the data in the database.
• Developed Database Triggers to enforce security.