Christopher Mcfarlane, Mba Email & Phone Number

• Built and designed reporting and administration structure for newly established company in pharmaceutical industry• Automated statement creating and publishing process in Excel with VBA, reducing the process time to approximately 3 minutes from 1 hour• Created reports for committee meetings, assembling data from multiple sources, cleaning the data, and performing analysis• Engaged closely with partners to develop and expand reporting capabilities

Toronto, Ontario, Canada

• Achieved a 30% reduction in completion time for major reports by leveraging VBA automation to streamline Excel spreadsheets• Consistently produced timely month-end reports with exceptional attention to detail• Proficient in developing complex SQL queries, including expertise in crafting efficient and effective Access queries for data retrieval and analysis• Responsible for end-to-end management of billing process, including data extraction and journal generation for SAP upload• Utilize SAP query tools to extract and analyze data

Toronto, Ontario, Canada

• Redesigned Excel spreadsheet templates and automated tasks that led to decreased completion times of at least 25%• Audit and analyze daily revenue integrations assessing accuracy and reasonability• Prepared monthly revenue and transaction volume reports• Managed and maintained 20 revenue clearing accounts• Prepared corrective journal entries for managed accounts

Mississauga, Ontario, Canada

• Used Microsoft Access to research client accounts, export data and create reports in preparation for invoicing • Created and posted invoices, credit notes and general journal entries with Microsoft Dynamics• Generated weekly inventory reports in Microsoft Excel using VLOOKUP function• Liaised with document specialists and other stakeholders to acquire data and documentation needed to complete invoicing process

Ontario, Canada

• Monitored and aided in the reduction of partner’s accounts receivable metrics with monthly and ad hoc Excel reports • Monitored and analyzed partner’s gross revenue data ensuring partners maintain and surpass monthly targets with monthly Excel reports and insightful recommendations • Led the invoicing process for assigned accounts and teams of partners, determining fees and expenses charged

Toronto, Canada Area

• Maintained sub-contractor invoice and pricing data with close to 1,000 rows using advanced Microsoft Excel functions (IF, SUMIF etc.) • Created at least five quotes a day for clients with Microsoft Excel, especially VLOOKUP• Excelled in project to update nearly 100 backlogged invoices to Account Payable system within 3 days

Toronto, Canada Area

• Successfully maintained clients’ policies in good standing by processing credit card transactions within 1 business day• Researched and provided information to brokers and clients within 24 hours• Kept brokers and clients up to date on the status of their accounts

Toronto, Canada Area

• Exceeded store’s sales targets by 10% as part of the retail store team• Consistently met and surpassed customers’ expectations using excellent customer service skills

• Conducted research on market size and trends, competitors, pricing strategies, etc., analysed the data and used the results to develop business plans and tactics for potential small business owners• Used Excel to analyse data and create financial models predicting future outcomes • Guided small business operators on business strategies, business process management, and entrepreneurship through presentations at workshops and seminars• Collaborated with the Small Business Association to spearhead the marketing and sales of its ERP software • Worked with NGOs and public agencies to develop policies to govern small business

58 1/2 Hagley Park Road Kingston 10

• Developed and implemented strategies to manage the company’s foreign exchange operations, turning a loss of $1.5 million into a profit of $4.9 million• Successfully implemented new processes that led to an improvement of 11% in debt collection ratio• Led and supervised a staff of 6 in improving key performance metrics

4 Park Boulevard, Kingston 5

• Researched monthly cash revenue and prepared a report of the cash flow analysis providing actionable insight into the company’s financial position for board meetings • Prepared reports explaining variance analyses, account reconciliations and other ad hoc requests for over 50 accounts monthly • Effectively managed the operating budget of more than 30 departments, ensuring costs were kept within budgetary guidelines• Analysed and prepared the investment sub-ledger in time for the annual financial audit for the first time in the company’s history

Certificate, Advanced Data Science And Predictive Analytics

Certificate, Big Data Analytics

Ontario Graduate Certificate, Global Business Management

Mba, Banking & Finance

Activities and Societies: Rotaract club of New Kingston

Bachelor Of Science - Bs, Management Studies And Accounting

High School Certificate

Activities and Societies: Wolmer's Boys' Rotaract Club, Wolmer's Boys' Key Club