Web Development
Full-stack builds & SPAs
Custom business applications
MIS, Reporting & Dashboards
Real-time KPI tracking
Data management & analytics
Business Process Automation
Workflow & process digitization
PDF, email & trigger automation
Zoho Systems & Integration
CRM, Books, Flow, SalesIQ
Platform customization

Systems Builder · Web, Data & Automation
Web Development MIS & Reporting Dashboard Development Business Process Automation Zoho Systems & Integration Data Management & Analytics Custom Business Applications Workflow & Process Digitization Systems Building Web Development MIS & Reporting Dashboard Development Business Process Automation Zoho Systems & Integration Data Management & Analytics Custom Business Applications Workflow & Process Digitization Systems Building
booting ranjan.systems ...
ranjan.saha
Get in touch
available for new builds — remote

Ranjan Saha
turns spreadsheets into systems.

Web Developer & Automation Architect · Dashboards, MIS & Zoho Systems

I design and build the web platforms, dashboards, and automation systems that real businesses run on — from Apps Script and Sheets-backed tools to Zoho customizations and full web builds — replacing manual, spreadsheet-only processes with proper software.

View systems Start a project
system_status.log live
20+
systems in production
16
sheets aggregated live
5+
platforms & stacks
Ranjan Saha
Ranjan Saha · 📍 Remote
01 Philosophy

I call myself a developer — because building the systems a business actually runs on is real engineering, whatever it's built on.

I'm self-taught, and I've never been precious about the stack. What matters is the problem underneath: manual reporting eating hours every week, approvals stuck in someone's inbox, five versions of the same tracker with no single source of truth. I picked up Apps Script, then Zoho, then full web development, because each one was the right tool for a different shape of that same problem.

A good system doesn't just display data — it automates the paperwork, connects the tools people already use, and gets out of their way.

Today that means full-stack web development, dashboard design, MIS & reporting systems, and Zoho-based business process automation — built fast, built to last, and shaped around how people actually work, not how a textbook says a workflow should look.

02 Build Log

Where the systems got built.

Current
active

Systems Builder — Intensiv Filter Himenviro

Operations-side role designing and maintaining the internal web application layer for a manufacturing and environmental-engineering business — inventory, fleet/material workflows, MIS scoring, vendor follow-up, billing, and manufacturing advice systems, all built on Google Apps Script against live Sheets data.

Apps ScriptSheets as DBRole-based accessPDF & email automation
Ongoing

Freelance — Web, MIS & Zoho Automation

Independent web development, MIS reporting, dashboard builds, and Zoho-based automation for clients outside my day role — turning raw exports, disorganised trackers, and manual approvals into systems someone can actually rely on.

Web developmentMIS reportingZoho automationDashboarding
Ongoing

Web & Brand Design — side practice

Business websites, web-based forms, and custom logo design for stores, B2B companies, and chain-marketing businesses that need a fast, affordable, professional presence.

Web designFormsLogo design
03 Featured Systems

Real dashboards, running real operations.

A working set of the systems in production — every one a custom web-based dashboard that replaced a manual, spreadsheet-only process with proper software.

// Operations Systems
01 / IMSlive inventory

IMS Control Center

Live inventory monitor aggregating transaction logs into daily in/out/booked totals, category breakdowns, and top-movers — with 3D animated stock-status cards and one-click export to Excel, Word, and PDF.

Multi-sheet aggregationServer-side cachingAnalytics
02 / Export & Outward FMS20-step workflow

Export & Outward FMS Dashboards

Sibling SPA dashboards that carry material requests through a 20-step export flow and a 12-step outward flow, with role-based edit permissions tied to each step's assigned doer and live funnel filtering.

Step-wise workflowRole-based editsStale-while-revalidate
03 / Supplier ManagementPO-level tracking

Vendor & Supplier CRM

Tracks purchase-order follow-ups, agreed delivery dates, and call outcomes at the PO and item-wise-indent level, with an append-only audit log so every promised date and remark stays traceable across every supplier.

Audit loggingCalendar viewFollow-up tracking
04 / RFQauto-email quotes

RFQ & Vendor Quotation System

Lets the team spin up an RFQ against a requisition, email transporters or vendors for quotes through a public submission form, then compare line-item costs across every quote and select a vendor from one screen.

Public quote formEmail automationCost comparison
// Finance & Reporting
05 / Project Billingmilestone tracking

Project Billing Dashboard

Branded billing tracker ("BillingIQ") pulling live from a project data sheet, with charts, a milestone and project-timeline calendar, and an auto-logged billing history that fires on every status change.

Charts & calendarAuto-loggingProject timelines
06 / SOAcredit-note aware

SOA Management System

Generates per-project statements of accounts straight from invoice and PI trackers, exports clean PDF and CSV to Drive, and handles credit notes as their own reconciled line items — not manual adjustments.

PDF & CSV exportCredit note handlingPer-project reports
07 / Billing Breakupstage-wise view

Billing Breakup & Analytics

Breaks a project's billing down by stage — advance, milestone, and final — reconciled against invoice status, so finance can see exactly where a project stands without opening three separate sheets.

Stage-wise breakdownInvoice reconciliationFinancial reporting
08 / MIS & Reporting16 sheets

MIS Scoring & Reporting

Aggregates a shared "DB" tab across sixteen separate spreadsheets into doer-view and PC-view scoring, with delegated role-based visibility and an automated weekly summary email to management and each doer.

Role-based loginWeekly automationCross-sheet rollup
// Automation & Platforms
09 / MFG Advicerev-controlled

Manufacturing Advice Management

End-to-end advice tracking with revision control, dirty-row-only re-saves, auto-generated PDFs on every change, location-based notification routing, and a password-gated proxy viewer for production drawings.

Revision historyPDF generationDrawing viewer
10 / HR Hierarchyreal-time punches

Attendance & HR Hierarchy

Live worker attendance reading guard-entry punches against HR records, plus the same role-based hierarchy pattern — admin, delegator, delegatee — reused to give management and HR the right view without extra access.

Live punch dataRole-based hierarchyPunctuality scoring
11 / Automationautomation backbone

Business Process Automation

The layer that runs quietly behind every system above: PDF generation, staged approval emails, and scheduled triggers — payment approvals notify the right person automatically, weekly summaries send themselves.

Staged emailsTime-driven triggersZero manual re-sends
12 / Zohoplatform automation

Zoho-Based Systems

Zoho CRM and Books customization and workflow automation for teams that want an off-the-shelf platform adapted to their actual process, connected to the sheets, forms, and reports they already use.

Zoho CRMZoho BooksWorkflow automation
04 In Motion

The systems, running.

A quick look at how these actually behave — live inventory, step-wise workflows, scoring, and the automation quietly running behind all of it.

systems.ranjansaha.dev
IMS Control Center — live inventory
1,842
in today
1,206
out today
364
booked
Export & Other FMS — 20-step workflow
material request #EXP-2216 — step 14 / 20, dispatch clearance, assigned doer notified
MIS Scoring — cross-sheet rollup
Doer — Purchaseon-track
Doer — Dispatchdelayed
Doer — Billingon-track
Doer — Vendor Follow-upon-track
Business Process Automation
Sheet
trigger
Automation
logic
PDF +
email
✓ approval notification sent — no manual step
05 Process

How a spreadsheet becomes a system.

The same sequence, every time — because the risk in this kind of work is never the code, it's breaking a process people already depend on.

01

Map the real workflow

Sit with the actual sheet, the actual users, and the actual bottleneck — who fills what in, who approves it, and where it currently goes wrong — before opening the script editor.

02

Design the data backbone

Keep Sheets as the source of truth, but structure it properly: header rows, role tables, step-master sheets — so the data model can support a real interface, not just a form.

03

Build the interface

A single-page Apps Script web app with role-based views, so each person only sees the steps and records that are actually theirs to act on.

04

Automate the paperwork

PDF generation, staged approval emails, weekly summaries — the reporting work that used to happen by hand now fires itself, on schedule, without anyone remembering to do it.

05

Deploy, watch, harden

Ship it, then watch how people actually use it. Caching for speed, locking for concurrency, backups before deletes — the second version is always more careful than the first.

06 Toolkit

What every system is built from.

backend

  • Google Apps Script
  • Google Sheets as DB
  • LockService concurrency
  • Server-side caching

frontend

  • HTML / CSS / JS SPAs
  • Role-based UI states
  • Drag-to-explore charts
  • Responsive dashboards

automation

  • PDF generation
  • Staged email workflows
  • Time-driven triggers
  • Drive-based document flows

data

  • Multi-sheet aggregation
  • MIS & scoring reports
  • Excel / CSV / PDF export
  • Audit logging
data & analytics
SQL
SQL
BI
Power BI
LS
Looker Studio
development
GH
GitHub
JS
Node.js
R
React.js
GL
GitLens
AI & IDE
AG
Antigravity IDE
C
Claude.ai
CC
Claude Code
G
Gemini
AI
Google AI Studio
GPT
ChatGPT
CX
OpenAI Codex
CP
GitHub Copilot
CU
Cursor
RP
Replit
platforms & hosting
N
Netlify
W
WordPress
Zoho ecosystem
IQ
SalesIQ
CR
Zoho CRM
ZF
Zoho Flow
FM
Zoho Form
BK
Zoho Books
07 Services

Outside the day job.

Freelance work for teams that need one of these done properly, without hiring a full dev team.

MIS & dashboards

Reporting & dashboards

MIS reporting, data entry, and web dashboards that turn a raw tracker into something management can actually read at a glance.

data & admin

Data & virtual assistance

Excel and data management, analytics, and admin support for teams that need a reliable extra pair of hands on their spreadsheets.

web & brand

Web design & branding

Business websites, web-based forms, and custom logo design — quick turnaround, built for stores, B2B, and chain-marketing businesses.

08 Contact

Let's build something that outlasts the spreadsheet.

Have a workflow that's still living in someone's inbox and three versions of the same file? Tell me how it actually runs today — I'll tell you what it looks like as a system.

emailsaharanjan454@gmail.com
phone+91 96796 89526
locationRemote
linkedin/ranjan-saha-841b23432
availabilityopen to new projects
Ranjan Saha