SAP BI/BW Analytics and HANA Developer
Resume:
`
Summary
*.*+ years of professional experience working in Business Intelligence.
Proficient in Business Intelligence, Data Analytics, Data Warehousing, Data Modeling, Data Reporting, ETL, requirement gathering, deployment, training, documentation and implementation of business applications that are allied to best industry practices and standards. Skills and Tool Highlights
• SAP BW/4HANA
• SAP SAC
• SAP Native HANA 2.0
• AMDP/ABAP
• SAP 3.X, 7.5.
• SAP ALM
• Query Designer and AFO
• Autosys, Control M.
• SAP BO
• MicroStrategy Reporting.
• SAP HANA Studio, Eclipse.
• SAP ECC, S/4 HANA System
Technical Summary:
• Responsible for end-to-end enhancements and support for various applications e.g. Assortment, Pricing, Sales, Delivery, Shipment, HR, Finance, Service billing and Quality management.
• Worked on S/4 HANA migration remediation project which involves migration from SAP ECC to SAP S/4 HANA 2023.
• Warehouse Modelling: Created ADSOs, CDS views, Transformation, Composite Provider, Info object Catalog, Info Objects, Info cubes, DSO’s, Multi Providers, Update Rules, Transfer Rules, Info Packages, Data Transfer Process (DTP) process Chains, etc.
• Experience in creation and customization of Transformations, Start Routines, Expert routines and End Routines and installing BW standard objects from BI content.
• Experience in performance tuning of query execution, creation of BEx Queries, Creation of Calculated and Restricted Key figure, Creation of Variables.
• Creating Input ready queries for planning model.
• Created SAC stories based on models with Live data connection on CDS views.
• Expertise in debugging ABAP Start, End, Expert Routines and generic extractors based on function module.
• Good knowledge in ABAP programming; including use of the various internal tables, function modules and remote function calls, update rules, Exits- CMOD/SMOD.
• Developed macros and SAP VB scripts to automate processes to ensure cost effectiveness and to minimize manual efforts
• Hands-on on Autosys and Control M tool – used for process chain automation.
• Hana Modelling: Hands on Experience in HANA Studio- Creation of Calculation view, Attribute View and Analytical view.
• Having ability to communicate effectively at all levels of Application Development phases in the Company.
Rajeev
Chandnani
SAP BW/4 HANA
Consultant
Contact:
Email:
rajeevchandnani11
@gmail.com
Contact
Address:
Languages
English – Proficient
Hindi – Proficient
Hobbies
• Sports
• Music
• Travelling
158 phase 2 Aditya Avenue
Airport road, Bhopal
Project Details:
Project 4 : SAP BW4HANA, SAP BW 7.5, Native HANA Consultant Company TietoEvry
Project SOK
Skills SAP BW4 HANA, SAP BW 7.5, SAP Native HANA, ABAP/AMDP, SAP SAC Duration December 2021 to Present
Role Lead Technical Consultant
Team Size 3
Location Pune, India
Responsibilities
Leading a team of 3 people with end-to-end responsibilities from AM perspective.
Working as an SAP BW4HANA, Native HANA, BW on HANA and SAC Consultant in L2/L3 team.
Responsible for end-to-end enhancements and support for various applications ex: HR, Service billing, Assortment and pricing, Sales and quality management.
Gained functional knowledge on SD, MM, Inventory, Assortment and Pricing applications.
Worked on enhancing business critical reports – ex: Sales, assortment, pricing and finance reports.
Experience in Integrated planning monthly activities involving Budgeting (Loading actuals as forecast), support users for planning, housekeeping activities.
Involved in bug fixes and enhancement of data flow in warehouse layer (ADSO, composite provider, open ODS views), HANA layer (enhancing calculation views, adding Input param, variables, calculated column.
Data extraction from ECC as well as S/4 HANA system and using SLT system.
Worked on complex mixed modelling – consuming ADSOs, semantic partitions in HANA CVs and CVs consumed in composite providers.
Converted ABAP routines to AMDP for performance optimization.
Involved in year-end activities for ADSO partitioning and semantic grouping.
Worked on HR data flow extracting data from workforce and success factor systems.
Implemented AMDP field and end routine to look up data and modifying result data set.
Implemented continuous service improvement (CSIs) to automate business processes. Example –
ABAP program to find where used list of ADSOs and Info-objects in routines. Housekeeping activities to prevent gowth of tables RSPMLOG, RSDTISCROSS etc. Implementation of snapshot ADSOs avoiding missing delta records for extractor based on CDS views. Created ABAP program to delete requests in foreground from ADSOs having more than 50K requests from table RSPMREQUEST.
Project 3: SAP BI/BW, BW4HANA, Native HANA Consultant Company Infosys
Project adidas
Skills SAP BI/BW HANA, SAP ABAP for BW, SAP Native HANA, MSTR Reporting Duration November 2019 to December 2021
Role Senior Associate Consultant
Team Size 3
Location Pune, India
Responsibilities
Involved in Requirement gathering, Gap analysis, Creation of technical specification, design, development, creation of test cases, unit testing, UAT, deployment and initial support post deployment.
Involved in enhancement of existing flow (Shipment, Demand, Sales, Prices, and Store inventory), Structural changes in SPOs, importing changes to HANA view and implementation of mapping and enabling attributes from projection to Semantics.
Experienced in applying logic in ABAP in transformation routines to achieve requirements and debugging routines to find the root cause.
Enhanced generic data source based on table and LO extractors based on Function module.
End to End enhancement from data source in ECC to modelling objects in BW to HANA views in HANA Studio, for example: derive and addition of metrics and attributes, deriving fields based on logic in BW and HANA views.
Importing BW and HANA objects.
Developed a custom ABAP program which transfers files from local server to application server and developed DTP filter routine to fetch dynamic filter selections from application server and automated the process through process chains.
Imported DSOs and Cubes as Analytical views in HANA and created CVs on top of it, also created calculated columns, restricted columns and input parameter.
Experience in running MSTR reports based on calculation views. Project 2 - SAP BI/BW on HANA Consultant
Company Allianz Technology
Project GRP and Service Accounting
Skills SAP BW/BI HANA, SAP ABAP
Duration January 2019 to November 2019
Role SAP BW Consultant
Team Size 4
Location Pune, India
Responsibilities
Working as an SAP BW HANA Consultant for German based company Allianz SE.
Experience in working on SAP BI/BW 3.x and & 7.5 flows.
Involved in development of various Data targets and Info providers like DSO
, Infocubes, Infoobjects, Multiproviders and ADSOs.
Involved in debugging ABAP Start, End and Expert Routines.
Worked on multi-Client source systems and monitored loads for SAP FICO module from R/3 (ECC) source system.
Process chain Monitoring and Load fixing sourcing from SAP ECC and other non-SAP Systems.
Complete automation of all BI Daily, Weekly and monthly loads (Info Package Scheduling) using Process Chain.
Good knowledge of few SAP Basis activities like - involved in transporting BI objects from development system.
Use of Near Line Storage service to archive historical data from HANA database.
Loaded Hierarchies from flat file and source system.
Involved in scheduling Bex broadcasters and created broadcasting settings. Project 1 - SAP BI/BW on HANA Consultant
Company Tata Consultancy Services
Project NIKE
Skills SAP BW on HANA, SAP BW 3.X
Duration August 2016 – December 2018
Role SAP BW HANA Consultant
Team Size 30
Location Pune, India
Responsibilities
Started working as BW on HANA consultant for NIKE Inc.
Experience in working on SAP BI/BW 3.x and & 7.5 flows.
Worked to provide L3 SAP BW Application support to End Users.
Active role in Month End activities to assist users in technical and functional areas.
Created Macros to minimize the efforts put into daily/monthly/weekly activities.
Created VB script to load sales and purchase orders from source system to BW.
Involved in Production Support and supported four production and quality systems which involved in resolution of data load failures.
Data load & job monitoring during testing.
Worked on rectifying data load failures and prevented re-occurrence of such failures, also documented the same as KBA for future reference.
Worked on SAP Retail system which involves Point of Sale, Merchandise and Assortment Planning, Master Data, Sales.
Achievement/Awards
• Appreciation for creating Macro which included usage of excel functions, Bex query, VBA function.
• Appreciation from client for creating SAP VB script for job scheduling automation.
• Bagged Nav Ratna award for analytical skills and adapting high performance culture. Certifications
• SAP BW4HANA 2.x (C_BW4HANA_27) and SAC certified (C_SAC_2415)
• Infosys SAP BW Professional Consultant Certificate
• Kanban Agile Certified.
• Exasol Certified.
• Gained certification in C/C++ at NIIT Bhopal
• Gained certification in Java and Advanced Java at Vedisoft Pvt limited, Bhopal. Education
Bachelor of Engineering: Computer Science – 2016 – 6.89 CGPA University Institute of Technology RGPV- Bhopal (MP), India High School: Science – 2012 – 83%
People’s Public School Bhopal,
India
Primary School: Science – 2010 – 8.6 cgpa
People’s Public School, India
Contact this candidate