# James zhang

> Software Engineer

Location: San Francisco, California, United States
Profile: https://flows.cv/jameszhang1

Database-focused Full-Stack Developer with 20+ years of experience studying and working with relational databases (PostgreSQL, MySQL). Skilled in ER modeling, schema design/normalization, SQL & query optimization, and database maintenance (backups, migrations, indexing, integrity). Builds data-driven applications where every feature starts with the data model. Background in accounting and e-commerce enables practical, reliable solutions for real-world operations.

## Work Experience
### Software Engineer Apprentice @ Coding Temple
Jan 2024 – Present | Remote
Software Engineer Trainee — Coding Temple (Remote) | 05/2024 – Present
•	Designed relational schemas and ER diagrams across multiple projects; applied normalization and constraints.
•	Improved performance with query optimization & indexing (EXPLAIN/ANALYZE, coverage indexes).
•	Built REST APIs on top of relational models; all app features are database-driven (auth, cart/checkout, reporting).
•	Established database maintenance: backups, migrations, seed data, and recovery tests.
•	Deployed services via Docker + AWS; ensured reliable, repeatable DB migrations.

### Administrative Assistant @ John H Wu Medical Office
Jan 2021 – Jan 2022 | California, United States
•	Introduced a document management system, improving efficiency by 20%.
•	Streamlined administrative workflows using Excel/PowerPoint.
•	Maintained patient database, ensuring accuracy, confidentiality (HIPAA-minded), and reliable record retrieval.

### E-Commerce Business Owner @ E-Commerce Business Owner
Jan 2014 – Jan 2020 | California, United States
•	Built and managed an online platform for educational material sales; achieved $400,000+ revenue.
•	Ran campaigns with Shopify & Google Ads to improve engagement.
•	Maintained customer database, tracking orders, payments, and communications to increase retention.
•	Handled bookkeeping tasks, recording sales, expenses, and reconciliations to support accurate financial reporting.


## Education
### Certificate of Competency in Computer Software Engineering
Coding Temple

### Master's Degree in Accounting and Related Services
DeVry University


## Contact & Social
- LinkedIn: https://linkedin.com/in/james-zhang-1a0936308

---
Source: https://flows.cv/jameszhang1
JSON Resume: https://flows.cv/jameszhang1/resume.json
Last updated: 2026-04-11