PROJECT DEEP DIVE
Analytics & CRM integration
Fintech · ASP.NET Core, MySQL, SQL Server, CRM
Situation
Merchants and internal teams lacked a single view of performance, and support questions raised in digital channels needed to reliably reach CRM.
What I built
A REST API on ASP.NET Core that aggregates telemetry from MySQL and SQL Server, exposes analytics (balances, volumes, peak/slow periods, multi-month trends) to a merchant portal and mobile app, and routes in-app questions into CRM via automated case creation.
Result
Merchants gained near real-time visibility; Support teams receive structured, routed cases instead of untracked calls, with CRM and core databases remaining the source of truth.
Architecture Diagram
Architecture flow
Merchant Portal + Mobile
Analytics consumption for balances, volumes, and trends.
ASP.NET Core API
REST endpoints for telemetry aggregation and CRM routing.
Data Aggregation
MySQL + SQL Server queries for operational and trend metrics.
CRM Integration
Automated case creation for in-app support questions.
Systems of Record
CRM and core databases remain authoritative sources.
Merchant Portal + Mobile
Analytics consumption for balances, volumes, and trends.
ASP.NET Core API
REST endpoints for telemetry aggregation and CRM routing.
Data Aggregation
MySQL + SQL Server queries for operational and trend metrics.
CRM Integration
Automated case creation for in-app support questions.
Systems of Record
CRM and core databases remain authoritative sources.