Welfare Operations & FinTech Analytics

Welfare Operations & FinTech Analytics Suite

Role: Full-Stack Frontend Engineer Tech Stack: React, TypeScript, Firebase, React-Bootstrap Project Link: Internal Community Deployment

The Technical Challenge

A regional welfare society relied entirely on fragmented, manual paper tracking to collect local funds across hundreds of homes and streets. This analog workflow made it nearly impossible to audit pending monthly balances, evaluate collector performance, or project financial run-rates.

The engineering challenge was to transform this highly chaotic, paper-based operational flow into a secure, real-time digital dashboard. Because the backend relied on a NoSQL infrastructure (Firebase), the main technical hurdle was architecting a performant relational data mapping system capable of handling complex multi-tiered queries (e.g., filtering unpaid house nodes nested under specific streets for distinct billing cycles) without incurring massive database read overhead.

Key Contributions

1. Mobile-First "Native-Feel" Optimization: Engineered the interface with a strict mobile-first viewport architecture. By implementing touch-optimized interactive targets, hardware-accelerated transitions, and zero-layout-shift styling via Tailwind CSS, the platform delivers an incredibly fluid mobile experience that feels indistinguishable from a native iOS or Android application for on-the-field collectors.

2. Relational Mapping in NoSQL (Firebase): Engineered a highly optimized Firestore data schema that successfully modeled relational dependencies between Streets, Houses, and monthly collection cycles. Designed client-side query logic to dynamically fetch and isolate "payment-pending" indicators, reducing database roundtrips and ensuring instant page loads.

3. Real-Time Data Aggregation Dashboard: Built a dynamic operational command center utilizing React and TypeScript to crunch raw ledger data into high-value, real-time KPIs. The dashboard visually surfaces critical operational metrics, including Total Accumulated Funds, Progress Percentages sorted by street, and live remaining operational balances.

4. Full-Lifecycle Operational CRUD Modules: Developed type-safe, strict validation forms (using Formik/Zod) to handle sensitive administrative data entry. Enabled seamless management of community street registries, collection-worker profiles, and recurring monthly salary disbursements.

5. Automated Administrative Guardrails: Implemented proactive financial logic to track pending overhead and delayed payouts to operational workers. This system automatically flags administrative bottlenecks before they impact localized worker morale or collection schedules, shifting the society from reactive tracking to proactive planning.