Jagseer Singh

Experience

• 

  SSPL

  Jun 2010 - Jun 2011

  Junior Consultant
• 

  Airtel

  Jun 2011 - Aug 2015

  Senior Executive

  Data analytics, MIS reporting, churn reduction and bad debts reduction

• 

  PwC India

  Sept 2015 - Apr 2016

  Consultant

  SAP Data Analytics using MySQL in SAP HANAClient – Manufacturing client.Team Size – 6My Role – Senior ProgrammerPerformed SAP Data Analytics using MySQL in SAP HANA for manufacturing client. SAP Modules covered in the scope are SD, MM, FI and PP. Overall Project scope covered the following key activities:• Identifying key areas for Risk assessment across in-scope processes• Performed walkthroughs with various process owners to define KPIs• Mapping analytics KPIs for identified areas• Identifying data sources for KPIs• Creating Business Logic for identified KPIs• Writing stored procedures in SAP HANA using MySQL language for identified KPIs.Few sample KPIs we created in are as follow:o Issue of material which is under blocked categoryo Issue of Payments to Blocked Invoiceso Value of Goods/ Service Receipt in excess of PO Valueo Duplicate Invoice with Duplicate Paymento Advance payment paid for the expenses are adjusted first and then only new payments are made to vendorso Sensitive PO details changes (not resulting in release changes) - Changing prices after release of PO, Changing Delivery Freight amounts after release of PO, Changing Payment Terms after release of POo Expenses document changed after posting(invoice/JVs)o Backdated Postings beyond acceptable limits Show less

• 

  KPMG India

  May 2016 - Mar 2017

  Consultant

  Data Analytics with Microsoft SQL Server & TableauClient – Agriculture Business International Client.Team Size – 5My Role – Project Lead and Senior ProgrammerUtilized Microsoft SQL Server to Implement Data Analytics for audit department. SAP processes covered in the engagement scope are Procure 2 Pay, Order 2 Cash, Inventory Management and Hire to retire. Overall scope of the work covered the following key activities:• Identifying key areas for Data Analytics project across in-scope processes,• Mapping Control KRAs for identified areas and Identifying data sources for KRAs• Creating Business Logic for identified KRAs• Writing stored procedures using T-SQL in Microsoft SQL Server for identified KRAs.• Visualization of SQL Server repost in Tableau• Documentation of user manual and technical document for SQL stored procedures developed.Few sample KRAs we created in are as follow:o Seldom vendor transaction during selected durationo PO versus Invoice analysis of amount and quantityo Price Change done in vendor invoiceo Duplicate GRN with same Doc Date/Delivery Note/Same Amount/Same Material code combinationo Split Purchase order within selected audit period.o Manual transactions posted in GL which are set as auto post.o Transactions posted in Dormant Bank accounto GL with Zero balances at Month end (during the months have transactions)o Stock Written off analysis during the selected period - Analysis to be performed on Material and Plant wise Show less

• 

  KPMG

  May 2016 - Apr 2019

  Assistant Manager

  Process Mining using SAP Hana MySQL and CelonisClient – Oil & Gas Sector client and Manufacturing client.Team Size – 7My Role – Project Lead and Senior ProgrammerHelped client in implementing Process Mining across Oil and Gas sector, Retail business and Telecom sector. Business processes covered in scope was more than 10 for each sector including Procure 2 Pay, Order 2 Cash, ITGC, Manage 2 Close, Plan 2 Produce, Cash and Treasury and Hire 2 Retire.• Performed walkthroughs with business process owners for in-scope processes, systems and applications for Process Mining• Created Object Views and Event Views using SAP Hana Stored Procedures, covering standard and customized objects and events based on client business processes• Performed Process Mining in Celonis using Views and Data sets created in SAP Hana• Created Process Models in Celonis by using “To be” business process activities• Identified and highlighted critical process deviations and violations by using Process Conformance by comparing “To be” Process model with “As is” Process model.• Performed in depth analysis in Celonis by studying various process variants• Identified key process steps which can be automated by analyzing Process explorer• Built Control KPIs using SAP Hana stored procedure written in MySQL language. Few examples of control KPI are as follow:o Duplicate payments to vendors,o 3-Way match,o Multiple Payment to vendor within X days,o Duplicate vendors in Vendor Master,o Duplicate customers in Customer Master,o Sales Return analysis,o Slow Moving Inventory etc.• Created Performance KPIs for Audit department and business teams using SAP Hana. Few examples of performance KPIs includes following:o Lead time analysis for PR creation to PR release, PR release to PO release, PO release to final goods receipts, GRN to payment.o Lead time analysis sales process,o Sales return percentage analysis,o Defective product ratio etc. Show less

• 

  EY

  Apr 2019 - now

  Manager