$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Expert Data Architect specializing in Analytics and Data Science
Matt Thompson
,
Weston-super-Mare, United Kingdom
Experience
Other titles
Skills
I'm offering
I am an experienced Technical Architect and Development Manager in the Data and information arena with strong skills in both production and development and a record of projects delivering to cost and on time.
I have worked with both Official Sensitive and Secret level data on UK Government projects. I have extensive experience with all aspects of data and information from strategy, master data management and data quality process through to migration, business intelligence and AI/ML.
Most recently I have been designing and implementing projects in the Microsoft Azure and AWS Clouds bridging the open-source Hadoop environment with Microsoft SQL BI Stack and Azure BI components and Amazon (AWS) PaaS components. Using concepts such as Delta Lake to provide flexible solutions to give timely access to information needed by companies to help them on their journey to become data driven decision makers.
In the 24 years, I have been working in Data and information I have had experience of all mainstream data and information platforms and have worked with most development and project methodologies including Waterfall and AGILE. I have designed and implemented DR solutions using 3rd party and SQL in built tools such as mirroring, replication and log shipping. I am used to producing documentation to ITIL standards and working within change control and to strict SLA targets. In data warehousing I have used Kimball (bottom up), and Inmon (top down) methodologies. I have extensive experience of all SQL Server versions from 4.3 – 2016. I have used many data mining tools and reporting systems and implemented MDS and DQS as part of Warehouse solutions. I have designed and implemented SQL Server platforms on Virtual and Cloud platforms. I am an experienced BI Technical Architect and have experience of delivering on both green field projects and taking over troubled existing projects to conclusion. I have implemented Hadoop for use with Big Data, primarily IoT, using Edge/Fog computing to reduce bandwidth of transmitted data.
I have worked with both Official Sensitive and Secret level data on UK Government projects. I have extensive experience with all aspects of data and information from strategy, master data management and data quality process through to migration, business intelligence and AI/ML.
Most recently I have been designing and implementing projects in the Microsoft Azure and AWS Clouds bridging the open-source Hadoop environment with Microsoft SQL BI Stack and Azure BI components and Amazon (AWS) PaaS components. Using concepts such as Delta Lake to provide flexible solutions to give timely access to information needed by companies to help them on their journey to become data driven decision makers.
In the 24 years, I have been working in Data and information I have had experience of all mainstream data and information platforms and have worked with most development and project methodologies including Waterfall and AGILE. I have designed and implemented DR solutions using 3rd party and SQL in built tools such as mirroring, replication and log shipping. I am used to producing documentation to ITIL standards and working within change control and to strict SLA targets. In data warehousing I have used Kimball (bottom up), and Inmon (top down) methodologies. I have extensive experience of all SQL Server versions from 4.3 – 2016. I have used many data mining tools and reporting systems and implemented MDS and DQS as part of Warehouse solutions. I have designed and implemented SQL Server platforms on Virtual and Cloud platforms. I am an experienced BI Technical Architect and have experience of delivering on both green field projects and taking over troubled existing projects to conclusion. I have implemented Hadoop for use with Big Data, primarily IoT, using Edge/Fog computing to reduce bandwidth of transmitted data.
Markets
United Kingdom
Industries
Language
English
Fluently
French
Good
Ready for
Larger project
Ongoing relation / part-time
Available
My experience
2019 - ?
job
Lead Architect
Methods Analytics.
Taking on core architectural responsibilities for designing platforms, data solutions and strategies to provide a space for innovation in Artificial Intelligence, Machine Learning, and advanced analytics within a governed self service framework for various clients including areas of the MoD. Guiding data scientists and analysts in the best way to structure and utilise their data while providing a central core of curated data. Responsible for developing and enforcing data strategies for Master Data Management, data collaboration and data policies. Producing a Master Data environment to provide cohesive curated data to both reporting and applications.
Designing core data to reflect requirements for business, statutory and regulatory requirements. Defining and refining data and information capture processes. Designating and defining master data and the management processes surrounding it. Data sets included PID data, Asset Register data, project and project performance data, safety data, security data. These were taken from a large range of systems across multiple organisations and suppliers working within the delivery framework.
Designing core data to reflect requirements for business, statutory and regulatory requirements. Defining and refining data and information capture processes. Designating and defining master data and the management processes surrounding it. Data sets included PID data, Asset Register data, project and project performance data, safety data, security data. These were taken from a large range of systems across multiple organisations and suppliers working within the delivery framework.
Machine learning, Innovation, Artificial Intelligence, Data management, Management, Analytics, Security, Master Data Management, Service, It, Safety, Advanced Analytics, Regulatory, Framework, Processes
2017 - 2018
job
Business Intelligence Technical Architect
Honda of the UK Manufacturing.
Responsible for delivering a proof of concept data warehouse solution to highlight benefits and synergies with existing practices and to enable growth of intelligent data use. Guidelines for ongoing development and a full documentation stack for the proof of concept. Integrating asset, production process, safety and product development data into a cohesive master data
Key Deliveries
● Technical architecture for proof of concept and post proof of concept using a hybrid of on premise and cloud (Azure) solutions
● Data Architecture of proof of concept solution, consisting of 13 fact tables and 22 dimension
tables with a combination of standard dimensions and inferred dimensions with data enriched through MDS
● Implementation of a comprehensive source control using VSTS and Git with defined branching
strategies
● Design of complex data control for handling loading of fact rows into multiple facts
● Extraction of data from multiple disparate sources including SQL, Excel, SAP, and Mainframe
● Scrum master for sprint delivery
● Responsible for engagement with subject matter experts and project and business data owners
● Delivery of a comprehensive and complete set of documentation for the proof of concept and the ongoing architecture development.
● Managing knowledge transfer from contract development team to permanent support team,
including upskilling on the new platforms
Key Deliveries
● Technical architecture for proof of concept and post proof of concept using a hybrid of on premise and cloud (Azure) solutions
● Data Architecture of proof of concept solution, consisting of 13 fact tables and 22 dimension
tables with a combination of standard dimensions and inferred dimensions with data enriched through MDS
● Implementation of a comprehensive source control using VSTS and Git with defined branching
strategies
● Design of complex data control for handling loading of fact rows into multiple facts
● Extraction of data from multiple disparate sources including SQL, Excel, SAP, and Mainframe
● Scrum master for sprint delivery
● Responsible for engagement with subject matter experts and project and business data owners
● Delivery of a comprehensive and complete set of documentation for the proof of concept and the ongoing architecture development.
● Managing knowledge transfer from contract development team to permanent support team,
including upskilling on the new platforms
Cloud, Proof of concept, VSTS, Hybrid, Production, Development, Support, Safety, Implementation, Growth, Mainframe, Architecture, Design, Data Warehouse, Azure, Scrum master, SAP, Product development, Business Intelligence, Scrum, Git, Sql, Excel
2015 - 2017
job
Business Intelligence Development Manager
Mitie Group.
Responsible for managing delivery of Business Intelligence projects and development in Mitie Group. Implemented process improvements to development process including ITIL compliant release processes, standardised documentation processes, standardised test processes and collaborative federated development to integrate group and divisional teams working on the same projects. Implementation of Visual Studio Team Services and Microsoft Project Server to allow closer integration of project management and Agile development practices with source control and DevOps release processes. Developing key SSIS, SSAS and TSQL and mentoring developers in the more difficult aspects of the SQL stack.
Key data sources include: Property and Asset registers, Security data, project data, finance data, technical maintenance data
Key Deliveries:
New Finance Data Warehouse
• Finance data warehouse covering all divisions in the business integrating SAP, Oracle financials, Sage, Open Accounts, WR1 to a standard format allowing standardised financial reporting across 15 divisions. Improved performance and integration
• New Development processes and environment to empower developers with the tools needed to
• deliver quality outcomes and solutions
Waste Performance Reporting
• Data silo to improve reporting performance over existing legacy reporting (average 97% reduction in reporting times)
• Big Data using Hadoop, Spark and Polybase
• Big Data provided from building sensors, stored in Hadoop and queried using both Spark for Big Data only and Polybase to integrate relational and unstructured data
New Infrastructure moving from On Premise SQL Server 2008 to Cloud Microsoft Azure including
• SaaS and PaaS components with full elasticity across the full stack
• Collaborative implementation with Lockheed Martin Consulting and Vodafone
• Technical lead and senior developer responsible for design and quality of all SSIS, SSAS, TSQL, SSRS and Azure Data Factory implementations
Key data sources include: Property and Asset registers, Security data, project data, finance data, technical maintenance data
Key Deliveries:
New Finance Data Warehouse
• Finance data warehouse covering all divisions in the business integrating SAP, Oracle financials, Sage, Open Accounts, WR1 to a standard format allowing standardised financial reporting across 15 divisions. Improved performance and integration
• New Development processes and environment to empower developers with the tools needed to
• deliver quality outcomes and solutions
Waste Performance Reporting
• Data silo to improve reporting performance over existing legacy reporting (average 97% reduction in reporting times)
• Big Data using Hadoop, Spark and Polybase
• Big Data provided from building sensors, stored in Hadoop and queried using both Spark for Big Data only and Polybase to integrate relational and unstructured data
New Infrastructure moving from On Premise SQL Server 2008 to Cloud Microsoft Azure including
• SaaS and PaaS components with full elasticity across the full stack
• Collaborative implementation with Lockheed Martin Consulting and Vodafone
• Technical lead and senior developer responsible for design and quality of all SSIS, SSAS, TSQL, SSRS and Azure Data Factory implementations
Infrastructure, Consulting, Visual Studio, Integration, Security, Test, Spark, Ssis, SSRS, Implementation, Developer, Finance, SSAS, Development, Senior Developer, Server, Visual studio team services, Tech lead, Processes, Sql server 2008, Manager, Microsoft azure, Sql, Project Management, Business Intelligence, Oracle, SQL Server, SAP, Azure, ITIL, Big Data, DevOps, Design, Agile, Mentoring, Agile development, Saas, Data Warehouse, Cloud, Microsoft Project, Hadoop, Management
2014 - 2015
job
BI Technical Architect and Senior BI Delivery Manager
Musgrove Park Hospital.
Responsible for delivering and designing a new data warehouse solution to fit in line with changed business needs and new Patient Administration System (PAS). Implementation of point in time change capture to replace old full snapshot data capture for census datasets, reducing data held by 95% with 0% loss of granularity. Increases in efficiency of data processing into warehouse from 10 hrs+ to sub 1hr. Implementation of DQS for data validation including validation reporting and dashboards. Definition and delivery of new processes to reflect change in systems. Implementation of Agile development and Kanban to increase pace of delivery and ensure project deadlines adhered to.
● Design of new data warehouse to match up to new PAS system
● Design and implementation of migration of data from old data warehouse to new data
warehouse
● Implementation of Point in time structures
● Technical management of development team
● Implementation of new Agile \ Lean development methods.
● Use of full SQL Server Stack (SSIS SQL Server SSAS SSRS etc.)
● Use of T-SQL and MDX for producing datasets
● SQL Server 2008 and 2014
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● Design of new data warehouse to match up to new PAS system
● Design and implementation of migration of data from old data warehouse to new data
warehouse
● Implementation of Point in time structures
● Technical management of development team
● Implementation of new Agile \ Lean development methods.
● Use of full SQL Server Stack (SSIS SQL Server SSAS SSRS etc.)
● Use of T-SQL and MDX for producing datasets
● SQL Server 2008 and 2014
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
SSRS, Manager, UP, Sql server 2008, Processes, Processing, MDX, BEE, Server, Development, Technical Management, Assessment, SSAS, Implementation, Design, Ssis, T-SQL, Kanban, Management, Lean, Optimization, Data Warehouse, Database, Agile development, Agile, SQL Server, Administration, Sql
2014 - 2014
job
BI Technical Architect
Lifetime Training.
Responsible for delivering BI projects to both internal and external customers. Designing and implementing changes to an existing tabular model based SQL Server 2012 based reporting solution. Design and implementation of a warehouse layer to integrate multiple data sources including SQL Server, MySQL, Excel and Oracle. Use of MDX and DAX against cubes to produce complex datasets for reporting. Design and implementation of hardware changes to make the existing infrastructure suitable for purpose. End to end development of complex internal and client facing reports including KPI, targets and predictions. Cover duties for DBA while new DBA recruited.
● Use of full SQL Server Stack (SSIS SQL Server SSAS SSRS etc.)
● Use of T-SQL,DAX and MDX for producing datasets
● SQL Server 2008 and 2012
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● Hardware and configuration optimisation for In Memory databases
● Design of end to end BI from SSIS to reports in SSRS
● Design of elegant complex reports with collaboration with graphics designers to match
existing materials
● Use of full SQL Server Stack (SSIS SQL Server SSAS SSRS etc.)
● Use of T-SQL,DAX and MDX for producing datasets
● SQL Server 2008 and 2012
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● Hardware and configuration optimisation for In Memory databases
● Design of end to end BI from SSIS to reports in SSRS
● Design of elegant complex reports with collaboration with graphics designers to match
existing materials
Implementation, Sql server 2008, Sql server 2012, MDX, BEE, Server, Development, KPI, Assessment, SSAS, Infrastructure, Hardware, Design, SSRS, Ssis, T-SQL, Optimization, Database, SQL Server, Oracle, Sql, Excel, Mysql
2013 - 2014
job
BI Developer Specialist
GoCompare.com.
Designing and implementing changes to a legacy SQL 2005 data warehouse. Designing and implementing changes to existing data warehouse to introduce datasets with multi-terabyte source tables and hardware optimisation to handle increased load. Migration of legacy SQL Server 2005 platform to SQL Server 2012. Changes to existing ETL to accommodate changing business processes and priorities. Consulting and implementation with other IT streams for SAN and Cloud implementations
● T-SQL Stored Procedures and functions for data processing and loading
● Extraction of data from SQL Server and SSAS cubes using SSIS with TSQL and MDX
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● 2005 to 2012 migration including hardware design.
● Large data loads (single tables > 20Tb)
● T-SQL Stored Procedures and functions for data processing and loading
● Extraction of data from SQL Server and SSAS cubes using SSIS with TSQL and MDX
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● 2005 to 2012 migration including hardware design.
● Large data loads (single tables > 20Tb)
Implementation, Platform, SQL Server 2005, Processes, Sql server 2012, Processing, MDX, SAN, BEE, Server, Assessment, SSAS, Hardware, Developer, Design, It, Ssis, T-SQL, Stored procedures, Consulting, Cloud, Optimization, Data Warehouse, Database, ETL, SQL Server, Sql
2013 - 2013
job
Data Warehouse Architect/Developer
Harding Brothers.
Designing and implementing changes to a failed 3rd party data warehouse implementation.
Migration of data from legacy systems to a SQL Server 2012 platform. Design of ETL, cubes and KPIs.
● T-SQL Stored Procedures and functions for data processing and loading
● Extraction of data from SQL Server and SSAS cubes using SSIS with TSQL and MDX
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● SSAS cube design
Migration of data from legacy systems to a SQL Server 2012 platform. Design of ETL, cubes and KPIs.
● T-SQL Stored Procedures and functions for data processing and loading
● Extraction of data from SQL Server and SSAS cubes using SSIS with TSQL and MDX
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● SSAS cube design
Ssis, Platform, Sql server 2012, Processing, MDX, Server, Assessment, SSAS, Developer, Implementation, Design, T-SQL, Stored procedures, Optimization, Data Warehouse, Database, ETL, SQL Server, Sql
2012 - 2013
job
Reporting Development Manager
OFSTED.
OFSTED
Managing and guiding reporting developers to produce reports and data extracts for business customers. Producing more challenging reports that were outside the skills of the development team. Working with outsource developers to produce changes to the existing data warehouse
● T-SQL Stored Procedures and functions for data processing and loading
● Extraction of data from SQL Server and SSAS cubes using SSIS with TSQL and MDX
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● SSAS cube design
● Production of reports in BIDS and Report Builder.
● Design and implementation of end to end development process including standard
specification templates, P2P testing and change control.
● Design of Any point in time warehouse snapshot process.
Managing and guiding reporting developers to produce reports and data extracts for business customers. Producing more challenging reports that were outside the skills of the development team. Working with outsource developers to produce changes to the existing data warehouse
● T-SQL Stored Procedures and functions for data processing and loading
● Extraction of data from SQL Server and SSAS cubes using SSIS with TSQL and MDX
● Database optimisation using indexes
● Assessment and guidance of future design for the existing warehouse implementation
● SSAS cube design
● Production of reports in BIDS and Report Builder.
● Design and implementation of end to end development process including standard
specification templates, P2P testing and change control.
● Design of Any point in time warehouse snapshot process.
Implementation, Manager, Processing, MDX, Production, Server, Development, Testing, Assessment, SSAS, Design, Ssis, T-SQL, Stored procedures, Optimization, Data Warehouse, Database, SQL Server, Sql
2012 - 2012
job
BI and Warehouse Developer
South West Water.
Design and development of full end to end BI. ETL process from multiple sources. Design of databases including staging, integrated relational model and star schemas. Reporting design in SSRS and SharePoint. Database optimisation including indexes and code optimisation. Managing multiple project workstreams.
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, SQL Server, XML
files and Oracle
● Database optimisation using indexes
● Implementation and design of new hardware and database infrastructure
● SSAS cube design and implementation
● KPI and Dashboard design in SSRS
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, SQL Server, XML
files and Oracle
● Database optimisation using indexes
● Implementation and design of new hardware and database infrastructure
● SSAS cube design and implementation
● KPI and Dashboard design in SSRS
Ssis, Processing, BEE, Server, Development, KPI, SSAS, Infrastructure, Hardware, Developer, Implementation, SSRS, Design, T-SQL, Stored procedures, Optimization, Database, ETL, SharePoint, XML, SQL Server, Oracle, Sql, Excel
2012 - 2012
job
BI Technical Architect and Lead Developer
East London and City NHS Commissioning Support Service.
Design and development of full end to end BI. ETL process from multiple sources. Design of databases including staging, integrated relational model and star schemas. Design of hardware architecture on a virtual platform including load balancing and DR. reporting design in SSRS and SharePoint. Database optimisation including indexes and code optimisation
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, SQL Server, XML
files and Oracle (including Exeter, SLAM and SUS/PbR Mart)
● Database optimisation using indexes
● Implementation and design of new hardware and database infrastructure
● SSAS cube design and implementation
● KPI and Dashboard design in SSRS
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, SQL Server, XML
files and Oracle (including Exeter, SLAM and SUS/PbR Mart)
● Database optimisation using indexes
● Implementation and design of new hardware and database infrastructure
● SSAS cube design and implementation
● KPI and Dashboard design in SSRS
SSRS, Platform, Processing, BEE, Server, Development, KPI, Load balancing, Lead developer, SSAS, Infrastructure, Hardware, Developer, Implementation, Design, Ssis, Architecture, T-SQL, Stored procedures, Optimization, Database, ETL, SharePoint, XML, SQL Server, Oracle, Sql, Excel
2011 - 2012
job
Data warehousing and BI Senior Developer
Heatherwood and Wexham Park Hospitals NHS Foundation Trust.
Development of new logic-based warehouse for identifying patient pathways for the 18 Week reporting process using the SQL Server Stack
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, SQL Server, XML
files
● Database optimisation using indexes
● Integration with Existing warehouse
● Analysis and dissection of existing Access based model
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, SQL Server, XML
files
● Database optimisation using indexes
● Integration with Existing warehouse
● Analysis and dissection of existing Access based model
Integration, Processing, Logic, BEE, Server, Senior Developer, Development, Developer, Ssis, Excel, T-SQL, Stored procedures, Optimization, Database, XML, SQL Server, Sql
2011 - 2011
job
Data warehousing and BI Senior Developer
Wolverhampton City NHS Primary Care Trust.
Responsible for creating new import ETL systems for XML, Database and Flat file sources. Development of new Suites of reports around GP commissioning and contract performance. Technical lead on hardware refresh project. Development of data extracts for provision to external organisations.
● On-going development and implementation and of existing in house data warehouse built in SQL Server, SSAS and SSIS.
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, SQL Server, XML
files
● Database optimisation using indexes
● KPI and Performance dashboards in SSRS
● Reporting Suite design in SSRS
Data warehousing and BI Team Lead 2011 Bristol City Council Mar 2011 - Jul
Responsible for developing a new data warehouse and associated BI structures. Design and implementation of new hardware platform. Development of SSAS Cubes and SQL Server based star schemas for a central data warehouse. Development of SSRS and Performance point reporting based on SQL server and SSAS cube data sources. Mentoring of junior team members. Scrum Lead for Agile.
● Design, development and implementation and of in-house data warehouse built in SQL Server, SSAS and SSIS.
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, Oracle, SQL
Server, Sybase Advantage Server
● Database optimisation using indexes
● KPI and Performance dashboards in Performance Point and SSAS
● Reporting design in SSRS
● On-going development and implementation and of existing in house data warehouse built in SQL Server, SSAS and SSIS.
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, SQL Server, XML
files
● Database optimisation using indexes
● KPI and Performance dashboards in SSRS
● Reporting Suite design in SSRS
Data warehousing and BI Team Lead 2011 Bristol City Council Mar 2011 - Jul
Responsible for developing a new data warehouse and associated BI structures. Design and implementation of new hardware platform. Development of SSAS Cubes and SQL Server based star schemas for a central data warehouse. Development of SSRS and Performance point reporting based on SQL server and SSAS cube data sources. Mentoring of junior team members. Scrum Lead for Agile.
● Design, development and implementation and of in-house data warehouse built in SQL Server, SSAS and SSIS.
● T-SQL Stored Procedures and functions for data processing and loading
● Data transfer in SSIS from a large variety of sources including flat file, Excel, Oracle, SQL
Server, Sybase Advantage Server
● Database optimisation using indexes
● KPI and Performance dashboards in Performance Point and SSAS
● Reporting design in SSRS
Ssis, Platform, Processing, Tech lead, BEE, Server, Senior Developer, Development, KPI, SSAS, Hardware, Developer, Sybase, Implementation, SSRS, Design, T-SQL, Stored procedures, Optimization, Data Warehouse, Database, ETL, Mentoring, Agile, XML, SQL Server, Oracle, Scrum, Sql, Excel
2010 - 2011
job
Data warehousing and Reporting Lead Developer
Western Sussex Hospitals Trust.
Responsible for design and implementation of a data warehouse for Service Line reporting and management. Working with admin and clinical staff to ensure needs of all users are catered for.
● Design, development and implementation and of in house data warehouse built in SSAS, SSRS and SSIS.
● Data transfer optimisation in SSIS
● Database optimisation using indexes
● KPI and Performance dashboards in SharePoint and SSAS
● Design, development and implementation and of in house data warehouse built in SSAS, SSRS and SSIS.
● Data transfer optimisation in SSIS
● Database optimisation using indexes
● KPI and Performance dashboards in SharePoint and SSAS
Design, SharePoint, Database, Data Warehouse, Optimization, Management, Service, Ssis, SSRS, Implementation, Developer, SSAS, Lead developer, KPI, Development
2010 - 2010
job
Data warehousing and Reporting Project Lead
Wessex Water PLC.
Project lead and senior developer for re-development of a failed mission critical data warehouse. Re- design using Kimball data warehousing principles. Implementation of design in SSIS, SSAS and T-SQL. Implementation of SSRS reporting and Surface Analytics for cube mining.
● Implementation and re-development of in-house data warehouse built in SSAS, SSRS and SSIS.
● Implementation of reporting in SSRS and Surface Analytics
● Optimisation and correction of data import procedures to remove duplication and improve
load times
● Design and implementation of new data warehousing hardware infrastructure
● Implementation and re-development of in-house data warehouse built in SSAS, SSRS and SSIS.
● Implementation of reporting in SSRS and Surface Analytics
● Optimisation and correction of data import procedures to remove duplication and improve
load times
● Design and implementation of new data warehousing hardware infrastructure
Design, Sql, Data Warehouse, Optimization, T-SQL, Analytics, Ssis, SSRS, Implementation, Developer, Hardware, Infrastructure, SSAS, Development, Senior Developer, Kimball
2010 - 2010
job
Senior DBA / Data warehousing Lead
Avon and Wiltshire Partnership Mental Health NHS Trust.
Senior DBA covering both production and development. Working on major projects including migration of SQL Servers to new hardware and version (2005 - 2008), hardware/DR re-design and implementation, new applications, data/system migration and data warehousing (Kimball)
● Redesign and implementation of new hardware platforms for SQL Servers.
● Planning and re-design of DR and backup solutions.
● Introduction of monitoring solutions as part of a new proactive approach to DB
administration.
● Introduction of change control processes to stop adhoc updates to live databases
● Administration of SQL Server versions 2005 and 2008
● Optimisation of existing 3rd party data warehouse to reduce load times to an acceptable
level
● Optimisation of data migration process to reduce run times and correct process errors
● Implementation and re-development of 3rd party data warehouse built in SSAS, SSRS and SSIS.
● KPI and Performance dashboards in Sharepoint and SSAS
House renovations prior to moving and break with children/adoption Dec 2009 to Apr 2010
● Redesign and implementation of new hardware platforms for SQL Servers.
● Planning and re-design of DR and backup solutions.
● Introduction of monitoring solutions as part of a new proactive approach to DB
administration.
● Introduction of change control processes to stop adhoc updates to live databases
● Administration of SQL Server versions 2005 and 2008
● Optimisation of existing 3rd party data warehouse to reduce load times to an acceptable
level
● Optimisation of data migration process to reduce run times and correct process errors
● Implementation and re-development of 3rd party data warehouse built in SSAS, SSRS and SSIS.
● KPI and Performance dashboards in Sharepoint and SSAS
House renovations prior to moving and break with children/adoption Dec 2009 to Apr 2010
SSAS, System Migration, Processes, Kimball, Redesign, Production, Server, Backup, Development, KPI, Monitoring, Design, Hardware, Implementation, SSRS, Ssis, Optimization, Data Warehouse, SharePoint, SQL Server, Administration, Sql
2009 - 2009
job
Production\Development Senior DBA
Lloyds TSB Wholesale Credit Risk Intelligence.
Senior DBA working to performance tune systems to provide services within strict time SLAs. Including SSIS/DTS improvement, query optimisation, structure optimisation, indexing and developer education into best practice. SQL Server 2000 - 2008 platforms
• Development and testing of performance improvements in warehouse loading procedures that resulted in reducing load times by 60%
• Optimisation of indexing to improve loading of data and running of queries
• Optimisation of long running queries and procedures to increase application efficiency
• Optimisation of database and OS configuration to provide the best performance from available hardware.
• Redesign of inefficient data structures to improve access to data.
• Development and testing of performance improvements in warehouse loading procedures that resulted in reducing load times by 60%
• Optimisation of indexing to improve loading of data and running of queries
• Optimisation of long running queries and procedures to increase application efficiency
• Optimisation of database and OS configuration to provide the best performance from available hardware.
• Redesign of inefficient data structures to improve access to data.
Sql, SQL Server, Database, Optimization, Ssis, Developer, Hardware, Testing, Development, Server, Production, Redesign
2008 - 2009
job
Production\Development Senior DBA (BI Specialist)
Nokia Software and Services.
Senior member of a team of DBAs with responsibility for running 50+ SQL Servers across 3 data centres with a combined data volume in excess of 100TB. These included live production systems, reporting systems (including large scale SSIS, SSAS and SSRS functionality), and development systems. SQL Server versions used 2000 - 2008. Migration of servers from 2000 - 2005 and 2005 - 2008 and migration between data centres
• Responsibility for high availability implementation and maintenance with SLA on system of 99.99%
• Analysis and performance tuning of existing system to allow an increased load across a smaller server footprint.
• Analysis of current and past growth to give accurate future requirements
• Migration of live systems between old and new data centres
• Migration of live, dev and test systems between versions (2000 - 2005- 2008)
• Provision of data for adhoc requests and refreshes for development platforms within tight SLA time schedules
• Responsible for day to day issues with SLA controlled by BMC Remedy
• Experience of developing and releasing within an Agile environment.
• Design and implementation of new Data warehouse system including hardware and software design for reporting on feeds from 100+ online stores in 30+ countries
• Working within strict Change Management processes raising RFCs and attending CAB meetings
• Design and implementation of BI infrastructure including hardware and OS\Database implementation design.
• Responsibility for high availability implementation and maintenance with SLA on system of 99.99%
• Analysis and performance tuning of existing system to allow an increased load across a smaller server footprint.
• Analysis of current and past growth to give accurate future requirements
• Migration of live systems between old and new data centres
• Migration of live, dev and test systems between versions (2000 - 2005- 2008)
• Provision of data for adhoc requests and refreshes for development platforms within tight SLA time schedules
• Responsible for day to day issues with SLA controlled by BMC Remedy
• Experience of developing and releasing within an Agile environment.
• Design and implementation of new Data warehouse system including hardware and software design for reporting on feeds from 100+ online stores in 30+ countries
• Working within strict Change Management processes raising RFCs and attending CAB meetings
• Design and implementation of BI infrastructure including hardware and OS\Database implementation design.
Growth, Processes, Tuning, Production, BEE, Server, Online, Software, Development, SSAS, Infrastructure, Hardware, Implementation, Design, Remedy, SSRS, Software design, Ssis, Test, Management, Data Warehouse, Database, Agile, SQL Server, Change management, Sql
2007 - 2008
temp
Contract Production\Development Senior DBA \ Architect
Weston Area Hospital Trust (NHS).
Microsoft SQL Server DBA role comprising overall ownership of all SQL Servers and associated applications
• Migration of Databases from SQL Server 7.0 and 2000 to SQL Server 2005
• Implementation of MSSQL 2005 Cluster based on Dell\EMC ISCSI SAN and Windows 2003 servers
• Construction of a Data warehouse for Statutory NHS reporting from flat files including DTS and SSIS for file verification and importing
• Implementation of SQL Server Reporting services and automation of complex reports via stored procedures
• Implementation of backup and recovery strategies
• Troubleshooting and performance tuning previous developments on the SQL Server platform
• Migration of web applications and implementation of reports via existing site intranet
• Mentoring of student placement and Long-term sick returnee to create a stable replacement for myself
• Primary tech lead on RTT 18 weeks in house developed solution. Working with clinical and administration staff to provide a solution that is efficient and fits in with current working practices.
• Developing database solutions to provide a full patient care lifecycle visibility for patients staring from referral to definitive treatment to allow better management of the RTT 18-week goals including hotlists of breach and close to breach patients to allow priority booking.
• Migration of Databases from SQL Server 7.0 and 2000 to SQL Server 2005
• Implementation of MSSQL 2005 Cluster based on Dell\EMC ISCSI SAN and Windows 2003 servers
• Construction of a Data warehouse for Statutory NHS reporting from flat files including DTS and SSIS for file verification and importing
• Implementation of SQL Server Reporting services and automation of complex reports via stored procedures
• Implementation of backup and recovery strategies
• Troubleshooting and performance tuning previous developments on the SQL Server platform
• Migration of web applications and implementation of reports via existing site intranet
• Mentoring of student placement and Long-term sick returnee to create a stable replacement for myself
• Primary tech lead on RTT 18 weeks in house developed solution. Working with clinical and administration staff to provide a solution that is efficient and fits in with current working practices.
• Developing database solutions to provide a full patient care lifecycle visibility for patients staring from referral to definitive treatment to allow better management of the RTT 18-week goals including hotlists of breach and close to breach patients to allow priority booking.
Ssis, Platform, SQL Server 2005, Tuning, SAN, EMC, Production, Booking, Server, Web, Backup, Development, Implementation, Sql, Windows, Stored procedures, Management, Microsoft SQL, MSSQL, Microsoft SQL Server, Data Warehouse, Database, Automation, Mentoring, SQL Server, Administration
2001 - 2006
job
Production\Development DBA
Bristol Port Company.
Microsoft SQL Server DBA role comprising of all production, development and support functions including migration (hardware and version from 6.5 to 2005) disaster recovery solutions, data warehousing and reporting and assessment of new technologies.
• Disaster recovery and prevention
• Version and service pack testing and upgrading. All service packs from 6.5(1) to 2005 and latest release security fixes
• Development and maintenance of replicated data between servers for resilience across a 60 square mile site. Also, to a web server within a DMZ for secure web access to live data from production systems. Methodology used includes combination of SQL Server replication, Active Directory Object replication and DTS
• Development and design of database models both logical and physical for all port applications using tools such as ERWin and ERstudio.
• Development of server-side business rules using triggers, rules and constraints
• Development of custom triggers, stored procedures and indexes using T-SQL
• Testing and vetting of T-SQL objects for all changes to be made to production systems
• Performance tuning of databases including server configuration, procedure and trigger tuning and index tuning.
• Specification, procurement, set-up and installation of all new database servers including operating system and networking
• General ongoing DBA tasks such as backup maintenance, monitoring of production systems for blocks and deadlocks, etc.
• Profiling of database systems to allow efficient tuning using multiple applications
• Determining and negotiating licensing for database systems and third party software for database development and maintenance.
• Configuration of all clients (SQL Server, ODBC, IDAPI and BDE32)
• Setting out best practice policy for development, release and maintenance of back-end and front end systems
• Managing development of version control and release control systems for bespoke software implemented on the company intranet
• Scripting
• Microsoft Project Server 2002 Administrator
• Installation and maintenance of all database servers including OS (NT 4 and Windows
• 2000 and 2003 Server (Standard and Advanced) Assessing new technologies and planning implementation
Responsible for developing data warehouse and reporting solutions:
Development of data warehouse of all aspects of business data in SQL Server and SQL Server Analysis Services using Microsoft Data Analyzer as the primary query tool
Development of reports using MS SQL Reporting Services and Visual Studio .NET
Use of DTS to create a cross platform data warehouse allowing comparison of data from different database platforms including SQL Server, Informix, Fox Pro, Sybase, Universe etc.
Development of strategy for increased user use and acceptance of new reporting and data warehouse systems and tools
Tools used
• Disaster recovery and prevention
• Version and service pack testing and upgrading. All service packs from 6.5(1) to 2005 and latest release security fixes
• Development and maintenance of replicated data between servers for resilience across a 60 square mile site. Also, to a web server within a DMZ for secure web access to live data from production systems. Methodology used includes combination of SQL Server replication, Active Directory Object replication and DTS
• Development and design of database models both logical and physical for all port applications using tools such as ERWin and ERstudio.
• Development of server-side business rules using triggers, rules and constraints
• Development of custom triggers, stored procedures and indexes using T-SQL
• Testing and vetting of T-SQL objects for all changes to be made to production systems
• Performance tuning of databases including server configuration, procedure and trigger tuning and index tuning.
• Specification, procurement, set-up and installation of all new database servers including operating system and networking
• General ongoing DBA tasks such as backup maintenance, monitoring of production systems for blocks and deadlocks, etc.
• Profiling of database systems to allow efficient tuning using multiple applications
• Determining and negotiating licensing for database systems and third party software for database development and maintenance.
• Configuration of all clients (SQL Server, ODBC, IDAPI and BDE32)
• Setting out best practice policy for development, release and maintenance of back-end and front end systems
• Managing development of version control and release control systems for bespoke software implemented on the company intranet
• Scripting
• Microsoft Project Server 2002 Administrator
• Installation and maintenance of all database servers including OS (NT 4 and Windows
• 2000 and 2003 Server (Standard and Advanced) Assessing new technologies and planning implementation
Responsible for developing data warehouse and reporting solutions:
Development of data warehouse of all aspects of business data in SQL Server and SQL Server Analysis Services using Microsoft Data Analyzer as the primary query tool
Development of reports using MS SQL Reporting Services and Visual Studio .NET
Use of DTS to create a cross platform data warehouse allowing comparison of data from different database platforms including SQL Server, Informix, Fox Pro, Sybase, Universe etc.
Development of strategy for increased user use and acceptance of new reporting and data warehouse systems and tools
Tools used
Software, Net, Sybase, Support, Hardware, Assessment, Monitoring, Testing, Development, Backup, Implementation, Web, Server, Administrator, Production, Tuning, UP, Server Configuration, Platform, Microsoft SQL Server, Sql, SQL Server, Networking, Active Directory, Scripting, Procurement, Database, Data Warehouse, Design, Microsoft SQL, Microsoft Project, Stored procedures, T-SQL, Visual Studio, Security, Service, Windows
2000 - 2001
job
Database Support Analyst/Developer
ARVAL PHH ltd.
Swindon Wilts
• Database Support Analyst/Developer
• Database Support Analyst/Developer
Database, Developer, Support, Analyst
My education
1996
-
1998
n/a
Hndhncorequivalent, Computing
Hndhncorequivalent, Computing
1995
-
1996
University of Surrey
BSc, Chemistry for Europe
BSc, Chemistry for Europe
Matt's reviews
Matt has not received any reviews on Worksome.
Contact Matt Thompson
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Matt 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