Mahir Shah
Custom Colors
My Portfolio Systems, research, and products I’ve built
RE Portal ERP

RE Portal — ERP Platform

Custom ERP for Reekhav Engineers with accounting, payroll, order tracking, GSTIN-powered company auto-fill, and strict RBAC.

Excel Security Framework

Excel Security & Authorization

Secure distribution of macro-enabled workbooks with VBA + Flask authorization, tamper detection, and centralized monitoring.

Ekam Instagram Archive

Ekam — Instagram Chat Backup

Processes Instagram data exports, organizes media, and reconstructs readable chat timelines in a messaging-style UI.

Market Microstructure Engine

Market Microstructure Engine

Research-grade trading simulator with exponential price impact, liquidity-aware costs, and scenario-driven dashboards for events.

SIH Internal Hackathon

SIH Internal Hackathon (Organizer)

Designed and led the Smart India Hackathon internal round at Adani University with project scoping, judging, and mentoring.

RE Portal — ERP Platform

Stack:FlaskPostgreSQLJWT RBACRESTPDF pipeline

Custom ERP for Reekhav Engineers covering accounting, payroll, invoicing, order tracking, and GSTIN-powered company auto-fill.

  • Flask API layer with JWT-secured roles and scoped permissions per module.
  • PostgreSQL schema for ledgers, invoices, payroll cycles, and audit trails.
  • GSTIN validation + enrichment service to auto-fill legal entity data.
  • PDF invoice generation pipeline with templating and delivery hooks.
  • Admin analytics for cashflow, receivables, and payroll summaries.
  • Deployment scripts with scheduled backups and basic observability.

Excel Security & Authorization

Stack:VBA clientFlask auth serverChecksumsTelemetry

Secure distribution of macro-enabled Excel tools with server-verified access, tamper detection, and usage monitoring.

  • Workbook bootstraps call Flask auth server; unlocks only on valid token + signature.
  • Manifest checksums to detect tampering; locks functionality on mismatch.
  • Rate-limited endpoints with audit logging and alerting for abnormal access.
  • Central dashboard for usage visibility, revocation, and key rotation.

Ekam — Instagram Chat Backup

Stack:ParsersSQLiteJob queueChat UI

Processes Instagram data exports to rebuild readable chat timelines with media organization and search.

  • Parsers for Instagram export JSON; normalizes threads and participants.
  • Media deduplication pipeline with hashed storage and attachment mapping.
  • SQLite store for fast querying; queue to handle large archives.
  • Chat-style renderer with search, participant filters, and timeline jumps.

Market Microstructure Engine

Stack:PythonQuantitative modelsVisualization

Research-grade trading simulator exploring exponential price impact, order imbalance, and liquidity-aware transaction costs.

  • Exponential price-impact curves parameterized by liquidity and float.
  • Continuous integration of transaction costs for realistic slippage.
  • Scenario runner for shocks, block trades, and liquidity droughts.
  • Visual dashboards for academic demos and live showcase portal.

SIH Internal Hackathon (Organizer)

Role: Organizer & Mentor — Adani University

Designed and led the Smart India Hackathon internal round with scoped challenges, rubrics, and mentoring support.

  • Defined problem statements aligned to institutional strengths and SIH themes.
  • Built submission + scoring workflow and coordinated judges/mentors.
  • Scheduled tracks, office hours, and feedback loops for finalist teams.
  • Packaged learnings and recommendations for future cohorts.