Jono McLeod BA/Ops/Dev/PMO

N

Founder

Nepotism

Jan 2021 - Current (5 years 6 months)

N

LIBOR Transition PMO

NatWest Group plc

Aug 2019 - Apr 2022 (2 years 9 months)

Teradata SQL, Tableau, MS Access, MS Excel VBA

L

COO

London Block Exchange

Oct 2017 - Jan 2019 (1 year 4 months)

Banking, treasury, exchange & OTC process flow design, daily operations and reconciliations. Staff management and payroll for 25 staff. Server infrastructure, office hardware & software, delivery and daily support. Design, planning and working daily with Emoney Licence holding partner to develop and roll out LBXPay bank account product. Partnered with Rackspace to deliver 20+ Azure server environment to support exchange operations.

N

Reporting Systems Architect / Developer

NatWest Group plc

Apr 2013 - Mar 2016 (3 years)

Design & build of RBS Remediation Project Databases and MI Reporting Solutions for an FCA S.166 Redress Programme and others. Combining multiple datasources to provide a centralised function for reporting to various stakeholders across internal franchises. MS Access, Excel, VBA, Sharepoint. Consulting as Balham Park Limited

PMO - Global Technology

Deutsche Bank

Sep 2012 - Dec 2012 (4 months)

Central budget planning for 2013 in Global Technology area. Short term contract.

PMO Coordinator

Computacenter

Dec 2011 - May 2012 (6 months)

Project Coordinator for Due Diligence on a 60mn GBP contract bid. 6 month contract.

Trade Reporting Developer

Barclays

Jun 2010 - Sep 2011 (1 year 4 months)

Trade Capture and Reporting in Fixed Income, Equities, FX, Commodities. Access, SQL Server, Excel VBA MIS Reporting

N

Reporting Systems Developer

NatWest Group plc

Jan 2010 - Mar 2010 (3 months)

Built a collection of Excel based MI reporting tools for Hays Financial within RBS. 3 month contract.

Operations Business Planning

OFCOM

Jun 2009 - Nov 2009 (6 months)

Accounts Reporting and Procurement. 6 month contract

Equity Markets VBA Developer

Macquarie Bank

Feb 2007 - May 2007 (4 months)

Worked with the Equity Markets middle office and finance users to design, develop and implement reporting solutions using Excel VBA combined with occasional Equity Markets front office desk support.

Credit Prime Brokerage VBA Developer

JPMorgan Chase

Jan 2005 - Dec 2006 (2 years)

• Responsible for the full life cycle development and implementation of software solutions utilising VBA and Sybase T-SQL. • Developed relationships with the Prime Brokerage team and DBA's to enable quick turnarounds of software releases and coordinate UAT's, ensuring solutions were in line with expectations. • Documentation of all processes and solutions, while using JIRA for issue tracking and project management. • Gained an understanding of Credit Derivatives, from pricing to booking, processing, netting and margining. • Solutions included CDS margining tools; a limit checking system to ensure daily fund trading had not exceeded give-up limits utilising complex netting rules; a sample portfolio tool for prospective clients to value

MI Reporting VBA Developer

JPMorgan Chase

Jun 2003 - Jan 2005 (1 year 8 months)

Responsible for the development and production of daily and monthly expense and revenue management reports in Excel & Access VBA from Business Objects & Peoplesoft. • Reports included Flash, P&L, Balance Sheet, Headcount & KPI's and were distributed to European Legal Entity heads and senior business managers based in London. • Developed MI reporting and reconciliation skills with an appreciation for financial controls. • Liaised with European clients & data suppliers to solve issues, customise reports and introduce new features.

Capital Markets PMO

BNP Paribas

Apr 2003 - Jun 2003 (3 months)

Supporting internal reporting systems and process improvement covering projects in the Capital Markets PMO using VBA and SQL. 3 month contract.

Financial Systems Analyst

JPMorgan Chase

Jun 2000 - Jun 2002 (2 years 1 month)

First line production support; identifying, tracking and resolving issues for JPM European Legal Entities covering Business Objects, Peoplesoft & Oracle general ledger and reporting systems. • Investigated reconciliation issues and carried out ad-hoc ETL data manipulation work in Access & Excel. • Worked with Application Delivery teams to resolve issues and coordinate month-end ledger closes, maintaining integrity between the MI systems and prior periods.

B

Unit Trust/OEIC Assistant

Bank of New York

Jan 2000 - Jun 2000 (6 months)

Stamp duty reclaims and placing of deals in Rufus Platform on behalf of trustee companies.

F

Financial Services Support

Freehills Law Practice

Dec 1998 - May 1999 (6 months)

Residential Credit Support

ANZ

Sep 1998 - Nov 1998 (3 months)

B

Consumer Finance Support

BTB

Dec 1997 - May 1998 (6 months)

General temp accounting and reporting work

Jono McLeod

About

Detail

Timeline

Résumé