Hema Shankar Reddy SAP HANA-BW-BO LEAD CONSULTANT

248-***-**** X 108

PROFESIONAL SUMMARY:

A result oriented professional with 12 years of experience working on SAP HANA, BW and BO across several functional areas and industry verticals. Implemented five full life cycle projects in SAP BW 7.4 on HANA, BW 7.3 on HANA, BI 7.0, BW 3.5 and BO 4.1.

Worked in major BIG 5 Consulting firms like IBM, ACCENTURE and worked on projects related to a multitude of industries like Oil & Gas, Financial Services, Food & Nutrition, Speciality Chemicals, Pharmaceutical and Consumer Packaged Goods.

An enterprising leader with proven abilities in leading teams towards achievement of product and organizational goals

Extensively implemented SAP BW solutions, which leveraged business intelligence that resided in transactions to drive executive queries, decision-making and what-if analysis.

Active participation in all phases of BW project including requirements gathering, modeling, design & development, extraction of data, reporting, performance tuning and transportation.

Sound knowledge in various data design models- Entity Relationship(ER), Multi-Dimensional/ Star Schema and Extended Star Schema models.

Expertise in analyzing, designing, creating and maintaining Info Objects, Info Cubes, ODS objects, Remote Cubes, Multi Providers, Info Sources and Extract Structures.

Expertise in Flat file, Generic Data Source, LO Cockpit, FI, CO and COPA extraction.

Customizations - Experience in activating standard Business Content, extending and enhancing Info Cubes according to the requirements, Data source Enhancements, User Exit Variables, Virtual Key Figures, Start Routines and Formula Builder.

Performance Tuning - Evaluated statistical performance using BW Statistics and suggested recommendations to Basis support for optimization. Improved data load and query performance by doing Compression, creating Aggregates, Rollups, Partitioning, Indexes, and Data packet size.

Experience in BW components like Scheduling, Process Chains, Data Mart, Legacy Systems, XML and DB Connect.

Experience in automating loads using Meta Chains, Process Chains and use of BW Monitor to supervise data loading.

Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, Restricted Key figures, Structures, Variables, Exceptions, Conditions, and Jump queries.

Developed Executive Dash Board using Micro strategy, Web reports, Web items, Customized web templates using Web Application Designer (WAD), Report Designer and Query designer.

Production Support Extensive experience in support, Data loads, Validation and troubleshooting of transaction data and Master data, Change management, Transport Management, Roles & Security, System Checks, Performance tuning and process chains.

ABAP Knowledge for developing business logic in Transfer and Update routines and enhance the Datasource User Exits.

Expertise in debugging Function modules, BADI’s, User exits and Start, End and expert Routines.

Expertise in developing reports using Analysis for Office(AFO) and Analysis for OLAP.

Build Dashboards using SAP BO Dashboards (formerly Xcelsius) and Design Studio based on requirements of different reports.

Expertise on building interactive applications by using design studio scripting language.

Experience in implementation of back end features and new reporting features in SAP BI 7.0.

Experience in SAP HANA Data Modeling and Data Provisioning using BODS and SLT.

Expertise on developing data flows for FI-GL, CCA, PCA, COPA, SD, HR and APO data sources in BW on HANA.

Expertise in conversion of 3.x data flows to 7.x data flows

Experienced in loading data from tables in HANA Database to BW data marts

Sound knowledge on LSA++ design for BW on HANA.

Worked on HANA models and created BO reports on HANA models.

Implement: Create database schemas, Attribute View, Analytic View, Calculation View, develop scripts and establish data feeds (SLT & BODS).

SAP BW modeling of complex data flows for building ADSO’s, Open ODS views, Composite providers.

Modelling of SAP HANA objects and developed Attribute Views, Analytic Views with various join conditions and calculation views using both Graphical and SQL script based methods.

Expertise and hands on experience in SAP HANA programming including SQL, SQL Script, and CE Script development.

Experienced in integration of HANA with Hadoop with Smart data access.

Expertise in data archiving from HANA to Hadoop as NLS by using SQOOP.

Excellent communication and interpersonal skills, and the ability to interact and collaborate with other IT teams including application development, testing, operations, and project management office as well as business customers and external vendors.

SKILL SUMMARY

Data Warehousing SAP BW 3.0B, 3.1C, 3.5, 7.0, 7.3, 7.4, HANA 1.0 SP 07/08/09

Reporting Tools BEX, SAP BO 4.x, WEBI, Crystal Reports, Xcelsius / Dashboarddesign tool, Design Studio 1.4, SAP BO Analysis edition for OLAP and Office, SAP Lumira

Languages PL/SQL, ABAP/4, Java Script

Data Bases Oracle, SQL Server, DB2, SAP HANA DB

ERP SAP R/3 4.7, 4.6C, APO, ECC 6.0

PROFESSIONAL EXPERIENCE / PROJECTS:

Client: PCG, Princeton, NJ Mar 2016-Till date

Project: NJ EdPlan Advance Reporting

Role: Sr.BW BO Lead Consultant

Environment: BO 4.1 SP4, WEBI, BODS 4.1, SQL Server 2008, EasyIEP, SAP BW7.4 on HANA

Responsibilities:

Created Best Practice documents for WEBI reports.

Created the templates for Requirement gathering document, Functional design document, Technical Design Document, WEBI report QC and Unit Test templates.

Responsible for conducting workshops to gather requirements.

Designed and developed data feed interfaces from Easy IEP using BO Data services.

Designed the data flow for advance reporting in BW.

Involved in creating InfoCubes, Advanced DSO, Composite Provider, Open ODS View, DSO Objects, InfoObjects, Transformations, InfoPackages, DTP'S and DataSources.

Developed the Universe for AR Reporting using IDT.

Designed and implemented 30 WEBI reports for NJ Special education.

Involved in UAT and fixed the bugs identified during UAT.

Trained the users and in-house technical AR team in WEBI.

Client: SYSCO CORP, Houston, TX April 2015-Feb 2016

Project: Head Count Planning

Role: SAP HANA BW Lead Consultant

Environment: SAP BW 7.4, SAP BPC 10.0 NW, SAP HANA SP8/9, ECC 6.0, Design Studio 1.4, BO 4.1, BODS 4.1, Analysis for Office(AFO) and SOLMON

SAP Modules FI-CO, PS, HCM, BPC

Responsibilities:

Prepared blueprint design document for headcount planning

Configured the SAP BW, ECC 6.0 Data Store connections to SAP BODS 4.1

Design and build Headcount transactional and Master Data flows in BW landscape based on reporting and forecast requirements for headcount planning from underlying source systems ( Corporate, field, SBS )

Designed and created Attribute Views and Analytical views for Head count Reporting using graphical and Sql Scripts. Created input parameters, variables

Involved in creating InfoCubes, Advanced DSO, Composite Provider, Open ODS View, DSO Objects, InfoObjects, Transformations, InfoPackages, DTP'S and DataSources.

Building transformation files to load the data from BW and flat files into BPC dimensions ( Employee and Job ) and HC_PLANNING model

Building Data manager Packages for loading BPC dimensions (Employee and Job) and HC_PLANNING model.

Created Universe (.unx) against BW Head count composite providers and developed WEBI reports for HR Module.

Created the Head Count dashboard using Design studio.

Understanding of REMEDY and Solution Manager CHARM process for migration of objects through landscape

Extend the headcount reporting framework to other Meat companies at SYSCO CORP

Prepare the test plan and conduct User Acceptance Testing with business community and ensure deliverables as per the signoff agreement

Client: Johnson and Johnson, New Brunswick, NJ Sep 2013-Mar 2015

Project: Back to Basics

Role: SAP BW HANA Lead Consultant

Environment: SAP HANA SP8, BW 7.3 on HANA SP8, HANA XS, BOBI 4.1, BODS 4.1 & ECC 6.0, Analysis for Office(AFO), Analysis for OLAP, Design Studio 1.4, Hadoop, Sqoop

SAP Modules SD, MM, HCM, FI-CO, APO

Responsibilities:

Developed data flow In FICO, SD and HR area. Worked on FI-GL, CCA, COPA, SLOB (Inventory), Open Sales Order, Head Count and Dispute Management interfaces and Reports.

Gathered and analyzed the requirement to replicate the ECC content in HANA using the Real-time SLT Process

Developed semantic partitioning objects, utilized HANA functionality to optimize the info cubes, and utilized memory capabilities to take advantage of HANA views- analytical, calculated, and attribute using HANA studio.

Created the Visualization Reports in SAP BOBJ Explorer 4.0 based on the Analytic Views, Calculation views and Universes using measures and Facets on the Information Spaces.

Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and various activities.

Involved in SAP HANA Security including User Management, Roles, and Privileges, Reporting, Accessing Analytical and Calculation views from EXCEL.

Migrated HANA SQL Scripts, Model objects from DEV to STG and STG to PRD

Migrated tables to other nodes in DEV/STG/PRD and monitoring system performance for PRD (checking for locks/long running threads etc)

Monitoring and Troubleshooting data loads in HANA environment.

Developed SQL Scripts, created calculation views, and develop reports with calculation views.

Created BOBJ Universes based on HANA views using IDT and created WEBI reports.

Enabled client tools to access HANA directly- Business Objects, to write the reports.

Scheduled real time data load into HANA by using SLT both initial load and continuous replication.

Collaborated with BASIS team in planning and orchestrating system copies during system upgrades, system integration testing (SIT) and User acceptance testing (UAT)

Managed the project on 'On Site- Off shore' model and managed the development activities with development team in India.

Performed data transformation and load into SAP HANA database from ECC, SQL Server sources using SAP Business Objects Data Services (BODS) and SAP Landscape Transformation (SLT)

Developed BODS jobs, data flows, workflows and data store creation and scripts with the platform transformations.

Performed Error Analysis, Debugging SQL Scripts, and in using SAP HANA Plan

Visualizer. Experience in optimizing existing application, which is migrated on HANA.

Developed 17 Interfaces and 4 complex reports in this project.

Created analytics application and dashboards using Design Studio.

Converted analysis for office reports in to Design studio applications.

Used various components of Design Studio like charts, crosstabs, popups, filter panel, tab strip, and dropdown box to create visually appealing reports.

Implemented archiving HANA data into Hadoop as NLS Using SQOOP.

Archived the HANA data into Hadoop by using Sqoop.

Integrated cold data stored in Hadoop and Hot data in HANA using Smart data access (SDA).

Build analytic applications on the HANA models which integrated with Hadoop

Client: Johnson and Johnson, New Brunswick, NJ June 2012-Aug 2013

Project: Galaxy E2

Role: Onsite Lead Consultant

Environment: BI 7.01, ECC 6.0, SAP APO, BO 4.0, Design Studio 1.4

SAP Modules SD, MM, HCM, FI-CO, APO, PCA

Responsibilities:

Part of service management team to support and maintain BW request across JnJ BI system of EMEA

Customer facing BI consultant to address issue from business users

Designed and developed the BI Data flows for APO JnJ E2 Modules (VMI, NVMI and NGF2 )

Designed and developed the BI data flows for E2E inventory from all ECC systems MM inventory data.

Worked on setup tables to fill the data by creating variants based on document ranges.

Worked on FI, CO, PS, and Revenue recognition data.

Created transformations between DataSources and Data Targets and creating DTP's to load data from DataSource to Data Targets.

Proposed and implemented data load optimization and data load performance improvements

Worked with project during implementation and go live of projects NGF2, SODIAC, DMBA and EDN in SD and MM modules

Involved in the implementation of Open-Hub Service to send the daily snapshot data to an external application.

Defined and implemented User roles and authorization profiles for security in BW.

Designed and implemented new enhancements and bug fixes

Developed user exit’s, routines.

Converted 3.x data flows to 7.x data flows in SD and MM data flows

Designed and developed COPA flows from FIT into E2-FSS system

Designed data model including Actual and Plan Basic InfoCubes and a MultiProviders.

Created Input Ready queries to support budget planning and periodic forecasting Involved in Month end, quarter end, yearend activities in COPA and budget cycle activities

Developed In-Market sales History and NGF2 forecast dashboards using Design Studio

Work with team to meet KPI’s set on Day to day delivery

Mentored new team members

Responsible for Organizational KPIs

Responsible for Client Value Adds

Provide inputs for process improvement

Responsible for providing best practices to business

Ensure compliance of standards and processes and Report on deviations.

Client: Shell DSIT Houston, TX Nov 2011-May 2012

Project: Crystal MI – Upgrade from 7.0 to 7.3

Role: Sr. BI Consultnat

Environment: BI 7.0, BO 3.3, ECC 6.0

SAP Modules SD, MM, FI-CO, PM, CRM

Responsibilities:

Based on user requirements activated the data sources in ECC and replicated the same in BI for PM Module and Installed the BI Contents for PM module.

Design and implemented the custom data warehouse modeling according to the user requirements.

Optimized the performance of the Data targets (InfoCube, DSO, MultiCube by Loading the Data through proper selection criteria and maintained the request for each data loads.

Extracted data from MM modules, uploaded the data into the procurement cubes via 2LIS_02_HDR, 2LIS_02_ITM and 2LIS_02_SCL, and activated the appropriate Business Content cube.

Excellent skill set in building queries using Reusable structures, Conditions, Exceptions, filters, Restricted Key Figures, Calculated Key Figures, Variables and RRI’s.

Involved with performance tuning of Queries by maintaining Aggregates, Compression, Partition and Indexing of InfoCubes.

Created WEBI reports for Plant maintenance module.

Responsible for Unit testing for all the developed reports in WEBI

Designed and Developed Dashboards using Crystal Xcelsius 2008 (with Live Office and QAAWS).

Created Data connectivity with QAAWS (Web Service URL’s) and Live Office while developing the dashboards. Created Process chains.

Responsible for building the Support Team and for Transition to support

Responsible for setting up all the Support process

Responsible for moving the project changes after ATD1 using shell support change management process

Integrate with project team, Super Users, App Specialists

Work with team to meet KPI’s set on Day to day delivery of incident, problem and Change management and small enhancements (RFS)

Managed hyper cares support and Situation Management

Resource Planning and work allocation in offshore

Define methods to monitor compliance and Provide inputs for process improvement

Responsible for Client Value Adds

Responsible for operations meeting with Client

Client: Shell DSIT Houston, TX Jan 2011 - Sep 2011

Project: BAM GSAP BW

Role: Sr. BW Developer

Environment: BI 7.0, ECC 6.0, CRM, APO, BWA, NLS

SAP Modules SD, MM, FI-CO, PCA, CCA, FI-AP, FI-AR, PP, QM, CRM

Responsibilities:

Interaction with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting

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

Developed Global info cubes, Multi cubes, Transactional Info cubes, DSO objects and extracted Master data and Transaction Based Data in QM, CRM, and FI Info areas

Created & maintained Start routine to filter out prior unwanted data while loading for functional enhancement during data update in update rules & transfer rules.

Created and maintained Data implementation transformation routine to eliminate the technical and semantic difference between data from desperate source system.

Designed and activated process chain at various levels with varied processes, which involves scheduling data in Info Packages, Reading data from PSA and updating corresponding data targets, Activating DSO data from data load, Deleting / Generating Indexes, Deleting requests.

Activation of standard InfoCubes and definition of new InfoCubes and provide enhancement to Business Content.

Customized new Fact and Dimension tables in the star schema by creation of InfoCube.

Excellent skill set in building queries using Reusable structures, Conditions, Exceptions, filters, Restricted Key Figures, Calculated Key Figures, Variables and RRI’s.

Worked extensively on BEX Query Designer. Developed flexible queries using filters, navigational attributes in BEX Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Created Queries with BEX Web Application Designer for analysis and reporting and to display the Report in Web.

Designed, developed BEx queries

Customized and maintained interface with Flat file and successfully extracted data into the SAP BW system.

Created InfoSets, assigned user groups to the InfoSets and defined InfoSet queries. Create exception evaluations for queries. Designed multiple drill-through reports from BEx Queries, ODS Objects.

Handled postproduction support and development of new design cycles simultaneously.

Client: Gujarat Cooperative Milk Marketing Federation, Gujarat May 2008 - Dec 2010

Project: Implementation

Role: BI Sr. Consultant

Environment: BI 7.0, ECC 6.0

SAP Modules SD, MM, FI-CO, PM, APO, PP, HR

Responsibilities:

Created and modified APO Reports (Milk Transfer Report, Milk Surplus report, Annual Production Plan - All Union Summary, Annual Production Plan - Union Wise, Ice Cream Buffer Stock Plan report, Marketing Dossier Reports, PCM Reports) by gathering requirements with the User and provided the KT to AMS by preparing required documents.

Created and Modified SD Reports (Depot Month wise trend (Value) report, Aaj Ka Score Reports) by gathering requirements with the User and provided the KT to AMS by preparing required documents.

Modified the Formatted Milk Summary All Unions Report as per the User requirements and provided the KT to AMS by preparing required documents.

Created and modified MM Reports (Carrier Performance report, GCMMF Cattle Feed Report, ABC Analysis Report, and Slow Moving Report) and provided the KT to AMS by preparing required documents.

Created Insurance Report (Seismic Zone Wise Inventory Report).

Created Head count reports in HR module.

Done the custom modeling for New Ledger Flow (Party Ledger Report) according to the user Requirement.

Worked on setup tables to fill the data by creating variants based on document ranges.

Done the coding in CMOD for report variable.

Created custom data sources for QM Module and enhanced the Generic Data Sources (Milk procurement, 0MAT_PLANT) and created/enhanced the data warehouse design accordingly.

Worked on process chains and transport the objects as well.

Client: Barclays – CSAG, Bangalore India Dec 2007 - Apr 2008

Project: Sourcing & Implementation

Role: SAP BW Consultant

Environment: BW 3.5, BI 7.0, SAP R/3, SRM

Responsibilities:

Involved in building of FDD's

Assisted in developing FDD's

Involved in the development of CCR’s

Involved in building of TDD's

Test data creation and testing the objects

Involved in Peer review

Involved in the Unit Testing and System Testing

Prepare the UTP, MOM and Delivery Cover sheet for assigned objects

Client: TIMKEN AD, Bangalore India Jul 2007 – Nov 2007

Project: Project ONE - Implementation

Role: SAP BW Techno Functional Consultant

Environment: BW 3.5, ECC 5.0, APO

Responsibilities:

As a BW Functional Consultant I have assisted in developing FDD's

Assisted FIRE team in developing Objects

Test data creation and testing the objects

Preparing the configuration document

Developing the FIRE Objects

Involved in the building of FD's

Prepared the UTP, MOM and Delivery Cover sheet for assigned objects

Client: SAP A.G, Bangalore India Jan 2007 - Apr 2007

Project: SAP AMS Support

Role: SAP BW Technical Consultant

Environment: BI 7.0, CRM 5.0 & CRM 5.1

Responsibilities:

System set-ups, upgrades & post testing activities after the upgrade

L1, L2 & L3 Message support

Data load monitoring using process chains

Delivered value added services (Custom report creation & enhancements)

Client: Thai Polyphosphate & Chemicals Co. ltd, Bangalore India Jul 2004 – Dec 2007

Project: AMS Support

Role: SAP BW Developer

Environment: BI 3.0 B, SAP R3

Responsibilities:

Design and developed Infoproviders, Data Sources & Reports

Involved in Peer reviews & project documentation

Created and maintained queries in BEX Analyzer and BEX Web application Designer for analysis and reporting with Workbook and Web Reporting respectively

Designed and created process chains

Implemented Data Integration transformation and Application Logic transformation with Routines

Worked extensively on LO Cockpit

Data source Enhancements

Monitoring data loads

Performance tuning using Aggregates & Partitioning

Modifying BW reports

Involved in developing SLA reports at end of every month

Contact this candidate