SUMMARY

• Result Oriented IT professional with 10 years of progressive expertise in analyzing the requirements, application design, development, customizations and implementation of software applications including Data Warehouse and Business Intelligence applications
• Comprehensive background in ETL Informatica, to complement the OBIEE skills for integrated OBI Apps.
• Very good understanding, knowledge and road map of DWH Process /OBI Apps
• Business requirement analysis, requirement gathering, FDD, TDD and iterative development.
• Specialized in Business Intelligence Reports using OBIEE Analytics, which provided adequate reporting facilities to the management system facilitating the decision making process and to provide report metrics.
• Well versed with new features and concept of OBI 11G
• Worked on Power Center Designer client tools, Create/Modify complex Informatica mappings as per design documents.
• Implemented Performance tuning techniques for ETL processes such as finding bottlenecks in sources, targets, mappings, and sessions and have done Troubleshooting and Error Handling.
• Extensive experience with end user requirement gathering and converting Business requirement into technical specification.
• Strong Knowledge on all phases of Software Development Life Cycle SDLC such as Requirement Analysis, Design, Development, Testing, UAT, Implementation and Post Production support
• Conducted workshops to gather user requirements and performed Gap Analysis and translate them to technical requirements.
• Experienced in Global Delivery Model Onsite/Offshore . Coordinated activities wrt to timelines, planning, POC and estimation
• Worked Extensively on Oracle BI Administration Tool, Presentation Services, Answers, Interactive Dashboards and Security Implementation
• Good Analytic and Statistical Exposure to create Reports, Proficient in building Repository Metadata, presentation layer, business models, generating reports, and creating interactive Dashboards using OBIEE
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers / IBots, creating reports / Dashboards, cache monitor, and building Analytics Repository using OBIEE Admin tool
• Good Understanding on Dimensional data modeling / Star Schema model
• Good at Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports.
• Experience in configuring Security Setup, Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports and setting up office integration for BI publisher
• Experience in Configuring Multi User Environment MUDE on Shared environment to allow development team to work concurrently
• Configured iBots using Delivers, Job Manager to deliver Analytics content based on schedule
• Implemented Cache Seeding Usage Tracking
• Experience in implementing Data Warehouses with ETL OLAP Tools like Informatica PowerCenter/ PowerExchange 9.x using Designer Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, and Transformation Developer , Repository Manager, Workflow Manager Workflow Monitor.
• Experience in Performance tuning and debugging of existing ETL processes.
• Demonstrated self-discipline, flexibility, and ability to work independently, as well as within a group
• Initiated various quality processes like defect tracking, delivery checklist, etc. to ensure smooth delivery of projects
• Prepared and maintained all project management documents, post implementation documents, production support documents, user guides
• Possesses good interpersonal skills and a keen understanding of fundamental business processes

Technical Skills

BI Reporting Tool : OBIEE 11.1.1.6.6, OBIEE 10.1.3.4.2, OBIA 7.9.6.2

ETL Tool : Informatica Power Center 9.1

DBMS : Oracle 11g, Oracle10g, Oracle 9i, DB2

Programming Languages : SQL, PL/SQL

Other Tools : DAC 10.1.3.4.1, Toad, SQL Developer

PROFESSIONAL EXPERIENCE

BI Senior Consultant Confidential

• As a 11.3 billion dollar pioneer in the direct selling industry, Amway is a consumer goods manufacturer supporting more than three million Independent Business Owners who provide products and services in 80 plus countries.
• As a Consultant in the DW/BI space reporting to Program managers and working with team across business functions and associated technical teams contributed to multiple projects ranging from enhancement to new development. I was very effective in proactively delivering and implementing technical solutions across the Supply Chain Data Warehouse space.
• Delivered multiple projects based on waterfall model in addition to implementing agile delivery of projects on a need basis. I worked with Supply Chain Team, with responsibility to provide analytics for meaningful business solutions related to cost savings and process improvements

My roles and responsibilities included but not limited to the following

• Interacted with Business Users to understand the Business Requirements, Report samples, data flows and prepared technical documents for implementing the solutions as per Business needs
• Conduct analysis and mapping of Functional Design Document for conversion into technical Design Documents for SCDW projects.
• Lead project opportunities that translate business analytics to informed business decisions.
• Worked with integrating multiple systems data from JDE into SCDW for different subject areas including but not limited to Procurement, JDA, BOM, Inventory, Planning, and Manufacturing, Warehouse Management System etc.
• Involved in Gap Analysis, Requirement Gathering, Functional/Technical Specifications, Development, Deployment and Testing
• As a BA doing the FIT GAP analysis and providing end to end design to the technical team.
• Designing and maintaining the Requirements Traceability document pertaining to OBIEE.
• Configured, Modified RPD as per the requirements
• Worked on Answers/Delivers/Dashboards/Report Changes
• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer, Security, test and validate the business model repository level calculations using Oracle BI Administration tool.
• Developed and debugged Dashboards / Reports using different Analytics Views Pivot Table, Chart, View Selector and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, guided navigation, charts, tabular using global and local Filters.
• Designed and Tested Reports in the Dashboards and created the Ad-hoc report according to the client needs
• Involved with the Testing team to resolve, fix the issues found during the Systems integration test
• Improved Analytics Response-time by Performance management using optimization efforts such as implementing the aggregate tables and reports changes
• Coordinated with the testing teams, business users during the UAT phase and worked towards the defect resolution.
• Developed ETL mappings using Unconnected Lookup, Aggregate and Router transformations for populating target table in efficient manner
• Involved in testing and performance tuning of Informatica mappings and understood the business requirements to transform the data
• Worked with various active passive transformations within Informatica like Expression, Lookup, Filter, Rank, Aggregator, Router, Update strategy, Stored Procedure and Joiner
• Involved in ETL support activities like : monitor, troubleshoot, track, and document day-to-day production issues
• Performance tuning of Dashboards/Reports and made changes to database by implementing Materialized views, Cache, Rebuilding Indexes
• Effectively contributed to the migration of Informatica mappings to Oracle Data Integrator for WMS.
• Made presentations to the management and end users during various phases of Software Development Life Cycle SDLC , OBIEE end user training for AD-Hoc analysis.

Environment: OBIEE 11.1.1.6.6, Informatica Power Center 9.1 Hotfix2 Designer, Workflow Manager, Workflow Monitor , Oracle 11g, Toad

OBIEE Consultant Confidential

Role and Responsibilities

• Participated in Requirement gathering and prepared the design documents
• Involved in migrating RPD and Catalog , from OBIEE 10G to OBIEE 11G using Upgrade Assistant Tool
• Worked on Oracle BI Administration Tool for customizing the Physical Layer, Business Layer, Presentation Layer that came with OBIA and modifying it according to the business requirements
• Involved in Gap analysis, requirements gathering, functional/technical specifications, development, deploying and testing
• Configured and Modified RPD as per the requirements
• Worked on Answers/Delivers/Dashboards/Report Changes as per the Requirements
• Set up Delivers iBots to support the needs of the end users
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer
• Implemented Data Level Security, Object Level Security
• Migrated Repository and Presentation catalog between different environments like Dev, Test, QA and Maintenance
• Worked on Web logic Security Realms to Administrate Users and Groups
• Implemented Action Links in reports, Navigating to a web page , Invoking java script and Navigating to BI Content/report
• Designed and Tested Reports in the Dashboards for the Oracle SCM Analytics modules and created the Ad-hoc report according to the client needs
• Worked on Enterprise Manager Console to deploy the RPD and Catalog
• Worked on Catalog Manager , for Partial Deployment , archive/Back up and Documentation
• Created Time Series Measures Year Ago, Month Ago, Year-to-date measures using Ago and To Date functions
• Involved in ETL support activities like : monitor, troubleshoot, track, and document day-to-day production issues
• Used DAC Client to customize and execute out-of-the box DAC execution plans to run all ETL mappings at specified interval
• Configure DAC and Monitor custom execution plans
• Created Tasks, Task Groups, Subject Areas and Execution Plans in DAC
• Performance tuning of Dashboards/Reports and made changes to database by implementing Materialized views, Cache, Rebuilding Indexes and ID Column Filter
• Participated in Unit System testing

Environment: OBIA 7.9.6.2, OBIEE 11.1.1.6.2, DAC 10.1.3.4.1, Informatica Power Center 8.6 Designer, Workflow

Manager, Workflow Monitor , Oracle 11g, Toad

OBIEE Consultant Confidential

• DuPont is a global leader in delivering science-based solutions in the areas of materials, products and technologies.
• DuPont has selected Oracle Business Intelligence Platform for enterprise-wide reporting and analysis for flexible, scalable and high-performing information system to improve the management of orders and enable constant monitoring of the sales process.
• The system enables users to perform detailed analysis of sales operations with respect to predefined criteria: product, client, or period. Manufacturers use Business Intelligence software to improve visibility and communication across their increasingly complex supply chains, while satisfying customer demands. Managers may access Dashboard reports to verify company results and make comparisons with previous periods.

Role and Responsibilities

• Interacted with Sales Supply chain Subject Matter Experts SME , Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements
• Participated in Installation of Oracle Business Intelligence EE
• Involved in upgrading OBIEE 10g to 11g
• Developed Metadata repository .rpd that consists of Physical, BMM and Presentation layer, Security LDAP for authentication and external table for authorization , test and validate the business model repository level calculations using Oracle BI Administration tool
• Developed and debugged many Dashboards / Reports using different Analytics Views Pivot Table, Chart, and Column Selector , Dynamic / Interactive Dashboards with drill-down capabilities, charts, tabular using global and local Filters
• Created Time Series Measures using Ago and To Date functions
• Implemented Object Level Security for both Repository objects and Web Catalog objects
• Performed the Administration tasks taking the repository Webcat backups, migrations, performance enhancements etc
• Created the user accounts, granting the access/privileges, resolving the performance bottlenecks, managing the usage tracking etc
• Implemented Data Level Security using Session Variables by creating content filter in RPD dimension table
• Implemented and Developed Usage Tracking Reports
• Configured and Monitored MUDE Multi user development Environment to achieve single and centralized repository development
• Improved Analytics Response-time by Performance management using optimization efforts such as re-organizing the data, implementing the aggregate tables, aggregate navigation, Cache Management, indexes, Oracle materialized views and reports changes
• Validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer
• Made presentations to the management and end users during various phases of Software Development Life Cycle SDLC
• Provided End User Training

Environment: OBIEE 11.1.1.3/ 10.1.3.4.2, Informatica Power Center 8.1, Oracle 10g, PL/SQL, Toad, SQL Plus

OBIEE Consultant Confidential

• Delphi is a leading global supplier of Automobile systems. Delphi Designs and manufactures a wide variety of components on a worldwide basis. . They are having manufacturing and design plants in many locations of the world. They are supplier for companies like GE, Caterpillar, Volvo, Renault, Toyota and Opel. Scope of the project includes developing an Enterprise Data warehouse and Reporting system for Delphi Supply Chain Reporting Suite.
• The Scope of the project is to provide reliable warehousing and reporting system for the critical applications- to create the Data warehouse, set up Oracle BI enterprise Suite, perform partial and full load of extracts and produce customized and vanilla reports.

Role and Responsibilities

• Interacted with the business users in analyzing report requirements
• Gathered Business Requirements and documented as Business Requirements, Functional Requirements
• Designed and Developed custom business intelligence solutions Metadata and Dashboards/Reports using OBIEE platform
• Created/Modified Metadata repository .rpd 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
• Created different Hierarchies, Levels and implemented Business Logic by creating level based measures
• Implemented object level security
• Worked on different performance tuning methods Caching Aggregate tables
• Developed Ad-hoc and standard Reports / Dashboards with different Analytics Views like Multiple Compound layouts, Tables, Pivot Tables, Graphs, Column Selectors using OBIEE
• Created reports using Filters, Prompts, Column selector, Conditional formatting, Charts etc as per the user requirements
• Configured iBots using Delivers, Job Manager to deliver Analytics content/report through mail to business users based on schedule
• Involved in developing Informatica Mappings Mapplets during enhancements
• Developed Informatica mappings with re-usable transformations mapplets using various Transformations
• Involved in performance tuning of the Informatica Mappings/Sessions by increasing the caching size, overriding the existing SQL
• Attended all functional Non functional, technical business requirements meetings concerned with the project
• Involved in Testing. Executing test plans and documenting test results for approval

Environment: OBIEE 10.1.3.2, Informatica Power Center 7.1.4 Designer, Workflow Manager, Workflow Monitor ,

Oracle 9i, PL/SQL, Toad, SQL plus

Software Engineer Confidential

• Farmers Insurance Group is an American insurance and financial services company headquartered in Los Angeles, California and a wholly owned subsidiary of Zurich Financial Services. It provides homeowners insurance, auto insurance, commercial insurance, life insurance and other financial services throughout all 50 states of the United States.
• An application named FPPS is currently using a third party tool called Optiload, to load the data from mainframe COBOL flat files, VSAM files to UDB DB2. The main purpose of the project is to replace Optiload tool with Zurich 'A' standard ETL tool Informatica, retaining the existing Optiload functionality. Because Optiload tool is incompatible with DB2 9.x and support from Vendor is not going to be provided from the year 2009.

Role and Responsibilities

• Interacted with Clients to gather business requirements
• Participated in the entire Software Development Life Cycle SDLC phases including Data Analysis, Data Modeling, Development, Supporting
• Analyzed Business Requirements and converted them into mapping design
• Developed data mapping for Sources, Targets, and Business Transformation rules
• Developed mappings for slowly changing dimensions Type I, II and Facts using Informatica Tool
• Used different Data Warehouse techniques like Star-Schema, snowflake schema
• Worked with various active passive transformations within Informatica like Expression, Lookup, Filter, Rank, Aggregator, Router, Update strategy, Stored Procedure, Joiner etc
• Developed Mapplets and Reusable Transformations for calculated business units
• Involved in the performance tuning of the programs
• Responsible for ETL Objects and Database Objects migration for each release
• Tested target data against source system tables by using SQL statements
• Monitored daily data loads and provided support after hours

Environment: Informatica Power Center 7.1.3 Designer, Workflow Manager, Workflow Monitor , Oracle 8i, PL/SQL, Toad, SQL plus, DB2, Cobol VSAM files

Software Engineer Confidential

• Barclays, a global financial services provider engaged in personal corporate banking, credit cards, investment banking, wealth and investment management services, with an extensive international presence.
• Barclaycard is a leading global payment business which understands the needs of both purchasers and sellers. It enables retailers and merchants to accept cards, helps customers make payments through card. It also issues credit cards to corporate customers and the UK Government. Barclays partners with a wide range of organizations across the globe to offer their customers or members payment options and credit.
• The Project mainly focuses on the loading of data from various sources into a single Data warehouse.

Responsibilities

• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer
• Created Informatica mappings using Transformations like Sequence generator, Lookup, joiner and Source qualifier transformations in Informatica Designer
• Created Complex mappings using Unconnected Lookup, Aggregate and Router transformations for populating target table in efficient manner
• Created Mapplet and used them in different Mappings
• Developed Informatica mappings and also tuned them for better performance
• Created mappings with PL/SQL Procedures/Functions to build business rules to load data
• Created events and tasks in the work flows using workflow manager
• Involved in testing and performance tuning of Informatica mappings and understood the business requirements to transform the data
• Developed Table to Table, File to Table mappings Full refresh, Incremental according to business requirements
• Involved in preparing Low level Design documents
• Involved in Unit Testing, System Integration Testing
• Research and resolve issues with ETL workflows
• Involved in Preparing Unit/Integration Test cases
• Perform Root Cause Analysis RCA and identify and implement corrective and preventive measures
• Created enhancements as per the requirement
• Deploying/Migrating the code to different environments
• Preparation and submission of Weekly/Monthly status reports to Customer

Environment: Informatica Power Center 6.2, Oracle 8i, PL/SQL, Toad, SQL plus, DB2, Cobol VSAM files