Experience:

Financial Database Designer Jan – Sep 2017

Manulife Financial Corporation

• Worked with the Senior Financial Analyst to design a solution to complete month-end PlanRight Sales Reporting in a timely manner, allow for dynamic ad-hoc reporting and to help develop KPIs and a management package for the PlanRight team

• Developed an object-relational database management system that stores and analyses large amounts of historical Sales information retrieved from multiple systems across the Canadian Division in one standardized repository while maintaining data integrity

• Automated the End of Month, Quarter and Yearly process by utilizing VBA in Excel, Microsoft Access, and Microsoft SQL Server thereby reducing/eliminating the risk of human error

• Tested the accuracy of the automated process' output by cross referencing data using Microsoft Excel v-lookup and pivot tables

• Collaborated with team members to find significant trends and other ways to approach analyzing the data mined within the newly constructed data warehouse

• Developed training solution structure, maintenance, migration, and continual improvements instructions for the new process

• Reduced the time spent on monthly sales reporting through a reduction of manual work by at least (1) business day

Assistant Resource Management Technician Jun – Sep 2016

Ontario Ministry of Natural Resources & Forestry

• Improved functionality and user experience of Aggregates database by scripting and testing SQL & VBA queries in MS Access

• Created, organized, and lead meetings regarding formulating, managing and piloting inter-district scaled projects including a large GIS-based project using ArcGIS

•Utilized risk-based compliance assessment approaches to create maps and built spatial databases to include year-end reporting

• Updated shapefiles for fisheries and waterbodies data spanning Eastern Ontario in ArcMap and submitted missing data to the Provincial database using the Land Information Ontario (LIO) Editor

• Conducted various data manipulation, spatial and attributional analysis via. ArcMap and Python and exported data to Excel for data accessibility and comprehension amongst staff

• Conducted research using numerous publications and presented findings to management biologists

• Researched and recommended appropriate Class EAs for fisheries rehabilitation and stocking feasibility report presented to biologists

Customer Loyalty Coordinator Jan – Aug 2015

BlackBerry Ltd.

• Provided guidance on sensitive stakeholder complaints in both English and French under tight deadlines to associates, customers and aid ad-hoc reporting to senior level managers

• Collaborated with various teams such as Legal, Social Media, and Manufacturing to provide services to both internal members and customers

• Identified and drove support process improvement opportunities minimizing scale of repetitive complaints by recognizing a problem, created and proposed a new process to handle future incidents

• Created process documentation for training of future co-op students including SalesForce use for given position and team reference

•Professional experience with SAP, JIRA, Salesforce, and QlikView

Document Control Clerk Jun – Aug 2014

Salumatics Inc.

• Efficiently prepared and kept track of medical records from an array of hospitals

• Verified patients' records by putting into practice detail-oriented order format and followed all precise organizational protocols

• Retrieved patients' files requested within specific turnaround periods

• Demonstrated Excel and accounting skills by performing formula calculations when aiding in payroll and bookkeeping procedures of employees' weekly hours

Education:

Certificate in Data Science

University of Toronto

Sept 2018 - Aug 2019

Bachelor of Honours Environment & Business Co-op

University of Waterloo

Sept 2013 - April 2018

Applied Technical Skills:

Languages, Frameworks & Libraries

Python - Numpy, Pandas, Sklearn,

Seaborn, Matplotlib, Scipy

SQL

R

Java

Scala

HTML

XML

CSS

Visual Basic for Applications

MapReduce

Applications, IDEs & Research SW

SPSS

Microsoft Suite (Incl. Access)

ArcGIS (ESRI)

BlueJ

Oracle SQL Developer

MySQL Workbench

RStudio

Jupyter

ImageJ

Adobe Illustrator

Tableau

Feature Manipulation Engine

Android Studio

Sublime Text

Eclipse

MongoDB

Spark

Applied Theoretical Skills:

Supervised & Unsupervised Learning

Logistic Regression (I & II)

Classification Analysis (Discriminant & Cluster)

Principal Components Analysis (I & II)

Support Vector Machines

Clustering

Time Series Analysis

Spatial Analysis

Relevant Courses:

• Spatial Databases

• Geographic Information Systems

• Principles of Industrial Economy

• Corporate Sustainability Accounting & Reporting

• Business Law

• Marketing & Consumer Economics

• Research Design

• Business Finance

• Advanced Environmental Research Methods

• Accounting Information for Managers

• Strategic Management

• Engaging Stakeholders

• Money & Banking I

• Microeconomic Theory for Business

• International Corporate Responsibility

• Cost-Benefit Analysis & Project Evaluation

• Computer Science I

• Data Organization for Data Analysts

• Data Analytics: Basic Methods

• Computer Science II

• Big Data Management Systems & Tools

• Statistics for Data Science

• Data Structures & Algorithms

• Machine Learning

Contact this candidate