Richard James Dyce

This contract has run from 2009, where I was initially brought-in to clean-up a basic v.5 FileMaker database of job notes. I was then asked to specify and develop a complete information management system to run their entire Aberdeen Completions operation. The system now comprises: * Quality Control Plan (QCP) and Work Instructions (WI) for three separate segments - QCPs consist of multiple WIs, with each task performed covered by a WI, Pre- and Post-job records, Client Satisfaction Reports, Well & Rig data sheets; * Goods Received Notices (GRNs) for electronically signing for deliveries, managing Technical Reception of parts, notifying engineers of parts arrivals, and measuring KPIs; * Equipment Transfers for tracking movement of goods within the enterprise; * Assignment Tool for managing engineer assignments between clients; * Quotes, Proposals and Tenders tool, for generating versioned PDF quotes by tying Word & Excel directly into FileMaker via VisualBasic macros; * Order Purchase Tracking for managing production of parts in other SLB sites; and * Forecasting Tool, for producing forecasts and rolling forecasts with a TimeMachine-style interface for reviewing previous forecast states. **The contract has been in maintenance mode for over 3 years now, at one day month.**

* Lead Developer/Architect for MDS, the FileMaker Master Data Management system in use by Synthes, Switzerland. Responsibilities included designing and maintaining interfaces, building reporting mechanisms for automated data transfers between legacy systems, and identifying and implementing opportunities for efficiencies and feature improvements. * Most recent project was a ReactJS/NodeJS Web application, acting as a front-end to an existing FileMaker-based Master Data Management system, for inter-departmental form review and approval. * Designed the architecture, implemented the web backend using Postgres, and the frontend using ReactJS. Main technologies used: Create React App, Jest, Cypress, PG-Migrations, Yup, Formik, React Data Grid, and MaterialUI. The application had 100% test coverage. * Developed several new approaches to the problem domain (language translation), and optimized existing codebase resulting in time-savings of more than 2 days per week. Mentored other developers within the department. Undertook Project Management role, as well as development, on two large international, multi-site projects involving SAP, Oracle & Agile EDI. * Developed a generic, FileMaker native, low impact, drop-in audit tool to augment the functionality of the existing Synthes MDM solution. The tool is fully documented, with installation instructions, performance tests suites, and Unit test suites in FileMaker. Provided similarly designed secure document storage to replace the Windows-managed document system.