Sagar Gokak

Sagar Gokak

Followers of Sagar Gokak168 followers
location of Sagar GokakPune, Maharashtra, India

Connect with Sagar Gokak to Send Message

Connect

Connect with Sagar Gokak to Send Message

Connect
  • Timeline

  • About me

    Sr. Developer at PayAsia by Deel || MIS || Power BI || SQL || VBA || Macro Certified || Lean Six Sigma Green Belt (LSSGB) ®

  • Education

    • ANGADI INST., OF MNG., STUDIES (B, Com), BELGAUM

      2011 - 2014
      B.Com Business/Commerce, General Distinction

      Activities and Societies: Class Leader for 2 years, Coordinating & Managing all the events Good in academicsAccountancy & Economic's were my favorite subjectsParticipated & won few trophies & medals in events

  • Experience

    • ADP

      Jun 2014 - Feb 2024

      VBA Projects – T2S/T2I/Benefits/Specialty/CA Pay Check List & Error log automation. Production Count sheet for Payroll, Sales Support, Benefits & Invoice Admin Team. PMS Email & Error Log Email (to track Internal & External error). Open & Closed Case report for Payroll & Sales Support Team. Turn Around Report, Time Sheet, Excel to PDF & few formatting macrosDashboards – Production Report of Daily/Weekly/Monthly report for T2S, Payroll, Sales Support, Benefits & Invoice Admin Team. Daily Status/EOD/Weekly/ Monthly reports for team. Monthly SLA, Utilization & Quality Dashboard. The Voice, Appreciation & Leave Tracker. Based on the requirement prepare all types of Interactive DashboardsSupport to T2S Payroll Team - Audit setups in ADP system related to Payroll, Benefits, Specialty, CA Pay, T2I & share the audit results with BU partners for further action/on-board new clients. Support Sales Support team in Basics, Bench Mark & Worker’s Comp. Work with automation team to reduce the manual intervention in the process & increase the Quality & Productivity (T2S Payroll & CA Pay Automation). Work with state side SME on any process improvements & update the SOP & Checklist. Did RCA on Escalation, Security Incident, Errors/Loophole in the process. Providing Training/Refresher training to Associates & Acting SME (Floor Support) Show less Perform 100% Quality Audits for 10-15 Associates. Perform Sample Audits for 5-6 tenured Associates. Taken care of 10-15 associates for their Quarterly Performances. Tracking their quality performance & giving them feedback/necessary re-training on timely basis. Providing Floor Support, Training New Joiners & Retraining Associates with poor qualityscores. Prepared & shared Quality Dashboard, Daily Task, Efficiency & SLA reports. Handling Internal & External Client’s queries/escalations. Doing RCA for Escalations & Security Incidents. Driving Quality in the team to ensure the quality standards are met on daily basis. Assignment & reassignment of Invoices & Audits Show less

      • Senior Analyst

        Sept 2023 - Feb 2024
      • Quality Analyst

        Jan 2019 - Feb 2024
      • Quality Analyst

        Jan 2018 - Dec 2019
      • Senior Process Associate

        Jan 2016 - Dec 2017
      • Process Associate

        Jun 2014 - Jan 2016
    • PayAsia by Deel

      Feb 2024 - now
      Senior Developer

      Experienced in creating VB scripts, developing macros, and building interactive dashboards in Excel and Power BI. I specialize in managing end-to-end macro projects, supporting teams in developing tools to streamline processes, and assisting payroll teams with their needs. My focus is on enhancing efficiency and delivering solutions that drive operational excellence.

  • Licenses & Certifications

    • Visual Basic for applications (VBA)

      Udemy Free Courses
      Apr 2021
    • Certified Industrial Accounting (CIA)

      ICA EDU SKILLS PVT LTD-Sayajigunj
      Jan 2018
    • Tally 9.0

      Media Industrial Training Center
      May 2010
    • Structured Query Language - SQL

      Skill Nation
      Apr 2023
    • Microsoft Visio 13/16/19 Like a Boss - The Definitive Course

      Udemy
      Dec 2023
      View certificate certificate
    • Microsoft Power BI

      Udemy
      Jul 2023
      View certificate certificate
    • Lean Six Sigma Green Belt

      Simplilearn
      Aug 2022
    • Tally

      NIIT Limited
      May 2012
    • Computer Hardware & Networking

      National Institute for Micro, Small and Medium Enterprises(ni-msme)
      Jan 2013
    • Business Analytics with Excel

      Simplilearn
      May 2022
      View certificate certificate