Benjamin Bortey

BENJAMIN BORTEY-- – Toronto SUMMARY OF QUALIFICATION Experience with using SQL to analyze data through previous work experiences Experience with Microsoft Excel through previous data analytical projects 3 years of experience with E-commerce through previous work experiences WORK EXPERIENCE / PROJECTS Penguin Pickup05/2020 – Present eCommerce Associate Developed analytical skills and E-commerce experience through the tracking of parcels Microsoft Excel and analytical skills are developed through the making of dashboards and data cleansing 2 times a day Providing support and assistance to customers over the phone and in-person Worked with companies like Ikea, Purolator, FedEx, and DHL Fast-paced environment Walmart06/2019 – 11/2019 eCommerce Associate Developed analytical skills and E-commerce experience through tracking online orders Analyzation skills and dashboard making skills were displayed by using computer software like Microsoft Excel Completed merchandising task through the uses of OIF (Online Item File) Provided support and assistance to customers over the phone Fast-paced environment Meridian Credit Union Client Project 09/2018 – 12/2018 Research Analyst Market research abilities showcased through the uses of ComScore Detailed how the created marketing campaign would be managed Data analysis skills displayed through the creation of one-way frequency tables Cape Codd Outdoor Sports Sales Analytics 09/2018 – 12/2018 Data Analyst Analyzed the sales of the Cape Codd Outdoor store by generating SQL queries to record, compare, and manipulate the data. Modified any corrupted and inaccurate data through the process of data cleansing. Queries were made by using SELECT, FROM, WHERE, JOIN, UPDATE, ON, GROUP BY, and wildcards. Used different types of joins like inner joins, left joins, and right joins to combine rows from different tables. EDUCATION Algonquin College08/2019 – 08/2020 Business Marketing The University of Toronto Rotman School of Management 01/2017 – 06/2017 Integrative Thinking Leadership Program Reference available upon request