NU
Nikhil UdgataTechnical Project Manager

Case Studies

Technical Project Management

The following case studies outline real-world engineering projects I have managed. Each case represents a complete lifecycle from initial problem identification and stakeholder alignment, through technical architecture selection, agile execution, risk management, and outcome validation.

B2B Digital Lending Integration & Funnel Optimization
Case Study #1FinTech & APIs

B2B Digital Lending Integration & Funnel Optimization

RoleTechnical Project Manager
TimelineOngoing (Nov 2025 – Present)
Stack
SQLGrafanaPostgreSQLREST APIsWebhooksJiraConfluence

Schematic Architecture

Partner AppFinBox APIDB Core[Integration Flowchart]

Problem

B2B fintech partners experienced high disbursement failure rates and onboarding bottlenecks in digital lending journeys. The engineering team lacked real-time visibility into transaction flows, resulting in slow incident response times and drop-offs in the lending funnel.

Approach

Designed and executed a strategy to stabilize the API transaction flow. Implemented a transaction monitoring system using Grafana and SQL to track disbursements in real-time. Created standardized API schemas and webhook config templates to streamline partner onboarding. Isolated drop-off points in the database to optimize API performance.

Key Integration Architecture

  • [1]Frontend: Embedded responsive digital lending widget for B2B client applications.
  • [2]API Gateways: Scalable REST APIs and Secure Webhook Callback handlers.
  • [3]Database & Query: PostgreSQL databases storing user workflow states and transaction records.
  • [4]Monitoring: Grafana dashboards integrated with real-time SQL queries and automated alert thresholds.
  • [5]Sandbox: Standardized testing environments for rapid partner integration and UAT.

Validated Outcome

Successfully streamlined digital lending integrations for major B2B partners. Real-time Grafana alerts enabled the team to respond to API drops instantly. Landing page optimizations and backend database query tuning successfully boosted active product adoption by 12%.

Key Project Metrics

-15%Disbursement Failure Rate
+12%FinTech Product Adoption
-20%B2B Partner Onboarding Cycle
< 5 minsIncident Detection Time
RAG-Based Business Intelligence & Release Tracker
Case Study #2Generative AI

RAG-Based Business Intelligence & Release Tracker

RoleTechnical Project Manager (AI Lead)
Timeline4 Months
Stack
PythonLangChainOpenAI APIpgvectorPostgreSQLJira APIs

Schematic Architecture

JIRAVector DBLLM[RAG Release Telemetry]

Problem

Product and engineering teams spent valuable hours manually tracking commit histories, release dependencies, and JIRA ticket updates to compile release notes. Stakeholders lacked an instant, automated way to query engineering throughput and release scopes.

Approach

Conceptualized and led the development of a Retrieval-Augmented Generation (RAG) internal business intelligence application. Built a system to parse JIRA commit logs and ticket data, run chunking algorithms on release documents, generate vector embeddings, and interface with an LLM query assistant.

Key Integration Architecture

  • [1]Data Pipeline: Node.js worker extracting commit histories and ticket fields from JIRA REST APIs.
  • [2]Embeddings: text-embedding-3-small via OpenAI API.
  • [3]Vector Database: pgvector (PostgreSQL) storing vectorized ticket metadata.
  • [4]LLM Retrieval: LangChain-based RAG pipeline retrieving context chunks.
  • [5]BI Interface: Custom internal dashboard with chatbot UI and metadata search filters.

Validated Outcome

Deployed the internal BI assistant to 25+ product managers and executive stakeholders. The system automates release log compilations, allowing managers to query current sprint statuses using natural language. Increased cross-team operational visibility while saving engineers hours of administrative reporting.

Key Project Metrics

0 HoursManual Release Report Compilation
InstantQuery Resolution Speed
99.8%Data Extraction Completeness
+40%Operational Transparency Score
AI-Powered Search & Patient CRM Modernization
Case Study #3Healthcare CRM & AI

AI-Powered Search & Patient CRM Modernization

RoleSenior Business Analyst
Timeline11 Months
Stack
LeadSquared CRMAzure OpenAILlamaIndexPythonHIPAA SecurityJira

Schematic Architecture

LeadSquaredHIPAAClinic[HIPAA Encrypted Channel]

Problem

Enterprise healthcare providers faced high customer service queues and onboarding delays. Customer service agents struggled to locate and parse dense compliance documents, policy books, and patient guidelines in a legacy CRM architecture.

Approach

Managed the end-to-end product lifecycle for a HIPAA-compliant healthcare CRM deployment. Spearheaded the integration of a RAG-based search engine that allowed representatives to query unstructured policy documents. Conducted cohort analyses and user journey mapping to drive data-driven feature improvements.

Key Integration Architecture

  • [1]Platform: HIPAA-compliant LeadSquared CRM architecture.
  • [2]Data Ingestion: Document parser converting PDFs and text files into clean structured content.
  • [3]Index & Storage: LlamaIndex processing embeddings for vector storage.
  • [4]AI Model: Azure OpenAI (GPT-4o) deployed in a private, secure cloud tenant.
  • [5]Integration: Custom CRM tab injecting the query resolution assistant into agent panels.

Validated Outcome

Delivered two major automated CRM features within an 8-month development cycle. The AI-powered search tool allowed agents to pull patient guidelines in seconds, leading to a 30% speedup in customer onboarding. Awarded 'Dashing Debut' for cross-functional alignment and delivery impact.

Key Project Metrics

-30%Customer Onboarding Time
+18%Customer Retention Rate
+15%Customer Satisfaction (CSAT)
82%Feature Adoption Rate
ML-Driven Lease Default Risk Prediction
Case Study #4Risk Analytics & Machine Learning

ML-Driven Lease Default Risk Prediction

RoleBusiness Analyst (Technical Lead)
Timeline2.5 Years
Stack
Python (Scikit-Learn)SnowflakeSQL ServerPower BIIFRS/GAAP StandardExcel

Schematic Architecture

Risk Forest[Risk Analytics Engine]

Problem

Asset finance enterprise clients faced rising default rates due to inadequate customer default scoring systems. Manual validation of auto lease applicants created processing delays, slowing down origination velocity.

Approach

Collaborated with data science teams to integrate predictive risk analytics into the credit validation pipeline. Preprocessed historical payment databases to train XGBoost and Random Forest Classifier models. Structured business intelligence dashboards to visualize customer risk profiles for underwriters.

Key Integration Architecture

  • [1]Warehouse: Snowflake repository containing historical customer records.
  • [2]Data Processing: Python ETL pipelines running data cleaning and feature engineering tasks.
  • [3]Predictive Engine: Random Forest classification model running on scikit-learn.
  • [4]Analytics Layer: Power BI dashboards visualizing credit default risk profiles.
  • [5]Automation: Automated validation rules configured directly in auto finance origination workflows.

Validated Outcome

Successfully automated auto finance origination workflows for Tier-1 multinational clients. The machine learning model successfully identified high-risk accounts prior to lease sign-offs, helping financial underwriters prevent defaults and saving millions in credit losses.

Key Project Metrics

-35%Lease Default Rates
-40%Revenue Loss Reduction
+25%Loan Processing Velocity
89.4%Risk Model Accuracy