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.
• 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 Confidential 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 PROFICIENCIES:

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/ Lead Consultant

Responsibilities:

• 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 Confidential 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. Confidential (Oracle Business Intelligence Applications)
• Installed and configured whole BI apps (OBIEE, ODI and Weblogic) in Linux environment.
• Defining Business intelligence applications instances using BIACM in Confidential 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.

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

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, Confidential 7.9.6.4, Informatica 8.1.1, Oracle BI Publisher, Oracle 10g, SQL, Windows XP.

Confidential

SQL Developer

Responsibilities:

• Extraction, Transformation and Loading of the data using Informatica.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data from DB2 & XML files into Db2 tables.
• Developed various transformations like Source Qualifier, Sorter transformation, Joiner transformation, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created multiple mapplets.
• Created Workflows, Tasks, database connections using Workflow Manager
• Developed complex Informatica mappings and tuned them for better performance
• Created sessions and batches to move data at specific intervals & on demand using Server Manager
• Responsibilities include creating the sessions and scheduling the sessions
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance Understanding the Functional Requirements.
• Responsible for identifying the missed records in different stages from source to target and resolving the issue
• Extensively worked in the performance tuning for mappings and ETL procedures both at mapping and session level.
• Developing, Testing and debugging the mappings in Informatica.
• Created dimensions model star schemas using Kimball methodology.
• Arrived at the dimension model of the OLAP data marts in Erwin.
• Preparing the documents for test data loading.

Environment: Informatica 7.1.2, Oracle 10g, SQL, Toad, windows XP