I formed a partnership with Geoprise Technologies who are now licensed to market my TRANSIX ERP application under the name GM-X

Providing ad hoc support for previous projects:• Wedding Rings Direct to provide enhancements to their ERP system. (PHP, MySQL) This included: o CRM - The ability to view, send and receive emails through the back office system. o CMS - The ability to maintain static content in multiple languages.• Transition Engineering to help integrate the TRANSIX package with some brand new websites. (PHP, MySQL)• London Borough of Waltham Forest to upgrade their system to incorporate what I had developed for the London Borough of Havering. (VB.NET, SQL Server)

API Developer- Sole developer working with their eCommerce section to link their in-house system with Amazon via web services.- Installed and modified software to provide secure communications using the AS2 protocol.- Developed functions to integrate with Amazon Dropship by exchanging XML documents for IAA (Inventory Availability Advice), OF (Order Fulfilment Requests), OFR (Order Response), SL (Shipping Label Requests), SLR (Shipping Label Responses), TMN (Truck Manifests), ASN (Advance Shipment Notifications) and INV (Invoices).- Developed functions to integrate with Amazon Vendor by exchanging documents in EDIFACT format for ORDERS (Order requests), ORDRSP (Order Responses), DESADV (Despatch Advice) and INVOIC (Invoice).- Designed and implemented supporting administration screens using the RADICORE framework.Technologies: Apache, PHP, MySQL, AS2, XML, EDIFACT, RADICORE

API Developer• Sole developer working with the Merchant Relations Team to upgrade their web services• Designed and developed alternative software to send and receive CSV files via FTP.• Designed and developed a method of reformatting XML documents using XSL stylesheets.• Designed and developed a series of background tasks to handle offline processing to a variable schedule.• Designed and developed a One Time Token mechanism allowing merchants to enter the merchant portal without having to go through the login screen.Technologies: Apache, PHP, MySQL, Web Services (XML/JSON-over-HTTP), XSL, RADICORE.Achievements:• Responded rapidly to provide solutions for merchants with non-standard requirements.• Designed and built a back-end application using RADICORE to speed up administrative tasks.

Experienced PHP Designer/Developer with strong OO skills. 10+ years of PHP, XML, XSL, web services, back-office eCommerce / business applications. Immediately available.

• Part of a team of contractors who updated the council’s website to display mapping (GIS) data using Google Maps to show the location of council assets (schools, libraries, etc). While others in the team dealt with the front end website I was tasked with making the numerous pieces of GIS data available through a series of web services.• Designed and developed a batch program to extract GIS data of council assets from multiple sources to a single database table in a SQL Server database.• Designed and developed a batch program to extract selected data from the new database to produce a series of static KML/XML files to provide small sets of GIS data without the need to access the database.• Designed a table of control data, with a GUI program, which identified what data needed to be extracted, from which database table, and with what KML options. This allowed various features to be turned on or off without the need for any program changes.• Designed and developed a series of SOAP web services to extract selected GIS data from the database and produce dynamic KML files.• Developed the web services which allow a resident to identify the coordinates for a problem such as an abandoned car, graffiti, pot hole, etc. This again used a single database table for any problem, which allowed new problems (cases) to be added at will through the CRM system.Technology: VB.NET, SQL Server, Web Services (SOAP)Achievements:• Designed a flexible solution so that new GIS data could be included in the process simply by a member of the council’s staff updating the control data.• Created the ability to hold all cases (user-defined incidents) in a single table with a single set of web services which allowed the initial set of 5 cases types to be expanded to over 30 without requiring any software changes.• The solution was so flexible that I was subsequently asked to implement it for other London boroughs, initially Waltham Forest and Newham, with several others to follow.

- Added enhancements to theTRANSIX ERP package.- Help front end developers integrate their websites with the TRANSIX package for new customers.

• Worked on Westminster City Council’s ‘MyWestminster’ website, written in PHP, which allows residents to obtain information on council services.• Integrated Microsoft Dynamics / Lagan CRM with Symphony CMS via web services (SOAP) so that requests for services made through the website could be logged as a case in Lagan CRM.• Dynamic PDF generation within the MyWestminster customer portal. This allowed a copy of an online application form to be emailed to the resident once it had been completed.• Designer and developer of an end-to-end email processing solution which integrated council departments outside the corporate ring fence. This involved, for example, emailing a PDF copy of a request for a library ticket to the relevant library, and when the library responded to the email the case inside Lagan CRM could then be closed.Technology: PHP, MySQL, Web Services (SOAP)Achievements: • Proved to client that the solution was workable and cost effective.• Significantly reduced the cost of face to face and telephony contact time.

After having successfully designed, developed and installed a back-end ERP solution for the first client, I joined Transition Engineering Limited so that it could be made available to a wider range of companies. They market an end-to-end eCommerce solution by building a bespoke front-end website to the client's specifications, then integrate it with the TRANSIX package to provide all the back-end functionality.• Bespoke websites are designed and developed by a group of front-end developers, and I modify their code to replace dummy data with calls to the database, and calls to the payment processors such as SagePay or PayPal.• Knowing that a package may need to be customised for different clients I designed and developed a system of plug-ins which allow customisations to screen layouts, report layouts or business logic to be kept separate from the core code, with each client’s plug-ins held in separate directories.Technology: PHP, MySQL, RADICORE

• Created a web-based ERP / eCommerce application in PHP to replace an existing back-end application which could no longer be adapted to meet the organisation’s growing requirements and workload. • Designed a new set of databases and migrated all their legacy data.• Designed and developed a new set of administrative screens using the RADICORE framework which was chosen for its inbuilt Role Based Access Control (RBAC) system, its comprehensive security features, and its Rapid Application Development (RAD) capabilities.• Redeveloped the APIs in the front end website so that it communicated with the new databases.• Added PayPal as a payment option in the front end website as an alternative to Protx/SagePay• Re-engineered internal processes and computerised manual processes to help increase staff efficiency. This included the sending of automatic emails when an order’s status changed, allowing customers to view the status of their orders in the front end website, converting orders into invoices which could be emailed to the customer in PDF format, and the printing of despatch labels.• Provided the ability to turn a sales order for custom jewellery into a purchase order for one of their network of suppliers.• Designer and developer of a multi-lingual and multi-currency international sales platform where a single back-office system could serve multiple front-end websites in different languages.• Provided the ability to link to FEDEX via web services (SOAP) in order to obtain pre-formatted shipment labels with barcodes to speed up the shipment process.Achievements:• My efforts helped triple turnover to £2.5million whilst lowering their cost base.• Enabled expansion into several overseas markets including Germany, US and Scandinavia.• Automated numerous processes which had previously been done manually, thus freeing up staff time for more important tasks.• Provided the ability to sell returned items as “Special Offers”, thus reducing inventory.

The author of this website wanted to expand the selection of back-office screens due to growing customer requirements for which he also wanted a Role Based Access Control (RBAC) system. Having read my article http://www.tonymarston.net/php-mysql/role-based-access-control.html he contacted me and asked if I could supply him with a copy of the source code. This encouraged me to release my personal development framework as Open Source, which I did under the name RADICORE (http://www.radicore.org).Due to time constraints he asked if I would design and develop a totally new and bespoke back-office application to manage their product catalogue and deal with customer orders, which I did. The client was very pleased with the software.Technology: PHP, MySQL, HTML, CSS, RADICOREAchievements:- The website author was also pleased and impressed with the results, and has he had other customers who also wanted upgrades to their back-office systems he asked if, instead of building a separate bespoke solution for each one, I could design an build a flexible ERP solution which could then be sold to multiple customers as a package. I rose to the challenge and built a piece of software called TRANSIX with the first customer being Wedding Rings Direct.- The TRANSIX package is now being marketed through Transition Engineering Limited (http://www.transitionengineering.com) as the back-end package for end-to-end eCommerce solutions.

• Created a PHP framework based on the 3-Tier Architecture with separate components in the Presentation, Business and Data Access layers. This allows for a different presentation layer, such as a front-end website, to share the existing business and data access layer components. The data access layer can also be switched between the MySQL, PostgreSQL, Oracle and SQL Server database without having to change the business layer.• As the heart of any business application is a properly normalised database, I designed and developed my own Data Dictionary which allows me to import the database structure, and at the press of a button export these structures to produce the class files which are used by the application. This allows me to keep the database and application structures completely synchronised, thus avoiding the mismatch which requires the use of an Object Relational Mapper (ORM).• It also contains a unique implementation of the Model-View-Controller Design Pattern. Each user transaction requires a Model, a View and a Controller component. Unlike other implementations which require Views and Controllers which are tied to a single transaction, I have a library of reusable Views (using XSL stylesheets) and Controllers which can be used in multiple transactions. • The reusable views and controllers have been paired up into a library of Transaction Patterns which can be paired with one or more Model components to produce a basic working transaction at the press of a button without having to write a line of code. All the developer has to do is add code for any business rules or customisations.• It has in-built components for dynamic menus, Role Based Access Control (RBAC), Audit Logging (using a single set of screens to view all changes), and an Activity-based Workflow Engine.Achievements:• Produced a framework that can help build web-based business applications which use a relational database in a fraction of the time required by other frameworks.