SUMMARY

• IT professional with about 7 Years of experience in analyzing the Business Users Requirements, Application Design Modeling, Development and Implementation of Business Intelligence using Oracle Business Intelligence OBIEE . Experience in Data Warehouse with good understanding of the architecture.
• Strong knowledge of RDBMS Databases like Oracle 10g/11g, MS SQL Server.
• Ability to interact effectively with clients, understanding their requirements and providing optimum solution and production support.
• Proficient in building three layers Physical Layer, Business Model Mapping Layer and Presentation Layer of OBIEE Repository.
• Expertise in translating high-level business requirements into logical business dimensional model.
• Expertise in handling all phases of Quality Assurance Life Cycle and Software Development Life Cycle SDLC of the BI Projects.
• Hands on experience in defining Key Metrics, Dimensions, Hierarchies and Attributes, Aggregate Navigation, Aggregates based on dimension, Level Based Measures, Variables, Initialization Blocks, and Cache Management.
• Expertise in complete life cycle of Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses including Testing and Code Migration.
• Experienced in Configuring and Publishing the iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily weekly transactions to all the departments in the organization by emails.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports.
• Good knowledge in ETL Transformations such as Router, Filter, Expression Builder, Sequencer, Sort.

TECHNICAL SKILLS

• BI Tools : OBIEE 11g/10g
• Databases : Oracle 11g/10g / 9i, MS SQL Server 2008 / 2005.
• Languages : SQL, SQL Plus, PL/SQL.
• Operating Systems : Windows XP, Windows 7, Linux Red Hat.
• Applications : MS Word, MS Excel, Outlook, Data Modeling, PowerPoint, Microsoft Visio.
• GUI : OBIEE, Business Objects, Oracle Reports.

EXPERIENCE

Confidential

OBIEE DMR, OBIEE Developer

This project is on OBIEE Upgrade 10g to 11g and Data Model Redesign of existing Subject Areas in 10g into new simplified Subject Areas in 11g- VTI Services, VTI Sales, VTI Marketing, and VTI Operations.

Responsibilities:

• Analyzed the existing system and designed a new Data Model to accommodate all the business requirements.
• Involved in client meetings to understand the Business need behind the SQL queries.
• Development of PLSQL code.
• Participated in design discussions to make the decisions to drive the project in the environment that is always changing.
• Involved in analyzing long running SQL queries to improve the performance.
• Created and Presented Client on new Dimensional Modeling and actively helped Data Team to resolve data level issues.
• Development of OBIEE Repository Physical, Business and Presentation layer and added extension columns in fact and dimension tables.
• Developed many Reports in Oracle BI Answers and created interactive Dashboards using features like Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with Global and local Filters.
• Worked on Security settings in Administration Tool to set up users, groups, access privileges and query privileges and also managed security for groups in Answers.
• Worked on Multi User Development Environment to develop RPD.
• Implemented both object level and row level security based on roles and responsibilities of end user.
• Dynamically used Filters and provided customized prompts appropriately to avoid excessive data showing up reports using variables.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked on the Time Series function and implemented time comparison using To Date, Period Rolling and Ago functions.
• Responsible for installing/configuring OBIEE 11.1.1.7.141014 in the Linux and presented client for the POC.
• Responsible for implementing Usage Tracking, Security using external tables for authorizing the users in OBIEE 11g.
• Responsible for deploying the RPD and restarting all the services through Enterprise Manager.
• Responsible for maintaining all the OBIEE Windows client environments of Verizon.
• Responsible for Coordinating offshore team and report to client on the development progress.
• Did extensive validation of the data in the reports through Unit Testing, Performance Testing, System Integration Testing, and Incremental Load Testing.
• Designed test cases for the validating the data in the Dashboards.
• Expert in database testing in Oracle environment including designing and manipulating test data, validating stored procedures, jobs and triggers.
• Helped ETL in building the mappings and workflows by applying certain transformations of Router, Filter and Lookups.

Environment:OBIEE 10g 10.1.3.4 , OBIEE 11g 11.1.1.7 , Oracle SQL Developer, Visio, Putty, WinSCP.

Confidential

Recast Reverse Engineering, OBIEE Developer

Responsibilities:

• Created metadata repository RPD as per business requirements at three layers in Oracle BI Administration Tool.
• Defined Physical Diagram by defining foreign key Joins and developed Business Diagram in BMM layer to define Business Model and requirements.
• Defined multiple Dimensions Drill-Down Hierarchies Logical Facts /Measures objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies in BMM layer.
• Developed Reports in OBIEE Analytics and created interactive Dashboards using features like Drill-Down, Cascading Style Sheets, Pivot Table, Chart, and Column Selector.
• Implemented Security in Administration Tool to set up users, groups, access privileges and also managed security for groups in Answers.
• Based on roles and responsibilities of end user, implemented both object level and row level security.
• Applied Filters and provided customized prompts appropriately to avoid excessive data showing up reports using variables.
• Implemented Time Series functionsof To Date, Period Rolling and Ago functions.
• Involved in design discussions to drive the project in the environment that is always changing.
• Prepared the technical design document.
• Integration testing the code.

Environment: Oracle 10g/11g, Performance Tuning, Oracle 11g SQL, PL/SQL , SQL Server 2008, Visio, Windows 7.

Confidential

OBIEE Developer

Responsibilities:

• Implemented Data Level Security in OBIEE depending on the user level access by integrating with EBS.
• Performed the Setting-up, Installation and Configuration of the complete Analytics platform environment and the required connectivity for seamless integration with the Data Warehouse.
• Developed many Reports/Dashboards with different Analytics Views Drill-Down/ Dynamic, Pivot Table, Chart, Column Selector with Global and Local Filters using Oracle BI Presentation Services.
• Was involved in the installing and configuring of Financial Analytics.
• Designed and Developed General Ledger, Payables, Receivables and Profitability Dashboards in OBIEE.
• Setup Multi User Development Environment MUDE in OBIEE.
• Created Presentation Catalogs, and Folders in Presentation Layer, and performed Global Consistency Check in Oracle BI Administration Tool.
• Exclusively involved in Unit Testing and Regression Testing.
• Worked on multiple folders at time to meet the dead lines of the tasks.
• Designed and Developed logical model in BMM in Repository.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Created custom reports in Payables in OBIEE according to user requirement.
• Worked on Microsoft Visual Studio for development.

Environment: Oracle Business Intelligence Suite OBIEE 11.1.6/11.1.5, Oracle 10g/11g, BI Publisher, Informatica 8.6, Erwin 4.3, Star Schema Design, SQL Plus, Performance Tuning, SQL, SQL Server 2000/2005, Microsoft Visual Studio 2010, Windows 7.

Confidential

OBIEE Consultant

Responsibilities:

• Worked closely with the business users and developers to make sure that business requirements are correctly translated into database schemas and ultimately into the application. Interacted with end users and developers to validate the data model, reports.
• Analysis of existing OLTP system and Identification of required dimensions and facts from the Database.
• Creation and Customization of the OBIEE Repository Physical, Business and Presentation layer and added extension columns in fact and dimension tables.
• Monitoring of the loads run on ETL and verification of the code.
• Worked on Oracle BI Answers to build Interactive Dashboards with Drill-Down capabilities.
• Time Series Objects, Interactive Dashboards with drill-down capabilities using page and dashboard prompts, OBIEE Security Setup groups, object and data level ,configured Analytics Metadata objects Subject Area, Table, Column , Web Catalog Objects Dashboard, Pages, Folders, Reports .
• Expert in Cache Management, Repository Migration, Data level and Object level security in OBIEE Analytics.
• Worked on MUDE.
• Built test cases and tested the Reports / Dashboards by comparing the SQL Output on the Data Warehouse to the values in the Reports/Dashboards, documented the test results.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created pivot table along with different kinds like charts, tabular allowing manager to analyze the business from different perspectives, and provided optimized Analytics requests using column selector and using global and local filters.
• Responsible for overall Business models and Reporting needs.
• Build all user and group level securities including data level.
• Created UAT User Acceptance Test cases.
• Worked on Microsoft Visual Studio for development and debugging.
• Assisted in production support. Specified the aggregate levels for each source and created dimension sources for each level of aggregated fact data in the BMM layer.
• Assisted in creating a Dashboard user guide for new users.

Environment: OBIEE 11g, SQL Plus, Performance Tuning, Oracle 11g SQL, PL/SQL , HTML, Microsoft Visual Studio 2010, Windows 2003 Linux Servers, Putty.

Confidential

Siebel Analytics Developer

Responsibilities:

• Created customer hierarchy dimension tables and Analytics metadata for drill down functionality for dashboards.
• Created front end reports, Intelligence dashboards by using Siebel Analytics Reporting tool and also worked on few RPD components to meet the business requirements.
• Debugged and tuned final released production dashboards.
• Meeting with business and technical users to understand their data warehousing data needs on a regular basis.
• Performed detailed source data analysis to determine grain and data quality characteristics.
• Associated with interfacing teams from Siebel perspective to provide information on Data Mapping relating to Siebel.
• Created the new analytics reports and modified the already existing ones.
• Used conditional formatting in the reports.
• Created reports with table, pivot, ticker, filter, and chart and narrative views with filters, prompts and also dashboard prompts.
• Created intelligence dashboards and mapped the Reports.
• Worked on metadata repository RPD enhancements.
• Performed project and application level data migration and delivery that support business information requirements ensuring effective data organization and maximizing re-usability of data.
• Provided end user support by addressing their issues.

Environment: Siebel Analytics 7.5 7.7, Siebel Answers, Siebel Dashboard, Oracle 9.2.05.