Zimyo HRMS
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
Additional Information
- Date of Birth : 29-Oct-1989
- Father Name : Sh. Hari Ram Sharma
- Nationality : Indian
- Marital Status : Married
Software
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 -
Similar Profiles
Rishab Kumar GogoiRishab Kumar Gogoi
Office Assistant at Om Motors, An Authorised Dealer For Bajaj AutoOffice Assistant at Om Motors, An Authorised Dealer For Bajaj Auto
Vipul KhannaVipul Khanna
Accountant at Garg Motors(Authorised Dealer of M&M)Accountant at Garg Motors(Authorised Dealer of M&M)
Akash MalikAkash Malik
Finance and Accounting Manager at Sai Motors PCD (Tata Motors Authorised )Finance and Accounting Manager at Sai Motors PCD (Tata Motors Authorised )