Data Sap

Summary of Experience and Qualifications

Ravikiran has around 10+ years of experience in the area of SAP Sales & Distribution, Business Intelligence, ABAP, BPC NW 10.0 and HANA Studio which includes Analysis, Design, Implementation and Development of data models and reporting solutions.

Implemented 10+ SAP BW and BPC projects with ABAP lifecycle implementation projects effectively translating functional objectives into clear technical requirements and further into high performance data models in various functional areas like SD, MM, QM, APO, FI.

SAP BI Configuration, Design and development of Standard and Custom Info Cubes, Info Object and Data Sources, Multi-Providers, Data store objects (DSO), Transformations, DTPs and Process Chains.

Good knowledge and working exposure on SAP HANA Data Modeling using Data Services, HANA Studio.

Good hands on experience on SLT, native HANA SQL coding.

Trained on SAP HANA S/4

Working exposure on SAP HANA Extended Application Services (XS) using SAP provided application process interfaces (APIs) to interact with SAP HANA, data visualization using business objects

Experienced in SQL scripting for SAP HANA views development

Good knowledge on complete Data Extraction, Modeling and Reporting with proven track record of project and customer satisfaction.

Provided best practices and sanity checks to be carried out during SAP BW, BPC upgradations.

Good working exposure on SAP BPC 10.0 data extractions both master data and transaction data with customizations meeting client requirement and creating input schedules, top side adjustments through Journals, reports with good understanding on consolidation process flow.

Good ABAP skills involve – creation and enhancement of reports, transactions, generic extractor using function module, BAdIs – WriteBack, Routines, retraction and Custom Logic, customer-exits transfer/ update/ start/ end and expert routines, debugging.

Involved in the configuration of Vistex Plug-in with SD module in ECC and configured the BW extractors into LO Cockpit

Configured and customized data sources, Vistex Namespace and number ranges in ECC/BW.

Worked with Customer Rebates module (/IRM/LIS_RM_IPCAHDR, /IRM/LIS_RM_IPCAITM, /IRM/LIS_RM_IPCAKON)

Involved in Production Support and addressed Process Chains failures, Scheduling, Manual Loading (Full/Delta Up-Load), Selective deletion and loading, addressed the tickets/issues related to reports, and Design Enhancements.

Activation and installation of Business Content according to Requirement and Activated Data Source Structures in (ECC). Extracted data from non-R/3 systems such as Flat files and Oracle.

Expertise in creating Reports using Calculated Key figures, Restricted key figures, Variables, Exceptions, conditions using BEx tools and testing the reports for required functionality.

Experienced in leading the teams and delivering solutions in required time lines at the required quality levels.

Worked with BEX Analyzer, BEx Web, Query Designer, Analyzer, WAD and BEx Broadcaster.

Worked with BI Accelerator to improve the read performance of BI Queries on Infocubes.

Developed WebI report, Advanced Analysis reports using BO 4.0 suite with OLAP Universe.

Extensively used BI Launch Pad to create Web Intelligence Reports over the Universe. Extensively worked in WEBI reports

Strong analytical and problem solving skills

Excellent communication, interpersonal, and presentation skills

Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Technical Skills:

ERP SAP BW 7.3/ 7.0/ 3.5, SAP R/3 ECC 6.0/5.0/4.6C, SAP HANA

Reporting Tools BeX, Crystal 2008/XI, BO 4.0,4.1, Tableau

SAP Modules SD, MM, WM, PLM, DP, FI/CO, SAP EPM 10.0 NW

ETL Tools SAP BODS, SAP SLT, Cognos

Systems Windows, HP-UX, UNIX, Sun Solaris, HANA 1.0

Languages ABAP, HTML, XML, C, SQL, PL/SQL, SAP ABAP,

Databases Oracle 9i/8i/8.x, Teradata, HANA

Methodologies ASAP, SDLC

Testing Tools HP Quality Center, Rational Suite

Verizon Wireless, New Jersey Mar 2015 – Till date

Sr. SAP BW HANA Architect Industry: Consumer and Industrial Products

Client Description:

Verizon Wireless is an innovative wireless communications company that connects people and businesses with the most advanced wireless technology and service available. They are the nation’s first 3G wireless broadband network and also the first tier-one wireless provider in the nation to build and operate a 4G LTE network. With 4G LTE.

As the nation’s largest wireless company, Verizon serve 108.6 million retail connections and operate more than 1,700 retail locations in the United States. Globally, they offer voice and data services in more than 200 destinations.

Project Description:

The Business Analytics program at Verizon wireless involves the implementation of SAP Solutions for the first time. Up-Scale the implemented analytical solutions from non-SAP tools to SAP landscape powered by HANA. On a phase by phase Verizon wireless choose to implement its Supply Chain Inventory Management solution on SAP in the first phase.

Responsibilities

Analysis of existing analytics solutions implemented for Verizon wireless

Conduct workshops and training sessions to business in helping to understand the dynamics of SAP implementation process

Gathering requirements and identifying the reporting needs of business

Design and develop Functional and Technical documents for different reports which helps in analyzing the inventory management solution.

Design data flow architecture and Develop custom transactions to extract, modify, download and delete data from non-SAP database tables to SAP landscape

Involved in design & development of cross channel order management (CCOM) allocations.

Involved in defining SAP BW Security roles

Assisted BASIS team in mapping security roles to enable single sign on for users

Design and develop HANA model views for supply chain management process

Integrate SAP BW to non-SAP products like Cognos, Tableau for client specific, management reports

Develop sales planning & forecast reports

Helped in designing and developing data model views for retail store mobile app for better inventory management and stock validations.

Consolidate income and balance sheets for supply chain management department.

Technical Environment: SAP ECC 6.0, SAP BW 7.4 on HANA Database, APO BW, Hana Studio, SAP Fiori1.0, SAP Design Studio, Cognos, Oracle, Tableau 8.2

CenterPoint Energy, Houston, TX Oct 2014 – Mar2015

Sr. SAP BI HANA Developer Industry: SAP Utilities – Power/Energy

Client Description:

CenterPoint Energy (CNP) is a company with more than 5 million metered customers and a long history of service. It is composed of an electric transmission and distribution utility serving the Houston metropolitan area, local natural gas distribution businesses in six states, a competitive natural gas sales and service business serving customers in the eastern half of the U.S., interstate pipeline operations with two natural gas pipelines in the mid-continent region, and a field services business with natural gas gathering operations, also in the mid-continent region.

Project Description:

The ALC Program at CNP is a complete deployment of metering, communications and associated head end systems. The components of the overall system are:

Focusing on the ability to report and score on operation equipment and to determine equipment efficiency, downtime, costs and reasons associated to down time. These report is to be used by the Operations team at Center Point Energy to help maintain their assets.

Responsibilities

Responsible in gathering requirements from customers for asset life cycle management.

Manage the BI & ABAP team and help the team in resolving the technical issues.

Responsible for conducting workshops with clients.

Design and develop Functional and Technical documents for different reports which helps in analyzing asset life cycle.

Develop custom transactions to extract, modify, download and delete data from database tables

Migrate objects from BW landscape to BW HANA landscape.

Involved in SAP landscape Transformation to extract real-time data directly from SAP ECC system into SAP HANA using trigger based mechanism

Developed attribute views, analytical views and calculation view using SQL and CE functions

Enhance datasources, changes in respective Transformations/Routines as well as InfoProviders.

Develop score card and summary reports to track work orders, notifications and transformer performance.

Involved in defining SAP BW Security roles

Assisted BASIS team in mapping security roles to enable single sign on for users

Involve in unit testing, integration testing and UAT testing.

Technical Environment: SAP ECC 6.0, SAP BW 7.3 on HANA Database, SAP HANA 1.0 SPS 8, SAP BOBJ 4.0, WebI, Tableau

Middle Tennessee EMC, Murfreesboro, TN Apr 2014 – Sept 2014

Sr. SAP BI HANA Developer Industry: SAP Utilities – Power/Energy

Client Description:

Middle Tennessee Electric Membership Corporation became the state's largest electric cooperative and the sixth largest in the United States distributing electricity to about 200,000 residential and business members in a four-county area directly south of metropolitan Nashville.

As a cooperative, MTEMC is highly sensitive to the needs and wishes of their customers. As such, all project decisions will be evaluated for their member impact. Also, as a cooperative, customers are really members of the coop and are typically referred to as such

Project Description:

The AMI Program at MTEMC is a complete deployment of metering, communications and associated head end systems. The components of the overall system are:

Focusing efforts on enabling the exploration and in-depth analysis of data regarding the deployment and status of assets and meters throughout the service areas of the Utility. More importantly, it allows us to juxtapose that information against the delivery of services – eventually transforming to the dollars billed and collected from the respective customers.

Responsibilities

Manage the BI, HANA & ABAP team and help the team in resolving the technical issues.

Responsible for conducting workshops with clients and do requirements gathering.

Design and develop Functional and Technical documents for different reports which helps in reconciliation of Meters master data across different sources, service orders tracking and unbilled revenue etc.

Design the process to synchronize master data across three enterprise systems and helped in identifying the missing information, help in enhancing the performance of data loads – master data & transaction data

Involved in defining SAP BW Security roles

Assisted BASIS team in mapping security roles to enable single sign on for users

Implemented SAP Fiori system landscape with HANA Extended Application Services using sidecar approach to compare and visualize asset analytics on customer smart devices.

Extract data from non-SAP sources and design data models in SAP HANA environment

Enhance datasources, changes in respective Transformations/Routines as well as InfoProviders.

Involve in unit testing, integration testing and UAT testing.

Technical Environment: SAP ECC 6.0, SAP BW 7.3 on HANA Database, SAP HANA 10.0 SP 7, BODS 4.0, SAP Fiori, SAP BOBJ 4.1, WebI, Xcelsius

ACH Foods, Memphis, TN Oct 2013 – Mar 2014

Sr. SAP BW BI BPC Developer Industry: Consumer and Industrial Products

Client Description:

In North America, they market, sell and manufacture a premier branded portfolio of cooking oils, spices and seasonings, baking ingredients and foodservice brands in the US, Canada, Puerto Rico and Mexico. It is one of the largest branded consumer oil manufacturers and marketers and also the second leading manufacturer and marketer of spices and seasonings in North America

Project Description:

Our project has undertaken an initiative to deliver a future Integrated Financial Reporting and Budgeting/Forecasting Process and Solution based on SAP’s Business Planning and Consolidation (BPC) solution and related incremental enhancements to their current SAP ECC (CO-PA, GL) system. The goal was to deliver a future state Financial Reporting and Budgeting/Forecasting Solution in BPC that will:

Focusing efforts on Forecasting, Budgeting and Reporting in the areas of Cost Center Expenses, Direct profit and a Company level trading profit, net profit, Balance Sheet, and Cash Flow reporting. While other areas like Capital Expenditure, Trade Promotion, Headcount/Workforce Budgeting, and Strategic Planning will be incorporated in future work orders.

Responsibilities

Manage the BI & ABAP team and help the team in resolving the technical issues.

Re-designed and implemented approach to derive and calculate unit of measure custom logic BadI effectively

Involved in design & implementation of Default logic enhancement for trade profit, cash flow calculations for different modules.

Involved in enhancements of BAdIs for Cost Center, Direct Profit Models

Helped in enhancing the performance of data loads – master data & transaction data, drastically reduced the execution time.

Built Info Cubes, DSO, Hierarchies, Info Sets and MultiProviders and Core Reporting Queries.

Reviewing the functional specifications and incorporating necessary modifications as per Business requirements

Enhancement of datasources changes in respective Transformations/Routines as well as Infoproviders.

Performed enhancements for both the transactional and master datasources and written the ABAP logic for the enhancements in order to meet business needs.

Involved in unit testing, integration testing and UAT testing.

Technical Environment: SAP EPM BPC NW 10.0, SAP BW 7.3 on HANA database, ECC 6.x

T-Mobile, Bellevue, WA Dec 2012 – Oct 2013

Sr. SAP BW BI BPC Developer Industry: Consumer and Industrial Products

Client Description:

As America’s Un-carrier, it is redefining the way consumers and businesses buy wireless services through leading product and service innovation. The company’s advanced nationwide 4G and 4G LTE network delivers outstanding wireless experiences for customers who are unwilling to compromise on quality and value. It currently serves approximately 43 million wireless subscribers and provides products and services through 70,000 points of distribution.

Project Description:

The current “One Source” project aims to solve the inconsistencies of actuals financial data reported from multiple data sources by different groups throughout the organization. The current state has financial data reported from multiple sources including the F1 planning tool (BPC version 7.5 on Microsoft SQL Server), SAP EC-CS (current consolidation tool), and SAP BW (data warehouse fed from SAP R3). The actuals can vary between these systems for a number of reasons including: changing of actuals in F1, timing of entering top-side adjustments back into SAP and pre- vs. post-allocations data from BW.

Once SAP Business Objects Planning & Consolidations (BPC) is implemented, business users can pull their consolidated financial information from one source – BPC. BPC will also support a number of efficiency improvements during the consolidation and reporting processes. Many manual processes to collect and consolidate data for US GAAP and IFRS reporting will be moved into BPC which will free up resource time to work on more value-add processes

Responsibilities

Interacting with the Client Team in understanding the business requirements and coming up with the Design document.

Manage the BPC team and help the team in resolving the technical issues.

Design and developed a Model for Consolidation.

Design and developed a Driver Based Planning Model.

Design and developed BAdIs for Consolidation and Planning Models

Conducted the workshops with the client and finalizing the design Document.

Developed Prototypes for all the Complex requirements.

Customized Lo Cockpit data source to include custom defined fields and populated those fields using customer exits before the setup.

Created Process chains for Master and Transaction data load.

Created Bex Queries for Warranty Report, Inventory Aging, sales representative efficiency, Vendor Delivery efficiency.

Developed Validation reports to check on master data changes.

Developed data models, data flow diagrams, functional design and technical design documents for BI Solutions

Built info objects, master data objects, DSO and info cube

Mapped the third party data to SAP data

Built customized Cubes and Multi provider for Sales; Developed BEx reports

Tested for data integrity, Data load/query runtime performance

Involved in unit testing, integration testing and UAT testing.

Focused on developing team spirit, motivation and Technical knowledge.

Technical Environment: SAP EPM BPC NW 10.0, SAP BW 7.3 on HANA database, ECC 6.x

Southern California Gas Company, Rosemead, CA Sep 2012 – Jan 2013

SAP BW HANA BODS Developer Industry: SAP Utilities – Power/Energy

Client Description:

SoCalGas is a regulated subsidiary of Sempra Energy. Sempra Energy, based in San Diego, is a Fortune 500 energy services holding company. SoCalGas® has been delivering clean, safe and reliable natural gas to its customers for more than 140 years. It is the nation’s largest natural gas distribution utility, providing safe and reliable energy to 21.4 million consumers through 5.9 million meters in more than 500 communities. The company’s service territory encompasses approximately 20,000 square miles in diverse terrain throughout Central and Southern California, from Visalia to the Mexican border.

Project Description:

Design a robust approach to Advanced Asset Analytics and Meter to Cash Analytics focused on enabling the exploration and in-depth analysis of data regarding the deployment and status of assets and meters throughout the service areas of the Utility. More importantly, it allows us to juxtapose that information against the delivery of services and consumption of power – eventually transforming to the dollars billed and collected from the respective customers, i.e. Cash using SAP HANA and BO Dashboards reporting tools.

Responsibilities

Design and Develop Data Models for Advanced Asset Analytics capturing Asset Telemetry and Residual Life Analytics, Asset Risk Portfolio and What-if Analytics and Asset Failure Analytics on SAP HANA Studio.

Design and Develop Data Models for Meter to Cash Analytics capturing Meter Event Analytics and Customer Consumption Analytics on SAP HANA Studio.

Analyze and compare these analytics with SAP Smart Meter Analytics

Worked on KPIs:

Risk Management

Failure Management

Service Management

Built Webi and Xcelsius reports

Used Calculation and Analytical views

Custom extractors was used to bring in the Smart Meter data

BW DSOs was used as the source, BODS was used to pull data into HANA and reporting was done in BOBJ

Technical Environment: SAP HANA 1.0 Studio, SAP BOBJ 4.0 – IDT, Dashboards, SAP BODS 4.0

Sysco Foods, Houston, TX Dec 2011 – Aug 2012

SAP BW BPC ABAP Developer Industry: Consumer and Industrial Products

Client Description:

One of the largest food service distributors in North America. It distributes frozen foods, various canned and dry foods, fresh and frozen meats, seafood and poultry, imported specialties, and fresh produce. The company also supplies various non-food items, including disposable napkins, plates, and cups; tableware, cookware, restaurant and kitchen equipment, and cleaning supplies.

Project Description:

The client has outlined a strategic intent to significantly grow and develop its business. This project is an end to end re-implementation of its data warehouse management in SAP BI, where in we have the scope of developing complete custom flows starting from Data Source creation to BEX Query, developing Webi reports, Crystal Reports and BO dashboards; Also involving planning and consolidation of data using BPC NW.

Responsibilities

Worked on Business Transfer of customers between different Business operating companies in APO BW within SAP to SAP

Worked on extraction of Sales Order data from ECC system directly into APO BW system without disturbing delta load of SAP BW system.

Worked on Business Transfer of customers between different Business operating companies in APO BW from third-party systems like SUS to SAP

Worked on purchase, sales and chargeback rebates implementing custom rebate basis logic using SAP – Vistex

Involved in enhancements to P&L forecasting using custom logic BADIs in BPC NW

Involved in data load monitoring with effective bug fixing as and when an issues arise.

Prepare and Executed Test Cases for queries in Development Test and Production Server.

Involved in collection and transport of objects to quality & production systems

Involved in unit testing and Integration testing with client in APO BW.

Technical Environment: SAP R/3, SAP BW 7.0, BPC 7.0 NW, SAP APO BW, SAP BW 7.3 (checking new features)

Kelloggs, Battle Creek, MI Nov 2010 – Dec 2011

SAP BW BPC ABAP Developer Industry: Consumer and Industrial Products

Client Description:

Client is a leading consumer goods manufacturer in Food and beverages industry for more than a century. It is the world’s leading producer of cereal and a leading producer of convenience foods, including cookies, crackers, toaster pastries, cereal bars, fruit-flavored snacks, frozen waffles and veggie foods.

Project Description:

The client has outlined a strategic intent to significantly grow and develop its business. This project is an end to end re-implementation of its data warehouse management in SAP BI, where in we have the scope of developing complete custom flows starting from Data Source creation to BEX Query, implementation of standard BI content; Also involving planning and consolidation of data.

Responsibilities

Worked on retraction of CCA data from BPC to SAP ECC system using BAdi.

Extraction of actual and planned data from BPC into BW cubes for Bex Reporting.

Created custom data sources for custom hierarchy.

Generic data source creation to extract Red K price using function module.

Data Source Enhancements using BADIs.

Involved in BI business content installation in Client server.

Involved in Migration from SAP BW 3.5 to SAP BI 7.0

Worked on Customer Exits for query variables and Virtual Key Figures and Characteristics

Involved in Estimation and Designing of Technical Documents for Functional Specifications.

Extracted data from CRM data sources to BW and generated reports as per customer requirement.

Prepare and Executed Test Cases for queries in Development Test and Production Server.

Technical Environment: SAP ECC 6.0, SAP BI 7.0, BPC 7.0 NW

Fiat, Italy Jun 2009 – Nov 2010

SAP BW ABAP Developer Industry: Automobiles Manufacturing

Client Description:

It’s an Italy based leading automobile manufacturers in Europe for more than a century. With it’s a wide range of products able to meet the most diverse mobility and transport needs, over a hundred years of experience helped it expand throught out the world making it one of the leading automobile manufacturer.

Project Description:

The project is about development of transactional reports, forms, custom transactions, data migration from its legacy systems to SAP along with end to end implementation of its data warehouse management in SAP BI.

Responsibilities:

Involved in Design and Development for new Enhancement requirements.

Created new reports according to the user requirements which also involved Jump Queries.

Created Technical design for pricing simulation.

Involved in Estimate and Execute Change Requests.

Involved in reconciliations process for major scenarios and Involved in rectification process if there is any disturbance between R/3 and BW, preceded with rectification plans.

Created and Maintained Info spokes through Open Hub Services (OHS) to export data from data target to External Logical system.

Generated an online report that SWCC (Client Basis Team) can use immediately before importing a transport into production to prevent overwrite with Back version of objects.

Implemented a BAdi enhancement to verify the versions of objects at the moment of release of a transport.

Created a Back order reports to help client in successful deletion of back orders related to a sale order simultaneously selecting different line items.

Generated reports to calculate monthly budgets, cost plans and implemented BAdis to increase expenses on internal orders and decrease budget related to Goods Movement in warehouse.

Co-ordinate all activities between Off-shore On-shore teams and communicate effectively with client team.

Daily monitoring the 6 production systems and implement solutions when a disruption occurs in any data loading processes.

Used Clear Quest tool to maintain the tickets and activities history.

Communicated effectively with client and brought long standing issues to closure.

Handled High priority Tickets and successfully got them to closure on time.

Trained newly joined junior level resources in the project and assisted the team members whenever required.

Transferred KT to associate team members.

Technical Environment: SAP ECC 6.0, SAP BI 7.0

Fiat, Brazil Feb 2007 – May 2009

SAP BW ABAP Developer Industry: Automobiles Manufacturing

Client Description:

It’s an Italy based leading automobile manufacturers in Europe for more than a century. With it’s a wide range of products able to meet the most diverse mobility and transport needs, over a hundred years of experience helped it expand throught out the world making it one of the leading automobile manufacturer.

Project Description:

The project is about development of transactional reports, forms, custom transactions, data migration from its legacy systems to SAP along with report generations for forecasting.

Responsibilities:

Enhancing existing functionalities with the help of BADI.

Solving the critical issues in time and providing a quick response to client’s queries.

Has performed the unit Testing and helped on-site team in integration Testing.

Has prepared the Technical design, Test Scripts.

Developing RFCs, BAPIs and configuring Interface architecture though IBM JCA Adaptor

Involved in monitoring process chains and reporting errors if any to client team

Performing end to end testing and prepared test documents based on different test conditions.

Make modifications to the objects based on the CRs in the specified time lines.

Being Mentor to ASEs in the project by helping them in learning interfaces according to business scenarios

Technical Environment: SAP ABAP- Enhancement Framework, BW 3.5, BADIs

Lanxess, Germany Apr 2006 – Feb 2007

SAP BW ABAP Developer Industry: Chemical, Resources & Energy Service

Client Description:

Client is a leader in specialty chemicals and operates in all important global markets. Its core business comprises the development, manufacture and sale of plastics, rubber, specialty chemicals and intermediates. In addition, it supports its customers in developing and implementing made-to-measure system solutions in chemical industry.

Project Description:

The project is about development of transactional reports, forms, custom transactions, data migration from its legacy systems to SAP along with report generations for forecasting.

Responsibilities:

Involved in writing ABAP routines in update rules, transfer rules.

Developed Smartforms,

Worked on ALV reports,

Worked on module pool programming

Has prepared the Technical design, Test Scripts.

Performed unit testing and prepared test documents based on test conditions.

Has performed the unit Testing and helped on-site team in integration Testing.

Track External defects in Solution Manager

Resolve the tickets related to the objects assigned

Make modifications to the objects based on the CRs in the specified time lines.

Provided Knowledge sharing session on Smartforms to fellow project members

Education

Bachelor of Technology, Information Technology

Jawaharlal Nehru Technological University, India

Trainings

Gave presentation on SAP River to people from different companies

Provided Overview of SAP BW 7.3 to teams at different locations in current project.

Provided Class room Training on SAP BW at cross teams level.

Provided Class room Trainings to cross teams and within team on ABAP for BI.

Technical Publications

Published a white paper on 'How To…Create, Transport and Reuse Custom Measures across different environments' in SAP SCN.

Published a white paper on 'BPC 10.0 Step-by-Step Guide For Custom Measures Formulae Transport' in SAP SCN.

Contact this candidate