James Reeves Email & Phone Number

Chester, England, United Kingdom

Developed and implemented advanced Power BI solutions to streamline reporting workflows and enhance data-driven decision-making capabilities across the organization.

Led the end-to-end development of a data management and visualisation solution to track and analyse the effectiveness of a smoking cessation campaign. This included designing and implementing the SQL Server database backend, as well as creating interactive Power BI dashboards to monitor user progress from initial application through to the outcome of their smoking cessation efforts. Developed reports to display results to NHS Commissioners. Collaborated closely with NHS Devon to understand their specific requirements for smoking cessation data analysis and reporting.

Amsterdam, North Holland, Netherlands

Led the development of a robust data pipeline and reporting solution for IFRS17 compliance, managing massive datasets through Azure Databricks and Power BI. Leveraged Python and Scala for advanced data processing and transformation. Overcame significant data volume challenges and implemented innovative solutions to ensure efficient processing and reporting.

Amsterdam, North Holland, Netherlands

Designed and implemented a comprehensive governance framework to enhance visibility, control, and security of Power BI data usage across the organisation. This initiative aimed to improve data governance, optimise resource allocation, and ensure compliance with organisational data policies.

Spearheaded the development of a dynamic reporting system focused on Advocacy outcomes, leveraging Dynamics 365 CRM as the primary data source. Utilized Power Query for all data transformations to ensure maintainability by the client's skilled staff.

Milton Keynes, England, United Kingdom

Using my meticulous attention to detail and great interpersonal skills, I am working with key stakeholders to determine what "good" looks like and drive data migration processes forward to that destination.I am genuinely passionate about data quality (hence the company name) and advocate for migration projects to have quality as a key indicator of success.Planning and executing major data migration initiatives includes assessing source systems, profiling data, mapping data from sources to targets, extracting data, transforming data, loading data, and validating results. For example, I planned and executed a SAP to Microsoft Dynamics 365 customer data migration. Activities included working closely with business and IT teams to understand requirements, profiling source data quality, mapping fields, defining extract and transform processes, developing SSIS packages for data movement, loading data into staging tables, performing validation checks, and working with teams to remediate issues before go-live. Effective project management, risk mitigation planning, strong communication skills, and meticulous validation enabled a successful on-time migration without data loss or corruption.

England, United Kingdom

Internet, Everywhere

Implement end-to-end data warehousing and BI solutions on Azure. Utilising Azure Data Factory ETL processes to consolidate data from Dynamics 365 (CRM, F&O BYOD) and other sources, implemented Kimball data warehouse on Azure SQL DB for enterprise analytics, and designed, built and deployed Power BI reporting suite.Work with the Dynamics 365 team to ensure that data setup within the system supports reporting requirements.

Wrexham, Wales, United Kingdom

Birkenhead

Created a new datawarehouse using Kimball methodologies to replace a previous implementation with a refresh time of 35 minutes instead of 9 hours.

Leeds, England, United Kingdom

Milton Keynes, United Kingdom

Utilising high levels of knowledge and experience to provide technical expert capability to pro-actively resolve live issues and support a robust data platform which enables development of accurate and complete reports to be provided to regulatory bodies such as the Financial Conduct Authority (FCA) and the Financial Ombudsman Service (FOS).Developing and maintaining highly complex automated data processing, data exchange and business intelligence applications using the full Microsoft SQL Server stack and a range of other professional development and data management tools, with a particular focus on importing, categorising and presenting data within the SQL Server data warehouse for reporting, business intelligence and performance management purposes.Interpreting and defining technical information and performance management requirements in both operational and management functions, and development of a robust architecture to meet identified needs,Contributing to database administrator (dba) functions for multiple servers, working collaboratively with other technical specialists to ensure system availability, robust security, back-up and data recovery arrangements and integrity of data across linked systems.

Chester, England, United Kingdom

Chester, United Kingdom

Created, maintained and enhanced management information, report production, key risk indicators etc. Assisted in the collation of data and production of presentations for regulatory examinations, senior staff visits from overseas and governance committee submissions.This role greatly enhanced my understanding of how the financial services sector interacts with Credit Reference Agencies and expanded my ability to analyse and present data using industry standard packages (SAS, SPSS, JMP et al).Achievements:Managed reconfiguration of PPI operational loss records in August 2011 from ‘The Standardized Approach’ (TSA) to the ‘Advanced Measurement Approach’ (AMA) to meet companies BASEL II approach.Created a suite of management information comprising ratified key risk (KRI) and key performance metrics (KPI) from all departments of the bank with standardised scales where appropriate to enable comparisons to be made and centres of excellence to be identified.

Chester, United Kingdom

Reported timely and accurate daily market exposure and profit and loss for a trading book whilst ensuring consistency with accounting ledgers. Analysed and investigated results obtained from the underlying data. Liaised with the Back Office team during, but not limited, to the month end and financial period closes assisting with the resolution of financial closing issues.Achievements:Implemented an Access database solution to co-ordinate workflow within the Middle Office across 5 work streams comprising 40+ users utilising hierarchical security levels to control access to sensitive data. This solution allowed the Head of Department to view in real time the status of all departments work in progress to allow rapid redeployment of workforce to ensure SLAs were met and to perform root cause analysis of failures when they were not avoided.

Chester, United Kingdom

Production of daily, weekly, periodic and annual reports relating to Call Statistics, Agent Performance, IVR executive management information (MI). Utilised Six Sigma methodologies to identify operational trends and communicate findings in appropriate manners to all levels from call-taking associates to senior management. Increased productivity levels by automating report generation processes by linking Business Objects, Avaya CMS and IEX TotalView into Excel utilising VBA and IEX SmartSync.Achievements:Using expert VBA and Excel development skills automated manual processing of established Crystal reports resulting in task completion in 10 minutes compared to 3 hours - with 100% accuracyAwarded “Associate of the Quarter” in Qtr. 4 2009 and Qtr.1 2010 in recognition of outstanding performance.

Chester, United Kingdom

As team leader, motivated and supervised teams of up to 16 staff. Handled a high influx of inbound calls within a dynamic call centre environment.Achievement:Received special recognition for remaining in the top 2.5% of 400+ associates in terms of efficiency, revenue generation and customer service levels for 12 consecutive months by maintaining an average productivity rating of 101.41% compared to the standard of 91.00% to target.

Bsc (Hons) Open Degree

Nvq Level 3

Nvq Level 3