MIS Executive

Office Location- Prashant Vihar

Timings: 9:45 am to 6:45 pm

Working Days: 6 working days only Sunday off

JD FOR MIS EXECUTIVE

Job Title:  

MIS Executive

Location:  

Delhi/ Prashant Vihar (Rohini)

Salary Range:  

Salary details:- 25k to 35k

Reports To:  

CEO

Job Summary:

MIS is a Management Information System. An information system is computerized and uses data from multiple systems to make decisions, coordinate, control, analyze, and visualize information. The MIS Executive is responsible for managing and coordinating the maintenance and growth of the organization's Management Information Systems. The role involves data analysis, report generation, system maintenance, and ensuring the accuracy and integrity of data.

Roles & Responsibilities:

An MIS Executive should focus on creating, maintaining, and analyzing Google Sheets that align with the organization’s core functions and reporting requirements. Here’s a breakdown of the most critical Google Sheets they should focus on:

1. Financial Management Sheets

• Expense Tracker: Tracks departmental or project-wise expenses against budgets.

• Revenue Reports: Monitors sales revenue and projections over time.

• Profit & Loss Statements: Summarizes income and expenses to calculate net profit.

• Cash Flow Analysis: Tracks incoming and outgoing cash to ensure liquidity.

2. Sales and Marketing Sheets

• Sales Performance Tracker: Tracks individual or team sales against targets.

• Lead Management: Maintains lead information, stages, and conversion rates.

• Marketing ROI Analysis: Tracks marketing campaigns and evaluates their effectiveness.

• Customer Database: Maintains customer details for sales and marketing efforts.

3. Inventory and Procurement Sheets

• Stock Inventory: Tracks stock levels, reorder points, and aging inventory.

• Purchase Orders: Logs all purchase requests, approvals, and statuses.

• Vendor Management: Maintains vendor contact details, pricing, and payment history.

• Supply Chain Tracker: Monitors the status of goods in transit and delivery timelines.

4. HR and Employee Management Sheets

• Attendance Tracker: Logs daily attendance and leave records for employees.

• Payroll Management: Tracks salary disbursements, bonuses, and deductions.

• Employee Performance Dashboard: Maintains KPIs and appraisals for employees.

• Training Schedule: Plans and tracks training sessions for employees.

5. Operations and Project Management Sheets

• Task Management: Tracks tasks, deadlines, and status across projects.

• Project Progress Tracker: Monitors project timelines, budgets, and milestones.

• Operational Dashboards: Consolidates data to monitor daily operational performance.

• Process Compliance Tracker: Tracks adherence to standard operating procedures (SOPs).

6. Data Analysis and Reporting Sheets

• KPI Dashboards: Consolidates key performance indicators for real-time monitoring.

• Trend Analysis: Visualizes historical data for trend spotting and forecasting.

• Error/Exception Logs: Tracks discrepancies in data or processes for corrective action.

7. Customer Service Sheets

• Complaint Resolution Tracker: Monitors customer complaints and their resolution status.

• Customer Feedback Database: Logs customer feedback for improvement strategies.

• Service Performance Metrics: Tracks SLA compliance and resolution times.

8. Automation and Integration

• Create Google Sheets integrated with tools like Google Forms, Apps Script, Zapier, or APIs to automate data entry, update notifications, and reporting workflows.

Focus Priorities

• Start with sheets critical to organizational goals.

• Automate repetitive tasks using Google Sheets formulas, macros, or Apps Script.

• Regularly review and update the sheets for accuracy and relevance.

By focusing on these sheets, an MIS Executive ensures efficient data management and actionable insights.

Qualifications & Experience:

Education:

Must hold Bachelor’s degree in Computer Science, Information Technology, or a related field.

Experience:

Minimum 3 years of experience in information systems management or a related field.

Proven track record in developing and implementing MIS solutions.

Skills:

- Technical Proficiency: In-depth knowledge of database management, software development, and system integration.

-Analytical Thinking: Ability to analyze complex problems and develop effective solutions.

-Communication Skills: Excellent verbal and written communication skills for effective collaboration and report writing.

Teamwork:

Ability to collaborate effectively with other team members.

Problem Solving:

Capable of identifying and resolving issues quickly in day-to-day tasks.

Working Conditions:

Environment:

Office Job

Office Timings:

9:45 am to 6:45 pm

More about this MIS Executive job

1. What is the eligibility criteria to apply for this MIS Executive job?
   Ans: The candidate should be Graduate and above and above with 2 - 6+ years Experience of experience
2. How much salary can I expect for this job role?
   Ans: You can expect a salary of ₹25000 - ₹30000 per month that depends on your interview. It's a Full Time job in Delhi.
3. How many working days are there for this MIS Executive job?
   Ans: This MIS Executive job will have 6 working days.
4. Are there any charges applicable while applying or joining this MIS Executive job?
   Ans: No, there is no fee applicable for applying this MIS Executive job and during the employment with the company, i.e., GVI HARDWARE.
5. Is it a work from home job?
   Ans: No, it’s not a work from home job and can't be done online.
6. How many openings are there for this MIS Executive role?
   Ans: There is an immediate opening of 1 MIS Executive at GVI HARDWARE
7. Who can apply for this job?
   Ans: Only Male candidates can apply for this Back Office / Data Entry job.
8. What are the timings of this MIS Executive job?
   Ans: This MIS Executive job has 09:45 AM - 06:45 AM timing.