SUMMARY

• Over Seven plus (7+) Years of IT experience in SAP BW/BI & BOBJ functional and various reporting. Implemented Projects in SAP BI 7.0, BW 3.5, upgrade from SAP 3.5 to BI7.0.
• Involved in 3 complete life cycles implementations of SAP BW/BI which dealt with requirement gathering, Business Blue Print, Realization, final preparation and Go Live & Production support.
• Excellent knowledge of BW system, ETL, Data Warehousing concepts including Data modeling, Query, BW Web Reporting, Report Design and Open Hub Service.
• Upgrade Experience in SAP BW from 3.5 to BI 7.0 and in depth knowledge of migrating data sources from BW 3.5 to BI 7.0 and maintaining Transformations and DTP’s.
• Experience in teh Design, Development and Configuration of multi - dimensional Data models, Info Cubes, Operational Data Store (ODS), Info objects, Data Sources, Info packages, Multiproviders, Transformation, DTP, Extract Routines, Enhancements to Business Content, Generic Data Sources, etc.
• Worked on SAP delivered Business Content objects as well as generic extractors.
• Experience in teh customization of teh standard business content extractors and enhancement of teh data sources in various applications using customer exits.
• Good at writing ABAP coding related to SAP BI/BW.
• TEMPEffective in Data Extraction from SAP R/3 (FI/CO, MM, HR and SD), flat files and BW using extraction structures such as LO Cockpit, COPA, FI and Generic Extractors.
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, partitions, and Info cube compression techniques.
• Created BEx Query on Info Providers and Multiproviders using Structures, Restricted Key Figures, Calculated Key Figures, Characteristic Variables, Text Variables, Formula Variables, Exceptions, and Conditions.
• Good expertise in Query development, Reporting agent, Variables, structures, BEx analyzer, Web Templates, WAD (Web Application Designer), Web Reports, Jump analysis using RRI (Report-to-Report Interface).
• Good experience in Business objects reporting, Xcelsius, Crystal and Webi.
• Good knowledge in creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus).
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate TEMPeffectively with Team members, developers, clients and end users in a diverse environment.
• Experienced in writing test schedule and test scenarios for Integration testing and User Acceptance testing.

TECHNICAL SKILLS

ERP: SAP ECC 6.0/5.0, R/3 4.7, R/3 4.6C

ETL Tools: SAP BI 7.0, BW 3.5/3.1C/3.0B/2.1C, SAP BO 3.1 XI/4.0

Reporting: BEx Analyzer, BEx Reporting (BI 7.0/BW 3.5), Web Reporting, Business Objects XI 3.1/4.0 (BOBJ), Web Intelligence, Crystal Reports, Ad-hoc reports, Xcelsius, Desktop Intelligence, Info View, QAAWS, Live Office, Central Configuration Manager (CCM), CMC (Central Management Console), Dashboard manager, Scorecards.

Programming: ABAP/4

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

SAP BI/BOBJ Consultant

Responsibilities:

• Involved in all phases of teh project life cycle implementation which includes requirements gathering, GAP analysis, design and architecture of teh system, modeling, and development of BW backend objects, Reports, Workbooks, User Roles etc.,
• Prepared Business requirement documents (BRDs), Functional designs (FDs), DFDs, Technical design and specifications, Data validation, Testing Procedures, Data load procedures for go-live etc.
• Developed DSO to load SD Sales Order, Delivery note, billing document Data from Business Content delivered data sources.
• Installed teh BI Content and extended teh content to add custom info objects. Modeled and created teh end to end connectivity using Custom data sources and transformations.
• Created genetic datasource to pull data from R/3 system and developed complete flow in BW and made it for reporting using multiprovider.
• Worked on creating Transformations and Data Transfer Process to load data from Flat File via Data Source into Staging DSO and in initialize by Full & Delta process.
• Created process chains for periodic upload of master data, transactional data, text data and scheduled and monitored teh data loads with delta update and full update mechanisms.
• Involved in performance tuning of reports dat were running slowly. Did performance tuning at teh report level, Designer level and database level.
• Extensively Worked on User Exits and Customer exits to meet teh client requirements.
• Developed transformations with start routine, update routine and end routine and involved in teh creation and maintenance of DTP and Info Packages for loading data in to data targets.
• Worked with Start Routine, Field Routine, End Routine, Expert Routine and proficient in writing user exits.
• Created complex and customized SD (Order to Cash OTC) reports which specific business requirements in various modules like Sales Shipment report, Sales overview report, Billing document report, Top 10 Customers etc... Using Bex Query Designer etc…
• Extensively worked with open hub service to extract teh data from BI (DSO, Infocube) to External Systems.
• Created BEx queries for delivery in full on time reports, Inter Supply service reports and sales order reports.
• In order to generate reports and improve query performance created Aggregates on infocubes.
• Extensively worked on generating Indexes for infocubes in Business Accelerator to improve teh performance during teh data loads.
• Involved extensively in defining flexible queries using Hierarchies, Filters, Variables, Exceptions, Restricted Key Figures and Calculated Key Figures in BEx Analyzer to facilitate data analysis in a summarized fashion to give detailed level of information.
• Created formula variables, conditions, exceptions, exception aggregation, customer exit variables and structures for developing complex custom reports.
• Designed, Created, and implemented Universes, Interactive Analysis Reports, Web rich Client, Crystal Reports, and Dashboard designer Dashboards using best practices.
• Created User Profiles, Categories, Authorizations, Groups, and Autantications of Business Objects tool.
• Created Web Intelligence documents and published them to corporate documents using Infoview.
• Worked on Ad hoc reporting to teh end user in SAP BI BEx and Business Objects with Xcelsius 2008 reports & BI widgets.
• Using Live Office and Query as a web service as Datasources Generated complex Dashboards.
• Created different types of charts such as pie chart for easier analysis of teh data by using Xcelsius 2008.
• Documented project procedurals and solution manuals for teh future references.

Environment: SAP BI7.0, BO 4.0, XI 3.1 (Web Intelligence (Infoview)), SAP BI 7.0 BEx, Crystal Reports, Xcelsius 2008

Confidential, Ashburn, VA

SAP BI/BOBJ Consultant

Responsibilities:

• Involved in full life cycle implementation which include client requirement gathering and actively participated in blue printing of teh solution development. Participated in development of teh functional and technical specs.
• Responsible for development of data models and extraction of data from ECC source system into BI from Purchasing, FI and CO modules.
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), General Ledger (GL), Purchasing and customized them as per teh client requirements.
• Worked on FI-AR and FI-AP extractions from R/3 with enhancements made as required and enhanced teh data sources by using customer includes and also adding generic fields.
• Worked extensively with teh Logistics Cockpit customization for extraction of Sales and Inventory data using transaction LBWE. Done Complex Reporting both on Sales and Inventory data individually and by Combining teh data into a Multi cube for Reporting on teh combined data.
• Created custom DataStore objects and InfoCubes by enhancing teh business content also developed Standard DSO for Consolidation Layers.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system.
• Responsible for Data Modeling to correct teh models for a better loading of data. Created Line Item Dimensions, Number ranges for teh dimensions to enhance load performances.
• Created and Maintained DTP and InfoPackage for Loading and Monitored Process Chains for periodic loads of Master data and Transaction data from ECC system to Data Targets using various process categories and process types.
• Developed ABAP Routines for Transformations, start routines and end routines.
• Worked extensively with Start Routine, End Routine, Expert Routine and good in writing user exits.
• Developed BEx queries for reporting on InfoCubes, Multi Provider and DSO by defining Structures, Selections, Formulas, Exceptions, Variables, Navigational Attributes, Conditions providing drill down functionality in reporting.
• Created Price Purchase Variance (PPV) and Foreign Exchange Exposure (FX) reports. Created FI reports “Overdue analysis (Aging report)”, “Payment History”, “Due date for net payment”.
• Generated Cost Center “Internal Order” report which provides an overview of teh incurred costs and consumption quantities on an internal order group during teh reporting timeframe and teh fiscal year also developed reports such as Actual costs, Plan/Actual, Confidential /Actual.
• Designed, Created and implemented Universes, Interactive Analysis Reports, Web rich Client, Crystal Reports, and Dashboard designer Dashboards using best practices.
• Worked on Information Broadcasting to provide teh reports in EP as IViews and offline reports.
• Created reports based on different BOBJ 4.0 tools like WEBI and OLAP ANALYSIS depending on teh user requirement.
• Teh project involved development of reports using Business Objects and WEBI to cater Ad-hoc reporting needs.
• Generated complex Dashboards using teh crystal Xcelsius.
• Created teh reports using Business Objects functionalities like Slice & Dice, Drill Down, Cross Tab, Functions and Master Detail etc.
• Created Crystal Reports using Formulae, Parameters and Grouping functionality.
• Provided training sessions to teh business end user according to their requirements.
• Experience in coordinating with offshore team.

Environment: SAP R/3, SAP BI 7.0, Business Explorer (BEx), Business Objects 4.0, Crystal Reports.

Confidential, Nutley, NJ

SAP BI Consultant

Responsibilities:

• Involved in complete full life cycle implementation of SAP BI, which includes requirement gathering, realization, testing.
• Understanding teh business challenges and translating them into requirements and also involved in teh discussions with teh functional team to discuss teh scope of teh project.
• Implemented SAP BW for MM and FI/CO modules which involve teh designing of data flow from R/3 to BW.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, Info set, time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc. Also involved new features of SAP BI security like Analysis authorization.
• Loading of transaction data to teh business content Info Cube from Info Sources like 2LIS 11 VASCL, 2LIS 11 VAHDR for sales, 2LIS 13 VDHDR, 2LIS 13 VDITM for billing, 2LIS 12 VCHDR for order.
• Perform initial setup to load teh data into Logistic Cockpit tables and setup Job control to load data at specified intervals. Used Unserialized V3 update to implement Delta mechanism.
• Installed and customized relevant business content in FI-CO (Costs and Allocations) and MM (Inventory Management).
• Enhanced teh business content data sources like 2LIS 02 SCL, 2LIS 02 ITM and 2LIS 02 HDR by appending structures and populated teh fields using user exits
• Extracted data from MM module and uploaded teh data into teh procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL and activated teh appropriate Business Content cube.
• Created MultiCubes to support reporting requirements for HR modules - Organizational Management (OM), Personnel Administration (PA), Personnel Development, and Recruiting (RC)
• Validated teh BI data extracts from teh HR data sources related to OM, PA, PD, Time and Benefits, FI GL, AR,AP, MM, Purchasing data sources to various data targets in BW
• As a part of Production support involved in Debugging and monitoring load failures, Delta loads, planning ECC Outage for filling up of setup tables for Logistics (LO) extractors, Minimizing teh Init load and setting teh v3 jobs, etc…
• Designed and created Process Chains to automate teh data load and data Confidential administration.
• Worked on performance tuning includes creation of Indexes, Aggregates, Compression techniques and Partitions.
• Worked with BEx Analyzer to generate Queries and also published teh queries onto teh web using Free Characteristics and Restricted Key figures, Filters, Variables and Exceptions.
• Created FI Line item reporting of AP & AR source data using Data sources 0FI AP 3 & 0FI AR 3.
• Developed reports on teh MM cubes to check teh price variance for materials from different vendors.
• Created reports on SD cubes for displaying sales figures and incoming orders.
• Created many test cases and test scenarios for Unit testing, Integration testing of many BI reports.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, Selection Criteria and grouping such as order to cash, AR, AP reports.

Environment: SAP BI 7.0, Business Objects XI 3.1 (BOBJ), SAP ECC 6.0, Crystal reports, Xcelsius.

Confidential, Austin

SAP BI/BW Consultant

Responsibilities:

• Implemented SAP BW/BI 7.0 for SD, HR and COPA modules.
• Worked extensively on standard and custom defined LO extractors. Used LO extract structures and data sources in sales material management to facilitate teh data extraction to BW/BI system.
• Extracted teh data from Production orders and Process orders to analyze manufacturing orders.
• Worked on Data modeling techniques like Transformations, DTP’S, Data migration, ODS objects and structuring teh infoCubes as per teh requirements.
• Created and maintained COPA data sources.
• Extracted data from HR modules and uploaded teh data into HR Info Cubes for teh data sources 0HR PY 1 (Payroll data), 0HR PA BN 1 (Benefits), 0HR PA OS 1 (Staffing Assignments), 0HR PA CM 1 (Compensation Adjustments), 0HR PT 1 (Times for personal work schedule), 0HR PT 2 (Actual personnel times) and Labor Data and worked on transformations.
• Extensively involved in activating of Standard Info Cubes, Info Sources & Info Objects of HR Payroll Modules as per teh Client Requirements. Activated Info Cubes like Benefits 0HR PA BN 1, Payroll Data 0HR PY 1 in HR Modules.
• Improved Query runtimes by using Partitions, aggregates, compression and cubes on BW tables.
• Extensively worked on Transports of BI objects using Transport connection in DataWarehouse workbench.
• Extensively worked on user exits RSAP0001 for master data enhancements.
• Developed, generated and processed query definitions with teh BEx Query Designer. Designed documentation for queries using BEx Analyzer Reporting tool for presentations.
• Modified existing queries on various Info Cubes related to SD and HR-Payroll.
• Created reports in SD Open sales Order report, which covers all organization levels, delivery status, shipping figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Created report for Profitability Analysis (CO-PA) based on teh fiscal year.
• Used Crystal Reports for sales tracking and billing purposes.
• Worked on Go-Live support after implementing teh project.

Environment: SAP ECC 6.0, SAP BI 7.0, SAP BW 3.5, WAD, BEX Analyzer, Business Objects XI 3.1, Crystal reports.

Confidential

SAP BI Consultant

Responsibilities:

• Involved in extraction of Master Data, Transactional data from Flat Files and R/3 to BW.
• Loaded data into Sales customer cube (0SD C01), Sales overview cube (0SD C03). Used ODS to stage teh data before transferring teh ODS contents to teh Info Cube.
• Extracted data from MM module and uploaded teh data into teh procurement cube (0PUR C01) via 2LIS 02 SCL and 2LIS 02 ITM.
• Considerably Worked on LO extractor 2LIS 03 BF to extract data for Material movement into BW and enhanced teh data source with required fields.
• Created Multi-Cube from Delivery and Billing Info Cubes.
• Design, development and implementation of Process Chain for scheduling and sequencing master data and transactional loads.
• Involved in Development and Implementation of SAP BW objects. Worked with Info Objects, Info Cubes, ODS objects, Data Sources, Info sources, Transfer Rules, Update Rules, Info packages.
• BEx reporting (Structures, Reports, Advising query writers in performance issues, Quality approaches, enhancements).
• Customized extract structure 2LIS 02 HDR to add payment terms and reference fields to teh data being exported to BW.
• Created transfer rules and update rules, DTP to load vendor master, customer data to BW 3.5.

Environment: SAP BW 3.5, SAP BI 7.0, BEx

Confidential

SAP BW Consultant

Responsibilities:

• Participated in user meetings to discuss project concept, design, and schedule.
• Worked on administration workbench activating InfoObjects, infosources and infocube.
• Created and maintained Transfer rules and Updates rules to map teh fields of Data Source to Info Source and Info Source to Info Cube Respectively.
• Extensively designed delta loading strategies and designed Info Package groups and scheduled Info Package groups in batch jobs.
• Scheduling periodic data loads from SAP R/3 to BW. Advised delta enabled data load and prior use of ODS Layer.
• Developed teh Process Chain for transaction and master data. Teh process chain Steps involves Deletion of Requests from PSA, Deletion of Data from teh Data Confidential, Deleting/Generating Index, Loading teh data with prior Transfer Routines and Filling teh Aggregates for loading Transaction data into teh Cube.
• Used BEx Analyzer to build queries, queries with maps and charts and worksheets to access data from BW data targets.
• Defined and modeled queries to satisfy business analysis.

Environment: SAP BW 3.5, SAP R/3, BEx