Data Analytics Generalist

Skills

Timbercreek Asset Management
Mar 2019 - Present

Business Intelligence Developer Lead

• Designed and led enterprise analytic strategy transforming from a CMR / excel based data process to an automated cloud architecture and analytic portal deployment

• Gathered requirements and designed DW model and Power BI Tabular Model for analyst enablement

• Managed team of Microsoft CSP consultants to complete production of corporate data warehouse​

• Created, developed and cost managed Azure Analytic cloud infrastructure

• Designed Power BI SaaS strategy and developed corporate Center Of Excellence delivering strategic analytics to executive team reporting directly to CEO and CFO

• Designed and developed data pipeline architecture for dynamic data transformation from multiple formats including API, Text File and Excel

• Performed internal training for financial analysts and presented business unit roadshows to drive analytic adoption

• Created sentiment analysis process for ingesting and scoring marketing customer experience surveys leveraging Python NLTK library and Azure Cognitive Services API

• Environment & Projects managed using Agile iterative methodology and ITIL for support

Interac Corp
July 2018 - March 2019

Senior Manager Advanced Analytics

• Led the implementation of the corporate BI transformation strategy from decommissioning Cognos 8.1 to multi pillar analytic stream utilizing Tableau server and Pentaho Report Designer

• Managed a team of 3 BI Developers

• Designed and presented 3 year BI strategy to Chief Data Scientist, breaking down timelines on multiple complex projects which was green lighted to action on​

• Managed analytic, research and report request intake from business stakeholders using Jira Scrum sprints

• Worked with Legal team and internal DBA to implement Data Governance Strategy

• Managed business intake request process by capturing requirements and scope assigning projects via Kanban (Jira) board

Interac Corp
February 2017 - July 2018

Advanced Analytics Specialist

• Designed OLAP data model for Data Warehouse of Debit / Flash payment solution across all dimensions derived from network traffic application

• Designed physical OLAP data model for ETransfer payment solution for usage rates as well as financial billing with custom tiered pricing formulary

• Translated technical specs for mobile payment solution applications including Apple pay and Google pay into a usage and financial model for transactions, provisions and customer lifetime cycles 

• Introduced Opportunity aggregation model used for analysis to improve user adoption by up to 10% year over year

• Performed QA and peer code review on data model development and end to end data integrity

• Worked with clients to troubleshoot data discrepancies and explain business logic applied to data warehouse transformed from raw transactional data with root cause analysis

• Developed OLAP data cubes from data warehouse as needed

• Designed Tableau dashboards for product business regression analysis

Telus Health

September 2015 -

February 2017

Business Analyst II

• PL\SQL development to automate weekly, monthly, quarterly executive aggregate reports from drug adjudication system

• Worked with internal client service reps, internal pharmacist team and external business analysts for major health insurers (Sun Life, Great West Life, Standard Life etc.) to develop drug / dental / multi benefit claim analytic models

• Provided data cleansing and analysis on new drug formularies and policy strategies, including Evidence Based Drug programs and multi-tiered pricing based on prior authorized drug formularies vs physician over ride scripts

• Provided Ad Hoc reports to major insurance carriers for policy formulary analysis, generic vs brand drug pricing analysis, claim count vs card count for profitability forecasting, prior authorized vs exception models and realization analysis of pilot formulary projects

• Developed and optimized drug pricing ETL processes to consolidate drug pricing tables from external sources Medis and McKesson price files with internal drug pricing lists

• Developed windows application text file reader as part of an ETL project to automate data entry from paper claims into database saving over 450 manual hours annually

Transcore Logistics
March 2015 -
September 2015

SQL Developer / Analyst

• Developed first national industry Rate Index regression algorithm measuring rate per mile / fuel surcharge across all shipping channels and market lanes in North America, used as a universal measure for the land shipping industry trending, pricing and forecasting.

• Designed complex custom ETL process mining data from multiple different sources including Web Services, XML, database replication, csv files and in house data base to consolidate into one data model to track industry index

• Worked with Business Analysts and Product Manager to offer data insights and refine data model ensuring data validity, accuracy and meaning including developing a rolling time and currency exchange standard deviation formula to scrub outlier data points.  

• Increased Average Revenue per Customer up to 10% per upsell of subscription to new data model service

• Developed Cohort Lifetime Value data model on initial activation of new product based on subscription spending revenue segmentation

• Worked with front end web development team to create optimized stored procedures OLAP data model

Bell Canada

February 2014 - May 2015

Buisness Intelligence Developer

• Developed customer experience scorecard application 

Bell Canada

April 2010 - February 2014

Application Developer

• Maintained Bell Business Market Datawarehouse

• Designed and developed internal CMS and document repository