Robert Taylor Email & Phone Number

Vaughan, Ontario, Canada

• Reduced cost by 60% by overhauling the company's expense forms using Microsoft user forms. This streamlined process enhanced administrator and associate operations through:- Direct PDF receipt upload to the expense form.- Auto-emailing the finalized expense form to the Accounting Department and the associate's expense form approver.- Boosting productivity and reducing workload cost by compiling the Summary by General Ledger Codes.• Reduced report generation running time by 66% by converting the General and Administrative Time billing per project capitalization reports from Visual Basics for Applications to Python. Utilized libraries like pywintypes and openpyxl for direct Excel access, maintaining accuracy.• Improved operational efficiency by finding an impactful solution to reconcile the newly implemented Yardi 7S data with existing Yardi Voyager data. I used a hybrid approach that combined the Microsoft Excel compare files tool with a custom program, enabling users to select files and remove unnecessary formatting. This method streamlined the accurate comparison process within the company during the transition between systems.

Vaughan, Ontario, Canada

• Increased timesheet compliance by creating a program that automatically detects incomplete timesheets, generating and cross-referencing email reminders to Associates, dynamically adjusting based on the status of their timesheets.• Cut Development Fees calculation time by over 50% by overhauling pre-existing code, improving various functions, and enhancing reporting accuracy, leading to consistent monthly performance target achievement.• Enhanced the journal entry process by implementing patterns and templates and creating an automation tool, eliminating repetitive keying and improving overall workflow efficiency.

Toronto, Canada Area

• Maximized profits by sourcing 500+ SKUs and forecasting inventory to prevent overstock and understock.• Streamlined custom order coordination by liaising with suppliers, consolidating quotes, and supporting the sales team.• Enhanced order accuracy by auditing purchase confirmations and manifests, correcting errors, and verifying orders using original documents.

Toronto, Canada

• Overhauled Excel spreadsheets within the company to assist with inventory management and customer delivery scheduling that increased employee efficiency by automating repetitive tasks.• Trained remote teams in British Columbia by creating process and procedure documentation that helped assist in the growth and expansion of the company nationally.• Earned the Employee of the Month Award for April 2019.

Toronto, Canada Area

• Filled and rotated stock in an efficient manner.• Oversaw the closing shifts (3+ a week) including handling customer questions, comments, or complaints.• Assisted in display decisions.