Prem Pithadia
Open to opportunities 📍 Kandivali West, Mumbai 🎓 B.Sc. IT · CGPA 8.85

// prem.pithadia

Prem Pithadia

Internal POC at Roswalt Realty, bridging 350+ business users and an external vendor team across four ERP modules — HRMS, IMS, AMS, and LMS — from requirements through UAT to go-live. Previously at Knight Fintech on SQL-heavy treasury systems and Tier-1 data migration for NABARD and ICICI Securities.

2.5+
Yrs experience
4
ERP modules owned
350+
Employees served
40%
Resolution time↓
Active
⚙️ HRMS: Attendance & Leave Management 🖥️ Asset Management System for employee-allocated electronics 🏗️ Portfolio site: recruiter-focused improvements

Experience

Work Experience

2.5+ years across ERP implementation, MIS, financial systems, and SQL data work.

Apr 2026 – Present

Roswalt Realty Pvt. Ltd. · Mumbai

MIS Executive — ERP Implementation & Product Ownership

  • The sole internal point of contact for a custom ERP being built by an external vendor — four modules (HRMS, IMS, AMS, LMS) for 350+ employees. Bridges the gap between business users and the vendor: gathers what the business needs, writes clear specs, keeps the vendor on track, and validates every delivery through UAT before go-live.
  • Drove HRMS from scratch — ran requirement sessions with HR and management across Recruitment, Onboarding, Attendance, Leave, Payroll, and Performance Management; wrote the full spec and built a working prototype so stakeholders could see and approve the product before it went to the vendor.
  • Delivered IMS for Red Thread Hotels (Morjim, Vagator and Calangute, Goa) — gathered requirements directly from the hotel principal, built a working prototype using Claude Code as a reference, and coordinated UAT and go-live with the vendor.
  • Handling AMS for company-wide device tracking and currently in the requirements phase for LMS — working with the business to define training paths, content structure, and how it connects to onboarding and performance. Also manages day-to-day ERP issues raised by internal users.
  • Built and presented multiple interactive prototypes using Claude Code for stakeholder demos, cutting approval cycles before development was commissioned.
  • Reconciled and cleaned 300+ user master records across two live platforms (ERP and HR system), identifying duplicates, mismatches, and access gaps.
  • Running daily sanity checks on ERP developments, bug tracking, and new feature deployments to maintain a zero-regression standard before each release.
ERP Implementation Product Ownership Stakeholder Management React · Node.js Python · Pandas Claude Code Hospitality · Real Estate
Aug 2025 – Mar 2026

Moksha Ayurveda Honey · Freelance & Self-directed

Freelance Sales Analyst & Independent Projects

  • Worked as a freelance analyst for Moksha Ayurveda Honey in Uttarakhand, building pricing and sales models to support their revenue planning and margin decisions.
  • Built and deployed a self-hosted Proxmox home server from scratch, containerising 8+ services including media streaming, photo backup, DNS filtering, file sync, and VPN.
  • Designed and shipped OneFinance end to end: data model, REST API, React front end, and Android APK via Capacitor, all running on self-hosted infrastructure.
  • Developed Python skills through project work, covering data processing, financial calculations, and automation scripts.
  • Built practical AI and prompting skills by building with LLMs, including prompt engineering and integrating the Anthropic API into personal projects.
Freelance Consulting Pricing & Sales Models Python · Pandas React · SQLite · Capacitor Proxmox · Docker Prompt Engineering
Mar 2024 – Jul 2025

Knight Fintech Pvt. Ltd. · Treasury Department

Production Support & SQL Developer

  • Reduced client ticket resolution time by 40% through structured triage, prioritisation, and ensuring all client requirements and bugs were resolved within agreed timeframes.
  • Led data migration for two Tier-1 enterprise clients (NABARD and ICICI Securities), moving lakhs of financial records across loans, assets, trades, user and company data modules from legacy systems to the platform using complex SQL.
  • Cleaned and validated master data for enterprise clients during migration, reconciling records using SQL and Excel to ensure zero post-migration discrepancies.
  • Wrote complex SQL including stored procedures, CTEs, and window functions across large treasury datasets; supported daily operations and resolved production issues for client environments.
SQL · MSSQL Data Migration Client Support · NABARD · ICICI Excel · Reconciliation Treasury Systems · FinTech

By the numbers

Impact that's measurable

Numbers from live deliveries, updated as projects close.

2
Tier-1 enterprise clients onboarded: NABARD and ICICI Securities
Client Onboarding · Knight Fintech
4
ERP modules owned as internal POC end to end: HRMS, IMS, AMS and LMS
ERP Implementation · Roswalt Realty
Lakhs
Of financial records migrated across loans, assets, trades and user data using SQL
Legacy Migration · Knight Fintech
300+
User master records reconciled and cleaned across ERP and HR platforms
Data Governance · Roswalt Realty
350+
Employees the inhouse ERP suite will serve across HRMS, IMS, AMS and LMS
ERP Delivery · Roswalt Realty
40%
Reduction in client ticket resolution time through structured triage and follow-through
Client Support · Knight Fintech

Projects

Things I've built & shipped

Real systems with real users. Not prototypes.

🏢 ERP & Enterprise Work projects delivered at Roswalt Realty

HRMS: End-to-End HR Platform

Overseeing the complete HRMS software for Roswalt Realty, covering Recruitment, Requisition, Interview, Onboarding, Probation, Confirmation, Attendance & Leave, Payroll, Performance Management, Employee Engagement, and more. Built a working React prototype and delivered a 6-document specification pack (PRD, solution architecture, engineering rules, decision log, phased plan, flowchart) as the vendor build contract.

10+ Modules PRD · Solution Architecture React · Express prototype Claude Code

IMS: Inventory Management System

Managing end-to-end implementation of an Inventory Management System for Red Thread, Roswalt Realty's hotel chain across Morjim, Calangute & Vagator, Goa. Held direct one-on-one sessions with the principal of Red Thread to gather requirements, then built a working prototype using Claude Code as a build-before-commission artifact. Coordinating development, UAT, and go-live with the vendor team. System covers assets, consumables, commodities, and hospitality laundry management.

Project Management · UAT Vendor Coordination Claude Code Hospitality · IMS 3 properties · Goa
⚡ Personal & Homelab Independent builds, designed, shipped, and self-hosted

OneFinance: Personal Finance System

A complete financial operating system running on my own Proxmox home server, designed, specified, and shipped end to end. Two editions: one for my personal daily use, one packaged as an offline-first Android APK.

Self-hosted · Docker · Proxmox React · Node.js · SQLite Android APK · Capacitor Cloudflare Tunnel
Personal Edition

Financial OS I use daily, with every account, card, investment, and loan in one place.

  • Net worth across 6 dimensions: bank, MF, CC debt, EMIs, loans, borrowed
  • Live mutual fund NAVs from AMFI, refreshed daily
  • Credit card statement cycling with interest projection
  • Reducing-balance amortisation for exact EMI liability
  • Recurring transactions with auto-scheduling
  • SMS parser auto-logs transactions from Indian bank notifications
  • 90-day cash flow forecast based on recurring transactions and upcoming EMIs
  • Analytics across income, spending, net worth trend, and per-category breakdown
  • Daily automated SQLite backups to NAS
User Edition

Same engine packaged as an offline-first Android APK. No cloud, no subscription.

  • Works fully offline, syncs to self-hosted backend when connected
  • Multi-account tracking across bank, credit card, and cash
  • EMI management with installment scheduling
  • Budget and savings goal tracking
  • Installs directly as an APK with no app store required
  • Users own their data entirely

Home Server & Hardware

Built, configured & optimised

Both machines spec'd, assembled, and tuned from scratch. The server runs a private always-on stack with no cloud dependency.

🎮 Gaming Rig
Custom build, cable managed and BIOS optimised
Built from scratch
CPU AMD Ryzen 5 7600X
Cooler DeepCool AG620
GPU ZOTAC RTX 4060 Ti 8GB OC
RAM 32GB ADATA XPG Lancer DDR5-5200 CL36
Mobo MSI B850M Gaming Plus WiFi 6E
Storage Kioxia 1TB NVMe + EVM 1TB SATA SSD
PSU MSI MAG A750GL 750W PCIe 5.0
Case DeepCool CG530 4F White
🖥️ Home Server
Proxmox VE 8.4.19 · 10+ services · 7TB storage · 24/7
Configured & optimised
CPU AMD Ryzen 5 8500GRadeon 740M iGPU
Cooler Cooler Master Hyper 212 Spectrum V3
RAM 16GB G.Skill Ripjaws S DDR5-5600 CL40
Mobo MSI PRO A620M-E
OS Drive WD Blue SN570 1TB NVMe
Storage WD Red Plus 4TB + WD Blue 2TB HDD
Hypervisor Proxmox VE 8.4.19LXC + VM
Network TP-Link Archer AX10 Wi-Fi 6

Everything runs on a single Proxmox VE bare-metal host. Each service lives in its own isolated LXC container, lightweight, individually manageable, and snapshotable.

WireGuard VPN is the sole remote access method. Zero ports are forwarded through the router; all external traffic arrives through the encrypted tunnel only.

A 4TB WD Red Plus holds the media library; a 2TB WD Blue backs up personal data. AdGuard Home filters DNS for every device on the LAN.

8+
Services running 24/7
₹0
Monthly cloud costs
0
Ports exposed to internet
24h
Max data recovery point
Network Topology · Homelab Infrastructure LAN only · WireGuard access · 0 ports exposed
Internet
💻 Remote Device
WireGuard VPN · Encrypted · Port 51820
→
🔒 WireGuard LXC 110
TP-Link Archer AX10 · Wi-Fi 6 Router
→ AdGuard DNS filtering → all LAN services
Proxmox VE 8.4.19 AMD Ryzen 5 8500G · 16GB DDR5 · 11 containers & VMs
Network
AdGuard Home DNS blocking · LXC 103
WireGuard VPN gateway · LXC 110
Media
Jellyfin Streaming · iGPU HW · LXC 102
Jellyseerr Requests · LXC 106
Seedbox Downloads · LXC 105
Files
Samba NAS Network shares · LXC 101
Nextcloud Cloud storage · LXC 120
Apps
Immich Photo backup · LXC 104
Finance App Portfolio + API · LXC 115
Homepage Dashboard · LXC 121
Smart Home
Home Assistant Alexa → WoL · VM 100
💽
WD Red Plus 4TB Media library · Jellyfin + Seedbox
💾
WD Blue 2TB Personal backup · Images & Documents
Live stats · auto-refreshes every 60s
— Server uptime
R5 8500G · 16 GB CPU · RAM
Proxmox VE 8.4.19 Hypervisor
— NAS usage · 7TB server total
Jellyfin
—
Loading…
AdGuard Home
—
Loading…
Jellyseerr
—
Loading…

Skills

Skills & Expertise

Business systems, data, and technical execution — from requirements to deployed software.

Business Systems & ERP

ERP Implementation Requirement Gathering PRD / FSD Authoring Stakeholder Management Product Operations Process Automation SDLC Governance UAT Vendor Coordination Phased Rollout

Data, MIS & SQL

MIS Reporting MySQL Microsoft SQL Server Data Reconciliation BI Dashboards Python · Pandas · NumPy Advanced Excel Tableau · Power BI Stored Procedures Window Functions · CTEs MongoDB · SQLite

AI & Automation

Claude Code Agentic Workflows AI-assisted Prototyping Anthropic API Prompt Engineering

Infrastructure & Dev

Linux Server Admin Proxmox · LXC · Docker React · Node.js REST APIs Git · GitHub WireGuard · Cloudflare Capacitor (Android)

Education

🎓

B.Sc. Information Technology

Thakur College of Science & Commerce, Mumbai

2020 – 2023  ·  CGPA 8.85

Certifications

Certifications

Udemy

SQL Masterclass: Beginner to Expert

Tharun Challa

Udemy

Python for Data Analysis

MTF Institute of Management, Technology and Finance

Udemy

Mastering Linux: The Complete Guide to Becoming a Linux Pro

OCSALY Academy

Let's talk. I'm open to opportunities.

Whether it's a new role, a collaboration, or just a conversation, fill in the form or reach out directly.