SUMMARY

• Over 8+ years of experience in end to end Implementation using Standard Software Development Life Cycle Methodologies.
• Over 5 years of Extensive experience in Business Intelligence using Oracle Business Intelligence EE 11.x,10.x(OBIEE) and Siebel Analytics 7.x
• Expertise in configuring and developing the Siebel Analytics/OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Mapping & Presentation Layer), 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, Web Catalog Objects and scheduling iBots.
• Responsibility includes gathering Business requirements, Analysis, design, Data Modeling, development, Client Interaction, and Compiling Specifications from client, Modification, Testing and Support.
• Expertise in configuring BI Scheduler in OBIEE 11g.
• Extensive Hands on experience in Presentation Services, Answers, Delivers, Scheduling Reports to emails, Handheld devices using Agents/iBots, and Creating Dashboards.
• Experience in Security Setup at both Object and Data levels, which involved creation of Users/Groups, Access privileges, LDAP authentication setup, External table and configuration of Multiuser Development Environment.
• Expertise in managing Security Model introduced in OBIEE 11g, Implemented security using Weblogic Server Administration Console by creating and setting up users and groups and used Enterprise Manager Middleware control to create and setup Application Roles and Application Policies.
• Experience in performing OBIEE upgrades and applying released patches.
• Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
• Migrated Repository and Web Catalog from one environment to another environment.
• Expertise in Performance Tuning of OBIEE/Siebel Analytics by implementing Cache management, Dimensional Hierarchies and Aggregate Navigation techniques.
• Proficient in working with OLTP and OLAP database system.
• Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
• Extensive experience in customizing Metadata Repository (.rpd) and Web catalog of Vanilla / Out - of-the-box Implementation of various OBI Applications like Financial Analytics, HRMS, Siebel Sales and Services.
• Expertise in Configuring Map Viewer in OBIEE 11g and setting up Google Maps in Reports.
• Expertise in Troubleshooting and providing work around solutions to the business users for bugs in OBIEE 11g.
• Worked with various Transformation Components like Source Qualifier, Expression, Aggregator, Filter, Router, Sorter, Lookup, Joiner and Sequence Generator.
• Design of ETL methodology for supporting data transformations & processing in a corporate wide ETL Solution using Informatica Power Center 8.x/7.x/6.x.
• Involved in using Erwin Data Modeling tool to represent the star schema Data Marts.
• Extensive experience in Oracle 10g/9i/8i, SQL Server 2000, design and developing Stored Procedures, Cursors using SQL, PL/SQL.
• Multi-platform experience on UNIX and Windows Server family of products. Highly capable of learning new technologies and adapting to new environments.
• Excellent Team Management Skills with good business acumen, effective communicator with proficient Multi-tasking abilities, efficient and effective problem solver, experience in working with Business Users, Controllers, Directors, Senior Managers and Executives and Department Heads.

TECHNICAL SKILLS:

BI Tools: OBIEE 11.1.1.5,10.1.3.x, BI Publisher, Oracle BI Apps 7.9.5/7.9.4 , Siebel Analytics 7.x

Data Warehousing(ETL Tools): Oracle Data Integrator (ODI) 11g, Informatica Power Center 8.x/7.x/6.x

Programming languages: PL/SQL, SQL, C, C++, C#.Net,ASP.Net, VB.Net, HTML, XML

Databases: Oracle11g/10g/9.x/8.x/7.x,MS AccessSQL server 2005/2003/2000 , Progress 10.2B

Other Tools: DAC, SQL*Plus, MS Office, SQL Developer, Erwin, Toad, AQT (Advance Query Tool)

Operating Systems: UNIX, Windows 95/98/00/NT/XP/Vista/7

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Sr OBIEE Consultant/Administrator

Responsibilities:

• Participated in gathering and analyzing the Business Requirements form Subject Matter Experts (SMEs), Business Analysts and Users and created the business model for generating reports/ dashboards as per the requirements.
• Developed/tested/migrated the RPD and Web Catalog across all the Environments (Dev, QA, Preprod, and Production) based on Architects and business user requirements.
• Involved in the Installation of OBIEE 11g (BI Administration Tool, Oracle BI Enterprise Manager, and Oracle BI Administration Console) on Linux environment.
• Upgraded OBIEE Version, Rpd’s, Catalogs from OBIEE10g to OBIEE11g by performing Upgrade Assistant.
• Developed Proof of Concept reports/dashboards for review by business users and stabilized OBIEE application after upgrading to 11g by solving all the issues, errors in reports/dashboards and rpd. Provided support to business in using the latest enhancements/UI Changes in OBIEE11g.
• Managed new security model introduced in OBIEE 11g. Implemented security using Weblogic Server Administration Console by creating and setting up users and groups. Used Enterprise Manager Middleware control to create and setup Application Roles and Application Policies.
• Configuration of OBIEE Security parameters at Object level, Data level, Row level and setup Dashboard privileges based on their groups or responsibilities.
• Created Level Based/Dimensional, multiple hierarchies on single table (Time Dimension Fiscal/Calendar) and Parent-Child hierarchies, where Parent child hierarchy is introduced in OBIEE 11g.
• Configured new ODBC Connection on Linux environment for progress database (Source Database) in OBIEE 11g.
• Created a new JDBC Connection to connect to the source database (Progress Database) from BI Publisher and trained end users in creating Datasets and BI Publisher reports in different views.
• Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Maps Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.
• Implemented Usage Tracking to monitor user statistics and provided simple solutions for complex/long running quires.
• Created Briefing Books and scheduled Agents/IBots to run all Dashboards and send emails after the incremental run.
• Installed and configured Oracle BI Mobile App on iPad/iPhone for executives.
• Technically Supporting and Providing Solutions to Ongoing Production Issues Encountered by Business Users while developing Ad-hoc Reports, Dashboards and Agents (IBots).
• Ensuring the OBIEE Application in all Environments is Available to Users by monitoring from Enterprise Manager.
• Extensively used variables as per the business requirements.
• Made Configuration changes to configuration files and uploaded external documents as requested by business to meet their requirements.
• Customized User Interface according to the Client Standards by creating separate skins and styles in OBIEE.
• Created Data Warehouse Reconciliation Dashboard to monitor the incremental run which includes loading files and variances.
• Responsibilities include Supporting existing Metadata rpd for Multiple Projects (PBM (Pharmacy Benefit Manager), MCS (Managed Care System) and created new Business Models and separate Subject Areas by importing tables from data warehouse and created physical, logical joins, hierarchies and helping the business users for creating the reports for their processes.
• Followed Best Practices while implementing changes and enhancements to the OBIEE Application and in order to Improve Performance worked with Cache Manager and performed load testing to test.
• Created Documents to the End users to use Answers/Analysis, create analysis/dashboards and Agents.
• Worked on Full Life Cycle of OBIEE including Answers, Intelligence Dashboards and Supporting end users in dealing with various functionalities like prompts, views, aggregates, guided navigation, customization, conditional formatting and drill-down capabilities.

Environment: OBIEE 10.1.3.4, 11.1.1.5, Oracle 11g Database, Progress 10.2B, ODI 11g, UNIX, Toad, SQL Developer, AQT.

Confidential, Atlanta, GA

Sr. OBIEE Consultant

Responsibilities:

• Conducted Sessions with Business Leads to Understand Business Process, gather requirements related to Commercial Sales and to enhance the existing Business reports.
• Designed Oracle BIEE Repository at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer as per the Universes in Business Objects and followed best practices.
• Created Dimensional Hierarchy, Aggregate columns, Level based Measures and Aggregate navigation in BMM layer to improve performance in rpd.
• Implemented Security Model, by creating User Roles and Web Groups,and setting upExternal Tables and LDAP Servers.
• Worked with Cache Manager to improve performance.
• Developed and debugged many Dashboards using different Analytics Views (Pivot Table, Chart, and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, guided navigation links, tabular using shared and local Filters.
• Replicated the Reports, Dashboard, and Functionality in Business Objects to OBIEE (nearly 300 reports).
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug SQL query issued during report execution.
• Performed Unit Testing by comparing the data in OBIEE and Business Objects.
• Identified causes of performance issues and helped to resolve the same.
• Documented the conversion process from Business Objects to OBIEE for future reference.
• Involved in training business users on OBIEE Answers and Dashboards and educating technical super users and administrators on repository and web catalog migrations procedures with Oracle best practices.

Environment: OBIEE 10.1.3.4, Oracle 10g database, Business Objects 6.5/XI, TOAD

Confidential, Green Bay, WI

Sr.OBIEE Consultant

Responsibilities:

• Involved in the whole life cycle of the project which includes requirement gathering, design, development, testing and release and production support.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and Presentation Layer in a BI repository.
• Created connection pools, physical tables, defined joins in the physical layer of the repository.
• Worked with OBIEE Answers, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, prompts, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users needs.
• Worked on Answers to build Interactive Dashboards with drill-down capabilities.
• Developed different kinds of Reports (pivots, charts, tabular views) using global and local Filters.
• Worked on Time series functions (ago and todate) to show percent change for several measures compared to one or two year ago.
• Managed day-to-day Rpd, Delivers, Scheduler & ibots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Implemented security using LDAP Authentication and using External table authorization.
• Worked on Cache management mechanisms to clear out the Cache on the OBIEE server side.
• Worked extensively on the initialization blocks and Dynamic variables.
• Created Virtual Dimensions (Aliases) on the original tables, and used them to join to other fact tables.
• Used the expression builder in the BMM layer and created various calculation measures.
• Involved in Design and Data Modeling using Star schema and constructed SCD’s.
• Peer review of code, testing, monitoring NQSQuery and tuning reports.
• Involved in upgrading the platform and applications to OBIEE through sequential and concurrent tasks which includes migrating webcat and migrating the rpd.
• Created report Layouts using BI Publisher desktop in MS word and produced various RTF templates and scheduled the reports.

Environment: OBIEE 10.1.3.4, 10.1.3.3, Oracle 10g, UNIX, BI Publisher, SQL, SQL server, Windows.

Confidential, Houston, TX

OBIEE Consultant

Responsibilities:

• Involved in the whole life cycle of the project which includes requirement gathering, design, development, testing and release and production support.
• Customized OOTB (Out of the box) for modules Oracle HR Analytics and Oracle Incentive Compensation repository as per the business requirements.
• Personally implemented most key projects of Empower rollout which involved building dashboards for Order Management, Order Fulfillment, Customer Service, Installation Management, Cash Management and Incentive Compensation.
• Customized the logical tables, logical tables source and columns, dimensional hierarchies, aggregations and logical levels,
• Created number of key reports for business such as Cross sales report, Revenue report, Finance and Authorization report, Lender analysis report for business to analyze.
• Designed Intelligence Dashboards and created Global Filters.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Configured repository and session variables to get dynamic reports and dashboards.
• Used Catalog Manager to maintain web catalog to manage Dashboards and Answers.
• Created groups in the repository and added users to the groups and granted privileges explicitly.
• Integrated BI Publisher with OBIEE to develop reports.
• Implemented the delivery of iBots using OBI Delivers to alert the associated teams.
• Designed & assisted Informatica ETL developer to create new Aggregates.
• Created data Model using Erwin from data source and define the dimensions.

Environment: OBIEE 10.1.3.3,10.1.3.2, Oracle 10g, BI Apps 7.9.1,7.9.4, LDAP, SQL, PL/SQL, SQL*Plus, OBI Publisher, Windows.

Confidential, OH

Siebel Analytics/Informatica Consultant

Responsibilities:

• Responsible for overall delivery of Competitor Brand Siebel Analytics Report.
• End to end project delivery from design of DW data model, ETL mappings and logic design of Analytic Report layer.
• Design and build a data warehouse model of competitor information and perform mapping of competitors’ data hierarchy to P&G hierarchy.
• Involved in all the design aspects that ranged from Data Architect (Data Modeler) to System Architect (Siebel Analytics and ETL Architect).
• Design and implement the Object level security and Data level security to restrict the users from accessing objects and restricting query privileges.
• Successfully designed and deployed the Data Model for Competitor Brand data.
• Involved in creating Business Model & Mapping layer and Presentation layer including all the calculations, aggregations and dimensional hierarchies associated with it.
• Designed Reports and organized Dashboards based on the business requirements from Analysts.
• Designed ETL methodology for loading data from flat files to final reporting tables.
• Developed mappings and workflows using various Transformations.
• Involved in Tasks and Workflows using Informatica Power Center Work Flow Manager and monitored them in Work Flow Monitor.
• Extensive use of mapping and logics to build the Competitor Brand Data.
• Extensive use of format conversion to resolve the issues related to mapping and logics.
• Documented and provided operational support and maintenance for the entire project including backup and restore of critical components of Siebel Analytics.

Environment: Siebel Analytics 7.8.x, Siebel DAC, Siebel Tools, Informatica 7.1, Erwin Data Modeler, Oracle Designer, Oracle 9i

Confidential

DataWare House Consultant

Responsibilities:

• Worked with Informatica Power Center 6.1 -Source Analyzer, Warehousing designer, Mapping Designer, Mapplet Designer and Transformation Developer for creating Mappings.
• Using Informatica Workflow Manager for Creating, running the Workflows and Sessions and scheduling them to run at specified time.
• Optimized Informatica mappings for Performance at transformation level, mapping level and Session level.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis.
• Extensively designed Data mapping using filters, Expression, Update Strategy Transformations in
• Power Center Designer.
• Migrated Mappings, Sessions, Workflows and Common Objects from Development to Test and to Production.
• Scheduling and Loading data process and monitoring the ETL Process.
• Used various data Sources like Flat Files, Relational Tables.
• Extensively used Stored Procedures for PreSession and PostSession Data Loading Process. Environment: Informatica Power Center 6.1, Oracle 9i, SQL Server 2000

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in all Life Cycle Phases including requirement analysis, Client Interaction Design, Coding, Testing, support and Documentation.
• Created Relational Models by normalizing the database using logical grouping of tables.
• Developed high-end triggers, procedures, functions and packages an on multiple tables using PL/SQL without any mutation errors.
• Configured ODBC connectivity for new instances and client.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan and SQL Trace.
• Involved in Data Loading Sequence and Populated Data into Staging Area and Warehouse with Business Rules. Loading data to staging area (Oracle 8i) using Informatica Power Center 6.2, worked with pre and post sessions, and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
• Involved in translating business reporting requirements into data warehouse architectural design.
• Created Functional Specification document and High-Level design document.

Environment: Oracle 9i, PL/SQL, TOAD, Oracle Forms 6i, Oracle Reports 6i, SQL Navigator 4.1, SQL Loader, UNIX, Win XP/2000.