Download PDF

Work History

Dufrain Consulting

Aug 2015Present

Consultant

Shawcor | Image Analytics Consultant (May 2018 - present)

  • Identified and acquired the opportunity to contract image recognition work to Shawcor
  • Supported development of image identification process and enabled users to interact with image recognition functions by creating and integrating Jupyter widgets interface and deploying on AWS cloud server

The London Sock Co. | Web Retail Analytics Consultant (Jan 2018 - May 2018)

  • Extracted guiding marketing insight from online subscription and transactions data through a guided dialogue and intensive analysis and modelling of the data available
  • Derived analysis methodologies to measure and present subscription conversion value, acquisition channels, customer value, forecasted sales, customer purchasing behaviours, promotion effectiveness

Sainsbury's Bank | IFRS9 Model Assurance Consultant (Nov 2017 - Jan 2018)

  • Supported model assurance lead by providing critical feedback on model documentation for all models and products

Tesco Bank | Credit Risk Model Analyst (Jul 2017 - Nov 2017)

  • Created a suite of MI for benchmarking and monitoring performance of IFRS9 models
  • Developed technical understanding of SAS-coded PD, EAD, and LGD models and wrote code to apply model scorecards and auto-compare performance over different periods
  • Provided an accessible Excel MI interface by programming VBA scripts to interact with SAS server macros

Tesco Bank | Modelling Data Analyst (Apr 2017 - Jun 2017)

  • Created and documented a robust understanding of a customers’ data journey for the modelling data-build
  • Self-generated a network of contacts and knowledge resources across the Bank (in Collections & Recoveries, Credit Risk, AML, Provisions, Analytics, and Data Services)
  • Ascertained customer interaction touch-points within the Bank’s systems through exploratory interrogation of cryptic data sources such as Debt Manager, SAS scripts, and technical documentation

Tesco Bank | Customer Documentation Review (CDR) (Nov 2015 - Mar 2017)

  • Managed and delivered the data-analytic elements of  the credit cards NOSIA (Notice of Sum in Arrears) remediation project to ensure account enforcability, arrears reprofiling, accurate remediation, and re-papering for all unenforceable cards accounts
  • Scoped, built, tuned, and maintained a remediation calculation system in SAS (compromising 34 programs and >40k lines of code) and trained three other consultants to use it
  • Entailed detailed financial provision reconciliation work and development of a robust, documented CDR system compliant with Deloitte audit standards
  • Financial remediation activities involved phased releases involving devising, coding, testing, and executing 18 file interface steps per release across 8 different business areas within and outwith the Bank
  • Received excellent 360 degree client feedback and highest performance rating across all 5 areas in 2016 performance review

Tesco Bank | Financial Services Compensation Scheme (FSCS) Reporting (Aug - Nov 2015)

  • Upgraded the Bank's FSCS Single Customer View (SCV) reporting process (deposit accounts) to ensure compliance with 2015 regulatory framework
  • Mobilised project support across commercial, operations, and analytics teams to implement a responsive SAS-based business solution

Palantir Economic Solutions

Feb 2014Aug 2015

Consultant

Shell Global | Planning One 2015 Stabilization Project

  • Delivered reserves system process improvements across 11 countries in four continents (4-month workflow, 17 customized economic models, >300 assets). Changes resulted in process simplification, global process consolidation, and system speed improvements worth an estimated $650k value added
  • For each country, liaised daily with planning heads, reservoir engineers, senior economists, reserves system programmers and Palantir consultants to scope, agree and implement all key project phases of the workflow (scoping, design, UAT, and implementation)

Shell UK | Business Plan 2014 Consulting

  • Enabled UK economic and asset portfolio analysis for the annual business planning cycle (400+ projects, 25 North Sea assets/fields, daily mtgs with senior UK economists and planning managers)
  • Resolved complex economic/fiscal modelling and multi-system interfacing problems

Consulting Support Projects

  • Supported roll-out of Maersk, Dana, and Taqa implementations by developing VBA and Palantir tools for data-management, economic modelling, and portfolio analysis and reporting

British Gas Smart Metering

Feb 2012Feb 2014

Stranding & Revenue Analyst

  • Created the BGSM stranding charge estimation model from first principles. Managed stranding model analysis and monthly financial workflows for its initial 1.5yrs of operation
  • Worked extensively with BGSM's finance team as well as internal and PwC auditors to build strong business resilience into the £37M stranding accrual management process
  • Interacted monthly with Meter Asset Providers (MacQuarie and Meterfit) to enable billing relationships, discuss contractual performance, and resolve dispute areas around MAP revenue and stranding obligations
  • Progressed various ad-hoc and routine analysis initiatives to mitigate and resolve high stranding charge liabilities: no-fault-found investigations, industry data reconciliation exercises (e.g between National Grid, MAP, and Industry Flows data), asset returns lifecycle analyses, and extensive SAP metering data interrogation work
  • Re-engineered the warehouse logistics workflow to enhance data capture enabling enhanced insight through accurate monitoring of asset movements
  • Achieved ‘Exceeding Expectations’ performance rating from Strategic Partnerships team for 2012 and 2013

British Gas Smart Metering

Jan 2011Feb 2012

Data, Rostering, and Business Information Analyst

  • Drove operational business insight through BGSM's early Smart Metering roll-out period by developing operational insight tools and working extensively with field, call centre, scheduling, planning managers, and senior leadership
  • Provided completion rate analysis, incomplete job analytics, call centre and field scorecard tools, jobs tracking databases, hand-held terminal failure contingency data solutions, and Smart Meter functionality trial analytic support
  • Achieved 98% feedback rating in 360◦ stakeholder assessment

Counter Intelligence Retail

Nov 2010Dec 2010

Consultant

  • Promotion data modelling provided travel retail marketing insight to the consulting team

NHS East Riding of Yorkshire Primary Care Trust (PCT)

Sep 2009Sep 2010

Performance Analyst

  • Provided a solid reporting base for the PCT's routine submissions. Performed service evaluations and analysis for clinical heads

Utah Valley University-Office of Institutional Research

Sep 2006Oct 2008

Research Analyst

  • Produced survey data analysis on student retention behaviour, FLOW psychology, and institutional performance

Education

Marriott School of Management

20052007

M.P.A

  • Economics, Accounting, Excel Modelling, Database Design, Public Finance, Applied Calculus, Investment Instruments
  • Consulting Field Project: Hewlett-Packard USA - 'Warranty Benchmarking'

University of Aberdeen

19972003

M.A English

  • ERASMUS study abroad (Vienna, Austria)
  • Two-year gap (1998-2000) in studies to serve full time mission for the LDS Church (Frankfurt am Main, German-speaking)

Certifications

SAS

May 2016present

SAS Certified Advanced Programmer

Advanced Programming certification exam (80%)

SAS

Apr 2016present

SAS Certified Base Programmer

SAS Base Programmer certification exam (90%)

Johns Hopkins University - Coursera

Sep 2015Nov 2015

Data Science Specialization

The Data Scientists Toolbox (86%)

R Programming (87%)


Chartered Institute of Management Accountants

Sep 2010Jan 2014

CIMA Cert BA

CIMA Certificate in Business Accounting

Skills

Python/R Programming

Fluent in popular data manipulation and machine learning packages in Python and R

SAS Programming

Financial Modelling, Analytics, Data Analysis

Excel Modelling + VBA

Economic Valuations, Automated Scorecards/Reporting, File Manipulation, Database/SAS Interactive programming

Business Analysis

Requirements and Solution Scoping/Design, Regulatory Interpretation, RACI mapping, Swimlane/GANTT planning 

MS Access + Jet SQL/VBA

Financial Modelling, Data Analysis, VBA & SQL Programming

Web Design

Basic HTML and CSS web design skills

SQL Server

Data Analysis, SQL Programming for Complex Processes

Project Management

Technical Implementations, Reporting and Analysis Projects

Other

  • Substantial Volunteering Experience with the LDS Church (including Full-time Missionary, Treasurer, and Youth Program Leader roles)
  • Fluent German speaker
  • British National
  • Full UK Driving License