SUMMARY

• Over 14 years of experience in Software Development and Expertise in OBIEE 12c,11g,10g and Siebel Analytics 7.5/7.7/7.8.4 , Informatica 9.5/8.x/7.1.4.
• Extensive experience in BI Administration Tool, BI Analysis, Dashboards, BI Publisher, Delivers and iBots with OBIEE Applications.
• Experience in installation and configuration of OBIEE, DAC and administering permissions, privileges to users based on their groups and responsibilities
• Building of RPD application design for Physical, Logical (BMM), and Presentation layers, configuration of those layers, development of Reports, Dashboards, BI Publisher, and integration to Microsoft suite of tools, testing, and deployment
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Experience configuring Interactive Dashboards with drill - down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experience in creating requests, adding filters, creating prompts, and creating pivot tables using OBIEE.
• Experienced in DAC to configure, monitor and schedule ETL routines.
• Expertise in ETL methodology for supporting data extraction, loading and transformation processing using Informatica Power Center.
• Experience in developing various Informatica Transformations and Mappings.
• Experienced in tuning Informatica Mappings, Sessions and SQL queries for better performance.
• Data modeling experience using Dimensional Data modeling, Star Schema, Fact and Dimension tables, Physical and logical data modeling.
• Extensive experience in working with various Enterprise Data warehouses, Data Marts.
• Expertise in debugging and optimizing the Oracle BI / Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies.
• Good Knowledge of database experience using Oracle, MS SQL Server, TOAD, PL/SQL, SQL and SQL*Loader.
• Excellent team player with strong analytical, communication and presentation skills.

TECHNICAL SKILLS

BI Tools: Siebel Analytics 7.8.2/7.7.1/7.5.2 , OBIEE 12c/11g/10g,Crystal Reports 2011

ETL Tools: Informatica Power Center 8.2/7.1/5.1

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

Data Modeling: MS Visio, Erwin.

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

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

SQL Tools: Toad, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, OH

Lead OBIEE Consultant

Responsibilities:

• Involved in entire software lifecycle including requirement analysis, solution design, effort estimation, schema design, RPD / Catalog design, performance tuning and associated development.
• Installed OBIEE 12.2.1.2.0 on four environments.
• Upgraded OBIEE 11g rpd and reports to 12c using bi-migration-tool.
• Configured both OBIEE 11g and 12c to authenticate with MSAD.
• Applied the patches to the OBIEE 11.1.1.9.0.
• Identification of key metrics for different product management teams.
• Implemented Data Level Security for the PII data by masking the data.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
• Built the Reusable columns in the Analysis for saving the custom formulae.
• Developed many Ad-hoc and standard reports / dashboards with different Analytics views.
• Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create Subject Areas), test and validate the model.
• Developed different Parent Child and Level Based Hierarchies.
• Created Level Based Measures in rpd for Reporting purposes.
• Handled the snapshot tables by using the Aggregation Based on Dimensions in the rpd for the Measures.
• Created reports based on Star and Snowflake schemas.
• Design and developed executive dashboards for management.
• Worked with setting up different Session and Repository (Static and Dynamic) variables using various Initialization blocks.
• Created OBIEE roles based on Active Directory groups and created policies.
• Managed security privileges for each subject area and dashboards at object level and data level security according to user requirements.
• Configured the usage tracking.
• Migrated Reports and Dashboards between different environments by using Catalog Manager.
• Involving in Unit Testing, Validating Reports and production support.
• Delivered the reports and rpd changes in 3 weeks sprints using Agile Methodology.
• Hosted multiple detailed training sessions for end users with documented material.

Environment: OBIEE 12.2.1.2.0/11.1.1.9.0 , Windows Server 2008, SQL Server 2008, SSMS

Confidential, OH

Lead BI Consultant

Responsibilities:

• Involved in entire software lifecycle including requirement analysis, solution design, effort estimation, schema design, RPD / Catalog design, performance tuning and associated development.
• Customize OBIEE to suit business requirements.
• Provide thought leadership in Business Intelligence domain for Confidential 's digital payments group.
• Identification of key metrics for different product management teams.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Design and develop executive dashboards for critical business groups like Risk Management, ACH, Account Opening, Funds Transfer, POP Money (mobile payments) and Wire Transfers.
• Developed many Ad-hoc and standard reports / dashboards with different Analytics views (Drill-Down / Dynamic, Cascading style sheets, Pivot table, chart, column selector.
• Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create Subject Areas), test and validate the model.
• Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Created reports based on Star and Snowflake schemas.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
• Worked with setting up different Session and Repository (Static and Dynamic) variables using various Initialization blocks.
• Managed security privileges for each subject area and dashboards at object level and data level security according to user requirements.
• Configured the usage tracking.
• Migrated Catalog’s and RPD’s from different environments by using Catalog Manager.
• Involving in Unit Testing, Validating Reports and production support.
• Responsible for coordinating offshore development.
• Hosted multiple detailed training sessions for end users with documented material.

Environment: OBIEE 11.1.1.7.1 , Windows Server 2008, Informatica Power Center 9.5.1, Oracle 11g,TOAD

Confidential, TX

Lead OBIA Consultant

Responsibilities:

• Worked during the whole life cycle of the project from requirements gathering to deployment.
• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Implemented dynamic dashboard and used conditional navigation to display the reports based on user selection.
• Configured weblogic console to authenticate OBIEE with MS Active Directory.
• Implemented Multiuser Development Environment (MUDE) Using Oracle BI Administration Tool.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns.
• Worked on the different layers in the data model (Physical, Business and Presentation).
• Pulled new physical tables to physical layer of RPD, joined them with dimensional tables, developed hierarchy and presented them to presentation layer.
• Designed and developed variousInteractive Dashboardsand reports with navigation, filters, and prompts.
• Created different reports by using Table, Pivot Table, Chart, Narrative Views etc.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
• Worked with setting up different Session and Repository (Static and Dynamic) variables using various Initialization blocks.
• Designed Reports in theDashboardsfor Financial Analytics and developed custom reports according to the client needs.
• Configured mappings & work flows in DAC.
• Analyzed the requirements and developed the technical documents. Identified the stars (Dimensions/Facts) that need to be populated and created new workflows and mappings in Informatica based on the requirements.
• Involving in Unit Testing, Validating Reports and production support.

Environment: OBIEE 11.1.1.7.1 , Linux, Informatica Power Center 9.5.1, Oracle E business Suite 12.1, TOAD

Confidential, NY

Lead BI Consultant

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements and Data Analysis.
• Configured the data sources in weblogic and scheduler connection settings of the database in em for the database connection issues after moving OBIEE repository database schemas to another database.
• Upgraded the OBIEE 10g repository and catalog to 11g.
• Modeling activities which included building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns.
• Created the new RPD and detail level drill downs to as per business requirements using OBEE Analysis.
• Created new logical columns by using the Time series functions as per specifications.
• Created different reports by using Table, Pivot Table, Chart, Narrative Views etc.
• Built Time-Series calculations using AGO and TODATE functions on BMM (Business mapping and modeling) layer of repository.
• Configured Scheduler, Delivers and Cache Seeding by using IBots.
• Installed and configured BI Publisher and Integrated with OBIEE server.
• Integrated MS Word, BI Publisher and OBIEE to publish the reports in different formats.
• Created RTF templates in MS Word by connecting to BI Publisher, and publish these templates for the reports to view data in BI Publisher.
• Migrated Catalog’s and RPD’s from different environments by using Catalog Manager.
• Involving in Unit Testing, Validating Reports and production support.

Environment: OBIEE 11.1.1.7.0/10.1.3.4.1 , Oracle 11g, Sybase PowerBuilder, BI Publisher, TOAD

Confidential, CA

Sr. Oracle BI Apps Consultant

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.
• Configured the OOTB (Out of the box) rpd so as to accommodate the business requirements
• Created/Modified Metadata repository by using Administration Tool: Physical, Business Model and Mapping and Presentation Layers.
• Developed the necessary star schemas in the BMM layer and modified them in order to accommodate the new business requirements
• Extracted the data from JD Edwards Enterprise One ERP system.
• Extensively used Guided Navigation in dashboards.
• Created different Hierarchies, Levels and implemented Business Logic by creating level based measures.
• Creating Users and Groups and managing the object level and data level security.
• Extensively used ETL to load data from multiple sources to Staging area using Informatica PowerCenter 8.6.
• Configured new customized mappings & work flows in DAC for new customized subject area.
• Worked closely with Users, Modelers and Administrators to resolve ongoing production Problems by reviewing design changes made to production systems.
• Performed Unit, Integration Testing to Validate the Reports.

Environment: OBIEE 10.1.3.4, Oracle 10g, JD Edwards Enterprise One, Oracle Financial Analytics 7.9.6, Informatica 8.6, SQL Developer, Windows XP

Confidential, FL

Sr. Oracle BI Apps Consultant

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Identified Facts, Dimensions, and Hierarchies of the business model.
• Extracted data from ERP Systems Oracle E business Suite (Oracle R12 Financials).
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.
• Extensively used ETL to load data from multiple sources to Staging area (Oracle) using Informatica PowerCenter 8.6.
• Before configuring full load Financial Analytics, configuredInitialExtractDate, Global Currencies ExchangeRateTypes, FiscalCalendars, and General Ledger Account.
• Configured DAC to run nightly data loads on daily basis.

Environment: OBIEE 10.1.3.4, Oracle 10g, Oracle E business Suite, Informatica 8.6, SQL Developer, Windows XP, Erwin, LINUX

Confidential, GA

Sr. Oracle BI Consultant

Responsibilities:

• Installed and configured complete suite of OBIEE 10.1.3.4 in test and development environment on windows platform.
• Worked on the different layers in the data model (Physical, Business and Presentation).
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE answers.
• Created session variables for users to provide row- level (data level) security and used the session variable in OBIEE answers to build the query.

Environment: OBIEE 10.1.3.4, Informatica 8.1, Oracle 10g, SQL Developer, Windows, Linux.

Confidential, NY

Sr. Oracle BI Apps Consultant

Responsibilities:

• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of the Repository by using Star Schemas.
• Created Dimension Hierarchies and Level-Based Measures for Business requirements.
• Designed & customized Answer Views & charts, Create & save Filters, Create Charts & Tables in Answers.
• Involved in creating Complex mappings using lookup, filter, Joiner, aggregate, Sequence generator and expression transformations using Informatica Power Center

Environment: OBIEE 10.1.3.3, Oracle Financial Analytics 7.8.2, Informatica 7.1, oracle 10g

Confidential, IL

Sr.OBIEE Consultant

Responsibilities:

• Involved in requirements gathering, designing functional and technical specifications for reporting needs.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Managed security privileges for each subject area and dashboards according to user requirements.

Environment: OBIEE 10.1.3.3, SQL Server 2005, TOAD, Informatica 7.1

Confidential, Dallas, TX

Siebel Analytics Developer

Responsibilities:

• Extensively used Siebel Analytics Administration Tool for customizing and modifying the physical, business and presentation layers of metadata repository.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created Dashboard prompts and criteria prompts for better understanding of the trends and projections.

Environment: Siebel Analytics 7.5.2, Siebel Call Center (CRM), Informatica 7.1, Oracle 8i, TOAD

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.
• 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.

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