Shift Timing - 8am to 5pm

Key Responsibilities

Reporting & Dashboards

● Design, build, and maintain MIS reports and dashboards in Google Sheets for sales, inventory, and operational data.

● Identify key metrics (totals, growth, top performers) and present them through explicit, pivot-table- and chart-driven dashboards.

● Set up energetic, self-updating reports using formulas such as SUMIFS, INDEX/MATCH, QUERY, and ARRAYFORMULA.

Systems Consolidation & Automation

● Consolidate data spread across multiple Excel/Sheets files maintained by different departments into a single, well-structured Google Sheets system.

● Build automation using Google Apps Script, IMPORTRANGE, and add-ons to eliminate manual, repetitive reporting work (e.g., auto-generated and auto-emailed weekly reports).

● Set up data validation, dropdown lists, named ranges, and access controls to keep shared systems clean and error-resistant.

● Plan and execute smooth transitions when migrating teams from Excel-based or manual processes to Google Sheets systems,



including backup and rollback planning.

Troubleshooting & Support

● Diagnose and fix broken formulas and data errors (#REF!, #VALUE!, #N/A) using a structured, step-by-step approach.

● Act as the go-to person for spreadsheet and reporting issues across departments, documenting fixes for future reference.

Process Improvement

● Proactively identify inefficient manual processes and redesign them into streamlined, systemized workflows.

● Continuously look for prospects to reduce manual data entry and reporting turnaround time.

Training & Change Management

● Train team members — including those resistant to change — on new systems and Google Sheets best practices, with patience and a teaching mindset.

● Provide ongoing, hands-on support during and after system rollouts.

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

Work Location: In person

📌 Mis Executive Surat (India)
🏢 Saileela Infotech Consultancy
📍 India