Download PDF

Work History

Dufrain Consulting

Aug 2015Present

Consultant

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

  • 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 repapering for all unenforceable cards accounts
  • Entailed detailed financial provision reconciliation work and development of a robust, documented CDR system compliant with Delloitte 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 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

  • Classes in Economics, Accounting, Excel Modelling, Database Design, 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

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

Data Mining

Identifying cost trends and patterns in multiple large datasets

SQL Server

Data Analysis, SQL Programming for Complex Processes

Project Management

Technical Implementations, Reporting and Analysis Projects

Other

  • Fluent German speaker
  • British National
  • Full UK Driving License