Babu

Senior BW/BO Consultant

Summary

Overall 10 plus years experience in various versions of SAP BW / BI (3.x & 7.x) with multiple implementations.

Over 4 years of significant experience in software development using Business Objects 4.0, XIR2/6.X/5.X.

Implementation Experience in Manufacturing, Chemicals, Pharmacy, O & G and Fertilizer Manufacturing.

Involved in 3 full life cycle implementations

Experience in ETL with SAP ECC LO, FICO, COPA & CRM systems

Experience in BADI’s objects implementation

Used Open Hub Services, to push data out of SAP BI using Data Services

Experience in Data Modeling for Design, Development of standard and custom BW solutions including data extractors

from Multiple SAP and Non SAP (Legacy) Systems

Expert level in front end development in designing queries, workbooks and dashboards

Experience in using of BEx Analyzer, Query Designer, Web Application Designer (WAD). Information Broadcaster.

Experience in using of Business Objects 4.0, XI R3.1/R2/R1/6.5,CMC, Designer, Desktop Intelligence, Infoview, Web-

Intelligence XI/6.x, Auditor, Crystal Reports, Xcelsius 4.5/3.5, Business Objects Reporting.

Experience in SAP BW 3.5/BI 7.X, Integration with SAP ECC/BI/BW, Xcelsius Dashboards on SAP ECC/BI/BW, Explorer

on BWA and Universe Designing (Relational & OLAP)

Performed Query performance Tuning by analyzing and applying, aggregates, line item dimensions, data compression,

Query read Mode, Bit Map Index, Partition a parallel query option.

Good communication skills, interpersonal skills, User Interaction, Top Management Interaction.

Technical Skills:

SAP BW/BI 7.3, 7.1, 7.0, 3.5, 3.1

SAP Business Object (BOBJ 4.0, XI R3, BO XI R2)

SAP Solution Manager

SAP BI Accelerator

SAP ECC 6.0 Finance Module, SD Module.

SAP R/3 ECC,4.0B/4.5B.4.6b,4.

SAP ABAP

SQL Server Integration Services

Project Summary

Home Depot, Austin TX Feb 14 to Date

Senior SAP BW/BO Consultant

Responsibilities

• Working in production environment, support production configuration and assist in change management and defects.

• Service Level Agreements based ticket fixation and Respond to user requirements, problem resolution, develop designs,

and process modeling

• Responsible for daily BI activities and SLA Management.

• Resolving the issues that occur during the Loads based on Severity Level.

• Responsible for Interacting with the Customer, Understanding Customer business requirements, analysis, technical design,

development and testing of various global templates

• Daily Monitoring activities like Analyzing ABAP Dumps, Update Monitoring, Alert Monitors, System Traces, Lock Entries Set

Alert Threshold, and Operation modes.

• Adhere to good systems development methodology and prepared project related documentation (functional design,

technical design, test scripts) during the different stages of a project.

• Analyze and configure BW/BI 7.0 data environment to facilitate custom reporting and data analytics solutions.

• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate

testing, and perform change management/training for BW Reporting and applications.

• Perform analysis and design; write technical specifications; configuration and programming in the SAP/BI environment,

including testing and implementation.

• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.

• Design complex, custom BW solutions or component objects translating complex requirements into an optimal BW design.

• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.

• Support the on boarding and training of BW Power Users. This includes providing technical training of key BW toolsets such

as BeX web analyzers, query designers, Business Objects.

• Conducted daily, weekly, monthly status meetings. presentations, resolution of issues and mitigation plans

• Perform code review and validations on new developed reports

• Participate in new report development/ requirement and design

• Re-modeling and enhancement of existing Objects in BI

• Validate Daily, weekly, Monthly data loads and reports

• Production deployment, upgrade plan and implementation

Page 1 of 7

• Production deployment of new reports and maintain BI Reports documentation.

• Managed and monitored several data loads, captured the errors and corrected the bugs and applied several OSS notes for

the errors encountered while loading the data.

• Client interaction, communication and coordinated onsite and off shore activities

• Conducted knowledge sharing session within different teams

Environment: SAP BI 7.0, BW 7.3, B O 4.0, IDT, WebI, DeskI, Xcelsius 2008, PL/SQL, SQL Server, SQL, BEx Query Designer

CF Industries, Deerfield, IL Oct 12 to Jan 14

Senior SAP BW/BO Consultant

Responsibilities:

Analyze and configure BW/BI data environment to facilitate custom reporting and data analytics solutions.

Built and enhance BI objects such as Info Objects, Info Cubes, Info Sources/Data Sources, Master Data,

Transformations, and Update Rules, DSO, Extractors, Info sets, Aggregates, Process Chains, User Exits, BADI.

Interact with business to gather requirements, prioritize work, develop enhancements to the existing system,

coordinate testing, and perform change management/training for BW Reporting and applications.

Perform analysis and design; write technical specifications; configuration and programming in the SAP BI environment,

Including testing and implementation.

Worked on MM Cube 0PUR_C01 loaded data into that successfully. Developed reports price trends over last three

months, D&B Billing documents per creditor, purchase order value by vendor over a time.

Worked on SD cube 0SD_C03 and developed reports sales order and sales revenue values from last 12 months.

Worked on SD business processes OTC (order to cash) and sales order processing, Delivery, shipping and billing.

Worked on Inventory data sources like 2LIS_03_BX, 2LIS_03_BF and 2LIS_03_UM

Worked on comprehensive process of Order to Cash cycle posting and reporting

Worked on simplified Order to Cash cycle like order-to-invoice and invoice-to-cash

Good functional knowledge of Sales & Distribution (Sales Orders, Deliveries, Billing ) MM (Purchasing & Inventory

Management), FI and general business process of SAP R/3.

Extracted data from Production (PP) and Process Orders (PP-PI) to analyze manufacturing orders

Worked on Production Planning Data Sources like 2LIS_04_P_MATNR, 2LIS_04_P_COMP, 2LIS_04_PECOMP and

2LIS_04_PEMATNR

Develop and drive the implementation of BW best practices and standards for the team.

Support the on boarding and training of BW Power Users. This includes providing technical training of key BW

Expertise in BW Performance Tuning: Performed tuning measures of Queries by maintaining Aggregates, Roll up,

Compression, partition, Process chains, indexing of info cubes and use of statistics for the same

toolsets such as BEX web analyzers, query designers, Business Objects

Resolved issues in Database Performance Tuning, Data Load Performance Tuning, and Query Performance

Tuning.

Created Process chains for effective scheduling of various processes.

Created and maintained Business Objects reports in Web Intelligence Info View.

Designed and developed standard reports, cross-tab reports.

Used Central Management Console of Business Objects Enterprise to maintain reports scheduling tasks.

Created queries and reports, Web Intelligence (Web I) documents in Info View and created Web Intelligence

(WebI) reports on top of the Universes created using the Designer.

Promoted the reports using Promotion Management Utility within BI 4.0 environments Dev, QA and

Prod.

Work on SAP Business Objects XI 3.2/4.0 (Universe Designer/IDT, Xcelsius, QAAWS, BIWS, Webi Rich Client, Import

Wizard, CMC, Info view etc.) and SAP BW

Experienced in creating complex reports by linking data from multiple data providers, using free hand SQL,

Stored Procedures and functionalities like Combined Queries, Sub Queries

Created executive summary and framework (Xcelsius) dashboards, including hierarchical selectors, flash variables (linking

to dashboards), and dynamic sales and marketing information based on live SAP BPC data.

Displaying data using remote cubes and pulling data from SAP BW using Open Hub Service and transferring the data

to non-SAP systems.

Created user manuals to the end-user to train how to work with the reports.

Taken demos to end-user to help them in creating sensible webi reports and how to make use of Info view, how to

make sensible report of their own when needed.

Environment: SAP BW 7.3, B O 4.0, WebI, DeskI, Xcelsius 2008, PL/SQL, SQL Server, SQL, BEx Query Designer

Hewlett-Packard, Austin, TX June 12 to Sept 12

Senior SAP BI/BO Consultant

Responsibilities:

Interacted with the project team and end users for designing the data models.

Analyzed the business requirements and translated into data models.

Worked extensively in the Data Modeling of FI Info Cubes.

Enhanced the DataSources to include the custom fields in extract structures and used user exits to populate the data.

Created new Data Sources for FIGL, and FIAR.

Extracted logistics data using data sources 2LIS_03_BF, 2LIS_02_SCL this data sources are used to extract data

related to Inventory Management and PO Extraction.

Generated Data Sources (Generic) for Master Data, Text and Transaction Data using the transaction RSO2.

Responsible for Design, Development and Implementation of Multi Cubes, Info Cubes, and Data Store Objects.

Managed and monitored data loads with full update and delta mechanism and optimized the performance by

adjusting packet size and data selections

Identified and developed new Queries in BI.

Page 2 of 7

Created Process Chains to automate the data load and data target administration.

Conducted Unit and Integration testing.

Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating

business objects reports

Created inventory accuracy Dash Boards (Xcelcius) and for management reports for inventory management and

wages and costs report from cost center accounting.

Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider

Created universes, classes and objects by retrieving the data from data sources like BW queries and defining

necessary connections.

Carried out Transport to staging and production environments, data transfer using Open Hub Services (OHB)/Info

Spokes.

Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key business.

• Involved in the Upgrade Apps, Pre-checks, Tech. Upgrade, Prepare, Post Activities, Migration to New Weaver

7.0, Web

• Objects to Net Weaver 7.0, Plug-in release.Tested the new features of BI 7.0 which includes new data

flow, re-modeling,

• integrated Planning, Real-time Data Acquisition, enhanced features of Process Chains etc.

Installation of BOBJ 4.0 tools and SSO with SAP BW

Created Analysis for Office workbooks as a replacement for BEx Workbooks

Conducted User training sessions with existing BEx End Users for Analysis for Office

Created few WebI Reports for existing BEx Reports & Web Templates

Developed workbooks and broadcasted to the end users

Conducted sessions with relevant teams for NW Portal Integration, OS, BackUp & DR Strategies

Used Bex Queries all through the Project to build OLAP Universes, and Webi Reports & Xcelsius Dashboards.

Worked on Bex Analyzer to test the above mentioned Xcelsius Dashboards, Webi Reports & Universe, to verify &

test the Consistency of data all throughout the SAP BW & SAP BOBJ Platform.

Getting rid of BEx Web Templates by Analysis for OLAP

Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored

procedures and functionalities like Combined Queries.

Generated several Reports using BO Universe as data provider against multiple data providers

Environment: ECC 6.0, SAP BI/BW 7.1, 7.3, BEx, Informatica, SQL, PL/SQL, BO, 4.0 and APO

CITGO Petroleum Corporation, Houston, TX Nov 11 to May 12

Senior SAP BI/BO Consultant

Responsibilities:

Scheduling and monitoring of Data loads.

Maintaining reconciliations to verify the data in SAP R/3 and SAP BW are same or not after the data loads

Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up

of set up tables and loaded data from SAP ECC to SAP BI and used initialization update and delta update

Worked on Creation of Process chains.

Testing the reports with data and Rectified the issues occurred.

Involved in performance enhancement features such as cube partitioning, Indexing, maintaining aggregates and

compression.

Set up periodic Data loads from legacy system (flat files)

Creating and managing dataflow using DTP, Transformations and info packages.

Designed and developed queries to generate reports in BEx Designer

Involved with performance tuning of queries by compression, repartitioning of info cubes.

Created aggregates for info cubes to improve query performance.

Created new and linked universes.

Created Master detail, Charts and Cross-tabs reports to view data in an analyzed way.

Automated Document Scheduling, Publishing and Distribution for Web Intelligence and InfoView clients using the Broadcast

Agent and XI Scheduler.

Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted Calculations, Filters, Sorts and

query Prompts

Developed reports using WEBI, DESKI as well as Crystal Reports as part of prototypes and demos

Created Contexts and Aliases for resolving Loops in the Universes

Created various predefined security settings depending upon users and group needs.

Generated hyperlink reports, cross-tab reports with conditions, global filters and multiple data providers.

Involved in performance tuning of Business Objects reports. Database hints and other optimizing techniques were used to

improve the performance.

Generated several Canned Reports using BO Universe as data provider against multiple data providers.

Installation, configuration, maintenance, technical support and troubleshooting of BO and Xcelsius

Development of Dashboards using Crystal Xcelsius 2008

Created detailed test cases and test plans to test various aspects of the universe and Business Objects reports.

Environment: SAP BW 3.5 BI 7.0, 7.1, SAP ECC.6.0, SAP BO 3.0, BEx Analyzer

Bristol-Myers Squibb, New Brunswick, NJ July 11 to Oct 11

Senior SAP BIBO Consultant

Responsibilities:

Page 3 of 7

Responsible for modeling the R/3 transaction data into SAP BI system to address the organization need of coverage

involved sales, profitability analysis and financial reporting. The SAP BI system utilized as a strategic tool for companywide

control of implementation.

Gathered and assessed customer requirements through interviews, questionnaires and Business Model Blueprints

Worked with functional consultants for mapping the SD, PA and FI data onto the Data Sources in BI. Information from various

sales docs (like customer orders, deliveries and invoices) were mapped from SD area, various levels of detailed key figures

were mapped to address the requirements of profitability analysis and information from general ledger was required for

financial reporting

Enhanced Standard Business Content Info Cubes like Product Cost Planning-All Cost Estimates (0COPC_C08) and Product

Cost Planning-Released Cost Estimates (0COPC_C09)

Developed custom InfoCubes for General Ledger and Plan data (Balance sheet and profit loss), actual and plan data for

Profitability Analysis

Customized and maintained Data Sources such as PCA – All Calculations (0C_PC_PCP_01), PCA-Released Calculations

(0CO_PC_PCP02), and PCA-Itemization (0CO_PC_PCP_30) for the Profitability Analysis.

Created Master Data Info Objects and loaded master data.

Worked on creating Aggregates, compressing InfoCubes, creating Indexes, MultiCubes and process chains

Created reports using BEx Analyzer and WAD that include Cost Overlay Reconciliation Report, Cost Compare Report, Value

of Production Report, Balance sheet and Profit Loss using filters, restricted and calculated Key Figures, variables, formulas,

exceptions and conditions

Created Open Hub Destination Objects to transfer data from standard DSO to Flat Files

Analyzed the business requirements, performed gap analysis with respect to the data model needs and available business

content in SD and FI

Used ODS objects to stage the data from different data sources and transferred the ODS contents into various data target

and Info Cubes based on the requirement.

Very good experience in extracting data from OLTP, legacy system, Flat files and Informatica Power Center Integration

Server V5.0 (PCISBW).

Built Process Chains for running Delta (Batches) after manual INIT loads.

Researched new versions of the tools like BO XI R3 (Beta), Crystal Reports 2008, BO Dashboard Manager in order to

explore the new features and integrate them into the existing reporting architectur

Generated several Reports using BO Universe as data provider against multiple data providers

Created new and linked universes

Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted Calculations, Filters, Sorts and

query Prompts

Created Master detail, Charts and Cross-tabs reports to view data in an analyzed way.

Environment: SAP BW 3.5, BI 7.0, 7.1, SAP ECC.6.0, Informatica, SAP BO, BEx Analyzer

Coca-Cola Company, Atlanta, GA Feb 11 to June 11

Senior SAP BW/BI/BO Consultant

Responsibilities:

Design of both functional and technical specifications

Development of Cockpit objects for query analysis

Involved in enhancement of the data sources in order to add new field as per client requirement.

Populated the historical data for new info object in info cube by using remodeling method.

Designed user’s manual for training.

Worked on comprehensive process of Order to Cash cycle posting and reporting.

Worked on simplified Order to Cash cycle like order-to-invoice and invoice-to-cash

Worked on SD business processes OTC and sales order processing, Delivery, shipping and billing

Day to day interaction with the end users collecting information and to further discuss any issues on the reports

Responsible for design of the data flow and developing DSOs for Line items, InfoCubes for summarization, and

MultiProviders for Cross reporting

Built new DSO’s info Cubes, multi-providers to support SD, FI, GL, AR, and AP reporting requirements.

Enhanced extract structures for Master Data to bring additional fields in to BI and created custom Data Sources for

transaction data to meet the business requirements.

Developed Paid GL Line Items, AR Monthly, and Budget vs. Plan workbooks to automate the close process for AR and GL

teams

Developed new BEx Queries, workbooks based on the different Info Providers

Maintenance of Hierarchies Structures

Create CKF and RKF as needed and adopt performance on all queries

Created queries in Query Designer and deployed to the Portal

Activated required BW Statistics Objects and created a virtual Cube that is required for Reports.

Developed process chains to automate the initialization and delta updating of all data.

Created over BEX queries and assigned them to roles by department.

Involved in migrating SAP BO universes and reports to Business Objects XI R2.

Generated several Reports using BO Universe as data provider against multiple data providers

Created new and linked universes

Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted Calculations, Filters, Sorts and

query Prompts

Created Master detail, Charts and Cross-tabs reports to view data in an analyzed way.

Environment: Net weaver 04’s, SAP ECC.6.0, SAP BO, BEx, Analyzer, APO.

Hewlett-Packard, Houston, TX Oct 10 to Jan 11

Senior SAP BW/BI/BO Consultant

Responsibilities:

Page 4 of 7

Contribution-Identified the functional derivations for the new developments in FI-Accounts Receivables, General Ledger,

Accounts Payable and Billing (FI-AR,FI-GL,FI-AP, SD) applications.

As a Techno functional consultant preparing the functional design documents from the requirements.

Created Technical Design Documents for Queries, Info providers and process chains from the Functional Design

Documents.

Ensure that customer needs are identified and that appropriate, cost effective solutions are provided to the satisfaction of

customers on schedule, within budget and to the appropriate quality

Designed project model based on the requirements.

Installed BC objects of Finance Module like Accounts Receivable (AR) payment history and billing.

Enhanced the Accounts Receivable Line items data source and info providers.

Created Reports in Accounts Receivable like Aging Period, Open items and Customer Information Overview Reports.

Created Reports in Accounts Receivable application like Bouncing and Credit Memo Reports.

Created dashboards for AR, Billing applications by using WAD.

Collected, released and imported the Objects from Development to Quality and Production Systems.

Worked on the mapping of the source systems from one client to another client.

Managing and resolving errors in transports from development to quality system.

Support end users for the existing applications.

Extensively worked on Bex Analyzer to create custom reports such as 1. Cumulative Failure Rate, 2. Annualized Service

Event Rate, 3. Revenue Report & 4.Forecast report.

BW /BI Consultant responsible for Preparation of Data flows, functional feasibility analysis, Post go live support, activity

execution, Quality Assurance to improve performance of the system.

Direct interaction with the business users.

Knowledge in designing universe by using multi dimension data base (SAP BI) as the back end.

Knowledge in classifying the classes and dimension /(Detail measure).

Experience in designing and developing the Universe and updating the existing Universes,developing canned/adhoc reports

Knowledge in designing reports by using different report components like desktop intelligence, WebI rich client.

Knowledge in creating xcelsius, Dashboards and integrating same in crystal reports.

Knowledge of using live office

Environment: Net weaver 04’s, SAP ERP ECC.5, BEx, SAP BO, BI Portals, BIA, IP, APO.

Hewlett-Packard, Austin, Jan 10 to Sept 10

SAP BW/BO Consultant

Responsibilities:

Worked as a Techno functional consultant, evaluated user requirements, converted the Business requirement documents

(BRD) to Application Design Document (ADD), designed and developed application by leveraging ABAP/4 programming

skills and functional expertise.

Worked on Data modeling in BI/BW with Data Warehousing Workbench Info Objects, Info Sources, real-time Info Cubes,

Multi-providers, Aggregates, Data store objects, Transfer Structures, Installing & Activating Business Content, coding in

Transformations, Info sets and Data Sources.

Designed and developed several BEX Queries in SD-Order Management, Customer service and Reverse logistics areas as

per the Business requirement.

Designed and developed the modeling for Backorder processing (Order management) and extract for Loan Management

tool for HP. Presented several KT sessions to the Global support teams.

Loaded data through different levels of ODS for Purchase order and deliveries. Loaded data into Cube with auto update from

different levels of ODS to which data is fed from flat files for sales order and deliveries. ABAP code was incorporated in

update rules to check the conditions like status of the delivery completion, sales order quantity and overall status of the sales

order.

Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the

extract structures for the above modules. Scheduled data loads.

Worked on LO cockpit for Maintenance of extract structures for Orders, Billing & Deliveries.

Worked on extractors in Procurement & Inventory Management in MM.

Coded (using ABAP) the MM extractors to selectively extract the inventory data.

Strong skills in the integration of SD, MM, APO-DP modules.

Designing the Data flow for extracting Sales and Shipment Data from R/3 to APO/BW.

Designed and developed several BEx Queries for Inventory to obtain component level data (ACTUALS VS FORECAST).

Created reports like Supply Reports, Ship/Order/Consumption reports etc.

Designed and Created Universe, Classes and Objects for management system.

Development and Deployment of Complex Reports.

Used multiple data providers, Union, Intersection, minus and Master/Detail, Cross Tab, Charts.

Data Providers for the Report generation in Full Client were Universes / Freehand SQL and Universes for WebI

Created the Informatica ETL design and developed the data flow

Worked extensively with the functionality of BO like Breaks, Alerter, Filters, Sorts, and Query prompt and Drill filters.

Analyzed the reports using the Drill Through, Slice and Dice.

Trained end users in the functionality of the software.

Assist team in delivering complex adhoc analysis and reports via the data warehouse

Environment: SAP BI 7.0 SAP ECC 6.0, APO, BEx and BIA,Informatica, Business Objects XI R2/6.5, Infoview, WebI.

Rohm and Haas, Philadelphia, PA Oct 07 to Dec 09

SAP BW/BO Developer

Responsibilities:

Gathered business requirements, performed Gap analysis, Design and Modeling on Purchasing and Sales.

Involved in Requirement gathering, Analysis, Design, Development, Testing, go-live and post go-live activities for projects

relevant to Special Purpose ledger, General Ledger, and. Tax Ledger

Page 5 of 7

Responsible for preparing functional and technical specifications, and BBP Documents.

Modified the R/3 (FI-GL, FI-SL) transactional data sources by enhancing the extract structures using user exits to support the

business needs.

Responsible for design of the data flow and developing DSOs for Line items, InfoCubes for summarization, and

MultiProviders for Cross reporting.

Created Real-Time InfoProviders, Aggregation levels, planning functions, and filters using Integrated Planning (IP) Modeler

to facilitate planning on Taxprovisioning and General Ledger Cubes. Enhanced the existing BPS scenario (Business

Planning and immolation).

Designed and developed FI-AR data model, A/R Cube, A/R Aging Data Mart Cube and A/R Cash Cube.

Installed Business Content including DataSource, InfoSources, InfoCubes, ODS Objects, Update Rules and Queries.

Responsible for Designing DSO (Data Staging Layer) for the General Ledger transactional data sources.

Created start routines in update rules for implementing the business requirements.

Created Transfer routines/Update routines for InfoCubes and DSO objects using ABAP/4.

Worked on BEx Analyzer and BEx Browser and Web Reporting, Developed queries using filters, navigational attributes in

BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Published reports to portal using BEx Broadcasting.

Sending daily/weekly reports to users using BEx Broadcasting.

Involved in migration and deployment of the universes and reports across multiple domains

Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to

every component.

Preparation of Project plan and HDD, LDD of Universe and reports.

Used supervisor module for disabling / enabling access to documents and access to universes.

Creating standard full client reports and WebI reports.

Performed the Integrity check and finally exported to the repository.

Involved in requirements study, design reviews and analysis of input/output flow.

Worked extensively with the functionality of BO like Breaks, Alerter, Filters, Sorts, and Query prompt and Drill filters.

Analyzed the reports using the Drill Through, Slice and Dice.

Created universes, classes and objects by retrieving the data from various data sources and defining the necessary

connections.

Used Business Objects Developer Suite (Publisher View, CMC, Designer, and InfoView) to perform various tasks specific to

every component.

Environment: Netweaver 2004s, ECC 6.0, Enterprise Portal 7.0, SQL, Oracle,SAP BO, XI R2/6. 5, Infoview, WebI.

Pactiv Corporation, Lake Forest, IL Jan 07 to Sept 07

SAP BW/BI Developer/Analyst

Responsibilities:

Designed/Build Documentation which provides to end users and developers to run their reports

Worked on extracting the data from for S&OP (Sales and Operation Planning) report

Prepared a designed documents and data model for S&OP projects

Designed/Built InfoCubes, Multicubes and prepared InfoCube, Multicube Design Documents

Created communication structures, transfer structures, transfer rules and update rules

Developed a start routine and transfer rule for unit of conversion

Created extractors and Infocubes in SD/MM (Billing, Sales Order, Delivery, Shipment, Material pricing)

Worked on BW performance and Tuning project (Query).

Activated LO Cockpit extract structures for Logistics

Performed extraction from multiple source systems including SAP (using LO) and flat files

Created Custom/extractors and Infocubes for General Ledger, Special Purpose Ledger in FI/CO areas.

Worked on SD business processes OTC and sales order processing, Delivery, shipping and billing

Created queries using variables, RKFs, filters, exceptions, conditions, free chars and almost all BEx

Contact this candidate