Bob Gordon-Hancock

Experience

• 

  Barnet Borough Council Development & Regeneration

  Jun 2000 - Sept 2003

  Executive assistant
• 

  Lloyds Bank

  Sept 2003 - Dec 2008

  Deputising for the Senior Manager, Manpower Information as divisional implementation manager for the Group’s online performance and learning management system, becoming subject matter expert, and networking to become first point of contact for all queries and training requests. Collaborating with the division’s Senior Manager for Talent to devise and deliver presentations and reports for senior management and the Executive on any people-related issue to tight timescales, becoming team expert on Talent reporting,Coaching, and training HR and business teams of up to 50 people on general software and HR systems. ▪ Monthly and ad-hoc reporting of people-related data across the division, with over 95% delivered within agreed service levels. Business continuity planning and cascade management for the team▪ Managed stakeholders in the HR team and business to successfully deliver IT solutions to meet HR data- and workflow-monitoring requirements. Projects included a divisional succession planning system, databases to manage Group-wide Resourcing, Expatriates and Graduates, all utilising advanced VBA programming and data management techniques in Microsoft Excel and Access▪ Produced high-quality training materials on bespoke systems at short notice▪ Devised and successfully implemented an online Excel solution for our divisional monthly reporting of consequences for underperforming staff, enabling HR teams to report informal actions for the first time without significant increase in their workload▪ Managed the performance rating collation exercise across the division, delivering over 99% of performance ratings through 5 rating cycles▪ Negotiated with Group colleagues and suppliers to obtain enhancements to Group HR systems at no cost to the division Show less Dec 2004 – Feb 2005: Wholesale & International Banking HR, Change Services: project support (London, UK)Apr 2004 – Oct 2004: Commercial Director’s Office: Executive Assistant (London, UK)Sep 2003 – Apr 2004: Business Banking Compliance and Risk: project implementation (Birmingham, UK)▪ Project managed a high priority Know Your Customer review of 1050 accounts to satisfy Financial Services Authority requirements, managing a team of 10 temporary secondees and permanent staff in delivering the work▪ Coached new-to-Bank junior staff members so they achieved Account Opening Accreditation within a month▪ Automated monthly reporting of business financials to eliminate the potential for error, and reduced monthly report production time from 2 days to 20 minutes Show less

  • Manager, Manpower Information

    Feb 2005 - Dec 2008

  • Management Trainee

    Sept 2003 - Feb 2005
• 

  First Data Corporation

  Jan 2009 - Jan 2013

  MI Business Analyst

  ▪ Monthly Essbase OLAP cube load, query tuning and reconciliation to agreed SLAs and delivery of monthly reporting to agreed SLAs. Single point of contact for Italian and Dutch acquiring alliances, resolving all data issues, undertaking research and correction of any anomalies, ensuring data and reports meet their requirements▪ Designed and built SQL Server repositories to hold complete merchant, financial, pricing and billing information for 2 acquiring alliances’ merchant base (c.80,000 merchants, 4 years’ data history) previously held in CSV files; designed and built SSIS load packages and stored procedures to automate data upload/transfer to SQL Server production from staging; fully reconciled against old data source▪ Fully automated monthly build of Essbase OLAP cube to run directly from SQL server, replacing previous text file load▪ Designed, developed, and implemented collaborative team SharePoint site, and delivered full training to team members Show less

• 

  AIB Merchant Services

  Feb 2013 - Jul 2020

  Business Universe Architect

  Starting with an empty development server and one data feed, singlehandedly built out the data warehouse of Ireland’s leading merchant acquirer.▪ Integrated feeds from all acquiring subsystems (master data, transaction processing, billing processing, authorisation, chargeback, fraud) to give one view of both merchants and transactions through the entire lifecycle, replacing all other reporting systems as “source of truth”▪ Seamlessly migrated the development server into Fiserv’s Frankfurt data warehouse, integrating with enterprise tools and processes▪ Built entire parameterised bespoke reporting system for easily configurable bespoke data delivery to satisfy large Corporate clients, capable of running data extracts, rendering Reporting Services reports and delivering to SFTP and email destinations to flexible schedules▪ Developed sophisticated data warehouse monitoring and alerting to ensure consistent service delivery▪ Proactive performance issue identification and resolution, to ensure consistent delivery to customer SLAs▪ Advanced, branded Reporting Services report creation for internal and customer audiences Show less

• 

  GGH Data Solutions

  Sept 2020 - now

  Founder & Director

  GGH Data Solutions is a new venture established to bring and deliver best in class data driven solutions to the Card Acquiring market.GGH, with decades of experience in the acquiring industry strives to deliver first class service to Card Acquirers the often forgotten industry that bears all the risk and enables all of fintech to run.The GGH SMART solution has all of the elements and modules to service acquirers in all aspects from Card Scheme Interchange cost management, Card Scheme Fee cost management to merchant reporting and analytical solutions to deliver superior service to merchant clients.If you work in the acquiring industry please do get in touch and we will be happy to demonstrate to you the tools and benefits the SMART solution can bring to your acquiring business.GGH helping acquirers manage their margin. Show less