Sarath M Sunny

SAP BW/ BPC

Techno-functional consultant with about 6+ years’ experience in SAP-BI/BW 7.0/7.3, SAP-BPC 7.5/EPM 10.0, SAP ECC 6.0, SAP BO 4.0 and ABAP with main exposure in Media & Telecommunications Industry and Pharmaceutical Industry.

Involved in Client Interaction, Blue print, Design, Build and Maintenance phases.

Well versed in understanding functional needs and converting to technical solutions.

SAP BW Data Staging and Modeling: Extensively worked in designing and configuring back-end components including Extractors, InfoObjects, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, InfoCubes, MultiProviders, ODS/DSO, InfoSets, InfoPackages and Data Transfer Process (DTP).

Expertise in DataSource Enhancement, User Exits, Loading, Scheduling, Monitoring, Process Chains, Open Hub Service.

Proficient in Development and Production Support issues which involved debugging ABAP routines, Data loads, Validation and trouble shooting of Transaction Data and Master Data, Change management, Process Chains Monitoring, Transport Management, Roles & Security, System Checks.

SAP Data Extraction: Strong background in data extraction from flat files, DB connect, LO extraction, setting up of delta, replication of extractors and creation of Delta Queue. Also development of BAdIs to populate newly added fields in the standard extractor.

Strong knowledge in Data Extraction, (Full/Delta) Data loads, ETL, Scheduling, Monitoring and Data Modeling.

Transports: Experience in transporting BW objects from Development system to Quality and Production systems.

SAP Generic Data Extraction: Expertise in building Generic extractor based on Tables, Views and Function Modules, working with Extract structure and testing and debugging of data in extraction checker

Replication of Metadata of new and enhanced extractors in BW system

SAP BW Process Chains and Data load Monitor: Experience in creating process chains, automating overnight data loads and monitoring of the loads.

ABAP: Expertise in creating custom ABAP programs/includes for implementing in Function module based extractors, BAdIs, for application server file selections, and creation of Start routines, End routines and Field routines

BI Reporting : Expertise in BEx Query Designer and BEx Analyzer

BEx Query Designer: Expertise in creating complex Custom BEx queries as per business requirement, Customer Exit for BEx variables, Custom structure, Formula variables, Global and Local Calculated Key Figures and Restricted Key Figures, Exception aggregation, Cell definitions and Formulas.

Performance tuning of BEx reports: Worked on measuring the query run-times and performance tuning by creating aggregates, doing Rollup, compression and partitioning. Also used other techniques like using Inclusions instead of Exclusions, suppressing result rows, using SAP Exits wherever possible instead of Customer Exits, less number of Joins etc.

SAP BPC implementation : Expertise in Creation of SAP BPC Reports and Input Schedules, Data Load, Currency Conversion and Group Currency Conversions

Strong background on Integration of SAP BW with SAP BPC using transformation files, Conversion files and Data Manager Packages

Running BPC loads from BW system through Process chains using custom created variants or answer prompts

Supported post go-live of projects

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Created End User Training materials for the end users and conducted Knowledge Transfer sessions.

Excellent communication, analytical and problem solving skills with ability to work independently and as a team player

Good Knowledge and understanding on SAP BOBJ – Crystal Reports

SAP NetWeaver BI 7.0/7.3, SAP BEx

SAP ECC 6.0

SAP BPC 7.5, EPM 10.0

SAP BO 4.0

Microsoft Visio

SAP ABAP/4

MS Office Suite

SQL, C,C++ programming languages

SAP HANA (Training)

Bachelor Of Technology in Computer Science Engineering

Deloitte Consulting June 2011 – Till Date

SAP BI/BW/BPC Consultant

Project #5

Client : Novartis

Location : Hanover, NJ

Role : SAP BI/BW Consultant

Novartis International AG is a Swiss multinational pharmaceutical company, ranking number one in sales among the world-wide industry. The company has core businesses in pharmaceuticals, vaccines, consumer health, generics, eye care and animal health.

Roles & Responsibilities

Worked in complete BI flows for master and transactional data consisting of various SAP Modules like FI, MM, SD, LO cockpit.

Migration of data flow from 3.5 TO 7.0.

Worked extensively on LO Cockpit. Loaded the data from R/3 to BW and used Initialization with Delta Update and Full Update methods.

Generic Extraction, Enhancement of standard data sources and setting up delta, replication of extractors in BW and creating Delta queues for extraction from R/3 to BW.

Created, activated and worked on a daily basis with Info sources, Info packages, Info package Groups, Info objects, DSO, Info cubes, Queries, Variables, Calculated & Restricted Key Figures.

Extensively involved in Activating Business Content for Standard Infocubes, InfoSources & InfoObjects as per the Client Requirements.

User Exits and Enhancements.

Used Delta Initialization, Full and Delta mechanisms for uploading data in BW

Designed and created Process Chains for master and transaction data loading from flat files and info providers. Also scheduled them to run at regular intervals. Monitored and analyzed the runs.

Worked on BEx reports and its Analysis through the use of Filters, Variables, Conditions, Exceptions, Restricted Key Figures, Calculated Key figures, Customer Exits and Replacement Paths.

Requirement gathering, design, development and testing of BW flow

Writing ABAP codes for Function Module based extractors, Start/End routines and BAdIs.

Extensively Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from ECC to BI system.

Understood the Client requirement, prepared the technical specification of the report requirements.

Performed Unit testing and Performance testing for all new developments.

Constant interaction with the Client team at all stages – Requirement gathering, design and development.

Created ODS, Infocubes, Multi-providers and Infosets and extracted SD data (Data sources Like 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit(LBWE) extraction.

Handled performance tuning of query response time by building aggregates and indexing on InfoCubes, InfoCube compression, worked on InfoSet queries.

Created documentation to facilitate the knowledge transfer during the go-live.

Transported BW objects to QA & Production system

Environment: SAP BI/BW (7.3), ECC 6.0, SAP BEx Analyzer.

Project #4

Client : Warner Bros. Entertainment

Location : Burbank, CA

Role : SAP BI/BW/BPC Consultant

Warner Bros. Entertainment Inc. (WB) is an American media company that makes film, television and music entertainment. It is one of the major film studios with its headquarters in Burbank, California. Warner Bros. has several subsidiary companies, including Warner Bros. Pictures, Warner Bros. Interactive Entertainment, Warner Bros. Television, Warner Bros. Animation, Warner Home Video, New Line Cinema, Castle Rock Entertainment, DC Entertainment, and the former The WB Television Network. Warner Bros. owns half of The CW Television Network.

Roles & Responsibilities

Worked on design and development of BW flows for EIS and LLP (Local Language Production).

Developed technical specifications based on the functional specifications to ensure the correct development of the solution to satisfy the business need.

Developed complex start, field, end routines, user exits & expert routines to facilitate custom business requirements like Amortization concept.

Created custom BW components including InfoObjects, DSO’s, InfoCubes, MultiProviders, InfoSets, Transformations, InfoPackages & DTP’s as required by technical specifications

Created Write-optimized and Standard DSOs as per business requirement in different BW layers.

Worked in ABAP routines – Start routine, End routine and Expert Routines in transformations – written codes for master data look-up, filtering data from source package, used function module for various conversions, etc

Worked on the SAP BW-SAP BPC Integration-Master Data Loads, Hierarchy and Transaction Loads for Theatrical and Overhead model.

Expertise in creation of Transformation and Conversion logic for data flow.

Created Process chains and implemented them in Data Manager Packages so that they can be triggered from the BPC environment and the complete flow of data happens as required.

Develop custom data model using InfoObjects, InfoCubes, Standard and Write- Optimized DSO, InfoSets and Multiproviders.

Used Delta Init, Full and Delta mechanisms for uploading data in BW

Automated loading of data using Process chains which has Meta chains

Writing ABAP codes for Function Module based extractors, Start/End routines and BAdIs.

Created aggregates to improve query performance.

Performed Unit testing and Performance testing for all new developments.

Constant interaction with the onsite team on all the requirements, Issues, changes and status updates.

Design & Develop automation of data loads (Master and Transaction data) from BW to

BPC via. BPC Data Manager Packages, BW transformations and DTP’s.

Design & Develop customized & interactive Input layouts and Reports using EPM10

Unit Testing on individual functions, reports and input schedules

For transport of Objects, a separate method called Charms were used. I was in charge of creating the Charms as required to capture the objects.

Environment: SAP BPC 10.0 NW,SAP BI 7.0, SAP ABAP, BW

Project #3

Client : Sony Pictures Entertainment

Location : Culver City, CA

Role : SAP BI/BW /BPC Consultant

Brief Description of Project:

Sony Pictures Entertainment Inc. (SPE) is the American entertainment subsidiary of Japanese multinational technology and media conglomerate Sony. It is a member of the Motion Picture Association of America (MPAA).This project includes SAP BPC implementation of all Close, Consolidation and Reporting (CCR), Integrated Planning (IP), Amortization & Ultimates and Cash Flow Forecasting (CFF).

Roles & Responsibilities

Worked on developing BPC reports for Consolidation of actuals & Cash Flow Forecasting and BPC Input schedules for consolidation of Budget

Worked on the SAP BW-SAP BPC Integration-Master Data Loads and Transaction Loads for Cash Flow Forecasting, Integrated Planning and Consolidation of Budget.

Expertise in creation of Transformation and Conversion logic for data flow.

Worked on BADI Implementation on Work Status to lock, approve and submit

Created Process chains and implemented them in Data Manager Packages so that they can be triggered from the BPC environment and the complete flow of data happens as required.

Worked on creating the Report specifications and Design documents

Daily trouble shooting of Incidents, Implementing changes and requests.

Involved in submitting the Ticket Status (open/close) report. Maintain Work History for all the Tickets until it is closed down.

Develop custom data model using InfoObjects, InfoCubes, Standard and Write- Optimized DSO, InfoSets and Multiproviders.

Used Delta Init, Full and Delta mechanisms for uploading data in BW

Automated loading of data using Process chains which has Meta chains

Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains

Worked on activating the Standard Business Content object like Info Cubes, ODS Objects, Info Objects etc.

Writing ABAP codes for Function Module based extractors, Start/End routines and BAdIs.

Performed Unit testing and Performance testing for all new developments.

Constant interaction with the onsite team on all the requirements, Issues, changes and status updates.

Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.

Involved in creating UAT/BAT test scripts and Sessions with the analysts and given training

Environment: SAP BPC 10.0 NW,SAP BI 7.0, SAP ABAP, BW

Project #2

Customers : S C Johnson

Location : Deeerfield, IL

Role : Business Technology Analyst (BI/BW/BPC)

Brief Description of Project:

The Client is a privately held, global manufacturer of household cleaning supplies and other consumer chemicals. It has operations in 72 countries and its brands are sold in over 110.This project includes SAP BPC implementation of all Close, Consolidation and Reporting (CCR) and Financial Planning & Analysis (FP&A) processes.

Roles & Responsibilities

Worked on BPC consolidation reports (balance sheet,Income statement etc.) and planning input schedules

Worked on data manager packages (data loading and copying).

Interacted with the onsite team on reporting requirements, Issues, changes and status updates.

Worked on creating the report documentations and other design documents

Created transformation and conversion files to use in the Data manager packages for BW-BPC integration

Environment: SAP BPC, NW,SAP BI 7.0, SAP ABAP

Project #1

Client : AMD, Diversey

Location : Austin, TX

Role : Business Technology Analyst (BI/BW)

Brief Description of Project:

Advanced Micro Devices, Inc. (AMD) is an American worldwide semiconductor company based in Sunnyvale,California, United States, that develops computer processors and related technologies for business and consumer markets.

Diversey, Inc., formerly JohnsonDiversey, Inc., is a Racine, Wisconsin provider of cleaning and hygiene products to the institutional marketplace, serving lodging, food service, retail, health care, food and beverage companies, as well as building service contractors worldwide

Roles & Responsibilities

Reviewed Vistex Functional Specification for Summary Report for Agreements, Accruals Aging Report & Customer Dashboard report.

Did documentation of 30 reports in 2 weeks going through each object one by one in BEx Query Designer.

Analyzed all those queries in SAP BW 7.0 and did relevant documentation.

Analyzing the Requirement of the Functional specification.

Environment: SAP BW 7.0, SAP R3 4.7

GSTI Technologies India PVT LTD June 2009 – June 2011

Client: Forest Labs

Role: SAP BI/BW Intern

Key Responsibilities:

Creation of Data models using Functional specs given.

Involved in maintaining Info Cubes, ODS, Info Objects, Info Areas, Multi Cubes, Info Sources, Data Sources, and Info Packages

Building Process chains and scheduling them.

Creating Documentation of complete flow

Maintenance of Daily process chain runs.

Created BEx queries using the Bex Analyzer in SAP BW

Wrote ABAP field routines.

Environment: SAP BW 7.0, BPC

Contact this candidate