Manager Data

Ravi Ambavaram

*********.****@*****.***

**** ******* *****, ******, ** 75035

972-***-****(Cell)

Citizenship status: U.S. Citizen

Objective: Looking forward for a challenging role as a Consulting Manager in SAP BW implementation projects pertaining to SAP SD, MM, FI/CO, CO-PA, SPL, AP, AR, GL, CCA, PCA and HR modules.

Professional Summary:

Over 20+ Years of experience in database design, data warehousing, dimensional modeling, ETL, data loading, Report generating, Performance Tuning, Optimizing SQL, Business Objects Universe, Web I reports.

15+ Years of experience in SAP BW/BI, Business Objects working for Fortune 500 Companies like EDS, Quadrem, Bluecross Blue Shield, MCI Communications/Skytel communications.

5 Years of experience as Oracle and SQL Server DBA.

Involved in 7 Projects which includes Full life cycle implementation, upgrade from 3.X to 7.0 Enhancements and Post Production Support in the areas of SAP Logistics SD, MM, Financials (FI/CO), COPA, SPL, AR, AP, GL, CCA, PCA, and HR modules.

Experienced with Onsite-Offshore model of work.

Worked as Business Analyst and as a Team Lead and directly interacted with the Business People (End users & Power Users) for the requirements.

Extensively Worked on Reports like Dashboards and Scoreboards for prominent level Management.

Trained the existing team in BI 7.0 (NetWeaver 2004s) and End users & Power Users.

Quick study who rapidly assimilates into organization and employs innovative ideas, concepts, methods and technologies to support business objectives. Thrive in both independent and collaborative environments.

Energetic and self-motivated team player. At ease in high stress and fast-paced environments requiring the ability to effectively handle senior level responsibilities.

SAP Experience – Summary

SAP BW Release: SAP Net Weaver 2004s (BI 7.3), 3.5, 3.0B, 2.1C:

ECC 6.0

Data Warehouse Architecture and Multidimensional Data Modeling – Designed and Development of InfoCubes, MultiCubes and Remote Cubes based on the data analysis and reporting needs, defining complex routines.

Extraction, Transformation and Loading of Data (ETL) - Preparing SAP R/3 for SAP BW using Methods like LO CockPit Extraction, COPA Extraction and defining the loading strategies, initial and delta data loads using IDOCs and PSA (TRFCs) loading, scheduling and monitoring data loads.

Reporting and Analyzing SAP BW data - Defining queries using the BEx Analyzer & Browser to deliver SAP and non-SAP BW information in an organized fashion. Executed the reports from 3rd party reporting tool by pulling data directly from BI.

Performance improvement- Optimizing data loads, index management, defining InfoCubes aggregates, query optimization.

Adavnced Concepts in Net weaver 2004S (BI 7.0):

Worked on Data transfer process(DTP), Data warehousing workbench, DSO’s, remodeling toolbox, tree search generic search, DSO object structure.

Extensively used ABAP in Start, End routines, Transformations, User Exits and Enhancements.

Worked in error handling using error stack, Temporary data storage, Process chain, flexible execution path.

Worked on BEx Report Designer, BEx Analyzer, BEx Web Application Designer, Information Broadcasting, Integration Planning, Portal Integration, Application Process Designers (APD’s).

Extensively worked on the Performance Tuning of the System.

SAP R/3 Release: 4.6C, 4.7E, ECC 6.0,4.0.

ABAP Development Workbench, Data Dictionary (DDIC).

Valuable experience in find and Implement OSS notes to enhance Different Data sources.

Good understanding of Functional and Technical in SAP Industry specific modules like IS-U/CCS, IS-MEDIA.

Company

Dart Container-Accenture

Role

Digital Data Engineering Associate Manager-Batch design implementation Architect

Industry Type

Consumer, Manufacturing, Products

Duration

November 2017 to Present

Environment

ECC 6.0, BW 7.3 Bex

Optimization of BW data loads, Process chains for the existing environment.

Provided Solution design and Technical design for Audit reports.

Manage off-shore team and helping them out in developing the applications, and reports.

Analyzing the new data flows and representing the flows in the Process chains considering the load balancing of the servers.

Company

Lockheed Martin-Accenture

Role

Digital Data Engineering Associate Manager-Software Implementation Tech Practitioner-SAP HANA Modeler

Industry Type

Aeronautics

Duration

September 2017 to November 2017

Environment

ECC 6.0, BW 7.3 Bex, HANA,

Hana Modeling -Developed Attribute, Analytical and Calculation views.

Optimized SQL scripts in Calculation views.

Performance improvement of HANA models.

Company

Miller Coors-Accenture

Role

Digital Data Engineering Associate Manager-SAP Data Modeler with Power designer (SD-OTC)

Industry Type

CFG-Packaging

Duration

May 2017 to July 2017

Environment

ECC 6.0, BW 7.3 Bex, HANA, SAP Power Designer

Good functional process knowledge in FTS, MTD and OTC functional modules.

Used SAP Power Designer tool to create logical and physical data models for Adhoc claims, Shipping, Delivery, Sales Order, Master data.

Reverse engineered the existing SAP HANA models into physical data model.

Participated in Business Process workshops, Gathered Business Requirements and Prepared the Business Blueprint

Strong technical and architectural expert with prior experience in designing SAP EDW Applications.

Company

Alcon (Novartis)-Accenture

Role

Digital Data Engineering Associate Manager-Techno Functional role (BW -SD/OTI)

Industry Type

Life Sciences

Duration

April 2016 to April 2017

Environment

ECC 6.0, BW 7.3 Bex, HANA, OBJ4.0, BO Analysis

Worked with Business users to discuss about the requirements and translated the requirements into Functional Specification.

Supported the technical team and helping them out regarding functionality and handing over the work to them.

Gained knowledge about Novartis system procedures, processes and policies and trained the new team members regarding these areas.

Used Solution Manager extensively in checking in the functional specification document, test scripts, data model design diagrams, query layout, data mapping documents.

Prepared functional specification for a sample management project where the trial consumption is compared to revenue by providing a data model which loads threshold percentages by product family. Reports are developed to provide the business users about the trial consumption of the products. Involved in testing the scenarios.

Prepared functional specification for an interface which is designed to import forecast files, inventory and customer service information into BW system. The goal is to merge this data with Billing and Forecast (APO) models to understand the forecast and inventory trends based on the customer level. Involved in testing the scenarios.

Contact this candidate