Mary Grace F. DeGuzman

LunaiWellnessApp (ASP.NET Core MVC CRUD)

Built a clinic operations web app foundation using ASP.NET Core MVC to manage fictional patient visits and appointment workflows.

Created MVC structure (Models/Views/Controllers) for clean separation of concerns
Implemented CRUD patterns for operational records (patients/appointments)
Designed for maintainable business workflows and future reporting

View GitHub Repo

Lunai Operations Dashboard (Power BI)

Designed an operational dashboard analyzing patient visits, workflow efficiency, and service trends using a structured dataset and Power BI modeling.

Created DAX measures for KPI tracking
Modeled relational dataset for analytics
Visualized visit trends and performance metrics

View Dashboard Screenshot

LunaiIntegrationHub (ASP.NET Core Web API + JSON)

Developed an ASP.NET Core Web API to standardize clinic operational data (appointments + inventory) with validated JSON inputs and Swagger documentation.

Built REST endpoints for appointments/inventory (CRUD) with validation + error handling
Documented and tested endpoints using Swagger/OpenAPI
Designed integration-ready JSON contracts for reporting workflows

View GitHub Repo

SQL Integrity + Validation Pack + Reporting Views + Runbook

Built a SQL Server operational database with data standards, integrity constraints, repeatable validation checks, Power BI-ready reporting views, and a superuser guide.

Implemented FK + CHECK constraints (status rules, non-negative inventory)
Created reporting views for trends, top diagnoses, demographics, and low-stock action list
Built a data-quality stored procedure (PASS/FAIL checks) and a superuser runbook

View SQL Documentation

Business Systems Analyst | Process Automation | Data Systems

Business Systems Analyst Portfolio

LunaiWellnessApp (ASP.NET Core MVC CRUD)

Lunai Operations Dashboard (Power BI)

LunaiIntegrationHub (ASP.NET Core Web API + JSON)

SQL Integrity + Validation Pack + Reporting Views + Runbook

Contact