Sap Bw
Resume:
Ram Prasad. Ambati
SAP BI-BO Consultant
mailto: ****.*********@*****.***
. 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