James Booth, Developer in Hove, United Kingdom
James is available for hire
Hire James

James Booth

Verified Expert  in Engineering

Data Warehouse and BI Developer

Location
Hove, United Kingdom
Toptal Member Since
September 13, 2022

James is a data warehouse and BI developer with over 15 years of experience in business intelligence, from design and development to support and testing. He has worked on numerous greenfield projects and reworks of existing implementation projects, and his industry experience covers private banking, accounting, manufacturing, travel, and law. James takes pride in his work and values trust and open communication.

Portfolio

Intuitive Thinking
Microsoft Power BI, Azure SQL Databases, SQL Server Analysis Services (SSAS)...
Innocent Drinks
Azure SQL Databases, Microsoft Power BI...
Temenos SA
SQL Server BI, SQL Server Analysis Services (SSAS)...

Experience

Availability

Part-time

Preferred Environment

SQL Server BI, Azure SQL Databases, Microsoft Power BI, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)

The most amazing...

...project I've developed is a data warehouse framework that allows rapid implementation of a star schema and data store with minimal coding.

Work Experience

Data Warehouse and BI Developer

2017 - PRESENT
Intuitive Thinking
  • Developed a highly-configurable data warehouse framework, refined over the past five years after an initial 6-month project. It combines the configurable star schema's performance and usability and is complimented by the data store flexibility.
  • Created a Microsoft Power BI report pack for accounting consultancy clients, and included the integration of write-back visuals, facilitating cell-level commenting and budgeting while redesigning the existing star schema data model.
  • Built a tool for social media monitoring and reporting using Twitter API and Google Translate API. The tool retrieves social media posts that suggest potential clients' financial wrongdoing for due diligence purposes.
  • Utilized Temenos Transact banking data to develop complex logic and provide funds transfer pricing for assets under management (AUM), flow, and margin and base rate analysis.
  • Researched various data tools and resources to find new ways of adding value to businesses while attending conferences, exploring new technologies, and keeping up to date with market changes.
Technologies: Microsoft Power BI, Azure SQL Databases, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Master Data Management (MDM), T-SQL (Transact-SQL), Data Warehouse Design, Star Schema, Kimball Methodology, Database Administration (DBA), Data Engineering, ETL, Data Analytics, Data Architecture, Data Analysis, Business Intelligence (BI), Master Data, SQL Stored Procedures

Lead BI Developer

2021 - 2022
Innocent Drinks
  • Redesigned the existing Microsoft Power BI data sets to use a centralized star schema data model based on the Azure SQL Database, expanding the data sets report possibilities and improving maintainability and usability.
  • Trained team members new to business intelligence, focusing on star schema design, SQL, and Microsoft Power BI.
  • Used Microsoft Dynamics 365 data and covered multiple manufacturing, finance, sales, general ledger, inventory, and purchasing aspects.
  • Exported data with To-Increase integration solutions and standard entities, leading to a better understanding of the Microsoft Dynamics 365 database, and used AXDB to understand the Microsoft Dynamics 365 data model.
Technologies: Azure SQL Databases, Microsoft Power BI, Microsoft Dynamics 365 for Finance and Operations, Data Engineering, Data Analytics, Data Architecture, Data Analysis, Business Intelligence (BI), SQL Stored Procedures

Technical Consultant

2013 - 2017
Temenos SA
  • Implemented the Insight Data Warehouse and BI solution at some of the largest Temenos clients, such as Nordea in Luxembourg and ABN Amro in Amsterdam, including short visits to Aktia Bank in Helsinki, Commerzbank in Luxembourg, and KBC in Dublin.
  • Delivered the first significant private banking implementation of the Insight R14 star schema version at Nordea in Luxemburg.
  • Delivered business requirements for AUM, flow, profit and loss, decentralized autonomous organization (DAO), portfolios, adjustments, budgets, and KPIs.
  • Collaborated with the product team on incorporating private banking developments into the main product.
Technologies: SQL Server BI, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Warehousing, Data Warehouse Design, Data Engineering, ETL, Data Analytics, Data Analysis, Business Intelligence (BI), Master Data, SQL Stored Procedures

MI Analyst

2012 - 2013
DAC Beachcroft
  • Provided reports that were written in SQL and exported them using SSRS and Microsoft Excel.
  • Covered financial reporting, billing, debt, work-in-progress reports, realization, client case status reports, rebates, and tenders.
  • Gathered requirements for a team intranet portal to track the team's work and consolidate the available resources.
Technologies: SQL Server BI, SQL Server Reporting Services (SSRS), ETL, Data Analytics, Data Analysis, Business Intelligence (BI), SQL Stored Procedures

Technical and Business Analyst

2007 - 2012
Thomas Cook
  • Applied Agile methodologies and worked on large IT projects focused on new reservation systems and their integration into the legacy data warehouse and management information systems.
  • Collaborated with the finance team to provide reports and better understand the requirements.
  • Utilized the SQL Server for testing the data warehouse and later moved to support and developed the ETL for bugs and future requirements based on T-SQL.
Technologies: SQL Server BI, Jira, SQL Server Reporting Services (SSRS), Testing, Agile, Data Analytics, Data Analysis, Business Intelligence (BI), SQL Stored Procedures

Data Warehouse Framework

Developed a highly-configurable data warehouse framework that has been in production at a private bank in Luxembourg since 2017. The framework was built within the SQL Server and combines the performance and usability of a star schema, complimented by the flexibility of a data store.

The solution uses a dynamic ETL accommodating dimension and bridge, in addition to transactional, snapshot, and accumulating tables. It includes comprehensive logging, covering schema changes, batch details, and ETL steps for maintainability.

As part of the project, I delivered cubes using SSAS, reports using SSRS, used SSIS file exports for third-party systems, and allowed users to maintain their hierarchies and other configuration using Master Data Services.

Client Report Pack Development

Created a new data model and process for implementing predefined Microsoft Power BI reports and data sets that accounting consultancy users can deploy without having a technical background.

Microsoft Power BI write-back tools integrated into the report pack allow budgeting and commenting within Microsoft Power BI. I designed the look-and-feel of the reports and documented the process for future implementations.

Insight BI Private Banking Implementation

Delivered insight R14 at Nordea in Luxembourg, the first significant private banking implementation of the star schema version of the Temenos business intelligence solution.

The business intelligence solution included a data warehouse framework and cubes that needed to be reworked for private banking purposes.

The project included using:
• T-SQL transformations to cover AUM, flow, profit and loss, portfolios, and DAO
• T-SQL process for upload, including adjustments, budgets, and KPIs
• SSAS cubes
• Azure DevOps Server

Languages

SQL, T-SQL (Transact-SQL), C++, Visual Basic

Tools

SQL Server BI, Microsoft Power BI, Excel 2016, Microsoft Dynamics 365 for Finance and Operations, Jira, TFS

Paradigms

Kimball Methodology, Business Intelligence (BI), Testing, ETL, Agile, Azure DevOps

Storage

SQL Stored Procedures, Databases, SQL Server 2016, Azure SQL Databases, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Database Administration (DBA), SQL Server Integration Services (SSIS), Master Data Management (MDM)

Other

Data Warehouse Design, Star Schema, Data Warehousing, Data Engineering, Performance Tuning, Query Optimization, Data Analytics, Data Architecture, Data Analysis, Systems Analysis, SQL Server Administration, User Requirements, Master Data

2002 - 2005

Bachelor's Degree in IT Software

Sheffield Hallam University - Sheffield, UK

2000 - 2002

Vocational Certificate of Education in Computing

Grantham College - Grantham, UK

1990 - 1996

General Certificate of Secondary Education in Mathematics, English, Science, Geography, and Art

Central School - Grantham, UK

JANUARY 2021 - PRESENT

MCSA: BI Reporting

Microsoft

JANUARY 2021 - PRESENT

MCSA: SQL 2016 Database Administration

Microsoft

JANUARY 2021 - PRESENT

MCSE: Data Management and Analytics

Microsoft

APRIL 2019 - PRESENT

Agile Data Warehouse Design with Lawrence Corr

Decision One

AUGUST 2018 - PRESENT

MCSA: SQL 2016 Business Intelligence Development

Microsoft

FEBRUARY 2018 - PRESENT

MCSA: SQL 2016 Database Development

Microsoft

NOVEMBER 2017 - PRESENT

Microsoft SQL Server 2016 Business Intelligence Expert

Koenig Solutions

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring