Varun Gaddam

SAP BW/HANA Consultant

SUMMARY

** **** ***** ** ** experience in various technologies and tools including specialized experience in Business Warehouse/Business Intelligence and Analytical Solutions.

Well experienced in fit/gap analysis, blueprints, system and architecture design, high degree of custom development and integration, configuration, testing, end user trainings, rollouts and support and onsite-offshore delivery model.

Exposed to complete life-cycle environment right from project definition, Business requirement gathering, analysis, developing detailed design documents and Technical architecture, Development, Unit Testing, Acceptance Testing, Performance tuning & testing, preparation of Quality documents, support documentation, cut over plan through go-live support.

Providing training to new joiners, conducting Interviews, mentoring junior staff, providing knowledge sharing sessions and trainings on SAP-Analytics.

SPECIALITIES

Technologies: SAP ECC 6.0, SAP HANA 1.0 & 2.0, SAP BW/BI 7.2/7.3/7.4 on HANA, SAP BODS 4.0/4.1, SAP BO 4.0, SAP Lumira, S4 Hana, MS SQL Server, Oracle, BW, BI and Native HANA modeling, Universe Design tool(UDT), Information Design tool (IDT) Webi Reports, Crystal Reports, Live Office, Analysis for OLAP, Xcelsius, Bex Query Designer, Bex Analyzer, Bex WAD.

Core Competencies:

Managing and leading offshore resources, and coordinating development efforts

oMaintaining SLA’s

oProject estimation

oPrepare development specifications

oQuality control

o24/7 on-call support

BW on HANA/ Native HANA

oWorked on Implementation and upgrade.

oIntegrating Fiori with BOBJ – SSO

oLarge scale projects using SAP BI7.x on HANA, Native HANA, BO 4.x, ECC6 and SQL.

oExtensive experience in SAP BW LSA++ Architecture, Extended Star-Schema, Data Flow Strategy

oGood understanding of HANA Architecture and its various components.

oDesigned, developed various HANA Information Models like Attribute, Analytic and Calculation Views to model data for reporting using SAP BO, Analysis Office and SAP Lumira.

oInvolved in creation of Universe using IDT (Information Design Tool) on top of SAP HANA Calculation Views and developed WebI Reports and Dashboards.

oData provisioning using SLT system and ODP extrators, Flat files, BODS etc.

oExperience in importing flat files (i.e. CSV) to custom tables in SAP HANA.

oWorked on replicating data from SAP ECC to SAP HANA using SLT Method.

oWorked on extracting BW Data sources from SAP BW to SAP HANA.

oImplemented data provisioning techniques and replication via Batch mode replication (ETL) and Real time methods like SAP BODS and SLT (SAP Landscape Transformation).

oWorking knowledge in creating calculated columns, restricted columns, filters on Information Views.

oPOCs for consuming BW Info Providers and SAP HANA Models using Transient Provider, Virtual Providers and Composite Provider using mixed case scenarios in SAP HANA using reporting w

oWorked with Information Design Tool for creating Data Foundation Layer, Universe for SAP HANA reporting.

oHaving knowledge in using User Defined functions, CE (Calculation Engine) functions and PROCEDURES for utilizing HANA hardware & software capabilities.

oDesigning data modeling and Maintenance of Info Objects, ODS, DSO, InfoCube, Multi-Provider, InfoSets, Data Sources, aggregates.

oWorked on different extracted methods like LO extraction, Generic extraction.

oEnhancing various extractors to SAP BW with CMOD, creating flat files from a various data sources including Finance, Logistics.

oDesigned and Developed Complex Queries, Views, Workbooks and Web Templates using BEx Query Designer, Analyzer and Web Application Designer.

oExtensive experience in Production Support Activities like Data loads, Validation and troubleshooting of Transaction data and Master data, Transport Management, Roles & Security, System Checks, Process Chains, Full/Delta loads, Scheduling, and Monitoring.

oExpertise in Data Archive & Reloading, worked on End-to-End Data Archiving Implementations. Archiving Administration Workbench, Near-line storage system (NLS), BWA.

BO

oWorked on Implementation project of BO 3.0 and upgradation Project from 3.0,4.0,4.2

oExperience of BO platform 4.1/4.2 (CMC/Launch pad)

oExperience working SAP BO 4.0 and Crystal Reports.

oDeveloped Universes on SAP BEx Queries using BICS.

oDeveloped WebI Reports on Universes.

oDeveloped Dashboards creating through Live- Office and BO Universes.

oDeveloped Crystal Reports on SAP BW and SAP R/3 Systems.

oFixed the joining data issues such as Charm and Fan Traps with Alias, Derived tables and Aggregate Awareness function.

oExperience in promoting Objects (Universe, Reports, Dashboards) across environments (Development, Quality, Production) using LCM (Life Cycle Manager)

ABAP

oExperience in ABAP Routines, Customer Exits in BW

oCustomer Exits.

oABAP List Viewer (ALV) reporting.

oABAP Debugging.

SAP Modules

oSD, Retail Sales, MM, QM, IM, PP, PM and Finance application

Certifications

SAP BW powered by SAP HANA

PROFESSIONAL EXPEREINCE

BW HANA/BO/SQL Aug2019 to Till Date

Project: Implementation Project

Client: Eskenazi Hospital, IN, U.S.

Role: SAP lead Consultant

Environment: Native HANA 2.0, BO 4.2, SAP ECC 7.0, S4 HANA, SLT

Key Objectives

As a BI Lead worked in Enterprise HANA integration with S4 implementation & SAP ECC system Integration.

Key Responsibilities

Designed system architecture to extract data from S4 & ECC to Enterprise HANA through SLT.

Developed custom models for Purchase and FI module reports in Webi with integration of Fiori Launchpad.

Integrating Hana model through Hana live connection to Custom Webi reports with Hyperlinks, Conditions, variables and report format.

SLT Replication from S4 & ECC system data in to Enterprise HANA and designed data models as Base View, Integration Views & Presentation Views.

Developed custom Schema, custom tables & custom flat file uploads of XREF reference information, Group and Sub Group information uploads based on the client requirement.

Designed custom calculation views LOV’s which helped end user for value help search in Webi reports

DATA Model mass import & Exports through Delivery units within the landscape of DEV, QAS & PRD

Created custom audit webi report to make sure that S4 & ECC and Enterprise Hana data are in SYC

Worked in Integration testing unit testing and business testing to make sure that all reports are working based on client requirement.

Providing training for the users on Webi reports usage and conducting work shop & walk through of salient features of the Webi reports.

consolidation of FI webi reports by groups/Sub groups and designing templates to the needs of sourcing/financial analysts & Procurement specialists.

BW HANA/BO/SQL Nov2018 to Aug2019

Project: Enhancement & Production Support

Client: Lyondellbasell, Houston, TX, U.S.

Role: SAP lead Consultant

Environment: SAP BW 3.x, 7.4, HANA 1.0, BO 4.1, SAP ECC 6.0,

Key Objectives

As a BI Lead worked in different projects & enhancement, System Support. BW system Integration with SAP ECC & non-SAP system

Key Responsibilities

Design, develop and implement project's with the estimate, To create transparency on business and process performance

Setup workshops, summarize results and execute comprehensive briefing expertise for assigned functional areas/systems and processes towards team and business partners

Ensure smooth operation of the business by taking on ownership for related actions.

Experience with SAP (Native) HANA data modeling, schema management, content import & export, data provisioning technology including SDA. Mixed modeling Between ECC tables data with BW data

As a lead, helped in the design of an end to end data flow to get new PO transaction data, Exchange rates, and Master data from ECC to BW on HANA including activation of standard business content, the creation of Advanced DSO, Open ODS Views, Composite Providers, Transformations, and Routines.

Delivered multiple reports for CAPEX NON-PRD HFM System, Consolidation and Elimination reports for Actual, Roll Forward forecast.

Replacing APD with Infoproviders by RSCRM_BAPI

Created Generic Data Source using the database view for WM data which is not satisfies in the standard extractors for the business needs.

Worked on Analytic Query type CDS Views with Fiori Query Browser.

Imported roles to Integrating Fiori with BOBJ for SSO.

Worked in SQL, PL/SQL, stored procedures for implementing custom business rules.

BW HANA/BO/SQL May2017 to Nov2018

Project: Migration & Enhancement & Production Support

Client: Zekelman Industries, Chicago, Il, U.S.

Role: SAP Consultant

Environment: SAP BW 3.x, 7.4, BO 4.1, SAP ECC 6.0, MS SQL, Crystal reports

Key Objectives

As a BI consultant worked in different projects, Migrated 3.x dataflow to 7.x dataflow, Unicode testing, System Support & Enhancement. BW system Integration with SAP ECC & non-SAP system

Key Responsibilities

Migrated 3.x data flow to 7.x & 7.4 on HANA data flow with RSMIGRATE tool.

Converted update rules into Transformations and modified Routines. Migrated some of the BW models to Native HANA Views.

Generating HANA views from BW models and consuming then in Calculation views.

Responsible in testing of ECC datasources during Unicode conversion

Developed the dashboards with charts and crosstabs using basic and ad-hoc analysis template.

Interacted with Business Analyst, Business Users to know their Business views in gathering and analyzing the requirement and build necessary.

Enhanced and Maintained Scorecard reporting system which includes sales, inventory, revenue analysis, delivery performance, Vendor performance reports

Filled set up tables for Logistic extractors (2LIS_02, 03, 11, 12, 13) based on document number.

Worked on data reconciliation from ECC tables and DSO using Standard Extractor.

Activation of the Business Content for Purchasing (MM) and customizing them as per the client requirement.

Developed Virtual Provider with BW objects upon HANA Models to use Navigational attributes and Master data related to BW Objects.

Had worked on creation of users, roles, creation and assignment of analytic privileges.

Developed Composite Provider to combine both data from HANA and designed BEx queries upon these Composite Provider.

Transported various HANA views to higher landscapes.

Developed Reports using WEBI against SAP HANA Views, Universe, and OLAP/BICS connection.

Developed Visualizations using SAP Lumira against SAP HANA Views, SAP and non-SAP data sources.

Demonstrated to the end user's utilization of the HANA views in the front end tools such as Tableau and SAP Business objects - Web Intelligence.

BW/HANA/BO/SQL June2016 to April2017

Project: Production Support & Enhancement

Client: Life is Good, Boston, Massachusetts, U.S.

Role: SAP Technical Consultant

Environment: SAP BW 7.4 on HANA, BO 4.0/4.1, SAP ECC 6.0, MS SQL

Key Objectives

Providing application system support & Maintenance. New development/Enhancements with system integrations of SAP & non-SAP system

Key Responsibilities

Experience in conducting business requirement gathering workshops and training with various business users.

Proactively manage changes in project scope, cost and time and track, create change requests, devise contingency plans, ensures project documents are complete, current, and stored appropriately

Created Query’s for PLM, SAP reports like On hand allocation by season, and Flash costing reports.

Designed different proto types of dynamic image display in the Department Category Selling Visuals Report

Experience with integration of HANA with BO Components.

Experience with SAP HANA Data Administration including managing schemas/data model objects & import/export of HANA Catalog Objects/Content objects

Experience on SAP HANA Modelling (HANA Design Studio), Designing Schemas, Creating, Analytic Privileges, Stored Procedures.

Experience in designing, developing & maintaining SAP HANA Information Models (Attribute Views, Analytic Views & Calculation Views including SQL Script based Calculation Views & Decision Tables)

Key metrics ‘TO SALE IN MEN’S DEPT’, ‘OFFER IN MEN’S DEPT’, ‘AVERAGE SKU ‘PRODUCTIVITY DOLLARS’, ‘AVERAGE SKU PRODUCTIVITY UNITS’ are captured with different subject areas has been re-created by using variables.

Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.

Experience in Data loading, Monitoring and Scheduling using Process Chain.

Created User Prompts, input query’s, result from another query’s, Conditions and Filters to improve the quality of report generation.

Scheduled Reports with excel format by using scheduler Infoview as well as CMC.

HANA/BW/BOBJ Mar2015 to May2016

Project: Hybrid Modeling

Client: Johnson and Johnson., Piscataway Township, NJ USA

Role: SAP Technical Consultant

Environment: SAP BW 7.4, BO 4.0/4.2, SAP ECC 6.0, HANA 1.0, MS SQL

Key Objectives

The objective of the project was to implement the SAP HANA as part of SAP BI solution in Johnson and Johnson Inc., to develop the executive dashboard using Mixed approach of SAP BW powered by HANA with SAP hybrid modeling, data extraction and SAP BOBJ for reporting purpose. Upgrading from BO 4.0 to 4.2 solution for reporting and provide application maintenance and support.

Key Responsibilities

Requirements analysis, Logical data modeling, BW and HANA modeling, solution architecture design, BI tools analysis and solution implementation.

Developing and presenting POC & demos to the executive management.

Configuration Replication Server (SLT) and replicated the Meta data table into SAP HANA using Data Provisioning technique.

SAP predefined HANA Live views content and creating real time operational report based on HANA views.

Experience in mapping business requirements to technical architecture.

Implemented Transformations with SLT using IUUC_REPL_CONTENT / LTRS.

System based on SAP HANA over BW and designed various attribute views and analytic views for building reports using SAP BO in SAP HANA studio.

Design and Developed the Calculation views (Graphical & SQL script), analytic and attributes views.

Expertise in develop calculated attributes, calculated measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA studio.

Created Analytical Privileges to implement row level security on calculation views on Plant & company code.

Involved in Re-Converted Hana-Optimized DSO to Classical DSO.

Performed unit testing of reports and dashboards using SQL assistant and Quality Center.

Design and create the BEx Queries, configure the BOBJ tools reports implementation of SAP Webi.

Developed ABAP program for ALV reports for comparison of BO reports.

Reports Developed on Purchase, SD and integration experience with SAP and NON SAP.

BW/BO/ABAP Dec2011 to Feb2015

Project: Secondary Sales Point of Sale

Client: Britannia Industries Limited, Bangalore, India

Role: SAP CONSULTANT

Environment: SAP BW 7.0,7.3, SAP BO 3.0, 4.0, MS SQL

Key Objectives

The project was intended to provide “Order to Delivery” to Britannia Industries Sales management team, with specific focus on Secondary Sales of retail data. Customer was lacking the insufficient visibility to access their secondary sales to effectively report and manage inventory levels across the company PLM. As part of the solution, Britannia wanted to leverage the existing SQL Report to SAP BI/BW. In the organization to develop a set of standard reports to provide sufficient Delivery’s to manage inventory levels and risk management

Key Responsibilities

Analyze the requirements and perform the solution and architectural design for SAP ERP(ECC) data extraction and reporting

Designed SPO for Secondary sales data to maintain huge volume of data into BW and improved report performance.

Model the BW objects including InfoObjects, DSOs, InfoCubes, aggregates and design and create SAP BEx Queries and SAP Web Application

Having precise expertise in understanding Non SAP System like MS-SQL system to connect SAP BI by using UD connection.

Experience in integration of various data sources with Multiple Relational Databases like SQL and Worked on integrating data from flat files.

Installed Business Content Sales Overview Cube and designed and activated Customer service to meet user needs. Created several ODS objects which acts as data staging.

Configured Data sources in R/3 by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for Periodic loads.

Written ABAP routine program to enable the delta for periodical load.

Modified several existing Bex report to improve performance and to improve the performance of the reports reorganized the Dimensions. Provided Line Item dimensions and Designed SPO for Secondary sales data to improve report performance.

Worked with BEx Reports for User requirements using Filters, free Characteristics, Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables.

Evaluate the BOBJ reporting, prepare estimations for development effort.

Creation of Reports using both Full client and Web Intelligence, summary and detail with the functionality of drill down to detailed document.

Creation of Full Client reports using functionalities slice and Dice, Drill down, Cross Tab, Master Detail and Formulae’s, Filters and Conditions, etc.

Being the first level of technical escalation for the team helping the team technically on Universe Design, Desktop Intelligence, Web Intelligence, Dashboard and Crystal reports, BO Administration and Deployment issues

BW/BO Dec2010 to Nov2011

Project: Implementation-Production Support

Client: Kengen, Nairobi, Kenya

Role SAP CONSULTANT

Environment: SAP ECC 6.0, BO 3.0

Key Objectives

As a team lead had opportunity to work on Fresh Implementation and production support activities, data integration and reporting for performance monitoring and onboard status.

Key Responsibilities

Involved in full life cycle implementation starting from business process definition project preparation gathering business requirement blueprint realization and providing post go live support.

Prepare status reports and presentations, schedule meetings, lead meetings for status updates, manage and coordinate with offshore/onsite project stakeholders to ensure the deliverables are on track.

Assisted Business users towards creation of UAT test scenarios and execution of UAT scenarios under the guidance of Project Manager.

Attended directors’ meetings for getting inputs to develop Xcelsius Reports.

Implemented SAP BO for Operation, PM, HR, FI, PS involved in the data flow from r/3 to sap BO.

Created Crystal Reports, Live office and Xcelsius based on the client requirement.

Created crystal report through infosets and developed reports based on Xcelsius Requirement.

In Crystal reports report customization via Grouping, Sorting, Field Highlighting, Conditional Formatting, Running Totals, Summaries, Static & Dynamic Parameters, Static & Dynamic Graphic Objects, Custom Formulas and Custom Functions

Worked in creation of Corporate Dashboard for the directors.

Created Authorizations & Roles for Dashboards.

periodically conduct review meetings with customer and support teams to measure the application support performance

BW/BO Sep2007 to Nov2010

Project: – Integration and Reporting – Implementation

Client: Reliance Capital Limited, Mumbai, India

Role SAP CONSULTANT

Environment: SAP ECC 5.0, BW 7.0, BO 3.0

Key Objectives

Extract the AR, AP, GL from SAP FI (SAP ECC) and load into SAP BW reports creation and rebranding of the documents. Perform the configurations and setup activities for support environment for setting up a new legal entity in FSV (Financial Statement Version) system and carry out testing, integrate Business User data, employee’s data for BO reporting

Key Responsibilities

Evaluate data migration requirements from SAP ECC and flat files perform the GAP analysis, review the migration requirements for reports and rebranding of documents

Worked in Development project, which mainly includes FI data flow of AR, AP, GL and developed FI reports in Webi according to client requirement.

Involved in the implementation Performed the activities like building, filling, dropping and monitoring the indexes in various environments throughout the landscape for the BI Accelerator implementation

Developed reports on Profit and Loss account, Income statement and Balance Sheet. Created Variable Exits to show the Invoicing amount of the respecting periods and hierarchy Structures in reports.

Participating in business meetings and finalizing the functional requirements from the business users Responsible in converting the functional requirements to technical designs and successfully implemented.

Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BW Reporting and applications.

Designed and developed process chains (RSPC) for master data loads and transactional data loads with the help of info packages. And these process chains are scheduled for periodically.

Involved in Webi and Universe. Handled according to Client Requirement.

Developed data flow and enhancement in existing data flow, reports with respect to client requirement and designed DSO’s, Info Cube and Multi provider

Prepared Technical Specification documents based on the Functional requirement.

Modified existing Bex Report for Webi reports. To improve the performance and created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables, etc. For customized reporting.

Creation of Full Client reports using functionalities slice and Dice, Drill down, Cross Tab, Master Detail and Formulae’s, Filters and Conditions, etc.

Used multiple data providers, Union, Sub Queries, Intersection, minus and Master/Detail, cross tab, Charts. Extensively used Opendoc function to link parent and child reports. Designed exceptional documents with Alerter and involved in designing the report with rank feature in WEBI.

Education:

Bachelors in Mechanical Engineering: Bharath Institute of Higher Education & Research

References will be provided upon request

Mobility willing to Travel

Contact this candidate