Public repo
DA-01
SQL query portfolio
Ten Superstore business queries in SQLite, from basic KPIs to a region × category matrix.
- Revenue, profit, discount effects
- Basic → advanced SQL
- Python + SQLite
Field operations · Systems · Data
Nguyen Vu Truong Phuc
IT Support · C# / .NET · Data Analysis
Hands-on support for servers, networks, databases, and virtualized environments. I also build with C# / .NET and analyze data in SQL, Power BI, and Python. I troubleshoot problems, configure systems correctly, and keep infrastructure stable and secure.
01 / Profile
A careful operator, not a ticket mill.
I provide hands-on IT support and system administration for servers, networks, databases, and virtualized environments. The work is practical: find the fault, change only what needs changing, test the result, and explain it clearly.
I like clearly defined technical problems — a server that will not boot, a VLAN that cannot talk, a database that needs a clean restore, a Docker stack that will not start, or a dataset that needs a clear answer. I take time to understand the problem before I touch production.
02 / Capabilities
What I can take on.
-
Servers
Windows and Linux server setup and troubleshooting. Ubuntu administration and remote support.
-
Virtualization
Proxmox VE, virtual machine management, snapshots, and hardware-level troubleshooting.
-
Network
MikroTik routers, managed switches, VLAN, DHCP, NAT, firewall, routing, DNS, and segmentation.
-
Remote access
SSH and Tailscale administration. Connectivity and remote access troubleshooting.
-
Data
MySQL / SQL setup, users, backups, restores, and day-to-day troubleshooting.
-
Web delivery
Nginx, domains, SSL/TLS, Docker Compose, plus Git and GitHub deployment workflows.
-
C# / .NET
ASP.NET Core APIs, configuration, health checks, and deploying .NET apps behind a reverse proxy.
-
Data analysis
SQL queries, Power BI dashboards, and Python EDA — sales KPIs, trends, and clear findings.
03 / Work samples
Public repos and a .NET deploy.
These are my own projects. They are not Upwork client jobs.
Public repo
DA-02
Power BI sales dashboard
Interactive Superstore dashboard: revenue, orders, profit, yearly growth, category and region.
- $2.30M sales · 9,994 orders
- KPI cards, trend, breakdown
- Power BI Desktop
Public repo
DA-03
Python sales EDA
Exploratory analysis of Superstore: category profit, region mix, discount losses, YoY growth.
- pandas EDA
- Clear written findings
- Reproducible notebook/script
Personal
CS-01
C# / .NET API deploy
ASP.NET Core API with PostgreSQL and Redis, Docker Compose, Nginx/Traefik reverse proxy, health checks, and GitHub deploy flow.
- C# · ASP.NET Core
- Docker · HTTPS proxy
- App, database, cache split
04 / Sample labs
Practice environments, not client jobs.
These are homelab runbooks I use to keep the skills sharp. They are labeled as samples so they are never mistaken for paid work history.
Sample lab
LAB-01
Proxmox VE homelab
Stand up a Proxmox host, create Linux and Windows VMs, snapshot before changes, and test a backup restore path.
- Host install and storage layout
- VM templates and snapshots
- Backup to a second disk
Sample lab
LAB-02
MikroTik segmentation
Split a small network into VLANs with DHCP, NAT, and a firewall that only allows the paths that should exist.
- VLAN, bridge, and trunk ports
- DHCP per segment
- NAT and firewall rules
Sample lab
LAB-03
Ubuntu, Nginx, TLS
Put a service behind Nginx with a real hostname, reverse proxy, and TLS certificates that renew cleanly.
- Virtual host and proxy_pass
- Let’s Encrypt / TLS
- HTTP to HTTPS redirect
Sample lab
LAB-04
MySQL backup path
Install MySQL, lock down users, take a dump, break a table on purpose, and restore it from backup.
- Least-privilege users
- mysqldump and restore
- Basic hardening notes
05 / Skills
Skills I actually use.
Infrastructure
Build & data
Working style
06 / Approach
How a job actually proceeds.
-
Understand
Collect symptoms, recent changes, and the expected state before changing anything.
-
Change carefully
Prefer reversible steps: snapshots, backups, one change at a time.
-
Test
Confirm the original issue is gone and that related services still work.
-
Explain
Leave a clear note of what failed, what was done, and what to watch next.
07 / Contact
Send the details of the problem.
If you have an IT, server, network, Docker, C# / .NET, SQL, or Power BI issue, include what is broken, what you already tried, and any logs or screenshots.