John Wilcox Email & Phone Number

Rayleigh, Gb

Worksop, England, United Kingdom

Maintaining and building out a core SQL Server database, tuning for performance and discovering and resolving slow running stored procedures. The entire schema was reviewed and many recommendation's made to normalize the data, rewrite and merge replicated queries into reusable blocks, validating and resolving indexes and foreign key issues. The goal was to reduce complexity, eliminate duplicated data and code so that it can be effectively maintained and documented, reducing delivery time for new functions and capabilities.

Langley, England, United Kingdom

Providing advice and guidance for the business to better align with business goals, and eliminate waste. Support for a major company effort which required a bespoke solution, with a clear focus on creating reusable components.

Langley, Slough, England, United Kingdom

Over a long career with Travelport, I was instrumental in the design and implementation of multiple core systems, used by thousands of internal and external users from around the world. I designed technical solutions to streamline the end to end new customer processes, helpdesk support processes and data migration processes. I am able to view existing processes, identify areas for change, design full stack solutions and lead the teams to deliver the new applications to users. For one of the helpdesk solutions I designed a solution that saved both our customers, our suppliers and helpdesk teams thousands of hours spent on the phone and created a multi million dollar company saving. In another area of the business I designed and lead delivery of a system that transformed they way new customers were on boarded from a 2 to 4 week lead time, to real time delivery, driving economies for the business, increasing the revenue capture as customers were online in minutes, reducing errors and freeing teams for more other duties. As the company grew through acquisitions and growth, the technical stack became fractured and costly to maintain. There were no single source views of data, so independently I created a data warehouse solution to collate data from more than 20 disparate sources into a single SQL Server database, which in turn was used to drive data migrations to a smaller tech stack, fulfill enterprise wide reporting of data that had never before been available as well as feeding back end functionality for customer applications. These are just a few examples where I drove significant value into the business, as a result of a perceived need or a request or question from the business which triggered a technical solution.

Langley, England, United Kingdom

Evaluating existing tool set, ensuring that technical debt is reduced where possible, and managed where it was unavoidable. Moving to Agile Release Trains and being a Product Manager within a new train. Proposing ways in which existing applications could be used for a significant company goal with as little cost as possible.

Langley, England, United Kingdom

Working in the Operations area, using data to identify areas where Customer Support items could be better managed through automation. Savings of $1 millions were made through this data evaluation, and architecting user friendly interfaces.

Maidenhead, England, United Kingdom

Supporting a number of systems and databases, and their interfaces with each other and services in other areas of the business

Windsor, England, United Kingdom

Designing and implementing new applications and databases to streamline new customer implementations as well as the rapidly expanding product offerings. Merging a number of legacy applications into a single standard stack

Swindon, England, United Kingdom

Reviewing and designing and implementing new business processes and systems to support new customer growth.