Aagam Sheth

Own the technical direction of every Tirth Infotech engagement end to end, from bid-stage architecture and estimation through security reviews, deployment sign-off, and post-launch support. Set infrastructure standards for AWS and Gujarat State Data Centre hosting patterns, DMZ topologies, and CI conventions; choose stacks per project constraint rather than fashion; and mentor the engineering team through design and code review. Still hands-on: I review critical diffs personally and step into thorny performance or security problems directly.

Architected and shipped the Archives Portal for the Gujarat State Archives and the Food and Drugs Control Administration, hosted on the Gujarat State Data Centre across three servers in a DMZ topology — one machine each for the Django/DRF application, PostgreSQL, and MongoDB. Built dynamic, metadata-driven APIs and admin panels so any archival schema can be modelled without code changes, added Gujarati full-text search over TsVector lexemes, RFC 7233 ranged downloads for large documents, and hash-table caching on hot client and server paths. The platform cleared two security audits by a CERT-In empanelled auditor and remains in production.

Built SahajPranali for the Collector Office in Buldhana, digitising land-revenue records — 7/12 extracts, mutation entries, land-acquisition files, and registers — behind search by district, taluka, village, and case number. Designed the secure dual-login model: OTP verification for citizens alongside role-based access for officials, plus watermarking and audit logging on every document view and download. Paid online downloads cut office visits and physical record handling, speeding up citizen services while preserving the legacy archive.

Shipped in weeks, not months. A Karobari document retrieval portal for GSHSEB built on a static-generation model I chose after analysing how often the client's metadata actually changed — rarely — so static pages plus an AJAX search-suggestion panel beat a heavier dynamic stack on cost, speed, and reliability. Deployed solo-instance on AWS LightSail with Django and PostgreSQL.

Recruitment exams attract objections by the thousand, and this platform is where candidates file them and boards resolve them. I developed the Django + MS SQL Server system deployed on AWS behind Apache Httpd and mod_wsgi, then made it fast: profiling showed a cryptographic hash burning CPU on every request, so a custom XOR integrity check replaced it — roughly 70% CPU saved across all eight cores and headroom for about 5,000 requests per minute on a single instance. Hot queries moved to Transact-SQL stored procedures, Django was hardened for thread safety under Apache MPM Prefork (10 processes x 100 threads), and I still maintain the system today.

Custom stock management and tracking for GSHSEB covering purchase orders, sales orders, and internal and external transport movements across warehouses. Designed the ACID-compliant schema that kept accounting modules consistent, built more than ten reports shaped around how each office actually works, and gave administrators spreadsheet bulk-upload plus user management so operations never queued on developers. Django + PostgreSQL on AWS LightSail behind Apache.

Where it all started: five summers and part-time years maintaining VB.NET and C# WinForms applications for real clients with real deadlines. Customised over fifty Crystal Reports to match exactly what each office wanted on paper, travelled to client sites for on-premise deployments and support, and learned early the discipline of shipping software other people depend on.