SUMMARY:

• 9+ years of experience of IT experience which includes Analysis, design, development, Testing and Implementation of complete Software development life cycle and all aspects of gathering Business Requirements.
• Over 7 years of experience of design and development of Oracle Business Intelligence (OBIEE and OBIA)
• Experience in Complete life cycle of Business Intelligence with Star and Snow flake Schema Methodologies.
• Around 6 years of expertise on technical areas of Metadata Design (RPD) and Dashboard Development.
• Had experience with Crystal reports. Converted the Crystal reports to the Bi Reports.
• Have experience with Microsoft SSRS reporting.
• Expertise in OLTP/OLAP System Study, Analysis and developing Database Schemas like Star schema and Snowflake schema.
• 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).
• Expertise in debugging and optimizing the OBIEE/Siebel Analytics Dashboards / Reports.
• Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, Physical & Logical Data Modeling.
• Proficient in defining key metrics, dimensions, hierarchies, attributes and building Star and Snow flake schema.
• Experience in developing OBIEE Repository at three layers (Physical, Business model and Presentation Layers), Interactive Dashboards and drill down capabilities using global and Filters and Security Setups.
• Migrated Analytics RPD and Web Cat from OBIEE 10g to OBIEE11g by using Oracle Fusion Middleware upgrade assistant.
• Experience working on Hyperion DRM, Imported and Exported the hierarches to different formats.
• Expertise in BI Publisher, Developing and designing the template in rich text format (RTF) and portable document text format (PDF).
• Proficient with BI Publisher reports and using various templates to publish the report as per user requirements.
• Strong Knowledge on Oracle EBS Financial Modules such as Assets, General Ledger(GL), Payables, Receivables, Cash Management, Tabs
• Administration of OBIEE and the OBIEE Web Catalog.
• Aggressively involved in OBIEE 12c, Smoke test and regression testing.
• Involved in designing and developing new reports in OBIEE 12c.
• Experience in integrating BI Publisher with OBIEE.
• Expertise working with dimensions and fact tables in the BI Apps and experience with understanding universal adaptors in order to load into BI.
• Strong knowledge of ELT/ETL concepts, design and coding.
• Development, validation, and support of the ELT packages with ODI.
• Implementation of data integration and data loading tasks.
• Monitor and troubleshoot production data loads.
• Experienced in Installation, Configuration, Upgrade, Migration and Administration of OBIEE, Oracle BI Apps, Informatica Power Center/ODI.
• Very strong analytical and presentation skills, problem-solving techniques, proven leadership qualities with emphasis on individual and team effort backed by excellentCommunication skills.

TECHNICAL SKILLS:

BI TOOLS/OLAP: OBIEE 10.1.3.X, 11.1.1.X, Hyperion DRM

Oracle Applications: OBIA 7.9.6.4, Oracle Financials E-Business suite R12/11i, Siebel Analytics,ETL TOOLS: Informatica Power Center 6.x/7.x, ODI 11g.

Tools: Toad, SQL Server 2005

DATABASES: Oracle, MS SQL Server 05/00, MS Access

OPERATING SYSTEMS: Windows,Unix,Linux.

WEB TECHNOLOGIES: HTML, DHTML, XML

APPLICATIONS: MS Word, MS Excel, Outlook, FrontPage, PowerPoint, Flash Languages: SQL, C, C++.

WORK EXPERIENCE:

Confidential, Greenvillie,Sc

OBIEE developer

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Analysis on the requirements Gathering to provide the best possible solution on reports/dashboards.
• Analyzed the specifications provided by the client, understanding the business.
• Design and develop the OBIEE Repository (.rpd) by importing the required database objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE 11g suite.
• Experienced in working with OBI Answers, OBI Dashboards, BI Publisher and OBI Delivers.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Experienced in creating Oracle BI Publisher Report Templates using BI Publisher Desktop Edition.
• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.
• Expertise in designing and developing interfaces, packages, procedures, variables and scenarios.
• Involved in developing scenarios and scheduled them for loading the data using the $ universe scheduler.
• Involved in configuration of topologies.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Debugged & modified some of the existing reports and dashboards, and fixed some of the issues related to performance, data quality etc., during production support.

Environment: OBIEE 12.2.1.2.0, OBIEE 11.1.1.9.0, Orcacle BI Appps 11.1.1, BI Publisher, SQLDeveloper.

Confidential, Sunnyvale,CA

OBIA/OBIEE/INFORMATICA CONSULTANT

Responsibilities:

• Worked with Business Groups to identify, analyze, and document Business Requirements.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Involved in customizing Out of the Box mappings and reports to support the business requirements.
• Siebel as the Source system, Customized the Sales data according to the users requirement.
• Worked on Oracle Financial analytics which helps us the better vision of the company and did spend, Procurement analytics too.
• Migrated Test Code from Development to QA and QA to Production of Repository, Dashboard Reports, Informatica mappings and workflows and DAC entities.
• Validated the data/Reports each and every time a migration occurs from Dev to QA and QA to Production environment.
• Configured new tasks, parameter files and Execution Plan in DAC for incremental and full load.
• Streamlined the Execution Plans with their respective tasks in DAC.
• Monitored the Incremental & Full load through DAC.
• Maintained the Full and Incremental loads through DAC on different environments like Development, QA and Production environment.
• Performed Unit and Regression testing during development of reports and dashboard.
• Developed, Configured and implemented Mapplets and Repeated functionalities.
• Worked on some informatica ETL mappings on SCD type 1 and SCD type 2.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks .
• Developed Mappings and Workflows using various transformations (Update Strategy, Router, Expression, and Aggregator) for extracting the billings data from Oracle Applications.
• Having a good knowledge on Change Data Capture for Siebel Analytics.
• Responsible for updating/ tracking and documenting the development changes at both ETL level and rpd level.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.
• Created new logical measures required as per the business requirements.
• Created catalog folder in the presentation layer and setup visibility of the presentation catalog to users with respect to their responsibilities.
• Added data level security at the repository level. The data was restricted with respect to the group user belongs too.
• Worked using Catalog Manager to migrate Web Catalog from one environment to another.
• Involved in Query Tuning to maximize the performance of reports and Dashboards.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.

Environment: Siebel Sales Analytics, Oracle BI Apps 7.9.6.3, Informatica Power Center 9.1.0, Oracle 11g, DAC 11g .

Confidential, Seattle, WA

OBIEE/ Informatica Developer

Responsibilities:

• Analysis on the requirements Gathering to provide the best possible solution on reports/dashboards.
• Analyzed the specifications provided by the client, understanding the business.
• Install, configure, and administer the OBIEE platform.
• Involved in developing the Incremental ETL process i.e., updated incremental code in Sessions / Tasks.
• Developed the Soft Delete Code changes to the Out of the Box mapping in the ETL tool for marking out the deleted records from the Database.
• Developed Mappings and Workflows using various Transformations (Update Strategy, Router, Expression, and Aggregator).
• Scheduled the jobs for loading the Data from Database to Data warehouse using DAC tool.
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mappinglayer.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed many Dimensions and Time Series Objects with Security settings for analyzing.
• Created Session & Repository Variables to achieve desired functionality.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE 11g suite.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Involved in migrating the reports from Dev environment to UAT and from UAT to Prod.
• Used SQL * Loader for Data Conversions and to load the data from flat files into Oracle tables.

Environment: OBIEE 11.1.1.6.7, Siebel Analytics, BI Apps 7.9.6.4, Oracle 11g, SQL, Informatica 9.1.0, DAC 11g.

Confidential, Boston, MA

Sr. OBIEE/INFORMATICA Developer

Responsibilities:

• Analysis on the requirements Gathering to provide the best possible solution on reports/dashboards.
• Interacting with the users on the collecting the requirements.
• Configure various server configuration files from Enterprise Manager to meet the requirements.
• Develop Oracle BI consisting of three layers (Physical Layer, Business Model & Presentation Layer).
• Develop Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), business rules with user identity and roles within the OBIEE 11g suite.
• Design and develop the OBIEE Repository (.rpd) by importing the required database objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• BI Applications with expertise in Sales Analytics.
• Customized the look and feel (Skins & Styles) for OBIEE products (Answers Login Page, Banners, CSS files, etc.) as per company specific standards.
• Design the hierarchies using Hyperion Data Relationship Management tool.
• Imported the Flat files which was pulled from Essbase and Maintained in the DRM as Hierarchies.
• Exported the hierarchies in a different formats ( Generation format, Level format, Parent child Relationship Format, etc)
• Ran the Action scripts to add the nodes to the existing hierarchies, deleting the nodes from existing hierarchies and Adding description to the existing nodes.
• Created the OBIEE environment for migration between DEV box, QAT box and Prod box over Linux and Windows.
• Maintained and monitored the services, debugged what the problem is and restarted the services on Linux box.
• 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 OBIEE repository.
• Debugged & modified some of the existing reports and dashboards, and fixed some of the issues related to performance, data quality etc., during production support.

Environment: OBIEE 11.1.1.6.0, Informatica,9.1.0, BI Apps Sales Analytics, Hyperion DRM, Sql Developer.

Confidential, Temple Terrace, FL

Sr. OBIEE/ODI Develope r

Responsibilities:

• Developed and tested RPD (Physical, BMM and Presentation Layer), configured metadata objects and web catalog objects as per the client and reporting requirements using OBIEE Admin Tool and Web tool.
• Created hierarchies, variables, and event poll strategies in the repository.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within the OBIEE 11g suite.
• Used repository variables to dynamically modify conversion values for logical column formulas.
• Implemented data level security depending on roles.
• Setup the visibility of dashboards to employees with respect to their responsibilities. Administered permissions and privileges for dashboard visibility and modifications to users based on their groups or responsibilities.
• Developed new dashboards on the business needs, implemented dynamic column naming and dynamic logo which is driven through DB tables. Displaying logo depends on user credentials.
• Participated in installation of OBIEE 11g on LINUX Redhat 5 and worked closely in resolving the issues with installation.
• Managed to do crystal reporting
• Upgraded OBIEE 10g repository and catalog using OBIEE 11g upgrade assistant tool and customized OBIEE 11g repository.
• Worked as an Administrator in Weblogic EM and monitored various applications and services.
• Prepared Migration document for all the environments and did production support.
• Created Analysis, Dashboards and Agents in OBIEE 11G Version 11.1.1.5.0.
• Configured various server configuration files from Enterprise Manager to meet the requirements.
• Implemented Row level security in repository using filters and object level security and assigned privileges according to the AD groups.
• Implemented Dynamic column formula according to the dashboard prompt.
• Monitor logs by setting log level and debugged reports issues by understanding the SQL queries behind them (used TOAD to run these SQL queries)
• Performed unit, integration, and regression testing to validate report and mapping functionality. Environment: OBIEE 11.1.1.5.0 (Analysis /Dashboards /Agents), Oracle 10gR3/11g, SQL*Plus, TOAD, ODI 11g, Putty.

Confidential, Sacramento, CA

OBIEE/ODI DEVELOPER

Responsibilities:

• Through understanding of Business requirement document and convert into functional specs.
• Extensively worked on developing repository for Client statements in all the three layers.
• Built schema in Business model and mapping layer by using complex joins, created logical tables and columns, also created hierarchy levels for drill down capability.
• Used Time series functions for calculating year ago and month ago assets.
• Scheduled iBots to generate the report on daily, weekly and monthly basis.
• Extensively used guided navigation capability, drilldowns in reports and created dashboards.
• Setup the visibility of dashboards to employees depending on their roles and responsibilities.
• Integrated Oracle BI reports with the front end interface of web logic server.
• Used Repository and Session variables for storing dynamic values.
• Designed and developed the OBIEE Repository (.rpd) by importing the required data base objects both Facts and Dimensions with integrity constraints into physical layer using connection pool.
• Imported Physical tables from Oracle database and defined relations between Physical tables at the Physical Layer.
• Created logical column aggregations with complex calculations using the inbuilt functions and expressions.
• Created dimension hierarchies and level based measures to support drill down feature.
• Experience in upgrade/migration process to 11g.
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Created reports in Oracle BI answers from existing reports in oracle Discoverer Integrating Oracle BI publisher reports in Interactive Dashboards.
• Involved in Migrating the ETL from OWB to ODI.
• Understood the Complex Mapping of OWB and converted them to ODI Interfaces.
• Developing of complex interfaces and packages using ODI tool.
• Scheduled batch jobs using ODI scheduler.
• Developing and designing the template in BI Publisher using rich text format (RTF) and portable document text format (PDF).
• Developed On-request Reports Using BI Publisher.
• Involved in Migrating the Reports Builder Reports to the BI Reports.
• Involved in unit testing and tested the data in the database with that of the reports.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector, View Selector), Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters.

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle 10g/11g, OWB, ODI 11g, Toad.

Confidential

OBIEE DEVELOPER

Responsibilities:

• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Analyzed the specifications provided by the client, understanding the business.
• Install, configure, and administer the OBIEE platform.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher.
• Designed Star schema for fact & dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Developed Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Administration Tool.
• Created Session & Repository Variables to achieve desired functionality.
• Extracted the pre-built BI solutions of tables by using Oracle BI Apps to configure and created repository (.rpd) and prepared a detail design document
• Used SQLServer2000 to access the database and Optimization of DATA TABLES.
• Used SQL * Loader for Data Conversions and to load the data from flat files into Oracle tables.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.

Environment: OBIEE, SQL Developer, Oracle 10g, Linux.