Enterprise Client Onboarding & LMS Product Redesign
- Led end-to-end onboarding of a new enterprise client onto the Loan Management System (LMS), including redesigning platform workflows as per client-specific business and accounting requirements.
- Designed and implemented new General Ledger (GL) structure and accounting flows.
- Architected ETL pipelines for data ingestion, transformation, and system integration.
- Coordinated with Product, Engineering, Finance, and Operations teams for successful go-live.
Technologies: Python, SQL, AWS, ETL Pipelines, APIs, MySQL, Power BI
Legacy System Migration & Conversion Automation
- Owned legacy-to-LMS conversion initiative, migrating large loan portfolios from external systems to internal platform.
- Designed detailed field-level mappings between source and target systems.
- Built Python automation to process flat files, transform data, and load records into the new system via APIs.
- Developed automated post-batch validation and reconciliation reports to ensure financial accuracy after each migration cycle.
Technologies: Python, SQL, APIs, ETL, MySQL, Data Validation Frameworks, Power BI, Excel
New Financial Product Implementations (SAC, SCRA, Change Orders, Extensions)
- Led business and technical solutioning for introducing new regulatory and financial products for existing enterprise clients.
- Translated client and compliance requirements into platform workflows and accounting logic.
- Extended existing LMS capabilities to support new product behavior and financial treatment.
Technologies: Python, SQL, MySQL, Loan Management Systems
Loan Modification & Re-Amortization Engine (Admin Portal)
- Designed and implemented loan modification functionality in admin portal.
- Built complete re-amortization engine from scratch to support deferment, temporary relief, and permanent restructuring plans.
- Developed algorithms to dynamically recompute amortization schedules for mid-term loan changes while preserving financial correctness.
Technologies: Python, SQL, Financial Algorithms, Amortization Logic, MySQL
Automation, Reconciliation & Financial Controls
- Built automation for loan statements, DPD, SAC eligibility, GL and bureau reporting.
- Designed reconciliation framework integrating NACHA, payment processors, and LMS, reducing reconciliation time from ~3 hours to ~5 minutes.
- Implemented audit-grade exception reporting and financial controls, improving compliance efficiency by ~30%.
Technologies: Python, SQL, AWS Lambda, MySQL, Power BI, Excel
Client Delivery, Solution Ownership & Execution
- Acted as solution owner for multiple enterprise clients, handling new implementations, enhancements, and change requests.
- Converted business requirements into technical designs and delivery plans across Engineering, QA, and Ops teams.
- Led UAT, client walkthroughs, and post-go-live adoption across multiple releases.
