Client Portal Development
Technology Stack:
ASP.NET MVC • C# • .NET • Azure App Service • Azure SQL Database • Azure Identity • REST APIs • HTML • CSS • JavaScript • Visual Studio
Built a secure, cloud-hosted client portal using ASP.NET MVC, C#, Azure App Service, and Azure SQL Database. Integrated external APIs to deliver real-time operational data, implemented Azure Identity authentication with user registration and login, and developed asset management, ticketing, and dashboard modules. The application provided clients with a centralized platform for monitoring operations, submitting requests, and accessing key business information.
Business Intelligence SOlutions
Technology Stack:
Power BI • Azure Functions • Azure SQL Database • SQL • ETL • REST APIs • DAX • Power Query • Data Alerts • Data Modeling • Power Query • Microsoft Fabric
Designed and developed an automated reporting platform using Azure Functions, Azure SQL Database, and Power BI. Created ETL processes that collected data from multiple APIs, transformed it into meaningful business metrics, and delivered interactive dashboards, alerts, and executive reports. These reporting solutions became some of the first advanced business intelligence tools developed specifically for the cryptocurrency mining industry.
Internal Outage Ticketing System
Technology Stack:
ASP.NET Core • C# • .NET • Azure App Service • Azure SQL Database • Entity Framework • CRUD • HTML • CSS • JavaScript • Visual Studio
Developed a custom outage management application using ASP.NET Core, C#, Azure App Service, and Azure SQL Database. Built as a full CRUD application, the system allowed employees to track, update, and resolve infrastructure outages across multiple locations. The solution provided a cost-effective alternative to third-party software while streamlining internal operations and improving client reporting.
Financial Forecasting & Profitability Analysis
Technology Stack:
Advanced Microsoft Excel • Financial Modeling • Data Analysis • Forecasting • Data Visualization • Pivot Tables • Formulas • Public APIs • Business Analytics • Power Query
Developed advanced Excel models using public Bitcoin market data, mining hardware specifications, energy costs, and hashprice projections to estimate mining profitability. Built dynamic forecasting tools that compared hardware performance, projected future revenue, and modeled profitability under multiple market scenarios, providing valuable insights for operational planning and investment decisions.
SQL Database Administration & MIGRATIONS
Technology Stack:
Microsoft SQL Server • SQL Server Management Studio (SSMS) • T-SQL • Windows Server • Database Backup & Restore • Migrations • Software Deployment • User Security • Troubleshooting
Created and configured Microsoft SQL Server databases and instances for new software deployments, including database creation, backups, restores, migrations, and user security. Managed application installations, configured environments, performed software upgrades, and validated functionality through testing. Worked with customers to ensure successful deployments while troubleshooting installation issues and supporting production environments.