# Andrew Leng Ly > Andrew Leng Ly is a designer, developer and analyst in Sacramento, CA. CSU Chico MIS graduate and founder of Parabox Digital, a web design studio. Open to Parabox Digital projects and work opportunities. Site: https://www.andrewlengly.com Also known as: Andrew Ly Full text of the bio, the case studies and the Q&A: https://www.andrewlengly.com/llms-full.txt Machine-readable index: https://www.andrewlengly.com/machine The same index as plain text: https://www.andrewlengly.com/machine.txt ## Two ways in - Just browsing? See my work: https://www.andrewlengly.com/#projects - Need a website? Visit Parabox Digital: https://www.paraboxdigital.com - Building a site for your business? Book a call with Parabox Digital: https://www.paraboxdigital.com/book ## Pages - [Designer](https://designer.andrewlengly.com): Andrew Leng Ly designs websites for local businesses at Parabox Digital and writes product case studies. - [Developer](https://developer.andrewlengly.com): Andrew Leng Ly builds web apps with Next.js and Supabase. Three of his projects run on live public data. - [Analyst](https://analyst.andrewlengly.com): Andrew Leng Ly studied Management Information Systems at CSU Chico. Grid Watch, his own dataset, saves California's outage feed every 15 minutes. - [Case studies](https://www.andrewlengly.com/case-studies): How I approached the work, what I found, and what I would change. - [Data studies](https://analyst.andrewlengly.com/studies): 9 data studies by Andrew Leng Ly. Each one has a question, the data behind it, the findings and my recommendation. - [Resume](https://resume.andrewlengly.com): Andrew Leng Ly's resume. He studied Management Information Systems at CSU Chico and founded Parabox Digital. - [Blog](https://blog.andrewlengly.com): Product case studies and build notes by Andrew Leng Ly, plus whatever he is thinking through this month. - [Parabox Digital](https://www.paraboxdigital.com): Andrew's studio. It designs and builds websites for local businesses in the Sacramento area. ## Case studies - [Spotify Podcast Gestures](https://medium.com/design-bootcamp/pm-in-progress-a-simple-gesture-to-fix-spotify-podcast-flow-dfd22a45d2ef): One small gesture to keep podcast listening flowing on Spotify. - [MyFitnessPal Habit Formation](https://medium.com/@andrew.leng.ly/pm-in-progress-strategies-to-make-myfitnesspal-a-habit-that-you-can-enjoy-3f601a9c3e1a): Making food logging a habit people actually enjoy. - [DoorDash Student DashPass](https://medium.com/@andrew.leng.ly/applying-growth-strategy-to-the-doordash-campus-launcher-role-09f84c5a8dc8): A growth plan I wrote for DoorDash’s Campus Launcher role. - [Grid Watch case study](https://www.andrewlengly.com/grid-watch-casestudy): Grid Watch is a live map of California power outages set over fire weather, built because the state's outage feed shows only what is out right now. It saves a snapshot every 15 minutes and lines each outage up with the Red Flag Warnings around it. It is built with Next.js, MapLibre, deck.gl and Supabase with PostGIS, and it has been live since November 5, 2026. Open Grid Watch: https://www.andrewlengly.com/gridwatch - [Chain Routes case study](https://www.andrewlengly.com/chain-routes-casestudy): Chain Routes is a 3D terrain map of Sierra chain controls that saves every checkpoint every 10 minutes, since Caltrans publishes the current status only. Each storm between Sacramento and Tahoe can be replayed. It is built with Next.js, MapLibre, deck.gl and Supabase, and the snapshots it has stored since November 7, 2026 go public once the first build merges. Open Chain Routes: https://chains.andrewlengly.com - [Fish Maps case study](https://www.andrewlengly.com/fish-maps-casestudy): Fish Maps is a 3D map of San Francisco Bay that shows how much sea level rise turns the year's highest tide into an ordinary high tide. It ranks the highest predicted tides at 7 Bay gauges and draws NOAA's sea level rise water on the shoreline one foot at a time. It is built with Next.js, MapLibre, deck.gl and d3, and it has been live since November 6, 2026. Open Fish Maps: https://tides.andrewlengly.com - [NetTracer case study](https://www.andrewlengly.com/nettracer-casestudy): NetTracer is a network lab in the browser. It follows one packet across a 3D network a frame at a time and shows which header fields change at each hop. It is built with React, Three.js, Tailwind CSS and Vite, and its 7 guided labs and sandbox are live with the code public. Open NetTracer: https://nettracer.andrewlengly.com - [S P L I T case study](https://www.andrewlengly.com/tab-split-casestudy): S P L I T splits a restaurant bill from one scanned receipt. Friends tap what they had on a shared link, and tax and tip split to the exact cent. It is built with Next.js, Supabase and the Claude API, with Frankfurter for exchange rates, and it is live at split.andrewlengly.com. Open S P L I T: https://split.andrewlengly.com - [Campus IT Triage Agent case study](https://www.andrewlengly.com/campus-it-casestudy): Campus IT Triage Agent is a Salesforce Service Cloud backend for a help desk agent that tries a known-issue guide first and opens a Case when it is needed. A chatbot that only searches a FAQ opens duplicate tickets. This one is built as five Apex actions for an Agentforce agent, and it is public on GitHub with 29 test methods. Open Campus IT Triage Agent: https://github.com/AndrewLengLy/Campus-IT-Triage-Agent - [AlwaysUp case study](https://www.andrewlengly.com/alwaysup-casestudy): AlwaysUp is a joke portfolio viewer that mirrors a losing chart about the price you paid, so a loss is drawn as a gain of the same size. It is a parody about how a red number can ruin a morning, and it says so on every screen. It is built with React, Vite and Framer Motion, and it is public on GitHub with 77 unit tests. Open AlwaysUp: https://alwaysup-mu.vercel.app - [The case for third places case study](https://www.andrewlengly.com/third-places-casestudy): A series of seven data studies on loneliness and the places people gather, run to decide where FourthSpace launches in Sacramento. It runs survey-weighted models on federal microdata, including 540 versions of the social media link, and maps walk access to indoor venues across Sacramento County. Built with Python, pandas, statsmodels and geopandas, it recommends a launch in south Sacramento with library branches as the first venues. Open the full study: https://analyst.andrewlengly.com/studies/third-places - [Where the best hires come from case study](https://www.andrewlengly.com/sourcing-channels-casestudy): A data study of which hiring channels bring in people who perform well and stay two years, tracking 311 hires by source. It runs survival models on retention and compares performance ratings by channel. Built with Python, pandas, lifelines and DuckDB, it recommends a two-tier referral bonus and a separate channel mix for production and office roles. Open Where the best hires come from: https://www.andrewlengly.com/studies/sourcing-channels.pdf - [Skills-based hiring case study](https://www.andrewlengly.com/skills-hiring-casestudy): A data study of how many jobs ask for a degree their own workers do not hold, across 177 occupations that list a bachelor's degree. It joins BLS data to O*NET's worker surveys and builds a launch list of ten roles. Built with Python, pandas, DuckDB and Excel, it recommends skills-first job templates shipped together with built-in assessments. Open Skills-based hiring: https://www.andrewlengly.com/studies/skills-hiring.pdf - [New-hire ramp time case study](https://www.andrewlengly.com/ramp-time-casestudy): A data study of why new hires leave in their first two years and how long they take to reach full speed, modeled on 1,470 employees. It compares new-hire and settled-worker pay across California sectors and prices out a buddy program. Built with Python, pandas, statsmodels and DuckDB, it recommends a buddy for every new hire and a ramp time KPI. Open New-hire ramp time: https://www.andrewlengly.com/studies/ramp-time.pdf - [Internal mobility case study](https://www.andrewlengly.com/internal-mobility-casestudy): A data study of whether people who move inside a company stay longer, modeled on attrition and time since promotion for 1,470 employees. It compares people who changed roles with people who did not and sizes the value for a 5,000-person company. Built with Python, pandas, statsmodels and DuckDB, it recommends a two-week internal posting window and skills-profile matching. Open Internal mobility: https://www.andrewlengly.com/studies/internal-mobility.pdf ## Projects Full index: https://www.andrewlengly.com/projects. Each note below is the one on that page, in Andrew's words. Builds: - [CareerLyAI](https://career-ly-review-3i7i.vercel.app/): Reads a resume and returns an AI assessment of it. - [Grid Watch](https://www.andrewlengly.com/grid-watch-casestudy): California power outages on a live map over fire weather, saved every 15 minutes so each event keeps its history. Opens the case study. - [Chain Routes](https://www.andrewlengly.com/chain-routes-casestudy): Chain controls and closures on a 3D terrain map of the Sierra passes, Sacramento to Tahoe. Road weather sits on the same map. Each summit has a page, and there's a trip check. Opens the case study. - [NetTracer](https://www.andrewlengly.com/nettracer-casestudy): A Packet Tracer alternative in 3D. Seven labs walk ARP, switching, routing, DNS, TCP and HTTP frame by frame, then apply fixes like VLANs, HSRP and TLS. - [Fish Maps](https://www.andrewlengly.com/fish-maps-casestudy): San Francisco Bay king tides on a 3D map. NOAA's sea level rise layers show where everyday high tides reach at 1 to 10 ft. Opens the case study. - [Joaquin](https://www.linkedin.com/feed/update/urn:li:activity:7354629990384062464/): An AI agent I built and demoed on LinkedIn. - [Campus IT Triage Agent](https://www.andrewlengly.com/campus-it-casestudy): A Salesforce DX and Service Cloud app that triages campus IT requests. - DegreePath (private): A Salesforce DX and Agentforce app that stops a course registration when a missed prerequisite or a wrong elective would cost a student a year. - Trustee (private): A Salesforce Agentforce concierge for admissions and financial aid. It answers with live records on tuition, missing documents, scholarship matches and transfer credit. - [AlwaysUp](https://www.andrewlengly.com/alwaysup-casestudy): A portfolio viewer that refuses to show a loss. A losing chart is mirrored about the price you paid, so the line always climbs. - [.Pckg](https://www.andrewlengly.com/pckg): A 3D packaging studio. Draw a box or your own dieline and watch it fold, then print the flat net at real size to build a paper model. - [Trace Studio](https://www.andrewlengly.com/trace-studio): A vector studio for logo work. Trace a photo with guides and the pen, or pour a word into a silhouette, then export the SVG or a replay of the build. - [Sticker & Stamp Lab](https://www.andrewlengly.com/sticker-stamp-lab): Make tilt-responsive holographic stickers and vintage postage stamps from your own images. - [Storyboard Lab](https://www.andrewlengly.com/storyboard): Storyboard and animatic editor for launch videos. Lay out frames, set their timing and play the cut back before a single frame is animated. - [Terrain Forge](https://www.andrewlengly.com/terrain-forge): A D&D map builder. Paint terrain, pick from five battle maps and run an encounter on a tactical grid. - [CircuitLab](https://www.andrewlengly.com/circuitlab): Learn electronics by wiring parts to an ESP32-S3 board. Six short lessons, a simple simulator and projects that save in your browser. - FourthSpace (in progress): A community app for finding third places to spend time with people in person. Data studies: Each study starts from a decision a company or a school faces. Every linked one ends with my recommendation. - [AI and student learning](https://analyst.andrewlengly.com/studies/ai-and-student-learning): Do coursework grades show what students remember, and what does an open AI chatbot do to the gap? - [TikTok STEM feed](https://analyst.andrewlengly.com/studies/tiktok-stem-feed): Why TikTok’s US STEM feed trails Douyin in China, and what would make it work. - [Chegg after ChatGPT](https://analyst.andrewlengly.com/studies/chegg-after-chatgpt): What Chegg should sell now that students have ChatGPT. - [Duolingo streaks](https://analyst.andrewlengly.com/studies/duolingo-streaks): Do Duolingo’s streaks and leagues build language skill, or mostly daily logins? - [Handshake and LinkedIn](https://analyst.andrewlengly.com/studies/handshake-and-linkedin): How Handshake can win new-grad hiring against LinkedIn and Indeed. - [Oura and Whoop](https://analyst.andrewlengly.com/studies/oura-and-whoop): Does paying for a wearable change how people live? - [The protein boom](https://analyst.andrewlengly.com/studies/protein-boom): Does the rush of high-protein products match a real gap in what people eat? - [The case for third places](https://www.andrewlengly.com/third-places-casestudy): Seven studies on loneliness and where people gather, and where FourthSpace should launch in Sacramento. - [Campus rec and GPA](https://analyst.andrewlengly.com/studies/campus-rec-and-gpa): Do students who use the rec center keep better grades and stay enrolled? Chico State is the example. - [Where the best hires come from](https://www.andrewlengly.com/sourcing-channels-casestudy): Which hiring channels bring in people who perform well and stay, and how the mix should change by role. - [Skills-based hiring](https://www.andrewlengly.com/skills-hiring-casestudy): How Greenhouse can help employers hire on skills, with job post templates and built-in assessments. - [New-hire ramp time](https://www.andrewlengly.com/ramp-time-casestudy): How fast new hires get up to speed, and what a buddy program and a ramp time KPI do for it. - [Internal mobility](https://www.andrewlengly.com/internal-mobility-casestudy): Do roles filled from inside fill faster and keep people longer? A study for Workday. - LinkedIn Premium (in progress): Which direction should LinkedIn take its Premium plans? - Indeed growth (in progress): Where Indeed can grow next, from job pricing to AI hiring software. Personal: - [Koi pond](https://www.andrewlengly.com/pond): A koi pond seen from above, with lily pads and a flock of ducks you can bring in. Tap the water to drop food and the koi come to eat. - [Sandscape](https://www.andrewlengly.com/sand): A tray of sand seen from above. Draw in it, then spin the bar across the middle to wipe it smooth. - [TextTrove Lab](https://www.andrewlengly.com/garden): Type a word and grow the homepage's role art around it, from vines and roses to circuits and charts. - [Andrew’s Campus](https://www.andrewlengly.com/campus): A pixel-art Chico State you can walk around. My resume plays out as the story. - [Keyboard playground](https://www.andrewlengly.com/keys): Pick a keyboard style and type. Each key squashes and sounds like the real one. - [Focus timer](https://www.andrewlengly.com/timer): Pomodoro and focus timers with breaks. The countdown shows in your browser tab. - [S P L I T](https://www.andrewlengly.com/tab-split-casestudy): Scan a receipt and send one link. Friends tap what they had, and tax and tip split to the penny. - [Music shelf](https://www.andrewlengly.com/music): My playlists on CDs. Pick one and it plays. - [Loading Lab](https://loading.andrewlengly.com): Sixteen canvas thinking orbs and seventy-four CSS loaders. The playground exports HTML or React. - [Live build](https://www.andrewlengly.com/build): A swarm of cursors rebuilds this site in front of you, drawing every box and typing every line while the screen follows. Parabox Digital: - [Parabox Digital](https://www.paraboxdigital.com): The web design studio I run for local businesses. - [Roadmap](https://roadmap.paraboxdigital.com): A sample timeline from signing a plan to launch day. - [Scorecard](https://score.paraboxdigital.com): A two-minute checklist that rates a business website and flags what to fix. - [QR Studio](https://qr.paraboxdigital.com): Make a QR code in your colors and check that it scans before you download it. ## Background Education: - California State University, Chico, Bachelor of Science in Management Information Systems, Cumulative GPA: 3.70 (2026) Certifications: - IBM - AI Product Management - Google - Project Management - McGraw Hill - Microsoft Excel Black Belt - Microsoft - UX Design - Adobe - Marketing Specialist - AWS - Cloud Practitioner Work Experience: - Founder & Web Developer, Parabox Digital, LLC (Aug 2024 - Present) - College of Business Senator, Associated Students of CSU Chico (Aug 2025 - May 2026) - Center Ambassador, Sierra College Basic Needs Center (Jun 2023 - Aug 2024) - Housekeeping Manager, California Family Fitness (Aug 2022 - May 2023) Leadership Experience: - President, Business Information Systems Society (Jan 2025 - May 2026) - President, Operations and Supply Chain Management Club (Nov 2025 - May 2026) - Lead Project Manager, MGMT 444 (Apr 2026 - May 2026) - Project Manager, Adulting 101 Program (Jun 2025 - May 2026) - Vice Chair, Associated Students of Facilities and Services (Sep 2025 - May 2026) - Appointed Representative, Associated Students of Business and Finance (Sep 2025 - May 2026) - Philanthropy Chair, Eta Mu Theta (Dec 2024 - May 2026) - President, VP Chapter Operations & Professional Activities, Delta Sigma Pi (Oct 2024 - May 2026) - Student Learning Fee Committee, College of Business (Sep 2025 - May 2026) - President, The Management Club (Jun 2025 - Dec 2025) - Vice President & Technology Officer, Business Information Systems Society (Sep 2024 - May 2025) - Campus Life Committee Representative, Sierra College (Sep 2023 - May 2024) - Student Senator, Associated Students of Sierra College (Sep 2023 - May 2024) Honors & Awards: - Outstanding Student Leader Award Recipient, College of Business (Apr 2026) - BIS Leadership Award Recipient, College of Business (Apr 2026) - Hackathon Awarded Competitor, Association for Computing Machinery (Apr 2026) - Datafest Awarded Competitor, American Statistical Association (Apr 2026) - Achievement and Equity Award, Cross Cultural Leadership Center (Apr 2026) - ERPsim Competition Finalist, SAP University Alliances (Mar 2026) - Anne Sena Business Information Systems Scholarship Recipient, College of Business (Jan 2026) - Lois Winifred Stansell Scholarship Recipient, College of Business (Jan 2026) - Grand Chapter Congress Delegate, Delta Sigma Pi (Aug 2025) - Excellence in Community Service & Philanthropy, Multicultural Greek Council (May 2025) - Excellence in Academic Achievement, Multicultural Greek Council (May 2025) - Datafest Awarded Competitor, American Statistical Association (Apr 2025) - APAHE Conference Grant Awardee, Asian Pacific Americans in Higher Education (Apr 2025) - DPMA Sacramento Scholarship Recipient, Data Processing Management Association (May 2024) - Senate Representative, Associated Students of California Community Colleges (Mar 2024) Technical Skills & Activities: - Technologies Used: Python, JavaScript, SQL, PostgreSQL, HTML/CSS, React, Git/GitHub, Tableau, Power BI, Microsoft Excel/PowerBI/Project/Powerpoint, Google Workspace, AWS IAM/EC2/Fargate/DynamoDB/Lambda/S3/Route53, Adobe Creative Suite/Cloud, Notion, Jira, Trello, Figma, CursorAI, ChatGPT, Claude, Google Gemini. - Technical Skills: A/B Testing, Product Roadmapping, User Research & Analysis, Wireframing, Prototyping, Agile/Scrum, Design Thinking, Competitive Analysis, Data Modeling, Data Aggregation, Entity-Relationship Diagrams, Market Research, Risk Mitigation, Scope Management, Project Lifecycle Management, Resource Allocation. - Services & Activities: Cross-Cultural Leadership Center Volunteer, Hmong Student Association, Campus Life Committee Representative, SAP Club, Social Science Club. ## Contact - Email: andrew.leng.ly@gmail.com - LinkedIn: https://www.linkedin.com/in/andrew-leng-ly/ - GitHub: https://github.com/AndrewLengLy - Resume: https://resume.andrewlengly.com - Business card: https://card.andrewlengly.com - Resume (PDF): https://www.andrewlengly.com/resume/andrew-ly-resume.pdf - Full resume (4 pages): https://docs.google.com/document/d/1A3oMlteBPp73m208RTMgZ0nsFqhwFZyoAkEDk3w1HG4/export?format=pdf - Designer resume (PDF): https://designer.andrewlengly.com/resume - Analyst resume (PDF): https://analyst.andrewlengly.com/resume - Developer resume (PDF): https://developer.andrewlengly.com/resume - Medium: https://medium.com/@andrew.leng.ly - Blog: https://blog.andrewlengly.com - Contact form: https://www.andrewlengly.com/#contact