Matthew Baynham

I was the team lead for a team of C++ developers, initially I had 4 developers, then it went up to 6 developers & a UI/UX designer. * Working on Project proposals for future projects. * Liaising between users and developers, also general coordination with meetings, meetings and more meetings. * General admin tasks. * And I did a little C++ programming.

I have built up an online shop, I basically did everything from system admin, software development as well as everything else.

I wrote a dashboard using VBA in Excel to give the team a better insight into what was going on with regards to all the statuses of each milestone. All the management reporting came from my tools. Creating and maintaining Excel workbooks that analysed all the management reporting for a role out of mobile phone transmitters. The biggest task was developing and maintaining a dashboard tool to manage milestones. Processing audit data. Automate all the charts and graphics for the status of the project.

There was a team of support staff in a telephone unit who supported merchants with anything technical. My job was to support the support staff. This role did have some computer programming in it but was more of a sys-admin role. * Build and maintain tools in Excel and Access for support technicians. * Monitor systems.

My website no longer exists, however you can look on this YouTube channel (just click here) to see videos of my tools functionality. * Build a software toolbar targeted towards VBA Excel programmers. * Build a website to sell the toolbar.

* Build a IT Planning tools with an Excel front end and a MS SQL backend.

* Build a reporting system on MS SQL with MS Reporting Services. * Develop the load process that takes all the data from the current database (Full Circle) and load it into the MS SQL server. Then Volcom closed their finance office, moved the work to france and everyone lost their job.

* Managed all aspects of building an iPhone App through all of the full system life cycle. * Learn a wide variety of new and different technologies. * Code optimisation, memory management and problem solving memory leaks. * Introduction to simple web development.

Note: First role (6 months) VBA expert in Portfolio Services Department, second role (6 months) TSQL expert in IT department. * Writing and maintaining reporting specifically for each client. * Improving the reliability, speed, flexibility and adding functionality of reporting tools. * Writing new stored procedures and re-engineering automatically generated stored procedures to optimise performance. * Training a business user to become a VBA programmer.

Supporting & maintaining over 80 Access databases as well as some Excel. Managing the development of a new DB for the Product control. Liaising with Specialists designing the DB. I performed all aspects of the full system life cycle and more. Separate from the development of my application I helped with the month end period & investigating intricacies of the source data during the month end period. Basically did anything to help the business department meet its reporting deadlines.

* Working in the Change Management Department, I wrote VBA solutions to enable the office to migrate from Legacy ABN Amro internal systems to State Street systems that support the offices work processes. * Developing the Timesheet and Project Management Database systems. * Developed some Excel workbooks for the Bloomberg Terminal. * Helping guide the head of Change Management through IT issues. * Help end users understand some of the functionality of Excel.

* Performed all aspects of the full system life cycle in developing three separate systems that interacted with each other for running and scheduling Television programmes, (Live Assist project, Scheduler Project and a third application to play programmes that have been scheduled). * Learn the VDCP commands as well as the intricacies of the Omneon Server and Omneon Player.

* Developing tools to enable data conversion / data transformation, which were used to assist the Data Conversion Team with the task of data conversion. * Working in the Data Conversion Team to do the task of the Data conversion. Reviewing documents that the tools had flagged, to assess if they were XP compliant. * Fixing any documents that were not XP compliant.

* Analysing data in the finance department with the largest dataset I processed being 60,000,000 records. * Building reports and tools to generate reports.

* Build databases, which will dedupe and store lists of companies and people. * Analysing, preparing and preprocessing data. * Checking and flagging records for MPS and TPS. * Train one of the new developers in VBA for Access.

* Performed all the tasks in the full system life cycle in order to develop a number of databases which are critical to the running of the company. i.e. Scheduling System, National Booking in System, Field Database, Purchasing Database and Job Cost Analysis Database. * Assisted in a minority of PC support duties as well as any general duties that were required in the team. * Trained a fellow member of IT to become a VBA developer.

Mathematics