Allie Chatsrirung Email & Phone Number

Melbourne, Vic, Au

Greater Melbourne Area

Melbourne, Victoria, Australia

- Led the enhancement of 2 critical ETL pipelines, minimising redundancies through modularisation and automation. This streamlined execution to a single Python command, reducing processing time by 40% and enabling more frequent data refreshes.- Developed a Tableau dashboard to validate the effectiveness of a new communication system for over 500 nurses and doctors, providing insights that led to a 40% improvement in clinical workflow efficiency. This analysis supported decision-makers in evaluating the system’s impact and identifying areas for further improvement.- Planned and organised tasks for a team of 5, establishing clear timelines and priorities, which resulted in the timely completion of key project milestones.- Created comprehensive documentation to ensure transparency and reduce onboarding time for future developers by 30%, improving the long-term maintainability and scalability of the system.

- Collaborated with the team of 10 to develop and deploy a web application that provided real-time traffic insights across Victoria, supporting future construction planning and decision-making.- Developed an automated road utilisation prediction model for 1,000+ road links and intersections across Victoria, using Prophet for time series analysis to forecast traffic patterns. This model provided valuable insights to aid in future construction planning, helping determine the best alternative routes and optimal times for roadworks.

Bangkok Metropolitan Area

- Worked as part of the BI Hotel Core Product TeamMy responsibilities included:- Collaborated with a Supply Optimisation team of 5 to define business requirements and provide expertise in effective data utilisation.- Built dashboards to enhance operational tasks, supporting market managers in performing root cause analysis. Improved the Supply Health KPIs, resulting in a 50% reduction in investigation time.- Designed and implemented new table structures for 3 existing fact tables to improve dashboard performance, support more complex business logic, and simplify investigation processes for all levels of users (from executives to operations).- Optimised and scaled datasets consisting of 3 billion rows, which were displayed in Tableau and Metabase dashboards to serve over 300 users globally.- Monitored various data quality dimensions using Quilliup DQ tools to achieve a 100% data quality score in the data warehouse.

Bangkok Metropolitan Area

- Facilitated classes for 300 students to provide guidance on best practices and concepts relating to data.- Demonstrated excellent leadership and mentoring skills by achieving a high feedback rating of over 70% from mentored students.- Conducted a Power BI dashboard workshop to demonstrate data visualisation and utilisation, inspiring over 50 students to start learning the tool.

- Interpreted and translated retail business requirements into software requirements and constructed BI and analytics applications based on given software requirements.- Built ETL pipelines from diverse data sources, including Oracle DB, SAP HANA, and survey data, consolidating them into the GCS Data Lake. Collaborated with 4 cross-functional teams, including finance, sales, restaurants, and IT, to ensure alignment and smooth data access for stakeholders across the organisation.- Performed data analysis on Google BigQuery and developed automated reports and dashboards using Power BI, covering key areas such as price analysis, competitor analysis, restaurant sales, and accounts receivable, enabling business users to track KPIs and streamline decision-making processes.

Bangkok Metropolitan Area, Thailand

- Developed an AR using Unity with Vuforia and ARCore- Consulted with supervisor and 3D artist to clarify program intent, identify problems, and suggest changes- Collaborated with artists to achieve the appropriate visual style

Master'S Degree, Information Technology

Distributed Computing Stream Endeavour Exhibition (Shortlisted for 2 Airwallex Awards): Developed the modern PetFinder project using image.

Bachelor'S Degree, Electronic And Computer Engineering

Activities and Societies: HackNotts 2018

Bachelor Of Engineering - Be, Electrical Engineering

Activities and Societies: Thammasat University Symphony Orchestra

Igcse