Sanyukta Srivastava

acg9a4@r.postjobfree.com

818-***-****

PROFESSIONAL SUMMARY:

A total of 8 years of experience as SAP BW consultant, indulging in the design, development, implementation

and maintenance of the Business Objects and SAP BW/BI Client/Server environment.

SAP BI 7.0 Certified.

SAP HANA 1.0 Certified.

8+ years of experience in SAP including two complete life cycle implementation of projects and

project planning, designing, developing in both SAP Business Objects (WEBI and Crystal) and SAP

BW/BI.

Experience in developing front end reports using Business Explorer (BEx), WAD, Visual Composer, SAP

BO XI 3.1 – Universal Designer, WebI and Xcelsius.

Dynamic SAP R/3 Techno Functional Consultant with extensive experience on SAP Business Objects with

emphasis on BW and well acquainted with HCM, FI/CO, SD and MM Modules.

Involved in 2 full life cycle implementations which includes 1 Netweaver 04s (BI 7.0) and 1 full life cycle

implementations of BW 3.x.

Business Modules: Key Involvement in the configuration of cross application modules HCM, SD, MM, PP

(SCM Supply Chain Management) and FI.

BW Architecture: Strong association with the architecture team in my 2 previous client work places.

Participated in the discussions regarding planning and implementation of the overall BW landscape and

architecture.

Data Modeling: Experienced with creating, modifying and activating Info Objects, DSOs, Info Cubes and

Multi Cubes according to the reporting requirements.

Data Extraction: Expertise in data extractions from Back end Business Warehouse Component Extractors

like LO Cockpit and Generic Extractors.

BW Reporting: Expertise in BEx Analyzer, Query Designer, Web Application Designer, Info Set queries,

Jump Analysis using RRI. Hands on experience with Front end Business Warehouse Components, which

involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted

and Calculated Key Figures.

Performance Tuning: Proficiency in query and load performance improvement using Aggregates, Rollups,

Indexes, Partitions and Info Cube Compression techniques. Evaluated statistical performance on OLAP

using BW Statistics.

BW Operations: Experience in the modeling and maintenance of Event & Process Chains.

BW Enhancements: Experience in writing ABAP/4 code for User Exits / in Transfer Rules, Update Rules and

Transformations to cleanse, transform and load the data to the data target.

BW Transports: Involved in testing the extractors, data loads and reports before going into production &

transporting the BW objects from Development to Quality and subsequently into Production.

SAP Business Objects Trained in Crystal Reports, Xcelsius, Voyager, WebI, and Universe Design.

Knowledge of Business Object tools, Voyager, CMC, Web Intelligence, Xcelsius and Polestar

BW Security: Possess a good understanding of the security constraints necessary in the BW/BI

environment. Have considerable knowledge in the creation of authorization objects, roles and role groups.

Assisted the security team in establishing effective user authorizations.

Possess a very strong technical foundation and the ability to work in a collaborative atmosphere with end

users and members of the development team. Excellent communication skills, including oral, written, and

interpersonal qualities are my assets.

Excellent production support and debugging skills, experience is resolving trouble tickets, monitoring

loads, enhancements and change requests.

Experience in integration of SAP BW and Business Objects

Educational Background:

B.E Computer Science and Engineering, IMS,Ghaziabad, U.P, India.

CERTIFICATIONS:

• SAP Certified in BI 7.0.

• SAP certified in SAP HANA 1.0.

• SAP Business Objects Trained in Crystal Reports, Xcelsius, Voyager, WebI, and Universe Design.

• SAP Trained in SAP Integration with Business Objects.

TECHNICAL SKILLS:

ERP: SAP R/3 ECC 6.0.

SAP Modules: HCM,FI/CO, PP, SD and MM.

Data Warehouse: Netweaver’ 04s (BI 7.0), BW 3.5, 3.1C, 3.0B.

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

Interfaces: Workflow Enhancements BAPI.

Operating Systems: DOS Windows 95/98/2000/XP Windows/NT

Development Tools: MS Office Suite Visio MS Project.

Company: Millennium Software, Inc

SAP BI BO Senior Consultant (Dec’13 – Till Date)

Client: Warner Bros.

Company: Millennium Software, Inc

Location: Los Angeles, US

Key Deliverables:

• Monitor performance of nightly jobs - Optimize data loads, index management, aggregates, query

optimization

• Perform hands on duties to develop custom extract data from ECC to BW, CRM-IPM to BW build

data stores and cubes.

• Responsible for the data flows required to extract, transform, cleanse, and move data across multiple

data sources.

• Build Business Warehouse backend objects: InfoCubes, Data Store Objects, InfoSets, InfoObjects,

Transformation Routines, Process Chains, Job Scheduling, user exits when required.

• Good experience on data reconciliation procedures

• SAP BI 7.3 query and workbook development with good understanding of SAP BI data warehousing

concepts

• Experience on developing BEx and Web reports

• Good communication and documentation skills

• SAP Finance and CRM functional knowledge with regarding to BI reporting is preferred

• Design cubes and queries to provide the users the best possible experience.

• Responsible for detailed knowledge of data coming from SAP modules: FI, CRM-IPM

• Identify data discrepancies and data quality issues, and work to ensure data consistency and

integrity.

• Define queries using the BEx Analyzer & Business Objects Web Intelligence to deliver SAP and non-

SAP BW information in an organized fashion

• Create, maintain and update technical documentation for data warehouse processes and dataflow

• Mentor report developers to find solutions for reporting requirements

• Strong interpersonal and communication skills including a willingness to work with end users,

business analysts, and business leaders in defining requirements for reporting and future planning

• Stay abreast of current technologies and recommend strategic changes to identify and implement

improvements that drive measurable business results.

Key Areas:

• Contract Management

• Billing

• Revenue Recognition

• Accounts Receivables

• SPL

• TAX

• CRM UI Reporting

• Contract Life Cycle Management:

• License Sales Order management

• Billing

• Revenue Recognition

• AR

• SPL

• Supply chain Management

• BW

• BO

Company: HCL Technologies Limited

SAP BI BO Consultant

Client: GE NBC Universals

Location: London U.K and Los Angeles, US (Nov’07 – Dec’13)

Key Deliverables:

• Managing all activities related to bidding and lead development as a Business Developer

• Leading a Team of 7 Consultants across diverse modules such as HCM,FIGL, CCA, PCA and Sales

and Distribution.

• SAP BI 7.0 Architect involved in creation and review of Data model for performance and space

optimization.

• SAP BI HCM Implementation for Headcounts, Benefits, Payroll Postings, Personnel

Administration, Organization Management, Learning Solutions, Performance Management and

Compensation Management.

•

• Managing all activities related to bidding and lead development as a Business Developer

• Creation of BO reports in WEBI and Crystal.

• Created Online Report for BI Load Status. It automated the manual work and made the process more

efficient.

• Worked on APDs’ for PCA

• Worked on APO Reporting Demand Planning, Backorder Information and Forecast Accuracy

datasources.

• Copy Down Functionality of FI AR

• Worked on POC for HCM Implementation. Worked in a very complex Landscape in which SAP BI is

integrated with various other modules like Finance, Supply Chain, APO, and R3.

• Business Analyst involved in initial requirement gathering and business study during the project start.

• Created Recon Reports to reconcile HCM Learning Solutions data and Performance Management data.

Worked exclusively on BI Accelerator in implementation projects in performance

improvement phases of Project.

Handling Structural Authorisation for HCM data confidentiality along with Analysis

Authorisation.

Background

GE was established in 1892, it is the merger of Thompson Houston Electric and Edison General Electric. It is placed

7th in Fortune 500 companies. It is among the worlds largest and Diversified Corporation in world. It primarily

operates at Europe (16 Geographies) and US. It employs around 316000 personnel with YOY revenue of US $149702

millions.

NBC is among the Top 10 companies of GE, The project deals with Financial systems with a tight Integration of other

modules like BW, APO, SRM, R/3 etc.

The project is based in Europe (16 Geographies), US and Canada and offshore work is taken care at GE GDC

Noida.

Responsibilities

Worked in a very complex Landscape in which SAP BI is integrated with various other modules

•

like HCM,Finance, Supply Chain, APO, and R3.

HCM and Finance are acting as a backbone of the project.

•

GE NBC Universal is a project based on HCM,Financial systems and Supply Chain

•

Management.

The project added Auto close project and Project Juice as its two new Assignments.

•

Kintana is the Online Ticketing tool for Logging Issues.

•

Key Areas

Business Objects:

1.

• WebI Reports for HCM (Payroll Postings, Headcount, OM, PA,LSO,PM,Comp Mgmnt),

• Crystal reports for HCM, FI, SD modules

• Universe Design

• BI Backend Design for HCM Master and Transactional Data

Finance:

2.

• Profit Centre Accounting (PCA),

• Cost Centre Accounting (CCA),

• Special purpose Ledger (SPL),

• General Ledger (FIGL).

• Intercompany Ledgers

3. Supply Chain Management (SCM)

• Special Purpose Ledger

• Trade Spend

• Pricing

• Material Movement

• Sales Order

Human Capital Management

4.

• Payroll

• Headcount

• Benefits

• Personnel Actions

• Learning Solutions

• Performance Management

• Compensation Management

5. Interfaces

• I140 interface

• I150 Interface

• Cinram

• Point of Sales

6. APD

• I206 & I206_E

SAP BI Consultant

Client: Duestche Bank (July’07 –Oct’07)

Deliverables and Value Adds to Customer:

• Created Online Status Reports of Process Chains. The work was done Manually Earlier and consumed 4

Man Hours Daily. Made the status available on Portal, Just a click away

• Added new Customers to Existing Canadian Interfaces, and made it Generic. Earlier the addition used to

travel through a complete enhancement cycle and took 2 Weeks per Customer. Now the Process is Generic

and a Task of 2 Hours.

• Copy Down Functionality of FI AR.

• APD’s For PCA

• Process Chain Runtime Analysis

• BW Cockpit. A centralised Portal for BI day to day Tasks.

Background

DB FSR Rollout is a project of Deutsche Bank for their Financial Systems Renewal of five countries i.e. Singapore,

Indonesia, Korea, Hong Kong, Philippines. It had integration of three parties i.e. Data loading through Informatica,

Data Modeling and Query Designing through SAP and Report layout or Delivery to the customer through

Cognos.The designing in SAP was done using T4 templates. Data modeling was done using SAP BI 7 and Reporting

was done using SAP BI 3.5

Responsibilities

• Creation of LDS attributes using Global Data Standards.

Expertise on Data modelling which involved creation of Data Store Objects, Info Cubes, Multiprovider and

•

Data loading to Data targets and Virtual Providers

Developed APO Reports Demand Planning.

•

Worked on APO Supply Network Planning Reporting requirements.

•

Developed Web Templates with Logo.

•

Expertise on Reporting of all three types i.e. Cell Based, Transactional, Adhoc using:

•

Query Designer for designing of queries as per Cognos’ requirement using features of Query Designer

•

such as access for Third Party Tools, Structures, Free Characteristics, Filters, Calculated Key Figures,

Restricted Key Figures, Conditions, Exceptions, Formula Variables, Customer Exits and User Entry/Default

Variables, Key Date Selection.

• Display of Output of Reports using Web Analyzer, BEx Analyzer

• Designed Multicube based on Sales, Delivery, Billing cubes.

• Mapping R/3 fields to BW Infoobjects in transfer structure during the creation of transfer rules

• Creating communication structure and infosources, Creating update rules

• Assisted in performance tuning for loading data and improving the query response times for material

movements project using aggregates, database partitioning, indexing and creation of database statistics

techniques.

• Created Queries by defining rows, columns and free characteristics providing drill down functionality in

reporting using BEx. Worked with users to understand their reporting needs.

• Experienced in working with Web Application designer to publish reports on company Intranet.

• Created Reports on Sales of Commercial Products and chargeback’s for reimbursements.

• Trained users in reporting functions

Deliverables

Delivered Cell Based Reports to the Customer for different Regions

Worked for Transactional Reporting for Singapore

Delivered KT to Internal Team

Performance tuning methods such as partitioning aggregates creation, compression,

Indexing of Info cube.

Customization at R3 in terms of creation of generic datasources, enhancement of

standard extractors at LO Cockpit, extract structure and function enhancements

Customization at BW in terms of Enhancement of Infocube, look ups, data archiving,

creation of multiproviders, data marts.

Concepts of Multiloading, loading of data from various external systems such as legacy, flat

file etc.

Concepts of Infospoke for providing data present at BW Infocubes to external system such

as SQL etc.

End to end expertise at BW front BEx Analyzer, BEx Designer used for reporting.

Single handedly completed successfully various maintenance projects, achieved remarkable

Client appreciation on automation of Data loads for long run through process chain along

with email notification for success/failure of data loads.

Performance Testing and reporting based on DW Statistics Info cubes and reports.

End to end expertise of User security i.e., concepts of roles and authorisations at various

levels and with diverse requirements.

SAP BW Consultant

Client: Cadbury Schweppes (Jul’06 –Jun’07)

Responsibilities:

As a team member, involved in Requirements analysis, Data Modeling and technical implementation.

•

• Involved in the design and development of Profitability Analysis (PA) Cube in Controlling (CO) and Profit

Center Accounting (PCA) as part of SAP FICO BW implementation.

• Worked with FI Cubes to enhance the performance (Modeling, Data load) from other systems and did

currency conversions for Country specific.

Worked on generic data extraction in COPA.

•

• Activated and Customized profit center accounting cubes, accounts payable cubes accounts receivable

cubes.

Extracted Line Item data from GL, AR and AP.

•

Modified standard Info sources 0FI_AP_4 and 0FI_AR_4 and populated the enhanced fields.

•

Managed and monitored data loads with full update and Delta mechanism.

•

Worked on Info set Query extraction on tables from SAP R/3.

•

• Developed BW reports using BEx Analyzer, created queries with Variables, restricted key figures, calculated

key figures, conditions, exceptions etc.

Worked in Web Application Designer (WAD) for creating web templates.

•

Used RRI feature to jump between the Queries to analyze the data efficiently.

•

Analyzed Info Cubes (via RSRV) created and maintained aggregates (RSDDV) to improve the performance.

•

Developed ABAP routines at Info Package level for data manipulation and restriction.

•

Loaded Master and Transaction data using Process Chains.

•

• Designed making extensive use of the ODS capabilities, delta management functionality and optimal use of

update rules keeping query performance in view.

Visa Status: H1B valid until Nov 2016

References: Available upon request

Contact this candidate