Wanda's Portfolio

IPB University

Bachelor of Mathematics

School of Statistics Data Science, Mathematics, and Informatics

MySkill: Intensive Data Analyst Coding Studio: Advanced Ms. Excel Udemy: Tableau Desktop for Data Analysis

📈 Analytic Methods

• EDA & Data Cleaning
• Data Quality Validation & Anomaly Detection
• Demand Index Scoring & Benchmarking
• Forecasting & Predictive Modeling
• Customer Segmentation & RFM Analysis
• Market Basket Analysis (MBA)
• Regression & Statistical Testing
• Machine Learning | Prediction Model
• Deep Learning | Sentiment Analysis

Critical Thinking Problem Solving Communication Team Work Time Management Public Speaking Adaptive Storytelling

• Built and maintained an automated BigQuery analytics database that incrementally ingests new POS orders, processing 928,051+ transaction records through 1 staging table, 1 partitioned raw table, 3 clean views, and 3 dashboard-ready materialized views.
• Shipped production-used dashboards (8 outlets, 4 brands) that drive weekly business reviews, covering revenue, menu, transactions, basket size, payment methods, sales channels, branch performance, and weekly trends.
• Conducted deep-dive analysis on approximately IDR 16.02B revenue, 198k+ transactions, and 1.03M+ units sold, revealing that 4 of 8 outlets contributed 84.5% of revenue.
• Identified seasonal and operational patterns — 35.4% Ramadhan drop, 36.3% Lebaran rise, and 47% higher weekend daily revenue.
• Delivered recommendations for building, upselling, cross-selling, staffing optimization, off-peak promotions, branch growth, and menu strategy.

• Built a production-used cinema admission dashboard covering tracked admission, estimated admission, occupancy rate, showtimes, exhibitor performance, city performance, and cinema performance.
• Developed an end-to-end workflow by scraping CGV, XXI, and Cinepolis admission data with a custom Selenium scraper (60k+ rows/ film), leading structured outputs into Big Query and connecting data sources to Looker (Google Data Studio).
• Consolidated fragmented Google Drive/Sheets workflows into a Big Query warehouse with star-schema staging, fact/dimension, and partitioned tables, plus helper views.
• Automated Big Query refresh/materialization with Google Apps Script and created SQL-based data quality checks that catch scraping issues, invalid records, inconsistent movie titles, and dashboard anomalies.
• Developed city/cinema performance indexes and a formula-based recommendation framework for special screening selection using occupancy rate, filled seats, showtime, accessibility, survival index, and film-specific demand.

📊 Data & Analysis Experiences

📢 Leadership & Organization