Andy Pham Email & Phone Number

Toronto, Ontario, Canada

• Design and develop scalable, event-based ETL pipelines using Python, Stored Procedures, Lambda Functions, EventBridge, to extract, transform, and load structured (csv, json) and unstructured data (text) from vendor sources into data warehouse in MySQL, PostgreSQL, and SQL Server.• Generate and develop custom reports for client and internal requirements.• Optimize data workflows to improve data processing, SQL query performance.• Create and maintain ETL build pipelines in Jenkins and manage workflow and log via Spinnaker and Grafana.• Monitor and troubleshoot data pipeline issues to ensure data availability and integrity.• Migrate legacy ETL workload to AWS using Terraform infrastructure.

Toronto, Ontario, Canada

• Tailored and delivered 12 mini-lectures on advanced topics in data science (Tableau, WebScraping, AWS EC2/SageMaker, Modeling and Data Science concepts).• Personally coached and supported 20 data science students throughout the full-time 12-week program.• Managed a team of UX Designers, Web Developers, Data Scientists, and Digital Marketer to accomplish a Hackathon project from MasterCard.• Graded assignments and presentations in addition to providing feedback on student projects.

Toronto, Ontario, Canada

• Checked-in/out of guestroom.• Introduced and guided the guests about the hotel structure and room types.• Answered the phone and directed the calls.• Arranged transportation for the guests.• Cross-trained with Bellman, Operator, and Club Lounge service tasks.

Toronto, On, Canada

• Proficient with Oracle MICROS POS platform and collaborated with the chef to customize their orders increasing guest satisfaction.• Proposed the initiatives from the Front Desk experiences to solve the Room Service problems (handling multiple guest calls).• Trained and assisted new staff to be familiar with room service or server assistant tasks.• Answered guest phone calls while simultaneously recording their orders in the POS system.

• Utilized marketing tools, explored and acquired locally potential customers to increase the store awareness as well as the revenue.• Analyzed guest order patterns to improve customer experience.• Hired and trained new staff for all in-store positions following the company quality standard.

• Dealt with issues relating to supplies and balanced the flow of materials to keep the production lines being smooth-going.• Maintained the material quality in the production line and simultaneously communicated with multiple suppliers to keep the consistency as buyers' standards and expectations.• Wrote reports, inspects and emails about defective issues or status of materials to the Korean Head office.• Supported factory manager to minimize the causes of breakdown issues.

Data Engineering

• Design, build and maintain scalable data pipelines. • Learn to work with the ETL framework (Extract, Transform, Load) for copying data.

Diploma Of Education, Data Science

Diploma, Hotel Operations Management, 3.89/4

Dean's Honour List 4 semesters

Bachelor'S Degree, Accounting