Mis Executive

1 week ago

Dehradun Uttarakhand, India Inder Book Agency & A. P. Entertainment Full time

**Objective of the Role**

To manage, automate, and troubleshoot day-to-day business data processes using Google Sheets, Google Forms, Apps Script, and REST API integrations. This role ensures real-time visibility, systematic reporting, and smooth data flow across departments like CRM, Order Management, and Delivery.

**Key Responsibilities**

1. Google Workspace Automation
- Create Google Forms & connect to Google Sheets as per team requirements.
- Maintain dynamic Forms linked to task management systems.

2. Daily Tech Troubleshooting
- Solve real-time formula errors, data inconsistencies, or broken sheet links.
- Ensure smooth functioning of CRM, Order-to-Delivery FMS, and Feedback trackers.

3. Data Collection & Presentation
- Gather data from various sources including cloud apps, ERP systems, and Google Sheets.
- Standardize and clean datasets—remove duplicates, fix date/timestamp issues.
- Present clean, visual reports using pivot tables, bar/line graphs, and dashboards.

4. Dashboard Development (Owner & Team-Wise)
- Build custom dashboards for owner and team members to monitor:

- Order status
- Task completion status
- CRM task ageing
- Performance KPIs (per person, per department)
- Dashboards must be auto-updated, visually clear, and action-oriented.

5. System Integration via REST API
- Connect and sync data from external platforms such as:

- POS systems
- Sales CRMs
- Call tracking apps
- Inventory or billing software
- Use REST APIs (JSON, Webhooks) and Google Apps Script to fetch, push, and organize data within Google Sheets.

6. Insight Generation
- Identify data trends (e.g. who is submitting late entries, which orders are delayed).
- Share weekly/monthly summaries with responsible team members.
- Help the team act on lagging performance through actionable charts.

**Sample Real-World Tasks You Will Handle**

**Task** **Description**

**CRM Form Link Broken** Investigate and restore Google Form to Sheet mapping logic.

**Order-Delivery Delay Report** Identify who submitted orders late using timestamp data across Forms.

**Build Daily Order Dashboard** Combine order entries from different sources into a single view.

**Trigger Alerts** Send WhatsApp/Mail notifications when specific forms are submitted.

**Owner Dashboard** Summary view of all pending/late tasks by person/category

**Team Member Dashboards** Each doer gets a focused view of their own tasks, delays, and performance trends

**Skills Required**:
**Skill Area** **Must Have** **Notes**

Google Sheets & FormsAdvanced formulas, data structuring

Google Apps ScriptTriggers, custom functions, automation

REST APIKnowledge of POST, GET, tokens, webhooks

Excel (Advanced)Cleaning, dashboards, dynamic analysis

VisualizationPivot tables, bar/line/stacked charts

DashboardingPer-person, per-process views

DebuggingComfort with error tracing

Basic LogicCan write and explain logical workflows

CommunicationCan explain solutions to non-technical team members

**Job Types**: Full-time, Permanent, Fresher

Pay: From ₹15,000.00 per month

**Benefits**:

- Leave encashment

Ability to commute/relocate:

- Dehradun, Uttarakhand: Reliably commute or planning to relocate before starting work (preferred)

Work Location: In person

  • Mis Executive

    14 hours ago

    Dehradun, Uttarakhand, India Narang Ethnics Full time

    ❖ Data Management Executive (DME) who is good with EXCEL ❖ He should have good knowledge of different Excel Formulas ❖ He should have knowledge of Macros, if possible ❖ Thorough Knowledge of Excel or Google Sheets ❖ Should know Pivot Tables ❖ A background in Mathematics will help **Experience**: 3-5 years Working Experience as MIS. **Job...

  • Mis Executive

    2 weeks ago

    Dehradun, Uttarakhand, India Communication Solutions Full time

    **Job Summary (Night Shift)** Privately owned since Oct. 2010, Communication Solutions is an offshore outsourcing company that offers solutions related to back office research, development, analysis, and consultancy for top US brands across retail, hospitality, F&B, and real estate sectors. **Roles & Responsibilities**: - Provide oversight and management...

  • MIS Executive

    7 hours ago

    Dehradun City, Dehradun, Uttarakhand, India VIVO UTTRAKHAND Full time ₹ 1,92,000 - ₹ 2,28,000 per year

    Daily, weekly, and monthly reports preparetion (Excel / Google Sheets).Sales, Stock, Attendance, or Operations data collection & maintainanceProvide Management accurate dashboards & summaries.V-lookups, Pivot Tables, Charts, MIS automation.Data cleaning and data verification.coordinate with internal teams for data collection.analyze Performance reports...

  • Operations Executive

    2 weeks ago

    Dehradun, Uttarakhand, India Quess Corp Limited Full time

    We are hiring **Implant Operations**. - MS Office proficiency - Good knowledge of HR operations, compliance and payroll. - Client Coordination - Recruitment Support - Reporting & MIS Pay: ₹18,000.00 - ₹20,000.00 per month **Benefits**: - Provident Fund Work Location: In person

  • Billing & Dispatch Executive

    2 days ago

    Dehradun, Uttarakhand, India Vigyan Lime Group Full time

    **Responsibilities and Duties**: Billing, Dispatch & Related Tasks Transport Handling & Related Tasks Office Communication, Filings & Compliances Day-to-Day Sales, Purchase, Expenses, Voucher, GST, TDS, etc. Entries & Reco Misc. Accounting Related Tasks Operations on MIS/ ERP Platform Software **Required Experience, Skills and...

  • Tender Executive in Dehradun

    1 week ago

    Dehradun, Uttarakhand, India lakshy enterprises Full time

    **we have urgent requirement of Tender Executive in Dehradun** **salary - 18 k to 20 k** male or female both can apply Manufacuring Company **Experience Required: Minimum 2 Years** *Must have experienced in Government E-Market Place, Driving Sales and business opportunities in the form of Government bids and tenders through GEM/ E-Procurement...

  • Billing & Dispatch Executive

    6 days ago

    Dehradun, Uttarakhand, India Vigyan Lime Group Full time

    **Responsibilities and Duties**: Billing, Dispatch & Related Tasks Transport Handling & Related Tasks Office Communication, Filings & Compliances Day-to-Day Sales, Purchase, Expenses, Voucher, GST, TDS, etc. Entries & Reco Misc. Accounting Related Tasks Operations on MIS/ ERP Platform Software **Required Experience, Skills and...

  • Back Office Executive

    2 weeks ago

    Dehradun, Uttarakhand, India Nippon Global SL Full time

    **NIPPON BHARAT** Full-time, on site, entry-level openings for Back Office Executives (Female only) at Nehru Colony, Dehradun, Uttarakhand, India. Job Requisites: Freshers/Graduates in any discipline/ BBA/ MBA Excellent organizational and time management skills. Excellent written/verbal communication skills in English Ability to work as part of a team and...

  • Customer Relationship Executive

    6 days ago

    Dehradun, Uttarakhand, India Sanidhya Sansar Ventures Full time

    ChatGPTYou said:Jd for customers relationship Executive ChatGPT said: Here’s a professional **Job Description (JD) for Customer Relationship Executive** you can use or customize: **Job Title**: Customer Relationship Executive **Department**: Sales / Customer Service **Location**: [Your Location] **Reports To**: Customer Relationship Manager / Sales...

  • Operations Executive

    1 week ago

    Dehradun, Uttarakhand, India Vigyan Lime Group Full time

    **VIGYAN LIME** is a six-decade-old, time tested establishment into manufacturing, marketing & sale of Lime (Calcium) to top sectors like FMCG & various other sectors PAN India, whilst increasing the presence globally. Registered Office is at Race Course, Dehra Dun and Plants are in Rajasthan. **Responsibilities and Duties**: 1. Client Communication...