Summary
Overview
Work History
Education
Skills
Additional Information
Software
Timeline
AccountManager
Vivek Sharma

Vivek Sharma

MIS Manager
Near Mother Ladali School Prakash Nagar Nunhai Agra,Uttar Pradesh

Summary

Results-driven MIS Manager with 12 years of extensive experience in data analysis, reporting, and team leadership. Adept at utilizing a diverse skill set encompassing Google Sheets, Google Forms, Google Drive, Advanced Excel, Google Data Studio, SQL Server and Power BI to streamline and optimize organizational processes. Proven track record of developing and implementing innovative solutions to meet diverse MIS requirements.

Overview

14
14
years of professional experience

Work History

MIS Manager

Ashok Auto Sales Ltd. Authorised Dealer Tata Motors Ltd.
11.2017 - Current
  • Automated reporting processes using Google Sheets, Google Forms, Google Drive, SAP portal, SQL Server reporting, and HRMS reporting, resulting in increased efficiency and accuracy.
  • Developed advanced Excel models to streamline data analysis and reporting tasks.
  • Created MIS reports, dashboards, and company portal reports using Google Data Studio, Power BI, SAP portal, SQL Server reporting, and HRMS reporting to provide real-time insights to management.
  • Connected FMS, MIS, IMS, and monitored employee Task Sheets, ensuring seamless communication and data flow between systems.
  • Led a team of 15+ members in handling management requirements and implementing new processes.
  • Generated FMS MIS reports on a weekly, monthly, quarterly, and annual basis for multiple departments including HR, Account, Sales, and Workshop.
  • Calculated and distributed employee incentives on a monthly and quarterly basis.
  • Monitored the annual employee increment process and prepared employee annual performance reports for management.

MIS Manager

Virola Shoes Pvt. Ltd.
12.2015 - 10.2017
  • Managed state distributors and outright ecommerce parties for Alberto Torresi brand, including Amazon, Mantra, Reliance, Azio, and others.
  • Oversaw shoe order processing, stock monitoring, production planning, and dispatch coordination.
  • Coordinated the logistic process of material dispatch to ensure timely delivery.
  • Utilized Google Sheets for data management and reporting.
  • Generated FMS and BMS reports. - Created MIS reports, including order Priority Reports, Merchant Reports, and Monthly, Quarterly, and Annual Sales Reports.
  • Utilized advanced Excel formulas to create management MIS dashboard reports.

Senior MIS Executive

GAPL Agencies Private Limited.(Authorized Distributor For Procter & Gamble India Ltd.)
08.2010 - 11.2015
  • Managed market retailers and oversaw the order processing and billing processing schemes for Procter & Gamble India Ltd. products.
  • Monitored product sales reports and provided regular updates to the management team. - Developed and maintained strong relationships with retailers and customers.
  • Applied bill and DSE (Direct Sales Executive) incentive schemes to encourage sales. - Prepared daily, weekly, monthly, quarterly, and annual retailer product sales reports.
  • Managed MIS dashboard reports with advanced Excel formulas and SQL server reports. - Utilized various billing processing schemes to ensure timely and accurate billing.

Back Office Executive

First Flight Courier Pvt Ltd.
08.2009 - 07.2010
  • Assisted customers with any order-related queries or issues, promptly responding to emails or phone calls.
  • Communicated promptly with customers, providing them with information about their courier shipments.
  • Professionally dealt with complaints and escalated issues when necessary, ensuring customer satisfaction.
  • Liaised with the warehouse to address any issues or concerns raised by customers. - Coordinated with courier companies to resolve any problems or inquiries raised by customers.
  • Maintained a high level of service awareness at all times, ensuring a positive customer experience. - Operated incoming and outgoing load operations, ensuring efficient handling of shipments.
  • Handled administrative tasks related to backoffice operations, such as data entry and documentation.
  • Assisted in maintaining accurate records of customer interactions and transactions.

Education

MBA -

Karnataka State Open University
Agra
04.2001 -

Bachelor of Science - Mathematics

Dr Bhimrao Ambedkar University
Agra
04.2001 -

Skills

    Data Analysis Tools: Google Sheets, Google Forms, Google Drive, Advanced Excel, Google Data Studio, Power BI, SQL Server

Automation: MIS report generation, Data dashboard creation, Report updates

Reporting: Weekly, Monthly, Quarterly, Annual Reports

Team Management: Leadership, Task delegation, Team collaboration

Departmental Focus: HR, Account, Sales, Workshop

Additional Information

  • Date of Birth : 29-Oct-1989
  • Father Name : Sh. Hari Ram Sharma
  • Nationality : Indian
  • Marital Status : Married

Software

Zimyo HRMS

Timeline

MIS Manager

Ashok Auto Sales Ltd. Authorised Dealer Tata Motors Ltd.
11.2017 - Current

MIS Manager

Virola Shoes Pvt. Ltd.
12.2015 - 10.2017

Senior MIS Executive

GAPL Agencies Private Limited.(Authorized Distributor For Procter & Gamble India Ltd.)
08.2010 - 11.2015

Back Office Executive

First Flight Courier Pvt Ltd.
08.2009 - 07.2010

MBA -

Karnataka State Open University
04.2001 -

Bachelor of Science - Mathematics

Dr Bhimrao Ambedkar University
04.2001 -
Vivek SharmaMIS Manager