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 insights. Main skill sets used: ● Independent coding of business requirements for validation purposes.● Front end sampling ● Presentation of findings at varying technical levels.

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 queries. -Loading of data ino Dataverse-Rigorous testing & documentation throughout.

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 (19/06/2017 - Jul2018) - delivered mis-sold Packaged Bank Account rectification strategies.Main skill sets used: TSQL processing of large volumes of data. Requirements gathering & prototypingCreating comprehensive central data repository for multiple downstream users(both Technical & Business) using Teradata & TableauImpact Analysis / Reverse engineering /troubleshooting data anomalyPlanning & building continue enhancements & functions to add valueManaging full life cycle of multiple mailing campaignsCreating actionable insights using Teradata SQLData cleansing on multiple data sourcesConducting 3 way testing to ensure accuracy of data/results

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 technology platforms. I did this using UNIX as a driver for the Teradata code and version control through Perforce software.

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 track back from source to contact. Being able to utilise my Teradata skills to produce new analytical data-sets which contained newly acquired data to enhance the teams capabilities was rewarding.

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 were that the solutions had to be robust, future proof as much as possible and be efficient to run and re-run on both ad-hoc and batch basis.

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 requirements. This was achieved by using SAS as a driver for the process and final finesse, while Teradata stored and processed large volumes of data. I have utilised a combination of techniques to improve the speed and efficiency of how SAS/Teradata communicate with each other which reduced the need to pass volumes of data unnecessarily, also reducing the drain on resource during the processes. During the work I held regular presentations with varying levels of stakeholders to provide insight into the work and encouraged a contribution of ideas for more innovation. During the work I managed two people ensuring workloads were distributed according to their skill sets and provide support.

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 to see solutions through to implementation.I was an expert (SME) in Post Application Fraud procedures, SAS, SQL, GRID/Data Warehouse and enhanced programming skills and technical abilities. I undertook the production and analysis of information for Post Application Fraud to support our decision making process and recommend solutions to enable Fraud Detection rules/strategies be implemented/amended ensuring we minimised loss and maximise revenue.I ensured the collection of appropriate data and create, maintain and improve information models so that effective analysis takes place for the business area supported, adding commentary to enhance understanding as appropriate.I contributed to the preparation and analysis of information for the planning, budgeting and forecasting process, compiling reports and other information to ensure business areas are aware of their performance and any variance from agreed targetsI ensured the preparation of information for and collate process outputs from other business units, for onward delivery to the business areas supported.I did liaise with internal and external service providers concerning enhancements to computer systems and assist with any user testing and implementation, ensuring changes are made to improve operational efficiency and to reflect future business requirements.I identified, recommend and implement agreed changes to support processes to reflect business needs and operational requirements, communicating these across assigned area of responsibility where appropriate.

• 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 analytical manner.• 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 and scheduled to run and distribute outputs with minimal resource. • 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. • I always ensured that the impact on genuine customers, income, and future profitability and operations units are fully assessed and considered when new strategies are proposed and deployed.• I have been heavily involved in UAT testing and implementation of Falcon USPP which involved a complete Falcon upgrade to 5.2c, Fraud Predictor & new server hardware which was delivered on time and under budget. For this our small team received an award and recognition from high level management.