# Albano Stefani

> Senior .NET / SQL Developer & Software Engineer based in Richmond, VA, USA. I build fast, reliable B2B and B2C systems — real-time ping/post engines, lead-gen platforms, APIs and the SQL that keeps them honest.

## About
20+ years as a Senior .NET/SQL Developer and Software Engineer specializing in B2B and B2C systems and applications — from the database schema to the pixel.
I design and build web applications with C#, .NET Core, Web APIs, ASP.NET (MVC & WebForms), JavaScript, TypeScript and Angular, plus real-time communication with SignalR and Firebase push messaging.
Deep SQL Server background (2000–2022): performance tuning, stored procedures, query optimization and database design, with hands-on MySQL, PostgreSQL and MongoDB.
I know customer acquisition end to end — marketing funnels, conversion optimization, landing page testing, data validation, data mining, regression analysis, predictive modeling and reporting.

## Experience
- Apr 2015 — Present: Senior Software Engineer, InterActive Financial Marketing Group (Automotive lead-generation and fintech marketing platform · Richmond, VA)
  - Build and maintain .NET Razor Pages apps, Web APIs and real-time SignalR systems.
  - Ping/post and lead-routing engines exchanging data with partners on complex bidding algorithms.
  - CRM, BDC and dealer tools; AI assistants and analytics over MCP.
  - SQL Server design, reporting and performance tuning.
- Sep 2014 — Apr 2015: Senior .NET Developer, Abbott (Richmond, VA)
- Nov 2010 — Sep 2014: .NET Developer / Systems Analyst, Dominion Enterprises (Richmond, VA)
- 2001 — 2010: Founder / President · .NET/SQL Developer, TrueLending, Inc (Self-employed · Seattle, WA)
  - Founded and ran the company (2001–2010); .NET/SQL development from 2003.

## Projects
- OverstockedCars (Consumer car marketplace · Web · Data API): Car shopping for consumers: search millions of new and used vehicles near any ZIP, see real prices against the local market, and request a quote or financing. https://overstockedcars.com [.NET 8, Razor Pages, SQL Server, ADO.NET, Bootstrap 5, Vanilla JS, Swagger, IIS]
- CountryTime (Personal product · Android · Web PWA · API): Tracks which country you're in every day — Schengen 90/180 countdown and tax-residency day counts for digital nomads and frequent travelers. https://countrytime.app [.NET 10, MAUI Blazor Hybrid, Blazor WASM, Minimal API, MySQL, SQLite, Linux]
- Auto-Finance CRM & Call-Center Workspace (Web PWA · Mobile API): A CRM for a lead-generation company's sales and call-center teams: lead queues, calling, texting, email and reporting. [.NET 8, Razor Pages, SignalR, Twilio, SQL Server, Firebase]
- Natural-Language Analytics over MCP (Data platform · AI tooling): A read-only analytics layer that AI assistants query in plain English through an MCP server. [MCP, .NET 8, Python, SQL Server, LLM]
- Conversational AI Sales Assistant (SMS agent): An SMS assistant that holds natural conversations with customers and books appointments. [.NET 8, Claude API, Prompt engineering]
- Vehicle Configurator & Rules Engine (API): A build-a-vehicle engine that only allows configurations the manufacturer can actually build. [C#, Dapper, SQL Server, REST]
- Advertised-Price Compliance Monitor (Scheduled service · Dashboard): Daily detection of vehicles priced differently on dealer sites vs. third-party marketplaces. [.NET 8, Hangfire, PuppeteerSharp, SQL Server]
- Production SQL Server Tuning (Performance engineering): Server-wide tuning of a busy multi-database SQL Server 2022. [SQL Server 2022, T-SQL, Query plans, Indexing]

## Skills
- Languages: C#, VB.NET, T-SQL, JavaScript (ES6+), TypeScript, HTML5, CSS3, PowerShell, PHP, Classic ASP
- Frameworks: .NET 10 / .NET Core, .NET Framework, ASP.NET MVC, Razor Pages, WebForms, Windows Forms, Web API, Entity Framework, SignalR, Angular, jQuery, Bootstrap
- Databases: SQL Server 2000–2022, MySQL, PostgreSQL, MongoDB
- Cloud & Infra: Azure App Services, Azure SQL & Storage, IIS, Windows Server, Linux / Apache, Networking
- Tools: Visual Studio, VS Code, SSMS, Git, TFS, SVN, Photoshop
- Analytics: Google Analytics, Adobe Omniture, Matomo
- Integrations: Twilio, SendGrid, Google APIs, Stripe, PayPal, PayTrace, QuickBooks, RightSignature, Firebase

## Education
- 2013 — 2015: Associate of Science, Information Technology & Web Development, Southern New Hampshire University
- 2001 — 2003: Associate's degree, Architectural Design / Construction Technology, Broward College

## Languages
English (Full professional), Albanian (Native / bilingual), Greek (Native / bilingual), Italian (Professional working), French (Professional working)

## Contact
- Website: https://albano.dev/
- Email: contact@albano.dev
- LinkedIn: https://www.linkedin.com/in/albanostefani