Skip to content
View jamesmnguyen704's full-sized avatar

Block or report jamesmnguyen704

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
jamesmnguyen704/README.md

header banner

profile views followers location

typing SVG

LinkedIn Portfolio Email


About Me

I'm an accounting professional with 10+ years of experience in financial analysis, reconciliations, and process improvement across technology, manufacturing, and professional services. Known for strong data integrity, clean reporting, and building repeatable workflows that improve accuracy and efficiency.

In my current role at Day & Night Solar, I support accounting operations in QuickBooks Desktop Enterprise — bank reconciliation, AP/AR reporting, process standardization, and period-end readiness — while building the internal tooling that makes day-to-day accounting consistent for the team.

Alongside the accounting work, I recently graduated from the SavvyCoders Full Stack Web Development Bootcamp, built and deployed a full-stack capstone (Cinemetrics), and hold a Data Science Certification (TripleTen, 2024). I apply Python, SQL, and JavaScript to automate reporting, validate data, and streamline workflows.

  • 10+ years in finance · 170+ projects managed · 15 U.S. states
  • Background: Accounting → Data Science → Full-Stack Dev
  • Open to collaboration on finance automation, data migration, and AI-integrated back-office tooling

What I'm Currently Doing

Building

Internal operations platform at Day & Night Solar — finance system, QuickBooks automation, reconciliation engine, document intelligence, AI-integrated workflows.

Shipping

Cinemetrics — full-stack capstone (Node.js · Express · MongoDB · REST APIs), deployed end-to-end as my SavvyCoders certification project.

Exploring

Multi-agent orchestration · local LLMs (Ollama) · document forensics · Postgres migration · reproducible finance pipelines.


Current Work — Day & Night Solar

Rebuilding internal operations from the ground up across a commercial solar portfolio — 170+ projects, 15 states. Everything I ship replaces a spreadsheet, a folder full of PDFs, or a manual QuickBooks workflow.


Finance Platform

Python/FastAPI + SQLAlchemy service layer designed for Postgres migration. Replaces a spreadsheet-centric close process with a query-able operational database.

QuickBooks Automation

Programmatic IIF generation for customers, POs, invoices, and deposits with anti-duplicate safety checks against tens of thousands of historical transactions. Eliminated 90%+ of manual QB entry.

Bank Reconciliation Engine

Progressive fuzzy-match engine across 5 bank accounts in a high-volume, multi-account environment. Surfaces discrepancies before month-end, not after. Tier-priority confidence scoring with review queues for ambiguous matches.

Executive Dashboards

pandas + openpyxl pipeline covering P&L, cash flow, billing, margin, and schedule. Auto-regenerates — CFO reads the same data leadership does. HTML operations hubs with collapsible sections and clickable file links.

AI Orchestration Layer

Multi-agent framework on Claude Code — reusable skill definitions, three-stage code-quality pipeline (implement → review → resolve), tiered model routing across cloud + local LLMs.

Document Intelligence

OCR + classification + auto-routing for hundreds of incoming vendor docs, bank statements, and internal cost models. Outlook .msg / .eml forensics pipeline builds defensive timelines for dispute preparation.

Operational scope: Payroll · multi-state sales tax compliance · period close · vendor/customer master data · AR/AP · audit response


Career Journey

From high-volume reconciliation at enterprise scale to building the systems that replace it.


Day & Night Solar

Finance & Operations Analyst
Oct 2025 – Present · Collinsville, IL

Building the internal operations platform end-to-end — Python/FastAPI, QuickBooks automation, bank reconciliation engine, executive dashboards, AI orchestration, document intelligence.

Keeley Companies

Data Analyst (Contract)
Mar 2025 – May 2025 · St. Louis, MO

ERP data migration: SAGE CRE 300 → CMiC. Extracted, validated, and reconciled large datasets using SQL, VSCode, and advanced Excel (XLOOKUP, INDEXMATCH, IFERRORS). Detailed discrepancy reporting to the ETL team.

Curtiss-Wright

Staff Accountant
Nov 2022 – Aug 2023 · Charlotte, NC

Financial reporting, reconciliations, budgeting/forecasting on SAP + Oracle. Automated data reconciliation processes to reduce manual errors. Sage FAS fixed-asset management.

Robert Half

Professional Consultant
Oct 2021 – Jul 2022 · Charlotte, NC

Financial analysis and reconciliation support across clients including Elgi, Essity, and Mood Media. Exploratory analysis to surface inconsistencies; Excel automation for reconciliation.

NTT

Reconciliation Analyst
May 2019 – Sep 2021 · Charlotte, NC

Sales tax rebates and vendor reconciliations for enterprise tech clients including Cisco and Dell. High-volume invoice processing on SAP ERP and Oracle; resolved unmatched discrepancies in holding accounts.

Wells Fargo

Trading Service Rep
Jan – Mar 2019 · Charlotte, NC

Sponsorship program — studied for SIE, Series 7, and Series 63 licensing. AML, fraud, and regulatory fundamentals.

Walmart eCommerce (Hayneedle)

Accounts Payable Associate
May 2018 – Jan 2019 · Charlotte, NC

Processed and reconciled invoices for 800+ vendors on Oracle, Medius, and Readsoft. Sales tax adjustments, debit memos, vendor credits. Built and led training programs for specialist roles.

Top Nails Tech

Founder / Business Owner
Aug 2005 – Apr 2018 · Morganton, NC

Founded and operated a service business generating $200K+ annual revenue. Full P&L, payroll, AP/AR, lease negotiations, state compliance. Led a team of six. 10–12% YoY revenue growth through multi-platform digital marketing.

The Through-line

Every role has been about reconciling high-volume financial data across messy source systems. First as a business owner running my own P&L, then inside enterprise ERPs, then modeling the data with ML. Now I build the systems that replace the manual work — with a CPA-grade mindset for controls, audit trails, and safety.


Tech Stack

Languages

Python SQL JavaScript HTML5 CSS3 Bash

Full-Stack Web

Node.js Express MongoDB Mongoose REST APIs

Backend & Data

FastAPI SQLAlchemy Pydantic PostgreSQL SQLite DuckDB Pandas NumPy

ML & AI

PyTorch TensorFlow scikit-learn Anthropic Ollama

Enterprise Systems (from prior roles)

QuickBooks SAP Oracle Sage Excel

Tools & Infrastructure

Git GitHub VS Code Docker Linux

Full integration & library list
Category Stack
Backend Python 3.14 · SQLAlchemy · FastAPI · Pydantic · Alembic · PostgreSQL 16 · SQLite · DuckDB
Full-Stack Web Node.js · Express · MongoDB · Mongoose · REST APIs · HTML · CSS · JavaScript
Data & Docs pandas · NumPy · openpyxl · pdfplumber · PyPDF2 · extract-msg · EasyOCR · pytesseract · BeautifulSoup
Integrations QuickBooks Enterprise (IIF) · Microsoft Graph / Outlook (pywin32 COM) · ICS calendar · Chrome DevTools MCP
AI / ML Claude Code · Anthropic API · Ollama (llama3.1) · PyTorch · TensorFlow · XGBoost · LightGBM · scikit-learn
Enterprise (prior roles) SAP ERP · Oracle · Sage FAS · Medius · Readsoft · CMiC · SAGE CRE 300
Dev Tooling Git · VS Code · pytest · black · flake8 · mypy · pre-commit · uv · Node.js

Certifications & Education

Credential Institution Year
Full Stack Web Development Certificate SavvyCoders 2025
Data Science Certification TripleTen 2024
BA in Accounting Belmont Abbey College 2012

Featured Project — Cinemetrics

Full-stack capstone built and deployed end-to-end as my SavvyCoders graduation project.

JavaScript Node.js Express MongoDB Mongoose

View data science portfolio (TripleTen — 16 projects)

EDA & Statistical Analysis

# Project Tech
01 Music preferences between two cities Python, pandas
02 Credit scoring — loan default likelihood Python, pandas
03 Vehicle price factors from classified ads pandas, numpy, matplotlib
04 Telecom plan profitability analysis pandas, numpy, scipy
05 Video game market hypothesis testing pandas, numpy, scipy
06 Taxi trip duration vs. weather pandas, numpy, scipy

Classical ML

# Project Tech
07 Cell phone plan classification (0.75+ accuracy) sklearn · Decision Tree, Random Forest, Logistic Regression
08 Bank client churn prediction (F1 ≥ 0.59) sklearn · Random Forest, Logistic Regression
09 Oil well location — reserve volume & regional risk sklearn · Linear Regression, Random Forest
10 Gold production process modeling sklearn · Linear Regression, Random Forest
11 Insurance benefit prediction with data privacy sklearn · K-Nearest Neighbors
12 Car price prediction (speed + quality tradeoff) sklearn · CatBoost, LightGBM, XGBoost
13 Taxi orders time-series forecasting (RMSE ≤ 48) statsmodels · LGBM, Linear Regression

NLP

# Project Tech
14 Movie review sentiment classification nltk · transformers · spaCy · LGBM

Deep Learning & Computer Vision

# Project Tech
15 Age estimation from facial photos — regression CNN TensorFlow/Keras · CNN · GlobalAveragePooling2D
16 Customer retention prediction (AUC-ROC ≥ 0.75) TensorFlow · CNN · sklearn ensemble

GitHub Stats

activity graph

Trophies

trophies


Let's Connect

Open to work — Data Analyst, Junior Software Engineer, or Finance/Operations roles where accounting, data, and code intersect.

Pinned Loading

  1. TripleTenProgram TripleTenProgram Public

    Jupyter Notebook

  2. CapstoneSavvyCoders CapstoneSavvyCoders Public

    Cinemetrics

    JavaScript 1

  3. Homework Homework Public

    JavaScript 1

  4. GUMP GUMP Public

    Astro 1