Vidhi Sharma

abmbu0@r.postjobfree.com

SAP Business Analyst BI

Cell: 703-***-****

Home: 703-***-****

[pic]

EXECUTIVE SUMMARY

. SAP Business Analyst with over 5 years of experience including two

full life cycle implementations.

. Experience in SAP HR,BW (Business warehouse) and SAP BI Netweaver

technologies.

. Participated in Public sector implementations.

. Participated in the Business Analysis, Blueprinting, Conceptual design,

Configuration, Go-Live and Post Go-Live including production

stabilization, maintenance and support.

. Extensive experience in gathering and analyzing business requirements

for conceptual design and coordination with ABAP development team for

customization and implementation of the same.

. Experience in the development of Business Process model, end user

training, and documentation .

. Prepared test scenarios and test cases, conducted unit and integration

testing within SAP to ensure all components fit together properly.

. Ability to bridge the gap between Technical and Functional teams in SAP

Projects.

.

TECHNICAL SKILLS:

Operating Systems: Windows 9x/ NT/ 2000, UNIX, Linux..

Languages: Visual Basic 6.0, C, C++, VB.NET, ASP.NET, C#, PL/SQL

Web Development: Html, XML, JavaScript, and VBScript

Database: MS SQL Server, Oracle, ERP.

Design & Development Tools: Microsoft Front Page

Application Software SAP R/3 4.6,ECC 6.0

HR,FICO,ABAP,QuickBooks PRO 2007

SAP Netweaver

SAP BI Skills

. Front end Reporting:

Gathered reporting requirements from business users and analyze the

possible sources of data for reporting.

Business Intelligence reporting understanding the analytics

relationships with the cubes.

Designed and developed Queries using BEx Query Designer BEx Web

Application Designer

Excellent Knowledge of workbooks and created custom queries using

conditions calculated key figures restricted

key figures exceptions variables & structures and created aggregates for

frequently used queries.

Analyze existing reports to evaluate them with changes in business

requirement

Change / Enhance reports to accommodate additional business requirement.

Write test cases and Testing the reports.

. Back end Data Modeling:

Analysis design implement and support of complex data extraction

transformation and load processes to support reporting needs

Build and enhance BI objects that include InfoObjects InfoCubes DSO Data

Sources Transformations

Extractors for Master and Transaction Data Multiproviders Aggregates and

Process Chains.

Data Model and design per best practices of SAP BI.

Front end BPS Planning

Developed Planning Layouts GUI based and Web based of various

complexities

Back end BPS Planning objects

Build and enhance Transactional InfoCubes BPS Planning Variables

Planning Functions and Global Planning sequences.

BI Content Activation:

Analyzing of BI Content and activation of required objects.

Extraction & Transformation:

Configured Transformations & DTP Processes and activated New Data

Sources to extract from SAP systems and Flat Files.

Configured Process Chains to extract data from source systems

Administration of Info cubes:

Performed Compression and Partitioning of Info cubes.

Created & Updated of Index of fact table

Testing

Written Test cases for BEx Reports including negative test cases.

Written test cased for BPS Planning Layouts and Planning functions

including negative test cases.

Performed testing in different test phases..

PROFESSIONAL EXPERIENCE

Client- Shipping Corporation of India,Mumbai

Dec 09 to May 2010

Company-ASAP Infosystems

SAP BI Consultant

Environment: ECC 6.0 SAP BI 7.0 FI AR AP FSCM.

The Shipping Corporation of India a Government of India undertaking was

established on 2nd October 1961,today has a significant presence on the

global maritime map with an annual turnover of about Indian Rs. 36.5

billion (approximately US$ 820 million). Starting out as a marginal Liner

shipping company with just 19 vessels, the SCI today has metamorphosed into

a giant conglomerate having 83 ships of 4.6 million DWT with substantial

interests in 10 different segments of the shipping trade. In addition, it

manages 53 vessels of 0.119 million GT (0.063 million DWT) on behalf of

various Government Departments and other Organizations.

Responsibilities

. Responsible for all aspects of data loading, modeling, spoking, and

reporting in BI and data-staging (SQL-based) environments.

. Responsible for supporting a third-party.net-based interfacing product

(iNet.BI) that connects SAP BI (and R/3) to Microsoft BI platforms and

tools. Developed a program that extracts delta data from infocubes

without using the Open Hub. Trained clients on implementing the

interface. Customized client's Z-reports in order to use as

extractors. Developed a report to interface security authorization

objects for use in Microsoft environments (SSAS).

. Assisted the Buisness Analyst in preparing Blueprint.

. Prepared Functional Specifications for ABAP team to understand worflow

of leave request.

. Prepared Data Templates for Data Migration.

. Created Leave Workflows to implement Leave Request and Approval

Process in ESS,MSS.Having knowledge of iViews,Pages,Roles and Worksets

in ESS and MSS.

. Understand the interaction of SAP Enterprise Portal, WebDynpro

Services and the SAP Backend System and their main functions in the

SAP ERP 6.0 technical infrastructure.

. Have sound knowledge of Payroll and Time Schemas,rules,functions and

operations.

. Have worked on Personnel Administration,Organizational Management and

Benefits.Understand the interfaces and infotypes used to integrate

HCM.

Client-Nalco,Chicago, IL

Sep 07 to Nov 09

Company- NetMatrics Inc. Permanent Role

SAP Business Systems Analyst

Environment: SAP BI 7.0 SAP ECC 6.0

Nalco is a global fledging water treatment company with presence in 130

countries and with over 20,000 employees.

Worked in complete life cycle project from 'kick off' to 'go live' Designed

work plan, work around for the business needs that cannot be fulfilled by

the standard SAP.

Responsibilities

. Extensively involved in design and development of the following

modules: HCM AND BI version 7.0.

. Created Functional and Technical Designs.

. Extensively involved in customizing the standard BW business content

to pull information from SAP ECC 6.0 system.

. Extensively used User-Exits to Customized Business Content Extractors.

Activated and Installed Business Content.

. Created Hierarchy Sets in ECC and Transferred to BI for Company Code.

Involved in the Creation of Authorization Objects and Roles using the

new Authorization Analysis concept for locking down data.

. Created and activated transfer structures transformations transfer

rules communication structures update rules (both DSO and Info-cube

level).

. Configured and mapped XI for transition between ECC 6 and Netweaver

ECC 5.0 systems. .

. Handled high severity critical issues while on support.

. Resolved assigned tickets within the specified SLA.

Client- Annheuser -Busch Companies, MO Jan 06 to Aug 07

SAP BI Functional Analyst

Company-NetMatrics Inc. Permanent

Anheuser-Busch is one of the biggest beer manufacturing industries in USA.

Involved in SAP implementation using the ASAP methodology.

Responsibilities

. Deployed BI content for FI-GL and FI-AP and CCA.

. Converted and mapped legacy material movements with SAP to create a

normalized model of SNAPSHOT and MOVEMENTS infoproviders.

. Deployed Stock Ledger Report from Inventory and Sales for finance to

match the GL reporting.

Developed common queries to query against history and current ERP

data.

. Extensively utilized Trasformations and DTP functionality for data

staging along with classical infopakage scheduling.

. New feature of "write optimization" DSO/ODS was used to reduce the

space/process-time of legacy history data.

Client-Motorola, Phoenix

Feb 05 to Dec '05

Sap BI Analyst

Company-NetMatrics Inc. Permanent

The project emphasis on Production support and implementation of SAP It is

a Semi Conductor Product Sector.

. Extensively involved in gathering business requirements to Go-Live

operations for Project.

Involved in design development and testing of data models across the

landscape based on business requirements.

. Conducted weekly team meetings with onsite and offshore BI teams to

coordinate development efforts among team members.

. Conducted weekly status calls with onsite and offshore Basis teams to

resolve ongoing issues and deadlines for tasks assigned.

. Represented the BI team in various Project meetings to provide status

updates.

Responsible for reviewing the functional and technical design

documents mapping documents

maintained by team members and maintained the same on SAP Solution

Manager.

. Actively involved in design and proposals for data extraction from ECC

datasources and through Flat Files.

. Developed functional specifications for Generic extractors to retrieve

data from source systems to accommodate business requirements.

. Designed and built custom infoobjects and custom data models

(InfoCubes ODS Multi-providers).

. Developed strategies for nightly/weekly/monthly production data loads

using Infopackage groups and scheduler.

. Designed Process chains for scheduling of data loads.

. Worked on BEX Query Designer in designing queries using filters

variables navigational attributes

to facilitate flexible detailed drill down data analysis to the

required level of information.

Education

Bachelors in Computer Science from MDS University(2001)

Post Graduation Diploma in Computer Application from Rajasthan

University.(2003)

Oracle Certification from NIIT.(2004)

MBA in Project Management (Northern Virginia University) (Jan 07-Sep 08)

Contact this candidate