Brian Lam Email & Phone Number

Toronto, Ontario, Canada

• Facilitated the companywide implementation project of upgrading the Yardi platform to latest version.
• Contributed to strategies for enhanced system capacity through improved automation and standardization.
• Acted as the Liaison between the developers and business users to update and create new reports.
• Created and tested workflow diagrams that document core business processes.
• Served as the Yardi software expert providing support to everyday department and advice in management meetings.

Markham, Ontario, Canada

• Primary person managing a $200 million annually budgeted cost model to record and organize forecasted project expenses. Also tracked actual cost on the cost model to compare forecast to actual.
• Managed and updated project resource allocations on Galaxy in a timely manner so that resources can correctly log their timesheets.
• Held and organized scrum of scrum meetings to discuss sprint objectives, progress, and potential risk.
• Processed and validated vendor invoices for project resources costing $100,000s in a timely manner to avoid interest Aviva interest payments worth thousands.
• Created financial accrual documents for projects at the end of every month to forecast expense for the next month.

Ontario, Canada

• Resolved multiple cases regarding data discrepancy and setup issues in a timely manner to ensure that clients can continue with their business operations.
• Managed multiple projects to implement the voyager software for new clients and upgrade existing clients to new core versions.
• Wrote SQL queries for data analysis, database updates and report modifications performed to help resolve client data discrepancies with the Yardi Software.
• Completed multiple projects acting as the liaison between our development team and the client to create custom programming reports requested by clients.
• Held weekly status calls with clients to monitor project progression, manage deliverables, and synchronize progression between different teams.

Toronto, Canada Area

• Designed workflow diagrams to illustrate business processes for various departments.
• Collaborated with project team to validate and transfer all the data from the old ERP system to the new ERP system.
• Participated in planning of restructure of company-wide security architect with upper management.
• Engaged in project meetings to discuss current problem and possible resolutions.
• Documented internal user guides for the new system specific to each department.

5925 Airport Rd #605 Mississauga, ON L4V 1W1

• Corrected Yardi Voyager settings and client data to resolve client cases.
• Presented a SQL tutorial to my team on basic SQL queries and inner joins.
• Wrote SQL packages and modified SQL report files to satisfy client needs.
• Completed projects where I created temp web shares and adjusted settings for clients.

Markham, Ontario

• Updated Company’s database to include additional entries and fixed errors.
• Created and managed Excel spreadsheets to reflect updated analytics.
• Designed a newsletter template to be used as a primary communication tool for distributors.