Hello, I'm Ethan Wu
— Data analyst, MS Computer Science*.
Data analyst with a computer science background, building production analytics tools in Python, SQL, and Snowflake. I combine technical depth with business judgment to deliver forecasting models, automated pipelines, and decision-support tools. Currently pursuing an M.S. in Computer Science at Southern Adventist University.
Languages
Tools & Platforms
Databases
Developed custom ETL pipelines in Python and SQL to ingest data from Snowflake into Neo4j, query both databases, and generate comprehensive post-game sales reports including LLM powered insights.
Developed the posts service for a microservices-based Instagram clone using Python, FastAPI, and MongoDB, implementing features such as post creation, retrieval, and user interactions. Orchestrated all services using Docker, and coordinated development with a team of 4 using Git and Agile methodologies.
- Developed concert pricing strategy for Sports Illustrated Stadium, advising leadership on price points and product placement to maximize per-cap revenue for non-game-day events
- Developed a predictive cannibalization model using statistical and ML techniques to quantify cross-product sales relationships, enabling leadership to model how pricing or volume changes on one item ripple through the broader menu.
- Redesigned and automated the consumption projection methodology in Python, pandas, and NumPy, replacing manual legacy processes and producing more accurate inputs for inventory and operational planning.
- Built MS Fabric ingestion pipelines that consolidate sales data into Snowflake, eliminating manual data movement and keeping analytics on a consistent source of truth.
- Prototyped an automated reporting workflow in n8n orchestrating custom Python, JavaScript, Snowflake and Neo4j queries, and a local LLM to surface AI-driven insights into consumption trends.
- Own recurring financial forecasting deliverables, including game-by-game projections and annual revenue forecasts that directly inform budgeting decisions.
- Engineered custom Snowflake views and complex SQL queries that power Tableau dashboards and financial reports, translating raw transaction data into KPI-level insights for non-technical business stakeholders.
- Conducted cost center analysis reporting directly to the CEO, delivering insight into millions of dollars in cash flow and supporting more deliberate fund allocation and expense decisions.
- Served as primary point of contact for all in-house IT needs and oversaw accounts payable operations — vendor invoices, contractor payroll, bill tracking.
The fastest way to reach me is by email at EthanWuCS@gmail.com. I'm also on LinkedIn and GitHub, and I respond to most messages within a business day. Open to work opportunities, research collaborations, and conversations with data-driven teams.