$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
BI Developer, Microsoft Certified, Power BI, SSIS, SQL, SSRS, SSAS
David Solomons
,
Hemel Hempstead, United Kingdom
Experience
Other titles
Skills
I'm offering
I am a full stack Microsoft Business Intelligence developer with 10 years of experience, a Computer Science Degree from King's College London and Microsoft Certified in SQL 2016 Database Development. I create solutions using Azure, Power BI, SSIS, SSAS, SSRS and I am very proficient at writing complex T-SQL. I am highly experienced in creating Data Warehouses using Kimball methodology and reporting solutions with Power BI. I am passionate about my work from a technical standpoint and also delivering valuable business solutions. Throughout my career I have had the pleasure of working with a range of methods and as a result have learnt advanced modern Metadata driven techniques. Having worked in test focused environments, I have developed an approach to projects where testing is performed throughout the process and, where possible, re-used as part of an ETL loading process for future quality assurance. I have written T-SQL scripts that auto generate elements of ETL loading processes to speed up code development.
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Available
My experience
2019 - ?
job
Business Intelligence Developer
Allvotec www.allvotec.com.
Main duties: Responsible for data and Power BI development
Technology: Power BI, Azure Integrations, Data Factory, SSRS, SQL Server 2016, Azure DevOps
● Analysis of existing data and reporting solutions.
● Architecting Azure and Power BI infrastructure.
● Data warehouse development using Kimball methodology.
● Data Factory Pipeline development.
● Manage task tracking and source control using Azure DevOps.
● Creating a citizen reporting model.
● Power BI dashboard development including tool tip reports, DAX and drill through data.
● Dashboards for support ticket metrics, HR and team skills.
● Training staff on Power BI.
Technology: Power BI, Azure Integrations, Data Factory, SSRS, SQL Server 2016, Azure DevOps
● Analysis of existing data and reporting solutions.
● Architecting Azure and Power BI infrastructure.
● Data warehouse development using Kimball methodology.
● Data Factory Pipeline development.
● Manage task tracking and source control using Azure DevOps.
● Creating a citizen reporting model.
● Power BI dashboard development including tool tip reports, DAX and drill through data.
● Dashboards for support ticket metrics, HR and team skills.
● Training staff on Power BI.
SSRS, Kimball, Sql server 2016, Power, Server, BEE, Development, Infrastructure, Support, Developer, Sql, Technology, Data Warehouse, Power BI, Training, DevOps, Azure, SQL Server, Business Intelligence
2018 - 2019
job
SQL developer
Frontier Economics www.frontier-economics.com.
Main duties: Responsible for data mart and ETL development
Technology: SQL Server 2016, SSIS, CozyRoc, Red Gate, Azure DevOps
● Architect the framework for all ETL processes.
● Built the company's first Data Mart for finance and consultancy utilisation planning using Kimball data modelling and project methodology.
● Real time Data Mart development.
● Spring planning using Azure DevOps
● Dynamic data volume loading, to reduce processing time.
● Data driven solutions to handle GDPR requirements.
● Dynamic colour coded exceptions reports.
● Created data processing warehouses for Royal Mail PAF data and International Finance Calendars.
● Use of SSIS plugins to interact with Exchange mailboxes.
● Integrations development to connect websites, third party providers and SAP.
● Training staff on SQL and SSIS development.
● Automated test data scripts in conjunction with Red Gate SQL Data Generator.
Technology: SQL Server 2016, SSIS, CozyRoc, Red Gate, Azure DevOps
● Architect the framework for all ETL processes.
● Built the company's first Data Mart for finance and consultancy utilisation planning using Kimball data modelling and project methodology.
● Real time Data Mart development.
● Spring planning using Azure DevOps
● Dynamic data volume loading, to reduce processing time.
● Data driven solutions to handle GDPR requirements.
● Dynamic colour coded exceptions reports.
● Created data processing warehouses for Royal Mail PAF data and International Finance Calendars.
● Use of SSIS plugins to interact with Exchange mailboxes.
● Integrations development to connect websites, third party providers and SAP.
● Training staff on SQL and SSIS development.
● Automated test data scripts in conjunction with Red Gate SQL Data Generator.
Finance, Processes, Kimball, Framework, Processing, Sql server 2016, International, Server, Development, Developer, Technology, Ssis, Sql, Test, Spring, ETL, GDpr, Exchange, SAP, Training, DevOps, Azure, Websites, SQL Server
2017 - 2018
job
Data Warehouse Developer
David Lloyd Leisure www.davidlloyd.co.uk.
Main duties: Responsible for all Data Warehouse Development
Technology: SQL Server 2012, SSAS, SSIS, SSRS, Power BI
● Completed an extended Data Warehouse project and delivered it to production.
● Built the company's first automated Financial Accounts process to load from Transactional System through to Accounts Financial Package.
● Performed all the Business Analysis to complete the project, interacting with all levels of stakeholders.
● Delivered projects on time by creating Automated testing systems that doubled up as integral parts of the Data Warehouse ETL process.
● Build processes to reduce daily ETL loading volumes dramatically, with a 'self healing' process to load historical data where issues were detected.
● Built high impact SSAS Cubes.
● Data modelling utilising a Kimball methodology design.
● Power BI dashboard development for finance.
● Proactively educate the team and produce lessons learnt after delivering projects.
● Built processes to assist in the automation of code production to save time and improve accuracy.
Technology: SQL Server 2012, SSAS, SSIS, SSRS, Power BI
● Completed an extended Data Warehouse project and delivered it to production.
● Built the company's first automated Financial Accounts process to load from Transactional System through to Accounts Financial Package.
● Performed all the Business Analysis to complete the project, interacting with all levels of stakeholders.
● Delivered projects on time by creating Automated testing systems that doubled up as integral parts of the Data Warehouse ETL process.
● Build processes to reduce daily ETL loading volumes dramatically, with a 'self healing' process to load historical data where issues were detected.
● Built high impact SSAS Cubes.
● Data modelling utilising a Kimball methodology design.
● Power BI dashboard development for finance.
● Proactively educate the team and produce lessons learnt after delivering projects.
● Built processes to assist in the automation of code production to save time and improve accuracy.
It, Processes, UP, Kimball, Sql server 2012, Production, Power, Server, BEE, SSAS, Development, Testing, Developer, Design, SSRS, Technology, Ssis, Finance, ETL, Data Warehouse, Automation, Power BI, Business Analysis, SQL Server, Sql
2016 - 2017
job
Data Warehouse Developer
Merkle.
Main duties: Developing new features for the SCV Data Warehouse for client Volkswagen Group
Technology: T-SQL, SSMS, SSIS, Visual Studio, tSQLt, Red Gate, Trello, SQL Server 2012
● Working on the premier VW Group account for the agency.
● Developing new features for the in-house data loading system using advanced Metadata driven design principles.
● Creating complex T-SQL driven transformations to handle unstructured data.
● Creating new data structures using Kimball methodology.
● Developing projects using a strong test focused approach.
● Add new data feeds to integrate with sizeable Data Warehouse.
● Strict use of source control for all aspects of development.
● Creating automated Unit Tests and working alongside Quality Assurance to ensure complete test coverage.
● Creating Client facing Statement of Work documents to formally capture development requests to state deliverables and financial costings.
● Strong understanding of de-duplication processes and analysis.
● Peer-reviewing and mentoring to pass on knowledge and empower colleagues.
● Coordinating between teams for high impact deployments and taking ownership of the process.
● Exposure to Business Intelligence Mark Up Language (BIML).
Technology: T-SQL, SSMS, SSIS, Visual Studio, tSQLt, Red Gate, Trello, SQL Server 2012
● Working on the premier VW Group account for the agency.
● Developing new features for the in-house data loading system using advanced Metadata driven design principles.
● Creating complex T-SQL driven transformations to handle unstructured data.
● Creating new data structures using Kimball methodology.
● Developing projects using a strong test focused approach.
● Add new data feeds to integrate with sizeable Data Warehouse.
● Strict use of source control for all aspects of development.
● Creating automated Unit Tests and working alongside Quality Assurance to ensure complete test coverage.
● Creating Client facing Statement of Work documents to formally capture development requests to state deliverables and financial costings.
● Strong understanding of de-duplication processes and analysis.
● Peer-reviewing and mentoring to pass on knowledge and empower colleagues.
● Coordinating between teams for high impact deployments and taking ownership of the process.
● Exposure to Business Intelligence Mark Up Language (BIML).
Technology, Processes, UP, Kimball, Sql server 2012, Server, Development, Trello, Quality Assurance, Developer, Design, Ssis, T-SQL, Test, Visual Studio, Mentoring, Data Warehouse, SQL Server, Business Intelligence, Sql
2015 - 2016
job
Data Warehouse Developer
[PIAS] www.pias.com.
Main duties: Developing for Big Data Warehouse and investigating data quality issues.
Technology: SSIS, SSMS, T-SQL, Tableau, Target Process, SQL Server 2012
● Completed a Data Warehouse project and delivered it to production.
● Work within a Data Warehouse with many datasets into the trillions of rows.
● Creating data structures using Star Schema and Kimball methodology.
● Improve speed of stored procedures and identify missing indexes.
● Major infrastructure changes to improve transparency in data marts.
● C# code amendments within existing packages.
● Create and modify procedures to calculate future trends within data.
● Train and coach colleagues.
● Tableau Dashboard development.
Technology: SSIS, SSMS, T-SQL, Tableau, Target Process, SQL Server 2012
● Completed a Data Warehouse project and delivered it to production.
● Work within a Data Warehouse with many datasets into the trillions of rows.
● Creating data structures using Star Schema and Kimball methodology.
● Improve speed of stored procedures and identify missing indexes.
● Major infrastructure changes to improve transparency in data marts.
● C# code amendments within existing packages.
● Create and modify procedures to calculate future trends within data.
● Train and coach colleagues.
● Tableau Dashboard development.
Data quality, Kimball, Sql server 2012, Production, Server, Development, Coach, Infrastructure, Developer, It, Sql, Technology, Ssis, T-SQL, Stored procedures, Tableau, C, Data Warehouse, Big Data, SQL Server
2014 - 2015
job
SQL Developer
Bourne Leisure Ltd www.bourneleisuresales.co.uk.
Holiday company comprising of Butlins, Haven Holidays and Warner Leisure.
Position: SQL Developer
Main duties: Maintaining ERP simulation/Financial dashboards/Data Warehouse Development
Technology: SSIS, SSAS, SSRS, SSMS, T-SQL, Oracle PL/SQL, Red Gate, SQL Server 2008 & 2012
● Develop ETL solutions for single customer view Data Warehouse project.
● Amend existing systems, including the company financial statpack, customer facing invoicing system and dashboards.
● Develop SSAS cubes for Financial Purchasing.
● Train and coach colleagues.
● Communicate with a wide range of stakeholders and customers.
● C# analysis to diagnose application/database issues.
Position: SQL Developer
Main duties: Maintaining ERP simulation/Financial dashboards/Data Warehouse Development
Technology: SSIS, SSAS, SSRS, SSMS, T-SQL, Oracle PL/SQL, Red Gate, SQL Server 2008 & 2012
● Develop ETL solutions for single customer view Data Warehouse project.
● Amend existing systems, including the company financial statpack, customer facing invoicing system and dashboards.
● Develop SSAS cubes for Financial Purchasing.
● Train and coach colleagues.
● Communicate with a wide range of stakeholders and customers.
● C# analysis to diagnose application/database issues.
Ssis, Sql server 2008, Oracle PL/SQL, Server, SSAS, Development, Coach, Developer, SSRS, Technology, Sql, T-SQL, Pl/sql, ETL, C, Data Warehouse, Database, ERP, Oracle, SQL Server
2014 - 2014
job
SQL Developer
unknown.
(Ascend Support Analyst (3yrs 10 months) / Retail Software Trainer and Installer (1yr 11 months))
Main duties: Develop extended business logic data sets and analysis.
Technology: SQL Server 2005 - 2014, T-SQL, SSMS
● Develop complex SQL for integration with application to provide Financial and stock information.
● Software Analyst for Bugs and Enhancements for in house.NET Application.
● Awarded rare $1000 prize by Company CEO for a business improving idea.
● SQL trainer and document application specific business rules.
● C# analysis to diagnose Database issues.
● Travel internationally to support US and Swiss teams.
Main duties: Develop extended business logic data sets and analysis.
Technology: SQL Server 2005 - 2014, T-SQL, SSMS
● Develop complex SQL for integration with application to provide Financial and stock information.
● Software Analyst for Bugs and Enhancements for in house.NET Application.
● Awarded rare $1000 prize by Company CEO for a business improving idea.
● SQL trainer and document application specific business rules.
● C# analysis to diagnose Database issues.
● Travel internationally to support US and Swiss teams.
Technology, SQL Server 2005, Logic, Server, Software, Ceo, Analyst, Support, Developer, Sql, Net, T-SQL, Integration, C, Database, Retail, SQL Server, .Net
My education
University of London
Computer Science, N/a
Computer Science, N/a
Vyners School
Secondary, Computer Science
Secondary, Computer Science
?
-
2016
Kings College London
Associate, Database Development
Associate, Database Development
David's reviews
David has not received any reviews on Worksome.
Contact David Solomons
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to David 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