Managed national generic pharmaceutical database in MS Access, processing 500+ data points per month to produce price lists, records, and reports. Provided quantitative analysis for generic department. Delivered advanced MS Excel pivot tables to support the accounting department in their vendor reconciliation and the generic program in their annual drug contract negotiations. • Liaised between internal and external stakeholders including the generic department and its management, accounting, IT department, stores nationwide, and key program vendors • Prepared monthly and quarterly vendor reconciliations using MS Excel pivot table reports • Maintained pharmaceutical database for generic drugs program using MS Access and SQL queries • Provided quantitative analysis reports, internal price lists

Primary liaison and business analyst for five clients, including internal and external stakeholders. Implemented and supported SaaS loan origination business systems, configured and designed dashboards and user interfaces. Managed implementation project for one of BC’s largest auction companies, delivering a 300-page report including GAP analysis, requirements and solutions design documentation. • Created GAP Analysis, business requirements document (BRD), and solutions design documentation • Designed and configured dashboards to achieve client KPI and business process requirements • Conducted application training for customers and created user documentation • Assisted in UI design and documentation using Balsamiq wireframing tool • Facilitated product roll-out, resolving customer environment issues • Coordinated and participated in QA activities, UAT testing, and product support (Zendesk) • Assisted project managers in managing progress updates, project timeline and milestones

Provided business analysis and project management services within the NCCABC’s Changing Directions program for the implementation of Efforts to Outcomes case management software. Provided key analytical and quantitative reports which allowed stakeholders to uncover issues and proactively address KPI deficiencies before funder reporting deadlines. • Acted as primary liaison between NCCABC stakeholders and external software development team • Analyzed, documented, and communicated stakeholder needs via translating reporting requirements into software requirements • Created business analysis deliverables including GAP analysis, solutions design documentation, statistical, strategic, and quantitative reports, and presentations • Developed professional presentations for management including animations and timing using MS PowerPoint, Publisher, and Word • Designed and configured software for user interfaces, forms, dashboards, and reports • Worked with software packages including Social Solutions’ Efforts to Outcomes case management software, Adobe Acrobat, MS Excel, Access, Word, OneNote, PowerPoint, Publisher • Developed Training program deliverables including: learning library, presentations and pamphlets, questionnaires, screen-capture training videos

Performed full-cycle accounting services, developing business relationships with clients across many industries. Performed special Excel projects for clients including business models, tax analysis, projections, and ad-hoc reports. • Performed corporate T2 tax filings, notice to readers, corporate and strata audits, and accounting IT functions • Prepared year-end audit documentation including financial statements, revenue analysis reports, engagement letters, and management letters • Utilized time budgeting software, created and utilized project management & reconciliation templates • Performed full-cycle bookkeeping for corporate clientele including bank reconciliations, accounts payable, accounts receivable, payroll, corporate and sales tax reconciliations

Provided accounting services for Simkin business entities. Delivered reports, disbursements, and documents for roster of over thirty artists including Marianas Trench, Nickelback, and Carly Rae Jepsen. • Processed accounts payables and receivables, performed detailed revenue analysis, billing disbursements, prepared invoices and statements using Record Maestro, Intuit QuickBooks, Microsoft Excel • Performed inter-company transaction tracking and reconciliation of funding initiatives

School of Business, Bachelor of Technology in Accounting