My Experience
The University of Western Australia
- Computer Science and Software Engineering School
- Casual
- Lab Facilitator for the unit CITS4009: Computational Data Analysis (RStudio) and CITS1401: Computational Thinking with Python.
- Project and exam marking.
eShopping Group
- An e-commerce company
- Intern
- Developed AI voice transcription application using React and Django Rest Framework.
- Implement innovative features to enhance user experience and increase efficiency of the software.
eShopping Group
- An e-commerce company
- Intern
- Integrated sales and purchasing data from Azure SQL database and developed automatic interactive Power BI dashboards.
- Enabling data-driven decision-making, and delivering actionable insights for cross-functional teams.
Coders For Causes
- A club that empower charities and non-profit organizations by providing them tech solutions
- Part-time
- Front-end development for Penni project using React.
- Full-stack development for Wajo project using DRF/React.
Landgate
- A data company storing and managing land information in WA
- Intern
- Responsible for strategy analysis on the trend of AI & Automation (BPA and RPA). Dig the impacts and changes brought from the new trend to the business operating model and business units.
Work
Supply Chain Planner
BASF
- The world's leading and the largest chemical company from Germany
- Initiated the Demand Review Visualization Project, delivered PBI dashboards for 3 product groups.
- Initiated the Forecast Accuracy Project and developed an automated Dashboard to track the Forecast Accuracy (FCA) rate.
- Executed End-to-End Supply Chain Planning, overseeing demand forecasting, allocation planning, replenishment.
- Collaborated with manufacturing and sales departments in monthly production planning, S&OP, and demand review meetings.
Work
Supply Chain Intern (Project Team)
Sanofi
- A world-leading pharmaceutical company from France
- Engaged in Reagents Purchasing Bidding Program. Established a quant criteria model; organize on-site visits and meetings; analyzed quotations for 4 tending suppliers.
- Participated in Vaccine Traceability Project. Drew comparison and analysis charts for 5 brands loggers, dig the quality defects of each, prevented the potential QA risks.
- WH & TRS cost summarizes for drugs/VXs across all China DCs.
Work
S&OP Intern (Machine Leaning)
Johnson & Johnson
- A world-leading healthcare company from the USA
- Participated in the Machine Learning Project for FMCG sales forecasting. Collecting, cleansing, and summarizing the data of promotion for ML system.
- Participated in Watsons & JNJ VMR (Vendor Managed Replenishment) Project by updating sales, allocation paper etc. to JNJ Azure database. Conduct the PBI dashboard UAT.
- Established and completed S&OP (Sales & Operation Planning) Data Maintenance Guide Manual, provided work guidance and training for other interns.
The University of Western Australia
- A program designed to support new students
- Helped new students navigate university life by answering questions and providing guidance.
- Offered encouragement and help students feel connected and confident in their new environment.
- Assisted with finding classes, using campus facilities, and understanding university systems.
Degree
Master of Information Technology
The University of Western Australia
- Obtained HD average mark and BCG GAMMA Prize (for the top 1 student in CITS4009)
- Relevant coursework: Relational DBMS (SQL), Computational Data Analysis (RStudio), Agile Web Development, High Performance Computing etc.
AIESEC
- A International Volunteer Program
- Provided basic English teaching for out-of-school children (9-18 years old) in two welfare educational institutions.
- Taught students to use simple vocabularies to communicate in English by organizing 5 days classes weekly for 2 months.
Leor Early Learning
- A family preschool education institution
- Provided Leor with strategic consulting services on employee recruitment and retention.
- Demonstrated 5 detailed improvement strategies to help Leor extend its business
Degree
Master of Business Analytics & Supply Chain Management
The University of Syndey
- Obtained 76 average mark
- Relevant coursework: Statistical Learning and Data Mining (Python), Managing Business Intelligence (Tableau), Quantitative Logistics and Transport, Applied GIS and Spatial Data Analytics (R Studio, ArcGIS), Supply Chain Planning & Design, Production and Operation Management (SAP & SQL) etc.
Degree
Bachelor of Logistics Management (Exchange)
University of Lodz
- Exchange program
- Relevant coursework: International Logistics, Custom Procedures, E-Commerce Marketing etc.
Degree
Bachelor of Logistics Management
Tianjin University of Science & Technology
- Obtained 86 average mark and first-class scholarship
- Relevant coursework: Linear algebra, Logistics system simulation, Microeconomics, Macroeconomics etc.
Work Referees
Please refer to me as: Arthur Lian (Australia) or Mingyu Lian (China)