Freelance SQL Server Specialist and Business Intelligence Consultant
- St Albans, United Kingdom
- Information Technology and Services
Tony Rogerson's Overview
- Principal Consultant and Director at Torver Computer Consultants
- Database Specialist at Fredrickson International Limited
- Consultant Database Specialist and Project Delivery at Redburn Partners
- Founder at UK SQL Server User Group
- SQL Server Consultant at iGroup (Computacenter)
- Microsoft SQL Server DBA/Consultant at Schroders
- Senior Analyst/Programmer at ABN AMRO
- Senior Analyst/Programmer at Centre-file Ltd
- Senior Analyst/Programmer at British Home Stores
- Apprentice Production Systems Analyst at Vickers Shipbuilding Engineering Ltd
- Furness ITec at Furness ITec
- The University of Dundee
- The University of Dundee
7 people have recommended Tony
Tony Rogerson's Summary
Tony started his career in '86 coding on the IBM mainframe with Application System, PL/1, CICS, DB2 and System W. In ’95 recognising the momentum of Client/Server computing he the Client/Server transferred his skillset adding Visual Basic, C++ and Oracle; he has worked with all versions of SQL Server since '93 starting with 4.21. In ’97 he became one of only 22 people worldwide to be given the SQL Server MVP award by Microsoft, an award he has received yearly since.
Tony has significant business experience gained through a mixture of permanent and contract roles as well as significant consultancy experience in many sectors including Finance, Debt Management, Retail, Vehicle Tracking, Web related industries and from general technical product consultancy with Microsoft SQL Server.
In spring 2012 he completed his MSc in Business Intelligence from the University of Dundee, he continues to research in the areas of parallel data processing using GPGPU's and distributed commodity storage.
Tony is very well known in the UK SQL community as well as across the globe through founding the UK SQL Server User Group in ’97, a founder member of Developer Developer Developer, SQL Bits and SQL Relay community conferences.
Tony continues work within the SQL community by presenting at regional groups and writing technical blog articles through his blog on http://sqlblogcasts.com/blogs/tonyrogerson.
A trusted individual by many long term clients; more recent projects Tony has delivered are the Research website for Redburn Partners, partitioned schema design to accommodate an insert rate of over 1,000 rows per second for a Vehicle Tracking system , the rewriting of a debt management transactional costing system to SQL Server and public facing commoditised implementation of the gaming statistics service for Just Cause 2.
In September 2012 Tony was made a Fellow of the British Computer Soceity.
Microsoft SQL Server, Data Architecting, Database Design, Problem Solving, High Availability, Business Intelligence, Remote support, Mentoring and Training.
Tony Rogerson's Experience
Principal Consultant and Director
Torver Computer Consultants
December 1998 – Present (14 years 6 months)
Database Specialist with a product focus around Microsoft SQL Server, specialising in the Engine, Query Tuning, High Availability and Business Intelligence.
Role revolves around a mix of short to long term consultancy as well as project work where I act in a number of roles including Architect, Project Manager, Database Specialist and QA.
Privately Held; 201-500 employees; Financial Services industry
January 2007 – December 2012 (6 years)
Tony has been the lead Architect and Developer in the migration of the core business systems to Microsoft SQL Server, he has personally rewritten some of the core business systems such as collections costing and reporting, debtor tracing and arrangement calculations. He manages the Database platform – Availability, Consultancy, Database Design and Data Analysis.
Consultant Database Specialist and Project Delivery
Partnership; 51-200 employees; Financial Services industry
July 2003 – May 2012 (8 years 11 months)
Tony helped set up the IT infrastructure at the company inception, he is responsible for the development of a number of in-house projects such as the Fidessa trade feed, Business Inteligence system and original CRM system. He is responsible for the development and delivery of the companies research system "IDEAS".
Nonprofit; 1-10 employees; Information Technology and Services industry
November 1999 – May 2012 (12 years 7 months)
Tony founded the UK SQL Server User group; the group provides a community for people to engage and learn around Microsoft SQL Server. Tony developed and manages http://sqlserverfaq.com which is the home of the user group. He regularly runs meetings in London and Reading and has many speaking engagements throughout the UK.
SQL Server Consultant
Public Company; 10,001+ employees; CCC.L; Information Technology and Services industry
August 2000 – October 2001 (1 year 3 months) London, United Kingdom
Provided SQL Server expertise to the company; mainly involved in developing a Knowledge Management product called iFramework. Areas of responsibility - Database Design, design and development of the core search functionality (the KM schema was dynamic so all queries needed to be constructed from the KM meta data, the search allowed for many different data sources - linked servers, index server and full text.
Microsoft SQL Server DBA/Consultant
Public Company; 1001-5000 employees; SDR; Investment Management industry
April 2000 – July 2000 (4 months)
Primarily a SYBASE site, Microsoft SQL Server was been introduced throughout the bank via. third party and in-house development, SQL Server 6.5 and 7.0. Duties included skills transfer to the 6 strong team of SYBASE DBA's, consult with other departments within the company to assist them with design and tuning work around SQL Server, develop a security model for SQL Server in the bank and prove the migration of the build from RAID 5 to RAID 10.
Privately Held; 10,001+ employees; Banking industry
May 1996 – May 1999 (3 years 1 month)
Role was full time with SQL Server in a developer and database administrator role (4.21a, 6.5 and 7.0) first working on a Global CRM system for the bank then on trading systems within the bank.
September 1993 – May 1996 (2 years 9 months)
Worked with SQL Server (4.21a and 6.0) and Visual Basic (3.0 – 4.0) and had a lot more exposure to Windows NT, because of his expertise Tony was had a big part in developing Natwest Streamline (invoicing and transaction accumulation), Mondex (the electronic bank purse) and the Natwest workflow application.
Tony Rogerson's Certifications
Fellowship British Computer Soceity
- British Computer Soceity
- License 990338660
- September 2012
Tony Rogerson's Organizations
British Computer Soceity
- September 2012 to Present
Tony Rogerson's Skills & Expertise
Tony Rogerson's Projects
MSc Dissertation: Reporting Brick - Reducing the cost of performing Business Intelligence with Commodity Hardware
- August 2011 to Present
A key component to the success of a Business Intelligence system is getting the requirements right; translating those requirements into code can be a time consuming process when dealing with large volumes of data or if the underlying table structure has a degree of complexity. Using hardware that does not provide responsive query times can mean extended consultancy hours which leads to increased cost or in the case of a fixed budget a narrower project scope.
The cost of server hardware has come down over the past decades, however, in order to get the IO’ps required to perform responsive queries still requires high initial outlay, outlay for a project that may not progress forward should the proof of concept not be successful.
Over the past decade commodity Solid State Devices (SSD) have been making inroads, especially for high end desktop machines used by gamers, enthusiasts and more recently business workstations. Reliability and performance has substantially increased; with SATA 3 appearing more on high end desktop motherboards the full throughput of SSD’s can be realised.
The Reporting Brick concept comes from the initial research performed by Jim Gray et al on Cyberbricks in the late 90’s where they used high capacity SATA hard drives to provide a cost effective solution to prove the scalability of SQL Server 2000 through the TerraServer project.
This project shows commodity kit can be used to great effect within the context of BI, delivering outstanding price-performance.
Research in using GPGPU's for Big Data through Massively Parallel Data Processing
- February 2012 to Present
General Purpose Graphic Processing Units are specifically designed to process large volumes of data using many thousands of parallel concurrent threads. With the introduction of PCIe to combat host to device transfer throughput and with PCIe based flash storage to provide very high persisted storage throughput that now bottlenecks on the host CPU, the GPGPU is a perfect candidate for BigData processing.
The project looks in-depth at how best to create synergy between BigData requirements and the massively parallel capabilities and throughput of the GPU cards.
Redburn Ideas Portal
- March 2008 to November 2008
IDEAS Financial Redburn Partners produce financial reports to assist advice investors and fund managers. I developed an application integrated with a document management system. This allows Redburn to track, update and manage their reports and client base. Advisors can instantly publish a document to clients allowing them keep up with the markets
- December 1998 to Present
How do you improve your own skill set? There are only so many technical manuals you can read. How do you grow your exposure and experience across many industrial sectors and many unique problems?
The answer is simple - open a channel that gives you access to as many people in your industry as you can.
The ongoing task of building the UK SQL Server Community raises many challenges such as Marketing, Event Organisation, Presenting, People skills, Project management and a ton of others.
The UK SQL Server User Group (http://sqlserverfaq.com), SQL Blogcasts (http://sqlblogcasts.com), SQL Bits (http://sqlbits) and SQL Relay are products of the project.
Tony Rogerson's Education
The University of Dundee
Data Science PGCert
2013 – 2013 (expected)
Big Data and Advanced Statistics.
The University of Dundee
MSc Business Intelligence, Information Engineering, Databases
2010 – 2011