Oscar Odhwani

Python · Local LLM (Qwen 3.6) · SQL Server 2025

A locally hosted AI analytics platform enabling users to query SQL Server databases in plain English instead of writing SQL. The system dynamically converts natural language to T-SQL, executes it, and renders interactive data tables and customizable charts from the result set within seconds. Engineered for strict privacy: runs entirely on local hardware with no cloud services or external APIs, ensuring sensitive data never leaves the network.

PHP · Access Control · Web Security

A secure cloud storage and file-sharing platform designed with a strong focus on privacy and access control. Supports private sharing with registered users or password-protected public links with download limits and expiration dates. Engineered to stream files through a permission-checked download layer, preventing direct file exposure to the internet.

C# · ASP.NET · CSV / Excel / SQL

A data reconciliation tool that automates validation by comparing records across CSV files, Excel workbooks, and SQL databases. Features column auto-mapping with manual override capability, automatically identifies missing, changed, or mismatched records, and generates detailed difference reports.

C# · Windows API · System Tray

A lightweight Windows utility designed to optimize repetitive copy-and-paste workflows. Developed in C# utilizing the Windows API for global hotkeys, it runs from the system tray with automatic state persistence and a minimal footprint.

Senior Technical Consultant · New York, NY & Remote

Lead technical implementations, SQL Server performance tuning, and production support of Regnology's OneSumX regulatory reporting platform for client banks (including Mizuho, Rabobank, USAA, Ford Motor Credit, and Toyota Credit). I typically manage 3–5 concurrent client implementations and production environments, performing deep root-cause analysis to resolve software defects, ETL failures, SQL Server performance issues, and data discrepancies. Built validation scripts to automate source data auditing, and co-led a proof of concept for a multi-tenant Azure cloud deployment to lower infrastructure costs.

Database Developer · Glen Allen, VA

Developed a secure ASP.NET (C#) web portal providing role-based access to SSRS reports, complete with custom credentials management. Designed SSIS packages to import daily and monthly sales data from customer FTP sources, implementing automated formatting validation, error logging, and email notification pipelines for Accounting. Developed SSRS reports used by Accounting, Marketing, and business stakeholders to analyze customer activity, advertising effectiveness, and sales conversion metrics.

Database / .NET Developer · Chester, VA (Remote part-time Oct 2013 – Feb 2015)

Administered SQL Server databases supporting the Virginia Information Technologies Agency (VITA) program, designing data collection processes that aggregated operational and capacity planning metrics for over 1,700 servers. Developed Active Directory-secured ASP.NET web applications and real-time executive dashboards to track SLA performance, contract negotiations, and incidents. Integrated diverse data sources using ODBC and Linked Servers, and built automated alert workflows for critical state agency issues.