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 teh Data Warehousing teamed wif 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 wif 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 wif Federated Query tuning strategies.
• Detail understanding of OLTP and OLAP Data models to create and manage teh repository wif teh 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 teh functional and technical specifications.
• Working closely wif 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 wif 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 teh columns in teh logical layer for query optimization.
• Implemented Time Comparison and Calculation measures in teh business model using Time series Wizard.
• Performed Repository Testing and Validation before exposing Business Models in teh Presentation Layer.
• Setup teh visibility of Dashboards to employees wif 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 teh 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 teh Physical layer, BMM and Presentation layers of teh repository (.rpd).
• Worked extensively on OBIEE Answers to create teh reports as per teh 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 wif 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 teh 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 wif 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 wif customer.
• Regular interaction wif Business teams.

Confidential, Louisville, KY

Project Lead

Responsibilities:

• Worked closely wif 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 Autantication.
• 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 teh OBIEE Repository (.rpd), which involves Schema Import, Implementing teh 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 teh single sign-on (SSO) Autantication.
• Configuring Object level and Data level security based on teh login credentials of teh users using session variables.
• Training Business users and power users on how to use teh new OBIEE tool and explaining them their access privileges.
• Configuring and Scheduling IBots to deliver daily reports to teh 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 wif 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 teh 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 teh 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 wif teh business partners to understand teh business process and modifying teh OTB Dashboards in teh areas Procurement and Spend Analytics.
• Created documentation for teh existing OTB Dashboards and explained teh 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 teh 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 teh Business keeping standard best practices in retrospect.

Confidential

Senior Developer

Responsibilities:

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

Confidential

Siebel Analytics Developer

Responsibilities:

• Involved in Full project life cycle implementation for PPCE Data Warehouse.
• Identified teh granularity level of teh data required to be available for analysis.
• Developed Metadata repository (.rpd), configured metadata teh Business Model Layer & Physical Data Model and Web Catalog Objects as per teh data requirements using Siebel Analytics Server Admin and Web tool.
• Worked on Siebel Answers to build Interactive Dashboards wif drill-down capabilities.
• Mapped teh configurations to accommodate for teh territorial hierarchy dat were accommodated via chart drilldowns.
• Assisted in creation of pivot table request allowing manager to analyse teh business from different perspectives provided optimized Analytics request using column selector.
• Implemented dynamic dashboard prompts to zoom into particular segments of teh business in a performance-optimized manner.
• Administered security and created alerts.
• Created templates for presenting results and Analytics and modified teh Siebel Dashboard using cascading style sheets.
• Used teh Siebel Analytics Administration tool to develop and enhance meta-data.
• Created connection pools, physical tables, defined joins and implemented authorizations in teh physical layer of teh repository.
• Worked extensively wif 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 teh Siebel Analytics Admin Tool to develop teh 3 layers in teh Repository.
• Created connection pools, physical tables and defined Primary key.
• Built prototype reports from excel spread sheets during teh requirement-gathering phase to visualize teh 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.