About Me

Versatile and quick to learn, I’ve grown a skill set covering the data and web spaces, utilising the mindset of a technical business analyst, working on numerous migrations and projects across a mix of business sectors.

I’m comfortable talking to people of all levels and can switch between clients, board members, IT teams and end users alike.

My passion for helping to solve problems has led to a blog of well over 100 pages, focused mainly on data but including other areas for those looking to self-service their own IT issues.

• Over 15 years of experience in implementing, developing and maintaining large Financial Services based database systems and data warehouses.
• Over 15 years of working with various ETL toolsets
• Over 10 years building reports using SSRS and PowerBI
• 5 successful database migrations using various technology and data sources
• Upgraded SQL Server to the latest versions without a natural build paths
• Over 10 years of experience building custom web-based applications
• Understanding of financial reporting to roughly a level 2 standard of accountancy
• ISO9001 and ISO27001 implementation experience
• Experience of managing teams of up to 20 people and external suppliers
• Exceptional client management and relationship building
• Written SQL that 95% of the worlds major banks use to validate commodity identifiers (ISIN, SEDOL, CUSIP) and currently ranked #1 on Google
• SQL to cleanse Telephone and Postcodes also both #1 on Google, amongst other highly ranking articles in my academy pages covering various topics, topping over 2.5k hits per month across 15 languages.

Personal: Project Management, Team Management, Data Architecture, Data Integration, Data Migration, Data Validation, Data Cleansing, Business Processes, IT Training, Mentoring

Database: from SQL Server 2000, T-SQL, SSRS, SSIS, ETL, Oracle, MySQL, Power BI

Office/IT: Excel, Access, Word, PowerPoint, PageMaker, Draw Plus, Office 365 Licensing, DNS, Networking, Azure, AWS, GCP, GIT, Azure DevOps, Visual Studio

Web: Page Routing, JavaScript, HTML, CSS, Visual Basic, VB.NET

Limited: Process Writing, SSAS, Windows Server, Share, Point, MVC, C#.NET, Windows Forms, Adobe Photoshop, Exchange Server, Python, Cloud Databases/ETL

Kinto UK Ltd, Jul 2023 – Current

Database Specialist

Designing, documenting, mapping and setting up the infrastructure for a DWH and application migration for a company owned by Toyota Financial Services.

Claytabase Ltd, May 2013 – Jun 2023

Lead Data & Solutions Architect

Data focused consultancy with a focus on business strategy and processes, working with numerous clients around the UK and Europe. Some of the clients and projects included;

Isle of Wight NHS

• Providing support and training in efficient use of SQL Server
• Upgrading reporting to PowerBI
• Data warehouse design
• Set-up of clustered servers covering two sites with automatic failover.

Your Doctor Film & Media, Viva Health Labs, Your Thyme

• Oversaw the build of the data warehouse and reporting capabilities in PowerBI with hand-on experience
• Architecture of application database and full build of associated front-end to fully manage process of PCR testing for film studios with clients like Sky, Amazon and Disney. At peak, the application hit over 40,000,000 requests a month, utlising a JavaScript/.NET Microservices style system
• IT Network Infrastructure management across multiple sites and via remote Telephony based systems
• Second portal for Viva Health Labs for ordering and managing pathology, nutritional and environmental tests with data integrations in to multiple external platforms
• LIMS Integration via HL7, XML and CSV
• Managed a team of five developers, two report writers, six service desk, three BA’s and suppliers
• Major part of ISO27001 and ISO9001 planning and implementation

Blake Morgan LLP

• Lead role in planning, structuring and implementing both the System Neutral (three combined databases) data warehouse, reporting platform, and migration to a new CRM
• The data sources were based in SQL Server, Oracle and Progress, and include automated SSIS and OpenQuery data transfer system

Institutional Protection Services

• Redevelopment, migration and enhancement of SQL 2008 databases and overhaul of ETL.
• Migration from Access forms to .NET platform, with integrated Client Portal and file transfer functions.
• Migration of financial and general reports from MS Access to SSRS.
• Planning and installing Network of Cat-6 cabling in new premises, set up of Small Business Server 2011, including Active Directory and Remote Desktop access, Migration to Exchange Server.

Other Assignments

• Working on a large-scale database migration project (multiple databases and platforms), with additional data warehouse, data cleansing and validation at Gattaca PLC
• Creation of web based platform for managing business data like Projects, QMS and CRM along with programmable dynamic forms at Bland Group (hovertravel)
• SQL, ETL and VB.NET development for a Unilever project, integrating 20+ systems, validation and cleansing of data in process at OCS Consulting
• Database migration from SQL2000 to SQL2012 at The International Labour Organisation.
• Data Warehouse/Application Development/Architecture, using .NET and SQL for ARC Europe
• Data Warehouse/Application Development/Architecture, using .NET and SQL for CARS UK
• Application development/architecture, using .NET and SQL for U Systems
• SQL development, reporting, auditing and documentation process improvement at Creator

Arvato Financial Services, May 2005 – May 2013

Technical Business Analyst/Lead Programmer

• Design and Build of the Dialer database, with stored procedures linking databases on two servers and syncing the data to between 20 and 40 seconds
• Design and Build of Documentation Management System for managing workflow and UAT
• Creating specifications for an upgrade to the existing IT infrastructure and software, and reviewing the indexes on all databases, as well as scripting a nightly rebuild on all databases and other Database Administration duties as required
• Planning and implementation of Log Shipping for reporting and live database environment.
• Creation of web applications and company intranet sites
• Design and management of the data warehouse, including automated nightly data transfer (ETL) routines using SSIS/CSV and SQL script from six databases and associated BI reports.
• Creation of reports using SQL Server/SSRS, Microsoft Access/Excel and Visual Basic, including key performance indicators and financial databases/spreadsheets for the board of directors and investors.
• Management of a team of four developers, including tasks such as performance management and development, and ensuring the department had adequate resources.
• Some basic work with Sage
• Other duties included forecasting and client profitability, process mapping, analysis of staff/business performance and ad hoc reports for clients as business needs arrived.

Philips Lighting UK Ltd, Jan 2004 – Sept 2004

Customer Account Planner

Task included arranging deliveries, stock control and forecasting using my own data models.

Whirlpool UK, Feb 2003 – Dec 2003

Account Co-ordinator

Managing orders from customers, assisting the marketing team with promotions and developing a product database.

Home Office, Mar 2002 – Jan 2003

Executive Officer

Program design to produce legal documents in Word and Excel, assisting with asylum applicants and representatives, staff training on both my own and Government computer systems and the analysis, changing and mapping of processes.

Cemplas Ltd, Mar 2001 – Jan 2002

Administrator

Dealing with all forms of administration, stock control and database design for the warehouse using MS Access.

Further Education

After leaving school I worked in short term contracts before entering the HM Armed Forces in May 2000. 

Microsoft Office Specialist Master 2003 (Word/Excel/PowerPoint/Access)

Train the Trainer

Education

Stansted Mountfitchet High School 1993-1998

GSCE: English B, Maths C, Science B-B, Geography B, Statistics D