DOSAPATI SUMAN

Sr. SAP BI/BW CONSULTANT

acowhn@r.postjobfree.com

Ph: 614-***-****

SUMMARY:

. Over 8 years of experience in SAP BI/BW and completed two SAP full

lifecycle implementations, gaining experience in gathering business

requirements, Gap analysis, Asap methodology, blueprinting, prototyping

with users, detailed design, hands-on configuration, system test

planning, system test execution, UAT - User Acceptance Test planning and

execution, super user training, Go-live or cutover planning, and support.

. Worked in two SAP BW/BI full life cycle implementations, as well as

upgrades. Analyzed feasibility study for NW 2004s BI for Upgrade and

creating Production Support environment.

. Worked on Blue Print, Data Modeling, Designing, Documentation,

Development to till Go Live and Support.

. Extensive experience and expertise in SAP BI/BW Extraction (Generic

/Standard), Modeling and Reporting (i.e. Back-end and Front-end). Good at

implementing SAP BW with different SAP data source.

. Strong in Configuration of Data targets, Datasources, Info objects,

Keyfigures and Multiproviders

. Configuration of Transfer Structure, Transfer Rules, Start routines,

Transfer routines, Update routines and End Routines.

. Extensively worked on Process Chains, Data source Enhancement, OLTP data

extraction, Loading (Full /Delta Up-Load), Monitoring, Data Mart and

Open Hub Service, Performance Tuning, Aggregates, BW Transports, RSRT,

Query tuning, Building aggregates, Indexing.

. Extensively worked on OLTP extractions using LO Cockpit, CO-PA, FI,

generic datasource customization, master data, and Customer defined

tables (z-tables) extraction.

. Extensive experience in Multi-Dimensional Data Modeling, Extended Star-

Schema, Data Flow Strategy.

. Proficiency in Performance Tuning using Rollups, Partition, Compression

and ticket resolution.

. Wrote various ABAP queries for field's selection, data modification and

updating to targets.

. Expert in SAP BI Business Explorer and SAP BI Web Application Designer.

Worked on SAP Business objects including Universe Design, Web

Intelligence, Crystal Reports and Xcelsius.

. Experienced with providing users with access to data by building reports

and queries using tools including SAP BW BEx Query Designer/Analyzer,

Crystal Reports and Business Objects Web Intelligence.

. Expertise in front-end Business Warehouse (Bex Suite) components for

Queries, workbooks, Calculated Key Figures, Restricted Key Figures,

Structures, Customer Exits, Variables, Exceptions, Conditions, RRI.

. Development experience of Extractors, InfoObjects, InfoSources, ODS

Objects, Basic InfoCubes, Transactional InfoCubes, InfoPackages, Volume

sizing estimates and establishing Dataclasses, Roles and Authorizations,

Infospokes.

. Strong on End-to-End SAP BW Configurations and Customizations from

Extraction.

. Served as liaison between application development team and technical

operations staff.

. Excellent communication and presentation skills. Reputed for dedicated

teamwork, solid work ethics and Commitment to achieving various Goals

and key objectives. Good academic performance, analytical, and

problem-solving skills

. Knowledge on BODS and SAP HANA.

Other Expertise:

. Focused on reuse, granularity, modularity, compos ability,

componentization and interoperability or applications and technologies.

. Communicate effectively with client, project management and team members.

. Experience in technical and functional upgrade.

. Deep understanding and adhered to standards and compliance requirements

(both common and industry-specific). Strong understanding of BI tools,

procedures and principles.

. Serviced identification and categorization, provisioning and delivery,

and monitoring and tracking

. Strong proficiency in both principles and execution of data modeling and

solution architecting

TECHNICAL SKILLS:

SAP SAP Net weaver 2004s BI 7.3/7.0, SAP BW

(3.5/3.1C/3.0B), SAP BOBJ/BO (XI 3.1/R2/6.5), SAP ECC

(6/5), SAP R/3 (4.7/4.6C/4.6B/4.5B), BI Integration

with SCM/APO, HR, and CRM, Reporting

Operating Windows 95/98/2k/XP/Vista/7

Systems

RDBMS Oracle10/9/8.x, MS SQL Server 2000, MS Access

Tools & ABAP/4, SQL, IDOC, RFC's, DBconnect

Utilities

Web Technologies HTML, XML, ASP, JavaScript, VBScript, Servlets

PROFESSIONAL EXPERIENCE:

Client: Adobe/ San Jose, CA

Aug'14-Till

Date

Role: Sr. SAP BI/BW Consultant

Responsibilities:

. Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases

of SAP BW.

. Lead as f-functional consultant to delivery and qualify SAP BI/BW

definition and requirements, gap analysis, technical design

build/development, testing and roll-out. Implemented SAP BW with

different SAP data source.

. Extensively used ABAP Routines to modify/update data and develop reports.

. Identified the extractors on the R/3 OLTP systems and defined the

Transfer structures on the source and target systems. Created BW

components like Queries, workbooks, Calculated Key Figures, Restricted

Key Figures, Structures, Variables, Exceptions, Conditions, R/RI.

. Extensively involved in scheduling BWA on cubes and monitoring the BWA.

. Created Attribute, Analytical, Calculation views on structure in SAP HANA

modeler.

. Extracted Cost Center hierarchy & Cost Element hierarchy into BW using

respective data sources 0COSTCENTER_0101_HIER & 0COSTELMNT_0102_HIER.

. Performed LO-Cockpit extraction to pull data from R3 SD modules into BW

system extracting Header and Line item data from the Sales and

Distribution (SD) module (Sales Order LIS_11_VAHDR/VAITM,

Shipping/Delivery 2LIS_12_VCHDR/VCITM and Billing 2LIS_13_VDHDR/VDITM.

. Experience organizing process chains with transaction RSPC and analyzed

process chain load for optimal performance issues and updates for

necessary automation process requirement.

. Worked as CRM Techno-functional consultant to develop reports like

"Activity Monitoring Report", "Opportunity Monitoring Report", "Territory

Monitoring Report" etc.

. Used SAP BW for DataStage to extract, transform and load (ETL) the data

from various data sources FI/CO, SD, MM, and HR including the legacy

systems and developed reports.

. Active participant in full-cycle implementation of SAP BW and BOBJ (from

project planning to go-live and post go-live support).

. Experience Bursting of dashboards data source to deliver personalized

dashboard with embedded offline viewing, linking of two reports for

Passing parameters and flash variables.

. Experience implementing break/fixes, report enhancements, debugging,

troubleshooting and performance tuning (load failures/deadlocks) various

complex issues.

. Thorough knowledge of Security permissions, authorization objects, and

roles within SAP BW and BOBJ, including SAP Authentication.

. Experienced with providing users with access to data by building reports

and queries using tools including SAP BW BEx Query Designer/Analyzer.

. Experienced with enterprise-wide data modeling, database design, and

building data structures and data mapping routines in SAP BW to support

the data and reporting requirements for all areas of the organization.

Environment: SAP Net weaver 2004s BI 7.3 Ehp1/7, FI, SD, SAP BOBJ/BO (XI

3.1/4.0/R2/6.5), ABAP/4,ECC 6.0, Oracle, Business Explorer, SAP HANA

Modeler 1.0, SAP Design Studio 1.0

Client: Vivint/ Provo, Utah

July'12-July' 14

Role: Sr. SAP BI/BW Consultant

Responsibilities:

. Played key role in Project Blueprint/Realization/GO-LIVE/Sustain phases

of SAP BW -SAP BOBJ development project.

. Lead as f-functional consultant to delivery and qualify SAP BI/BW

definition and requirements, gap analysis, technical design

build/development, testing and roll-out. Implemented SAP BW with

different SAP data source.

. Generated several Consolidated (BCS) financial statements to accommodate

different accounting principles. Used the consolidation monitor to

execute the consolidation tasks and to monitor the entire consolidation

process.

. Extensively used SQL, PLSQL and ABAP Routines to modify/update data and

develop reports.

. Identified the extractors on the R/3 OLTP systems and defined the

Transfer structures on the source and target systems. Created BW

components like Queries, workbooks, Calculated Key Figures, Restricted

Key Figures, Structures, Variables, Exceptions, Conditions, R/RI.

. Created reports Finance "Days Overdue analysis", "FX Monthly", "FX Global

Exposure", "Payment History by Document Type" and "DSO Analysis by

Period" reports.

. Experience in creating Multi currency, Balance Sheet analysis, Profit &

loss and cash flow statements.

. Activated profit center accounting cubes (0PCA_C01, 0PCA_C02), accounts

payable cubes (0FIAP_C02, 0FIAP_C03), accounts receivable cubes

(0FIAR_C02, 0FIAR_C03) Sale cubes (0SD_C01, 0SD_C02, 0SD_C03, 0SD_C05)

from Business Content.

. Generated Cost Center "Plan/Actual" report which provides an overview of

the situation of primary and secondary costs and "Internal Order" report

to provide an overview of the actual and planned costs incurred during

reporting time frame on certain internal orders.

. Extracted Cost center statistical key figure actual for headcount into

0CCA_C03 InfoCube from data source 0CO_OM_CCA_3.

. Experience organizing process chains with transaction RSPC and analyzed

process chain load for optimal performance issues and updates for

necessary automation process requirement.

. Worked as CRM Techno-functional consultant to develop reports like

"Activity Monitoring Report", "Opportunity Monitoring Report", "Territory

Monitoring Report" etc.

. Used SAP BW for DataStage to extract, transform and load (ETL) the data

from various data sources FI/CO, SD, MM, and HR including the legacy

systems and developed reports.

. Active participant in full-cycle implementation of SAP BW and BOBJ (from

project planning to go-live and post go-live support).

. Experience Bursting of dashboards data source to deliver personalized

dashboard with embedded offline viewing, linking of two reports for

Passing parameters and flash variables.

. Experience implementing break/fixes, report enhancements, debugging,

troubleshooting and performance tuning (load failures/deadlocks) various

complex issues.

. Thorough knowledge of Security permissions, authorization objects, and

roles within SAP BW and BOBJ, including SAP Authentication.

. Experience in Unit testing, system testing, integration testing and

performance testing. Hands-on development experience with Business

Objects WebI, Universe Designer, Live Office, Query as a Web Service

(QaaWS), Lifecycle Manager, and Xcelsius.

. Experienced with providing users with access to data by building reports

and queries using tools including SAP BW BEx Query Designer/Analyzer,

Visual Composer, Crystal Reports, Business Objects Web Intelligence,

reporting with MDX integration and/or other enterprise reporting tools.

. Experienced with enterprise-wide data modeling, database design, and

building data structures and data mapping routines in SAP BW to support

the data and reporting requirements for all areas of the organization.

Environment: SAP Net weaver 2004s BI 7.1 Ehp1/7, FI, SD, SAP BOBJ/BO (XI

3.1/4.0/R2/6.5), Visual Composer, ABAP/4,ECC 6.0, Oracle, Cognos,

Informatica, Business Explorer, BCS, BPC, Crystal Reports.

Client: BASF/ Atlantic, New Jersey

June'10-May'12

Role: SAP BW/BI Consultant

Responsibilities:

. Involved in the Blueprinting phase, Gathering business requirements,

analyzing existing SAP system and other interfaced systems and

participated in the ETL architecture of Finance and Controlling modules

using BI Administration workbench.

. Involved in Full life cycle implementation of BW BPS involves

transitioning from BW-BPS to BI- IP.

. Worked extensively on FI-CO, SD, HR, COPA. Loaded the data from ECC to BI

and used initialization with delta update and full update methods. Used

SAP BW for DataStage to extract, transform and load (ETL) the data from

various data sources HR,PP, SD, and FI .

. Key person to maintain/manage and code User Exit programs for CRM

Services, Activities and Opportunity Management and Logistics.

. Worked on CRM-BI IP integration to load data in to planned and Actual

cubes.

. Developed data model for Actual and planned data with CRM-BI IP for

report requirement of target Customer sales.

. Extensively worked for BW-CRM integration area like Services, Survey

Confirmations, IBase, Activities, Opportunity management and ECC

Logistics and FI.

. Worked as CRM Techno-functional role for data sources like

0CRM_SRV_PROCESS_H, 0CRM_SRV_PROCESS_I, 0CRM_OPPT_H, 0CRM_OPPT_I and with

ECC data sources like 0FI_AP_4, 2LIS_02_HDR, 2LIS_02_ITM, 2LIS_13_VDITM

and its corresponding DSOs and Cubes.

. Created second level DSOs on top of 0CRM_OPPH, 0CRM_CNFI, 0CRM_PROH,

0CRM_PROI and created End Routines to do look ups on different master

data objects to make the data in linear line.

. Written Implementations for BADIs like CRM_BWA_MFLOW to fill data in to

enhanced fields to improve performance of data loads.

. Enhanced 0DOC_NUM master data InfoObject with CRM Service Order

information to make synchronize the relation between Service Order to

Purchase Order.

. Extracted the data from HR modules and uploaded the data into HR Info

Cubes for 0PY_C02 Payroll data, 0PABN_C01 Benefits, Staffing Assignments

0HR_PA_OS_1, 0HR_PA_CM_1 and 0PT_C01 Time and Labor Data and worked on

transformations.

. Created Generic Extraction from user defined tables and created

transformations using ABAP routines.

. Extracted non-SAP systems data like Oracle, BODS, Teradata using UD

connect and did flat file extractions.

. Designed and created complex process chains to automate the data load and

data target administration.

. Developed Analytical Reports with multiple parameter fields, multiple

expressions and multiple grouping for hierarchy levels and published them

using the Business Objects Enterprise XI.

. Created WEBI reports with Variables, Prompts and Complex Calculations to

get Alerts for Xcelsius Dashboards.

. Implemented analytics across the organization and used tabs on company

performance via flexible management dashboards and scorecards and

implemented index awareness.

. Checked the Universes for Integrity and exported to the Repository to

make resources available to the users and groups and Created Adhoc

Reports by accessing the Universe.

. Generated complex and large reports to show information from service

order to Purchase Order to Account payable using RRI to meet the business

user's requirement.

. Build complex new queries with variables, calculated key figures,

restricted key figures, customer exit variables and authorization object

variables.

. Created test cases and closely worked with business users to test the

queries and documented data model for backend objects and front end

queries for production support.

Environment: SAP ECC 6.0, SAP BI 7.0, SD, MM, PP,FI, PCA, SCM, ABAP/4, IP,

Business Explorer, Xcelsius, Crystal Reports with MDX, BOBJ/BO (XI

3.1/3.2), WEBI, Query Designer, Report Designer

Client: Magneti Marelli/ India

Jun'09 -

May'10

Role: SAP BW/BI Consultant

Responsibilities:

. Involved in the development of the user requirements, testing, initial

phase of production and thereby possessed a good understanding of

complete life cycle implementation of SAP BW.

. Gathered user requirements for creating reports such as Geographical

Sales Lead Report (sales prospect monitoring), Daily Billed Report

(revenue monitor) based on KPIs and studied the business content to suit

the clients requirements

. Extensively involved in installing and customizing the standard BW

business content to pull information from various source systems

including SAP R/3, Oracle and flat files to load the data into

InfoProviders.

. Worked in the areas of purchasing and extracted data from DataSources

like 2LIS_02_ITM, 2LIS_02_SCL and 0FI_AP_3. Also extracted and populated

data into LO InfoCubes from DataSources 2LIS_11_VAITM, 2LIS_11_VASTH and

2LIS_12_VCITM.

. Worked on custom reports like vendors without materials, materials

without vendors, spend data by material group, consolidated spend

history, and purchase price variance.

. Created custom report called forecast variance report, which compared

actual data from 2LIS_02_ITM and planned data from 2LIS_03_S194.

. Customized InfoObjects to match report requirements by creating variables

in BEx and creating InfoCubes based on the data content. Created

MultiCubes such as Demand cube, Supply Cube and Inventory Cube.

. Created the required InfoSources (for flexible upload and direct upload)

and InfoPackages to load the appropriate data into ODS via PSA for data

staging. Uploaded transaction data into ODS objects from flat files and

Oracle 8i. Multiple ODSs then fed the data into the InfoCubes and

InfoObjects.

. Created and maintained transfer rules, transfer routines, update rules,

and update routines to maintain data consistency.

. Extracted data, initialized delta for uploading of transaction data from

R/3 systems by V3 updates. Monitored the data load.

. Designed and built the generic data source on VEKP, LIKP tables of R/3 by

creating view on both tables on delivery numbers and document types.

Wrote user exits and customized delta built up for these DataSources

using V3 update.

. Created Conditions, Exceptions, Structures, and Variables to use them in

BEx Reporting.

. Worked with Info Package groups and Process chains for effective

scheduling and automation of various data loading processes.

. Resolved Query Performance issues using transactions like RSRT, RSRTRACE,

ST03N, RSDDSTAT, and BW Statistics. Involved in fine-tuning the

performance by creating aggregates based on BW statistics, creating

InfoCube partitions, data indices, optimal packet size, and data

compression.

. Developed authorization objects and profiles to restrict the access to

the data model and queries.

. Worked with OpenHub feature for creating InfoSpokes in extracting the

master data of the logistics, and material for exporting to a different

SQL server.

. Responsible for the creation of Naming Convention document and other

Documents for InfoCubes, ODS Objects, InfoSources, InfoObjects.

Environment: Sap Net weaver 2004S, ECC5.0, SAP BW 7.0,SD, FI,MM, Oracle 8i,

Windows NT, Business Explorer, WAD.

Client: Godrej/ Mumbai, India

Mar'08 -

May'09

Role: SAP BW/BI Consultant

Responsibilities:

. Involved in complete life cycle update (from preparation, business blue

printing, realization and go-live) of SAP BW & APO in SD, MM and FI

modules.

. Performed LO-Cockpit extraction to pull data from Sales and Distribution

SD module into the BW system. Customization of datasources in CO-PA, LIS,

HR, FI/CO and LO Cockpit to match the business requirement.

. Extracting the data from MM (Material Management 2LIS_03_BF data

sources), and PP (Production Planning and controlling) modules.

. Wrote reports in SD Open sales Order report, which covers all

organization levels, delivery status, shipping details and partner

function details. The tables used were VBAP, VBPA, VBAK, VBUP, VBFA,

KNA1, and MARA.

. Help project team in extracting data, interfacing BW with APO. Loaded

Demand Planning and ATP relevant data from I2/APO into BW.

. Created ABAP routines in Update rules, Info Objects. Used custom exits in

creation of Variables. Used debugging process for verification of

extraction process.

. Worked on BI 7 for GATP relevant reporting on APO and Prepared the Sizing

document by using Quick Sizer tool.

. Designed the Data flow for extracting Sales and Shipment Data from R/3 to

APO/BW.

. Extracted data from the Planning Area (DP). Involved in Creating Planning

Area's, Planning Book and generating CVC.

. Designed and developed several BEx Queries for LAG reports (ACTUALS VS

FORECAST).

. Performed CTM Job for transportation. Filled Setup Tables.

. Built an interface by using tscopy for master data load in SNP from

legacy database.

. Installed Business content for Sales & Operations Planning of SCM PP in

BW side.

Environment: SAP R/3, BI7, BW 3.5, APO 5, SRM 4.0, ABAP/4,, Business

Explorer, WAD, SD, MM, FI, CO-PA

Client: MIC Electronics/ Hyderabad, India

Jan 07- Feb- 2008

Role: SAP BI/BW Consultant

Responsibilities

. Involved in complete life cycle implementation (from preparation,

business blue printing, realization and go-live) of SAP BW in SD, MM and

FI modules.

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

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

R/3 system and flat files into BW system.

. Created and mapped source and target structures, loaded transactional

data and master data, set up delta load using SAP Standard extractor

program. Created transfer rules and update rules.

. Installed and extended standard Business Content based on client

requirements for enhancing Data sources for transaction data, master data

and texts.

. Created, Maintained and modified existing queries on different Info Cubes

related to SD, MM and FI/CO modules. Extensively worked on Query

building, filtering data, Structures, Variables and conditions.

. Created a custom Start Routine, Update Rules and Transfer Routines to

meet the business requirement.

. Schedule of Process Chains for Hourly/ Daily / Weekly Loads as and when

required.

. Involved in the preparation of Technical specifications and maintained

all the technical documents of all the objects and their user manuals.

. Designed custom ODS for sales order line items relevant to demand

planning.

. Involved in extracting data from custom data sources i.e. Generic

Extraction.

. Involved in the Integration testing in quality of Objects.

. Designed custom info provider for Delivery analysis and to load large

volume of data from SAP R/3 4.6C Source systems.

. Extensively involved in Design and creating Processes Chains to automate

the process of loading data into data targets

. Designed ODS object for MRP and loaded data. Developed an interface

between legacy system Windmills and BW to extract data and developed

reports Sales by customer and Sales by materials.

. Worked on Info Cube to develop income statement report.

. Involved in transporting objects in system landscape and in production

support.

. Designed loading strategies for master data, initial load of

transactional data and delta loading of both master data and

transactional data.

. Developed ABAP routines at Info package level for data manipulation and

restriction.

. Defined strategy to set up the historical data to load into BW and

improved performance by running parallel setups.

. Developed Transfer rules, update rules and Start routines to incorporate

Business logic for data manipulation.

Environment: SAP BW3.5/3.0bSAP R/3 4.6B/4.6C/4.7, BEx, SD, MM, PP, FI.

Contact this candidate