SUMMARY

• Over 8 years of experience in Software Development, and over 6.5 years with OBIEE 11/10
• Over 1.5 years experience with 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 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, 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
• 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 PublisherSiebel 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, Albany, NY

Sr. Business Intelligence Devoloper/Administrator

Responsibilities:

• Interacted with Procurement and Operation/Maintenance business representatives for gathering the OBIEE Reports/ Dashboards requirements and to define business and functional specifications
• Involved in meetings business representatives for requirement analysis and to define business and functional specifications.
• Identified the Gap’s by analyzing the data mart instance and provided alternative solutions as well as recommended changes to database.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Developed many reports / Dashboards with different Analytic Views (drill-Down / dynamic, Cascading styles Sheets, Pivot Table, Charts, Column Selector, Tabular with global and local filters) using Siebel Analytics Web.
• Analyzed and used various data sources- Oracle and Excel and Web services.
• Identified Facts and Dimensions levels/ Hierarchies of Dimensional model.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Developed many reports/dashboards Analytic views (Pivot Tables, Charts, Column Selector, and View Selector).
• Created the test schema and Test data according to Report Requirements and recommended Data model changes
• Developed the Incremental ETL Processes like Mappings & Mapplets using various Transformations. And workflows with Sessions/Tasks. Executed the workflows with Shell Scripts.
• Created measures and level Based measures in Business Model
• Created logical Tables and logical columns, Physical Columns.
• Created measure with Logical Columns and Physical Columns.
• Created Dimension hierarchy in Business model layer.
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
• Performance tuning of Dashboards/reports and made recommendations for changes to database by implementing the materialized views, partitions.
• Wrote complex sql queries to test the data warehouse.
• Involved in testing whether ETLs are accessing and picking up right data from right source and all the data transformations are correct according to the business rules and data warehouse is correctly populated with the transformed data.
• Tested the rejected records that don\'t fulfil transformation rules.
• Involved in Integration testing
• Tested sequence of ETLs jobs in batch and Initial loading of records on data warehouse.
• Worked in Incremental loading of records at a later date to verify the newly inserted or updated data.
• Tested the rejected records that don\'t fulfil transformation rules.
• Performed Unit, Integration and Regression testing to validate report and mapping functionality.
• Working Closely with users/developers and administrators to resolve the production problems by reviewing design changes.
• Designed and developed the OBIEE metadata repository (.RPD) using OBIEE Server Admin tool by importing required objects (Dimensions, Facts,Aggregations) with integrity constraints into physical layer using connection pool, developing multiple dimensions and logical and facts/ Measures objects in business model layer, and creating the presentation catalogs in presentation layer.
• Developed many reports/dashboards with different analytic views(Pivot table, charts, Column selectors, view selectors)
• Implemented basic security and external table authentication security mechanism
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
• ImplementedSecurityby authenticating against theLDAPandexternal table.
• Trained End Users and Pilot Users aboutOBIEE Tools.

Environment: OBIEE, Informatica Power Center 8.1.1, Oracle 10g, DAC, PL/SQL, T-SQL.

Confidential, Danbury, CT

Sr. Business Intelligence Lead/Administrator

Responsibilities:

• Involved in Analysis, Requirements gathering, functional /technical specifications, development, deployment and testing.
• Managed team of IT, business and marketing personnel to transition and enhance custom developed software
• Developed statements of work, interviewed potential candidates and assisted in knowledge transfer for consultants
• Created need/want analysis matrix for stakeholders to help them set project priorities and scope
• Managed teams of 4 - 6 consultants for a consulting company specializing in Internet application development
• Developed the project plan for the implementation that identified the schedule, tasks, milestones and requirements
• Involved in star schema creationinthemetadatalayer and the corresponding reports built on top of this usingOBIEE11g.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Involved in Merging Repositories using administration tool and Web Catalogs using Catalog Manager (migration)
• Highly experienced withrepositorydevelopment, configuredmetadataobjects (Subject Area, Table and Column) andWeb Catalogobjects (Dashboards, Pages, Folders, Reports).
• Analyzed and recommended enhancements toMetadata Reportingin all 3 layers (Physical, Business and Presentation) for the financial data mode
• Customized and developedrepository, configured metadata objects (Subject Area, Table, Column) andWebCatalogObjects(Dashboard, Pages, Folders, Reports)
• Layer, Business Layer and Presentation Layer (.RPD) to get new column as per BU.
• Developed OBIEE repository for LDAP data source by creating Physical, Business and Mapping and Presentation layers using OBIEE 11.1.1.5 Administration tool.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
• Involved in Configuration ofWebCatalog Security and Cache Management
• 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 Performing Test cases and various test scenarios to validated seeded OBIEE reports.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Guided Navigation, and Dynamic / Interactive Dashboards with drilldown capabilities using global and local Filters.
• Involved in set up of MUD environments

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

Confidential, San Leandro,CA

Sr. Business Intelligence Lead/Administrator

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics Requirements and created Business Models for Generating Reports as per the requirements
• Worked Majorly for the Oracle client such as Apple, Symantec,Skype,Yahoo,Nokia, Confidential Cisco,EBAY,Avaya, GE etc
• Developed statements of work, interviewed potential candidates and assisted in knowledge transfer for consultants
• Created need/want analysis matrix for stakeholders to help them set project priorities and scope
• Managed teams of 4 - 6 consultants for a consulting company specializing in Internet application development
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects
• Developed the project plan for the implementation that identified the schedule, tasks, milestones and requirements
• Lead development of dynamic e-commerce and e-business solutions for numerous clients
• Involved in star schema creationinthemetadatalayer and the corresponding reports built on top of this usingOBIEE11g.
• Customized and developed RPD (Physical, Business model and Presentation Layer), configured metadata objects and Web Catalog Objects.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Involved in Conversion of 200 nVision reports (PeopleSoft HR database) to OBIEE using HRA data
• Involved in the development and analysis of metrics for all phases of the talent lifecycle including working with HR analytics software
• Provide support in the implementation of OBIEE component
• Administer and create documentation on reports and system environment
• Design and implement data in various layers including physical, business and presentation
• Assist the teams in generating dashboards and reports properly
• Use the best practices of business intelligence to administer the analytical solutions
• Perform validation of data on the reports and monitor the performance status of the same
• Assist and administer the deployment process of UNIX, OBIEE and repository codes
• Prepare monthly reports and present it to the management
• Assess production faults and critical issues followed by identification of the root cause
• Provide remedial measures to the production issues or process failure
• Train the administration team on new OBIEE and ETL tools
• Worked extensively on Physical Layer, Business Layer and Presentation Layer (.RPD) to get new column as per BU.
• Developed OBIEE repository for LDAP data source by creating Physical, Business and Mapping and Presentation layers using OBIEE 11.1.1.5 Administration tool.
• Designed Star schema for fact & dimensional tables for metadata imported from LDAP and created alias for the dimensional tables when necessary.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards
• Involved in Configuration ofWebCatalog Security and Cache Management
• 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
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher reporting.
• Performing Test cases and various test scenarios to validated seeded OBIEE reports.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Guided Navigation, and Dynamic / Interactive Dashboards with drilldown capabilities using global and local Filters.
• Involved in set up of MUD environments
• Worked on Performance tuning on the Dashboards and Answers
• Created security settings to setup groups, query privileges and access privileges

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

Confidential, Stamford,CT

Sr. Business Intelligence Lead/Administrator

Responsibilities:

• Conducted research and analysis of business requirements, problems and available technologies to define systems solutions that increase efficiency and effectiveness.
• Involved in translating functional requirements into technical requirements.
• Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications.
• Analyzed and used various data sources - DB, XML, Excel, and OLAP.
• Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modelling.
• Customized and developed RPD (Physical, BMM and Presentation Layer).
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics web.
• Configured OBIEE iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.
• Performed Unit, Integration, and Regression testing to validate report.
• Used MS office plug-in for analyzing data.
• Implemented write back functionality.
• Designed Star schema for fact & dimensional tables for metadata imported from LDAP and created alias for the dimensional tables when necessary.
• Developed Physical Layer, Business Model & Mapping and Presentation Layer using Oracle BI Server Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created numerous reports, prompts and folders in Oracle Answers and used them in creating dashboards.
• Involved in Configuration ofWebCatalog Security and Cache Management
• 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
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher reporting.
• Performing Test cases and various test scenarios to validated seeded OBIEE reports.
• Developed and debugged many Dashboards / Reports with different Analytics Views (Pivot Table, Chart, Tabular and View Selector), Guided Navigation, and Dynamic / Interactive Dashboards with drilldown capabilities using global and local Filters.
• Involved in set up of MUD environments
• Worked on Performance tuning on the Dashboards and Answers
• Created security settings to setup groups, query privileges and access privileges

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

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
• Worked Majorly for the Oracle client such as Apple, Symantec,Skype,Yahoo,Nokia, Confidential Cisco,EBAY,Avaya, GE etc
• 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
• Debug the sessions by utilizing the logs of the sessions.
• Perform unit testing at various levels of the ETL.
• Transition knowledge and train developers.

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

Confidential, Ohio

OBIEE Developer

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 web services 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.
• 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.
• Design and build ETL processes (Star Schemas) and ETL for relational reporting
• Participating in problem solving and troubleshooting for the applications implemented with Odi Documenting all new and modified mappings according to standards as part of the Data Operations documentation
• Debug the sessions by utilizing the logs of the sessions.
• Perform unit testing at various levels of the ETL.
• 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,ODI

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.
• 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.
• 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, 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, Financial), Oracle BI Publisher, Oracle RDBMS 10g, Oracle Application Express 3.1, Oracle Business Intelligence Enterprise Edition 10.1.3.3

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 LDAP 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