TIMOTHY LAM

Portfolio

Skills

Professional Experience

Executives and Sales Support Assistant  (2023-Present)

Tempur Sealy Canada, Scarborough, ON

• ADMINISTRATIVE SUPPORT AND ASSISTANT

        Reporting to the Vice President of Sales provide day-to-day support for the Sales function at Tempur Sealy Canada and assist Executive team, as required.

• Reports: processed "sales and returns" reports from raw data and presented in Excel pivot tables.

• Ensured efficient communication by utilizing Microsoft 365 online services.

• Increased data accuracy and process efficiency by introducing dynamic data sources for Excel pivot tables and dynamic cell references using the INDIRECT function.

  • Automated the process of gathering data submissions from various sources and automatic reporting using the Microsoft 365 Form by creating an online data entry form for a back-end Excel spreadsheet. While data entry requires authentication by company login accounts, the spreadsheet data is accessible only to the administrator.

• EXECUTIVES SUPPORT

  • Ensured signatures are gathered according to proper ranking for contracts and agreements.

  • Set up and coordinate transportation and meetings.

Service Co-ordinator  (2023 April-December)

Volvo AWIN Group of Dealerships, Markham, ON

• Demonstrated excellent communication skills in cultivating professional relationships with customers in English, Cantonese, and Mandarin by telephone, email, and in person to schedule vehicle service appointments.

• Managed 17 courtesy vehicles by creating agreements for vehicles loaned to customers and ensuring that they were returned as agreed. I tracked and reported vehicle availability to cross-functional teams in real-time using a secured online process I created.

• Skillfully liaised with vehicle service, parts and sales departments, external warranty, and insurance companies and ensured customers received vehicle service claims and repairs under various coverages.

Office Manager  (2009-2022)

Malvern Family Resource Centre, Scarborough, ON

• ADMINISTRATIVE SUPPORT

  • Recognized by the Executive Director as the “right-hand man” who could render ED’s vision and resolve daily problems.  Handled facility related complaints documented by the Critical Incident Report for follow up.

  • An accomplished problem solver with proven ability to overcome challenges and complete tasks given up by the others, e.g., created the collaborative online Organization Calendar.

  • Succeeded in persevering core administrative functions throughout the pandemic, when the accountant position had been vacant, and during the leadership changes involving three Executive Directors from 2021 to 2022.

  • Provided high-quality core administrative services to support the Executive Director as part of the integral process in the growth of the MFRC from a humble setting to owning its building in 2014.

  • Created a system to track payable invoices and submit with approval to the Accounting office for payment.

  • Ensured employee records in HR information database were updated wherefrom other documents generated.

  • Provided website overhaul Subject Matter Expert advice as a member of the Public Relations Board Committee.

• CUSTOMERS SERVICE

  • Provided general and specific information to the public, the City of Toronto and Statistics Canada surveys.  Other inquiries were redirected either internally or to other community services guided by the 211 Central directory.

  • Filled work orders by resolving all IT related problems and provided payroll and Human Resources services.

  • Executed bi-weekly payroll schedules accurately and on time for the past twelve years.

• COORDINATED PROJECTS START/END ACTIVITIES, LIAISON WITH STAKEHOLDERS

  • Trusted with the responsibility to create and manage a Community Demographic survey in collaboration with the “Data for Equity Strategy” initiatives by the City of Toronto to identify inequities in our community services.

  • Achieved a 30% survey response rate by setting up and coaching MFRC program staff to conduct the survey.

  • Provided families in need with free Income Tax Clinics in partnership with the Canada Revenue Agency and liaised with volunteer Chartered Professional Accountants.  Documented activities and submitted statistical reports.

• SYSTEM DEVELOPMENT AND MAINTAINENCE

  • Enhanced information flow with the new ‘MFRC intranet’ I created in a Microsoft SharePoint "MFRC Insider Intelligence (ii)" secure portal[1].

  • Created an online Organization Calendar to track business-critical events synchronized with mobile devices.

  • Ensured a 99.9% uptime of Microsoft Business Servers 2003 R2 & 2019 and Virtual Private Network.

  • Achieved self-sufficiency by learning proactively to maintain the facility security (Protégé) and CCTV systems.

  • Consolidated asset management by creating and administering an “inventory database”, and by writing and implementing policies on asset acquisition, distribution, tracking and disposal.

• CREATIVITY INNOVATION

  • Digitalized general ledger to replace the Blueline ledger by creating a secure database application on MsAccess.

  • Pioneered a data conversion process to replace manual tabulation.  The new process utilized barcodes and handheld scanners to digitalize text in various applications, e.g., gift card bundles, survey returns.

  • Spearheaded a new statistical data ETL and reporting process with perfected distinct-individuals-served methodology by a) creating applications, i.e., “Electronic Attendance Recording System (EARS)”, the “ITWO”, and the “MFRC membership”; and b) by coaching program staff to upgrade their skills in data analysis and tabulation.

  • Advanced Excel forms programming, e.g., Expense tracking, financial submission, and hybrid work accountability.

  • Improved reception desk admission efficiency by 66% and improved Annual General Meeting (AGM) minutes accuracy to 99.9% by creating an AGM application to receive members by scanning membership barcodes.

Business Information /Emergency Road Service Supervisor (2006-2009)

Canadian Automobile Association, Thornhill, ON

• Improved information flow from different operational silos by centralizing data storage in standard digital format referred to as “Corporate Performance Index (CPI).”

• Oversaw operational reports to the Control Centre Solutions Managers (4), Member Care Centre Directors (2), the Automotive Services Director, and as liaison to AAA Florida in U.S.A. and CAA Ottawa headquarters.

• Administered Member Satisfaction Survey Program by overseeing budget, sample selection, weekly and monthly reports, and accreditation compliance with AAA in U.S.A.

• Analyzed and mapped system data to meet reporting and analytical business needs.

• Developed and analyzed business performance reports and provided notations of performance deviations and anomalies.

• Identified project requirements by establishing personal rapport with potential and existing clients.

• Spearheaded additional supervisory support to Emergency Road Service.

Administrative Assistant  (1988 - 2009)

Malvern Family Resource Centre, Scarborough, ON

• Reported to the Executive Director while spearheading all administrative tasks.

• Drove client satisfaction ratings while maintaining the Information Technology infrastructure.

• Executed record filing system to improve document organization and management.

• Handled client correspondence and tracked records to foster office efficiency.

• Monitored supervisor's work calendar and scheduled appointments, meetings, and travel.

• Developed and updated spreadsheets and databases to track, analyze and report on performance.