Data Analytics • Business Intelligence • Decision Support
Turning business context into clear, actionable analytics.
I am Jose Antonio Ayon Wu, a bilingual MBA graduate and Master of Science in Data Analytics candidate. My portfolio brings together business leadership, retail and category experience, dashboard design, SQL and Python analytics, and decision-support projects built to solve real operational problems.
Core stack
SQL • Power BI • Excel • Tableau • Python • Streamlit
About
A data portfolio built on business experience.
My background started in retail operations, category management, pricing, forecasting, and commercial leadership. That experience shaped the way I approach analytics: not as reporting for its own sake, but as a practical tool for improving decisions, communication, and performance.
Today, I work across data cleaning, normalization, dashboard development, exploratory analysis, SQL data modeling, and applied analytics projects that make complex information easier to understand and use.
Featured projects
Selected work from GitHub
Python • Streamlit • Excel
Clinical Wound Decision Support Demo
A Streamlit-based decision-support demo focused on cleaning, normalizing, validating, and structuring Excel-based protocol data into a deterministic workflow.
- Data cleaning and ambiguity review
- Vocabulary and schema standardization
- Rule-based recommendation logic
Power BI • Python • DAX
Credit Risk Analysis
Interactive credit-risk dashboard combining data modeling, DAX, PCA, and K-Means clustering to generate behavioral segmentation and executive-ready insights.
- 30,000+ customer records analyzed
- Power BI storytelling with Python integration
- Risk behavior profiling for decision support
MySQL • ER Modeling • Excel
KJ CORP SQL Database Project
Fully normalized retail database designed to centralize suppliers, inventory, customers, sales, and payments in an analytics-ready schema.
- 3NF database design
- DDL, DML, DQL, and BI-ready queries
- Retail operations modeled end to end
Tableau • Tableau Prep
Hospital Quality Intelligence Dashboard
Executive-ready Tableau dashboard using ETL, data blending, LOD expressions, forecasting, and sensitivity analysis to evaluate hospital performance.
- Healthcare KPI storytelling
- Interactive what-if analysis
- Blending and LOD expressions
Python • Machine Learning
Recipe Review Ratings Prediction
End-to-end analytics and machine learning workflow predicting 1-5 star ratings from recipe reviews, from data preparation to model evaluation.
- 18,180-row cleaned dataset
- Feature engineering and class imbalance handling
- Random Forest baseline accuracy of 0.76
Experience
Relevant Experience for Data Analytics Roles
Data Analytics Co-op (Clinical Decision Support) - Niagara Region
Analyzed structured healthcare and clinical data to identify patterns, validate decision-support logic, and support the development of a data-driven application for operational use.
Associate - TJX Canada
Contributed to high-volume retail operations, inventory organization, product presentation, and customer service while completing graduate studies in analytics.
Founder & Shareholder - KJ CORP
Led operations and commercial strategy, achieving 45% annual sales growth and improving forecasting accuracy through Power BI and Excel dashboards.
Own-Brand Product Manager - Makro Supermayorista
Managed private-label brands generating USD 47M annually, optimizing assortment, pricing, reporting, and supplier negotiations for large retail categories.
Category Manager - Makro Supermayorista
Oversaw multimillion-dollar categories using Excel and SQL to support category profitability, promotional decisions, and KPI visibility.
Skills
Tools and strengths
- SQL
- Power BI
- Excel
- Tableau
- Python
- Data Cleaning
- Dashboard Development
- Forecasting
- Business Intelligence
- Stakeholder Communication
Education
Academic background
Master of Science in Data Analytics
University of Niagara Falls Canada | Expected Jul 2026
MBA
Pontificia Universidad Católica del Perú
B.Sc. in Food Science Engineering
Universidad Nacional Agraria La Molina
Contact
Let’s connect.
I am open to data analyst, BI, reporting, dashboard, and business analytics opportunities in Canada.