$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Business Intelligence Consultant
Jim Scragg
,
Liverpool, United Kingdom
Experience
Other titles
Skills
I'm offering
A client focussed and output oriented senior data professional who leads and delivers rapid results within a quality framework. 20 years in SQL Server development and management, with a wealth of experience in data migration, data architecture, and the designing and successful implementation of innovative Enterprise Data Warehouse / BI solutions. I have strong customer facing skills and experience with involvement at all stages of the delivery lifecycle. I hit the ground running and quickly get to grips with a client's data and requirements. I possess strong problem solving skills, and implement robust, practical, supportable solutions. I am a good communicator, and demonstrate technical leadership whilst developing the skillsets of those around me.
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Full time contractor
Available
My experience
2019 - ?
freelance
BI Consultant
Liverpool University Hospital NHS Foundation Trust.
• Implemented tactical BI solution for the new organisation - formed by the merger of the Royal Liverpool & Broadgreen and Aintree trusts
• Designed and delivered automated data flows, replacing manual collections
• Migrated SSIS packages, db objects, reports, cubes from SQL 2008 R2 to SQL 2017
• Developed Power BI reporting outputs for numerous directorates within the new trust
• Designed and delivered automated data flows, replacing manual collections
• Migrated SSIS packages, db objects, reports, cubes from SQL 2008 R2 to SQL 2017
• Developed Power BI reporting outputs for numerous directorates within the new trust
Sql, Power BI, Ssis, Organization, BEE, Power
2018 - 2019
job
SQL Data Manager
Barclaycard.
• Migrated dialler data source from an on-premise SQL Server backend database, to a suite of cloud based API data event streams
• Implemented data flows, ETL and business outputs for a suite of regulator-required reports, identifying vulnerable customers from key words and phrases included in correspondence from any text-based channels - letters, emails, SMS, chat
• Migrated SSIS packages, db objects, reports, cubes from SQL 2008 R2 to SQL 2016 as part of an in-house product upgrade project
• Migrated data sources from an enterprise Teradata platform which was being phased out, to sources within the Barclays Hadoop clusters
• Implemented data flows, ETL and business outputs for a suite of regulator-required reports, identifying vulnerable customers from key words and phrases included in correspondence from any text-based channels - letters, emails, SMS, chat
• Migrated SSIS packages, db objects, reports, cubes from SQL 2008 R2 to SQL 2016 as part of an in-house product upgrade project
• Migrated data sources from an enterprise Teradata platform which was being phased out, to sources within the Barclays Hadoop clusters
Sql, Backend, API, SQL Server, Database, ETL, Cloud, Event, Hadoop, Ssis, Teradata, Server, Enterprise, Backend, Manager
2017 - 2018
freelance
SQL Consultant
Mersey Care NHS Trust.
• Design and implementation of proof of concept data warehouse to future-proof the trust from the impacts of organisational mergers and service acquisitions
• Data mapping, planning, development and implementation of migration of data from legacy complaints system into new in-house solution
• Design and delivery of reference-data management process to underpin new legislative requirements and national dataset changes
• SQL Server 2012, SSIS, SSRS, SSAS, SQLBase
• Data mapping, planning, development and implementation of migration of data from legacy complaints system into new in-house solution
• Design and delivery of reference-data management process to underpin new legislative requirements and national dataset changes
• SQL Server 2012, SSIS, SSRS, SSAS, SQLBase
Design, Sql, SQL Server, Data management, Data Warehouse, Management, Service, Ssis, SSRS, Data mapping, Implementation, SSAS, Development, Server, Sql server 2012
2017 - 2017
freelance
Database Consultant
iProspect.
- January 2017 to September 2017 (2 renewals)
A leading digital performance marketing agency - part of the Dentsu Aegis Network
Database Consultant
• Replaced unsupported VB6 batch management application with a robust, supportable SQL Agent schedule, in place of 3rd party scheduling tool being purchased
• Implemented an SSIS auditing model, migrated from SQL 2005 to SQL 2016
• Trained local staff on SQL 2016 development best practices, testing approaches, and deployment techniques
• Developed and deployed MS Azure Logic Apps to incorporate o365 data into ETL
• Utilized MySQL databases for management of marketing campaign data feeds
• Utilized Google Cloud utilities to incorporate Google data into ETL
A leading digital performance marketing agency - part of the Dentsu Aegis Network
Database Consultant
• Replaced unsupported VB6 batch management application with a robust, supportable SQL Agent schedule, in place of 3rd party scheduling tool being purchased
• Implemented an SSIS auditing model, migrated from SQL 2005 to SQL 2016
• Trained local staff on SQL 2016 development best practices, testing approaches, and deployment techniques
• Developed and deployed MS Azure Logic Apps to incorporate o365 data into ETL
• Utilized MySQL databases for management of marketing campaign data feeds
• Utilized Google Cloud utilities to incorporate Google data into ETL
Ssis, Agent, Utilities, Logic, Campaign, Google, Testing, Development, Apps, Network, Marketing, Management, Google cloud, Cloud, ETL, Database, Deployment, Azure, Sql, Mysql
2016 - 2017
freelance
Data Warehouse Consultant
Informatics Merseyside.
• Designed and developed data warehouse using Kimball methodology to deliver a conformed dimensional model incorporating data from multiple source systems
• Developed new reporting outputs (legislative, contractual, operational) and ensured their accuracy and availability during a phased rollout of source systems to new services
• Provided data management consultation across project workstreams during the implementation phase of new systems
• Updated C#, ASP.NET apps capturing user comments and feedback to incorporate additional requirements relating to new systems
• SQL Server 2012, SSIS, SSRS, SSAS, Power BI, C#, ASP.NET
• Developed new reporting outputs (legislative, contractual, operational) and ensured their accuracy and availability during a phased rollout of source systems to new services
• Provided data management consultation across project workstreams during the implementation phase of new systems
• Updated C#, ASP.NET apps capturing user comments and feedback to incorporate additional requirements relating to new systems
• SQL Server 2012, SSIS, SSRS, SSAS, Power BI, C#, ASP.NET
Ssis, Kimball, Sql server 2012, Power, BEE, Server, SSAS, Apps, Implementation, SSRS, Net, Sql, Management, ASP, C, Data Warehouse, Data management, Power BI, ASP.NET, SQL Server, .Net
2015 - 2015
freelance
Business Intelligence Consultant
Unified Intelligence Strategy Consulting Enterprises (UISCE) Ltd.
- May 2015 to August 2015
A provider of business intelligence strategy consultancy
Business Intelligence Consultant
• Consulted to deliver a set of best practice proposals for their client on how to approach key elements of their project to implement a suite of quality performance reports
• Reviewed existing processes around data collection, management and report construction
• Designed and delivered a proof of concept, Kimball modelled data warehouse
• SQL Server 2012, SSIS, SSRS
A provider of business intelligence strategy consultancy
Business Intelligence Consultant
• Consulted to deliver a set of best practice proposals for their client on how to approach key elements of their project to implement a suite of quality performance reports
• Reviewed existing processes around data collection, management and report construction
• Designed and delivered a proof of concept, Kimball modelled data warehouse
• SQL Server 2012, SSIS, SSRS
Sql, Business Intelligence, SQL Server, Data Warehouse, Management, Ssis, SSRS, Data collection, Server, Sql server 2012, Kimball, Processes
2013 - 2014
job
Senior Data Developer
Really Good Domains.
• Redesigned and performance-tuned problematic ETL batch
• Migrated SSRS query logic to stored procedures, added report filters, grouping options
• Advised on and implemented indexing strategy
• Advised on and implemented data partitioning and archiving
• Implemented routines to identify data duplication across the multiple client platforms
• SQL Server 2012, 2008R2, SSIS, SSRS
• Migrated SSRS query logic to stored procedures, added report filters, grouping options
• Advised on and implemented indexing strategy
• Advised on and implemented data partitioning and archiving
• Implemented routines to identify data duplication across the multiple client platforms
• SQL Server 2012, 2008R2, SSIS, SSRS
Sql, SQL Server, ETL, Stored procedures, Ssis, SSRS, Developer, Server, Logic, Sql server 2012
2013 - 2013
job
Senior Data Systems Developer
Liverpool Heart & Chest NHS Foundation Trust.
- May 2013 to October 2013
A tertiary trust specialising in cardiothoracic care
Senior Data Systems Developer
• Designed, modelled and implemented a proof of concept, Kimball modelled data warehouse
• Migrated legacy data repository from physical to virtualised environment, upgrading and redeveloping SQL Server 2005 SSIS packages and databases to SQL Server 2012
• Managed in-house C# / ASP.NET application development team in delivery of ward management / consultant diary application
• SQL Server 2012, 2005, SSIS, SSRS, C#, ASP.NET
A tertiary trust specialising in cardiothoracic care
Senior Data Systems Developer
• Designed, modelled and implemented a proof of concept, Kimball modelled data warehouse
• Migrated legacy data repository from physical to virtualised environment, upgrading and redeveloping SQL Server 2005 SSIS packages and databases to SQL Server 2012
• Managed in-house C# / ASP.NET application development team in delivery of ward management / consultant diary application
• SQL Server 2012, 2005, SSIS, SSRS, C#, ASP.NET
Ssis, SQL Server 2005, Kimball, Sql server 2012, Server, Development, Developer, SSRS, Net, Sql, Management, ASP, C, Data Warehouse, ASP.NET, SQL Server, .Net
2010 - 2013
job
Senior BI Developer / DWH Manager
NHS Sefton.
- January 2010 to May 2013 (permanent)
A Primary Care Trust providing commissioning support services across North Merseyside
Senior BI Developer / DWH Manager
Inherited a BI solution built with MS Office products, and planned, designed and delivered its replacement with the successful implementation of a SQL Server 2008, Kimball-modelled data warehouse, supporting a user base of over 500 users across 100+ sites. Designed and delivered a data warehouse incorporating data from a multitude of sources, populated via SSIS-driven ETL routines, with conformed dimensions across both a range of standardized national reference datasets and a host of locally agreed definitions. Developed a simple web wrapper application in ASP.NET to host the SSRS report viewer control, and designed a database-driven access model managing user rights to outputs which were delivered as scheduled and user-driven reporting via SSRS. Developed a range of SSAS cubes for analysis via MS Excel, and scripted some complex database views for analysts to query via SSMS or by using linked tables within MS Access. Developed many complex T-SQL procedures and functions enabling business-critical analysis, processing datasets handling many millions of records. Designed and delivered training package to upskill analysts within the intelligence function, enhancing their querying and analysis skills, and enabling some to get involved with database object development and delivery of SSRS report outputs. Responsible for all DBA tasks other than server hardware / OS support, incorporating architecture design, security and access, setup and installation, configuration and backups, troubleshooting and performance tuning.
A Primary Care Trust providing commissioning support services across North Merseyside
Senior BI Developer / DWH Manager
Inherited a BI solution built with MS Office products, and planned, designed and delivered its replacement with the successful implementation of a SQL Server 2008, Kimball-modelled data warehouse, supporting a user base of over 500 users across 100+ sites. Designed and delivered a data warehouse incorporating data from a multitude of sources, populated via SSIS-driven ETL routines, with conformed dimensions across both a range of standardized national reference datasets and a host of locally agreed definitions. Developed a simple web wrapper application in ASP.NET to host the SSRS report viewer control, and designed a database-driven access model managing user rights to outputs which were delivered as scheduled and user-driven reporting via SSRS. Developed a range of SSAS cubes for analysis via MS Excel, and scripted some complex database views for analysts to query via SSMS or by using linked tables within MS Access. Developed many complex T-SQL procedures and functions enabling business-critical analysis, processing datasets handling many millions of records. Designed and delivered training package to upskill analysts within the intelligence function, enhancing their querying and analysis skills, and enabling some to get involved with database object development and delivery of SSRS report outputs. Responsible for all DBA tasks other than server hardware / OS support, incorporating architecture design, security and access, setup and installation, configuration and backups, troubleshooting and performance tuning.
Office, Access, SSRS, Developer, Support, Implementation, SSAS, Hardware, Development, Net, Web, Server, BEE, Kimball, Tuning, Processing, Sql server 2008, Manager, Data Warehouse, Sql, Excel, .Net, SQL Server, ASP.NET, MS office, Training, Database, Design, ETL, SoMe, ASP, T-SQL, Ssis, Security, Architecture
2007 - 2010
job
MI Delivery Manager
TalkTalk.
Migrated TalkTalk's call centre MI solution from one based on MS Office outputs, to a centralized portal supported by a SQL Server 2008 Kimball-modelled data warehouse. Managed a project team of analyst developers throughout the requirements-gathering phase to determine the strategic business reporting needs, then, acting as technical development lead, designed and delivered a data model to underpin these needs, before leading the development project to deliver the front-end portal and all the reporting outputs. Designed and managed delivery of SSIS ETL layer to populate the data model, used SSRS as the delivery engine for reporting outputs, and delivered direct query access via ODBC to a suite of 3rd party analyst tools. Managed all DBA tasks and supported other teams around the business in supporting their SQL Server based systems.
Sql, SQL Server, MS office, Data Warehouse, ETL, Ssis, SSRS, Analyst, Development, Office, Server, Kimball, Sql server 2008, Portal, Manager
2006 - 2007
job
Delivery Manager
Capita ITS.
(CRB contract) - March 2006 to January 2007 (permanent)
Capita run the Criminal Records Bureau security check service on behalf of the Home Office
Delivery Manager
Consulting with the business to gather management requirements and design and document the proposed BI solution, I then managed the Oracle development team through the development and delivery of a suite of KPI reports for CRB contract account managers and Home Office use. I also managed a business transformation project, transitioning the BI team from one staffed with a team of contractors to one staffed with primarily permanent resource.
Capita run the Criminal Records Bureau security check service on behalf of the Home Office
Delivery Manager
Consulting with the business to gather management requirements and design and document the proposed BI solution, I then managed the Oracle development team through the development and delivery of a suite of KPI reports for CRB contract account managers and Home Office use. I also managed a business transformation project, transitioning the BI team from one staffed with a team of contractors to one staffed with primarily permanent resource.
Design, Oracle, Business transformation, Consulting, Management, Service, Security, Transformation, Development, KPI, Office, BEE, Manager
2001 - 2006
job
IT Support & Development Manager
Vertex.
January 2001 to March 2006 (permanent)
Major outsource provider of business services to public and private sector organisations
IT Support & Development Manager
Managed the Microsoft-technologies support and development team, for clients including major utilities providers, local / central government agencies and national retail groups. Undertook business analysis of systems and processes from organisations Vertex was acquiring or offering services to, and consulted on the best business approach to take in terms of taking on support of client systems, developing new systems, or the re-use of existing Vertex systems. This required the ability to quickly get to grips with client requirements, business processes and data management, and to marry the business and technical aspects to determine the most beneficial solutions. Development and support technologies used were SQL Server v6/v7/2000/2005, VB5/6, .NET, Crystal v7/9, but the nature of the business analysis work in the investigation stages meant that I was also exposed to a whole raft of non-Microsoft technologies (including Oracle, SAP, MySQL, PHP, DB2, Paradox, Staffware). I passed my PRINCE2 practitioner exam during my time with Vertex, and managed my team through the process to successfully achieve ISO9001 accreditation.
Major outsource provider of business services to public and private sector organisations
IT Support & Development Manager
Managed the Microsoft-technologies support and development team, for clients including major utilities providers, local / central government agencies and national retail groups. Undertook business analysis of systems and processes from organisations Vertex was acquiring or offering services to, and consulted on the best business approach to take in terms of taking on support of client systems, developing new systems, or the re-use of existing Vertex systems. This required the ability to quickly get to grips with client requirements, business processes and data management, and to marry the business and technical aspects to determine the most beneficial solutions. Development and support technologies used were SQL Server v6/v7/2000/2005, VB5/6, .NET, Crystal v7/9, but the nature of the business analysis work in the investigation stages meant that I was also exposed to a whole raft of non-Microsoft technologies (including Oracle, SAP, MySQL, PHP, DB2, Paradox, Staffware). I passed my PRINCE2 practitioner exam during my time with Vertex, and managed my team through the process to successfully achieve ISO9001 accreditation.
Data management, Manager, Processes, Utilities, Server, Development, Support, It, Net, Management, DB2, Php, SAP, Prince2, Oracle, Retail, Business Analysis, SQL Server, It support, Sql, Mysql
1999 - 2001
job
Mobile phone sales and fulfilment
Cellstar.
Database Administrator
Managed a high-volume, high-availability SQL Server 7 environment, supporting warehouse management and logistics applications and a Solomon (precursor to Great Plains and Microsoft Dynamics) implementation. Responsible for developer support, performance tuning, DR planning, security and backups, capacity planning and management, and Solomon integration and support. Created cubes using SQL OLAP services for reporting on the European Sales Team KPIs, and used a Crystal Reports add-on in Solomon to generate daily sales and shipping reporting.
Managed a high-volume, high-availability SQL Server 7 environment, supporting warehouse management and logistics applications and a Solomon (precursor to Great Plains and Microsoft Dynamics) implementation. Responsible for developer support, performance tuning, DR planning, security and backups, capacity planning and management, and Solomon integration and support. Created cubes using SQL OLAP services for reporting on the European Sales Team KPIs, and used a Crystal Reports add-on in Solomon to generate daily sales and shipping reporting.
Sql, SQL Server, Database, Integration, Management, Sales, Security, Shipping, Developer, Support, Implementation, Server, Administrator, OLAP, Tuning
My education
1983
-
1990
n/a
Secondary, N/a
Secondary, N/a
?
-
1996
University of Liverpool Institute of Public Administration and Management
Masters, Public Administration
Masters, Public Administration
?
-
1994
University of Hull
Bachelors, Policy & Statistics
Bachelors, Policy & Statistics
Jim's reviews
Jim has not received any reviews on Worksome.
Contact Jim Scragg
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Jim directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark