Professional Summary

• Eight plus years of effective IT experience across Data warehouse development providing business intelligence solutions using OBIEE Siebel Analytics reporting tools.
• Experience with Data Integration and Analysis for Decision Support Systems in Banking, Pharmaceutical, Retail, Health Care, Federal industry domains.
• Effective experience in Complete Software development life cycle Iterative, Waterfall methodology, Agile, RUP which includes Business Requirements Gathering, System Analysis Design, Data Modeling, Development, Testing and Implementation.
• Solid understanding of Oracle Business Intelligence Enterprise Edition OBIEE 11g/10g , its architecture, both server and client components i.e. BI Answers, BI Dashboards, BI Deliver, BI Server and BI Publisher
• Extensive experience on OBIEE/Siebel Analytics features i.e. Clustering, Security, cache, usage tracking, dimensional hierarchy, aggregate navigation, MUD, Disconnected, Integration Variables/Initialization Blocks configuration etc.
• Extensive experience in building business models of OBI rpd and configuring Metadata using admin tool, Time series measures, direct data base requests by including global local Filters in Answers, Delivers, developing Dynamic Interactive Dashboards with drill-down drill-across capabilities, Security Setup and Web Catalog Objects and scheduling IBots using OBI.
• Excellent experience in creating pixel-perfect BI reports using Oracle BI Publisher.
• Configured and installed BI Publisher and integrated with OBIEE server and created Smart View Report Templates.
• Hands-on experience with prebuilt Oracle BI Apps for HR and Marketing modules.
• Highly proficient in Design, Development, Implementation, Administration and Support of ETL processes for large scale Data Warehouses using Informatica 8.x, 7.x.
• Experience in extracting data from Oracle EBS, Siebel CRM, People Soft OLTP and integration and loading data to OLAP systems using Informatica.
• Practical, hands-on experience working with Informatica Data Integration Tools Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution data warehouse load .
• Experience in integration of various data sources with Multiple Relational Databases like Oracle 11g/10g, SQL Server and DB2.
• Expertise in writing, testing and implementation of Stored Procedures, Triggers, Functions, Packages and design of star schema at database level using SQL, PL/SQL.
• Quick learner and excellent team player, ability to meet deadlines and work under pressure.

Technical Skills

Professional Experience

Confidential

BI Consultant

Responsibilities:

• Involved in requirements gathering and worked on Functional and Technical Detail Design based on the Business Requirements.
• Developed Metadata repository, configured metadata in the Business Model Layer Physical Layer and maintaining Web Catalog Objects Dashboard, Pages, Folders, Reports as per the data requirements using OBIEE 11g.
• Worked on Oracle Enterprise manager to activate and Deploy RPD, Security, Capacity Management etc. in OBI 11.1.1.7.0.
• Customized the AR subject area based on the requirements and load the history for the sales invoice numbers.
• Modeling activities that include building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns. Defining logical joins/keys.
• Created Dimensional Hierarchies, Level based Measures and Aggregate navigation etc. in BMM layer.
• Implemented cache management and aggregate table techniques to improve the performance
• Worked on Oracle BI Answers to develop complex and Reports using pivots tables, charts.
• Configured Aging Bucket for AR Aging tables and increased buckets in aging reports.
• Altered the database tables in lower environment.
• Worked on ETL and DAC customization for AR subject area in Financial Analytics.
• Created new subject areas and Execution Plans in DAC in lower environment.
• Involved in Performance Tuning, Debugging, and Optimizing Reports.
• Designed and implemented stored procedures, views and other application database code objects to load the history for AR subject area.
• Fixed the issues in Procurement and Spend analytics Purchase Orders, Purchase Recipts.
• Maintained SQL scripts, indexes and complex queries for analysis and extraction.

Environment: OBIEE 11.1.1.7, Informatica 9.0.1, Oracle EBS, Oracle 11i, SQL, SQL developer, DAC, UNIX.

Confidential

Sr. OBIEE Developer

Responsibilities:

• Involved in requirements gathering and worked on Functional and Technical Detail Design based on the Business Requirements.
• Developed Metadata repository, configured metadata in the Business Model Layer Physical Data Model and maintaining Web Catalog Objects Dashboard, Pages, Folders, Reports as per the data requirements using OBIEE 11g/10g Server Admin and web tools.
• Worked on Oracle Enterprise manager to activate and Deploy RPD, Security, Capacity Management etc. in OBI 11.1.1.5.0.
• Worked on BI Office integration with OBIEE 11.1.1.5
• Integrated OBIEE with EBS for security authentication, authorization and implemented Out Of the Box OTB Financial Analytics to help them provide visibility to detail level General Ledger transactions, Debit and Credit Payments, facilitate transaction analysis across locations, products, territories and business units.
• Customized the Compensation dashboards as per business needs and in the process, fixed various payroll data related issues, Active Head count issues in the ETL mappings.
• Developed and Customized the GL Dashboards to allow users to look up Daily GL balances by specific GL Accounts.
• Modeling activities that include building star schema as per the business requirements and configuration of Logical Layer, Logical tables, dimensions and columns. Defining logical joins/keys.
• Created Dimensional Hierarchies, Level based Measures and Aggregate navigation etc. in BMM layer.
• Worked on Security Realms in Oracle Weblogic Server-Administration Control to configure Users and Groups and Roles and Policies , granting OBIEE access and query privileges using BI Presentation services.
• Implemented cache management and aggregate table techniques to improve the performance
• Worked on Presentation Catalog to set permissions in the Catalog Manager based on Application Roles and maintained Catalog Groups.
• Worked on Oracle BI Answers to develop complex and Reports using pivots tables, charts, Column Selector, and view selector. ETL and DAC customization for Financial Analytics
• Tuning SDE ORA APTransactionFact ExpenseDistribution mapping.
• Tuning SDE ORA APTransactionFact Payment mapping.
• Tuning SDE ORA ARTransactionFact Adjustments mapping.
• Tuning SDE ORA Stage ARTransactionFact ARSchedules mapping.
• Configured Aging Bucket for AP/AR Aging Tables
• Involved in Performance Tuning, Debugging, and Optimizing Reports.
• Migrated OBIEE repository and Web Cat between environments

Environment: OBIEE 11.1.1.5, Informatica 8.6, Oracle EBS, Oracle 11i, SQL, SQL developer, Autosys, UNIX.

Confidential

OBIA Consultant

Responsibilities:

• Understanding the Business requirements and developing technical needs by comparing the requirements with the existing out of box setup
• Extracted and customized the pre-built BI solutions of tables using Oracle BI Apps 7.9.6.4 HR Analytics
• Worked in OBIEE Repository .rpd which involves Schema Import, Implementing the business logic by customization, Dimensional Hierarchies, and Aggregate Navigation, Level Based Measures, Variables, and Initialization blocks.
• Configured Physical Layer Import tables, Create Tables and its aliases, add/change physical joins/keys from databases Oracle 11g.
• Configured Logical Layer Create Logical tables/dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns.
• Configured Presentation Layer Created Folders/sub-folders for different User Groups to satisfy Ad-Hoc reporting requirements
• Modified the existing OOTB reports and the dashboards according to the business requirements.
• Worked in customizing of New Hire, Turnover, Compensation and Human Capital Metrics/Headcount and Workforce data coming from PeopleSoft.
• Migrated RPD and Webcat from lower environments to higher environments.
• Worked in Informatica on analysis and customization of SDE, SIL and PLP Informatica objects and created customized folders as per the business requirements.
• Proficient in customizing tasks and Scheduling both Incremental and Full Loads in DAC.
• Supported infrastructure teams in the maintaining OBIEE servers and to ensure high availability of Business users.
• Responsible for OBIEE on call rotation and 24 7 available

Environment: People Soft 9.1, Oracle Business Intelligence 11.1.1.7, Informatica 9.0.1, Oracle BI Apps 7.9.6.4, DAC 10.1.3.4.1, Oracle 11.1.0.7.0.

Confidential

OBIEE Administrator

Responsibilities:

• Studied Micrsotrategy Desktop and Web reports, objects Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups and Generic cubes in the Desktop.
• Involved in requirement gathering from the client through meetings, understanding the business from end user and technical perspective.
• Installed OBIEE 11.1.1.7.0 on Windows Server 2008 R2.
• Experience with Weblogic server and Enterprise manager in OBIEE 11g.
• Used the OBIEE Admin Tool to develop the three layers in the Repository.
• Worked on converting snowflake schema to star schema in the Physical Layer.
• Created connection pools, physical tables and defined Primary key and foreign key joins in the physical layer of the repository.
• Created and modified logical tables, logical columns and defined Foreign-keys and complex joins.
• Created dimension hierarchies, levels, level based measures and defined level, attributes level keys.
• Used the expression builder utility to create new logical columns in the BMM layer and created various calculation measures.
• Customized/created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked extensively on OBIEE Analysis to create the reports as per the client requirements.
• Defined additional views compound, table, chart views of the data returned by the request to visualize data in many different ways.
• Maintained effectiveness in creating the Dashboards by appropriately including guided navigational links and drilldowns.
• Created on Presentation variables for navigation reports and for different views.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to the user requirements
• Worked on OBIEE security like configuring LDAP authentication, creating users and groups and application roles.
• Worked on deploying the RPD's in Enterprise Manager and restarting the services.
• Created custom CSS classes and styles, java scripts Iframe and HTML scripts to enhance the dashboard functionality and produce reports that meet user requirements.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards and Analysis.

Environment: Oracle Business Intelligence 11.1.1.7, SQL Server Management Studio 2008 R2, Micro Strategy 9.0, Windows 2008

Confidential

OBIA Consultant

Responsibilities:

• Co-coordinating with Business on requirement gathering and analyzing the Business requirements and providing best feasible solution.
• Extensively used Oracle BI Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Modeled the Logical Layer based on the Business requirements in the BMM Layer and developed the necessary Star Schemas.
• Performed the detailed design of Reports / Dashboards, Analytical Data Model rpd and performed Fit/Gap Analysis between existing reports and new requirements.
• Created Presentation catalogs and Folders in Presentation Layer and Performed Global Consistency Check in Oracle BI Administration Tool.
• Defined the Primary, Foreign keys and created Simple and Complex joins between various Dimension and Fact Tables.
• Administered NQSCONFIG.INI and Instanceconfig.xml configuration files.
• Designing Logical and Physical Database design and Star Schema design, Fact tables.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Created various Static and Dynamic variables for different report and Security requirements.
• Customization of Marketing Analytics repository.
• Creating new measures as well as modifying the existing measures at RPD levels.
• Extensively worked on Answers, Dashboards and Security for users.
• Worked on security for users Authentication External table authentication and Database
• Data analysis and ad-hoc report generation on accessing data from multiple platforms
• Migrated Analytics RPD and Webcat from lower environment to higher environments.
• Developing Informatica Workflow mappings for NRA Reporting.
• Create new/modified existing SDE's and SIL's Mappings as per the requirements. Created Custom mappings to update Facts and Dimensions and worked on performance tuning of various transformations.
• Creating/modifying DAC execution plans.
• Providing continuous enhancements and fixing of production issues.
• Monitoring daily Incremental Load in Production and fix any issues during the Load.
• Documenting High level and Low level designs for development and enhancement changes.
• Application Testing - unit and regression.

Environment: Siebel Analytics 7.7.1, Oracle Business Intelligence 10.1.3.3, Informatica 7.1.4, Oracle BI Apps 7.9.4, DAC 7.9.5, AutoSys 4.5.0, Oracle 10.2.0.1.0, TOAD, 2003

Confidential

Sr. OBIEE Developer

Responsibilities:

• Analyzed the functional specifications that are in existing BO universe and BO reports.
• Worked with multiple business groups in the process of requirements gathering.
• Coordinated with both SAP BO team to understand the functionality.
• Exposed and worked on Agile Processing, which have six sprints in parallel.
• Involved in multiple scrum meetings to reach the deadlines.
• Analyzed the functional specification provided by the data architect and created technical specification for the mapping.
• Created Report Mappings for each BO report that needs to be replicated in OBIEE.
• Worked on repository Physical, BMM Presentation Layer
• Created hierarchies, aggregate columns, new logical table sources as per the business requirements.
• Calculated all the metrics that are needed for OBIEE reports according to BO reports.
• Organized the presentation layer for Ad-hoc reporting.
• Involved in Merge and Migrating RPD that include Repository and Catalog files from lower to higher environments.
• Involved in Setting up Multi User Development MUD Environment.
• Debugged and optimized the OBIEE Dashboards / Reports
• Created User Guide for Business Users and provided intensive training.
• Performed Unit Testing, Integration Testing, and User Acceptance Testing.

Environment: OBIEE 10.1.3.4.1, SAP Business Objects XI 3.1, Data Stage 8.0.1, SQL Explorer 3.0, DB2 9.1.4, Oracle 11g, UC4 version 8.0, Windows XP, AIX.

Confidential

OBIEE Developer / BI Publisher

Responsibilities:

• Involved in Installation, configuration and administration of OBIEE server and worked on Physical, BMM Presentation Layer
• Worked with functional and technical project leads, other business groups to identify, analyze, and document Business requirements.
• Imported the Physical tables, keys and physical joins from the databases using ODBC.
• Configured Analytics Metadata objects and Web Catalog Objects
• Performed end-user training to develop ad-hoc reports using BI Answers.
• Extensively worked on BI Publisher, created data models using OBI answers reports/generic sql, used them to create picture perfect report to be provided for the high level executives.
• Configured and Scheduled BI Publisher scheduler for report bursting to FTP/email destination type.
• Experience in creating the reports using the different views such as Pivot, Tabular, Narrative etc as well as creating dashboards for the same using prompts, guided navigation as per the project needs

Environment: OBIEE 10.1.3.4, BI Publisher, SQL Server 2005, IBM InfoSphere DataStage 8.0, Microsoft SQL Server Management Studio Express 9.0, Oracle SQL Developer 1.5.4, Windows NT Server/XP, UNIX.

Confidential

OBIEE Developer

Responsibilities:

• Interacting with middleware team for data processing requirements and data validation.
• Requirements gathering for the data cleansing rules.
• Data analysis for manual merges of accounts and history records.
• Building OBIEE repository Physical layer, BMM layer and the presentation layer.
• Designed and development of various reports with Drilldown, Pivot, Bar charts, Pie charts in Answers
• High Level and Low Level design documentation.
• Building and execution of functional and technical test scripts.
• Defect tracking and fixing of defects
• Involved in user training in application.

Environment: OBIEE 10.1.3.3.3, Oracle BI Applications 7.9.6/7.9.5, Informatica 8.6.1, DAC, Oracle 10.2.0.1, Oracle EBS, Oracle SQL Developer 1.5, Windows-XP