Profileimage by Ashwin Sonekar SAP BI Consultant from Bengaluru

Ashwin Sonekar

available

Last update: 27.05.2018

SAP BI Consultant

Company: IBM
Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional) | Hindi (Native or Bilingual)

Attachments

ashwin-sonekar-ibm-sap-bi_3-years-experience.docx

Skills

Skill Sets
  • ERP: SAP R/3 4.6C, ECC 6.0
  • Data Warehousing: SAP-BW 3.5, SAP BI 7.3/7.4
  • Languages: Basic knowledge of ABAP and SQL.
  • Operating Systems: Windows 7, Windows XP.
  • Reporting Tool: BEX Explorer.
  • Ticketing Tool: Remedy, Service now and JIRA.

Professional Chronicles:
  • 3 years of SAP BI experience, which includes Data-Modelling, Data Extraction, Data Loading, Scheduling, Monitoring,
Reporting and Performance Tuning.
  • Extensively worked on designing/creating Info-Objects, Info Sources, Transfer structures, Communication structures, Standard and Custom Info-Cubes,
 Data Store Object (DSO), Process chains.
  • Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI.
  • Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA and reloaded to Data targets.
  • Data Extracting from the Source system using LO Cockpit and Generic Extractions for all the logistics data.
  • Written User exit, Customer exit, Subroutine in BW as per the business requirement.
  • Having basic idea of reports(Classical/Interactive/ALV), Interfaces (IDOC's, BAPI's and RFC), Conversion (BDC, BAPI) Enhancements (User exit, Customer exit, BADI's,
 Implicit and Explicit enhancements)
  • Having basic idea of ABAP repository, Transaction, Function Modules etc. in ABAP.
  • Have worked on Remedy, HPQC, Service Now tool and JIRA.
  • Good interpersonal skills, result oriented, hard working with a quest and fervor to find out modern technologies and embark on challenging tasks
  • Having an experience of the project being in the transition time.

Project history

Project: AMS (Functional Team)
Client: CARHARTT
Duration: January 2017 – Till Date
Assignment carried out:
  • BW Enhancement Team:
  • Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multi-providers and Open-hub.
  • Data Source Enhancement according to customer requirement.
  • Creating and managing dataflow using DTP, transformations and info packages.
  • Worked with SAP R/3 Logistics (LO) in loading Sales and Distribution data into BW.
  • Set up periodic Data Loads Error message distribution to the recipients.
  • Creation of Generic Data Sources from table, view.
  • Knowledge of using Structures, cell definition, calculated key figures, restricted key figures, new selection, new formula, exceptions and conditions.
  • Write Customer exit, User exit, Subroutines in BW as per the client requirement.
  • Worked on moving transport from Dev to Quality systems for testing purpose.
  • Production Support Team:
  • Involved in 24x7 Production Support.
  • Monitoring of Info-packages/DTP and analyzing the reasons for frequent failures of Info-packages.
  • Schedules DTP for loading Transactional Data from PSA to Info Provider and IP to Open Hub using process chains.
  • Maintaining ticketing tool (Service Now) for saving SLA’s.
  • Involved in frequent client meetings to discuss project status.
Project: Production Support
Client: BRITISH PETROLEUM
BP is one of the world's leading international oil and gas companies, providing its customers with fuel for transportation, energy for heat and light, retail services and petrochemicals products for everyday items.
Duration: August 2015 – December 2016
Assignment carried out:
 Supporting Retail Project (DART-Delivery Advanced Retail Technology) in SAP BW Module.
  • Primarily working on Data Load Monitoring/Scheduling and Housekeeping jobs like SID Deletion, Query Deletion.
  • Involved in extracting the data from External Source system like Informatica.
  • Schedules DTP for loading Transactional Data from PSA to Info Provider using process chains.
  • Corrected delta load failure while loading the data from POSDM.
  • Worked on POSDM Workbench for extracting the day to day transactional data.
  • Involved in creation and testing of Yearly/Quarter cube.
  • Involved in Historical data deletion and loading.
  • Solving issues raised by clients on live Production System.
  • Uploading flat files like Accelerator calendar and Promo calendar
  • Involved in Manual Regression Testing(MRT) in the Quality System during the release activities.
  • Completing assigned activities during PEC/QEC/YEC and Non-PEC/QEC/YEC periods
  • Blocking & Unblocking of loads during system outage.
  • Sending status mails to business about various data loads.
  • Documentation of the reconciled report and updating to SharePoint.

Local Availability

Only available in these countries: India
Flexible in Bangalore location
Profileimage by Ashwin Sonekar SAP BI Consultant from Bengaluru SAP BI Consultant
Register