P.CHARANDrawing set · 2026Résumé
Application Developer II · HNTBFull stack · Data engineering39.0997° N, 94.5786° WKansas City

PrudhviCharan

I build .NET and Python applications and the SQL Server and Databricks pipelines underneath them. Right now, at HNTB, that means auditing job-number data across five production databases.

See the work Résumé PDF

Profile

General arrangement · read before the details

Most of my work happens below the interface: the schemas, migrations, pipelines and services that decide whether the numbers on a screen can be trusted.

General notes

  1. 01Application Developer II at HNTBKansas City, Missouri · On-site · since July 2026
  2. 02Data engineering on Databricks and Medallion Architecture, with Azure Synapse in scopeCurrent focus
  3. 03Senior Full Stack Engineer, AkdeneMarch 2025 – June 2026
  4. 04Software Engineer to Senior Software Engineer, VitranaDecember 2019 – December 2022
  5. 05M.S. Computer Science, University of Missouri–Kansas CityGPA 3.8 / 4.0 · January 2023 – May 2024

Drawing notes · Why this site is a drawing set

Before anything gets built at an engineering firm, it gets drawn.

I work at HNTB, where bridges, highways and transit systems start as sets of drawings: numbered sheets, checked, marked up in red and stamped before anything is built. My part of that world sits a layer down, in the data. Schemas, pipelines and stored procedures have to be designed just as carefully before they run.

So this portfolio is built the same way, printed in cyanotype blue, the original blueprint. Each section is a sheet. The schematics show how each project is wired, not just how it looks. And the stamp at the end is yours to give.

Sheet
One part of the story, numbered A-01 to A-06
Red markup
Where a decision was made, or a result landed
Schematic
How a system is wired. Press Run to watch it work
Stamp
Approval. You’ll find it on the last sheet

Work

Four things I designed and shipped. Open one to see how the system fits together.

AI-Powered Job Application Tracker

Problem
Tracking job applications manually across email requires repeated review and categorization.
What I built
Designed a full-stack Gmail integration with tiered classification: rules, subject-level AI, then a full-body model fallback. Built Databricks ingestion workflows and asynchronous routing with Azure Service Bus.
Outcome
500+ active users; 90%+ classification accuracy across eight job-signal categories; 75% less manual tracking effort.
  • Python
  • C#/.NET
  • React / TypeScript
  • Gmail API
  • OpenAI API
  • T-SQL/SQL
  • Databricks
  • Azure Service Bus
  • Docker
Open live Source
Detail 01 · System schematicprudhvicharan.github.io
  1. Gmail API
  2. Rules
  3. Subject-level AI
  4. Full-body model
  5. Azure Service Bus
  6. Tracker

Press Run to send an application email through the system.

  1. 01Gmail APIread-only inbox
  2. 02Rulescheap, exact matches
  3. 03Subject-level AImost messages stop here
  4. 04Full-body modelfallback for the hard ones
  5. 05Azure Service Busasync routing
  6. 06Tracker8 job-signal categories

College Application Management Platform

Problem
Students need searchable institution data and a structured way to manage college applications.
What I built
Developed a full-stack platform with external REST API integrations, filtering, pagination, Redis caching, and Python normalization and import scripts. Built a Node.js/Express backend with T-SQL/SQL schema-driven modeling.
Outcome
1,200+ students and data for 5,000+ US colleges; backend supporting 500+ concurrent users at 99.5% uptime; 85% test coverage.
  • Python
  • Angular
  • TypeScript
  • Node.js / Express
  • T-SQL/SQL
  • MongoDB
  • Redis
  • Azure Pipelines
Open live Source
Detail 02 · System schematiclaunchmasters-prod.vercel.app
  1. External REST APIs
  2. Python import
  3. SQL schema
  4. Node / Express API
  5. Redis cache
  6. Angular app

Press Run to send one college record through the system.

  1. 01External REST APIsinstitution data
  2. 02Python importnormalize + load
  3. 03SQL schemaschema-driven model
  4. 04Node / Express APIfiltering, pagination
  5. 05Redis cachehot queries
  6. 06Angular appsearch, deadlines

GitHub Profile README Builder

Problem
A GitHub profile README is the first thing many reviewers see, and turning scattered public repositories into a clear story takes hours of hand-written Markdown.
What I built
Built a client-only builder that imports a public GitHub profile, lets the user pick up to eight repositories, drafts the story by hand or with optional Gemini, and composes it in three directions (Editorial, Studio, Aurora) before exporting sanitized Markdown.
Outcome
Live at gitfolio.prudhvicharan.com. No account or server needed; API keys are never stored, and tests cover README generation, security, storage and navigation.
  • React
  • TypeScript
  • Vite
  • GitHub REST API
  • Gemini API
  • react-markdown
  • rehype-sanitize
  • Vercel
Open live Source
Detail 03 · System schematicgitfolio.prudhvicharan.com
  1. GitHub public API
  2. Pick repositories
  3. Write or draft
  4. Compose
  5. Sanitized preview
  6. README.md

Press Run to send a GitHub profile through the system.

  1. 01GitHub public APIno login
  2. 02Pick repositoriesup to eight
  3. 03Write or draftGemini is optional
  4. 04ComposeEditorial · Studio · Aurora
  5. 05Sanitized previewrehype-sanitize
  6. 06README.mdcopy or download

VS Code Theme Collection

Problem
Most editor themes are built for a screenshot, not for reading code for eight hours straight.
What I built
Designed and published eight VS Code color themes, four houses in dark and light, with house colors kept to the window chrome and syntax colors tuned for long, readable sessions.
Outcome
Published on the Visual Studio Code Marketplace as prudhvicharan.four-founders, with paired dark and light themes that can follow the system appearance.
  • VS Code Theme API
  • JSON color tokens
  • Semantic highlighting
  • JavaScript
Open on Marketplace Source
Detail 04 · System schematicVS Code Marketplace
  1. Four houses
  2. Dark + light
  3. Workbench colors
  4. Syntax tokens
  5. Marketplace

Press Run to send one theme through the system.

  1. 01Four housesGodric · Salazar · Rowena · Helga
  2. 02Dark + lighteight themes
  3. 03Workbench colorshouse banners on the chrome
  4. 04Syntax tokenstuned for long sessions
  5. 05Marketplaceprudhvicharan.four-founders

Experience

Dimension lines show time on the job. Red is industry, ink is study.

HNTB

Application Developer II

July 2026 – Present
Kansas City, Missouri · On-site · Full-time

  • Data engineering on HNTB’s Databricks/Medallion Architecture stack, with Azure Synapse in scope.
  • Leading investigation and implementation on a database-wide job-number reclamation initiative spanning five production SQL Server databases: full column-level data auditing (6,000+ columns per database), cross-database join verification against master tables, and design of a table-driven stored procedure for safe number reuse.
  • Collaborating with technical leads and business stakeholders to scope implementation approach, including stored procedure redesign in a Git-based development workflow.

Akdene

Senior Full Stack Engineer

March 2025 – June 2026
Remote

  • Developed .NET Core/C#, Python, TypeScript, and Node.js applications supporting 50,000+ users across healthcare and recruitment domains with 99.9% uptime.
  • Designed T-SQL data models across 15+ distributed services and authored rollback-safe migrations, with end-to-end test ownership and no dedicated QA team.
  • Built Azure Pipelines workflows and blue-green deployments enabling 50+ weekly production releases with automated rollback.
  • Implemented Azure Service Bus integrations and Python ML workflows in Databricks, classifying signals across eight categories at 90%+ accuracy.
  • Resolved tier 2/3 production issues, authored tests achieving 90%+ coverage, and maintained deployment documentation and QA checklists.
  • Built Prometheus, Grafana, and ELK dashboards, reducing MTTD by 60% and MTTR by 45%; mentored five junior developers.

Vitrana

Senior Software Engineer

June 2021 – December 2022
Bangalore, India

  • Led development of the HiLIT healthcare analytics platform using .NET Core/C# and SQL Server, with queries, indexing, migrations, and reporting views across 5M+ adverse event records serving 2,000+ B2B users globally.
  • Built 20+ RESTful microservice APIs with ASP.NET Core and integrated Azure Service Bus for event-driven messaging.
  • Developed Python scripts for ingestion, transformation, and reporting; collaborated with data teams on ML integration and feature engineering.
  • Executed rollback-safe T-SQL/SQL schema migrations across distributed SQL Server services for zero-downtime deployments.
  • Achieved 95% unit and integration test coverage as sole QA owner; authored test suites and deployment documentation, reducing production defects by 40%.
  • Optimized AWS and Azure infrastructure with auto-scaling, reducing costs 35% while maintaining 99.9% application availability.

Vitrana

Software Engineer

December 2019 – May 2021
Bangalore, India

  • Developed Angular enterprise dashboards with 60+ screens, supporting navigation of 100K+ medical terminology records for pharmaceutical and regulatory clients.
  • Redesigned the MedDRA Dictionary application: improved search performance by 60% and reduced data load time by 50% through T-SQL optimization, server-side pagination, and refactoring an approximately 80K-line legacy JavaScript codebase.
  • Replaced legacy GitLab pipelines with Azure Pipelines and automated testing and SonarQube quality gates, increasing test coverage from 60% to 90% and reducing production bugs by 35%.
  • Wrote Python reporting and batch-processing scripts, reducing manual data preparation effort by 40%.
  • Built 30+ reusable Angular component libraries with Angular Material and SCSS, reducing development time by 35% across enterprise applications.

UMKC

Master of Science in Computer Science

January 2023 – May 2024
Kansas City, MO · GPA 3.8 / 4.0

  • Coursework: Advanced Algorithms, Distributed Systems, Cloud Computing, Machine Learning, Database Systems

VIT

Bachelor of Technology in Software Engineering

June 2016 – June 2021
Tamil Nadu, India · GPA 8.67 / 10

  • Vellore Institute of Technology

Materials

Bill of materials: what I build with, grouped the way I use it.

Languages & Core6 items

  • 001C# / .NET Core
  • 002T-SQL / SQL
  • 003Python
  • 004JavaScript / TypeScript
  • 005Java / Spring Boot
  • 006Node.js

Cloud & Data13 items

  • 007Azure Pipelines
  • 008Azure Service Bus
  • 009Azure Functions
  • 010Azure App Service
  • 011Logic Apps
  • 012Databricks
  • 013Medallion Architecture
  • 014SQL Server
  • 015PostgreSQL
  • 016MySQL
  • 017MongoDB
  • 018Redis
  • 019AWS

Frontend5 items

  • 020React / Redux Toolkit
  • 021Angular / RxJS / NgRx
  • 022Next.js
  • 023Tailwind CSS
  • 024Module Federation

ML & Integrations6 items

  • 025NLP classification
  • 026OpenAI GPT-4
  • 027LangChain
  • 028Kafka
  • 029RESTful APIs
  • 030GraphQL

Testing & Delivery10 items

  • 031xUnit / NUnit
  • 032JUnit
  • 033Jest
  • 034TDD / BDD
  • 035Docker / Kubernetes
  • 036Terraform
  • 037GitHub Actions
  • 038Jenkins
  • 039GitLab CI/CD
  • 040SonarQube

Operations6 items

  • 041Prometheus
  • 042Grafana
  • 043ELK Stack
  • 044Tier 2/3 support
  • 045QA / deployment documentation
  • 046Mentoring

Contact

Direct line

Request for information

Sent through EmailJS straight to my inbox. Please don’t include anything sensitive.