Managed and maintained MyTutor’s WordPress-powered blog as the sole support person. Secured the blog using appropriate plugins, refined custom PHP code, ensured plugins were up-to-date, and collaborated with the theme developer to update the site.
Tag: MySQL
RDS User Monitor for MyTutor
At MyTutor, we aimed to ensure that the application database was accessed only by authorised user accounts for legitimate reasons. This project involved analysing AWS CloudWatch logs for the AWS RDS instances to extract relevant information. A list of users and their executed queries was compiled, excluding certain allowed users. The accounts that did not meet the criteria were then posted to a Slack channel for review.
Developer at FireTech – Kiosk Student Registration System
To enhance child safety during courses, I developed a student registration system for FireTech. This system, designed to run in kiosk mode in a browser or compiled into a native Android app using Apache Cordova. It featured:
PHP Developer at FireTech – Amazon site
FireTech collaborated with Amazon to arrange visits to the Amazon regional fulfilment centres, providing children with the opportunity to explore the facilities and learn about Amazon’s cutting-edge technology.
Senior WordPress Developer at FireTech
In my role as a senior software developer at FireTech, my responsibilities were:
PHP/ColdFusion Developer at Zonal
My responsibilities encompassed PHP and Adobe ColdFusion development, focusing on implementing new features, planning development initiatives, and resolving issues through bug fixing.
Refactor Plusnet BACS Billing for Plusnet
The first task was to gain a deep understanding of the existing legacy system and produce detailed documentation.
Plusnet GDPR
At Plusnet, I was lead developer in the Agile-based Plusnet GDPR Team, where my responsibilities included:
NHS Live Wait Times App Welsh Translation
This project expanded the app’s capabilities by incorporating multi-language functionality, specifically focusing on Welsh, with provisions made for adding additional languages in the future. Updates to the app’s dictionary can now be seamlessly performed online, eliminating the need for users to manually update their app on their devices.
Dollcrafts E-commerce WordPress site
Built on WordPress with the WooCommerce plugin, I integrated text message notifications to promptly alert company staff of new orders.
NHS UHNM legacy PHP systems
A prominent developer at the Trust had left leaving over 2 million lines of unsupported PHP code spread across numerous inter-related applications. The trust needed someone who could quickly become proficient at maintaining the code, develop new functionality, and offer advice on redeveloping the systems to their in-house standards.
This involved:
• Supporting the applications for the 8,000 Stoke Hospital users. This later became 12,000 when the Hospital merged with Stafford Hospital.
• Developing and maintaining a Virtual Machine to emulate the live system in isolation. This was then used for development and testing of changes to the live system.
• Making database updates to the live database to keep the system up to date and functional.
• Implement an authorisation system which integrates with the Hospital’s MS Active Directory structure.
• Developing a backup solution for the code and data, and preparing for disaster recovery.
• Responding to helpdesk requests, liaising with users to identify problems and provide solutions either by code changes, database updates or training.
• Redeveloping the import process for Staff-In-Post data from HR systems. This was a new PHP/MySQL application to parse the incoming data, and load it into the live database. I used jQuery UI to add a user friendly front end.
• Active Directory group maintenance. The BI team needed a way of easily managing users Active Directory groups. I wrote a suitable utility in C# .NET.
• Supplies & Procurement required management reports and graphs. I coded some pages using PHP/MySQL, jQuery and Google Charts.
• Other ad-hoc development such as developing Report Builder 3.0 reports for SQL Server.
HOPS Linux Server
HOPS required a reliable server to host essential business applications. This server was crucial for hosting the client portal, generating nightly management reports, and facilitating an authorisation API to the MS SQL server.
HOPS Website
The HOPS website required modernisation to include specific legal compliance information. I proposed using WordPress to create a basic brochure site, utilising its CMS capabilities to empower existing staff to update the required pages.
HOPS Text Messaging Promotion
As part of a marketing campaign, HOPS invited potential candidates to engage in a text message dialogue to determine their eligibility for a government-endorsed training scheme. I developed a system to send messages and process replies according to a predefined script, ensuring it could handle accidental and intentional misuse.
Incommunities Development Environment
This server became my primary development tool throughout my contract and was subsequently adopted by the resident development team.
Incommunities WordPress Plugins
The first WordPress plugin enabled document sharing and meeting bookings for internal staff. I customised an existing plugin to meet the client’s specific needs.
Salesforce Payment Interface
I led a team of two PHP developers to accomplish this. The project involved using PHP to generate XML data, which was transmitted to the Salesforce gateway via SOAP. Result codes from Salesforce were then interpreted and relevant messages displayed to the website users.
HomeServe CMS
I developed a CMS that worked seamlessly with the existing templating system, enabling copy editors to log in, modify text, and manage revisions of site content.
HomeServe White-label sites
I was part of a team responsible for implementing and maintaining these white-label sites, ensuring each micro-site was tailored to meet the clients’ specific requirements and satisfaction.
PHP Support for HomeServe
I joined HomeServe as one of two contractors hired to support their legacy PHP application developed in the CakePHP framework. The decision was made to refactor the code in ASP.NET. Along with the other contractor, I collaborated with the existing PHP team to wind down the current application, address imminent issues, and assist in the early design stages of the new .NET solution. During my two years at HomeServe, I eventually led a team of two other PHP developers.
VRM Vehicle records archive and search facility
I was tasked with developing a robust system from scratch to securely store and provide searchable access to this information via tools on the Jaguar Intranet for authorized personnel.
Mercia Servers
One of our initial tasks was to build and configure web, FTP, Usenet, and mail servers, each running on Linux-based PCs. This project required me to familiarise myself with early versions of many GNU and open-source packages, including Sendmail, WU-FTP, and Apache.