DBA Management Portal

PROBLEM//

DBAs couldn't reliably monitor or control 140+ servers and 800+ TB of data.

SOLUTION//

A centralized, web-based internal management portal providing insights and control across the entire SQL Server ecosystem.

Scale · Automation · Infrastructure
  • Developed an automation engine leveraging PowerShell for reliable, cross-server communication and job execution.
  • Delivered a centralized platform giving the team more granular control and better visibility than existing third-party tooling.
  • Gained deep understanding of SQL Server architecture across Servers, Instances, Databases, and Availability Groups.

Ministry Investment App

PROBLEM//

The executive team had no efficient way to track donations, partnerships, and contributions — leading to manual errors, lack of visibility, and slow processing.

SOLUTION//

A secure, reliable internal application centralizing all financial data for the executive office.

Data Sensitivity · Security · Executive-Facing
  • Full-stack application replacing a legacy process of manual spreadsheets for tracking sensitive financial partnerships.
  • Provided the executive office with a single source of truth, automating reporting and ensuring data accuracy for critical decisions.
  • End-to-end responsibility including robust user authentication, data validation, and secure access controls.

International Import Price Index (IPI) Processing

PROBLEM//

The aging legacy system no longer fit the highly dynamic nature of processing imports, resulting in larger adjustments and corrections than necessary.

SOLUTION//

A new all-in-one platform covering the entire purchasing, verification, and classification process for increased accuracy and control.

Modernize · Collaborate · Accuracy
  • Participated in development across console, web, and API-based applications to run jobs and communicate with external systems.
  • Gained high-level understanding of the full PO process — vendor correspondence and tariff classification research.