Skip to content
mimi

Executive Analyst & Automation Specialist

Shri Ram Metalloplast

India · On-site Full-time Executive Today

About the role

It looks like you’ve pasted the full job description for the Executive Analyst & Automation Specialist role at Shri Ram Metalloplast. If you’re looking for help preparing your application—whether it’s polishing your résumé, drafting a compelling cover‑letter, or showcasing the specific Google‑Workspace projects that match the responsibilities listed—I’d be happy to assist.

Below are a few ways I can help you move forward:

What you might need How I can help
Tailored résumé Create a one‑page or two‑page résumé that highlights your expertise with Google Sheets, Apps Script, AppSheet, MIS dashboards, and any manufacturing‑operations experience.
Cover‑letter Draft a concise, results‑focused cover‑letter that directly ties your past achievements to each of the key responsibilities (e.g., “Automated production‑tracking workflow that reduced data‑entry time by 40 %”).
Portfolio of projects Outline a short case‑study format for the most relevant automation projects you’ve built (screenshots, flow diagrams, metrics).
Interview prep Provide a list of likely interview questions (technical, behavioral, scenario‑based) and model answers that showcase your problem‑solving approach.
Salary & negotiation tips Offer market‑rate information for similar roles in the Sonipat/Haryana region and advice on how to negotiate a fair package.

Quick “starter” template for a cover‑letter (feel free to edit)

[Your Name]
[Your Address]
Sonipat, Haryana, India
[Phone] • [Email] • LinkedIn: [URL]

[Date]

Hiring Committee
Shri Ram Metalloplast
Sonipat, Haryana, India

Dear Hiring Committee,

I am excited to apply for the Executive Analyst & Automation Specialist position within the Founder’s Office. With over [X] years of hands‑on experience designing end‑to‑end workflow solutions in Google Workspace—particularly Google Sheets, Apps Script, and AppSheet—I have consistently delivered measurable efficiency gains for manufacturing operations.

Key highlights that align with your requirements include:

• **Custom ERP‑style system** – Built a Google‑Sheets‑driven production‑tracking hub for a mid‑size metal‑fabrication plant, integrating real‑time inventory updates via Apps Script and reducing manual entry errors by 35 %.

• **Automated quality‑control workflow** – Designed a Google‑Forms‑based QC submission portal linked to an AppSheet dashboard; automated alerts cut non‑conformance reporting time from 2 days to under 2 hours.

• **MIS & executive dashboards** – Developed dynamic, role‑based dashboards using Google Data Studio and embedded Sheets charts, delivering weekly KPI snapshots to senior leadership with a 0‑error data pipeline.

• **Cross‑functional collaboration** – Partnered with production, finance, and HR teams to map processes, gather requirements, and train end‑users, achieving 95 % adoption within the first month of rollout.

I am drawn to Shri Ram Metalloplast’s commitment to leveraging technology for operational excellence, and I am eager to bring my analytical mindset and automation expertise to support the Director’s strategic initiatives.

Thank you for considering my application. I look forward to the opportunity to discuss how my background can contribute to the continued growth and efficiency of Shri Ram Metalloplast.

Sincerely,

[Your Name]

Next steps

  1. Send me your current résumé (or a bullet list of your experience) and any specific achievements you’d like highlighted.
  2. Let me know if you have a portfolio (screenshots, links, or brief descriptions) of past Google‑Workspace automations.
  3. Tell me if there are any constraints (e.g., page limit for the résumé, preferred tone for the cover‑letter).

Once I have that information, I can produce a polished, role‑specific application package ready to send to the hiring team.

Feel free to share any additional details or ask for anything else you need!

Requirements

  • Expert-level proficiency in Google Workspace, especially Google Sheets (advanced formulas, query routing), and Google Forms.
  • Hands-on experience building functional applications with Google AppSheet.
  • Ability to write and deploy Google Apps Script to automate processes and integrate Google services.
  • Experience in MIS, data visualization, and creating business dashboards.
  • Analytical mindset with the capability to understand complex business processes and translate them into automated workflows.
  • Excellent communication skills for reporting to executive leadership and coordinating across teams.

Responsibilities

  • Design, build, and maintain a custom ERP-like system using Google Sheets, Google Forms, AppSheet, and Google Apps Script.
  • Automate internal manufacturing workflows, production tracking, and quality control processes.
  • Develop and monitor team task trackers and company expense tracking systems.
  • Manage Management Information Systems (MIS) by creating dynamic dashboards and automated reporting for leadership.
  • Serve as an Executive Analyst within the Founder's Office, offering data-backed insights for strategic decision-making.
  • Monitor system usage, troubleshoot technical issues, and optimize data flows across departments continuously.

Skills

AppSheetGoogle Apps ScriptGoogle FormsGoogle SheetsGoogle WorkspaceMISdata visualization

Don't send a generic resume

Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.

Get started free