ENTERPRISE MIS / WORKFLOW 2018 – 2021

InfoTech MIS & Work Manager

Internal enterprise operational backbone and project task delivery platform for GIS, LiDAR, and engineering drafting.

InfoTech MIS served as the operational nervous system for an engineering enterprise specializing in GIS, Underfloor Heating, LiDAR, and Photogrammetry. It unified internal administrative processes (daily attendance regularizations, leave approvals, automated payslips) with a high-throughput production work manager that automated project creation, file dispatching to engineers, active task timers, multi-stage QA verification, and direct-to-client server publishing.

Visit Company Website

01.

The Challenge: Managing Complex Technical Deliverables Alongside Company Operations

InfoTech Enterprises operated at the intersection of complex technical drafting and high-volume client delivery. The firm executed engineering contracts across four specialized domains: GIS mapping, Underfloor Heating CAD layouts, LiDAR point-cloud classification, and aerial Photogrammetry.

At the same time, the company needed to manage daily operations for over 50 technical and administrative staff: attendance regularizations, multi-tiered leave quotas, employee records, and monthly salary and payslip calculations.

Before building the unified MIS, these two sides of the company were heavily fragmented. HR tracked attendance and payroll across disjointed spreadsheets. In the production floor, project managers manually emailed drawing files, copied large datasets across local network shared drives, and tracked engineer task hours by asking for end-of-day verbal reports. Handoffs to the Quality Assurance (QA) team were disorganized, and delivering finalized batches to clients required manual FTP uploads.

We needed a single, integrated web platform that could handle core company operations while transforming the technical delivery pipeline into an automated, traceable, and audited assembly line.

“An engineering firm cannot scale high-volume GIS and CAD projects if task files are passed around through shared folders and time tracking is an afterthought on a spreadsheet.”

— Shubham Upadhyay

02.

The End-to-End Production Pipeline: From Ingestion to Client Server Delivery

The defining breakthrough of the platform was the integrated Work Manager engine. Rather than relying on managers to manually sort and delegate incoming contract files, the system orchestrated the entire lifecycle from raw client upload to approved server delivery.

HOW TASK FILES MOVED THROUGH THE INFOTECH WORK MANAGER

1 Project Ingestion → Project created and categorized (GIS, Underfloor Heating, LiDAR, Photogrammetry)

2 Dynamic File Dispatcher → Client drawing and data files uploaded and randomly distributed across team members

3 Active Time Tracking → Real-time timers record exact work duration per task file from open to submit

4 Multi-Stage QA Queue → Completed files automatically route to senior QA specialists for inspection

5 Client Server Publishing → Approved files automatically push directly to the client's server for instant download

03.

Core System Architecture: Unifying Administration & Production

The MIS was architected into cohesive modules serving different operational needs while maintaining a unified relational database schema:

Human Resources & Payroll Automation

Integrated daily employee attendance tracking with automated regularization workflows, leave quota balances, and dynamic monthly payslip generation calculating basic pay, allowances, deductions, and tax compliance.

Daily biometric & web attendance regularizations
Multi-tier leave approval hierarchies
Automated one-click monthly payslip generation
Employee profile, document vault, and onboarding records

Domain-Specific Project & File Dispatcher

Engineered custom workflows tailored to InfoTech's four core service lines: GIS mapping, Underfloor Heating CAD layouts, LiDAR point-cloud annotation, and aerial Photogrammetry.

Domain categorization with custom SLA parameters
Bulk file batching & automated randomized assignment
Workload balancing preventing engineer bottlenecks
Real-time task dashboard for production floor leads

Active Work Timers & Quality Gateways

Replaced guesswork with real-time active timers that recorded productive hours from the moment an engineer opened a task file. Integrated multi-stage QA where rejected files looped back with annotated change requests.

File-level active timer start, pause, and resume
Automated SLA alerts on lingering or stuck tasks
Dedicated QA verification queue with inspection checklists
Direct client FTP / SFTP synchronization for signed-off deliverables

04.

PyQGIS Automation: Scripting Faster Workflows in QGIS

Alongside the web MIS, repetitive manual drafting and map layer inspection inside desktop QGIS consumed substantial engineer hours. I developed targeted Python automation scripts using PyQGIS to eliminate friction.

Manual Desktop Geoprocessing Bottlenecks

Engineers spent hours manually loading shapefiles, checking attribute table consistency, and verifying spatial projections.
Repetitive layer-by-layer polygon boundary validation and geometry cleaning slowed down drafting timelines.
Manual coordinate transformations and attribute exporting introduced human data entry errors in large GIS batches.
Drafting leads had to manually verify thousands of vector geometries before submitting batches to the QA queue.

PyQGIS Python Scripting Solutions

Wrote concise Python scripts utilizing PyQGIS to batch-import shapefiles, validate CRS, and automate attribute schema checks.
Automated boundary extraction, polygon closure validation, and geometry fixing with one-click terminal and QGIS console execution.
Accelerated daily processing throughput, freeing engineers to focus on precision drafting rather than tedious manual exports.
Standardized export pipelines directly into the format required by international client specifications.

05.

System Architecture & Internal Infrastructure

The MIS ran on internal Linux server infrastructure connected via a secure private local network, interfacing with desktop GIS workstations and automated client delivery servers.

Team Workstations

(Web Browser & QGIS)

←––→

Internal Gateway

(Private LAN Host)

–––→

PHP Application Engine

(Custom MVC Architecture)

MySQL & PostgreSQL

(Relational Operational DBs)

PyQGIS Script Engine

(Python Batch Geoprocessing)

Internal File Server

(Automated Client Sync)

–––→

Target Client Deliverables

GIS Mapping & Spatial

(ESRI Shapefiles & GeoJSON)

Underfloor Heating

(CAD Drawings & Heat Layouts)

LiDAR & Point Clouds

(3D Classified Datasets)

Photogrammetry

(Orthomosaics & Aerial Maps)

06.

Quick Project Facts & Operational Specs

A summary of system facts, operational scope, and technical infrastructure for InfoTech MIS:

Primary Role PHP Developer & MIS Specialist

Core Technologies PHP, MySQL, PostgreSQL, Python (PyQGIS), JavaScript, jQuery

Hosting Environment Internal Linux Servers (Private LAN & Client Sync)

Version Control Internal Versioning Server (Self-Hosted Platform)

Specialized Domains GIS, Underfloor Heating, LiDAR Point Clouds, Photogrammetry

Core Operations Daily Attendance, Leave Workflows, Automated Payslips, Task Dispatcher

QA & Delivery Multi-Stage QA Queue with Direct Client Server FTP/SFTP Sync

Desktop Automation PyQGIS Python scripts for batch geoprocessing & attribute inspection

07.

What I Learned Building This

Developing InfoTech's MIS and work manager taught me that enterprise software is fundamentally about eliminating operational friction. When engineers don't have to guess which file to work on next, and managers don't have to spend half their day manually compiling attendance or chasing project updates, the entire company moves faster.

Working alongside specialized teams in GIS, LiDAR, and underfloor heating also taught me the immense value of targeted automation. Learning Python and PyQGIS to automate repetitive geoprocessing tasks proved that writing small, pragmatic scripts directly at the problem point delivers immediate, massive productivity dividends.

Most importantly, this project formed the bedrock of my engineering career. Designing normalized database schemas, building multi-tier state machines, and writing reliable PHP backend logic from scratch established principles of performance and code durability that I still rely on every single day.