Pat Jones

Contact Details

Email : pat@anythingaccess.com
Web : http://AnythingAccess.com
Phone : 086 262 0005
Linkedin : https://www.linkedin.com/in/patnjones/

Profile / Summary

  • Chartered Management Accountant with a demonstrated understanding of how to interpret customer business needs and translate them into application and operational requirements from senior management level to business and user level.
  • Senior Business Analyst with Software Solution Development, collaborating with business and cross-functional teams through defined periods of change, designing bespoke financial management solutions and systems, complex budgeting and reporting systems and custom ETL models.
  • Proven ability to lead and negotiate business solutions that balance technical capability, cost and time, against business need across Banking, Public Sector, Manufacturing, Food, International Service, and SME.
  • Strong leadership skills with the ability to work independently whilst supervising teams large and small on national and Pan-European levels

RPA – Robotic Process Automations

  • Product Specialist – Design and Documenting the Next Generation fund trading platform for State Street. Working with developers and Analysts to develop a proof of concept , define the data dictionary and document the workflow for each process using both JIRA and Confluence.
  • At Handheld (Client VTI), I automated the import and matching of supplier’s invoices to freight booking using the booking reference. Exceptions were reported separately when the price or sailing didn’t match for the staff to query. Customers were automatically invoiced for matched booking and the sales invoices loaded in Sage Line 50. This process had a saving of 1.5 FTE which allowed the department to grow the volumes processed without increasing the headcount.
  • At State Street for the EMIR group, I automated the process of logging into the DTCC portal each night and downloading the reports by instrument. The system used Cloakware to retrieve the credentials to connect to the portal. The system downloaded over 500 reports each night and saved over 2.5 FTE for the department.
  • At State Street, for System Maintenance on database applications, I used the Microsoft Task Scheduler to automatically run system maintenance tasks each night to compact the database programs. I also use scheduled tasks to create client summary group reports. The system generates over 1400 reports each night which are loaded to the SharePoint site.
  • At Handheld, I created programs which automated the invoice creation from thousands of delivery dockets.
  • At State Street for the OTC matching group, I developed an automated process to monitor an email account and extract data based on subject patterns or content. Data extracted from the email accounts was passed to Xceptor to parse and normalise into a table for matching against the client transactions. The process on another machine would call on the client’s ledgers using Interactive Excel download and extract and parse the XML to load and match against the broker data. These processes were running 24/7 on independent machines.
  • At Handheld (Client UCC) a manual process of extracting the spending reports and circulation to 140 departments was automated by linking directly to the Coda system and extracting the reports as PDF files and sending by email. Reports were also loaded to an intranet site and access controlled by password to allow users to self-serve the report delivery.

Systems Development

  • Finance fees are calculated by Sedol and fund and comparing the broker values to the ledger accruals, calculated values are then compared to the prior day’s accruals and the BPA impact on the fund composite. The manual process required more detailed audit controls and the ability to scale without increasing the headcount. The completed program, which has been deployed in 4 locations globally, delivered automation, with audit controls and reduced the headcount required.
  • For Broker payments the process required a reconciliation between the finance fee and settlement values by Sedol before the payments are executed. Broker files come in a variety of formats and individual Excel models had been created for each broker to accommodate the reconciliation. The process was very time consuming and the audit trail was very weak with users able to manipulate the content during the reconciliation process.  The re-design normalised the broker data into a single table and applied the business rules consistently with four eyes approval of any adjustments required. The deployed program significantly reduced the headcount required while increasing the controls.
  • Regulatory reporting for EMIR/ASIC required trades, valuations and collateral be loaded to the regulator by instrument. Working with SME’s globally, we defined the sources of the required information and developed a program to create the required formats
  • In Handheld, I delivered a range of solutions for the wholesale industry included handheld devices to record sales and order delivery with proof of delivery. The system was linked to several accounting solutions including Sage, Herbst, Coda, Exchequer, Agresso and others. Payment processing solutions included Direct Debit, SEPA and EDI integrations.
  • At Handheld (Client VTI) I created a complete freight booking system to take customer booking and send via XML to the shipping companies. The returned booking reference was sent to the customer via text message. The system also automatically processed the accounts payables, direct debits or credit card payments and loaded the sales invoices to Sage.
  • Creation of a global funds register for State Street loaded to collaborate to allow a web front end for fund queries or reports by Clients or Groups. The system links to the MCH accounting system to retrieve fund static data as a scheduled job which speeds the input or addition for new funds.

Technical Skills

      • Fellow of the Chartered Institute of Management Accounts with broad GAAP and Management Accounting experience working and managing small and large teams
      • Integration to / from Herbst Accounting, Coda, Exchequer, Impact Award, CORE HR, QuickBooks, Agresso, Axiom Planning and Reporting, Hyperion, BEX Analyser
      • Access and Excel, Advanced VBA and Model Design
      • ETL – to and from CSV, TXT, XML, XLS from SQL and other Data sources
      • Realex and Worldpay Integration and SEPA XML Generation using VBA
      • Process automation for SAP R3, Syspro ERP, Intact Business Accounting, Sage Line 50
      • MS SQL Stored Procedures and Functions and integration to Access with VBA, Visual Studio C#