SUMMARY

• Over 8 years of experience in Software Development, and over 6.5 years with OBIEE 11/10, BI/XML Publisher
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Interactive Dashboards, BI Publisher, Delivers and iBots within OBIEE suite
• Experience in installation and configuration of OBIEE, DAC and administering permissions, privileges to users based on their groups and responsibilities
• Expertise in configuration and integration of BI publisher with BI Answers and BI Server. BI Publisher reports development, render the same via BI Dashboards
• Installation and configuration of OBIEE 11, BI Publisher Enterprise, Repository Configuration Utility (RCU), Enterprise Manager 11g, Weblogic Server 11g.
• Expertise in ETL methodology for supporting data extraction, loading and transformation processing using Informatica Power Center
• Experience in developing Informatica Transformations and Mappings
• Experienced in tuning Informatica Mappings, Sessions and SQL queries for better performance
• Designed Star schemas, Snowflake schemas for Data Marts and Data Warehouses
• Experience in shell scripting (pre - sessions and post-sessions commands)
• Expertise in debugging and optimizing the Oracle BI / OBIEE Dashboards / Reports and Informatica Mappings / Workflows
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies
• Excellent problem solving, troubleshooting and decision-making skills.

TECHNICAL SKILLS

OLAP Tools: OBIEE 11/10, OBIA, BI / XML Publisher, Siebel Analytics 7.8.2, Hyperion Essbase 9.3.1

RDBMS: Oracle 11g/10g/9i/8i

Applications: Oracle E-Business Suite Releases 11.x (GL, AP, AR, PO) / R12, Siebel CRM

Oracle Tools: Oracle Discoverer, Oracle Reports, Oracle Forms, SQL*Loader, SQL Developer

ETL Tools: Informatica Power Center 8.2/7.1/5.1, Informatica PowerMart 5.0/4.7, DAC

Data Modeling: MS Visio, Erwin.

Languages: VB, PL/SQL, Java Script, VB Script, Toad

Operating Systems: Windows XP/00/NT/98/95, Linux, UNIX (Solaris)

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Sr Business Intelligence Developer

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
• Upgraded Micro Strategy to OBIEE 11.1.1.6 and changes to new reports
• Involved in creating the Star Schema, Logical and Physical Modeling,identified Facts, Dimensions, and Hierarchies of the business model
• Identified the granularity level of the business model based on the end user requirements.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Worked Closely with ODI developers in creating new metrics for the Reports.
• Involved in creating Style sheets for the Report Catalog.
• Worked Extensively on RPD in creating the presentation variables and repository variables. worked Extensively in the RPD level security and Repository Level security.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Involved in developing the testing documents like Estimates, Test Strategy, Test Plan, Use cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications.
• Experience in preparing Test Execution Report, Participated in unit-testing, and supported User Acceptance Testing
• Transition knowledge and train developers.

Environment: OBIEE 11G(11.1.1.5,11.1.1.6), ODIEE,Micro strategy, Windows XP / 2003 server

Confidential, Ohio

OBIEE Devoloper

Responsibilities:

• Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing.
• Prepared, Integrated and Configured Siebel CRM 8.1 with BI publisher 10.1.3.4.1.
• Configured Outbound webservices for BI Publisher server and created report responsibilities in Siebel Application.
• Configured Security and Authentication with Siebel security model and LDAP security model.
• Embedded BI Publisher scheduled reports view in Siebel and Configured BIPDataService WSDL for BI Publisher server.
• Manages the BIP servers perform Administration, Migration and Update responsibilities.
• Participating in problem solving and troubleshooting for the applications implemented with ODI.
• Experience with ODI integration between OBIEE and/or Hyperion Planning is a plus
• Experience with customizing knowledge modules
• Experience developing complex transformations
• Experience with Oracle SOA Suite
• Prepared and uploaded new / modified / preconfigured report layout templates to BI Publisher server and multiple Siebel server environments.
• Involved in Administering automatic purging of reports in Siebel file system and purging of schedule reports from BI Publisher server.
• Created custom reports, created new Integration objects and involved in the process of registering and scheduling of reports in BIP and Siebel servers.
• Involved in packaging and Migrating of reports from Source to Target environments using Application Deployment Manager.
• Configured BI Publisher and Integrated with OBIEE server
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Involved in developing the testing documents like Estimates, Test Strategy, Test Plan, Use cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications. Experience in preparing Test Execution Report.

Environment: OBIEE 11, Siebel CRM 8.1, BI Publisher, Windows XP / 2003 server

Confidential, Cincinnati, Ohio

OBIEE Senior Developer

Responsibilities:

• Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing
• Installed and configured OBIEE 10g and Custom development of the RPD on Oracle 11g RDBMS.
• Upgraded from OBIEE 10g to OBIEE 11g including the upgrade of 7.8.4 applications to 7.9.6 applications
• Support Informatica Power Center mappings design and development
• Extensive development within BI Answers and Interactive Dashboards
• Configured BI Publisher and Integrated with OBIEE server
• Extensive BI Publisher reports development using BI Answers and Subject Areas (BI Server) as Data Sources. Includes both Finance and operational reports.
• Configured and Integrated BI Publisher scheduler to schedule reports and view the saved data
• Integrated BI Server and BI Publisher, with LDAP security model, folder access management within BI Publisher for those LDAP roles and groups
• Worked extensively on various Cache Management techniques to increase the performance of both Real-Time and Non Real-Time reports
• Enforced criteria based navigation to achieve better SLA on Ad hoc queries based on customer origination and industries
• Implemented Dashboard Prompts, and presentation variables for global reports and Dashboard usage.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent
• Participated in unit-testing, and supported User Acceptance Testing
• Transition knowledge and train developers.
• Involved in installation and configuration of OBIEE 11.1.1.3, BI Publisher Enterprise, Repository Configuration Utility (RCU), Enterprise Manager 11g, Web logic Server 11g for future upgradation.
• Developed few XML Publisher reports in Peoplesoft 9.0

Environment: OBIEE 10/ 11, OBIA 7.9.6.3, BI Publisher, Oracle 10/11g, Toad, Windows XP, PL/SQL, Erwin.

Confidential, Boston, MA

OBIEE Developer

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Installed and configured Oracle BI EE 10.1.3.4/ Oracle Financial Analytics 7.9.5 on Windows.
• Installed and configured BI Publisher and Integrated with OBIEE server.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Identified the granularity level of the business model based on the end user requirements.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business, and presentation layer of the repository.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Enforced criteria based navigation to achieve better SLA on Ad hoc queries based on customer origination and industries.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Created corporate standard variables in the metadata to ensure standard measures and best practices are followed.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drill downs. Setup the visibility of dashboards to employees with respect to their responsibilities.
• Implemented Prompts to provide dynamic filter condition to End users.
• Created Intelligent Dashboards for different groups of users to view across regions, Customer Demography with the facility to drill downs and charts.
• Providing object level security for different web groups based on responsibilities.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica Power Center 8.6.
• Developed many delta / incremental complex Informatica ETL process and Oracle Packages i.e., Mappings & Mapplets using various Transformations.
• Redesign Informatica ETL & DAC mappings based on new requirements.
• Configured DAC to run nightly data loads on daily basis.
• Configured new customized mappings & work flows in DAC for new customized subject area.
• Migrated the mappings and workflows from the development server to the Test Server to perform the integration and system testing.
• Involved in developing the testing documents like Estimates, Test Strategy, Test Plan, Use cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications. Experience in preparing Test Execution Report.

Environment: OBIEE 10.1.3.4, BI Publisher, Oracle 10g, Informatica 8.6, DAC, Toad, Windows XP, PL/SQL, Erwin.

Confidential, Carbondale, IL

OBIEE Developer

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
• Upgraded Siebel Analytics 7.8 to OBIEE 10.1.3.2 and changes to new reports.
• Involved in creating the Star Schema, Logical and Physical Modeling
• Built the Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer)
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively
• Created Aggregated Tables and Configured the Content in Business Model Layer to use the Aggregate Tables for better Performance
• Created BI Publisher RTF templates in MS Word, publish the same in BI Publisher Enterprise Edition, as well as on BI Interactive Dashboards.
• Configured BI Publisher and Integrated with OBIEE server, and its security model
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics
• Developed Various Dashboards and Reports and Created the Business Model for Ad-hoc queries using Oracle BI Answers and assigning them to application specific dashboards
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security
• Managed and provided Permissions for Reports and Dashboards in OBIEE Presentation Services Web Catalog
• Involved in Testing the reports and writing Test cases for Reports developed

Environment: Oracle 10g, OBIEE 10.1.3.2, BI Publisher, Informatica, DAC, SQL Developer, Windows NT

Confidential, Boston, MA

OBIEE Developer

Responsibilities:

• Participated in migrating Oracle Discoverer End-User-Layer (EUL) over to OBIEE platform
• Reviewed existing Oracle Discoverer environment on Oracle 10g Database, and architected migration of reporting over to OBIEE solution
• Utilized Oracle provided migration utility to migrate Discoverer EUL (metadata) over to OBIEE RPD
• Extensive re-work of hierarchies, BMM mappings, joins, and other areas broken with the migration utility (first release)
• Architect and lead development of OBIEE repository and security model to mimic the one in Discoverer
• Developed and supported creation of new Adhoc Answers requests and Dashboards in OBIEE
• Configured OBIEE Event Caching and Cache management features for improved end-user query experience
• Security configuration of OBIEE presentation catalog and data access
• Integration of BI Publisher with OBIEE and Oracle Discoverer environment
• 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
• QA testing and data validation support

Environment: Oracle Applications Release 11.5.10 (PA, PO, Financials), Oracle BI Publisher, Oracle RDBMS 10g, Oracle Application Express 3.1, Oracle Business Intelligence Enterprise Edition 10.1.3.3

Confidential, Cleveland OH

OBIEE Developer

Responsibilities:

• Participated in requirements gathering, prepare System Design Documents, and dimensional modeling and upgrade from 7.8 to OBIEE 10.1.3.3
• Custom design and develop OBIEE/Siebel Metadata Repository
• Configure Hierarchies, integration from multiple data sources, LDAP based authentication model, implemented Caching and Cache Management
• Involved in developing ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center
• Involved in fine-tuning of Informatica Mappings
• Developed several BI Answers requests, worked with different layouts (pivots, charts, tabular) using global and local filters
• 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.
• Configured and used Siebel Delivers and iBots extensively
• Integration of BI Publisher with BI Server and BI Presentation Services. Developed static pixel perfect Sales reports using BI Publisher with BI Answers as the data source

Environment: Windows XP, OBIEE 10.1.3.3, BI Publisher, Informatica 8.1, Oracle 10g, SQL, TOAD, PL/SQL.

Confidential

Siebel Analytics Developer

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model and Mapping Layer and Presentation Layer in a Siebel Analytics Repository.
• Configured analytics repository with logical dimensional modeling using Star Schema (Facts and Dimensions).
• Configured and created repository using Siebel Analytic Admin Tool.
• Developed different kinds of reports/Ad-hoc queries using Siebel Answers and assigned them to application specific dashboards.
• Created connection pools to retrieve data from Siebel OLAP layer, real time Siebel OLTP data and data from Oracle Database.
• Managed day to day .rpd, scheduler, and iBots.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Involved in setting up Delivers to configure iBots based on the threshold value to the users.
• Developed UNIX and PL/SQL scripts for pre & post session processes to automate daily loads.
• Created ibots and Delivers to send Alert messages to subscribed users.
• Worked on various Informatica mappings as per business requirement.
• Worked extensively on Unit testing, Integration testing and fixed bugs during the UAT phase.

Environment: Siebel Analytics 7.7.1, Informatica Power Center 6.1, Oracle 8i, TOAD, UNIX