SAP BW ABAP HANA

Sudhakar Koppineni
Sudhakar412@gmail.com
+91-9866225901
Summary

• 16+ years of experience in design, development and maintenance of Data warehousing applications on SAP Business warehouse and Various SAP Reporting Tools, SAP R/3 and SAP CRM Solutions.

• Managing and leading the team for implementing the SAP Analytical solutions .
• Core member of the team of Shell Crystal System Upgrade project.
• Core member of the team of Shell GPMR Migration project.
• Core member of the team of Shell Highlander project.
• Core member of shell Global commercial team supporting SAP BW projects.(Nextgen Webservices, Credit portfolio, Account payables and Receivables, HSSE Dashboards, Enhancement bundle)

• Technical expertise in SAP BI 7.5 on HANA, SAP-ABAP, BEX Query designer, WAD, Integrated Planning, Web, AOLAP, Analysis for Office, SAP Dashboards, SAP Design studio, SAP HANA, SAP -CRM,SAP-SD.
• Worked on end to end BI solutions.  Interpreting business requirements into technical specifications for Data warehouse and BI implementation, SAP R/3 and SAP CRM Solutions.

Educational Details

• Bachelor of Technology (B.Tech, Mechanical Engineering) from JNTU University 2000.

   
Technical Skills

• Technology                      
  • • • SAP BI 7.5 on HANA, SAP BO 4.1 – WebI, AOLAP, Analysis for Office, Query designer, SAP BW 7.0 and 7.3 Modelling, WAD(Web application development),Integrated planning.
      • Hands-on Experience in SAP HANA modelling.
      • Knowledge on Maestro SAP Batch Job Scheduler.

                                     

• Programming Languages                 SAP ABAP JavaScript, XML.
• Cross Applications                            ALE, EDI & IDOC

Employment Experience
IBM India7 YearsOct 2013 – till DatePackage Solution Consultant
Conexant Systems India Limited, Noida10 yearsJuly 2004 – Sep 2013SAP Technical Lead
List of Projects:

1. GPMR Migration project: Jan 2020 to Till date

ClientSHELL Petroleum Ltd
Technology   SAP BI 7.5 BEX Query Designer, BEX analyzer, BEX Web Application Designer
, BI Integrated Planning, SAP ABAP
Duration12 Months
LocationHyderabad, India
Type of ProjectMigration project
Project Desc.Migration of GPMR applications to GSAP system
Role in ProjectSAP BW ABAP Consultant
ResponsibilitiesUnderstanding the old requirement in GPMR systems.
Building the objects in GSAP system.
Supporting The end to end deliver of the project during build, unit test, User acceptance testing and Hyper care.
Technical DeliverablesBuild of Aviation, Marine, GKA, Sales and Credit Target Integrated Planning
Build of Child line, SFS Line, Profit Centre Entry unit Integrated Planning objects for Submissions.
Build of ABAP classes for File Validations and derivation logic.
Build of GPC and ERS Interfaces.
Build of User Account manager mapping for SP Users,
Identifying issues during reconciliation of GPMR and New GPMR objects in GSAP system.

1. Highlander project (Dec 2018 to Dec 2019)

ClientSHELL Petroleum Ltd
Technology   SAP HANA,  SAP BI4 WEBI
Duration13 Months
LocationHyderabad, India
Type of ProjectDevelopment
Project Desc.The aim of this project is to build objects which can be later used by different teams in shell with minor changes.
Role in ProjectSAP HANA Consultant
ResponsibilitiesUnderstanding the requirement by participating workshops with functional experts and Architects.
Created a new HANA view on top of tables in HANA which are replicated from SAP R3 using SLT
Created new WEBI Reports on top of the universe
Supporting The end to end deliver of the project during build, unit test, User acceptance testing and Hyper care.
Technical DeliverablesHANA Views: Plant, Material, Customer, Sales and Delivery, Primary and Secondary costs and Sales MI Daily and Monthly Views.

1. Enhancements CR’s(Jan 2017 to Nov 2018)

ClientSHELL Petroleum Ltd
Technology   SAP BW, SAP BI4 WEBI, Query Designer, ABAP
Duration24 Months
LocationHyderabad
Type of ProjectDevelopment
Project Desc.As part of Global commercials team member involved in CR’s
Role in ProjectSAP BW and BI Consultant
ResponsibilitiesWorking with SAP Consultants to implement the solution in Shell BW Landscape.
Implement w
New BW Models and enhancing the BO Reports to enhance functionalities
Technical DeliverablesEnhancement of throughput logic in BW Chemicals system
Change Site Acquisition type to GKA type in reports.
Enhancement of pack of bulk reports to calculate delivery time based priority .
Credit portfolio, Created ABAP interface programs in GSAP and Chemicals systems to generate files
Modified Chemicals CPT Data set flow by adding Risk category in complete flow and reports.
Enhanced Ageing reporting to fix Tax logic in reports.
Created Salesforce interface programs in GPMR system to generate files for sold, Ship to master data and Primary and secondary target files.
Developed Abap program which generates XML file. This file is sent to Hungary Tax department.
Developed webservices for Nextgen system to access Value and Volume reports, These report are used by Shell Market Hub Team.

1.    Crystal upgrade project to 7.3  : Mar 2016 to Dec 2016

ClientSHELL Petroleum Ltd
Technology   SAP BI 7.0 BEX Query Designer, BEX analyzer, BEX Web Application Designer
,
Duration10 Months
LocationHyderabad, India
Type of ProjectUpgradation project
Project Desc.Upgradation of Both BW and R/3
Role in ProjectSAP BW-ABAP Consultant.
ResponsibilitiesSupported Architects during Migration across landscape.
Technical DeliverablesAdjust objects based on SPDD and SPAU analysis.
Performed pre and post checks across landscape.
Managing the project by participating in daily calls with all the stake holders(Basis, SAP, Development and Support teams)
Fixing the issues during the upgrade.
Coordinating with SAP
Support during Hyper care.

1. Enhancements CR’s(Oct 2013 to Feb 2016)

ClientSHELL Petroleum Ltd
Technology   SAP BW, SAP BI4 WEBI,Query Designer,ABAP
Duration24 Months
LocationHyderabad
Type of ProjectDevelopment
Project Desc.As part of Global commercials team member involved in CR’s
Role in ProjectSAP BW and BI Consultant
ResponsibilitiesWorking with SAP Consultants to implement the solution in Shell BW Landscape.
Implement w
New BW Models and enhancing the BO Reports to enhance functionalities
Worked on GSAP ,GPMR and Chemicals Change requests
Worked in performance improvements.

1. SAP Integration with Sales Force – Dec 2011 – Jun 2012

ClientConexant Systems Inc.
Technology   SAP-R/3,BI,ABAP,Query Designer.
Duration7Months
Type of ProjectDevelopment
Location                  Noida
Project Desc.Enabling Sales details to save in Daily, weekly and monthly info structures and this data is later used by Sales team for reporting.
Role in Project

• ABAP Developer.
• Gap Analysis, development, applying business logic, Documentation, Testing and Deployment

Technical Deliverables

• Developed program to update Material and participants details  in Sales force.
• Program to create eRMA in SAP R/3 when request is submitted from Sales Force.
• Created CQA interface program to create Contracts in SAP.\
• Programs to update Customer details and Shipments in Sales force.
• Developed program to update forecast data from Sales force to SAP Z table.
• Created Program which is used to reconcile the GL Data with SIS infostructures.

Developed report to list data at document level.

 

1. SAP Backlog Billing & General Ledger Configuration – Dec 2009 – Jun 2010

ClientConexant Systems Inc.
Technology   SAP BW 7.0,Query Designer and Bex Analyzer
Duration7 Months
LocationNewport Beach, US
Type of ProjectDevelopment/Support
Project Desc.Enabling and Maintain Sales Backlog and Billing information in BW system for reporting.
Role in Project

• ABAP/BI Developer.
• End to End Business Requirement Analysis.
• Participated in workshops with all key stake holders (Business and IT) to understand the requirements and agree on the scope.
• Documenting the agreed scope of the project, sending the minutes and actions from the workshops. Following up on the actions if any.
• Handing over the high level and low level design documents with offshore team and Working closely to explain the requirements and the design walkthroughs.
• Conducted regular calls with developers to understand the progress of the build and to clarify on design aspects.
• Defining the test data for unit testing and User Acceptance Testing
• Conducting regular calls with business users to share the status and expectations of the delivery.

Technical Deliverables

• Involved in Data extraction using Data sources 0FI_GL_4,2LIS_11_VAITM,2LIS_13_VDITM etc.
• Enhanced Standard ODS 0FI_O02.
• Worked on Routines.
• Created Reports using Bex query designer and published in portal.
• Created Process chain to load data from R/3 to BW backlog billing and GL info providers.
• Extensively worked in data load monitoring and Fixing  Data load failures.

1. Channel Management – Oct 2008 – Aug 2009

ClientConexant Systems Inc.
Technology   SAP-R/3,SAP-CRM,ABAP
Duration11 Months
Type of ProjectDevelopment
Project Desc.To maintain Distys inventory details in CRM and processing claims for OEM;s
Role in Project

• ABAP Developer.
• Gap Analysis, development, applying business logic, Documentation, Testing and Deployment

Technical Deliverables

• Developed functions which are used for OEM and ODM Claim processing.
• Created program to show inventory and price details based on Date Selection.
• Created RFC to create contract in R/3 and replicate in CRM system.
• Developed BADI’s for Claim Amount checks, Resale authorization price checks, Resale Invoice Check
• Created Function to create POS records from flat file.
• Created Programs for credit approval and reserve adjustment.

1. Sales Information Systems – Dec 2006 – Jun 2007

ClientConexant Systems Inc.
Technology   SAP-R/3,SD,ABAP
Duration7 Months
Type of ProjectDevelopment
LocationNoida
Project Desc.Enabling Sales details to save in Daily, weekly and monthly info structures and this data is later used by Sales team for reporting.
Role in Project

• ABAP Developer.
• Gap Analysis, development, applying business logic, Documentation, Testing and Deployment

Technical Deliverables

• Developed Routines for GL Determination.
• Worked on user-exits for Infostructures.
• Created Daily weekly and Monthly Infostructures.
• Created Program which is used to reconcile the GL Data with SIS infostructures.

Developed report to list data at document level.
Support project July 2003 – Nov 2006
ClientConexant Systems Inc.
Technology   SAP-R/3, SAP-SD,ABAP,SAP-MM,SAP-FICO,SAP-HR
Duration3 years
Type of ProjectSupport
LocationNoida
Role in Project

• Supported users based on tickets
• Worked on production issues to identify cause of issue by debugging ABAP and Fixing issues
• Worked on Enhancement of existing user exits, reports BDC program, SAP scripts.
• Worked on EDI issues in fixing Idoc falures and reprocessing failed Idocs.
• Configuration of SAP SD based on functional requirements
• Configuration of ALE and EDI Modelling
• Enhancing Existing IDOC messages with new functionality.

Extra-Curricular Activities

• Guided IBM Motiva team in solving critical issues .
• Conducted SAP trainings to IBM Graduate hires.

I hereby declare that all the information furnished above is true to the best of my knowledge and belief.
Date:        10 Sep. 2020 Place:       Hyderabad,India                                                                                                                                    (Sudhakar Koppineni