SUMMARY

• Over 9 years of total IT experience in Data warehousing implementation, experience in Business Intelligence using Oracle Business Intelligence(OBIEE) 10g and 11g, and Siebel Analytics. Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Infrastructure setup, Data Modelling, Development, Testing and documentation
• Over 7 years of strong experience in OBIEE 10.1.3.x, 11g, Siebel Analytics 7.x modelling, Installations, developing Metadata (RPD), Dashboards and, Reports. Scheduling and Monitoring ETL routines through DAC on different environments like Development and Test environment
• Worked on implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Snowflake Schema, Fact & Dimensions tables, Physical & Logical Data Modelling.
• Responsibilities included installation of Oracle BI in a single and also in a distributed environment. Building of RPD application design for Physical, Logical (BMM), and Presentation layers, configuration of those layers, development of Reports, Dashboards, Publisher, and integration to Microsoft suite of tools, testing, and deployment.
• Configuring Multi User Development Environment, OBIEE scheduler, Usage Tracking, Security integration between rpd and BI Publisher, Repository Sever and Presentation Server configuration changes, Cache etc.
• Experience 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).
• OBIEE- SECURITY- SSO- LDAP-- OID, External Table, OBJECT level Security, ROW level Security using INIT Blocks. Experience with Federated Query tuning strategies.
• Detail understanding of OLTP and OLAP Data models to create and manage the repository with the available metadata using Siebel Analytics/OBIEE.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.

TECHNICAL SKILLS

• Oracle Business Intelligence (OBI) EE 11.1.1x and 10.1.3.x (Admin
• Presentation Services
• Publisher).
• Siebel Analytics 7.x (Admin
• Web
• Answers
• Dashboards) iBots
• Scheduler
• BI Publisher.
• Informatica 6.x/7.x/8.x (Power Center / PowerMart).
• Oracle 8i/9i/10g/11g
• MySQL
• Microsoft SQL Server2000.
• Toad
• Putty
• SQL Plus 10.x/9.x/8.x
• ODBC.
• SQL
• PL/SQL UNIX shell script.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

OBIEE Lead

Responsibilities:

• Requirement analysis gathering, analyzing the functional and technical specifications.
• Working closely with business users to ensure completeness of requirements.
• Setup OBIEE on Linux environment. Installed single node in development Instance and cluster in QA.
• Worked extensively on BMM (Business Model and Mapping) layer to develop business models like Corporate Expense and Inventory Build
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation

Confidential

Technical Lead

Responsibilities:

• Worked closely with business users to ensure completeness of requirements.
• Worked extensively on BMM (Business Model and Mapping) layer to develop various business models like benefits and revenue using Star Schema and Snowflake Schema.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down and Aggregation navigation.
• Created dimensions, dimension hierarchies, level based measures and defined level, attributes level keys.
• Enforced Criteria based navigation to achieve better SLA on adhoc queries based on products, customer origination, and industries.
• Created Level Based Measures, new logical columns and enforced conditions on the columns in the logical layer for query optimization.
• Implemented Time Comparison and Calculation measures in the business model using Time series Wizard.
• Performed Repository Testing and Validation before exposing Business Models in the Presentation Layer.
• 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.
• Configured iBots to alert the management and sales teams as per their requirements.
• Slice and Dice data using filters and used pivot tables and charts for better presentation.
• Worked on OBIEE Administration Tool for customizing and modifying the Physical layer, BMM and Presentation layers of the repository (.rpd).
• Worked extensively on OBIEE Answers to create the reports as per the business requirements.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Pie/Bar Chart, and View/Column Selector, Narrative View), Dynamic / Interactive Dashboards with drill-down capabilities using global and local Filters. Extensively used OBIEE Delivers and iBots. Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.

Confidential, Atlanta, GA

Technical Lead

Responsibilities:

• Given support on multiple OBIEE modules like Finance, Project and HR Analytics.
• Coordinated with oracle Cloud Team to set up SSO and LDAP Configurations,
• Setup real time views to create real time reports.
• Application Failure troubleshooting.
• Data Analysis
• Customized Solutions.
• Status meeting and status reporting with customer.
• Regular interaction with Business teams.

Confidential, Louisville, KY

Project Lead

Responsibilities:

• Worked closely with business users to ensure completeness of requirements
• Worked as onsite-offshore coordinator and implemented OBIEE end to end set up.
• Implemented Security by creating roles & web groups using LDAP Authentication.
• Extensively worked on admin tool, Answers, Dashboards, BI publisher and Security for users. Worked on creating complex reports, and cutomized widgets.
• Designed various OBIEE data models and managed different levels of security for different subject areas.
• Successfully designed and implemented cluster servers on production environment.
• Configure and develop the OBIEE Repository (.rpd), which involves Schema Import, Implementing the Business Logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, Cache Management, Utilities, Subject Areas etc.
• Configure the single sign-on (SSO) Authentication.
• Configuring Object level and Data level security based on the login credentials of the users using session variables.
• Training Business users and power users on how to use the new OBIEE tool and explaining them their access privileges.
• Configuring and Scheduling IBots to deliver daily reports to the target business users.
• Managed cache in different environments.

Confidential, Boston, MA

OBIEE Senior Associate

Responsibilities:

• Worked as onsite coordinator and handled offshore team.
• Configured OBIEE with Hyperion essbase cubes.
• Worked on High Level Design document and Detail Design Documents.
• Generated and plan executive level dashboards, complex reporting, and metadata modelling.
• Display a thorough understanding of complex information systems and apply it to the situation of client.
• Designed and configured different users and groups in OBIEE
• Migrating code between different instances.
• Extensively worked on RPD, Webcatlog and Dashboards
• Designed, Developed and Tested Data security and Dashboard security in OBIEE
• Worked as a lead in the design and development of dashboards and reports.
• Involved in cache management.
• Managed Security privileges for each Subject area and Dashboards according to user requirements
• Worked with the business partners to understand the business process and modifying the OTB Dashboards in the areas Procurement and Spend Analytics.
• Created documentation for the existing OTB Dashboards and explained the functionality in recurring Demo meetings.
• Worked on creating Custom Dashboards for external Spend Team to provide insight into their current and history Sales by Customers, Territories and Products.
• Customized the RPD to import new Data elements and create Time series measures and Hierarchies.
• Focused on Usability, User Friendly Interface and consistent intuitive Dashboards and suggested different layout approaches to the Business keeping standard best practices in retrospect.

Confidential

Senior Developer

Responsibilities:

• Used the Siebel Analytics Admin Tool to develop the 3 layers in the Repository.
• Built prototype reports from excel spread sheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• 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.
• Worked extensively on Siebel Answers to create the reports as per the client requirements.
• Defined additional views (compound, table, chart views) of the data returned by the request to visualize data in many different ways.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Created Proactive agents (iBots) and configured Interactive dashboards to alert the employees as per the requirements.
• Formatted columns used in generating the requests and used various filtering options as and when needed.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers and Delivers.
• Worked on improving the dashboard performance, readability, and security.

Confidential

Siebel Analytics Developer

Responsibilities:

• Involved in Full project life cycle implementation for PPCE Data Warehouse.
• Identified the granularity level of the data required to be available for analysis.
• Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the data requirements using Siebel Analytics Server Admin and Web tool.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
• Mapped the configurations to accommodate for the territorial hierarchy that were accommodated via chart drilldowns.
• Assisted in creation of pivot table request allowing manager to analyse the business from different perspectives provided optimized Analytics request using column selector.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
• Administered security and created alerts.
• Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
• Used the Siebel Analytics Administration tool to develop and enhance meta-data.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Enhanced existing Business Models & created customized Dashboards for revenue ratio reports for North America and Asia Pacific regions.
• Developed custom reports using Seibel Answers and assigned them to application specific dashboards.

Confidential

Siebel Analytics Developer

Responsibilities:

• Used the Siebel Analytics Admin Tool to develop the 3 layers in the Repository.
• Created connection pools, physical tables and defined Primary key.
• Built prototype reports from excel spread sheets during the requirement-gathering phase to visualize the reports and clarify requirements.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimensions, dimension hierarchies, levels, level based measures and defined level, attributes level keys.