Senior SAP BW Consultant

SUMMARY:
Over 9 years of SAP experience which includes over 7 years in SAP BW full life cycle implementations with SD,MM, FI/CO modules and 2 years in ABAP.
Expert in transforming business decisions into functional requirements and thereby converting those
into technical specifications to formulate an appropriate multi dimensional design/planning model
after assessing against the usage of standard SAP delivered Business Content.
Expertise in SAP BW Architecture including Extractors, Data Sources, Info Objects, Info sources, ODS Objects, Info Cubes, Info Packages, and Hierarchies.
Expertise in SAP BW7.0/3.5/ 3.1C/3.0B/2.1C configuration and Query development.
Proficient with planning, Gap analysis, design implementation, trouble shooting, performance tuning , production support and user training of SAP Business Information Warehouse.
Expertise of various data design models - Multi Dimensional data modeling/Star Schema and Extended Star Schema models.
Proficient in Performance tuning using Aggregates/BIA, Rollup, Partition, Compression and BW Statistics.
Written complex Update routines, Transfer routines, Transformations(start and end routines).
Worked with Master and Transaction Data User Exits on R/3 and Variable exits
Proficient in Data staging using ODS before transferring data to required data targets
Experience in creating Views, Generic Datasources in SAP R/3
Worked on Front End, BEx (Business Explorer) Analyzer, BEx Broad Casting BEx Query Designer Queries, Workbooks, Tabular Reporting and Web Reporting(WAD)
Experience in SAP R/3 modules: Sales & Distribution (SD) and Materials Management (MM) and Finance and Controlling (FI/CO)
Experience in Data-Modeling, Delta Extraction, Generic Delta Extraction, Data Loading Scheduling,
Designed documentation standards for Technical and Functional Specs and test plans for UAT, Integration testing
Involved in end-user training and documentation.
Worked on Integration of BO with SAP BW
Worked as a Lead in Matrix environment
Excellent team member with the ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation.

TECHNICAL SKILLS:

Hardware: SUN E10000 IBM RAVEN IBM RS-6000 SP2 (AIX)
HP-9000 (HP-UX) IBM PC
Operating Systems: UNIX (Solaris, AIX, HP, SCO), MS-DOS, MS-WINDOWS 3.11/\'95/98/NT
RDBMS: ORACLE 7.1, 8, MS SQL Server, MS Access and DB2
ERP: SAP R/3 Version 3.1H, 4.6
Languages: ABAP/4, C, JAVA

PROFESSIONAL EXPERIENCE:

Confidential, CA
March 09 --Current

Team Size: 10
Environment: SAP BI7.0, ECC 6.0
Role: BW ARCHITECT

Designed and developed reporting solutions in the areas of Procurementand Finance .
Developed critical Spend Analysis Reports.
Build the Custom Cubes, Custom DSO’s and generic extractors for capturing the Total Spend at Adobe
Created Process chains for Master data and Transaction data Loading.
Enhanced standard LIS extract structures and Master Data objects and extractors
Worked extensively on Infosets to provide reporting solutions of cross functional areas.
Worked on end routines and start routines.
Worked on Performance tuning of queries.
Involved in preparing the training material for end users as well as providing training to end users. Resolving discrepancy between the legacy reports and BW reports apart from improving the query and load performance constituted integral part of responsibilities.
Working with Business and Power users to understand their unique reporting requirements and provided solutions
Was involved in integrating BI and Business objects.
Involved in feasibility analysis of BI/BO integration, performance of exposing Query vs. Multiprovider to the Business objects universe, Analysis of Variables, Hierarchies in Business Objects.
Involved in creating Spend Analysis reports in Business Objects.

• Created the dashboard reports using Business objects to illuminate the business by providing
• consolidated views of Key metrics.

Confidential, CA
Nov 07 Feb09

Team Size: 15
Environment: SAP BI7.0, ECC 6.0
Role: Senior BW Consultant

Designed and developed reporting solutions in the areas of Sales, Procurementand
Finance FI-AP FI-COPA.
Worked on various Performance improvement initiatives to improve the load times and appropriately handling large volumes of data by partitioning and using parallelism.
Enhanced standard LIS extract structures and Master Data objects and extractors
Developed Generic Delta extractors.
OSS notes have been applied to fix issues.
Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
Created Start and End routines for providing custom solutions.
Created different types of variables and enhanced existing variables thru customer exits
Created jump Queries from Analytical reports to the Info-set queries created on top of the detailed operational data store objects and master data objects.
Created very complex reports using cell editor for the required structural requirements in query Designer.
Worked extensively on Infosets to provide reporting solutions of cross functional areas.
Exposure to BO and SAP BW integration

Confidential, CA
Jun 07 Nov 07
Team Size: 4
Environment: SAP BI7.0, ECC 5.0
Role: BW ARCHITECT

Developed a proof-of-concept for BI7.0 implementation of Sales and Billing Modules,
Introduction of New Back-End features and Front-End features to users.
Developed prototype and presented the demo session for user acceptance.
Analysis of FI requirements and designed solutions for reporting.
Enhancement of standard logistics and finance extractors and created BW objects
for providing cross-functional reporting solutions using BI7.0 features.
Created Web Templates Using WAD.
Worked with BEx Report Designer to create formatted reports.
Worked with BEx Information Broadcaster to distribute the right information to the right
people at the right time.
Trained Users with new BI 7.0 reporting Functions.

Confidential, OR
Feb 06- March 07
Team Size: 3
Environment: SAP BW 3.5C SAP 5.0
Role: Technical Lead

Involved in Full Life Cycle implementation of SAP BW 3.5 system.
Responsible for providing estimates, creating and managing project plan.

Worked in requirement gathering, blueprint design and complete development activities for a large number of very complex reporting requirements
Installing business content, Configuration of BW system and setting up source system connections
Worked on SD and FI Modules.
Created Custom Cubes and extractors, enhanced standard extractors and ODS Objects.
Worked on the complex Design of creating & Custom ODS Objects and extracting the data in their respective cubes for Billings, Booking and Backlogs.
Extensively used ABAP code in writing user exists, start routines, transfers rules, update rules and variable exits.
Developed Complex Reports in BBB area (Bookings, Billings, and Backlogs).
Extensively used BEx Analyzer, created queries with variables, restricted/ calculated key figures, conditions, exceptions, filters, RRI feature etc.
Created Jump Target Queries from Summary level to Detail reporting.
Designed and developed complete data loading procedure using process chain and events.
Involved in preparing the training material for end users as well as providing training to end users. Resolving discrepancy between the legacy reports and BW reports apart from improving the query and load performance constituted integral part of responsibilities.
Working with Business and Power users to understand their unique reporting requirements and provided solutions

Confidential, CA
April 04 -Sep 05
Team Size: Varies
Environment: SAP BW 3.1C, BW 3.5C SAP 4.7, ECC 5.0
Role: SAP BW Consultant

As a SAP Employee actively worked in different kinds of projects in different Modules SD, PP, MM, and FI at different phases of BW project Implementation.
Pro active participation Resolving issues and to improve performance

Confidential,
The main objective of this project is to reduce the time for ETL process which was taking more than 5 to 6 hours and to retrieve the reports fast.
Configured the BW System to improve performance of data loads and query response times
Design changes have been made for ease of maintenance
Enabled delta loads for FI extractors to avoid full loads which could take several days when they were few changes in data.
Created Custom Delta extractor
Written complex routines improve the ETL Process.

Confidential,
The project involves implementation in the areas of business process improvement / design, change management, end-user and project team training, benefit realization, system development, technical
infrastructure, program management, quality management / integration, business warehouse and portals

Created Custom Cubes based on reporting requirements.
Enhanced standard Data Sources and Enabled Delta Loads.
Generic data extractors to extract/cleanse and transform the data to suit the Business Warehouse model.
Involved in designing the data loading procedure using process chain and events
Created Queries / Workbooks using SAP Exit to create variables like calendar month, previous quarters etc
Worked extensively with flat files for master data and transaction data to meet the End-User Requirements
Performance tuning of Backend and Frontend.
Worked with the process team to create functional specifications for a large no. of development objects, drive each development object technical design and construction in SAP BW. Contributed in resolving all functional/technical issues, managing test problem, scope change request etc.
Prepared detailed testing strategy, integration test plan and user test plan. Coordinated project testing activities with users globally, Participated in numerous user training sessions

Confidential, WA
(IBM Project)
Nov 03 April 04
Team Size : 6
Environment : SAP BW 3.1C, SAP 4.7
Role : SAP BW Consultant

Created Custom Info Cubes and Generic Delta Extractors.
Enhanced Standard Info Cube as per client requirement.
Created Custom ODS objects.
Created Info Packages and created ABAP routines to fill selection criteria dynamically.
Scheduled and monitored data loads in production.
Installed and used BW statistics for performance tuning.
Written Start routines, transfer routines and update routines.
Enhanced extract structures 0FI_AP_3 with Check no, Void reason code and Idoc no,
Created variables using for YTD (Year to Date), QTD (Quarter to Date), Prior Year to Date,
Prior Quarter to Date values to display in Queries using variable exit.
Created and scheduled process chains for Master Data Loading, Transaction Data Loading,
And for Delta Transaction Loads.
Created ABAP program to delete previous ODS data load request with the same selection
Criteria.

Confidential, GA
July 02 Nov 03
Team Size : 5
Environment : SAP BW 3.1C/2.1C, SAP 4.6C
Role : SAP BW Consultant

Involved in the design, development, testing and implementation of Business Warehouse.
Used star schema model in designing info cubes.
Extensively worked on Administrative Workbench for Configuring, Customizing,
Monitoring and Scheduling.
Defined, Analyzed Info Cubes and maintained Info Objects and ODS objects in SAP BW.
Created Aggregates and Multi Cubes for performance and efficient utilization of data.
Extracted data from SAP, Non-SAP (SQL Server) and flat files.
Set the extraction process using LIS, LO execution cockpit and V-3 updates.
Scheduled and monitored the data loads in production.
Monitored the LO Extraction Cockpit and the Delta Queue Maintenance.
Performed detailed analysis to improve the performance using Info Cube Compressions and Aggregates.
Written complex transfer and update rules.
Designed data model and Info Cubes for SD, FI and CO modules.
Worked with Master and Transaction Data exits in SAP R/3.
Used BEx Analyzer to build queries, worksheets and accessed data from BW data targets.
Generated reports using BEx (Business Explorer) with exceptions, conditional formatting, restricted and calculated key figures.
Developed different queries based on calendar day week, month and year in order to obtain any combination of reports from the info cubes.
Published queries on the web using BEx Web Browser. Worked on InfoSet queries for reporting on master data and calculated key figures.

Confidential,IL
Feb 02 July 02
Team Size: 7
Environment: SAP BW 3.0B SAP 4.6C FI, MM, SD
Role: SAP Consultant

Evaulated BW 3.0B features and functionality
Created custom InfoCubes in Sales, Purchasing, Procurement as per client specifications
Worked on Crystal Reports Integration.
Worked on Extract Structures using SBIW transaction.
Maintained InfoObjects, Data Sources, Info Sources, Aggregates, Communication
Structures, Transfer Structures.
Coded complex Transfer Rules, Update Rules.
Scheduled Info Packages, deleted and created indexes using Process Chain.
Extracted data from flat files, SD, MM, FI InfoSources into multiple ODS objects
And to InfoCubes.
Publish reports on Web using both ITS and BW Web Templates

Confidential,MN
Sep 00 Feb 02
Team Size : 10
Environment : SAP R/3 4.6C
Role : SAP Consultant

Development of reports, batch input programs as ABAP technical consultant in the areas of SD, MM and FI modules

Confidential, MI
Jan 2000 Sep 2000
Team Size : 10
Environment : SAP R/3 4.5B
Role : SAP Consultant

Responsible for the low-level design, technical specifications, coding, Testing and implementation of the following
Configured and customized a real time project for a leading bearing manufacturing company. Working knowledge in ABAP/4 Workbench Tools, Interactive Reporting, ABAP/4 Query, SAP Script, and Batch Data Communication (BDC).
Acquired in-depth knowledge in SAP R/3 module and was working in project environment for customizing Materials Management related functions. Enhanced existing BAPI’s according to requirement.

Programmer Analyst
May 99 Jan 2000
Was involved as a Programmer/Analyst in Design, Development and Testing of different Business/Engineering Application Software for various clients in Mainframes and SAP.

Education:
Post Graduate Diploma in Computer Science
Bachelor of Science