Post Job Free

Resume

Sign in

SAP HANA Analytics Consultant

Location:
Spring, TX
Posted:
January 12, 2021

Contact this candidate

Resume:

Kishanlal Noklal Kumawat 704-***-****

SAP HANA XSA/Data and Cloud Analytics Consultant

adjdqh@r.postjobfree.com

PROFESSIONAL SUMMARY:

SAP-HANA/Cloud consultant with around 10 years of professional experience, involving multiple full lifecycle implementations, and expertise in design and development of HANA Objects, Transformations, Business Content configuration, Capacity Planning, and Sizing using SAP ASAP methodologies

Experience in Microsoft Azure Cloud Applications.

Experience on Advance technologies like HANA XSA, SAP Design Studio, SAP Lumira, SAP S/4 HANA with Embedded Analytics

Experience in SAP Business objects tools like Data Services, Webi, Lumira, SAP Analytics Cloud and Analysis for Office

Experience in Planning and Consolidation tool like BPC 10.1 and BPC on S/4 HANA

Good functional knowledge of SAP R/3 application areas like SD, MM, COPA, FI AR, AP and IM

Bring to work the perspective gained by working extensively in Chemical and Oil vertical

Demonstrated ability to complete multiple assignments simultaneously, maintain high standards of client organizations, and work efficiently in onsite/offshore model

Working on latest technologies/versions like BW 7.5, BODS 4.2, HANA and others JOB RESPONSIBILITIES

Creating Upstream Financial Reports in order for business to Generate 10K reports for the Management and Share Holders.

Worked on HANA 2.0 WEB IDE to create complex HANA Views to be consumed in Cloud, Tableau and other Front End Tools

Created Complex Tableau Dashboards based on HANA Views in XSA

Created Complex Reporting in HANA consumed Data from S/4 HANA ACDOCA finance table

Perform Data Modelling along with development and implementation of BW objects like Info Objects, InfoCubes, DataSources, Extractors, Process Chains, User Exits, Multi Providers, Hierarchies, Transformations, ABAP Programs, BEx Queries, Analysis Process & Design (APDs) and other ETL processes

Perform Data Modelling in SAP HANA /SAP BW 7.5 on HANA and Implementation of Objects like Composite Provider, ODS Views, Complex HANA Views, Advanced DSO, Advanced DSO for BPC Planning and Consolidation.

Help integrate with non-SAP systems to Extract, Transform and Load (ETL) data using SAP Business Objects Data Services tool

Worked on Performance tuning of existing load process and BW reports along with improving the Data Integrity

Participate in the Architectural Review Board, Dev Process Improvement Committee, Conceptual Design and Functional Design document review. Participate in groups to define System Landscape, Quality Process, Naming Standards and other SOX compliant steps in SDLC cycle

Advocate Best Practices in implementing Master Data Governance strategy, Data Quality and Finance Reporting Dashboards

Provide consulting services to key clients, including data quality, data migration and data governance leading practices. Working as liaison between technology and business groups. SKILLS/TOOLS:

SAP BW/BI (3.5/7.0/7.3/7.4/7.5): Data Modeling, Transformations, Complex ABAP Routines, Remodeling for InfoCubes, Load Monitoring, Customizing Extractors, Creating Generic Extractors, Designing APDs, Process Chains, Creating Open Hub Destinations

SAP BW on HANA Data Modeling, Creation of Advanced DSO, ODS View, Complex HANA Views, Creations of BW objects in SAP HANA environment, Reports on SAP HANA View using Analysis for Office SAP S/4 HANA Analytics Worked on creating Reports in HANA XSA consuming Data from S/4 HANA

SAP HANA XSA and WEB IDE Data Modeling in HANA XSA using WEB IDE interface. Creation of Space, HANA Views in Web Environment, Using GIT for Transports of HANA Objects, Connecting to Tableau

Microsoft Azure Building Applications in Azure, Creating ADF, Pipelines, Connections to HANA, SQL. Ingesting Data from Different Data- sources and sending it to BLOB storage . Visualizing data in Power Bi.

SAP Business Objects(3.X/4.0/4.2): Experience working on Business objects tools like Data Services, Data Quality Management, Web Intelligence, Analysis for Office, SAP Design Studio

SAP BPC Creating Planning and consolidation Model in BW for BPC, Models, Dimensions, BPF, Scheduling Data Manager package, Planning Functions

Tableau Creating Dashboards based on XSA HANA views for Financial Objects and Permit Vision in Oil and Gas Industry

Employer : MODIS ( June 2018 till Present ) :

Client : ExxonMobil June 2018 till Present

SAP BW/BO/HANA Consultant Expert The Woodlands, TX

Worked as a SAP BW/HANA Expert consultant in building a solution for Upstream Finance team to report on Current and historical Data from Mainframe systems.

Worked on UFO Project which includes Complex HANA Views, Stored Procedures, Connection to BW system,File systems.

Created Override reports with Users having ability to provide Manual inputs and hence changing the base values in the back-end.

Created planning sequences, Planning functions, Complex formulas to Input workbooks.

Worked in Complex Integrated planning objects with planning functions based on Classes created in SE24.

Worked on HANA 2.0 in WEB IDE interface to create HANA Views for Financial Applications.

Developed Tableau Dashboards based on XSA HANA Views

Developed Complex Algorithms to build Analytical Models as per the customer need using ABAP, SQL, CDS Views in memory to transform data for reporting needs for S/4 HANA Embedded Analytics.

Participated in Major upgrades and testing of systems utilizing advanced knowledge of SAP BI development application tool-set such as integrated planning, HANA, business objects and Tableau.

Developed Input screens with complex Algorithms to process Manual entry data along with Current and Historical Transaction data in SAP BW-IP as part of FAST Project. Supported Month end close process for all the regions to closing books.

Worked in Agile environment with Scrum masters to Deliver Deliverables on time.

Modified Existing HANA Views to improve the performance by introducing input parameters and checking the memory consumption through plan viz tool-set.

Worked on Integrating different objects from HANA and BW to create a robust UFO solution which is up and running used by approx. 300 users with 0 Defects.

Worked in Microsoft Azure Portal to develop a pipeline to bring data from on Premise HANA and store it in Blob Storage which can be later used for transformation and visualizations.

Created Resources like Storage Accounts, Data lake, Virtual Machines, SQL Servers, Azure Data factory, Embedded Power BI tools etc for Powerful Cloud Reporting in Microsoft Azure. Employer : Accenture LLP ( Aug 2011 to June 2018) : Client : LyondellBasell May 2017 to June 2018

SAP BW/BO/HANA Consultant Houston, TX

Worked as a SAP BW/HANA lead from Onshore for the client and is the single point of contact for all the issues.

Single Point of Contact to work on Management reporting which has visibility to the CEO of the Company. Experience in getting data from all the sources, cleansing it and Provide it to the Business in form of Crystal Reports in PDF forms which can be easily presented to CEO for Financial Numbers.

Worked on SAP BW on HANA Project to Transform the current Architecture to enhance the performance using BW on HANA Architecture.

Performing Pre-Migration and Post Migration activities for SAP BW on HANA Migration which includes Cleanup, activation of BI Content, Optimizing BW Cubes to HANA, Raising OSS Messages, Installing SAP notes, PSA and Change Log deletions, Compression and others

Recommending design changes to route long term strategy based on LSA++ architecture

Coordination of Migration activities with other teams involved like Basis, Security, DB, Enterprise, Testing, Procurement and others

Work with Quarterly Coordinator and higher management to prioritize and estimate the new enhancement and project request. Define/confirm the Quarterly scope for projects and enhancements

Worked on Complex Data Architectures such as COPA, SD, profit Center Accounting, Third Party Systems, etc.

Lead the offshore team of 10 under him and successfully delivering the Deliverables.

Worked on tableau and Complex calculation views involving Finance Data.

Presented many improvement Areas for the client wherein the overall cost of managing the systems has gone down.

Worked on Design Studio, SAP Lumira and Analysis for office for Reporting tools

Integral part of Data and Analytics team wherein Business can get solutions for their issues at one point stop and they can rely on.

Implemented several solutions to bring data from HFM (Third Party system) to SAP BW and vice versa suing Data services.

Supported BPC system for all the input template issues, Forecast and Budget issues and Executing the Monthly cycle for Forecast.

Client : Sumitomo Chemicals Dec 2016 to April 2017 SAP BW/HANA/BPC Consultant San Francisco, CA

Worked on BPC on S/4 HANA Functional Document creation along with Business and functional teams

Involved in sales planning, Marketing, Cost planning, Profit center planning Reports.

Worked with Business to Tranform the requirements generated from Third Party Tools into S/4 HANA Architecture for BPC.

Performed Activities to create BW on HANA objects to support BPC on S/4 HANA.

Worked on Analysis for office to use back-end Embedded BPC Models. Led the BW/BPC offshore team from onshore.

Involved in creating HANA Views, Models, Back-end Cubes, Planning Functions and Analysis for office BPC report

Client : FANAR+ USA Implementation Dec 2015 to Nov 2016 SAP BW/HANA\Defect Champion\Cutover Lead Charlotte, NC

Driving BW implementation project in SAP BW 7.3.

Worked on SAP BW on HANA platform for COPA and Inventory reports by creating Views on BW object and using HANA Live views.

Created around 80 Reports in the Project to support FI, COPA, SD, Inventory and Project systems.

Worked on making several project plans like planning the development, ISRT, UAT and Approach in completing Go –live successfully

Worked as Defect champion managing client expectation for IP implementation.

Worked as Cutover lead for successful go live of EP phase and is currently working on IP on a same role

Convinced client and client team to take better approach in project to avoid future issues thus building excellent client relationship.

Worked with user for User acceptance testing and Go Live Phase onshore

Worked with all the functional team to make system stable.

Worked on End to End cycle to implement various phases of Project.

Handled team of 8 Resources and guiding them to continue working positively

Worked on LO extractors, Data source enhancements, new reports and back-end flow.

Handled all the Project transports during whole phase of the project Client : FANAR+ UK Implementation Dec 2014 to Nov 2015 SAP BW/BI Consultant Newcastle, UK

Worked from onshore UK to meet client requirement.

Worked on all the phases of project right from Blue printing phase to go live support.

Expert in Transport process of Objects.

Gathered requirements from business at different stages and implemented all the solution satisfying Client

Worked in all the objects of BW and created WEBI reports on top of Bex Queries.

Worked on generic extractors, enhancing extractors in ECC.

Proficient in ABAP to handle all the ABAP requirements in BW space.

Lead the Team displaying good management skills

Implemented this project in short timeline successfully.

Almost worked on all the modules of ECC in reporting.

Devloped solutions for APO using BW data which gets extracted via Open hub tables.

Development Includes changes to DSOs, enhancement of routines, FM logic, Data sources, Queries and others. Client : Danisco May 2014 to Nov 2014

SAP BW/BI Consultant Copenhagen, DN

Worked on FICO, inventory, Sales, COPA reports.

Created Cubes, DSO, and Virtual Cubes and Managed the LSA structure in the project.

Worked on Data extraction from third party system in SAP BW 7.3

Managed the whole project with resources which I had to train.

Supported Phase Wise Go live support after successful go Live

Managed Client expectation with proper communication and learnt a lot about leadership skills.

Worked on APD’s as well to support difficult requirements from the business. Client : DuPont Aug 2011 to April 2014

SAP BW/BI Consultant Wilmington, DE

Worked in multiple projects under client which requires gathering business Requirement and implementation. Working on ABAP to provide solutions which are not feasible in BI.

Being part of Development and Support Team, worked on multiple Tickets which requires major as well as Minor Enhancement, Complex Data Loads.

As part of Large Enhancement, worked on creating new Data flows in both SAP BW 3.5 and SAP BW 7.01, Writing ABAP code in Start, Field, End routines and Expert routine.

Proficient in working with Data Source Enhancement in R/3, BADI, Customer exits, Info spokes, open hub, Designing DSO, info cubes, Multi provider, transformation, Info source, transfer rules.

Worked on Complex Query issues which involve RKF, CKF, filters, and variables per business requirement.

Worked on Assignment of roles to user and transporting them to portal in production.

Proficient in Designing Reports based on business requirement and adding all the functionalities required

Proficient in BI Accelerator to solve any issue related to it.

Worked on Performance tuning methods in Back-end as well as front-end.

Worked on Designing Process chains for new projects according adjusting current architecture of BW system.

Analysis & resolution of Technical/Functional issues reported by end-users/super-users. Expertise in tickets handling P1, P2, P3 raised by users & resolving them with in SLAs.

Monitoring all the process chains and Network (Huge network running for almost 17 hours a day). Working on Performance tuning methods to reduce the network time to make data available to user.

Working with multiple teams like Informatics, R/3, APO to solve various issues in BW.

Working on Analyzing failed transports and successfully migrate them to production.

Proficient in preparing Functional as well as technical document for BW objects based on Business requirement which helps in finding all the information together for that object.

Proficient in Unit testing, Integration testing and Scenario testing

Providing Accenture level training at various locations for resources not part of SAP BW. EDUCATION/CERTIFICATIONS:

Bachelor of Engineering in Information Technology from Thakur College of Engineering & Technology

Open SAP Certification for SAP BW on HANA

Open SAP Certification for SAP Analytics Cloud

Trained on other Skills :

SAP S/4 HANA on BPC

SAP Lumira

SAP Analytics Cloud

SAP Design Studio

SAP S/4 HANA on Embedded Analytics

Tableau



Contact this candidate