Hallmark has been a 100% Canadian-owned and operated building maintenance firm since 1977, currently employing over 5,000 team members, across over 120 million square feet of office, retail and industrial space.

Structure Research is a global IT infrastructure research and consulting firm that has been featured on influential news agencies such as Channel NewsAsia, South China Morning Post, Nikkei Asian Review and San Antonio Express News.(Redundancy)• Produced market research reports and daily summaries of US and Chinese IT infrastructure trends. Readership of over 880 subscribers and 3,000 newsletter clicks weekly• Tracked and organized KPIs plus M&A activity of key market players in financial models. Built complex formulas involving IMPORTXML, two-way lookup, etc. to automate 80% of data entry work• Supported quarterly presentations for over 120 clients, namely cloud service providers, institutional investors, and IT users

(COVID-19 Downsizing)• Enhanced the Colliers Asia Research unit's central database operations using VBAs (dialogue boxes), dynamic S&P Capital IQ (CIQ) charts/formulas, and nested OFFSET formulas• Standardized data submission practices across 18 regional teams to declutter the central database• Produced six quarterly and special reports that provided timely consulting to a global clientele• Self-taught and trained two new hires on S&P CIQ/Market Intelligence, Real Capital Analytics and Oxford Economics. Consistently sought training to improve my own and mentees’ analytical skills• Fulfilled a data-sharing contract with Bloomberg, the unit’s main revenue stream

(Reassignment)• Delivered a $50,000+ consulting project for AXA Tower, a major landlord in Kowloon• Advised three relocation and expansion cases (two banks and one vending machine supplier)• Prospected and pitched Colliers’ competitive edge to nearly 100 potential clients• Ran financial modelling of rental options for three clients and informed them of market movements

Sino Group's Management Trainee Programme is a selective 20-month career development scheme that fast tracks young talent into management roles in the company. Every year, fewer than 10 university graduates are chosen through cognitive tests and multiple interviews to eventually lead one of Hong Kong's top 10 property developers.• Negotiated and upheld compliance with residential leases at one of Hong Kong’s largest real estate developments (Gold Coast Residences)• Conducted tenant and competitive analysis to identify target tenants, lower vacancy rates, and improve services for existing residents. Improved resident satisfaction• Monitored the progress and costs of repairs and renovations to avoid cost overruns • Inspected repossessed units to ensure move-in conditions for new tenants were up to par• Audited financial statements to maintain profitable rental yields • (Special project) Analyzed Sino Club’s (hotel and mall loyalty program) social media and Salesforce data to pinpoint subscribers’ favourite content

• Answered calls and voicemails about meal plans, on-campus filming requests, price quotes, and other inquiries• Completed housekeeping duties (i.e., cleaning, restocking, and organizing) on time• Executed ad hoc tasks such as researching entry requirements for the VP’s Cuba trip, verifying receipts for reimbursement, and preparing employee awards • Designed a call handling workflow diagram in Microsoft Visio to train future staff• Distributed mail daily; invented an "if/then" system for matching mailboxes to names, cutting time spent on mail distribution by >50%

• Discovered potential donors plus pharmaceutical partners for USC’s in-house addiction treatment centre. Determined CRR’s existing top donors using PivotTables• Expedited the creation of donor databases by three to four days using web scraping tools• Taught the supervisor how to use HubSpot CRM as a better alternative to Excel • Carried out core administrative tasks such as mail merging quarterly reports and reformatting messy spreadsheets left by ex-employees

• Co-planned the 25th Anniversary Image Awards to raise over $30,000• Harvested the contact info of potential silent auction donors from Yelp via web scraping• Wrote an Excel macro to consolidate donor information scattered across numerous spreadsheets• Created a Gantt chart to better track the progress and deadlines of OCA’s grant applications

- Conducted market research for clients and new services offered by yOptimize- Implemented client-focused digital marketing and PR strategies both internationally and domestically- Developed various digital marketing materials such as videos, designs, web development, etc - Managed various social media functions including but not limited to community management and content research

• Performed a PESTLE analysis of the non-profit CRM landscape in China to present market entry recommendations to the unit president• Co-authored a competitive analysis report to learn from Salesforce’s non-profit business strategy• Verified income data of the largest APAC university endowments (by cross-checking multiple lists and contacting advancement officers) to forecast market prospects• Identified three donation processing platforms in Japan for potential acquisition• Resolved inquiries by management about Singapore’s and Hong Kong’s data privacy laws

• Answered directional questions; pointed patrons to the right resources for their research needs• Enforced library rules to facilitate a pleasant user experience for all patrons• Sorted and shelved items; routinely checked shelves for missing or misplaced items• Guided users unfamiliar with library printers and computers, troubleshooting issues as needed

• Translated a text on the history of Buddhism in Malaysia from Chinese to English• Developed sensible metrics to chart the fluctuations in international support for the 14th Dalai Lama• Identified opportunities for cross-disciplinary collaboration between ARI and other institutes • Curated research resources for major projects

- Commanded the school’s flag-raising ceremony before 2,900 students and faculty members- Imparted crime prevention knowledge to neighborhoods- Oversaw drills and training camps for 15-20 junior cadets- Awarded the .22 revolver marksmanship badge