Ambrose Lye Email & Phone Number

Petaling Jaya, MY

Selangor, Malaysia

• Collaborated with cross-functional teams to design and automate ETL processes using SSIS and implement Power BI. This initiative significantly increased data processing efficiency and enabled real-time, accurate.
• Developed data models and interactive Power BI dashboards for senior management, identifying key issues in banking equipment. This data-driven approach resulted in reduced machine downtime and operational costs for.
• Conducted comprehensive audits of workflows and processes for operations servicing Tier-1 banks, including HSBC and Bank of China. This proactive approach identified and addressed key inefficiencies, resulting in.
• Streamlined data transformation and report generation processes by leveraging SQL and Power Query, substantially reducing manual effort. This automation enabled management to access near real-time data for analysis.
• Spearheaded a Google Maps API-based distance calculator project to optimize engineers' daily routes. This initiative improved resource allocation, achieving cost savings and enhancing overall operational efficiency.
• Supported the implementation of an ERP system to optimize data entry, resource allocation, and scheduling through automation. This change improved data accuracy, streamlined reporting, and increased overall operational.

Laie, Hawaii, United States

• Developed over 540 financial reports and dashboards using Microsoft Excel to extract, clean, and analyze data sets for 5 retail departments, providing management with valuable insights into business performance and.
• Managed the time tracking process for a large team of over 100 employees, conducting regular audits to verify compliance with company policies through the use of the Workday Enterprise Management Cloud
• Efficiently managed the meal plan booking process for a student body of over 1200 individuals each semester, utilizing a Restaurant Management System software to facilitate smooth operation every quarter of the year
• Conducted monthly credit card reconciliation and resolving discrepancies for 5 retail departments by collaborating with managers and finance team, ensuring accurate and timely financial records
• Maintained precise financial records by processing payments and addressing inquiries from clients and vendors promptly
• Managed the Food Services Department's inventory and invoices using an Inventory Management System, ensuring accurate records to minimize inventory discrepancies, accurate pricing of products, and improved operational.

Hawaii, United States

• Leveraged Customer Relationship Management software to create targeted training programs based on customer feedback, resulting in a record-high customer satisfaction score of 100% in 2021
• As a trainer, successfully mentored a diverse team of over 90 tour guides from 70 different countries, providing weekly training on Polynesian culture and effective presentation skills