Tony Rogerson

Tony Rogerson

Freelance SQL Server Specialist and Business Intelligence Consultant

Location
St Albans, United Kingdom
Industry
Information Technology and Services

Join LinkedIn and access Tony Rogerson’s full profile. It's free!

As a LinkedIn member, you'll join 225 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you and Tony Rogerson know in common
  • Get introduced to Tony Rogerson
  • Contact Tony Rogerson directly

View Tony's full profile

Tony Rogerson's Overview

Current
  • Principal Consultant and Director at Torver Computer Consultants
Past
  • 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

see less

see all

Education
  • The University of Dundee
  • The University of Dundee
Recommendations

7 people have recommended Tony

Connections

500+ connections

Websites

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.

Specialties

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.

Database Specialist

Fredrickson International Limited

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

Redburn Partners

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".

Founder

UK SQL Server User Group

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

iGroup (Computacenter)

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

Schroders

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.

Senior Analyst/Programmer

ABN AMRO

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.

Senior Analyst/Programmer

Centre-file Ltd

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.

Senior Analyst/Programmer

British Home Stores

June 1991 – September 1993 (2 years 4 months)

Worked on their BI/Reporting suite using Application System, DB2, System W, Oracle, Oracle Glue, Visual Basic 2.0 to extend the BI system and give the business new ways of slicing the data

Apprentice Production Systems Analyst

Vickers Shipbuilding Engineering Ltd

October 1987 – June 1991 (3 years 9 months)

Served an apprenticeship in their Production Engineering department using Application System and modelling using IDEF-0 and later in their IT department using PL/1, CICS and DB2.

Furness ITec

Furness ITec

July 1986 – October 1987 (1 year 4 months)

Technology college based around the then Youth Training Scheme.

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 Projects

  • MSc Dissertation: Reporting Brick - Reducing the cost of performing Business Intelligence with Commodity Hardware

    • August 2011 to Present
    Team Members: Tony Rogerson

    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
    Team Members: Tony Rogerson

    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
    Team Members: Tony Rogerson, Chris Gaskell, Phil Winstanley

    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

  • Build a UK SQL Server Community

    • December 1998 to Present
    Team Members: Tony Rogerson

    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

Tony Rogerson's Additional Information

Websites:
Interests:

Technology (Databases, Relational Model, NoSQL, Business Inteligence practices), Personal (Gardening, Cycling)

Groups and Associations:

ACM, UK SQL Server User Group

Honors and Awards:

SQL Server MVP 1997 - 2012

View Tony Rogerson’s full profile to...

  • See who you and Tony Rogerson know in common
  • Get introduced to Tony Rogerson
  • Contact Tony Rogerson directly

View Full Profile

Not the Tony Rogerson you were looking for? View more »

Name Search:

Search for people you know from over 225 million professionals already on LinkedIn.

Example: Tony Rogerson

Viewers of this profile also viewed...

Find a different Tony Rogerson:

  • Tony Rogerson, IT Security Specialist at Manitoba Blue Cross

    Canada

  • Anthony Rogerson, Senior Employee Benefits Analyst

    Greater Salt Lake City Area

  • Anthony Rogerson, Owner at Pawfect Pads

    Newcastle upon Tyne, United Kingdom

  • Tony Rogerson, Owner, Rogerson & Associates

    Hull, United Kingdom

  • Tony Rogerson, Independent Professional Training & Coaching Professional

    Oxford, United Kingdom

More professionals named Tony Rogerson »