Leanne Masters Email & Phone Number

Manchester, England, Gb

Newbury, Berkshire, Gb

Newbury, Berkshire, Gb

Red Leaf Property Solutions is a family run property investment business based in the North West of England. We pride ourselves on being open and transparent in everything that we do. Simplicity is key.​Our vision is to provide the best property experience for investors, homeowners and tenants.

Salford, England, Gb

Revenue and Margin Assurance (RMA) is a niche team within TalkTalk with the goal of providing assurance over internal processes to ensure that customers are treated fairly and TalkTalk are able to identify and remediate any cost or revenue leakage.As the Lead Data Engineer and Controls Development Manager, I am responsible for strategy and technical leadership of the Controls Development Team within RMA. Key ResponsiblitiesWorked with the Assurance teams to understand their needs and created and implemented a request process using a hybrid Agile approach - this facilitated a more structured approach to work whilst maintaining the flexibility required by the wider teamIntroduced Power BI into RMA and worked with my team to define standard templates and look and feel for all reports and dashboardsCoached the data engineers on how to approach problems and delivering positive outcomes in the most efficient wayImplemented documented best practice in design, coding, and testing standards within the team, new ways of working and improved development practicesProactively initiated activities to source previously unavailable data sources for use within the RMA team and implemented a backlogAccountable for key technology supplier relationshipsResponsible for owning the GDPR compliance for Revenue and Margin AssuranceLine management for four direct reportsProjectsDeveloped a single consolidated view of key data points in SQL and ADF - this was used to identify £150K worth of savings for TalkTalkBuilt a control for reconciling an OFCOM policy for Automatic Compensation to ensure that TalkTalk customers were compensated correctly and that TalkTalk received the correct payments from our suppliersHas technical ownership over the preparation for a migration from Phixflow to Azure Data FactoryAccountable for a successful migration from a Netezza Database to an Azure Synapse Database Tooling:Azure Data Factory, Azure Synapse, SQL, ETL, Power BI, Phixflow, Agile

Salford, England, Gb

As a Senior Data Engineer, I built and maintained the data ingestion, transformation and analytics solutions which support the RMA function as well as supporting the Lead Data Engineer in improving the ways of working, tooling and standards.Key ResponsiblitiesWorked with business partners in RMA to understand, elicit, document and challenge requirementsCompleted data discovery across multiple large and complex data setsDesigned and built automated ETL processes using Phixflow (ETL and analytics tool) across semi-structured and structured data formatsBuilt self-service reports and standardised outputs to allow Business Partners to access and interrogate their dataChampioned best practice in design, coding, and testing standards within the team, helping to implement new ways of working and to improve development practicesEstablished Confluence as the team's documentation source replacing ad hoc Word documents and emailsProvided technical support on existing developmentsShared technical knowledge with team members and provided innovative solutions to existing problemsCoached and supported junior members of the teamTooling:Phixflow, ETL, Netezza, SQL, Confluence, Aginity Workbench, Analytics

London, Uk, Gb

As the Senior Subject Matter Expert in Financial Crime, I provided technical leadership and authority to the CCTM application team, was accountable for cross project technical support and managementKey responsiblities:Supporting the Lead Project Manager in planning, resource allocation and prioritisationWorking with Technical Architects to define and agree strategy and technical roadmap and apply this to projects to ensure that design and deliverables maintain strategic view and comply with roadmapManaging a team of up to 12 developers and technical leads both onshore LBG colleagues and offshore partners to ensure a successful project deliveryAccountable for Impact Assessment preparation and sign-off and all project deliverables including documentation and code.Line management of three colleaguesRun daily/weekly project and platform-wide meetingsReceived Delivering Excellence Award in 2016 and 2017

London, Gb

I was the sole architect tasked with transforming ION Trading’s sales management reporting from Microsoft Excel spreadsheets to a consolidated data warehouse and integrating with the in-house built BI toolKey responsiblities:Design and build of PL/SQL packages to load data from flat files, into a staging schema for difference checking before loading into the data warehouseBuild and manage a team of data warehouse developers – actively seeking opportunities to place them and identify areas where their skills could be enhancedDimension modelling and establishment of facts following the Kimball methodology in order to convert large, complex data sets into understandable, business-ready informationImplementation of ION Trading’s proprietary reporting BI toolArrange and lead workshops with business users to identify future projects and support the requirements gathering processPoint of contact for all data-related queriesRun daily/weekly team meetingsDistribute work amongst team membersCoaching, leading and mentoring less experienced team members and colleaguesConsolidation of multiple Salesforce instances into a single group-wide instance Training on MR ARC (ION Trading’s BI tool) and SQL to allow end users to self-serveTooling: Oracle 11g, Oracle Application Express, ETL, Data Warehousing, Star Schema, Data Analysis, SQL, Reporting

Hartford, Ct, Us

As the Business Intelligence Team Lead, I was responsible for the day-to-day running of the BI team.Key responsiblities:Creation of new dimensions and facts within the existing Data Warehouse following the Kimball methodologyDesign and build of PL/SQL packages for both new and existing applications, including maintenance and troubleshooting of production environmentsDevelopment of custom PL/SQL ETL for a data warehouse implementationCreation and maintenance of complex Oracle Reports, including equity management, actuarial and customer service daily operational reportsImplementation and administration of Oracle Discoverer 10g End User Layer and build of associated workbooksDevelopment and maintenance of OLAP cubes using Oracle Analytical Workspace Manager (AWM), including training of Excel OLAP Spreadsheet Add-In to end usersPlan, schedule and monitor the day-to-day work of the BI team. Agree priorities and forward planningManaging the Report Request function to allow business areas to request and prioritise their reporting needsOn-call batch supportKey Projects:Woodbury Financial Services’ Data Warehouse – Sole architect and developer for the creation of WFS’s data warehouse using the Kimball methodology, Oracle External Tables, PL/SQL packages and Linux shell scripts. MI Lapse Analysis – Responsible for the analysis and development of the MI lapse-reporting project. Liaising with directors, senior team members and the chief actuary to identify the KPIs - developed to integrate complex calculations into a PL/SQL package in a reusable and robust design.OLAP Sales Cube – Developed a prototype OLAP Sales cube aiding the targeting, forecasting and reporting of sales figures. Expanded to include additional dimensions/facts and rolled out across multiple business functions. Responsible for prototype, presentations, all development, testing and support.Tooling: Oracle 10g, Oracle Discoverer, Oracle AWM, Oracle PL/SQL, Data Warehousing

As a Senior Analyst Developer and Team Lead, I was responsible for project teams of up to 7 developer (in-house and contractors) with the goal of delivering our projects on time, to the highest standard and within budget.Key Responsiblities:Develop and maintain PL/SQL packagesDevelop and test Oracle Forms, Menus, and Reports through the Oracle Developer Suite100% Generation of Oracle Forms and Menus through Oracle Designer 6, 6i and 10gManage customers and their expectations by building strong working relationshipsManage all development changes during the project lifecycleManagement and training of the development teamReview and clarify business requirements and prepare functional specifications to be developed and delivered by my teamCoordinate project handovers to the support team upon completionProjectsAnti-Money Laundering – Creation of a PLSQL package to identify unusual trading activity and to facilitate mandatory returns to US regulatory bodies. Responsible for all development and testing. 10g Upgrade – Upgrade of all Global Markets’ application systems from Oracle Forms 6 and 6i to Oracle Forms 10g. Responsible for preparation of shared libraries, object libraries and environments.Customer Maintenance System – Enhancement of Customer Maintenance System to facilitate storage of additional information required for Basel II returns, through Oracle Forms, Reports. Developed generic auditing and dynamic interface capabilities, through PL/SQL. Other projectsThird Party Interfaces – IBSNET, MUREX and Algorithmics

As an Oracle Analyst Developer I was part of a small team of developers responsible for delivering projects for BOI Global MarketsKey Responsiblities:Preparation of functional specifications Develop Oracle Forms and Reports through the Oracle Developer Suite100% generation of Oracle Forms and Menus through Oracle Designer 6iDevelop and maintain PL/SQL packagesLiaise with business users to ensure that expectations are managedProjectsCustomer Accounts System – Creation of a new application to input and manage customer account information, bank drafts, cheques.

Participated in the 1-year IT Graduate Programme with Bank of Ireland Treasury and International Banking (former name for Global Markets). Assigned to a project team for this period and continued as a full-time team member after the year.ProjectsForeign Exchange System – Creation of a new application to manage the foreign exchange details of Global Markets. Developed the front-end interfaces (Oracle Forms and Reports), supported UAT phase and provided production support.Message Repository – Creation of a new application to manage the payments needs of Global Markets both inwards and outwards.

Msc Data Analytics

G.Dip, Computing

Bsc, Management (Hospitality Management)

Leaving Certificate