- Innovation and development of analytical products designed to expedite processes in vehicle repair and claims management software and to reduce costs for automobile insurance carriers- Comprehensive testing and parameter optimization of various predictive modeling techniques and combinations, demonstrating a high degree of technical understanding and creativity in achieving optimal results- ETL development and parsing of millions of large XML files of up to 31,000 elements; accurately following requirements of data architecture and efficiently loading the data into a relational database using Pentaho Data Integration (Kettle)- Continuously supporting senior management by conducting analysis to support important data informed decisions- Development of web applications with interactive graphics to demonstrate model diagnostics and performance in R Studio’s Shiny package to stakeholders- Published an economics study that explained the trends and seasonality of vehicle part costs as they relate to economic indices, and the Canadian automotive market’s response to the recent decline of our dollar- Completed Applied Analytics Using SAS Enterprise Miner training course at the SAS Institute in New York, NY, February 2015- Technologies: Oracle (SQL), Spoon (Kettle/Pentaho), R, SAS Enterprise Miner, Excel, Mathematica 10

- Assembled product specifications for new features in games played on iOS and Android platforms- Demonstrated how proposed features would impact key product metrics and affect business objectives- Provided in-depth data and experiment analysis in launching new titles and releasing updates- Modified existing SQL scripts that generated reports in a tableau-style BI tool to produce brand new insights that were not readily available for the team across multiple games and platforms- Studied, validated, and made improvements to taxonomy calls made by the product to give rise to new metrics to help the team better understand in-game actions and impact of new features- Designed A/B test experiments to validate the hypothesised effects of new features against a control- Held an R tutorial for the PM team focused on the application of linear regression analysis- Technologies: DbVisualizer (SQL), Balsamiq Mockups, PowerPoint, Excel, R, Tableau, GitHub

- Dove deep into Facebook’s Hive (HQL) database dynamics to derive attitudinal and behavioural metrics that evaluate the impact of advertising and marketing activities on Facebook for the Canadian Sales team- Delivered comprehensive audience insights studies including Canadian Moms, Mobile Users, and Quebecois- Investigated, cleaned and fixed broken HQL jobs that run daily for vertical benchmark reporting – enabling the team to benchmark a client’s performance against industry competitors- Applied logistic regression to build several models that predict if a FB user looks like they could be a quality fan of a particular page category – enabling clients to target a list of higher quality potential page fans and avoid legal restrictions in targeting fans of competing clients in fan acquisition campaigns- Automated model diagnostics, validation and scoring processes in R- Applied techniques including random forests, PCA, logistic regression, and variable reduction/treatment- Presented narratives of findings to the sales team, changing the way people make decisions and take action- Technologies: R, Hive (HQL), Excel, PowerPoint, Terminal (OS X), Python

- Supported insurance companies with marketing insights into their AIR MILES customer loyalty programs- Developed a high performing acquisition model identifying prospective low-risk home insurance policyholders- Statistically disproved the significance of the existing categorical risk model and proposed a new model to classify acceptable risk to the directors of analytics and marketing- Joined external and internal data by postal and FSA codes and reduced 400+ explanatory variables to a select few by applying statistical methods in SAS; reviewed methodology with decision sciences team- Automated several financial reporting processes using Excel VBA and Macros in SAS- Member of the winning team in LoyaltyOne’s Summer 2012 Co-op Business Case Competition – a two month project to define an innovative solution for a new Employee Value Proposition; rewarded the privilege of presenting to the company executives: CEO, CFO, COO, President of AIR MILES, Head of IT and Head of HR- Technologies: SAS, R, Netezza SQL, Excel, MicroStrategy, PowerPoint

- Generated insights to support business decisions involving the Nissan and Infiniti CRM program- Using PCA, determined significantly loading variables to improve cluster definitions of demographic data- Delivered a comparative study on call centre resources with respect to customer retention- Aided management in Data Mart development by determining data extraction windows and impacts to deliverables- Completed "IBM Introduction to SPSS Decision Trees" training course with The Marketing Store, March 2012- Technologies: R, SPSS, SQL Server, Excel, PowerPoint

- Deployed web application builds to testing and staging environments for the Nissan and Infiniti CRM program- Wrote SQL queries that verify the accuracy of items displayed on the front-end- Regression tested the functionality of new builds, and documented test cases regularly- Reported on the effectiveness of adopting new testing methods in MS Visual Studio over current- Technologies: SQL, Excel, Visual Studio, SharePoint

- Investigated PDF files of handwritten land registry documents dating back as far as the 18th century in an Access database in order to assemble large books on land ownership information for lawyers- Quality checked the accuracy of books assembled by other members of the team- Technologies: Access

- Wrote over 200 professional emails within 4 weeks on behalf of a mechanical engineer seeking opportunity to further develop career- Diligence and an effective writing style led to numerous responses from potential employers and ultimately the engineer’s employment with Visible Assets Inc