SUMMARY:

• Over Eight years of experience in full life cycle includes Design Analysis, Application Development, Implementation, Maintenance and Documentation of Data Warehouse, Data mart and Business Intelligence using OBIEE, Informatica and BI Applications.
• Good understanding in various sectors like Banking, Financial, Communication, Pharmaceutical and Automobile with source systems as Oracle EBS Financials, Oracle EBS Order Management, PeopleSoft Financials and PeopleSoft HR.
• Expertise in configuring various analytics for Finance, HR, Procurement and Spend and Project.
• Experience in implementation of Data Warehouse, BI solutions and a strong understanding of Data Warehouse Concepts, ETL, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Experience in Installation and Configuration of BI Applications which includes OBIEE, ODI, Informatica and DAC.
• Experience in configuring BI APPS by using interfaces like BIACM (Business Intelligence Applications Configuration Manager) and FSM (Functional Setup Manager) for ODI 11.1.1.7 and configured BI APPS using DAC for the older versions.
• Expertise in complete life cycle implementation of OBIEE with Star and Snow flake schema.
• Experience with repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Pages, Folders, Reports). Added Metadata changes to the OBIEE Repository.
• Expertise in creating complex reports using BI Analysis like Union Reports, Repository Variables, Presentation Variables Dashboard Prompts and Briefing Books etc.
• Developed reports / dashboards with different analytics views (drill - down, dynamic cascading style sheets, pivot table, charts, narrative view, static text, column selector, global and local filters to provide the functionality of viewing selective data for the end users.
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups against LDAP authentication and external table authentication.
• Implemented Scheduler- Agents, Alerts and report bursting-proactive reporting. Worked on Disconnected Analytics, Usage tracking, event polled cache purge.
• Worked with BI publisher 10g/11g, created and managed highly formatted reports for a different data sources. Building new data models and creating and editing new report layouts within the BI Publisher interface.
• Extensively used ODI (Oracle Data Integrator) Designer to develop the process of extracting, transforming and loading data into data warehouses.
• Experienced in establishing the connections to various source and target systems using ODI topology.
• Proficient in using Informatica PowerCenter Designer, Workflow Manager and Workflow Monitor to create mappings, tasks, sessions and to schedule and control workflows.
• Responsible for monitoring and scheduling the ETL jobs in Informatica and ODI.
• Responsibilities handled include requirement study, functional study, system analysis, programming, testing and implementation support.
• Proficient in preparing the process documents (Functional Specifications Document, Technical Specifications Document, and Test plan) for the knowledge repository.
• Provided intensive to business users and to enable the use of Ad-hoc Reporting.
• EnhancedQuery performance, byanalyzing & modifyingSQL QueryandFilters, for all the reports and dashboard prompts, to minimize the delay in Physical Query Execution.
• Worked on enhancing performance by creating Aggregate tables, Indexes and managing Cache. Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support.
• Self-starter, motivated to learn, takes initiative and has experience working on complex projects and strict deadlines.

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.6,ODI 11.1.1.7

Business Intelligence Platform: OBIEE 11.1.1.7/11.1.1.6/11.1.1.5/11.1.1.3/10.1.3.4, Oracle BI Application 7.9.4/ 7.9.5/7.9.6. x/ 11.1.1.7.1, 11.1.8.1 BI Publisher 11.x

Analytics Packages: HR Analytics, Financial Analytics, Supply Chain and Order Management and Procurement and Spend Analytics, Project Analytics

Databases: Oracle 11g/10g/9i, SQL Server 2005, Essbase Versions 11.1.1.3/ 9.3.1, PeopleSoft 9.1(FSCM, HCM),Oracle EBS 11.1.5.10/R12

Scheduling Tools: Data Warehouse Administration Console (DAC)

PROFESSIONAL EXPERIENCE:

Confidential, DC

OBIA Developer

Responsibilities:

• Worked in FOCUS-NAICS project which involved decommissioning the source system CAPS and migrating to Salesforce. My prime focus was in implementing the NAICS (North American Industry Classification System) changes in the downstream application called Enterprise Business Reporting (EBR) which included ETL and Reporting changes.
• Involved in analyzing the business requirements and functional specifications.
• Involved in setting up the ODI connection with Oracle, MS SQL Server Technologies
• Experienced in Topology set up including physical architecture, logical architecture and context for different environments like DEV, TEST and PROD.
• Created and imported new models for the data sources - MS SQL server, Oracle and did reverse engineering for the data sources and targets.
• Developed new interfaces for loading the data and created new ODI packages, scenarios using interfaces, variables.
• Experienced in migration of ODI packages, scenarios from Development environment to test as well as production environment.
• Used ODI in-built scheduler to schedule the scenarios and load plan’s in new DEV server.
• Involved in Operations and Maintenance activities, troubleshooting the issues and resolving the tickets based on the severity of the issue.
• Modified the existing database objects like tables, views, PL/SQL procedures to adhere to the business requirements.
• Modified several of the existing mappings based on the user requirements and maintained existing mappings, sessions, and workflows.
• Used debugger to identify the bugs in the existing mappings by analyzing the data flow and in evaluating the transformations.
• Thoroughly analyzed the impact of source and target tables and its related components on other applications before decommissioning the existing ETLs.
• Modified metadata repository - Physical and BMM layer as per reporting requirements using OBIEE Admin Tool.
• Analyzed the data and enhanced Logical Star Schema model with consultation from Data Modelers and Business Analysts.
• Modified the existing reports by adding the new NAICS changes into OBIEE reports and developed new reports/dashboards which included guided navigations, drill downs, conditional formatting, graphs, complex compound layouts including multiple view and column selectors, dashboard prompts, etc.
• Involved in setting up agents to run reports at scheduled time for cache seeding in order to improve query performance.
• Involved in implementing LDAP Security with External Table Authorization.
• Worked on tuning SQL queries and functions to enhance performance.
• Involved in the migration of OBIEE repository and catalogs from DEV to UAT, PROD.
• Extensively interacted with business users during UAT.
• Co-ordinated with the business analyst in preparing the test case scenarios for business users.
• Prepared the project documentation for knowledge repository.

Environment: OBIEE 11.1.1.7.1, TOAD, ODI 11.1.1.7, Oracle 11g, Informatica 9.5.1.

Confidential

OBIEE Developer

Responsibilities:

• Worked as Oracle BI consultant at Maryland State Department of in ‘Race To The Top’ project with primary objective of building Finance module of K12 dashboards and enabling security privileges to the users according to the business needs.
• Involved in generating custom reports and dashboards to provide insight into student’s records and various other factors that contribute to system and also implementing security as per the business requirements.
• Worked closely with the business analyst in understanding the business requirements and generated reports as per the user requirements.
• Involved in installing and configuring Oracle BI EE 11g in sandbox environment and testing the reports and dashboards.
• Involved in administering the Physical Layer, Business Model Layer and Presentation Layer of the OBI Repository.
• Developed Business Model Mapping Layer to create Dimensional hierarchies, measures and assigned Aggregation levels based on dimension hierarchies (Category, Fiscal Year).
• Worked extensively on BI Answers to create and design reports using views like Table, Pivot, Graph, narrative, static etc. to meet business requirements.
• Generated various analytical reports using Global and local filters.
• Created dashboard pages and provided drill down and navigation within the dashboard and used Conditions to determine which sections and their content are to be displayed on dashboard pages.
• Extensively used presentation variables to develop the logic for the reports.
• Implemented MUDE functionality in the project to enhance parallel use of the RPD
• Extensively involved in implementation of data-level security for LEA, Student dimensions, etc. using session variables.
• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.
• Calculated rolling average on a calculated item using various Math functions as part of developing custom reports.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Involved in migration of OBIEE components from various environments - DEV, TEST and PROD.
• Worked on implementing security for LEA users based on LDAP authentication security as well as catalogue user groups in presentation layer.
• Used security settings in BI Administration Tool to assign privileges to users and groups.
• Worked on managing the security privileges for dashboards according to the list of users provided by business.

Environment: OBIEE 11.1.1.7.1, SQL Developer, UNIX, Oracle 11g, Informatica.

Confidential, VA

Senior OBIEE Consultant

Responsibilities:

• The IT sector is implementing “Project Accelerate” for conversion of their source system from JD Edwards to Oracle EBS R12, OBIEE is implemented as a part of their reporting system to replace the old crystal reports.
• OBIA 11.1.1.7.1 which includes Weblogic 10.3.6 upgrade, OBIEE 11.1.1.7, ODI 11g and OBIA post-installation patches are installed by Oracle.
• Configured BI APPS for Financial Analytics by using the interfaces like BIACM (Business Intelligence Applications Configuration Manager) and FSM (Functional Setup Manager).
• Load plans for Full load and Incremental load were implemented, monitored and fixed the runtime issues by using ODI console and ODI Studio successfully.
• Designed and Developed OBI Repository at 3 layers i.e., Physical Layer (connecting to Data Warehouse & imported objects with joins), Business Model / data mapping (create Logical tables, Drill-Down Hierarchies & complex joins) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Developed Time Series object for comparing between the months, quarter’s sales.
• Successfully Organized Bi-weekly Scrum meeting as part agile methodologies and creating weekly status review meeting notes.
• Implemented Security by creating roles & web groups, checks with External tables and LDAP.
• Implementation of different views of report i.e. Pivot table, Titles, Graph, Filters and Column Selector etc.
• Created Materialized views and indexes for improving the performance.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To-Date functions.
• Created comprehensive and easy-to-understand Oracle Answers & Dashboards User Guide, and provided intensive to business users and to enable the use of Ad-hoc Reporting.
• Also involved in all production support activities, incident ticket resolving, issues fixing and troubleshooting the problems.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services.
• Perform end to end unit testing upon completing custom monthly FTE and Payroll reports comparing against legacy system reports.
• Created and implemented operational dashboards provided instant insight for Organization’s business by providing them with relevant and timely information, allowing executives to instantly identify and apply appropriate check points to improve their efficiency.
• Extensively interacted with client to provide all the necessary information and documented all the installation and configuration activities that are performed at onsite.

Environment: OBIEE 11.1.1.7, Oracle E-Business Suite R12, Oracle11g, SQL Developer, ODI 11.1.1.7 PL/SQL.

Confidential, TX

OBIA Consultant

Responsibilities:

• Installed the Oracle BI Enterprise Edition on distributed environment and responsible for administration and migration of repositories between various environments.
• Involved in translating functional requirements into technical requirements assisted in building detailed project schedule, gathering the requirements, completed the proof of concept.
• Actively involved in creating custom Interactive Dashboards, Answers and Administering Oracle BI Apps Applications
• Involved in Daily status meetings and preparation of operational plan and Involved in technical Conference Room Pilot sessions.
• Worked with Oracle BI Apps (OBIEE) Installation, Oracle BI Server, Presentation Server, Repository and Oracle BI Administration.
• Development using Oracle BI Repository like, Physical Layer, Logical Layer, Presentation Layer

  Analysis, Design, development and customization of Reports and Dashboards in OBIEE.

• Daily client interaction. Preparation and execution of the test plans.
• Developed customized reports like gross and net reports on the number of new Connections/Cancellations made by the customers hourly/ Daily/ Weekly/ yearly from different regions and used BI Publisher tool to generate the pixel perfect reports based user criteria.
• ETL process using Informatica for deploying BIEE reporting solution and optical metadata modeling.Involved in developing the Incremental ETL process i.e., Mappings using various Transformations and Workflows.
• Created Guided Navigation Links within OBI Dashboards
• Customized the OBIEE web user interface to meet Client reporting standard and developed key business Reports and Dashboards.
• Developed yearly and quarterly sales trending reports using time series functions like ago and To-date.
• Involved in applying department level data security for all BI reports and dashboards. Implemented the Cache Purging Strategy and usage tracking of Reports.
• Defined dimensional hierarchies and associated the proper level of granularity to the fact table.

Environment: Oracle BI Apps 7.9.6.3, OBIEE 11.1.1.6, Informatica 8.6, Oracle E-Business Suite R12, DAC, OBAW, Oracle11g, SQL Developer, PL/SQL.

Confidential, VA

Senior OBIEE Consultant

Responsibilities:

• Worked with multiple business groups and individuals in the process of Requirements Gathering.
• Organized meeting with Business users as part out of the box reports GAP analysis and gathering requirements for custom reports.
• Extensively involved in Managing Security, Managing Variables, Administrating the Repository and Managing Catalog objects as part of OBIEE 11g Administration activities
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Worked on scheduling Daily incremental loads after creating new client specific execution plan.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Customized the repository and created new requests using Answers.
• Developed the financial reports from different subject areas like FMS-AP-Account Entries, FMS-AP-Aging Process and reports like Listing of intra fund elimination exceptions, Payroll Disbursements.
• Involved in creating OBIEE 11g Data set as part of BI Publishers report development.
• Customized and Developed OBIEE Analytics Reports Account Activity, Revenue on business segmentation, Actual Vs Forecast Response rates, and Segment and Offer responses.
• Configured OBIEE Event Caching and Cache management features for improved end-user query experience.
• Organized the presentation layer in a format that is easy for end user for Ad-hoc reporting.
• Involved in Merge and Migrating RPD that include Repository and Catalog files from Development to Integration, QA and Production Environments.
• Debugged and optimized the OBIEE Dashboards / Reports
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP (OID) authentication setup and configuration of Multiuser Development Environment (MUDE).
• Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.

Environment: OBIEE 10.3.4.1/OBIEE 11.1.1.5, Informatica 8.6, SQL Explorer 3.0, DB2 9.1.4, Oracle 10g, Windows XP, AIX.

Confidential, PA

OBIEE Developer

Responsibilities:

• Primary responsibilities include gathering business requirements, designing the functional and technical specifications.
• Involved in Creating and Administering the Physical Layer, Business Model & Mapping
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the financial team about business changes.
• Involved in Design and Data Modeling using Star schema. Applied the method of 3N forms to minimize duplication of data in database design.
• Developed several mappings to load data from multiple sources to data warehouse.
• Developed and tested Store procedures, Functions and packages in PL/SQL for Data ETL.
• In Reports created the charts, tables, Pivot tables, View/Column selector, prompts etc.
• Design and configuration of BIP reports using BI Publisher for sharing the reports with Regulatory Authorities.
• Creating data models, parameters, templates and writing SQL Query for getting the data from source tables to design the BIP reports.

Environment: OBIEE 10.1.3.4.1, Informatica 8.6, DAC, Oracle 10g

Confidential

DataWarehouse Consultant

Responsibilities:

• Worked with Business Analysts and Business Users in the design of technical specification documents for data warehouse during multiple phases of the project
• Participated and provided input in business review meetings for approving logical and physical data models
• Involved in gathering user requirements and analysis.
• Involved in working with heterogeneous data sources like flat files, DB2 and Oracle.
• Implemented Type2 Dimension Model In Customer/Supplier/Product - record book. I.e. new attributes/columns were introduced in the dimension tables by slowly changing dimensions.
• Used complex mappings involving Target Load Order and Event based loading.
• Created various transformations like Joiner, Lookup, Router, Filter, Update Strategy Sequence Generator, Sorter and Stored Procedure.
• Created Mapplets for reusable business rules.
• Created Shortcuts to reuse objects across folders without creating multiple objects in the repository.
• Loaded bad data using reject loader utility and actively coordinated with testing team during Integration and Regression testing
• Dealt successfully with resource problems and reduced the turnaround time of DBA with data warehouse issues
• Implemented performance tuning techniques at system, session, mapping, transformation, source and target levels

Environment: Oracle 10g, Informatica 8.1x, Windows 2003 R2, 10.1.3.x, HP Quality Center, Toad

Confidential

Oracle Developer

Responsibilities:

• Involved in identifying and analyzing user requirements, preparing testing specs, database designing.
• Involved in development of online intranet Leave application & Time sheet management /HR payroll is for board wide use.
• Involved in designing database schema and implementing the software.
• Developed User Interface screens (GUI's) with Visual Basic.
• Responsible for forming SQL queries as per the criteria selected by user
• Created Stored Procedures and triggers.
• Involved in analyzing user requirements.
• Created the Tables, Views, Stored Procedures, Triggers and generated DDL and DML scripts.
• Involved in design, development and modification of PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application.
• Performance tuning of SQL queries, checking the most expensive queries using Explain Plan.

Environment: Oracle 10g, SQL Developer, SQL*Plus, TOAD, Windows XP