Sales Data

Swathi

SUMMARY:

. SAP BI consultant with over 7 years of experience in SAP BI / BW with

Four Full Life Cycle implementations.

. Demonstrated expertise in all phases of SAP Implementation such as

Analysis, Blue-printing, Realization, Design, Development, testing,

documentation, Support & maintenance, training, Performance tuning,

Security authorizations and trouble-shooting.

. Extensive experience in Standard Business Content of Various business

modules and Custom Info Cubes, Info Objects and Info Sources, Web

reporting, Extraction (LO Cockpit, Generic Extractions), Transfer

Structures, BI Transformations, Data transfer process, Data Store

Objects (DSO) and hierarchies.

. Functional Modules - SD, MM, HR, PP, PM, FI-AP/AR/GL, CRM and SCM

Modules.

. Customizations - Data source enhancements, Generic extractors, User

Exits and LO Cockpit configuration and customization, Data Extraction

from flat files and Update/Transfer rules modifications.

. BW Operations - Data load management, Job scheduling, OLTP extraction

data, Loading (Full /Delta Up-Load), Monitoring, Data Reconciliation

with Remote Cubes, Data Mart, Open Hub Services, importing OSS Notes

and BW Transports.

. BW Reporting - Strong Experience of BEx Query Designer, Calculated &

Restricted Key Figures, and RRI jumps, Conditions, Exceptions,

Variables, Queries on Multi Providers, Web Application Designer (WAD)

and worked on Visual Composer to deploy the reports into portal.

. Performance Tuning - BI Accelerator, BW Statistics, Multi Providers,

Aggregate creation, Info Cube partition & compression, Query tuning

and OLAP Cache Monitoring.

. Open Hub Destination - Extracted data from SAP BW to External systems

and Files.

. Testing - Master/Transaction data testing in BW and handled

Reconciliation with R/3 Data.

. Good Knowledge in SAP BW 7.2,7.3 Versions

. Highly organized with proven skills to perform several tasks and

assignments within the scheduled time. Dedicated and customer

satisfaction oriented. A team player working effectively with group in

accomplishing objectives. Have exemplary Communication and

Presentation skills. Communicates effectively with all levels of

management and clients.

Technical Skill Set:

ERP packages: SAP R/3 Release 4.5B, 4.6B, 4.6C,

4.7, ECC 5.0/6.0, EP 6.0/7.0,

Netweaver'04, NW2004S, SRM 4.0, BW

3.5/7.0, Versa Fire Fighter 3.0

SAP BW SAP BW versions 7.0, 3.5/3.1/3.0B.

Operating Systems: Windows 9x/00/XP/NT, UNIX, LINUX,

IBM AIX, SUN- SOLARIS, HP-UNIX

Reporting Tools: Business Objects (XI R1/R2, 3.0,

3.1), Web Intelligence, Desktop

Intelligence, Info View, Dashboard

Manager, Crystal Reports 2008,

Celsius 4.5/2008, QAAWS, Live

Office, Voyager, SAP Integration

Kit.

Databases: Oracle 8i/9i/10g, DB2, MS SQL

Server, MS Access

Languages: SQL, PL/SQL, ABAP/4, C, C++, Java,

Access Basic, Visual Basic

Others: MS Office, MS Outlook, Adobe

Photoshop

PROFESSIONAL EXPERIENCE:

Boston Scientific, Marlborough, MA

April 2013 - Present SAP BW Consultant

Boston Scientific is leading innovator of medical solutions that improve

the health of patients around the world. They are focused on high

performance benefit patients, clinical, and shareholders.

Responsibilities:

. This was a Global Full cycle project from Requirements gathering to Go-

Live.

. Worked on Business requirements gathering and Gap Analysis to identify

the gaps that existed from the Standard Business Content.

. Based on the Gap Analysis and requirements we prepared functional and

technical documentation.

. Activated the Business Content for SD, FI, CO, MM, IM, HR and PP

modules. Converted some Update rules and Transfer rules into

Transformations and created the DTPs.

. Extensively worked in BADI for writing the ABAP code required for the

newly added fields in various Data sources.

. Extensively worked in writing the ABAP code in Customer Exits for the

different Variables used in Sales History Reports, Balance sheet

Reports, Forecast Reports, Plan attainment, Plant Maintenance etc.

. Extensively worked in writing the ABAP code in Start Routines, End

Routines and Individual Routines in Transformations according to User

requirement.

. Developed the data flow for FI-GL (New), FI-AP, and FI-AR, and created

the reports like AR Aging, Customer Analysis, Vendors Overview,

Installed Balance Sheet and Profit & Loss Statement based on virtual

cubes.

. To automate the data loads, I have created Process Chains (based on

the application specific like SD, MM, FI).

. Project landscape included integration testing in Sandbox system, UAT

in QA system before migrating to Production.

Movado Group Inc, Paramus, NJ

Feb 2013 - Dec 2013

Role: BW Developer

One of the world's premier watchmakers, Movado Group, Inc. designs,

manufactures and distributes watches from ten of the most recognized and

respected names in time like Movado, Concord, EBEL and ESQ Movado.

Responsibilities:

As a SAP BI Consultant prepared Business Blue print, requirement gathering,

scope design, functional and Technical design documents, Test cases and

Technical design documents.

. Involved in the preparation of Business Blue print document,

functional and technical specifications.

. As a part of the Carve-out Project, Involved in co-coordinating with

BASIS team for creation and modification of dealer roles.

. As a part of the Sprinter Vans Project, Creation and modification of

various Reports, Interfaces.

. Worked on BEx Query Designer in designing queries using filters,

variables, navigational attributes and structures to facilitate

flexible, detailed drill down data analysis to required level of

information.

. Created BEx reports, Web reports, dashboards and web templates.

. Extensively built queries on info Cubes, ODS objects, multiproviders,

using BEx analyzer.

. Enhanced standard business content cubes and extractors to meet the

client requirements.

. Created BEx queries, Web templates and published them in portal.

. Migrated the BEx queries to BOBJ and published them in portal.

. Designed and created Infocubes, ODS objects, transfer rules, update

rules, infosources, transfer structures, communication structures,

multiproviders, infosets, infopackages and data mart interfaces.

Home Meridian International, High Point, NC Jan

2011 - Dec 2012 BI/BO Implementation

HMI is a next-generation global design and marketing company that ranks

among the top 5 case goods suppliers to US retailers. HMI has

distribution in all but 9 of the FT 100, excluding bedding only and closed

distribution outlets.

Responsibilities:

. Worked on SAP BW/BI implementation of two critical functional areas,

OTC (Order-to-Cash) and APO (Advanced Planning and Optimization,

Demand Planning).

. Developed complex designs to support aforementioned reports and also

built these reports using B Ex.

. Was involved in project to retire the legacy Point of Sales tool and

replicating the functionality delivered in SAP BW.

. Was involved in development of complex reporting functionality for the

waterfall report using cell editor in B Ex.

. Remodeled the backend build to address the issue with rejected/un-

rejected order for sales order history.

. Designed and developed queries in B Ex using complex functionalities

like user exist variables, cell editors, RRI and conditional

reporting.

. Participated in info package management for data loads by daily job

monitoring through IDocs and PSA, flat file creation and load of PSA

that was used to source data from legacy system into SAP BW.

TDS Telecom, Madison, WI

Oct 2009-Oct 2010 SAP BI/BO Implementation

TDS Telecommunications Corp. (TDS is the seventh largest telecom provider

in the U.S. For more than 40 years, the company has been connecting people

with high-speed Internet, phone, and TV entertainment services in hundreds

of rural, suburban, and metropolitan communities across 31 states.

Responsibilities:

. Analyzed data requirements and translated these requirements into

dimensional data models using star-schema and extended star-schema

data modeling techniques.

. Created Info Objects, Data Sources, Info-Sources, Data targets, Info-

Packages and Info Cubes to load Master and Transactional data from SAP

ECC system and flat files into BW system.

. Data from Sales and Distribution and MM modules of ECC into SAP BI

system using data sources creating through Generic extraction and LO

Cockpit data extraction techniques.

. Installed and extended standard Business Content based on client

requirements for enhancing Data-sources for transaction & master data

(Attributes, texts and Hierarchy).

. Created, Maintained and modified existing queries on different Info

Cubes related to SD and PP modules. Extensively worked on Query

building, filtering data, Structures, Variables and conditions.

. Developed update rules using ABAP for updating the Sales item

extractor table in ECC and Developed custom Info Objects.

. Created data sources for Sales item and Billing and created Info

source, transfer rules and update rules.

. Filled setup tables and performed job control in ECC System and

maintained delta queue and outbound queue and checked the data in ECC

using extractor checker.

. Developed front end reports using Business explorer for month to date

shipment reports and fiscal period sales reports based on product

group and sales district.

. Resolved issues in multifamily reports by implementing sales area

realignment and master data realignment

WIPRO INFOTECH, INDIA, Bangalore May 2008 -

Sep 2009

Client: United Gulf Steel Mill/ Production Support

SAP BW Consultant.

Wipro Infotech is a leading manufacturer of computer hardware and provider

of IT services, Business and Technology Consulting, IT Outsourcing and

System Integration services & solutions all over the world.

Responsibilities:

. Involved in the implementation of SAP BW.

. Analysis and development of objects as per client requirements.

. Helping team members co-coordinating with the client.

. Design and Modification of Objects.

. Uploaded legacy data from non-sap to sap using LSMW and custom

programs.

. Documented and reported with currency conversions in FI-SD-COPA areas.

. Created queries and customized MS Excel reports using VBA and

generated Workbooks.

. Worked Extensively on BEx Analyzer (RRMX) to create Queries on

MultiProvider and created Web Templates using Web Application Designer

for web reporting.

. Created Dashboards using Web Application Designer.

. Involved in day-to-day production support.

Olympus Tech, Bangalore, India. Aug 2007 - April

2008

Role: SAP Tech Consultant

Olympus is a world leader in delivering products and services that help

physicians diagnose, treat and prevent illnesses that further scientific

research.

Responsibilities:

. Analysis of the specifications provided by the clients and Design &

Development of Objects.

. Design of layouts, Coding with coding standards, peer review of

objects Testing - Unit testing & Integration testing, and preparation

of Test Plans.

. Regular Data loads to BW and its maintenance. Developed reports with

better reporting performance.

. Review of partitions on Info cubes, adding/merging partitions to

improve query performance.

. Fixing of the recurring issues from BW/BO perspective.

. Enhancement of various Reports depending on Business requirements.

. Development of reports to meet the new functional requirements of the

Business.

. Introduction of new methods and education of team members on

functionalities.

[pic]

Contact this candidate