Mis Executive

**Job Summary**:
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 certifications for 10th, 12th, and Graduation.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

Pay: ₹25,000.00 - ₹35,000.00 per month

Schedule:

- Day shift

Application Question(s):

- Do you have any knowledge of Google Sights & Google Data Studio?
- Do you have knowledge of Rahul Jain & Sanjeev Jain Courses?

**Education**:

- Bachelor's (preferred)

Work Location: In person