SUMMARY

• Around 9+ years of IT experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse/ Data Marts and Business Intelligence. Involved in all the stages of SDLC and provided solutions to various clients.
• Extensively worked on OBIEE 11g/10g and BI Publisher 11g/10g.
• Strong Knowledge on OBIEE 12C.
• Experienced in customizing Business Intelligence Dashboards/Score cards with drill - down capabilities using global and local Filters Analytics Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboards, Pages, Folders and Reports).
• Experienced on integrating BI Analytics with EBS.
• Extensively worked on section conditions in Dashboards.
• Extensively worked on OBIEE report performance tuning.
• Extensive Experience in developing BI Publisher Reports in 10G/11G
• Expertise in Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server and Oracle BI Publisher.
• Implemented Best Practices in BI Publisher/XML Publisher.
• Provided Production support extensively.
• Expertise in writing complex queries and packages.
• Expertise in Implementing Object level as well as Data level Security.
• Expertise in creating, modifying and administering OBIEE/Siebel Analytics Intelligence Dashboards using OBIEE/Siebel Answers, creating iBots using OBIEE/Siebel Delivers.
• Expertise in configuring Interactive Dashboards with drill-down capabilities using global and local Filters. Expertise in Implementing Object level as well as Data level Security.
• Expertise in Performance tuning of OBIEE/Siebel Analytics by implementing Cache management and Aggregate Navigation techniques. Implementing Database tuning as well.
• Experience Integrating OBIEE with OBI Publisher and Hyperion Smart view through Provider Services.
• Expertise in debugging and optimizing the OBIEE/Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
• Experience in troubleshooting Complex SQL queries and improved data delivery performance
• Upgrades, performance tuning and optimization on Linux and Windows environment.
• Extensively worked on installations and configurations of OBIA 11.1.1.7/ 11.1.1.9.2 on Exalytics and Linux VM Machines.
• Experienced in installing OBIEE 12c on Exalytics Server.
• Extensive Experience in Moving Middleware folders from one server to another and created a new environment without doing new installations (Changing the Hostnames).
• Experienced in Installing times ten in Exalytics.
• Experienced in upgrades and patching on OBIA 11.1.1.X in Linux and Windows machines.
• Experienced Migrating objects (Catalog/Repository) from one environment to other.
• Experienced in merging the repositories.
• Expertise in integrating OBIEE with Webcenter Portal.
• Expertise in Integrating OBIEE with EBS/PeopleSoft Portal.
• Experienced in creating and Configuring Google Maps with Dashboards.
• Experience in configuring LDAP/OAM/Database authentication.
• Expertise in the complete Administration of OBIEE in LINUX/WINDOWS.
• Expertise in migrating security from DEV to TST to PRD.
• Expertise in installing and configuring J2EE agent.
• Expertise in installing ODI 11g and ODI 12c.
• Expertise in migrating ODI objects from one environment to other using smart export and smart import.

TECHNICAL SKILLS

OLAP/BI Tools: OBIEE 12C/11g, BI Publisher 11.1.1.9, Essbase 9.x/7.x/6.x

ETL Tools: ODI 11g/12C, Informatica Power Center 9.1.

Tools: Toad 4.0.3, Erwin, SQL Developer.

Methodologies: Ralph Kimball’s Star Schema and Snowflake Schema.

RDBMS: Oracle 12c, 11g/10g, MS-SQL Server 2005/2000/7.0/6.5.

Languages: PL/SQL, SQL, Java 1.2, HTML, XML.

O/S: Linux, Windows server 2003/2000, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

OBIEE/OBIA Lead Consultant

Responsibilities:

• Designed Metadata repository(rpd) - Physical layer, Business Model & Mapping layer and Presentation Layer.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns.
• Created Aliases and defined Role-Playing Dimensions.
• Configured People Soft Security with BI using Database Authentication.
• Created Custom Groups and Application Roles as per business requirements.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Created multiple UNION reports.
• Extensively used Session/Repository/Request/Presentation variables as per requirement.
• Used Oracle Data Integrator for performing ETL, Data Integration, Data Cleansing efforts.
• As per the business requirement created source to target mappings using filters, joins and different SQL expressions.
• Created custom roles as per business requirement.
• Integrated Google Maps with Dashboards.
• Implemented Out of box OBIA 11.1.1.9.2 on People Soft Financial and HR Analytics .
• Developed different Dashboards/Reports with different views (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Analytics.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer in OBIEE 11g.
• Worked on setting up content levels and created level based measures.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
• Assigned Object level and Data level Security.
• Developed Repository from scratch based on Business requirement.
• Installed and configured whole BI apps (OBIEE, ODI and Weblogic) in Linux environment.
• Defining Business intelligence applications instances using BIACM in OBIA 11.1.1.9.2.
• Configuring Source/Target systems.
• Enabling the BI Applications offerings in BIACM.
• Creating load plans using Manage Load plans.
• Configuring Data load parameters/Reporting parameters in BIACM.
• Functional Configurations using FSM.
• Implementing the Projects.
• Configuring the offerings.
• Configure source codes with target codes using Managing Implementation Projects in FSM.
• Resetting warehouse to run full load.
• Configuring GL Accounts and Segments using CSV files.
• Migrating Configurations from DEV to TPR to PRD using Export/Import Setup data or from repository tables.
• ODI Installation, Configuration, creating master and Work repository. Setup of Topology, data Stores, projects and Security as ODI administrator
• Implemented ODI interfaces and scenarios for extracting and loading data from a variety of data sources/targets.
• Upgraded the PSFT 9.1 Adaptor to 9.2 Adaptor without redoing all customizations in ODI 11g through backend changes.
• Modified the load plan to improve incremental load timings.
• Worked on Topology Manager Module to manage the data describing the information systems physical and logical architecture.
• Used custom incremental logic with MViews to run all mappings in Incremental load.
• Responsible for Metadata Administration, managed Data models and reverse engineering
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data and integrating it.
• Extensively worked on Load Plan and Scenarios.
• Customized Knowledge Modules (KM) to meet specific interface requirements.
• Created Custom Packages and Procedures as per business requirement.
• Extensively worked with variables to customize the flow of the package.
• Created custom packages to run Scenarios in Asynchronous to improve the performance for long running Scenarios/Interfaces.
• Customized the load plan as per business requirement.
• Created many custom Interfaces to populate custom Facts and Dimension using out of box Knowledge Modules.
• Worked on running scenarios/Packages outside in a Full/Incremental loads.
• Customized the KM’s as per DBA’s suggestions to improve the performance.
• Worked on running specific fact group in Incremental/Full Load.
• Experience on running the load plans using DB Link.
• Having knowledge on ODI REPO tables to enable or disable the variable values in database.
• Experienced in migrating objects from one environment to other using Smart Export/Import. (DEV to TPR to PRD)
• Purging the sessions log with custom procedure in Load plan.
• Running multiple scenarios in parallel to improve the performance using ORA HASH.
• Running load plan through command prompt/SH script.
• Configured J2EE agent.
• Passing HINT values or Alter Sessions or Variable values to Load plan/Individual Scenarios.
• Customized the EXEC TBL MAIN as per business need.

Environment: OBIEE 11.1.1.9/12 C, ODI 11g, People Soft 9.1/9.2, BI Apps 11.1.1.9.2/7.1 , BI Publisher 11.1.1.7.0 , Oracle 11g/10g, TOAD, SQL, LINUX, Windows 2008 Server.

Confidential, Baltimore, MD

Sr OBIEE Developer

Responsibilities:

• Worked extensively on the K12 Educational Data warehouse to retrieve all the facts and conformed dimensions to the OBIEE Repository.
• Interacted with Business Analysts and Users in gathering and analyzing and designing the Business Reports Requirements
• Developed different Dashboards/Reports with different views (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Analytics.
• Extensively worked on RTTT (Race To The Top) projects.
• Designed Metadata repository - Physical layer, Business Model & Mapping layer and Presentation Layer in OBIEE 11g.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
• Having experience on configuring Google maps with Dashboards.
• Assigned Object level and Data level Security.
• Having experience on Configuring Webcenter portal with OBIEE.
• Configured OBIEE dashboards as Webcenter Spaces in OBIEE 11g.
• Developed Repository from scratch based on Business requirement.
• Upgraded from 11.1.1.5 to 11.1.1.7
• Created Repository Groups and Web Groups and assigned users to configure security in OBIEE 11g.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Worked on moving objects from DEV to TEST to PROD.
• Scheduled reports to be e-mailed using BI Publisher Scheduler. Worked on Dashboard and Page level prompts and Report filters
• Used Table and pivot table to display hierarchical columns
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Developed Master Detail Report in OBIEE
• Generated Report Name at Runtime in BI Publisher Bursting.
• Created Hyperlinks to other reports.
• Created excel templates using BI Publisher.
• Worked Extensively on developing Excel Templates

Environment: OBIEE 11.1.1.7.0 , BI Publisher 11.1.1.7.0 , Oracle 11g/10g, Informatica Power Center 8.6.1, TOAD, SQL, Windows 2008 Server and Linux.

Confidential, Boston, MA

OBIEE/BI Publisher Developer

Responsibilities:

• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Scheduled reports to be e-mailed using BI Publisher Scheduler.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE Answers.
• Created Time- Series calculations using AGO and TODATE functions on BMM 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.
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Developed Master Detail Report in OBIEE.
• Implemented custom functionality in BI Publisher to prevent blank pages getting printed in reports.
• Worked Extensively on developing E-text Templates
• Created Multi Sheet Excel templates using XLSPE engine
• Migrated Web catalog and RPD from one environment to other environment.
• Developed Sql queries and PL/ sql packages from scratch to use as BI Publisher Event Trigger.
• Upgraded Standard 6i reports to BI publisher reports.
• Created Complex Matrix reports in BI Publisher.
• Created Reports from scratch in 11.1.1.5
• Created Packages and Procedures/Functions using Cursors, Global Temporary Tables, Record Types, and Table Types as per the requirement of the data model.
• Involved in Setting up of users/roles in Oracle OBIEE/BI Publisher.
• Converted all the existing Actuate reports into BI publisher Reports.
• Converted Main Frames Reports to BI Publisher Reports.
• Customized various BI Publisher 11G Reports using RTF templates and defined their respective Templates and Data Definitions.
• Used Table and pivot table to display hierarchical columns.
• Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, and Filters) and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.
• Worked extensively on Oracle BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats (PDF, CSV, HTML, EXCEL and XML DATA).

Environment: OBIEE 11.1.1.5.0 , BI Publisher 11g, ODI (Oracle Data Integrator), Toad, Linux/Windows.

Confidential, Richardson, TX

OBIA Developer

Responsibilities:

• Collaborated with Business contacts & Business Analysts in the analysis and preparation of OBI data requirements.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Creating dimensions, aggregations and keys using admin tool. Customizing Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
• Content settings, Complex joins fragmentation content and defining of Most Economical Source as per business requirement.
• Creation of presentation layer tables by dragging appropriate BMM layer logical columns.
• Developed Global prompts, Filters, Customized Reports and Dashboards using OBI presentation services.
• Creating Users and Groups and managing the object level and data level security.
• Managing the intelligent dashboards by using dashboard, page and report level security.
• Creation of views like Pivot table, Column Selector, Compound layout.
• Identified the granularity level of the data required to be available for analysis.
• Involved in fine-tuning the reports by working extensively on the Caching Strategy.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Configured measures in the Business Model Layer and mapped to multiple logical source tables.
• Extensively used Oracle Delivers and iBots so as to provide alerts.
• Worked on OBI presentation Answers to build Interactive Dashboards with drill-down capabilities.
• Created RTF templates in MS Word by connecting to BI Publisher and publish these templates for the reports to view data in BI Publisher.

Environment: Oracle Applications, OBIEE 11g, OBIA 7.9.6.4, Informatica 8.1.1, Oracle BI Publisher, Oracle 10g, SQL, Windows XP.