Sap Data

Amithsa Shankarsa Meharwade

Address: ****, ********* ****, *** #**, San Diego, CA-92115

Email: *******.**@*****.***

Mobile: 405-***-****

Summary:

• 5+ years of SAP Experience as BI Functional Consultant.

• Implemented SAP BW through 3 Complete Life Cycles.

• Proficient in all phases of BW application development, data extraction, InfoCube building and

reporting.

• Excellent hands of experience on BW reporting - BEx Web Designer, BEx Analyzer, BEx

Query Designer, BEx Broadcaster and sound knowledge of Visual Composer.

• Performed Data load management, experience also in Scheduling Start Process and Process

Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta

Up-Load), Monitoring, Remote Cubes, Multi Cubes, Data Mart, Info Spokes and Open Hub

Service.

• Extractions – Extracted data from Logistics (SD, MM, PP etc), FI, LO Cockpit, CO-

PA, Generic data sources (RSO2), Flat File, Non- SAP systems.

• Extensive experience with BW development tools, delivered ETL - data extractors,

transformation and data load.

• Rich experience in Aggregates, Performance Tuning, Partitioning, Compression, BW

Statistics and BW Job Scheduling, Testing, Go-Live, Production Support, End-user

training and Documentation.

• Extensive knowledge of Standard and Custom Info Cubes, Info Object and Info

Sources, Web reporting, Extraction, Transfer Structures, Data Store Objects (DSO),

Info set, Multi providers, Hierarchies, Business Explorer (BEx) and Archiving.

• Experienced in using Delta update mechanisms for uploading the data to BW from R/3

in specific intervals.

• Used Data Transfer Process (DTP) to transfer data within BI from one persistent object

to another object.

• Performance Tuning -Evaluated statistical performance and suggested recommendations to basis

support for optimization. Improved data load and query performance by doing Compression,

Aggregates, Partitioning.

• Reporting - Expertise in front-end Business Warehouse Components like Queries,

Calculated Key figures, restricted key figures, Structures, Variables, Exceptions,

conditions, RRI and Jump queries etc

• Enhanced Infocube with remodeling concept to make changes, without having to reload

data.

• BW Security - Defined authorization, user profiles, creation of Users and Roles and access.

• Working knowledge in Mercury Test Director testing Tool.

• Presentations - Conducted workshops and presentations to validate business

requirements and solutions with the end user community. Developed business process

documentation.

• Sound knowledge of Xcelsius and Crystal reports.

• Sound knowledge of BI Accelerator.

• Excellent verbal and written communication skills, ability to work independently as and when

required and highly Self-Motivated.

Technical Summary

SAP-BI 7.0 Migration to 7.0 from 3x, Data Warehouse workbench, Process Chains,

Logistics Cockpit, Web Application Designer, BEx Designer/Analyzer,

Xcelsius and Crystal reports.

SAP-BW 3.X Administrator workbench, Process Chains, Logistics Cockpit, Web

Application Designer, BEx Designer/Analyzer, WAD.

SAP-APPL SD, MM, PP, FI/CO, SAP SRM

DATABASE ABAP Data Dictionary, Oracle 9i, MySQL, SQL Server, MS-Access

ENVIROMENT Windows XP/NT, Linux, UNIX (Solaris)

OTHER SKILLS SQL, PL/SQL, C, C++, XML, HTML, MSOffice, MS Excel, MS Word, MS

PowerPoint, MS Visio, MS Project.

PROFESSIONAL EXPERIENCE

PACIFIC GAS AND ELECTRIC, CA

SAP BI/ BW Consultant

Environment: SAP R/3 4.6C, SAP BW 3.x, BEx, WAD, SD, Oracle 9i, Windows XP, Linux, SAP

ECC6.0, SAP BW 7.0

Responsibilities:

• Full Life Cycle of BW from Project Preparation Blue Print, Realization, Final Preparation, and

Go Live.

• Used DTP’s and loaded data to the InfoProvider through InfoPackages.

• Created custom InfoObjects, InfoSources and InfoCubes.

• Developed / Built BEx Queries, using BEx Query Designer and WAD.

• Maintained Functional documents, and Technical documents.

• User Demo, Presentations on BI Reporting.

• Involved in UAT and coordinated with the Development team to fast resolution of issues and

closing the tickets.

• Created BEx Web Templates with WAD (Web Application Designer) in order to give a

consistent look & feel to the end user and giving them flexibility using query views and query

view selection drop down.

• Extensively worked on Administrator Workbench.

• Datasource enhancements, concerned to Purchasing.

• SAP BW Backend activities like ETL, Cleansing Data, Processing and loading data.

• Created Process chains for weekly production loads, and special loads based on the custom

requirements.

• Developed validation queries and conducted unit testing and user validation testing.

• Coordinated with basis to fix Transport issues, database issues and parameter settings in

development staging and production environments.

SOLO CUP, CHICAGO, IL

SAP BI/ BW Consultant

Environment: SAP R/3, SAP BI 7.0, SAP 3.5, ECC 4.7, ECC 6.0, Oracle11i, Windows XP and SD.

Responsibilities:

• Involved in complete life cycle of the project (Architecture, Design, Development, Deployment,

Performance Tuning, Go-live and support activities) BW upgrade project from 3.5 to in BI 7.0 .

• Analyzed business reporting requirements that could be satisfied by Business content info cubes

of Sales (0SD_C01, 0SD_C02, 0SD_C03), Purchase (0PUR_C01, 0PUR_C04) and Finance

(0FIGL_C01, 0FIGL_VC1, 0FIGL_VC2).

• Maintained info packages and monitored data load into Info Cubes and DSO.

• Worked on Actual/Planed comparison(Created Planning functions and Planning sequence).

• Improved Query Performance by creating Aggregates from Info Cubes.

• Used DSO data for detailed reporting purposes using Info set Queries.

• Extracted data using DB-Connect, and data export using Open Hub and Info Spoke

methodology.

• Designed the Custom Info Cubes related to SD, FICO and MM.

• Extensively worked on Query building, Filtering, Structures, Free Characteristics, Restricted

Key Figures, Variables, Conditions,Exceptions and Query variants using BEx Analyzer.

• Worked on the Design custom views, pages, work sets, layouts in the Visual Composer.

• Worked on FI-GL, FI-AR and FI-AP reports and developed business process flows for

activities in FI/CO Module.

• Generated numerous drill-down reports for end users using BEx Analyzer for SD and MM

modules.

• Performance Tuning of BW query using index, Aggregates, compression, Partition and

Rollup.

• Solved a number of tickets issued by help desk.

TORO COMPANY BLOOMINGTON,MN

SAP BI/ BW Consultant(SRM Implementation, Production Support)

Environment: SAP R/3 ECC 6.0, SAP BI 7.0 BW release, BEx Analyzer, ABAP/4, SAP Web

Application Server 6.20.

Responsibilities:

• Involved in the Production support of their existing SAP SRM system.

• Actively involved in the resolving the production issues and also developed new reports for

Shopping cart according to the user requirements.

• Generated Cycle Time reports.

• Used Transformation and DTPs for all the data models in BI 7.0

• Involved in the Reloads for the test system, where I was required to Test the enhanced routines,

for consistencies.

• Created Jump-to reports for cycle time to shopping cart.

• Improved Performance Tuning standards and benchmarks to improve overall performance of

extraction, performance-tuning techniques for Process Chains and increase parallel processing.

• Monitored BW data loads for Daily/Weekly/Monthly and resolution for the load failures,

performances tuning of data load for critical BW applications.

ACCENTURE SERVICES PVT LTD, BANGALORE, INDIA

JUNIOR SAP BI/ BW Consultant

Environment: SAP R/3, 4.7EE,BW 3.5, BEx Analyzer, Windows 2000/NT.

Responsibilities:

• As a part of implementation team, involved in gathering user requirements and data modeling

using ERM, Extended Star Schema Concepts.

• Installed relevant SAP business content.

• Designed and customized data models and Info Cubes for Sales order.

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

• Worked on activating the standard business content info cube 0IC_C03 Material movement and

0PUR_C01 Purchasing data.

• Created Multi cube based on Sales order and Billing cubes.

• Responsible for design, development and extraction of data from R/3 Source System and Flat

Files to the BW system and created various Info package to enable data transfer.

• Worked on creation of Aggregates and hierarchies for the Info Cubes to access data in an

efficient and ordered level.

• Developed various reports for forecast comparison.

• Designed, Developed and integrated reports using Crystal Reports.

• Monitoring daily /weekly/monthly loads and solving loading issues.

• Involved in weekly maintenance issues as part of performance team.

• Training end-users on utilizing, developing and creating BW Queries.

L & T ELECTRONIC BUSINESS GROUP, BANGALORE, INDIA

JUNIOR SAP BI/ BW Consultant

Environment: SAP R/3 4.5, BW 3.0B, BEx Analyzer, Windows 2000/NT.

Responsibilities:

• Involved in requirement analysis, modeling, Business Content Activation, Front-end design,

data load scheduling.

• Involved in extraction, configuration and construction of Data targets.

• Created number of Reports with various filters, formulas and restrictions and variables

• Enhanced the DataSources & InfoSources for additional business requirements, used Customer

Exit Variables, Formulas and Filters for the client business requirement.

• Involved in Query Definition, Query Presentation - BEx Analyzer and

• Scheduling of Daily, Weekly and Monthly Data Target loads using Process Chain and Event

Controller.

Education

Master of Science in Computer Science

San Diego State University (SDSU),

Bachelor of Engineering in Computer Science

Bangalore Institute of Technology, India.

Contact this candidate