TECHSALO
CASE STUDY / WEALTHTECH

FROM HISTORICAL RECORDS
TO INTELLIGENT WEALTH.

Engineering a connected mutual fund distribution, investor digitization, financial data and robo-advisory ecosystem.

SCALE
100TB+ data environment
INDUSTRY
WealthTech / Financial Services
CLIENT
Confidential
THE TRANSFORMATION MANDATE

MORE THAN A PORTAL. A CONNECTED WEALTH ECOSYSTEM.

A leading wealth-management organization needed to modernize a mutual fund distribution estate spanning a large investor base, years of transactions and multiple external data sources.

TechSalo connected digital distribution with the data foundation required to reconstruct portfolios, power analytics and support personalized investment guidance.

Investor digitizationDistributionTransactionsData engineeringPortfolio analyticsRobo-advisory
01 / HISTORICAL DATA DIGITIZATION

FRAGMENTED RECORDS. ONE FINANCIAL DATA FOUNDATION.

SOURCESLegacy systems · CSV · Excel · RTA files
→
INGESTExtract · parse · validate
→
RESOLVEClean · normalize · map identities
→
CURATEInvestor · folio · transaction data

Identity resolution

PAN, investor IDs, folios, email and mobile mapped into a unified investor view.

Transaction reconstruction

Purchases, SIPs, redemptions, switches, dividends and adjustments classified reliably.

Data quality

Duplicate, count, amount, unit and source-to-destination controls isolated exceptions.

Incremental processing

New historical datasets could enter the platform without redesigning the application.

02 / MUTUAL FUND DISTRIBUTION

ONE DIGITAL JOURNEY. FROM PROFILE TO ADVICE.

Every investor touchpoint runs on the same connected service and data foundation—from first-time onboarding to ongoing portfolio guidance.

01OnboardIdentity & KYC
02ProfileNeeds & risk
03DiscoverFund universe
04AnalyzeCompare & assess
05InvestPurchase & SIP
06TrackValue & returns
07ReviewAllocation & goals
08AdviseNext best action
01 / EXPERIENCE LAYER

Every channel.
One investor context.

  • Investor web
  • Mobile application
  • Advisor workbench
02 / SERVICE CORE
API

Reusable wealth services

Investor · Transaction
Portfolio · Scheme

03 / INTELLIGENCE LAYER

Trusted data.
Actionable insight.

  • Operational data
  • Market & fund data
  • Analytical warehouse
03 / PORTFOLIO & DATA PLATFORM

TRANSACTIONS BECOME TRUSTED PORTFOLIOS.

The portfolio engine joined transaction history, scheme masters and current NAV data to derive holdings, valuations, costs, returns and allocation views for investors and advisors.

TRANSACTION HISTORY · SCHEME MASTER · NAV↓ CLASSIFY · CALCULATE UNITS · VALUE↓ PORTFOLIO · RETURNS · ALLOCATION
ENGINEERING SCALE100TB+

Financial, transaction and analytical data workloads.

UNIFIED VIEW360°

Investor relationships across identities, folios and portfolios.

PROCESSING MODELETL / ELT

Partitioned, incremental and reconciliation-aware pipelines.

04 / ROBO-ADVISORY

FROM PORTFOLIO REPORTING TO PERSONALIZED GUIDANCE.

INVESTORProfile · risk tolerance · horizon
+
GOALSTarget · timeline · required investment
+
PORTFOLIOHoldings · returns · allocation gaps
→
ADVISORYSuitable universe · strategy · action
Risk profilingGoal-based investingAsset allocation intelligenceScheme intelligenceAdvisor workbenchPortfolio review
BUSINESS OUTCOMES

DIGITIZE. CONSOLIDATE. TRANSACT. UNDERSTAND. ADVISE.

Digitized investor recordsUnified portfolio visibilityDigital mutual fund distributionStronger data reliabilityScalable financial analyticsFoundation for personalized advisory