SAP HANA, BW/BI Consultant

SUPRITH R

SAP BW/BI/HANA Consultant

Summary

SAP BI / BW HANA / ABAP Techno Functional Consultant with an Extensive experience in Design, Development and Maintenance & Implementations primarily servicing Finance, Retail, and Procurement, Sales and Distribution area of Business Warehouse. FI, SD, MM, PP, QM

Having 10 yrs. of experience working with SAP BW 7.3/7.x/3.5,7.4, Enterprise HANA SP11.

Having 6 + years of experience in SAP ABAP.

Having 2 years of experience in SAP HANA modeling implementing SAP SD & Procurement.

Experience in Blue printing, Requirements gathering, understanding different business processes and converting them to efficient data models.

Excellent in System Analysis, Documentation and Designing Tech-Specs of the Processes

Experience in SAP BW/BI components like Data source, User Exits, Process Chains, Remote Cubes, Data Mart and Open Hub Service.

Expertise in building Multi provider, Multi cubes and Info sets as per the query needs. Performance Tuning of Queries

Experience in Multi-dimensional modeling with Cubes & HANA Views

Experience in working in Complex Transformation using Routines, Lookups using ABAP.

Experience in Front-End Business Warehouse Components like Query Development, Reporting agent, Calculated/Restricted figures, Structures, Variables, BEx Analyzer, Web Templates, WAD, Web Reports.

Experience in Production Support Skills including Data loads, Reporting, Performance Issues, and Data Compression Activities.

Expertise in designing BEx queries, WAD, CKF, RFK, Key figures, and variables.

Excellent Communication skills and ability to lead, work, and also as an individual contributor.

Education

Masters in Software Engineering, UK – 2012

Bachelors in Computer Science -2006

Technical Skills & Areas of Exposure

SAP Net Weaver 2004s, SAP R/3 4.6, 4.7, ECC 6.0, Solution Manager, SAP BI 7.3/7.0, BW 3.5, BWA, BOBJ 4.X/3.X, HANA, BEx Query Designer, BEx Analyzer, Report Designer, WEBI & Xcelsius / Dashboards, SCM (MM, IM, Purchase), PM, FI (AP, AR, AA, GL),ABAP/4,PL/SQL, BMC Remedy 7.5, Report Designer, WEBI & Xcelsius / Dashboards

Work Experience

WALMART Inc. – Bentonville, AR

SAP HANA, BW/BI Consultant

17th Oct 2016 – Till Date -

Project # 1: Walmart Manufacturing – 7 months

Lead a team of 4 core technical consultants for the Manufacturing program at Walmart.

Designed and implemented data flow for SD, QM, PP, QM consuming BW and HANA objects using the LSA ++ Architecture.

Designed and implemented Custom Calendars and Custom Hierarchies solutions to meet the reporting requirements.

Created an ABAP Utility programs to create Custom Calendars and create Custom Hierarchies.

Created Attribute, Analytical and Calculation Views to meet new reporting requirements in HANA Studio using different joins (inner join, outer join, referential join etc.) and union to connect tables to meet the Reporting requirements.

Leveraged the methods REPTASK & SDI, for data provisioning from SAP and non-Sap sources.

Extensively used BW Modeling tool, Hana Modeler and Hana Development perspectives to create objects like ADOs, Composite Providers, Open ODS Views, Calculation Views(scripted & graphical), Stored Procedures, Hana Tables, to consume persistent and virtual BW datasets into HANA and vice versa.

Extensively involved in creating optimized HANA Models as per user requirements.

Created SQL Stored Procedures to implement solutions for complex business scenarios.

Fine-tuned the transformations via SQL script Expert Routine.

Project # 2: Profit Cost Management, an SAP Custom Solution - 3 months

Designed & developed a complex data flow for SAP Profit Cost Management

Designed a complete Custom Tool Kit for implementing SAP PCM reporting feature in SAP BW

Worked with IBM Info Sphere Data Stage for extracting Master Data & Transaction Data

Architected the Master Data Flow, Master Data Text Data Flows & Transactional Data Flows

An Extensive hands on ABAP to feature the hierarchy generation functionality in BI.

Design BEx reports with versioned hierarchy with Custom Variables,

Configure ODATA Services on Easy Queries to publish the BW Data for Web Services

Error Handling & Unit Testing

Project # 3: Global Supplier Management Solution – 4 months

Design and Develop Calculation views based on the reporting requirements.

Performed Real Time Replication from the MS SQL 2 HANA DB using SDI for real time reporting in BW/HANA.

Written Scripted Calculation Views for reporting requirements

Optimizing performance in joins, evaluate the execution time.

Mount Sinai – New York City, NY

SAP HANA, BW/BI Consultant

2nd Aug 2016 – 14th Oct 2016

Extracting data from different sources and creating BW models to stage the data.

Creating information views in HANA based on the BW models.

Created star joins to improve the performance of calculation views.

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.

Debugging scripted views and performing unit testing matching with the legacy Teradata system.

Worked on BW on HANA and Native HANA.

Consumed data from HANA calculation views as source to stage data in BW models.

Performance tuning of existing information views, created dimension based calculation views as re-usable master data for star join modelling.

Used explain plan and visualization plans to overcome the performance bottlenecks.

Extracted data using BODS and consumed in HANA.

Created composite providers on top of BW info providers and HANA native views.

INVISTA - Wichita, KS

SAP HANA, BW/BI Consultant

5th Jan 2016 – 15th July 2016

Roles & Responsibilities

Worked on ASAP (Accelerated SAP) methodology in Implementation Project.

Expertise in Design and Implementing the solution(creating the Technical Documents) for the Functional Specifications on Enterprise HANA for modules SD,MM,

Expertise in GAP evaluation with Technical, Functional requirements with End/Business User.

Worked extensively on HANA modeling and responsible for HANA development deliverables in time, Cutover Activities

Extensively worked on Calculation Views, Analytical Views, Attribute Views, Star Join CV's, Hierarchies by using Calculation Views, Delivery Units, Import, Export, Filters, Variables, If Else Calculated Formulas, Calculation Attributes/Measures for Inventory Extensively worked on Transposes like Row to Columns, done Currency conversions using Calculation Attributes/Measures & Restricted Calculations.

Dynamic data selections by using input parameters like Direct, Column, Static, Derived from Table.

Imported the Master data Flat Files (CSV, Excel) to tables in HANA by using the BODS Job.

Used Calculation Views for data display as Header and Item Data format.

Worked on reading the BW models in to HANA and creating the HANA view to achieve the complex reporting requirement.

Extensively worked on Virtual Provider based on HANA Models & FM.

Extensively worked on Composite Providers. Created the stored procedures and scheduled those using ABAP to load the snap shot information into HANA tables.

Worked ABAP on HANA, SLT Replication, SAP BODS

Developed complex BEx reports.

Building the reports and delivering on time with all the due diligence.

Co-coordinating with offshore for all the deliverable or issues.

Executed the Test Scripts in HP Quality Center Tool during the Testing.

Extensively worked on UAT/Defects in HP QC Tool.

WALMART - INDIA

SAP BW/BI Consultant

11th Nov 2013 - 25th Dec 2015– Deloitte

Roles & Responsibilities

•Worked with SAP applications like MM, FI,SD,PS,SRM

•Administrating through BW Administrator workbench using Info Providers, Info Objects, Info Sources, Source Systems, and PSA, Sub functional areas to create and monitor the objects that are involved in multidimensional Analysis.

•Worked on BI ABAP - Start Routines, End Routines and Field Routines.

•Worked extensively on Performance tuning in improving the load and read performance by maintaining indexes, partitioning, aggregates, query properties etc.

•Extensively worked on business critical reports like Asset Management and Reconciliation Reports.

•Meetings on status, issues, and overall progress on a regular basis.

•Completely responsible for the Design and Configuration of the LO extraction Cockpit, the building flow of data from R/3 to BW.

•Configuring LO extraction involved identifying the required dates and building the business logic characteristic derivations and rules, transfer of billing documents, Enhancements required for Sales Analysis and Set up extractors for BW.

•Customizations - Extract structure enhancements, generic extractors, user exits and worked on customized delta built up for the data sources.

•Modified report content and export reports in multiple formats based on user input Wrote documentation for users on how to select necessary parameters and date frames for different selections.

•Involved in end-user training and documentation.

•Involved in various testing procedures, user training, on-site support and maintenance.

•Extensively worked in Unit Testing and Integration Testing.

AFLAC

SAP BW/BI Consultant

1st July 2013 - 25th Oct 2013– Deloitte

•Extracted data from flat files for the HR.

•Developed numerous custom data sources using database views and custom function modules.

•Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.

•Involved in activating Business Content for Standard Info Objects, DSO, Info Cubes related to FI, SD.

•Monitoring the Process Chains for daily, weekly and monthly loads.

•Involved in creating many complex OLAP variables, DTP routines.

•Performed LO-Cockpit extraction for Sales Order, Sales Delivery, and Billings by extracting Standard Data Sources from the Business Content using LO-Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements.

•Implemented various Performance Tuning activities to increase the performance of Queries by Creating indexes, Aggregates, Partitioning and Compression.

•Error Debugging and rectification, solving issues, problems faced during Data loads.

•Involved in Increasing the Load performance of the BW system while loading into DSO objects and InfoCubes.

•Fixed number of data load issues like data load failures, long running jobs etc.

•Analyzed PSA table growth and scheduled weekly PSA deletion jobs.

•Fixed number of DSO activation errors.

•Fixed number of BW system related, system refresh errors and documented those errors.

•Created Functional Designs and Technical Design documents based on real-time report.

•Involved in creating DSN and ODBC connection between the BOBJ and SQL Server environments.

•Created Universes using tables from SQL Server tables involving joins, Conditions e.t.c.

GLAXOSMITHKLINE - UK & INDIA

SAP BW/BI Consultant

05th Sep 2012 - 24th June 2013 – TATA Consultancy Services

Roles & Responsibilities

•Involved in the team through SDLC life cycle (Requirement gathering, gap analysis, HLD, Detail Design, Development, Unit testing, Assembly testing, System test support, migration to Production environment and post go-live support).

•Involved in ABAP coding of transformations, extractors, program, and function module and customer exits.

•Worked extensively in collecting the BI objects to the transport requests, released all transports to the Quality/Production system and resolved issues related to transport failures.

•Actively participated in preparation of KT Questionnaire to get most of the system information in hand before KT Execution

•Coordinated and lead the Operations team in Knowledge Transition phase

•Actively participated in KT Execution from site and coordinated the offshore team up to the speed

•Coordinated closely with team in resolving various maintenance tickets.

•Involved in maintenance and support of production system under SLA.

•Actively participated in system validation during System maintenance/Bounce

•Coordinated closely with Basis team during Server Shift (Primary to Failover and vice versa)

•Primary responsible for Daily Operations SLAs with Client and Monthly SLA Metrics with Client

•Coordinated closely with team in resolving various maintenance tickets

PA Consulting Group – London, UK

SAP BW/BI Consultant

5th April 2011 to 2011 to 31st Dec 2011 - University of Bradford Intern

Extensively worked on the Back End development involving developing from Info Objects to Data Marts and Process Chains for the complete Business Data Model.

Designed Integrated data model including Actual and Plan Basic Info Cubes and a MultiProvider.

Worked on the Front End Development on SAP BW/BI 3.5/7.0 BEx Analyzer by developing Web Templates, Queries, and Workbooks.

Developed WEBi reports using SAP Query as data source and Universe as Semantic layer in XI 3.1

Also handled complete migration of the BW 3.5 queries to BI 7.0 with error handling issues.

Took responsibility of cleaning up the BI system Back end by deleting roles not in used and Objects not required in all the systems.

Also cleaning the Front end side by identifying and deleting Un used queries and Web Templates in all the systems.

Involved in Data Extraction from SAP and Non SAP systems using SAP extraction Methods.

Involved in Redesigning/Migration of the Data Models for many existing applications to improve the systems performance.

Transportation of Objects to Acceptance and Production as and when required.

Extensively worked on the Maintenance and Support areas both at Back End and Front end Areas.

BRISTOL MAYER'S - INDIA

SAP BW/BI Consultant

2nd June 2008 - 24th Sep 2010 – Accenture

Roles & Responsibilities

•Involved in determining the data flow for the business requirements extraction and reporting, and translated these requirements into Dimensional Data Models in BW for Warehouse Implementation.

•Participated as a team member in discussion with business analysts and end users for Data Modeling, Business Content, Granularity, and Performance Tuning.

•Performed data extraction using LO and prepared LO extractors in Plant Maintenance and Customer Services for various Data Sources and thus configuring for initial, delta and full updates.

•Performed Data Extraction for master data (attributes, texts and hierarchies) and transactional data.

•Customized generic data source with the help of Function Module to load the Work Order details.

•Created various queries and extensively worked on Query Builder objects viz. Filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Offsets and Query Variants.

•Scheduled and automated data loads from R/3 to BW, 3rd party systems to BW and also from flat files to BW and optimized the load performance by data selections and number of Info Packages.

•Created various queries and extensively worked on Query Builder objects viz. Filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Offsets and Query Variants.

•Extensively worked on Web Application Designer (WAD) to develop the templates to meet the business requirements.

•Extensively worked on DB connect to extract the data from 3rd party systems.

SNAP - INDIA

SAP BW/BI Consultant

3rd Jan 2007 - 15th May 2008 – Accenture

Roles & Responsibilities

Worked extensively on Administrative Work Bench. Customized Basic Info cubes, ODS objects, multi provider, data marts, Transfer rules, Update rules, Data sources, replicated data sources, loaded master data and Transaction data from flat files and OLTP respectively.

Developed routines in transformations for the Key figures of Info cube.

Replicated Data sources in SAP BW source system and scheduled the Info package to load Data.

Created Generic Extract structures, Data sources and Replicated Data sources in SAP BW source system and scheduled the Info package to load the Data.

Created custom Master Data Sources using Tables, Views, ABAP/4 Query, function module and set up Delta for custom fields and ensured the loads are successful from all source systems.

Created several custom Info Sources & Info Objects in BW and mapped them with R/3 fields using transformations

Extracting Master & Transaction Data using Generic Data Sources from OLTP.

Enhancement of the Data source by adding new fields and populating them with user exits.

Maintaining Reconciliation’s to verify the data in R/3 and SAP BW Error Handling and issues solving arising during user acceptance test.

Created BEx reports where Formulas, selections, structures, exceptions, conditions, Currency translation, calculated key figures, restricted key figures and variables with user entry/default value customer exit and Replacement path, WAD

Data loading and monitoring through process chains.

Preparing Hand over Documents and giving back to client.

Handled complex performance tuning issues to improve data loading and query performance.

Implemented advanced performance tuning techniques like Partitioning, Compression for query performance

Implemented advanced performance tuning techniques for data load performance.

Contact this candidate