Analyze
Data analysis
Querying, cleaning and testing data to answer real business questions.
Dylan Nguyen
I turn data into decisions.
Welcome to my portfolio, and thanks for stopping by.
Tools I use
Python- SQL
- Power BI
Tableau
Excel- Pandas
- Scikit-Learn
- Google Analytics
React- TypeScript
- FastAPI
Git
About
Learn about me.
I'm a data analyst who likes turning messy data into clear answers. I earned my B.A. in Business Analytics at Cal State Fullerton, built a foundation in computer science along the way, and I'm now pursuing an M.S. in Analytics at Georgia Tech.
I've worked in broker-dealer operations and banking security analytics, and I build my own products, like Pokernow.ai, a real-time poker analytics platform serving 1,000+ concurrent users. Now I'm looking for roles where I can bring that skill set to analytics, BI and AI.
Beyond the technical side, I bring strong analytical thinking, data-driven decision-making, and clear communication to every team I work with. I do my best work in open, cross-functional environments where I'm always learning from the people around me.
On a more personal note, I was born in Seattle, WA and grew up in Irvine, CA. My hobbies include tennis/pickleball, surfing, cinema and traveling.
1,000+concurrent users on Pokernow.ai
11projects and case studies
5AI-powered projects
Skills
My skills & tools.
Tap any tool to see where and how I’ve used it.
AI
AI & machine learning
Building with LLMs, predictive models and computer vision, from coursework to shipped products.
Visualize
BI & dashboards
Turning numbers into dashboards, KPIs and stories that people act on.
Analyze
Python
My default for anything data: cleaning and modeling in notebooks, scrapers, and production backends.
Where I’ve used it
- 2026Pokernow.aiEarly Flask and pandas service for parsing hand logs, later replaced by the Node parser.
- UC RiversideStarbucks analysisEDA and customer segmentation on 10,000+ records in JupyterLab.
- Side projectLinkedIn automationSelenium and BeautifulSoup pipeline that scrapes, cleans and analyzes connection data.
- Side projectReal-estate price predictorHousing-price model trained on listings from an automated scraper.
Analyze
SQL
Joins, CTEs and window functions for recurring reports and for tracking stats over time.
Where I’ve used it
- 2026UnusualSQLite store of WSB mentions, price snapshots and scored analyst calls, written in one transaction per scrape cycle.
- 2022–23Farmers & Merchants BankAutomated SQL reports on vulnerability trends and compliance metrics across 500+ tracked assets.
- 2026PokerNow GPT agentSQLite store of every opponent’s VPIP and PFR across sessions, used for exploitative adjustments.
- Cal State FullertonDatabase ManagementRelational modeling and query design coursework.
Analyze
Excel & VBA
Pivot tables, lookups and VBA for quick models, reconciliations and forecasts.
Where I’ve used it
- Cal State FullertonBusiness Analytics II & ForecastingForecasting models and pivot-table analysis built in Excel.
- 2022–23Farmers & Merchants BankReporting templates that summarized 50+ monthly Nessus scans.
Analyze
Pandas
Where messy data gets cleaned, joined and reshaped before any chart or model.
Where I’ve used it
- UC RiversideStarbucks analysisCleaned and merged customer, offer and transaction data to segment purchasing behavior.
- Side projectLinkedIn automationCleaned and scored scraped connection data.
Analyze
Statistics
Hypothesis tests, regression and classification, and the KPIs built on top of them.
Where I’ve used it
- 2026UnusualWilson 95% lower bound to rank analysts and z-scores to flag chatter spikes.
- UC RiversideStarbucks analysisChi-squared tests, K-NN and regression; classifiers at 85% accuracy.
- 2026Pokernow.aiPer-player stats (VPIP, PFR, 3-bet) and performance models across 1,000+ concurrent users.
Analyze
A/B testing
Comparing groups and variants to see what actually moves a metric.
Where I’ve used it
- UC RiversideStarbucks analysisCompared how customer groups responded to different offer types.
- 2023–25DigitalChief client sitesMeasured page changes against acquisition and conversion funnels.
AI
LLM APIs
Wiring OpenAI, Gemini and local models into products, with streaming answers and the option to switch providers.
Where I’ve used it
- 2026UnusualClaude Haiku picks which ticker a Reddit post is betting on, limited to candidates a regex pass already found.
- 2026Pokernow.aiAI scouting reports that turn each player's stats into a written read on style and leaks.
- 2023ClarityGPTOne workspace for five generative tools: chat, image, video, music and code.
AI
Prompt design
Getting reliable output by giving the model the right context and structure, not just a longer prompt.
Where I’ve used it
- 2026Pokernow.aiPrompts carry each player’s stats plus Hold’em or Omaha norms and return JSON-schema output.
- 2023ClarityGPTPrompt chaining for more consistent, accurate output across tools.
AI
Predictive modeling
Regression, classification, clustering and forecasting to answer business questions with data.
Where I’ve used it
- Spring 2026Business forecasting (CSUF ISDS 477)Time-series forecasting models and forecast cycles in Forecast Pro.
- Fall 2025Data mining (CSUF ISDS 474)Group project on a gaming-and-wellbeing dataset: stepwise multiple regression, regression trees, logistic regression, PCA and cluster analysis.
- UC RiversideStarbucks analysisCustomer segmentation and K-NN classification on 10,000+ records.
AI
Scikit-Learn
Classic machine learning, from a quick baseline to a tuned model.
Where I’ve used it
- UC RiversideStarbucks analysisK-NN and regression classifiers at 85% accuracy.
- Side projectReal-estate price predictorRegression model that predicts housing prices.
- Side projectAI plagiarism scannerML similarity checks on source code and web material.
AI
Computer vision
Detecting and tracking people and objects in images and video, then making models fast enough for a phone.
Where I’ve used it
- 2026Surf Filmer AIYOLO surfer detection on lineup footage, detector benchmarks and Core ML export for an auto-filming iPhone app.
- 2026AceCoachPose estimation on recorded tennis and pickleball swings to measure angles and give feedback.
- Side projectTrue-Upscaling Image EnhancerReal-ESRGAN upscaling for photos and illustrations in a Tauri desktop app.
AI
Local models
Running models on the user's own machine for privacy and speed, with no audio or video uploaded.
Where I’ve used it
- 2026AceCoachTensorFlow Lite pose model running on the phone through the camera.
- 2026Surf Filmer AICore ML detector designed to run on an iPhone on a tripod.
Visualize
Power BI
Dashboards and KPI reports for people who need the answer at a glance.
Where I’ve used it
- 2022–23Farmers & Merchants BankExecutive dashboards from 50+ monthly Nessus scans for risk-posture visibility.
- Cal State FullertonData Mining & BI courseworkDashboards on course datasets for business questions.
Visualize
Tableau
Interactive views for exploring a dataset and telling its story.
Where I’ve used it
- Cal State FullertonBusiness Analytics courseworkInteractive dashboards and data-storytelling assignments.
Visualize
Google Analytics
GA4 events, funnels and content groups to see how people really use a site.
Where I’ve used it
- 2026This portfolioGA4 with 15+ custom events: résumé downloads, case-study read depth, form starts and leads.
- 2023–25DigitalChief client sitesDashboards tracking acquisition, engagement and conversion funnels for 5+ small businesses.
- 2023HighlanderNowEngagement tracking for 350+ monthly active students.
Visualize
Matplotlib
Fast, precise plots while exploring data in a notebook.
Where I’ve used it
- UC RiversideStarbucks analysisDistribution and trend plots during exploratory analysis.
Visualize
Seaborn
Statistical charts that make group differences obvious.
Where I’ve used it
- UC RiversideStarbucks analysisVisualized customer segments and model results.
Visualize
KPI design
Choosing the few numbers that say whether something works, then putting them where people look.
Where I’ve used it
- 2026Pokernow.aiKPI framework for win rate, profitability and player tendencies across 1,000+ concurrent users.
- 2023HighlanderNowMonthly active users, session duration and feature adoption.
- 2023ClarityGPTEngagement, feature adoption and conversion metrics.
Experience
My professional experience.
DirectPath FinancialFinancial Advisor Intern2026Sovran Advisors · Cetera Wealth Services · Costa Mesa, CA
- Administered daily operations across AdviceWorks, NetX360, Docupace and Pinpoint Compliance within a FINRA/SEC-regulated broker-dealer, after earning the Cetera Admin Academy certification.
- Audited and reconciled correspondence, check and gift logs, validating record integrity against SEC retention and client-data privacy requirements.
- Structured and monitored account-opening and onboarding documentation pipelines end to end, increasing status visibility across advisors and the back office.
- Resolved documentation exceptions through recurring log reviews, reducing rework and preempting downstream compliance findings.
DigitalChief SolutionsFreelance Web Developer2023 – 2025Irvine, CA
- Architected and delivered 5+ web applications for small-business clients, embedding analytics dashboards that track acquisition, engagement and conversion funnels.
- Engineered scalable front ends in React, TypeScript and Next.js, partnering with stakeholders on requirements, data modeling and performance tuning that cut page load times by 35%.
- Optimized RESTful APIs, reducing data-retrieval latency by 20% and strengthening backend throughput.
- Instituted systematic cross-browser and mobile QA, ensuring consistent, responsive experiences across devices.
Farmers & Merchants BankInformation Security Analyst Intern2022 – 2023Long Beach, CA
- Administered security databases tracking 500+ assets and automated SQL reporting on vulnerability trends and compliance metrics, enabling leadership to prioritize remediation.
- Analyzed 10,000+ log entries weekly in Sumo Logic SIEM to surface threat patterns and anomalies, reducing mean time to detection.
- Translated 50+ monthly Nessus scans into executive dashboards and reporting templates, sharpening visibility into the bank’s risk posture.
- Conducted internal vulnerability scans, supported penetration testing, and maintained network diagrams and security documentation for audit readiness.
UberDelivery Service Driver2019 – 2020
- Cut average delivery time by 15% through GPS- and traffic-informed route optimization while sustaining a 4.9/5 customer rating.
Woodly Co. USAPrivate-label Ecommerce2017 – 2019
- Launched and scaled a private-label e-commerce brand to $10,000 in revenue with nationwide distribution through Amazon Prime.
- Negotiated with international suppliers and streamlined fulfillment logistics within Amazon’s distribution network.
- Owned brand identity, product listings and PPC advertising campaigns end to end.
Lakeview Senior CenterInformation Technology Tutor2017 – 2019
- Diagnosed and resolved software, hardware and connectivity issues, strengthening members’ digital literacy and confidence.
- Designed tailored one-on-one instruction and training materials that accelerated members’ adoption of everyday technology.
- Led group workshops on computer fundamentals, internet safety and social media.
Tyvak Nano-Satellite SystemsStudent Engineer Intern2017 – 2018CubeSat program
- Member of the first high school team to design, build and launch a nano-satellite into orbit, a mission covered by the LA Times, NBC News and ABC7.
- Led camera module integration with Tyvak’s nano-satellite systems.
- Contributed to the mission’s technical specifications and legal documentation.
Certifications
Sumo LogicSumo Logic FundamentalsEarned while analyzing SIEM logs at Farmers & Merchants Bank
Cetera Financial GroupCetera Admin AcademyEarned for broker-dealer operations at DirectPath Financial
Work
My projects & collaborations.
Web app · Markets analytics
Unusual
A markets dashboard that scores r/wallstreetbets analysts against real prices, beside an options-flow tape and a WSB sentiment radar.
Web app · AI poker analytics
Pokernow.ai
Free AI poker intelligence for PokerNow home games: player stats, a hand replayer, AI scouting reports and ledger settle-ups.
Data science study
Starbucks Customer Behavior Analysis
Exploratory analysis, chi-squared tests, K-NN and regression on Starbucks customer data to find purchasing patterns and segments.
Data analysis study
Santa Barbara Home Price Analysis
Scraped 750 Santa Barbara home sales from Trulia, turned listing text into features and set up price models in Python.
AI sports app
Court Evolution Stroke Analyzer
A phone app that scores tennis and pickleball strokes: MediaPipe measures the body, Claude Vision coaches, and simple rules fill in offline.
AI SaaS
ClarityGPT
An AI SaaS workspace with five generative tools, prompt chaining, authentication and Stripe subscriptions.
Progressive web app
HighlanderNow
A campus utility platform for UC Riverside students: interactive map, live parking, class schedules and offline support.
Web studio · Founder
DigitalChief Studio
My one-person studio in Irvine: fixed-price websites and products for founders and local businesses, most live in about two weeks.
AI web app
AI Resume Analyzer
Upload a resume and a job post, get an ATS score and section-by-section tips from Claude.
Python automation
LinkedIn Application Automation
A Selenium pipeline that discovers, filters and ranks job postings before handling multi-step application forms.
Club website
Startup@UCR Website
A full-stack website for UC Riverside’s startup club with events, member profiles and founder resources.
Writing
Featured writing.
Contact
Let’s connect.
If you’re interested in collaborating or have opportunities, I’m always open to connecting and exploring new ideas.
hello@dylanhnguyen.com