Job role :-
Making various FMS, PMS, IMS in Google sheets for various dept and as per the needs.
Making and updating mis score dashboard for various department
Creating and making report as per the management requirement
Making task automate through google sheets by using google app script.
Email reminder automation for delegation task
Email notification automation for new enquiry assigned.
Trouble shooting of issues coming in various FMS, IMS, PMS & MIS.
Changing and updating the FMS as per the system need.
Training to the concerned person, dept for the newly created FMS,IMS,PMS.
Updating and maintaining google sites. (Intranet)
Making various dashboard for data visualization.
Making and updating mis score dashboard for sales team.
Making and updating mis score dashboard for production and other dept each.
Need Skills :-
Javascript
HTML/CSS
Google App Script
Google Sheets, Google Forms, Google Docs
Google Sites
Google Query Function
Google Drive
Google Add on's
Form-Mule Email Notification/Reminder
All google formula in google sheets
Excel VBA
Advanced excel