John Pan Email & Phone Number

Toronto, Ontario, Canada

Capitalized on a niche market during quarantinePitched to landlords from Kijiji and various other rental websites why they should choose our rental servicesStrategically marketed their homes on various platforms and have viewings to potential tenantsUtilized Squarespace to create a simple and effective website to display all current available rentals

Toronto, Ontario, Canada

Contract Classification Project:Analyzed the amount spent in different contract types and discovered potential gaps in the system for the Governance Team to improve the process Cooperated with different Business Units to understand the Database in Oracle and to identify the correlation between the physical processes and the flow of information within Oracle Established the complete process map and created a master database in ACL as well as collaborated with the business Unit and the Governance Team to set controls in place for future applications Generated Qliksense Dashboard for Amount flowing through Purchase Orders to help the Business Unit process PO utilization and overpayment Vendor Negotiation Project: Diagnosed the issues generated due to system migration and assisted the Business Unit obtain the harmonized information for the requested vendors through ACL and Qliksense Collaborated with the Business Unit to bridge the information currently missing in the Oracle Database to provide the essential information for the negotiationsData Mart Project:Lead the QA Testing phase for the Business Unit to pinpoint potential gaps in the design, transferred the Proof of Concept in ACL to the AX Exchange client and banded with the Vendor Unit to resolve issues in the design

Toronto, Ontario, Canada

Performed valuation of hedge funds’ portfolio holdings and critically analyzed their day to day performances Demonstrated analytical skills through preparing daily and month-end performance/profit and loss reports Effectively utilized excel macros to automate several daily analytic tasks Through research and due diligence, priced OTC securities (stocks, bonds, money market instruments) Contributed to the monthly Net Asset Value process by performing Independent Pricing Verification

Richmond Hill, Ontario, Canada

Effective communication skills in a B2b market contributed to my being the most successful co-op student ever (for comparison within my work term, I sold roughly 9x the quantity that the other co-op students sold) Demonstrated initiative by researching the industries and products of prospective companies the night before to prepare next day’s call plans Excellent time management skills and previous night’s planning led to 2x the call volume of past co-ops Data enhancement and data mining lead for CRM for the generation of qualified leaf for the sales force Formulated new pitching styles and company expansion strategies with the Director of Sales after analyzing marketplace changes and faults with our current sales strategy