Alfredo Patallo Cano

Experience

• 

  Gordon Associates

  Sept 2000 - Aug 2001

  Software Developer

  Web multi-tier projects with VB Script, ASP Pages, Visual Basic, SQL Server 2000, ADO, Crystal Reports 8.0 and MS-Access.

• 

  Misys

  Aug 2001 - Jun 2003

  Software Developer

  Software Development in mi-solution, the largest desktop project in the company using Visual Basic, SQL Server 2000, MS Access and XML for the financial sector ORIGO ISML.

• 

  In Spanish

  Oct 2003 - Nov 2007

  Project Manager

  Project Management in software and website localization projects.

• 

  University of Gloucestershire

  Dec 2007 - Oct 2012

  Planning and Reporting Analyst

  Developed, produced and analysed periodic and annual statistics for internal and external customers using SQL Server and a variety of BI tools. Analysed and supported different departments by defining business needs and by implementing data requirements. Project managed Active Dashboards implementation using Dynistics technology.

• 

  Lloyds Banking Group

  Nov 2012 - Oct 2013

  Data Quality Coordinator

  Supported Data Quality in a) identifying and resolving live data issues; b) establishing and maintaining all data supplier relationships; c) designing and supporting data extracts; and d) supporting data change projects. Daily use of Oracle platform, NRS, and GDW platform.Documented designed and developed the DQ Tracking Incidents and Reporting System (DQ-TIRS) which controls the arrival of data feeds and log data incidents. Supporting Data Quality in a) identifying and resolving live data issues; b) establishing and maintaining all data supplier relationships; c) designing and supporting data extracts; and d) supporting data change projects. Daily use of Oracle platform, NRS, and GDW platform. Documentation design and development of the DQ Tracking Incidents and Reporting System (DQ-TIRS) which controls the arrival of data feeds and log data incidents. Show less

• 

  TSB Bank

  Jul 2013 - now

  Maintaining the accuracy and data quality of the Finance Unified Database platform (BDU)Managing Q4 Month End reconciliation, P&L resolution, BDU Data Quality Sign-Off, maintaining BDU metadata, and providing reports related to TSB Data Governance: BDU Data Lineage, BDU Critical Data Elements (CDE) and Data Quality Management Forum (DQMF).Developed the BDU Data Quality platform, including the Data Quality System website (BDU DQS), Data Quality Incident Management (BDU DQ IM), BDU Data Quality Workspace in Power BI and FIM Data Dictionary Workspace in Power BI.Reporting for Risk & Control Assessment (RCA) Audit, Strategic Data Stores Audit, KPMG Q4 Month End Audit, KPMG Mortgage Interest Calculation Audit, Key Quality Indicators (KQI) Audit and TSB Internal Audit Show less Member of the Finance Pathfinder team in Barcelona engaged in the bank data migration from Lloyds TSB platform to Proteo4UK (Banco Sabadell) platform.Implemented solutions for the BDU (Financial Unified Database), which would be the main repository of TSB financial data for reporting and analysis purposes.Developed the BDU Management System (BDU MS) to simplify all reporting processes for the BDU, analysis of business requirements, data quality checks, BDU updates, BDU Requirements Dashboard, BDU Summary and DA101 parameterization.Developed the UAT Report Management System (UAT_RMS) to provide all the information required to control end-to-end testing in UAT for P200 and P201 tests. Developed the Data Quality Scorecard (BDU_DQS_UAT_TSB) that reports the daily and monthly data upload and the BDU_VB (BDU Views Builder) that reports connection problems and data quality errors across transactional data. Show less Member of the team that looked after the quality of Business Intelligence (BI) data assets, their completeness, validity, consistency, timeliness and accuracy. Examined Data Quality across products (Credit Cards, Savings, Personal and Business Accounts, Loans and Mortgages) using the Oracle platform, the Group Data Warehouse (Teradata platform), NRS (Unisys) and several ad-hoc tools. This entailed liaising with data providers, Group IT and BI teams to ensure the quality of feeds received.Designed and developed three EUC applications for TSB: a) the DQ Enquiry System (DQ-QUIS), to automate the process for answering queries raised by the Query Team by interacting with the Group Data Warehouse; b) the Feed Repository System (DQ-FRS) which was created in a web platform to keep feed information up to date; c) the DQ Sales Quality Report applications that uploads, checks the data and produces the SQR data feeds.Represented the Data Quality team in the Kaizen program. Kaizen is an initiative that champions continuous improvement by simplifying processes, reducing risk and lowering costs in Business Intelligence and across the bank.Toolsets: Teradata (Group Data Warehouse), Oracle SQL Developer, SAS (Statistical Analysis System), NRS (Unisys platform), and UFSS (Unisys Financial Services System). Show less

  • Data Quality Manager - Finance Information Management (FIM)

    Apr 2017 - now

  • Finance System Analyst

    Feb 2016 - Apr 2017

  • Senior Data Quality Analyst

    Jul 2013 - Jan 2016