Vignesh Kumar A

McCormick (September 2021 - till present)

• Developing and testing of Infoproviders (ADSO, Composite Providers, Info objects).
• Getting involved in AS IS and TO BE process.
• Filling set up tables of LO cockpits Datasources.
• Identifying bugs raised during initial investigation of multiple reports including Inventory, IBP and O2C.
• Developing CDS views.
• Creating Datasources based on CDS views and Functional Modules
  Activating standard Business Content.
• Enabling standard BW queries and create new one as per business requirements.
• Identifying data quality gaps and developing plan to close data quality gaps.
• Understanding Business requirement and design flow.
  End-to-end hybrid model development based on CDS views and BW4HANA objects till Reporting.
• Performing TUT and designing TSD after development is completed.
• Designing and creating data flow architecture of confidential business processes from BBP to Go live.
• Consolidating in the ADSO objects, the information of the processes that involve the SAP and SQL legacy systems.
• Using the ODP to connect the SAP data sources.
• Using Fiori to manage, activate and load data into SAP BW objects.
  Monitoring the process chain's progress and participating in the search for business opportunities and job development proposals.
• Writing ABAP codes at the start, end and transfer routines.
• Understanding and done Analysis on the Splitting Cube Project.\
• Extracting data from cubes and validating the splitting cubes.
• Moving Info cubes with transformations From Development to Quality and Production.
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization.
• Improved data load and query performance by doing compression, aggregates, partitioning.
• Creating Secondary Indexes on DSOs to speed up the data retrieval process and done testing in quality.
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.
• Involving in all transportation activities like TRs, and TOC and solving dependency issues while transporting and creating documentation.
• Involving in cookbook preparation and Go-Live activities of the project.
• Experience in Hierarchies, Authorizations, BW Statistics, Archiving, Process chains and Open hub.
• Creating the Sales Reports that provides output details like sales order no., date, item, material no., material description, net price, ship to party, quantity delivered, sales unit, pending quantity, pending value based on sales orders.

TOPCO Associates LLC (October 2016 - September 2021):

• Experienced in working with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools.
• Uploaded Master and Transactional data from flat files and SAP R/3.
• Created Aggregates and BIA index on info cubes to improve Query performance.
• Worked on Job Schedules for loading data and monitoring process chains to run periodic loads and other processes.
• Created Multiproviders to enhance the reporting base.
• Used BEx analyzer to develop Sales Analysis reports using filters, navigational attributes, calculated and restricted key figures.
• Worked extensively on Generic extractions like VIEW, Table and LO-Cockpits.
• As part of the Information consumer layer designed BEx reports for Business Analyst for decision making using Formulas, Selections, Structures, Calculated key figures, Restricted key figures and Used variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Worked with several users, interacted with them to gather requirements and transformed them to data models.
• Extensively involved in analyzing, customizing and activating delivered BW Business Content in the logistic area.
• Extracted data from SAP R/3 system (FI/CO, SD, MM) into SAP BW through LO, LIS, CO-PA, FI-GL and Generic R/3 data extraction techniques.
• Designed custom infocubes and DSO by enhancing the existing Infosources and Info Objects.
• Created Transformations, Start routine, End Routine and transfer routine and aggregates.
• Performed detailed analysis to improve the data load performance, data extraction performance using BW statistics.
• Responsible for data loading from SAP R/3 and Flat files to SAP BW.
• Created custom reports using Business Explorer (BEx) to give detailed level information from queries based on DSO and info cube.
• Testing and implementing the solution development of user exits for reporting purpose.
• Managing unit testing, quality assurance and testing processes.
  Developed a program to split data based on the number of lines and sending them in different files.
• Having Good Knowledge on the BW4HANA2.0 (Modeling, ODP Extractions, LSA++ Architecture).
• Experience in SAP HANA modelling and scripting
• Have developed an end to end data flow with ADSO, Open ODS views, Composite providers.
• Hands on experience in developing CDS views based extractors.
  Have written routines on AMDP scripting.