Production Case Studies & Systems Delivered

0%

Proxy Punches

< 2 sec

Sync Latency

45+ hrs

Monthly Time Saved

The Challenge:

Manual attendance suffered from proxy punches, lack of location verification, and delayed compilation into payroll.

The Solution:

Engineered an interactive web-based attendance terminal featuring live GPS geofencing (distance calculation vs office coordinates), front camera photo capture with mirrored preview, strict 1-Check-in/1-Check-out per day logic, and direct Google Sheets live logging.

62%

TAT Reduction

Complete Flow

Stages Digitized

Real-time

Bottleneck Detection

The Challenge:

A heavy machinery manufacturing plant faced severe delivery delays, untracked component shortages, and zero visibility into job-work stages.

The Solution:

Mapped and digitized a multi-stage manufacturing & procurement FMS covering raw material requisition, BOM breakdown, machine shop bays, vendor job-work, assembly, testing, paint shop, and final dispatch with automated Turnaround Time (TAT) and escalation alerts.

2+ hrs

Daily Time Saved

99.9%

Data Accuracy

Daily 6 AM

Automated Runs

The Challenge:

Attendance data trapped inside TrackOlap portal required daily manual exports and tedious formatting for reporting.

The Solution:

Developed an automated Google Apps Script pipeline that executes scheduled GET requests to TrackOlap REST APIs, parses nested JSON responses with pagination, processes check-in/out timestamps, and synchronizes clean employee attendance records directly into master sheets.

500+ / 10 min

Broadcast Speed

0%

Duplicate Rate

Enabled

Click Tracking

The Challenge:

Broadcasting operational notices, payment reminders, and marketing updates to 500+ clients and customers manually on WhatsApp was error-prone and time-consuming.

The Solution:

Built a custom WhatsApp automation engine utilizing AiSensy / Meta Webhook APIs. Features include personalized contact variables, short URL tracking, duplicate message guards, failed delivery auto-retry queues, and detailed transmission status logging.

-85%

Data Entry Errors

100%

Draft Recovery

Mobile/Tablet/PC

Device Support

The Challenge:

Sales reps and purchase officers made frequent formatting errors when submitting multi-line orders from mobile devices.

The Solution:

Created a responsive web app with dynamic line-item addition/removal, searchable vendor dropdowns, auto-calculated totals, LocalStorage draft preservation (recovering unsaved work on browser reload), print preview, and instant PDF generation upon backend submission.

10,000+

Files Indexed

< 1 sec

Search Speed

Weekly

Auto Scan

The Challenge:

Thousands of technical drawings, customer voice logs, and product videos scattered across Drive without unified indexing.

The Solution:

Engineered a recursive Google Apps Script scanner that traverses deep Drive folder hierarchies, extracts metadata (file size, mime type, last modified, owner), generates direct playback/preview URLs, and maintains a clean, searchable sheet catalog with duplicate elimination.

45%

SMS Cost Reduction

Automated

Link Generation

Per-link clicks

Analytics

The Challenge:

Long spreadsheet links caused high SMS character costs and looked unprofessional in dealer communications.

The Solution:

Integrated the Insprl URL Shortener API into automated dispatch workflows. Generates branded short links dynamically, logs short codes with destination mapping, and implements fallback handling if the API is momentarily unavailable.

94%

On-Time Completion

8 Depts

Department Views

Daily / Weekly

Review Frequency

The Challenge:

Management lacked a single pane of glass to review daily delegated tasks, pending checklist submissions, and team performance.

The Solution:

Designed an executive KPI dashboard in Google Sheets & Looker Studio. Aggregates live task delegation data, tracks planned vs actual completion dates, calculates compliance percentages, and highlights overdue tasks by department.