Software Modernization

Modernizing 17-year-old .NET software

How TranzIndia moved from .NET and MS SQL to Java, PostgreSQL and REST APIs, migrated 17 GB without data loss and cut server charges by 60%.

Conceptual engineering illustration for Modernizing 17-year-old .NET softwareTranz / Engineering in practice
TranzIndia · Legacy modernization

17 years of operations. A new foundation.

TranzIndia’s direct selling business had outgrown the software supporting it. We rebuilt the platform with Java, Spring Boot and PostgreSQL, migrated 17 GB of business data without data loss, and reduced server charges by 60%.

17 years

Legacy software modernized

17 GB

MS SQL data migrated without loss

60%

Reduction in server charges

REST APIs

A connected application foundation

The challenge

Every change had become difficult.

The system held years of business knowledge, but its architecture made it hard to improve performance, connect services or adapt to new requirements.

01

Business logic inside SQL

The legacy application ran on .NET and Microsoft SQL Server, with business rules embedded in stored procedures. Even small changes were difficult because application behaviour was tightly tied to the database.

02

Heavy infrastructure, slow operations

The repository exceeded 1 GB, and the application relied on a server with 64 GB of RAM. Despite that capacity, processing was slow and the running costs were high.

03

Limited ways to connect

The existing system had no API support, third-party integrations or AI capabilities. New services and automated workflows were difficult to introduce.

04

Manual work around the software

Teams spent time checking documents and managing work outside the core application. Finance relied on a separate Excel sheet, adding another operational handoff.

Architecture and migration

Preserve the data. Rebuild how the system works.

Plan around the business rules

Our team prepared the solution architecture and migration plan before moving the application. The work had to account for the rules held in SQL stored procedures as well as the records accumulated over 17 years.

Move from .NET and MS SQL to Java and PostgreSQL

We rebuilt the backend with Java and Spring Boot, using PostgreSQL for data and REST APIs to connect application workflows. Loosely coupled modules made the platform easier to extend as requirements changed.

Migrate 17 GB without losing data

The migration transferred the existing Microsoft SQL Server data into the modernized platform without data loss. Preserving the business’s historical records was a central requirement of the migration plan.

Connect the wider platform

React and Next.js support the web experience. The delivered stack also includes RATH ORM and the Tranz AI RAG model, giving the business a foundation for integrations, automation and AI capabilities.

The operational platform

Modernization across the distributor journey.

The rebuild connects the public product experience, distributor application, service-centre workflows and finance operations.

01

Distributor onboarding and KYC

PAN and bank verification APIs replaced document uploads and routine manual checking. RabbitMQ queues verification work, while match scores automate clear decisions and route borderline cases to a person.

02

Commerce and payments

Product discovery, ordering, wallets and PayU payment integration connect the distributor experience with business operations.

03

Network and recognition

Genealogy, commissions, weekly payouts, ranks and trip achievements give distributors and operational teams a shared view of progress.

04

Finance and reporting

Finance moved into the application alongside operational reporting, reducing dependence on separate spreadsheets and disconnected records.

Explore the automated KYC workflow ↗
The results

Faster software. Lower server charges. Less manual work.

60% lower server charges

The modernized software runs faster while costing less to host. TranzIndia’s server charges fell by 60% after modernization.

Less staff effort for routine operations

Automated workflows reduced the manpower needed for manual processes. Staff can focus on exceptions and operational decisions, with borderline KYC matches still receiving human review.

Capacity for distributor growth

The client reports that the platform supports more than 10,000 distributor registrations a day. Registration and completion of external verification checks are separate steps.

Recognition connected to business activity

The related achievers platform gives distributor progress and rewards a visible place in operations. The supplied project brief reports 48% more revenue for that initiative.

Migration, performance and server-cost outcomes are reported by the Tranz project team. The revenue figure relates to the achievers initiative; its measurement period and methodology are not supplied.

Delivery

A cross-functional team. Four months to delivery.

The deployed platform brought architecture, backend engineering, frontend engineering, design and quality assurance into one delivery team.

Two backend developers and two frontend developers worked with a solutions architect, project manager and team lead.

A senior UI/UX designer, a UI/UX designer and two quality analysts completed the team.

Client testimony

TranzIndia, in their own words.

Four people standing together in a group photograph

“Tranz Technologies helped us modernise our 17-year-old legacy Direct Selling platform into a scalable, enterprise-grade system.

Today, it supports 10,000+ distributor registrations a day, automates KYC with zero manual intervention, and has streamlined several of our critical business processes.”

Dr. Mohanraj VCMD, TranzIndia Corporate Network Pvt. Ltd.

TranzIndia is a group company. The relationship began in 2024. In the documented KYC workflow, strong and low matches receive automated decisions; borderline matches need manual review. See the KYC workflow ↗