Client project

Poduppil Constructions

Moving a growing construction firm onto ConstraPro.

Client:Poduppil Constructions
Industry:Construction
Year:2025
Status:Live
Poduppil Constructions
Overview

Poduppil Constructions had years of history in a legacy system: projects, purchase bills, received payments and supplier balances. They needed to move to ConstraPro without losing anything and without the numbers changing.

I built a set of migration tools that read the old database, cleaned and de-duplicated the data, mapped it to the new models and verified that every total matched the original.

✳ The problem

Years of financial and project history in a legacy system that could not be switched off until the new one matched it exactly.

✳ The solution

A read-only, repeatable migration with integrity checks, Excel archives of the old data, and a cut-over to ConstraPro running on AWS with automated deployments.

Features

What it does.

  • (01)

    Legacy data migration

    144 projects, 12,700+ purchase bills, received payments and supplier opening balances migrated with totals matching to the rupee.

  • (02)

    Data clean-up

    Material names trimmed, normalised and de-duplicated; labour and expense entries separated from real materials.

  • (03)

    Archives

    Complete Excel exports of the old database and old website kept as a permanent archive.

  • (04)

    Company website

    Public website with projects, services and a construction cost calculator, managed from the dashboard.

Under the hood

Engineering highlights.

  1. 01Source database never modified — only read queries were issued
  2. 02Integrity checks: no orphaned payments, no missing creditors, unique project numbers
  3. 03Production backend on AWS EC2 behind Nginx with CI/CD and automatic rollback
My role

Full stack developer — migration, deployment and ongoing support.

Tech stack
  • Node.js
  • MongoDB
  • Next.js
  • React
  • AWS EC2
  • GitHub Actions
Deepak®

Reach out to me

Contact me

Let’s create together.

✳ Results-driven solutions

Have a product idea, a website to build or a system to modernise? Send me a message.