Craig Wrightson Email & Phone Number

Manchester, England, United Kingdom

• Data ConsultantFor the end client (Lloyds Banking Group - Rectifications) I covered the assurance of the ‘bereavements data engine’ and supporting the management of incidents raised through investigative work & data.
• Independent coding of business requirements for validation purposes.
• Front end sampling
• Presentation of findings at varying technical levels.

London, England, United Kingdom

A short term role to help a project around environmental land management scheme deliver on time. The main aim for my role was to take a historic MS Access solution and bring it up to date loading into Dataverse/Power Apps and using SSMS (SQL) to do some of the heavy calculation. Main skill sets used: -Design & build a SQL solution to process complex data.

London, United Kingdom

This role covered a few major projects:Project Breavements Cohort 6 (April2020 - Dec2020) - Currently deceased customers with ANY open products. Project PAN08 (Oct2019 - April2020) - Previously customers marked deceased incorrectly.Project COM021 (Jul2018 - Oct2019) - major cross brand and cross product rectification & remediation project.Project Cookie.

London

• Working in the Corporate Data Repository (CDR) team my key duties were:
• Analyse complex Teradata SQL code
• Engage with Business functions at all levels to drive out Business Requirements
• Write functional and technical specifications
• Write Teradata SQL code for development change demands
• Undertake technical systems test runsCDR collates data from many source systems for reporting purposes. The project I lead was the on-boarding of Corporate clients across mainland Europe on to standard Barclays.

London, United Kingdom

• The role consisted of primarily Teradata with some Base SAS skills:
• Rebuilt historic reports & processes to be robust and automated
• Constructed a new MI reporting suite
• Analysed fraud trends and proposed & implemented fraud detection rules (Falcon)
• Supported new learning and teaching within the teamThis opportunity gave me the chance to rebuild and enhance how fraud was reported and made analysing fraud quicker and gave more confidence in the results as we could.

London, United Kingdom

• The role consisted of primarily Teradata with some SAS EG skills:
• Loading and transforming data onto Barclays Teradata platform from historic data sources.
• Optimising tables to ensure performance and supporting application extracts for operator usage.
• Requirement’s gathering and process creation to drive the mailing of customers proactively.
• Building of the MI database and reporting solution for management. Within this role I have had a great opportunity to build a variety of solutions from end to end to meet client’s requirements. The main deliverables.

Sydney, Australia

The work undertaken was to speak to the business and gather specific requirements from varying stakeholders. From this I created data processes which would build, maintain and distribute key data across Credit Risk. The main objectives were that all code had to be robust, automated, simplified so that analysts could follow and easy to amend for future.

London, United Kingdom

Summary…Reporting to the Senior Manager Post Application Fraud, I pro-actively extracted and analysed data in the assessment of Post Application Fraud trends, to create solutions for managing fraud risk across all channels. I worked closely with the Application and Intelligence teams, as well as Operations, to ensure our overall strategy is integrated, and.

• Main duty was to be responsible for the development and implementation of strategies designed to reduce fraud losses across LBG portfolios (Credit & Debit).
• I ensure fraud trends from both the industry, other sources and internally are analysed (SQL & SAS skills used predominately) and tactical responses to emerging trends are identified and deployed in an effective.
• Where possible I altered, improved and created new reporting processes which reduce the resources required to run daily activities/reports utilising my SAS skills. Most reports are now close to being fully automated.
• I have developed an array of account take-over strategies from scratch by compiling data, analysing trends, writing Falcon rules to reduce fraud spending and producing reliable and presentable MI.
• Effective fraud strategies are deployed utilizing the Bank’s strategic fraud prevention/detection tools (i.e. Falcon).
• I ensured that the performance of Falcon was regularly monitored to ensure that the strategy rule base is fully optimized reducing impact on both customers and the banks loss line.