profile-pic

Dishant Garg

Dishant Garg

Experienced Executive with a demonstrated history of working in the outsourcing/offshoring industry. Skilled in PBI Dashboards, Visual Basic for Applications (VBA), Microsoft Office.

  • Role

    Data Science & Analytics - Other

  • Years of Experience

    4 years

Skillsets

  • Advance Excel - 5 Years
  • SQL - 2 Years
  • ETL - 5 Years
  • VBA - 5 Years
  • microsoft excel
  • Microsoft Office
  • PowerBI
  • Web Scrapping

Professional Summary

4Years

  • Senior Assistant

    Deloitte

  • Software Engineer

    IDS Infotech Limited

  • MIS Executive

    Genpact India Pvt. Ltd

  • MIS Executive

    EXL Service.Com (I) Pvt. Ltd

Applications & Tools Known

  • icon-tool

    VBA

  • icon-tool

    Excel

  • icon-tool

    Access

  • icon-tool

    Outlook

  • icon-tool

    Power BI

Work History

4Years

Senior Assistant

Deloitte
    Generate and distribute management reports, developed Excel/Access/Outlook macros, manipulate worksheet and cell properties using VBA, and confer with internal customers.

Software Engineer

IDS Infotech Limited
    Automated reporting to ensure quality, trained teams, and collaborated on a book writing system within MS Word.

MIS Executive

Genpact India Pvt. Ltd
    Developed Access databases to manage reports, worked on Power BI Dashboards, and automated files and reports.

MIS Executive

EXL Service.Com (I) Pvt. Ltd
    Used advanced Excel for business process streamlining and developed Microsoft Access databases for FP&A Process using VBA.

Achievements

  • Generated and distributed management reports in an accurate and timely manner
  • Developed custom Excel/Access/Outlook macros for business requirements
  • Conferred with internal customers to understand needs and assisted in project completions
  • Automated numerous reports ensuring quality and meeting client requirements
  • Developed a database in Access that saved over 10 hours of work daily
  • Deployed multiple tools for Claims Teams improving efficiency
  • Re-engineered existing tools for improved results

Major Projects

3Projects

Payment Due Reminder Tool

    Segregates clients list from a database based on multiple criteria and creates reminders.

Points Calculator

    Calculates monthly points for FTEs based on tasks performed and effort.

Website To Excel - Web Scrapping

    Scraps data from a client's website using VBA and allocates data to each FTE based on AHT.

Education

  • Master's in Computer Applications

    The I.K. Gujaral Punjab Technical University

  • Bachelor's in Computer Applications

    Kurukshetra University