PROFESSIONAL SUMMARY

• Around 8 years of extensive experience in Data warehousing and Data Analysis, design, development and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL and Reporting on Windows and UNIX platforms.
• Strong experience in OBIEE 11.1.1.6/10.1.3.x, which includes design and development of OBIEE repositories at three levels Physical Layer, Business Model and Presentation Layer .
• Involved in Data Modeling techniques like normalization, denormalization, Star Schema/Snowflake modeling, Fact and Dimensions tables, Physical and logical data modeling.
• Experience in Oracle BI Apps that include OBIEE, ETL Tools and in Banking, Financial and Insurance domains. Proficient in the Design and customization of BI Answers/ Analysis, Reports, Dashboards, Oracle delivers
• Expertise in configuring Interactive Dashboards with drill-down capabilities and drill-across capabilities using Dashboard Prompts, Contextual Navigation, Guided Analytics, Business Rules with User Identity Roles, Profiles Personalization.
• Expertise in creating metadata repositories .rpd using Administration tool.
• Expertise in creating iBots in Delivers to send alerts to the recipients on occurrence of a business event or at the time specified Expertise in debugging, optimizing the Performance Tuning of Oracle BI Repository Dashboards / Reports and Informatica / Mappings / Workflows.
• Experience in setting up a Multi-User Development Environment MUDE .
• Experience in complete Software Development Life Cycle SDLC including Requirement, Analysis, estimations, Design, Construction, Unit and System Testing and implementation.
• Used Type 1 SCD and Type 2 SCD mappings to update Slowly Changing Dimensions for accessing the full history of accounts and transaction information.
• Experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions, packages.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema.
• Experience in integration of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, CSV files, COBOL files, XML, DTD, XSD files, legacy system files etc.
• Experience in configuring Security Settings groups, roles, access/query/report privileges and scheduling Agents for OBIEE 10g and OBIEE 11g.
• Extensive work in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading
• Involved in fixing bugs in production environment and was a part of the production support team.

TECHNICAL EXPERTISE

Confidential

Role: OBIEE Developer

Project Description:

Confidential is a Confidential financial services organization that is the leading retirement provider for people who work in the academic, research, medical and cultural fields. My responsibilities for this project are Implementing Oracle Pre-built Financial Analytics, HR Analytics, Procurement and Spend and Projects of Oracle Business Intelligence applications.

Responsibilities:

• Analyze and document business process, user requirements, and functional needs and provide innovative solutions
• Translated the Functional Specifications to Technical Reporting Requirements.
• Design and Develop Metadata required for reports.
• Administered the OBIEE web catalog and repository.
• Installation of 11.1.1.7 on the Development and new training windows environments for initial evaluation.
• Configure Windows Native Kerberos Active Directory Authentication.
• Configure SSO with WNA.
• Experience in upgrading from 11.1.1.6.5 to 11.1.1.7.
• Set up Business End Users with appropriate application roles.
• Modified existing analyses, dashboards and creating new analyses.
• Consolidated and redesigned the existing dashboards and analyses.
• Documented the Design Standards used for presentation, repository elements. Presentation Folder Structuring, Measure alignment and format, Attributes alignment and format.
• Designed and Developed Data Load Status and Availability Reports for Operations and Maintenance.
• Created Usage Tracking Reports for monitoring the usage of the reports.
• Build test scripts to thoroughly test the accuracy and completeness of reports
• Understand the business process and the technical solution OBIEE reporting solution implemented to address the business needs.
• Work extensively with the ETL/DB team to improve the performance of long running queries.
• Analyze and determine the impact of technology capabilities and limitations, translate high level design to detailed design specifications, develop, test and deploy code/application in various environments.
• Perform effort estimation for various Data Warehouse activities meet project deliverables as per requirements, on time within budgets.
• Technical development of all OBIEE system objects needed, including developing OBIEE subject areas, measures, attributes, filters, dashboards and analysis.
• Monitored usage and performance of the reporting environment and suggest and help design and implement the steps to improve the performance.
• Responsible for 2nd level technical end-user support, which may include telephone technical support, complex user report creation, promoting end-user created objects to the sharable system level, managing the application server and web server software versioning, and troubleshooting any system failures.

Environment: OBIEE 11.1.1.6.5 Informatica 8.1.6, Oracle SQL Developer, SQL Server 2000, Windows NT.

Confidential

Role: OBIEE Developer

Project Description:

Confidential Services centers on banking and payments technologies. Confidential provides payment processing and banking solutions, software, services and outsourcing of the technology. FIS holds leadership positions in payment processing and banking solutions, providing software, services and outsourcing of the technology that drives financial institutions. My primary role is to set up the financial environment by performing the account mapping and generating OBIEE dashboards and reports.

Responsibilities:

• Worked with End users and oracle support in resolving many product issues.
• Worked with Business Analyst and analyzed the business requirements for developing the repository and extraction of reports.
• Analyzed the specifications provided by the client, understanding the business.
• Involved in RPD Development, Oracle BI Administration, Oracle BI Answers, Scheduling IBOTS and BI Publisher
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Created Views and alias for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports
• Developed Physical Layer, Business Model Mapping and Presentation Layer using Oracle BI Administration Tool.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• 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
• Created various reports to fulfill the marketing needs and customized the views using Oracle BI Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users, which include like Managers, functional heads, Department Heads.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Siebel Analytics Web / Oracle BI Presentation Services.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards answers.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Implemented Multi User Development Environment MUDE for concurrent rpd development
• Involved in System Integration Testing SIT , User Acceptance testing UAT and Production support.

Solution Environment: OBIEE 11.1.1.5, BI Publisher 11.1.1.5, Oracle 11g, SQL, SQL Server 2005, SQL Developer, Windows XP, UNIX

Confidential

Role: OBIEE Consultant

Project Description:

Confidential is a leading packaged foods company headquartered in Confidential, owned by Confidential. Confidential is a key player in the shelf stable and frozen food categories. Pinnacle Foods had existing Hyperion Reports that were recreated in OBIEE based on modified requirements after consulting with Business End Users. The Informatica tool is used to get data to the Confidential for the OBIEE reports and is mainly based on the manufacturing which includes Forecasting , Inventory analysis and Service management along with Sales of the iconic brands by zone, customer and at different levels.

Responsibilities:

• Involved in Analysis, Requirement gathering, function/technical specification, development, deploying and testing.
• Analyzing and understanding different sources and target.
• Involved in daily, weekly loading of data from Flat files and other sources into the EDW by applying business logic on transformation mapping.
• Developing Mappings as per the design document with proper naming conventions for transformations and Mapping.
• Extensively worked on different types of transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Joiner Transformations and SQL Override.
• Created Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Extensively worked on Administration tool to build Physical Model, Business Model and presentation layer and established relationships.
• Created dimension hierarchies to achieve the drill down functionality.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled Slowly Changing dimension data.
• Extensively worked with BI Answers to create various reports such as Drill down, Chart, Pivot, Narrative Reports etc as per the client requirements.
• Created, modified, and administered BI Dashboards with links to web sites, HTML text, and links to documents and embedded content such as images, text, charts, and tables.
• Implemented Prompts to provide dynamic filter condition to End users.
• Used BI Publisher to create checks, sales and marketing letters, Financial Statements etc.,
• Created proactive agents iBots using BI Delivers and interactive dashboards to alert the agents.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.

Environment: OBIEE 11.1.1.5, BI Publisher 11.1.1.5, Informatica PowerCenter 8.6/8.1.1, Oracle 11g, SQL, PL/SQL, TOAD, UNIX Shell Script, UNIX, Windows XP

Confidential

Role: OBIEE/ETL Consultant

Project Description:

Confidential is one of the largest and most respected insurance companies in the Confidential focused exclusively on the needs of Confidential. A banker is a subsidiary of Conseco Inc., a financial services organization headquartered in Confidential. The team implemented an Confidential that collects, organizes and stores data from different systems to provide a single source of integrated and historical data for the purpose of end user reporting, analysis and decision support. Primary objective is to improve the client's services by preventing errors, providing real time data and upgrading records as transactions are completed.

Responsibilities:

• Creation of the design documents and test cases for Informatica mappings.
• Worked closely with executive sponsors and user decision makers to develop the transformation logic to be used in Informatica.
• Created different transformations for loading the data into targets like Source Qualifies, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expression, Aggregator.
• Worked on OBIA - Financial and Supply Chain and Order Management Analytics.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance gains.
• Created multiple aggregated tables and setup aggregated navigation to enhance performance.
• Configured and created OBIEE Repository, Involved in modifications of the physical, the BMM, and the presentation layers of metadata repository using OBIEE Administration Tool.
• Scheduling and Loading data process and monitoring the ETL Process using Autosys.
• Extensivelyused 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.
• Performance Tuning of SQL queries, views etc.
• Scheduled and monitored jobs using UNIX Shell Scripting.
• Used Variables and Parameters in the mappings to pass the values between mappings and sessions.
• Used and developed Shell Scripts used for Pre and Post Session commands for the developed Mappings and scheduling

Environment: OBIEE 10.1.3.4, Informatica 8.1, Oracle 10g, SQL Server 2000,flat files, UNIX shell scripting, Windows XP, OBI Apps FI SCM

Confidential

Role: OBIEE Consultant

Project Description:

Confidential uses Confidential system and Confidential reporting for Supply Chain Implementation in their organization and need to upgrade to Confidential Module. The project involved creation of Datawarehouse from Confidential system using Oracle Data Integrator and build OBIEE reports on top of the Confidential covering the Supply Chain and Order Management Analytics Procurement and Spend Analytics modules

Responsibilities:

• Responsible for full life cycle implementation of OBIEE
• Participated in user meetings to understand the requirements
• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer using Oracle BI administration tool.
• Created Alias Tables, Views and Dimensional Hierarchies.
• Developed Calculated Measures and assigned these Aggregation levels based on Dimension Hierarchies.
• Implemented external table security with session variables, tested and validated the business model and repository level calculations using Oracle BI Administration tool.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and User Security.
• Worked extensively on Answers, Delivers, and Interactive Dashboards for Procurement and Spend Analytics.
• Developed standard and custom SAP BW reports in OBIEE
• Performed Customization of dashboards
• Developed 11 Dashboards / 53 Reports using different Views Table, Pivot Table, Chart and Column Selector , with guided navigation and dashboard and page prompts.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog
• Developed and modified reports in BI Publisher
• Performed unit testing of the reports
• Involved in UAT.

Environment: Oracle 11g, SAP BW, OBIEE 10.1.3.4, Oracle BI Apps Supply chain Analytics , BI Publisher, ODI 10.1.3.5, SQL Developer, UNIX.

Confidential

OBIEE Consultant

Project Description:

Involved in customizing and Migrating reports Both Oracle and Discoverer , building custom reports using Discoverer 10g, Reports 6i/9i/10g, and XML Reports. Developed reports from scratch and accomplished Discoverer admin Task's in secured Instances. And I was responsible for Oracle BI Applications Siebel Analytics Implementation and Extension Project.

Responsibilities:

• Worked as a Discoverer Administrator by handling Move docs to Production, Registering Functions, Creating List of Values, Sharing, Scheduling Workbooks, Maintaining End User Layer, Resolving Connection Issues and Trained developers on move docs.
• Migrated many Discoverer reports and Oracle Custom Reports from 11.0.3 to 11.5.10 in AP, AR, GL and OM modules.
• Worked on creating Oracle Reports9i, XML Reports from scratch and customized lot of standard reports according to the client requirements.
• Creating star schemas, aggregates and general data architecting. Master data management MDM approaches metadata management.
• Migration of Discoverer Business Area to OBIEE Repository.
• Evolving standards and processes for customization of OBIEE RPD and ETL of Informatica of out-of-the-box product.
• Educating Users and Development team on Oracle EBS Functionality to evolve solution integrated with EBS.
• Developing Security model by re-using Oracle EBS functionality for OBIEE and integration of Oracle EBS and OBIEE.
• Design, development and testing of new Informatica ETL adaptors for Oracle EBS to Analytics Data warehouse.
• Installed and Configured OBIEE platform, application, DAC and Informatica Power Centre 7.1.x and 8.1.1.
• Data reconciliation during ETL data load of Financials, Human Resource and Supply Chain data from Oracle Applications.
• Customized pre-defined dashboards as per the requirements given by the client.
• Worked with Oracle Engineering directly to resolve issues and bugs working with Oracle EBS 11i, Oracle BI Applications 7.9.3, Informatica, Oracle DB 10g, etc.
• Played an important role in the team and worked as a good team member.

Environment: Oracle Apps 11i 11.5.10 , GL, AP, FA, PO Oracle 10g, Pl/SQL, SQL Plus, SQL Loader, Forms 9i, Reports 9i, TOAD, Discoverer 10g, Performance Tuning, Windows XP, UNIX, OBIEE 10.1.3.2, Oracle BI applications 7.9.3, Informatica 7.1.4, DAC Data warehouse Administration Console .

Confidential

OBIEE Consultant

Project Description:

Confidential is a not for profit health plan. Their mission is to improve the lives of the people it serves and the health of its communities. The project was to centralize decision making system as part of data management which involved integrating and simplifying by dropping unwanted data elements, introducing new elements and combining data using ETL processes by providing composite and meaningful views to users.

Responsibilities:

• Participated in User Meetings to understand the requirements.
• Worked closely with the data modeler in creating logical data model Star Schema .
• Built the OBIEE repository/metadata Physical Layer, Business Model and Mapping Layer and Presentation Layer and created the subject area where reporting and analysis are centered around.
• Developed calculated measures and dimension hierarchies in the Business Model and Mapping Layer
• Configured web catalog objects Dashboards, Pages, Folders, Reports
• Implemented data level and object level security.
• Worked on OBIEE Answers to build Interactive Dashboards with drill-down capabilities based on organization's and product's hierarchies
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generated Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created users, groups, configured the permissions in the administration tool and verified the Permissions of the users in web catalog.
• Assisted in creation of pivot table requests allowing manager's to analyze the business/data from different perspectives.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Installed and configured Oracle BI Publisher and integrated it with Oracle BI Presentation services.
• Developed and modified reports in BI Publisher.
• Extensively used SQL queries, Procedures, Triggers.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Environment: Oracle 10g, Informatica 8.1.1, OBIEE 10.1.3.2, BI Publisher, Toad, SQL, SQL Loader, PL/SQL Procedures, Windows 2000

Confidential

Role: Informatica/ Oracle Developer

Project Description:

The Confidential project program aims to deliver a Data Warehouse architecture and management reporting solution for all Confidential. The Data warehouse was maintained using PL/SQL procedures. The project involved in converting the PL/SQL procedures to Informatica mappings as the first phase and to reduce the load time and deliver a more stable environment to business users. The later phase was to provide support to Business users and understand the functionality of the new business areas and search for the scope of improving the existing mappings.

Responsibilities:

• Assisted in Design of physical logical models using Erwin Data Modeler
• Interface with Sales and Production Management Team to capture and analyze business strategic requirements.
• Developed many mappings / mapplets using various transformations for extract and loading the sales data.
• Created sessions and batches for executing the mappings. Scheduled the batches through cron job.
• Involved in the performance tuning of mappings.
• Provided support to report developers in developing the reports.
• Wrote Event Triggers, PL/SQL Program Units for Reports for Client Validations
• Wrote Database procedures, Packages, functions to handle data manipulations and Computations on Server.
• Designed and developed Oracle Monthly Reports.
• Created Materialized views to calculate aggregated data, such as a sum of monthly revenue.
• Developed Database Objects - Triggers, Packages, Procedures and functions.
• Modified, Maintained and Developed the SQL,PL/SQL codes to develop new enhancements
• Develop and maintain the documentation to support the team and business
• Responsible for the fixation of the errors in data as part of testing

Environment: Oracle 9i/8i, SQL Server 2000, Informatica Power Center 7.1, UNIX Scripting Ksh , Sun Solaris 7, Windows XP Professional