John Layt Email & Phone Number

London, Gb

London Area, United Kingdom

* Provide thought leadership around digital transformation and support strategic digital decisions and practice.* Understanding of wider implications of digital development within MOLA and the wider sector.* Provide support in the design and implementation of digital recording or database systems.* Undertake software development and digital consultancy.* Provide training and CPD in the use and production of digital systems and wider digital workflows.* Advocate for and support the open sharing of archaeological data, source code, and methods, both within and outside MOLA.* Identify immediate improvements to data systems, storage, and management within MOLA, especially with regards to improving the integration and sharing of data to enable wider use and reuse both within and outside MOLA.* To contribute to ongoing Data Management Plan, complying to industry standards and best practices. * Contribute to innovation and impact at MOLA, increasing the internal and external profile of the digital development and the external profile of MOLA at large, and contribute to wider change in the discipline on an international scale.* Assist with underpinning MOLA’s reputation as a leading Independent Research Organisation.* Contribute to the development and achievement of the MOLA Research Strategy.* Initiate and/or develop external and internal collaborations and novel opportunities for research and engagement related to digital development at the national and international level.

London Area, United Kingdom

Design and development of LP's Digital recording systems:* ARK database for site recording and project management* ARK Spatial QGIS plugins* ARK Matrix for Harris Matrix processingData management.Digital archiving.Management of the IT infrastructure including Google Workspace and Apple Mac / iPhone fleet management.Site survey and GIS using Leica and QGIS.Field work including excavations, watching briefs, etc.

Greater London, England, United Kingdom

Southampton, United Kingdom

Provided ObjectStar consulting services to Skandia Investments as part of the Non Functional Requirements team working on the Omega Investment Fund Warehouse platform using ObjectStar on Windows. Performed system analysis to identify business and system process improvements to resolve system performance and data integrity issues. Documented database schema and data dictionary, batch schedule and performance history, and middleware interfaces. Coordinated design and implementation of code, batch schedule and data model improvements with business owner, application support team and MIS. Reduced end-of-month batch run-time from 30 hours to 8 hours. Reduced middleware call overhead by 90%. Designed changes to reduce end-of-day run-time by 50%. Designed changes to rebates processing for Retail Distribution Review (RDR) regulatory changes .

Provided ObjectStar consulting services to Skandia Investments. Designed and implemented generic database archiving framework for Omega Investment Fund Warehouse platform using ObjectStar on Windows.

System analysis and design of small change and project work on RCB Major Business billing system for electricity and gas using ObjectStar on Mainframe. Close liaison with business for requirements gathering and business analysis phases. Worked on electricity and gas industry standard data flow processing, billing work flow management, bill layout redesign, and various management, financial and performance reports.

Development of small change and project work on RCB Major Business billing system for Electricity and Gas using ObjectStar on Mainframe.

Project work and maintenance on IBIS Term Loans, Term Deposits and Loan Securities (NZ$45 billion in value), EMAX Channel Access and Control, and LMS Loyalty Points Management systems using ObjectStar and DB2 on Mainframe. Designed and developed TotalMoney loan offset product, middleware API for Internet Banking loan maintenance services, Loan Amortisation calculator, Early Repayment Fee calculator, Maximum Lending Amount calculator, Future Dated Loan Product Transfer, Second Factor Authentication interface for EMAX and Internet Banking. SOX compliance changes.

Project work and maintenance on LOIS Asset Leasing system using ObjectStar on Mainframe. Designed and developed sections of new Basel II compliant Impaired Assets Management functionality. Documented database model and batch schedule. Developed performance improvements to system to reduce daily batch critical path runtime by 1.5 hours and monthly batch by 2 hours to meet Service Level Agreements. Reconciliation of historic tax depreciation errors.

Canberra, Australia

Project work for Department of Veterans Affairs on Veterans Home Care system using ObjectStar on Mainframe. Developed sections of new Supplier/Service Contract Management functionality. Wrote user manuals for new functions.

Client account for Optus Telecommunications.System analysis, design, project and maintenance development, and 24x7 system support for CASS Wireline billing, RaDS Premium Rate billing, LDChurn Carrier Pre-selection, and SPACE Online Credit Rating systems using ObjectStar, COBOL, DB2 and IDMS on Mainframe. Local Number Portability for Carrier Preselection, Partial decommissioning of Premium Rate Billing. Virgin Mobile Premium Rate Billing. Mobile Number Portability for Premium Rate Billing. ObjectStar 3.2 upgrade. SPACE Java version upgrade migration feasibility study

Technical lead of 9 person support team, business and system analysis, design, small project estimating and management, small project and maintenance development, 24x7 system support, and manual writing for IBIS Term Loans, Term Deposits and Loan Securities, EMAX Channel Access and Control, AVP Inter-Bank Payments, and LMS Loyalty Points Management systems using ObjectStar, COBOL, and DB2 on Mainframe. Term Loan Amortisation corrections. Online Loan Repayment and Early Repayment Fee calculators. Customer-level account fee overrides. Conversion of printed reports to on-line screens. Direct Debit/Credit payment facilities. Scope Credit Scoring system interface. Staff account HR system interface.

Business and systems analysis, design, small project estimating and management, small project and maintenance development, and 24x7 support of IBIS Term Loan, Deposit & Lending Securities systems using ObjectStar and DB2 on Mainframe. Stabilisation and tuning of new system. Loan repayment holidays. Temporary interest margins. Mortgage unit trust. Decommissioning of mortgage insurance.

Wellington, New Zealand

Business analysis, user interface design, small project management, supplier liaison, user acceptance testing, manual writing and second level support for out-sourced IBIS Term Loans, Term Deposits and Lending Securities system, and CIF Transaction Account systems.Worked for 9 months on IBIS Replacement Project to replace out-sourced systems written in COBOL/Hogan/IMS with an in-house ObjectStar solution. Initially seconded to perform Business Analysis, Interface Design, Acceptance Testing and User Manual writing. Held delegated authority from Business Owner to approve system changes and sign off on completed system components. Wrote system test plans for Term Deposits. Designed screen layouts for Term Loans. Role later expanded to include programming for Term Loans online screens. Performed system testing for Term Loans batch. Continued to perform regular Business Analyst role described as below. Administration of project LAN.

Wellington, New Zealand

Loan Administration for corporate customers from $20 million upwards in value.

Wellington, New Zealand

Administration of 150 user Novell Netware LAN, building facilities administration, day-to-day supervision of facilities support staff.

Wellington, New Zealand

Loan administration for business customers from $250,000 to $20 million in value.

Wellington, New Zealand

Loan administration for consumer and small business customers up to $250,000 in value.

Wellington, New Zealand

Data entry and filing of customer records.