Manpreet S.

Experience

1. Sr SAP Bi Lead Architect

   Cisco

   Jul 2019 — Present · San Jose, CA, US

   Working on Supply Chain Application called Business Analysis/Analytics Optimization.• Working for performance tuning of the slow executing Calcuation views. • Using hints and trace files to optimize the calculation views. • Reviewing the Data Models and Partitioning Strategies for big tables from performance perspective.• Working on Core SAP Native HANA Development procedures to extracted in XSJS frontend Application.• Review of Application Data Models from consistency and data scalability point of view.• Review of Calculation views from Performance perspective.• Responsible for designing the procedures and calling Calculation Views in SAP Native HANA procedures.• Tools like BODS and SLT were used to extract data from SAP ECC.• Various Supply Chain KPIs were build to enable dashboards for different types of External and Internal Users.• Landing pages were designed to extract different KPIs for both External Users like Suppliers, Contract Manufacturers etc. and Internal users were PM, Manager, Global buyers etc.• Data strategies were designed in view the big data practices in Operational Data Provisioning.• In Supply Chain methodology, strategies like launching, uploading the rates submitted were part of the application designed.