Rupali Singh SAP BI/BW Consultant

Ph.no.610-***-****

Email acdd1u@r.postjobfree.com

SUMMARY

* ***** ** ** ********** that comprises around Five Years of SAP experience as a BW/BI (NW 2004s) and

Two Years of experience in SAP ABAP/4.

Successfully completed Six implementations in SAP BI/BW in multiple versions

Modeling - Strong working knowledge of modeling Info Cubes, Info Objects, DSOs, Info Sources, Update

Rules, Transfer Rules and Transformations, Multi Providers, Data Mart and Open Hub Service

Worked with standard SAP R/3 & ECC 6 in areas including SD, MM, DM, FI, CO-PA, SCM, HCM, DM, QM

and SRM.

Broad knowledge of the IT application development life cycle including initiation, requirements gathering,

design, build, test, implement and operations.

Worked from Functional/Business requirements to Design and Develop Multi Dimensional Data Model using BW

concepts of Extended Star schema and Data sources (Installation of standard data sources, Enhancing existing data

sources and creating custom data sources).

Developed, Configured and Customized Data Extractions from SAP R/3 and Legacy Systems. Created

Transformation, DTP, Transfer and Update rules, Routines in transformations.

Extracted from Flat Files and R/3 using extraction methods like LO-Cockpit, FI, CO-PA, and Generic

Extractions using function modules and enhancing the Extract structures based on the user requirement as

needed.

Extensively worked on complete life cycle implementation of BO XI 3.1 reporting with BI 7.0.

Created complex Webi reports by linking objects from different data providers and creating local variables in

the report.

Extensively worked in Business objects reporting, in the context of developing the Universe using the

Universe Designer and the Analytics using, Xcelsius, Webi and Crystal.

Designed and developed BW Reports primarily using BEx. Integrated SAP BW queries developed using BEx with

WAD and converted Bex Reports into Web Reports. Created Queries, Reports and Workbooks extensively using BEx

Analyzer (Business Explorer analyzer).

Created flexible reports using Restricted Key Figures, Calculated Key Figures, Exceptions, Variables and Conditions.

Overall BI Technical experience in Infrastructure, Databases (partitioning, Compression, Statistics, Aggregates

and BWA), Sizing, Loading and Extraction (specifically performance), Reporting performance,

Experienced in integration of SAP BI system with Business Objects.

Documented Test Plans and complete Unit Testing of Developed Objects and Reports. Worked with Quality

Assurance business resources to complete System and Integration Testing.

Troubleshoot issues and follow up with SAP (OSS-Notes).

Involved in SAP BIBO Reporting (Crystal Reports, Xcelsius, Web Intelligence).

ABAP/4 Programming - Worked on ABAP/4 programming for enhancing standard R/3 Data sources, Created

Function module data sources, creating Transformation, Transfer and Update Routines, and variable Exits in

BI/BW

TECHNICAL SKILLS

Operating Systems UNIX, MS-Windows XP/2000/NT/9x.

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

Data Warehouse Tools SAP BW 3.5, 3.1c, 3.0b, BI 7.0, DataStage7.0, Cognos, BO XI 3.1

Programming Languages ABAP/4, C, C++, Java.

Databases Oracle 10g/9i/8i/7.x, MS-SQL Server, DB2.

Web Technologies Servlets, Applets, JavaBeans, HTML and JavaScript.

GUI VB 6.0 Swings.

PROFESSIONAL EXPERIENCE

Shell Oil CO, Dallas TX March 2013 – Till

Date

SAP BW/BI Consultant

Roles & Responsibilities:

In the DLM ( Device Life Cycle management ) Phase-1 implemented successfully DM (Device Management ),

SC ( Supply Chain ) integrated with QM (Quality Management)for the business

Reporting requirements

Involved in deep dives with business users and business analyst to understand report requirements and

Developed tech specs for the reports

Responsible for designing the data model for Device Management, Supply Chain integrated with Quality

Management which are key modules for DLM

Activation of standard Info Cubes, DSO and definition of new Info Cubes and provide enhancement to Business

Content.

Handled Utilities Installation, Allocation, Device History 0UC_DEVICE, Device Location 0UCIODS12, Utility

Contract 0UCIODS05, Quality Management Inspection Results cubes (0QM_C05, 0QM_C04), Notifications

(0QM_C02) as a part of cross-functional SAP BW implementation.

Developed Custom data source using function module to extract ISU-Goods movement data from the table

SER03 and ISU specific equipment’s on table EQUI .

Developed a expert routine to pivot different MIC’s ( Master Inspection character values ) for each inspection

lot, serial number at operation level to inspection lot and serial number level.

Used Routines (Expert Routines, Start Routines, Update Routines) in Update Transformations to Update Key

Figures and Characteristics in the Info Cubes and DSO’s.

Designing, developing and supporting frontend enterprise reporting, query elements, user exits, Variables

through Business Explorer (BEx) Query Designer, BEx Analyzer.

Responsible for Creating/Enhancing BOBJ Universes using BW Bex Query’s, retrieving data from Universes

and Creating Complex, Multi-dimensional and Ad-Hoc reports according to client's requirements using, Web

Intelligence (WEBI).

Involved in performance tuning of queries, Data models, Data Loading and Webi Documents as per the best

practice.

Used ABAP for enhancing Data Sources for User Exits

Environment:

SAP BI 7.0, ECC 6.0, SC, DM and QM and BO XI 3.1.

Target Corporation, MN March 2012 - February

2013

SAP BW/BI Consultant

Roles & Responsibilities:

Transforming business decisions into functional requirements and thereby converting those into technical

specifications to formulate an appropriate multi dimensional design.

Involved in the design and design reviews of different reports like Ship Mode Analysis, in transit status,

Replenishment.

Involved in the gap analysis in the existing data sources and business content objects

Enhancing the data sources and creating the generic data sources as per the requirement.

Customizing the business content objects or design the Info Cubes, DSO and Multi Providers depends on the

requirement.

Creating Transformations to do lookups from various DSOs s to derive the key figures as per the business rules.

Testing the data from R/3 side to BW by using some test cases on DSO, Infocube and Query level.

Extensively worked on BEx Analyzer and WAD to create Queries, Variables, Structures, Exceptions,

Conditions, Calculated Key Figures, Restricted Key Figures, and Formula Variable.

Implemented Process Chain to schedule automatic data loads and apply business rules for loading data to

InfoCubes and DSO.

Conducted end user training on running various queries and reports in BEx and WAD on InfoCubes and DSO

InfoProviders.

Loaded data and monitored and the failed data packets were analyzed for Quality in PSA before sending into

Data targets.

Scheduling and Monitoring of DTPs and analyzing the reasons for frequent failures of DTPS.

Environment: SAP BW 3.5, ECC 5.0 SD, MM, FI\CO

Florida Power & Light Company (FPL), Juno Beach, FL January2011-February2012

SAP BW/BI Consultant

Roles & Responsibilities:

Performed analysis, design, development and Implementation of standard / customized info cubes and ODS

objects for business end-users in the application areas of SD and COPA.

Customized basic cubes like COPA Summary, Statically key figures cubes and created data sources and

extracted data from COPA.

Designed cubes to accept multiple Info Sources, Extracted Master data and Transaction data.

And worked with cubes customer, delivery and Billing cubes as per the client Requirement.

And enhanced the billing document header data source and extracted the data in to billing cube according to

client requirement.

Worked with Business Content as well as custom Info objects, Info cubes, ODS Objects, Transfer/update rules

Created aggregates to improve the query performance.

Involved in performance tuning of queries by maintaining Aggregates.

Created Bex queries for incoming orders per Month and open sales order reports according to client requirement

Created variables restricted, calculated Key Figures, Query Jump Targets (RRI) for the Queries.

Scheduling and Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.

Worked extensively on BEx Reporting by creating various queries based on user requirement using Variables,

Exceptions, Conditions, Calculated and Restricted key figures.

Worked on performance tuning by maintaining aggregates and partitioning in Info Cubes.

Environment: SAP BW 3.5, SAP R/3 4.7

Sky Info Tech, India January2010 - December2010

SAP BW Consultant

Roles & Responsibilities:

Involved in the analysis, development, and support of reporting initiatives within the firm, primarily using the

firm's SAP Business Warehouse (BW) application.

Developed SAP BW queries using SAP BW tools such as Business Explorer (BEx) and Web Application

Designer.

Consulted with users and project team members to gather, interpret, and document reporting requirements; work

with the SAP BW Development Team in creation of data model and data access methods to support reporting

projects.

Created Aggregates for the Info Cubes to increase the performance of Queries

Building Multi Providers for reporting purpose.

Used BEx Analyzer to create Queries and post them on the web. Customized web templates and created web

based reports.

Setup periodic Data loads from a legacy system (flat files).

Created Info Spoke to transfer data from Info Cube into ‘CSV’ files.

Developed reports using Business Explorer that had exceptions, conditional formatting, restricted key figures

and calculated key figures.

Environment: SAP BW 3.1c, SAP R/3 4.6C, SD and MM

IGL February 2009-December 2009

SAP BW Consultant

Roles & Responsibilities:

Customizing of extract structures for SD sales Data Source like 2LIS_11_VAHDR, 2LIS_11_VAITM,

2LIS_11_VASCL.

Worked on LO – Cockpit for maintenance of extract structures, maintaining Data sources, activating the update

Used PSA to stage the data before transferring the PSA contents into the Info Cube.

Used ODS to stage data before transferring the ODS contents to the Info Cube.

Created, maintained and configured Info Cubes to load data as per the Technical Specifications.

Worked on the partitioning and configuration of Info Cubes as per the client requirements and also for better

performance at runtime

Created indexes and aggregates for better performance

Extensively used BEx Query Designer to create queries using variables, filters, calculated key figures, restricted

key figures.

Used ABAP for enhancing Data Sources for User Exits.

Environment: SAP BW 3.0B, SAP R/3 3.1C, SD, MM

BHEL May2008-December 2008

Position : Team Member

Team Size :8

Roles and Responsibilities:-

Configuration of Various objects and actions

Understanding the business process enhancements of the client and gathering the information about business demands.

Requirement Gathering

Configuring the data as per Client requirement and Supporting Project manager in documentations

Working on Tickets assigned

Involved in end user training and preparation of end user manuals

Involved in unit tests

Attending meetings

Sky Info Tech, India January2007-April2008

HR Executive

Key Result Areas:

Handling recruitment & selection through job portal,

Training for new employees, maintaining roaster, documentation, candidate placement

Salary calculation

Induction & orientation, joining formalities

Exit formalities, leave records

Full & final settlement, reference checking, etc.

EDUCATION

Uttar Pradesh Technical University Master of Business Administration in Human

Resource and Finance

Lucknow University

Bachelor of science in Maths, Physics and Computer

Science

Contact this candidate