Mis Executive

6 days 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

    2 weeks ago

    Dehradun, Uttarakhand, India FirstCry.com Full time

    **Duties and Responsibilities**: Build tools and macros using VBA to eliminate or reduce the manual intervention and improve the quality of the tasks. Troubleshoot and resolve issues with macros and databases as they arise. Prepare reports as per the requirements, Daily/ Weekly & Monthly reports. Analyze data from databases and submit a summary...

  • Mis Executive

    1 week ago

    Dehradun, Uttarakhand, India FirstCry.com Full time

    **Duties and Responsibilities**: - Build tools and macros using VBA to eliminate or reduce the manual intervention and improve the quality of the tasks. - Troubleshoot and resolve issues with macros and databases as they arise. - Prepare reports as per the requirements, Daily/ Weekly & Monthly reports. - Analyze data from databases and submit a summary...

  • Tender Executive in Dehradun

    5 days 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...

  • Customer Relationship Executive

    3 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

    6 days 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...

  • Inventory and Billing Executive

    1 week ago

    Dehradun, Uttarakhand, India Integrin Healthcare Full time

    Prepare accurate invoices and bills using Marg ERP software. Maintain and manage inventory in Marg - including stock in/out, batch, expiry, and reorder levels. Ensure data accuracy and timely entries of purchase and sales. Generate and analyze daily, weekly, and monthly inventory and sales reports. Work closely with the accounts and sales team for...

  • MIS Executive

    6 days ago

    Uttar Pradesh, Uttarakhand, haryana, India Amar Ujala Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Role & responsibilitiesPreparing all daily, weekly, and monthly basis sales MIS Reports, Quality and Client Service reports and monthly Performance Status Reports on spreadsheetsAssisted in decision making process by accumulating, analyzing and documenting companys quarterly and half yearly performance detailsExpertise in performing Trend Analysis of Data...

  • Accounts & Billing Executive

    2 weeks ago

    Dehradun, Uttarakhand, India Sutlej Timbers Full time

    **Responsibilities and Duties**: Billing, Dispatch & Related Works Preparing Quotation, Performa Invoice & Related Documents Misc. Office Filings & Compliances Office Online & Paper Communication Misc. Backend Operations Day-to-Day Book Keeping and Misc. Accounting Related Work Filing GST, TDS, ITR and other Returns Reconciliation / Audit of Account...

  • Male Chef Domestic

    24 hours ago

    Dehradun, Uttarakhand, India Vigyan Family House Full time

    **Chef (Male) & Office Executive (Female) (Couples Only Full-Time Residential Domestic) at Race Course Dehra Dun Uttarakhand** Are you a Couple or Family looking for an opportunity to work & grow your skills as a Chef and Office Executive, while you get to stay in a nice, beautiful & posh locality in Dehra Dun? We are an Indian family in search of talented...

  • Male Chef Domestic

    1 week ago

    Dehradun, Uttarakhand, India Vigyan Family House Full time

    **Chef (Male) & Office Executive (Female) (Couples Only Full-Time Residential Domestic) at Race Course Dehra Dun Uttarakhand** Are you a Couple or Family looking for an opportunity to work & grow your skills as a Chef and Office Executive, while you get to stay in a nice, beautiful & posh locality in Dehra Dun? We are an Indian family in search of talented...