Education

Majors: Food Engineering

Cumulative GPA (scale 4.0): 3.2

Majors: Advanced Mathematics

Cumulative GPA (scale 10.0): 8.9

Programming Languages: SQL (MS SQL Server, PostgreSQL, Google BigQuery), Python, R , HTML, CSS.

Software/ Tools: Microsoft Office (Excel, Power BI, PowerPoint), Adobe Suite (Photoshop, Lightroom, After Effect), Google (Google Sheets, Google Data Studio), Tableau, Miro.

Certifications: Intermediate SQL (HackerRank), Google BigQuery & PostgreSQL for Data Analysis (Udemy), Python Programming Bootcamp (Udemy).

• Retrieved data from Xiaomi Management System to build automatic dashboard regarding warranty performance, Warranty CPU; Warranty Period; Claim Rate, Labour Cost etc., utilizing Tableau.
• Utilized SQL to extract and manipulate data from MS SQL Server to build a price-cost analysis model, providing business insights for stakeholders to make strategic decisions.
• Collaborated with key business partners (Sales and Supply Chain Department) to develop and manage dashboards/ reports on P/L and 3PL management, using advanced MS Excel and Tableau.

• Analyzed historical engagement data of 8 warehouses and recommended strategy to improve engagement metrics from 18% to 37% for Health & Well-being campaign, using Excel Data Modelling and Power Pivot.
• Built training metrics and a reporting system (+ 2000 rows) and visualized on dashboard to certified training program, utilizing Power Query and Power Pivot on Excel and Power BI.
• Conducted market intelligence analysis of 5 third-party logistics companies on employee engagement, corporate communications and branding partnerships and translated information into recommendations for corporate branding activities.

• Reduced 8 hours of the manual monthly report by building an automation reporting system (+ 4000 rows), utilizing Power Query, Power Pivot and DAX Studio on Excel.
• Prepared quantitative and qualitative surveys to identify deficiencies of 3 training programs and prepared proposals for facilitators to improve training design & delivery activities, using Microsoft Form and Power Automate.
• Coordinated 3 end-to-end Learning & Development training programs (competency evaluation test, logistic management, participant management) for 4 months and delivered to + 200 employees.