Profileimage by Yogesh Patil SAP BW/HANA Consultant from Bangalore

Yogesh Patil

available

Last update: 06.09.2022

SAP BW/HANA Consultant

Graduation: Bachelor of Engineering (E&TC)
Hourly-/Daily rates: show
Languages: English (Full Professional) | Hindi (Native or Bilingual)

Attachments

Yogesh-Patil-CV-BW-on-HANA_260123.pdf

Skills

SAP BW/4HANA Certified with 7+ years of IT experience in ERP based Business Warehouse (SAP BW 7.5 on HANA, SAP BW 7.4/7.3 on Oracle, SAP BI 7.0), SAP HANA, SAP ABAP and Business Objects 4.2 of Implementation, Developments, Support, Migration and Roll-out projects.
Currently, I am leading my project of team 5 for one of the German Customer. I am really good with SAP BW on HANA skillsets along with SAP HANA modelling which helps me to work on Mix modelling approach. And knowledge of ABAP helps while working with pretty complex logics using different types routines.
I also worked on SAP BO tools like WEBI, Design Studio and Dashboard Designer (Xcelsius) and administration tasks.

Project history

05/2019 - Present
SAP BW/HANA Consultant (Team Lead)

Responsibilities:
  • Migration activity (migration from 3.x to 7.x) for master and transactional flows.
  • Pre-upgrade and Post-upgrade steps check.
  • Support activity with Process chains, existing Data flows.
  • Creation and Changes in BW queries and workbooks.
  • BW Data modeling like Info objects, ADSO’s, Composite Providers using HANA Studio
  • Creation and Changes in Authorization Roles.
  • Handling Transports of BW and BI.
  • ITSM Tickets based issue resolution.

03/2018 - 04/2019
SAP BW/HANA Consultant
Kirloskar Brothers Ltd

Responsibilities:
* Worked on Data modeling like creation of Info objects, ADSO's, Composite Providers, DSO's,
Info Cubes, Multi providers etc.
* Automated the data load through Process Chains.
* BW master and transaction data extraction.
* Inventory Data Extraction Activity.
* Worked on Inventory report, different types of MRM reports, Financial reports etc.
* Worked extensively on HANA Information Views i.e. Attribute View, Analytic View and
Calculation View and created mixed scenarios of BW and HANA.
* Created several queries and workbooks.
* Designed several dashboards using Design Studio.
* Moving Transports from development to Production system and tracking the changes.
* Documentation of Project management activities.

04/2017 - 02/2018
SAP BW on HANA Consultant
Windsor Machines Ltd

Responsibilities:
* Extensively worked activation of standard Business content, Data Modeling and Data
Extraction etc
* Extensively worked on HANA Information Views i.e. Attribute View, Analytic View and
Calculation View
* Worked on Information Design Tool
* Worked on several BEx Query
* Creation of process chains to load the data
* Worked on CDS Views
* Worked on Design Studio - Sales Dashboard, and Contribution Dashboard
* Support Activities

11/2016 - 03/2017
SAP BW Consultant
Spicer India Ltd

Responsibilities:
* BW support
* Data Modeling, Data Extraction, Transformation and Loading (ETL).
* Scheduling, Monitoring, Reporting and Performance Tuning.
* Extensively worked on InfoObjects, DSO/ODS, InfoCubes
* Master Data Extraction, Process Chains
* Worked on Routines.
* Worked on LO Extraction
* BEx Query Designer: Sales Report and Actual Sales Vs Target Report

03/2016 - 10/2016
SAP BI Consultant
SULA Vineyards Private Ltd

Responsibilities:
* Daily Monitoring and removing bugs
* Worked on BW modeling and data extraction
* Worked on BW Routines and user exits
* Support Activities
* Budget Vs Actual Sales Report, Creditors Ageing Report using Query Designer

11/2015 - 02/2016
SAP ABAP BI Consultant
Bilcare Ltd

Responsibilities:
* Data Modeling, Data Extraction, Transformation and Loading (ETL).




* Scheduling, Monitoring, and Performance Tuning.
* Worked on routines.
* Monitoring Process chains
* BEx Report - Order Reconciliation report

02/2015 - 10/2015
SAP ABAP BI Consultant

7. Project Name: SBI Mutual Fund, BKC, Mumbai (Implementation)
Role: SAP ABAP BI Consultant.
Duration: February'2015 to October'2015
Responsibilities:
* Data Modeling, Data Extraction, Transformation and Loading (ETL).
* Scheduling, Monitoring, Reporting and Performance Tuning.
* Extensively worked on InfoObjects, DSO/ODS, InfoCubes, Multiproviders, and Infosets.
* Extraction: LO Cockpit, Oracle DB, Flat files.
* Extensively worked on Field, Start, End and Expert routines.
* Worked on AUM Reports - Scheme wise, Scheme Location wise, Scheme Channel wise, and
Scheme Segment wise AUM Report.
* Designed Process Chains.
* Created BEx queries using BEx Query Designer
* Worked on BEx Analyzer

06/2014 - 01/2015
SAP ABAP Consultant
SHIVA Pharmachem Ltd

Responsibilities:
* Interact with client and gather require information.
* Define customize tables in SAP to maintain data.
* Master data upload for MM, SD, QM, PM modules using BDC and BAPI.
* Smart forms for Excise Invoice, Packing List, COA, RM Analysis, FG Analysis, Packed Material
Inspection, Returned Good Analysis, Import PO, Service PO, Bank Reconciliation, Bank
Payment Receipt, Advance Payment.
* ALV Reports Sales Register, Order Tracking Report, Open Order Report, Customer Ageing
Report, TDS Report, And Summary Report.
* Workflow: Send mail when MIGO posted.
* BDC: Master Inspection Characteristics (QS21), Legacy Data (AS91), Bank Statement Upload
(FF67), GL Account Posting (F-02).
* BAPI: Inspection Plan (QP01), Stock Upload.
* Enhancement: Display Vendor in Transactions FAGLL03, Profit Center and Plant for FBL1N
and FBL5N Transaction codes using BTE, Added Work Center Field in MIGO line item.

03/2014 - 05/2014
SAP ABAP Consultant
Garware Bestretch Ltd

Responsibilities:
* Smartforms - Reservation Print Form
* Report - RM & PACKINGS GOODS
* Changes in Reports, Smartforms, and Enhancements.

Certifications

SAP Certified Application Specialist - SAP BW 7.5 powered by HANA Delta
2020
SAP Certified Application Specialist - SAP BW/4HANA 2.0 Delta
2020

Local Availability

Only available in these countries: India
Profileimage by Yogesh Patil SAP BW/HANA Consultant from Bangalore SAP BW/HANA Consultant
Register