Ram Prasad. Ambati

SAP BI-BO Consultant

+1-732-***-****

mailto: acn69o@r.postjobfree.com

. SAP BI-BO with 8 years of experience. Worked as BW & BOBJ Consultant and

Sr. SAP BI Consultant for Multiple industries.

. Experience in Information Technology industry with SAP BW ( BW 7.4, 7.3,

BI 7.0, BW 3.5), BI Accelerator, SAP BOBJ, SAP BO (4.1, 4.0, XI3.1), SAP

ECC.

. Coordinated with business/users and responsible for deployment & Go-live

(Review/approve transport, lead solution architecture, help troubleshoot

and coordinate any issues with basis and functional teams).

. Experience in SAP BW Implementation, Support, Upgrade, Rollout & BW on

HANA Migration Projects.

. Experience in 2 full life cycle implementations including Business

Blueprinting, Design, Development, Unit Testing, Integration Testing,

Training Documentation and end user training.

. Extensively worked in BW 7.3 components (Transient Provider, Composite

Provider, Virtual Master Data InfoObjects).

. BW Architect, Experience in BI 7.0, BW 7.3 & 7.4 End to End

implementation & production support projects using ASAP Methodology.

. Experience in SAP BW Data modeling of InfoCube, MultiProvider, Virtual

Provider, Transient Provider, Composite Provider, DSO, InfoObjects,

Datasource, Transformation & DTP, Process Chains, Open Hub Destination

(OHD), APD.

. Extensively worked in SAP BW Data Extraction from Multiple SAP and Non

SAP (Legacy) Systems using BI Content Extractions LO, FI, Flat File, and

Generic Extraction Methods.

. Designed and developed queries for reporting using BEx Analyzer, Query

Designer and Web Application Designer

. Extensively worked in BEx Reporting of Selections, Formulas, RKF, CKF,

Variables, Processing Types, Conditions, Exceptions. RRI & Bex

Broadcasting.

. Extensively involved in Data load & Report Performance tuning Techniques

(Partitioning, Parallelization, Aggregates, Cube Compression, Line Item

Dimension, and Indexing).

. Extensively involved in SAP BI-BW Production Support in handling daily

batch jobs, load failures, delta failures, Performance issues, BIA

issues, System issues, reporting issues, locking issues, resource

bottleneck issues.

. Extensively worked in SAP Business Objects (BO 4.1, BO 4.0, BO XI 3.1)

tools like Universe Designer, WEBI.

. Experience in SAP BO reporting on SAP BW.

TECHNICAL SKILLS:

SAP BW Versions: 7.4, 7.3, 7.0, 3.5

SAP BO Versions: 4.1, 4.0, XI 3.1

SAP R/3 Versions: ECC 6.0, 5.0

Business Objects Tools: Universe Designer, WEBI,

Databases: SAP HANA, SQL Server, Oracle

BW reporting: BEx Query Designer, BEx Analyzer, BEx Web

Analyzer, WAD &

Portal

ERP Packages: SAP ECC SD, MM, FI, HR

Operating Systems: Windows 2000/XP/NT.

PROFESSIONAL EXPERIENCE

Deloitte Netherlands & Turkey (Internal Client) (CA)

July 2013 - till date

Sr. SAP BW-BI Consultant

Responsibilities:

. Responsible for analyzing the requirements and identifying the gaps.

. Responsible for reviewing Technical Design specifications.

. Involved in BI 7.4 implementation scenario and suggesting solutions

for specific requirements where high volume of detailed data reporting

is required in real time.

. Involved in ETL Based replication to provision the data from ECC to BW

system,

. Involved in providing solutions to the complex requirements using BW

7.3 Infoproviders

. Involved in Planning of data load activities runbook preparation.

. Involved in coordinating with offshore for the daily deliverables

throughout the ASAP phases.

. Involved in explaining the end user requirements to the

Onshore/Offshore & filling the gaps.

. Meeting SLA for all the developments and continuously tracking for the

updates to move the project in a smooth way to the target state.

. Involved in defect management during RT & UAT testing phases.

. Involved in Management of Transportation activities across the DEV,

QA, PROD Environments.

. Extensively worked in Mock Cutover activities & Defect Management.

. Involved in Coordinating with Upstream & Downstream teams for the data

loads activities.

. Involved in upgrading BW systems from 7.0 to 7.3

Environment: SAP BW 7.4 & 7.3, SAP BO 4.0, SAP ECC 6.0

Estee Lauder (NY)

February 2012 - June 2013

Sr. SAP BW-BO Consultant

Responsibilities:

. Involved in SAP BW 7.3 upgrading

. Involved in preparing Technical Design specifications for user report

requirements.

. Involved in development of BW Objects InfoObjects, DSO, InfoCube,

Multiprovider, Transformation, DTP, OHD, APD, Datasource,

Infopackages.

. Involved in BW BEx Reporting using BEx Query Designer.

. Involved in SAP BO WEBI, reporting on SAP BEx Queries & BW

Infoproviders.

. Involved in BW Transformation logics implementation through ABAP

routines.

. Involved in automation of data loads to BW using process chains.

. Involved in RT & UAT activities to fulfill the gaps in the system.

. Created BIA Indices on cubes to work on BI Accelerator.

. Experience in Environment synchronization to maintain consistency

across the landscape.

Environment: SAP BW 7.3, SAP BO 4.0, SAP ABAP, SAP ECC 6.0

AMUL DAIRY (INDIA) August 2010 -

January 2012

SAP BW Consultant

Responsibilities:

. Responsible for solution design for the SAP BW Implementation flows.

. Responsible for reviewing Functional Specification, Technical Design

specifications and providing corrections in the design.

. Identifying gaps in the system to stabilize the BI System.

. Involved in different BW releases to handle the enhancements in BW.

. Involved in Performance & Tuning activities.

. Involved in Transportation repackaging activities to transport the

objects in cross environments.

. Involved in System refresh activities.

. Responsible for maintenance of system consistency across the

landscape.

. Identifying performance improvement areas to improve the Flexibility,

Maintenance of the BI System.

. Extensively coordinated with the Security teams to design & implement

Analysis Authorization for various Reports

. Involved in Current State Vs Target state system analysis.

. Responsible to meet the SLA to deploy the objects in the production

environment.

. Responsible for implementation of security activities in the BW system

. Involved in End user support to fulfill the requirements.

Environment: SAP BI 7.0, SAP ECC 6.0

Heritage Retail (INDIA)

February 2010 - July 2010

SAP BW

Responsibilities:

. Involved in the requirement gathering for Data Warehouse Environment

for SD and MM applications.

. Involved in coordinating with functional team and created business

blue print and data flow diagrams.

. Coordinated closely with the business team in development of the

Technical & Functional specs.

. Designed functional specification and technical specifications as per

the business requirement.

. Involved in creation of Unit test script templates and executed of

those scripts and ensured there are no gaps between functional and

technical aspects.

. During the testing phases took up more responsibilities in all the

activities related to defects resolution.

. Involved in data loading from different source systems for Plan &

Actual data loads.

Environment: SAP BI 7.0, ECC 6.0

Akzo Nobel (INDIA)

August 2006 - August 2009

SAP BW

Responsibilities

. Monitoring of BW loads through Process chains and Solving load

failures during the data Loads.

. Solving performance-related issues by applying Partitioning,

Aggregates, and Compression.

. Did Re-modelling of the Cube.

. Created BIA Indices on cubes to work on BI Accelerator.

. Created Queries on Multi providers and Info cubes.

. Created Transformations, DTP's between the Objects.

. Designed process chains for Batch job scheduling of loads and Updating

data targets.

. Transported the objects in system landscape.

. Involved in meeting SLA for data loads & development.

Environment: SAP BW 3.5 & BI 7.0, SAP ECC 5.0

Educational Qualification: Post Graduate (Master of Business

Administration)

Graduate (Bachelor of Computer Science)

Contact this candidate