m
mooregra001

Graham Moore

@mooregra001

Financial Reconciliation and Data Cleansing Expert, Excel, VBA, Python, SQL

Regno Unito
Inglese
Alcune informazioni sono riportate in lingua inglese.
Chi sono
I'm Graham Moore, an FCCA accountant with 20+ years in banking (HSBC, Barclays Capital, UBS). I fix messy finance data, build automation tools, and deliver accurate reconciliations using Excel, VBA, Python, Access and SQL. I specialise in data cleansing, validation, controls, and reporting automation. See samples of my work on GitHub: https://github.com/mooregra001. You get fast delivery, clear communication, and precision. Message me to discuss your project.... Continua a leggere

Competenze

m
mooregra001
Graham Moore
offline • 
Tempo di risposta medio: 1 ora

Consulta i miei servizi

Sviluppo database
I will design, build, and fix ms access databases for business use

Esperienza lavorativa

HSBC

HSBC

Lavoratore autonomo • 6 yrs 6 mos

Finance Change Project Manager

Mar 2018 - Oct 20191 yr 7 mos

Product Owner and Scrum Master for FATCA and CRS reporting systems. Led requirements gathering, system design, product backlog prioritisation, sprint planning, and daily scrums. Test Manager for the successful roll-out of the CRS classification tool. Created test plans and scripts while managing a team of 30 test analysts across three international locations. Produced daily MI and handled senior stakeholder management.

Finance Change Business Analyst

Apr 2013 - Mar 20184 yrs 11 mos

Supported the Oracle General Ledger implementation for IFRS 9 reporting requirements. Conducted data gap analysis, data sourcing, and controls over completeness, accuracy, and integrity of data in the FTP/Big Data environment. Performed extensive SQL data mining to support the accounting team and regulatory reporting needs. Led end-to-end delivery of a Book Population Reconciliation using TLM, including requirements gathering, BRD writing, and coordination of offshore development teams. Played a key BA role in implementing front-office driven accounting (Microgen to Oracle). Automated testing and reconciliation processes using Access and SQL Server, reducing testing cycles from 5 days to 3. Managed system testing, UAT coordination, data migration, and live cut-overs.

Barclays

Credit Derivatives Product Control Manager

Barclays • Full time

May 2006 - Apr 20136 yrs 11 mos

Managed Product Control teams supporting Credit Trading and Emerging Markets businesses. Oversaw daily P&L production and analysis, month-end close processes, balance sheet substantiation, and regulatory reporting. Key achievements include driving significant process improvements through extensive VBA development and automation, building SQL-based tools for trade-level analysis and reconciliations, and acting as the primary Product Control subject matter expert for major system migrations. This role involved deep product knowledge across Credit Default Swaps, structured credit products, interest rate derivatives, and FX, while maintaining strong relationships with traders, market risk, finance, and audit teams.