• Designed Power BI dashboards to analyze over 1 million departing passengers per boarding area perhour, enabling concession stands to maximize profits and boost business efficiency• Utilized Tableau to forecast departing passengers over the next 6 months, predicting trends byairline and boarding area with 85% accuracy, helping resource allocation and operational planning• Crafted dynamic SQL queries in Oracle to drive and document database migrations inCognos, ensuring smooth transitions and empowering data-driven decision-making• Assisted airport staff by resolving support tickets, streamlining automation processes using PowerAutomate, Power Apps, Microsoft Forms and Sharepoint integration•

• Optimized a master dataset by cleaning and joining over 50 Excel files together using Python• Applied statistical and machine learning models to analyze and predict key performance indicators • Utilized data visualization tools in Python and Excel to extract meaningful insights and identify useful trends by displaying over 20 graphs, charts, and tables• Produced detailed literature reviews and presented research findings to make recommendations and support decision-making for the Monitoring and Evaluation team

• Implemented automation solutions using Power Automate to streamline weekly email notifications and calendar invites, resulting in a 80% reduction in manual workload• Created automation solutions for Providence's Think Tank to advance project ideas submitted by caregivers, and systematically recorded and managed ideas in SharePoint• Orchestrated and designed over 10 surveys using Forms to collect feedback from internal caregivers• Conducted PowerPoint presentations to the Talent Effectiveness team, demonstrating the benefits and functionalities of automation solutions for potential implementation

• Developed a recommender system using Pandas, NumPy, Matplotlib, and Scikit-learn libraries, achieving a 20% increase in recommendation precision. • Leveraged Python to employ machine learning models for predicting student test scores based on educational data, achieving a prediction accuracy of 85%• Supported the publication of 2 peer-reviewed articles by conducting over 20 literature reviews and research summaries using Mendeley• Delivered an engaging seminar to over 40 ETS scientists, answering questions and facilitating discussions: https://github.com/joseph-cchang/ETS-RS

- Performed comprehensive data analysis using numerous statistical softwares (R, Python, Javascript) to extract meaningful insights and trends in team repository on Github- Supported in planning, designing, and conducting research experiment designs under a senior researcher- Participated actively in research discussions and brainstorming sessions, contributing ideas, insights, and suggestions to advance research project on human behavior and dehumanizing language

- Produced and launched interactive campus maps featuring students’ favorite places on campus, tips, andtestimonials through Google Sheets -Transferred data collected for over 100 schools onto MapMe, the platform used to create interactive maps

- Applied active listening, encouragement, and tutoring techniques for student in Math and English fundamentals- Conducted monthly assessment of student progress and modified tutoring techniques accordingly

- Implemented after-school academic support to elementary and middle school students- Taught daily math courses using child-centered learning approaches as well Chinese and English classes- Translated announcements/rules in Chinese or English for teachers, parents, and visitors- Conducted assessment of students' academic performance. Identified students' areas of improvement and made suggestions for improving academic success to the principal monthly.