Oscar Odhwani

SQL Server 2025 · Python · Qwen 3.6

A locally hosted AI-powered data analytics application that allows users to query enterprise SQL Server databases using plain English instead of writing SQL. Converts natural language into SQL using a locally hosted Large Language Model (Qwen 3.6). Returns interactive tables within seconds and generates customizable charts and visualizations from query results. Runs entirely on local hardware with no cloud services or external APIs.

PHP · Privacy · Security

A secure cloud storage and file-sharing platform designed with a strong focus on privacy, access control, and security. Upload, organize, and securely store files through a web-based interface. Share files privately with registered users or generate secure public download links. Supports password-protected links, download limits, and expiration dates.

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

A web application designed to simplify data reconciliation between CSV, Excel, and SQL databases. Automatically maps matching columns while allowing users to customize mappings, identifies missing, changed, and mismatched records, and generates easy-to-review difference reports for data validation and reconciliation.

C# · Windows API · System Tray

A Windows productivity application that reduces repetitive typing and copy-and-paste work through keyboard-driven text shortcuts. Stores frequently used text snippets for quick access, uses keyboard shortcuts for fast copying without interrupting workflow, and automatically saves user content and runs from the Windows system tray.

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.