SUMMARY

• 8+ years of Strong experience in Complete Software development Life cycle (SDLC) which includes Business Requirements Gathering, System Analysis & Design, Data Modeling, Development, Testing and Implementation of Data Warehouse and Business Intelligence Applications.
• More than 5 years of experience in Oracle Business Intelligence Enterprise Edition 11g/10g and Siebel Analytics 7.x.
• More than 5 years of experience in Oracle BI Publisher, MS Office Plug - in for rich reporting and Oracle BI Scheduler Configuration for Alerts / iBots.
• Experience in Installation, Configuration, and Administration of Oracle BI 11.1.1.x, 10.1.3.4, Oracle 10g standalone.
• Experience in Upgrading Siebel business analytics 7x to OBIEE 10g & from OBIEE 10g to OBIEE 11g.
• Upgraded BI Publisher 11.1.1.6 to 11.1.1.7
• Strong experience withTransactional andDimensional Data Modeling, Data Warehousing Concepts,and Designing Star & Snowflake Schemas for OLAP Systems.
• Expertise in developing OBIEE repository with Physical, Logical and Presentation layers build reports/dashboards from the repository using OBIEE (Siebel) Answers and troubleshoot various technical issues and bugs.
• Developed variousDynamic and InteractiveDashboards/Reportswith intuitivedrilldowns, drill-acrossand drillable charts using Oracle Answers
• Experienced in installing and configuring BI Discoverer 11g which includes BI Discoverer Administration and BI Discoverer Desktop.
• Expertise in OBIEE/Siebel Analytics features (i.e. Clustering, Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.)
• Involved in upgrading Informatica Power center Components 7.1.2 to 8.6x and from 8.6.1 to 9.0.1.
• Knowledge in developing Informatica Mappings / Mapplets usng various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and Creating Workflows with Worklets & Tasks and Scheduling using Workflow Manager
• Experienced in Performing end to end testing, creating Test Plans including Data Validation, Unit Testing and User Acceptance.
• Experience in interacting with Business users to analyze the business process and requirements and writing technical documentation and rolling out the deliverable.
• Excellent Team Management Skills with good business acumen, effective communicator, good team mentoring and training skills, experience in working with Business Users, Controllers, Directors, Senior Managers, Executives, Department Heads and Project Stake Holders.
• Goodknowledge of HR, CFO, Project Accounting or Procurement modules in an organization level.
• Very knowledgable on People soft technologies.
• Excellent problem solving skills with strong technical background and good inter-personal skills, Quick learner and excellent team player, ability to meet deadlines and work under pressure.

TECHNICAL SKILLS

Business Intelligence Tools: OBIEE/Siebel Analytics 11g/10g (Oracle BI Administration, Oracle BI Presentation, Oracle BI Dashboards, Oracle BI Delivers, Oracle BI Publisher, Catalog Manager) Oracle BI Applications 7.9.5(DAC, OBIEE Platform), OBIEE Plus, Hyperion Interactive reporting

Data Warehousing: Informatica 8.1/7.1, Data Mining, Data mart, OLAP, ROLAP(Relational), OLTP, SQL *Plus, SQL *Loader

Data Modeling Tools: ERWIN 4.0, MS Visio, Rational Rose

DATABASES: Oracle 8i/9i/10g/11g, SQL Server 2005/2000, MS Access, DB2

LANGUAGES: C, C++, C#, SQL, PL/SQL, Java, J2EE, HTML, XML,VB,UML

OPERATING SYSTEMS: Windows 95/98/2000/2003/ NT/XP/Vista, MS DOS, LINUX, HP-UX

Tool: & IDE: DAC (Data warehouse Administration Console), Microsoft Visual Studio 2003/05, HP Quality Center.

SQL Tools: SQL Developer, TOAD.

Application Servers: OC4J, Apache Tomcat.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr OBIEE Consultant/Lead

Responsibilities:

• Involved in Requirements gathering, functional/technical specifications, development, deployment and testing.
• Created Business Facts & Dimensions and defined logical relation between them in BMM layer.
• Created Drill down Hierarchies and implemented Business Logics for Facts.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data level and User level Security.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• 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 suite.
• Designed, implemented and tested Security Privileges on subject areas, dashboards and BIP reports.
• Managed and customized the ETL Informatica/DAC loads, RPD and Web catalog metadata according to the reporting needs of the client.
• Built Repository Confidential 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model Mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
• Monitored incremental and full load of data through Data Warehouse Administration Console (DAC) and Informatica.
• Upgrading the OBIEE 11.1.1.5x to OBIEE 11.1.1.7x on both windows and AIX.
• Worked on integrating and configuring the BI Publisher with OBIEE.
• Upgraded BI Publisher 11.1.1.5x to 11.1.1.7x
• Worked Extensively on developing Excel Templates, Filtered data based on various Parameters & Created Multi Sheet Excel reports in BI Publisher 11g.
• Worked extensively on declaring variables in templates for the complex calculations.
• Involved in Migrating reports from one environment to other environments.
• Customized various BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
• Installing, Configuring and Administering of Oracle Business Intelligence Enterprise Edition (OBIEE 10.1.3.4.1 , OBIEE 11.1.1.5 & Siebel Analytics 7.8x).
• Responsible for Unit and System Testing and performed Data Validation using Quality center tool.
• Also applied the different OBI Patches both on the Windows and Linux boxes.
• Created PDF/EXCEL/Word output’s for reports based on requirements.
• Customized the login page and dashboards using style sheets and XML files.
• Used Toad & SQL*Loader to import receipts data into AR Payments Interface table after defining Lockbox, and Transmission Format and running Lockbox interface form transferred data into Oracle Receivables.

Environment: OBIEE 11.1.1.x, BI Publisher 11.1.1.x, Oracle R12 (General Ledger GL, Account Payables AP, Account Receivables AR, TCA, Purchasing PO, Order Management(OM), Reports 6i, Oracle 9i (9.2.0), Workflow Builder 2.6. Discoverer 11g, SQL*PLUS, SQL*Loader, TOAD, AIX 6.1.

Confidential, Irving, Texas

Sr OBIEE Consultant/Lead

Responsibilities:

• Gathering the Business requirements from the Business users.
• Install, Configure & Administer the OBIEE 11g/10g/7.x & BI Publisher 11.1.1.x
• Customized the OBIEE Repository (Physical, BMM & Presentation Layer), Created the connection pools, Joins, hierarchies, aggregates & keys, Time series function.
• Installing and configuring the Hyperion Interactive reporting.
• Upgrade RPD & Web Catalog from Siebel Analytics V7.8.2.x to OBIEE 10g and then OBIEE 10g to OBIEE11g.
• Upgraded OBI Apps 7.9.6 to 7.9.6.4
• Experienced in Supply Chain, Order Mgmt Analytics and Procurement & Spend Analytics
• Installed & Configure the BI Publisher scheduler to schedule reports and view the saved data.
• Built Repository Confidential 3 layers i.e., Physical Layer, Business Model Mapping and Presentation Layer level.
• Used the Security settings in BI Admin tool to setup Users, Groups and Access privileges.
• Analyzed and validated the business model in Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Created presentation catalogs and organized tables and columns in presentation layer.
• Merged new RPD, dashboard and Answers requests with existing OBIEE content.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table)
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up in reports.
• Customized all the Dashboards, Analysis reports to look and feel as per the business requirements.
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog.
• Good experience and knowledge in GUI Design as per users requirement..
• Tested and validated the repository, reports and dashboards.
• Written test scripts to compare OLTP vs OLAP for ETL testing.
• Customized ETL Informatica Jobs.
• Installation and configuration of Informatica Power center Components 7.1.2/8.5.1/8.6/9.0.1 and DAC 10.1.3.4.1 .
• Upgraded Informatica 7.1.2 repository to Informatica 8.5.1/8.6 & 9.0.1
• Tested RPD, Webcatalog, Informatica and DAC customizations.
• Provided End-User training on Informatica Power center 9.0.1, Hyperion Interactive reporting & OBIEE.
• Designed, developed and implemented an Extract-Transform-Load (ETL) process for executive management reporting
• Designed various mappings using transformations like Lookup, Router, Update Strategy, Filter Sequence Generator, Joiner, Aggregator, and Expression Transformation.

Environment: OBIEE 10g/ 11g (Repository, Answers, Dashboards, Delivers), BI publisher, Informatica 8.5.1, DAC 10.1.3.4.1 , TOAD 10.1.1.8, Oracle 10g, Windows XP, AIX, FileZilla client.

Confidential, Seattle,WA

Sr. OBIEE Consultant

Responsibilities:

• Involved in gathering & analyzing the Business/User requirements.
• Installed and configured complete suite of OBIEE 10.1.3.4/ OBIEE 11.1.1.5 on both Windows (DEV) and Linux (QA and PROD) environments.
• Very good understanding and hands on experience on OBIA 7.9.x
• Worked closely with Data warehouse team to get good knowledge on the data architecture to get efficient and fast reports.
• Designed the star schema in the data model (Physical, Business and Presentation) in the repository.
• Created the Hierarchies, drills and level-based measures on different dimensions in the repository.
• Configured OBIEE Event Caching and Cache management features for improved end-user query experience.
• Worked closely in migrating the Security Groups, Id’s, Users Confidential the time of migration along with catalog.
• Worked efficiently in creating the session variables and also assigning the security groups and users. Also, worked on the data-level security to restrict the data to certain groups of users.
• Created reports using the Pivot Tables, View Selectors, Column selectors, Guided Navigations, In-place drills in the reports, Embedding HTML links in the report columns etc.
• Also worked on color gauge reports on a different dashboard that helped the users to easily analyze the reports.
• Worked in creating the presentation variables, global filters, charts, tables, global prompts. Creating glossaries as a book-mark link in the reports.
• Worked on BI Publisher reports in generating the templates (Word, PDF, and HTML) as required.
• Integrated BI Server and BI Publisher, with LDAP security model, folder access management within BI Publisher for those LDAP roles and groups.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent.
• Customized ETL (Informatica) Jobs.
• Developed Informatica Mappings/ workflows to extract the data from Oracle Apps.
• Fine Tuned Informatica mappings & PL/SQL procedures for better Performance.
• Efficiently co-ordinate with the offshore team in taking the requirements between the client and team efficiently and meeting the deadlines and the deliverables on time.
• Participated in unit-testing, and supported User Acceptance Testing.

Environment: OBIEE 10g/11g, Oracle BI Answers, BI Publisher, Oracle 10/11g, SQL Navigator, PL/SQL, Toad, Windows XP, Linux.

Confidential, Providence, RI

SR. OBIEE Consultant

Responsibilities:

• To analyze the specifications provided by the client, understanding the business.
• Install, configure and administer the OBIEE platform.
• Worked on Metadata on different subject areas and BI Answers in generating the reports and dashboards.
• Involved closely with the Business users, Analysts and also the Data warehouse Team in the meetings to build good efficient data model that makes the performance of the reports fast and running.
• Prepared both Business and Functional Documents as per the requirement gatherings.
• Worked on creating reports build on 3NF in the Teradata and also worked on Adhoc-Functionality on a subject area as per the Business request.
• Involved in Repository Configuration, Troubleshooting, and Migrations to from all the environments (LOCAL to DEV to QA to PROD).
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Designed the Star Schema for all the different subject areas and build hierarchies, level-based measures, Aggregate level, Alias tables, Implicit Facts.
• Extracted data from various systems like Teradata, Access database, Excel sheets and also from Flat Files.
• Used the Catalog Manager for the migrations to different environments and worked on the security of different groups and users, Maintained the dashboards and Answers and Used Analytics Web Catalog to set up groups, access privileges and query privileges
• Developed different brand level Reports, Filters, and Prompts using Oracle BI Answers.
• Used Filters (Global and Local) and provided customized prompts to avoid excessive data showing up in the reports.
• Implemented both Object-level security and also the data-level security on the dashboards depending on the business requirements.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads.
• Worked on BI Publisher reports and made cosmetic changes by enabling the add-on the Microsoft word.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Colored Gauges, Column Selector, View Selector, global and local Filters) using Oracle BI Presentation Services..
• Worked closely with Datastage Mappings, Mapplets, Sessions, Workflows and Worklets for extraction, transformation & loading.
• Worked for performance tuning by finding out the bottlenecks in various mappings.
• Trained and worked with the end-users in developing their own ad-hoc reports using OBIEE Answers.
• Involved in writing the Test Cases, Unit testing and Regression Testing and the data testing with the Data Analyst and also worked mostly on the Production Support issues.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Oracle BI Answers, BI Administration, BI Publisher, Datastage 8.1, Oracle 11g, MS Access, Teradata 12, Teradata SQL Assistant, Windows XP, UNIX

Confidential, Washington D.C

Sr. OBIEE Consultant

Responsibilities:

• Participated in requirements gathering, prepare System Design Documents, and dimensional modeling
• Installed and configured Oracle BIEE 10.1.3.4.1 and Custom development of the RPD on Oracle 10g RDBMS.
• Extensive re-work of Hierarchies, BMM mappings, joins, and other areas broken with the migration utility.
• Involved in migrations of the development from DEV to QA and finally to PROD environments on both Windows and Linux boxes using the version control tool called SVN.
• Developed and supported creation of new Adhoc Answers requests and Dashboards in OBIEE.
• Extensive usage of repository variables, server variables, and presentation variables, following best practices and standards
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Also worked closely with the Flex Developer while integrating the Flex in BI Reports for more flash and graphical reports.
• Worked on moving the entire catalog, security groups to the production and also involved in the production support.
• Used TOAD and SQL Navigator for the database queries.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Developed several BI Publisher reports with both BI Answers, and Oracle Discoverer as the data sources.
• Oracle Discoverer data source was a temporary solution, while being entirely migrated over to OBIEE.
• Involved in setting up Delivers to configure iBots to send Alert messages based on the threshold value to the users.
• Worked on performance tuning on dashboard and BI Publisher reports working closely with the database developers on indexes and tuning the data in the tables with the appropriate facts and dimension measure in the tables.
• Experience in handling projects like reimbursing expences and medical claims for employees in organization.
• Performed Unit and Regression testing on all the reports developed to maintain consistency and efficiency to meet the users requirement.

Environment: Oracle Business Intelligence Enterprise Edition 10.1.3.4. Oracle BI Publisher, Oracle 10g, Flash Builder 9, TOAD, SQL Navigator, Windows XP.

Confidential, Alpharetta, GA

Sr. OBIEE Developer

Responsibilities:

• Installed and configured complete suite of OBIEE 10.1.3.4 in test and development environment on windows platform.
• Worked closely with business users in the client side and designed the system accordingly.
• Created the new RPD and detail level drill downs to as per business requirements using Oracle Answers.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Worked on the different layers in the data model (Physical, Business and Presentation).
• Involved in gathering and analyzing requirements and documenting them for further implementation.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Customized Repository (RPD) to work with other EBI systems.
• Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.
• Used presentation variable in OBIEE Oracle answers to save prompt values and use them for conditional formatting.
• Developed different Dashboards/Reports with different view( Calculation, Detailed, Pivot, Charts, Filters) using the Presentation services.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Developed process for object level migration of web catalog, for post production release of - enhanced and bug fixed reports.
• Worked with both migrations of the Development and QA environments.
• Used TOAD for Oracle and SQL Navigator to connect to databases in Oracle.
• Performed Unit Testing and worked with the end user Confidential various stages of the test cycles.
• Conducted meetings with Project Managers, Business Users and Business Analysts during testing and deployment stage of the application development lifecycle.

Environment: OBIEE 10.1.3.4, Oracle Answers 10.1.3.4, Informatica Power Center 8.1.1, Oracle 9i, TOAD, SQL Navigator, Windows XP Professional.

Confidential - Coulter, CA

OBIEE Developer

Responsibilities:

• Created Campaign Tracking Dashboards, Advisor Dashboards and Management Dashboard.
• Created business reports using Oracle Answers as per requirements.
• Generated various Analytics reports like Formulary Report and Direct Sales Report using global and local filters.
• Involved in modifications of physical, business and presentation layers of metadata repository using Oracle BI Administration tool.
• Identified in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Created iBots and delivers to send alert messages to subscribed user groups.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Configured and administered existing subject areas and created new subject areas as per the modified Star schema information.
• Also worked with the end-users in developing their own ad-hoc reports using OBIEE Answers.
• Involved in technical documentation that helps the end users to develop the reports later.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Oracle BI Answers, BI Publishers, Oracle 9i, Windows NT.

Confidential, San Diego, CA

Siebel Analytics Developer

Responsibilities:

• Developed Solution Designs and Detailed Design Documents based on Siebel Analytics Requirements and Business reviews.
• Expert in Siebel Analytics Physical, Business and Presentation Layers.
• Extensively worked on physical, business and presentation layers
• Developed Assets, Opportunities, Entitlements, Partner Authorizations, Service Requests subject areas using Siebel Analytics/Answers.
• Expert in Siebel Analytics components - Clients, .RPD, Presentation Services, server, repository and data sources.
• Extensively worked on RPD, Webcat and Dashboards and Configured Column and Dashboard Filters in Siebel Analytics Requirement validation of the reports and drilldowns.
• Created logical tables and assigned levels and custom aggregation rules.
• Used Catalog manager to do work between folders.
• Developed Uploading process of the FEA and all data types, field sizes and formats.
• Worked on Siebel Analytics Administration tools - online and offline.
• Analyze the ETL procedures and developed mappings, mapplets, and using most of the transformations.
• Written SQL queried to test the OLTP & OLAP Databases based on changes of the functionality.
• Did ETL - Data Load Process “Full Load and Incremental Load” testing.
• Created logical tables and assigned levels and custom aggregation rules.
• Worked and used most of the Informatica Transformations in Mappings.
• Extensively worked on synchronizing the thin client to the Handheld (palm) and completed successfully.
• Verified logical tables and validated levels and custom aggregation rules.

Environment: Siebel Call Center 7.7, Siebel Integrated Application 7.8.2, Test Director 7.6, Win XP Professional, Oracle 9i, Informatica 7.1.1 and MS Access, TOAD.

Confidential

ORACLE DEVELOPER

Responsibilities:

• Gathered the requirement from the client and translated the business design into Technical design.
• Monitor performance and changing performance requirements through application of database tuning and performance optimization techniques.
• Triggers, procedures and functions are developed in this reports using PL/SQL.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Created user defined Exceptions while handling exceptions.
• Troubleshooting production problems and worked effectively with other team members to identify and address problem.

Environment: Oracle 8i, PL/SQL, SQL * PLUS, TOAD, Windows 2000.