$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Lead Business Intelligence Developer/Analyst
Karyn Jackson
,
Ellesmere Port, United Kingdom
Experience
Other titles
Skills
I'm offering
Highly skilled and motivated LEAD BUSINESS INTELLIGENCE DEVELOPER with more than 15 years experience designing and building Data Warehouses, extracting, transforming and loading data in Integration Services, designing and developing cubes in Analysis Services, developing reports and dashboards in Reporting Services/Power BI. Now seeking a new challenging and rewarding opportunity to demonstrate abilities and make an effective contribution to a successful organisation.
Markets
United States
United Kingdom
France
Germany
Lithuania
Denmark
Norway
Sweden
Finland
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2018 - 2020
freelance
Lead Business Intelligence Developer
Keoghs.
• Implemented, designed and maintained a Data Warehouse using Azure Data Platform and Azure Data Factory. This incorporated dimensional modelling, design and build of ETL processes, design and build of Analysis Services cube, design and build of SSRS and Power BI reports to provide insight on the law firms data.
• Stakeholder engagement with Corporate Risk staff at all levels within the organisation to gather requirements and deliver solutions to meet company strategy, including meeting with Clients.
• Leading and mentoring a team of developers/analysts working in an Agile team.
• Migrated a suite of reports from Crystal Reports to SSRS and PowerBI.
Technologies Used: Azure, Azure Data Factory, SQL Server 2017, SSRS 2017, SSIS 2017, SSAS 2017, Power BI, DAX, SSAS Tabular Models, working within an Agile environment using Scrum, Azure DevOps
• Stakeholder engagement with Corporate Risk staff at all levels within the organisation to gather requirements and deliver solutions to meet company strategy, including meeting with Clients.
• Leading and mentoring a team of developers/analysts working in an Agile team.
• Migrated a suite of reports from Crystal Reports to SSRS and PowerBI.
Technologies Used: Azure, Azure Data Factory, SQL Server 2017, SSRS 2017, SSIS 2017, SSAS 2017, Power BI, DAX, SSAS Tabular Models, working within an Agile environment using Scrum, Azure DevOps
Data Warehouse, Processes, Dimensional modelling, Power, Server, Organization, BEE, SSAS, SSRS, Ssis, Design, ETL, Mentoring, Agile, Power BI, DevOps, Azure, SQL Server, Scrum, Sql
2017 - 2018
freelance
Lead Business Intelligence Developer
Kitbag.
• Implemented, designed and maintained a Data Warehouse using Azure Data Platform and Azure Data Factory. This incorporated dimensional modelling, design and build of ETL processes, design and build of Analysis Services cube, design and build of SSRS and Power BI reports.
• Used SSIS to extract data from SharePoint Lists, Access databases, Excel, Websites and databases to build a SSAS cube for Management Reporting. Migration of Access and Excel reports into SSRS.
• Developed a reporting environment using SSRS, Performance Point and SharePoint to create Management Information Reports.
Technologies Used: Azure, Azure Data Factory, SQL Server 2016/2014, SSRS 2016/2014, SSIS 2016/2014, SSAS 2016/2014, Power BI, DAX, SSAS Tabular Models, C#.NET, MDX, Agile
• Used SSIS to extract data from SharePoint Lists, Access databases, Excel, Websites and databases to build a SSAS cube for Management Reporting. Migration of Access and Excel reports into SSRS.
• Developed a reporting environment using SSRS, Performance Point and SharePoint to create Management Information Reports.
Technologies Used: Azure, Azure Data Factory, SQL Server 2016/2014, SSRS 2016/2014, SSIS 2016/2014, SSAS 2016/2014, Power BI, DAX, SSAS Tabular Models, C#.NET, MDX, Agile
Management, Processes, MDX, Sql server 2016, Dimensional modelling, Power, Server, BEE, SSAS, Management Reporting, Developer, SSRS, Net, Ssis, Design, Data Warehouse, ETL, C, Agile, SharePoint, Power BI, Azure, Websites, SQL Server, Business Intelligence, Excel, Sql
2015 - 2016
freelance
Senior Business Intelligence Developer
SSFT.
• Built a Data Warehouse from scratch. This incorporated dimensional modelling, design and build of ETL processes, design and build of Analysis Services cube, design and build of security model.
• Developed a reporting environment using SSRS and SharePoint to create Management Information Reports and KPI dashboards.
Technologies Used: SQL Server 2014/2012, SSRS 2014/2012, SSIS 2014/2012, SSAS 2014/2012, SharePoint 2013, Tableau
• Developed a reporting environment using SSRS and SharePoint to create Management Information Reports and KPI dashboards.
Technologies Used: SQL Server 2014/2012, SSRS 2014/2012, SSIS 2014/2012, SSAS 2014/2012, SharePoint 2013, Tableau
Ssis, Processes, Sql server 2014, Dimensional modelling, Server, KPI, SSAS, Developer, SSRS, Security, Design, Management, Tableau, Data Warehouse, ETL, SharePoint, SQL Server, Business Intelligence, Sql
2013 - 2015
freelance
Senior Business Intelligence Developer
inAnalytics.
• Lead Data Warehouse Developer for the build of Cheshire & Merseyside CSU Business Intelligence Platform for delivery to 12 CCGs. This incorporated dimensional modelling, design and build of ETL processes, design and build of Analysis Services cube, design and build of security model for CCG and Practice access.
• Used SAS to create predictive models and dashboards for GPs and Providers to monitor key metrics and spot trends and patterns to improve patient care.
• Working with a Microsoft Gold Partner to provide SQL Server 2012 Data Warehousing and Technical capability to their clients (Argos, Leeds Metropolitan University, Vinci Construction)
• Developed a reporting environment using SQL Reporting Services, Performance Point and SharePoint to create Management Information Reports.
Technologies Used: SQL Server 2012/2008 R2, Oracle, SSRS 2012/2008 R2, SSIS 2012/2008 R2, SSAS 2012/2008 R2, SAS, MDX, SharePoint 2010, Performance Point, Panorama Necto, PowerPivot, Excel
• Used SAS to create predictive models and dashboards for GPs and Providers to monitor key metrics and spot trends and patterns to improve patient care.
• Working with a Microsoft Gold Partner to provide SQL Server 2012 Data Warehousing and Technical capability to their clients (Argos, Leeds Metropolitan University, Vinci Construction)
• Developed a reporting environment using SQL Reporting Services, Performance Point and SharePoint to create Management Information Reports.
Technologies Used: SQL Server 2012/2008 R2, Oracle, SSRS 2012/2008 R2, SSIS 2012/2008 R2, SSAS 2012/2008 R2, SAS, MDX, SharePoint 2010, Performance Point, Panorama Necto, PowerPivot, Excel
Security, Processes, MDX, Sql server 2012, Patterns, Dimensional modelling, Server, Powerpivot, SSAS, GPS, Developer, SSRS, Design, Ssis, SAS, Management, Data Warehouse, ETL, SharePoint, Oracle, SQL Server, Business Intelligence, Excel, Sql
2011 - 2012
freelance
Senior Business Intelligence Developer
CMA Group.
• Designed and developed SQL databases: designing tables; writing views, functions, triggers and stored procedures; creating SSIS packages and creating and managing jobs.
• Designed and developed Cubes for use with Reporting and Mapping Applications.
• Responsible for data analysis and cleansing of data received from NHS Trust providers, including SUS, HES, Prescribing, Radiology, Pathology and GP Emergency Admissions (A&E, OOH, Inpatient and WIC) datasets.
• Developed a reporting environment using SQL Reporting Services, Performance Point and SharePoint to create Management Information Reports.
• Worked as a consultant on a project in New Zealand for a Healthcare company documenting their current systems and providing recommendations for a new Data Warehouse, Cube and Reporting Environment.
Technologies Used: SQL Server 2008 R2, SSRS 2008 R2, SSIS 2008 R2, SSAS 2008 R2, MDX, SharePoint 2010, Performance Point, QlikView, Panorama Necto, PowerPivot, Bing Maps, Excel
• Designed and developed Cubes for use with Reporting and Mapping Applications.
• Responsible for data analysis and cleansing of data received from NHS Trust providers, including SUS, HES, Prescribing, Radiology, Pathology and GP Emergency Admissions (A&E, OOH, Inpatient and WIC) datasets.
• Developed a reporting environment using SQL Reporting Services, Performance Point and SharePoint to create Management Information Reports.
• Worked as a consultant on a project in New Zealand for a Healthcare company documenting their current systems and providing recommendations for a new Data Warehouse, Cube and Reporting Environment.
Technologies Used: SQL Server 2008 R2, SSRS 2008 R2, SSIS 2008 R2, SSAS 2008 R2, MDX, SharePoint 2010, Performance Point, QlikView, Panorama Necto, PowerPivot, Bing Maps, Excel
Stored procedures, Sql server 2008, MDX, Server, Powerpivot, SSAS, Developer, SSRS, Ssis, Sql, Management, Data Warehouse, SharePoint, SQL Server, Writing, Business Intelligence, Data Analysis, Excel
2009 - 2011
freelance
Senior SQL Developer
Commissioning Business Service.
• Designed and developed SQL databases: designing tables; writing views, functions, triggers and stored procedures; creating SSIS packages and creating and managing jobs.
• Wrote SQL scripts to migrate data from legacy databases and spreadsheets into SQL Server.
• Developed a reporting environment using SQL Reporting Services linking to SQL databases to create Management Information Reports.
• Used SAS to create predictive models to help providers understand readmission rates and created a risk stratification model to share information with GPs to improve patient care.
• Created dashboards, reports and KPI's using Performance Point. Deployed reports to Sharepoint.
• Responsible for data analysis and cleansing of data received from NHS Trust providers, including SUS, Child Health, Radiology, Community iPM/Lorenzo, 18 Weeks, Choose & Book datasets.
• Lead analyst/developer on the Advancing Quality program for the North West including AQ population data, measures data, PEMs, SINAP, MINAP and PROMS datasets.
• Designed and developed applications in ASP.NET.
Technologies Used: SQL Server 2008, SSRS 2008, SSIS 2008,SSAS /2008, SAS, SharePoint 2010, Performance Point, C#, Access, Excel, PRINCE2
• Wrote SQL scripts to migrate data from legacy databases and spreadsheets into SQL Server.
• Developed a reporting environment using SQL Reporting Services linking to SQL databases to create Management Information Reports.
• Used SAS to create predictive models to help providers understand readmission rates and created a risk stratification model to share information with GPs to improve patient care.
• Created dashboards, reports and KPI's using Performance Point. Deployed reports to Sharepoint.
• Responsible for data analysis and cleansing of data received from NHS Trust providers, including SUS, Child Health, Radiology, Community iPM/Lorenzo, 18 Weeks, Choose & Book datasets.
• Lead analyst/developer on the Advancing Quality program for the North West including AQ population data, measures data, PEMs, SINAP, MINAP and PROMS datasets.
• Designed and developed applications in ASP.NET.
Technologies Used: SQL Server 2008, SSRS 2008, SSIS 2008,SSAS /2008, SAS, SharePoint 2010, Performance Point, C#, Access, Excel, PRINCE2
Stored procedures, Sql server 2008, Server, Health, KPI, Community, SSAS, GPS, Analyst, Developer, SSRS, Net, Ssis, Sql, SAS, Management, ASP, C, SharePoint, Prince2, ASP.NET, SQL Server, Writing, .Net, Data Analysis, Excel
2008 - 2009
freelance
Senior SQL Developer
Performance Department, Hull PCT.
Hull
• Developed a reporting environment using SQL Reporting Services linking to SQL databases to create Management Information Reports.
• Designed and developed SSIS packages to import data from flat files into a SQL 2005 database; incorporating package configurations, checkpoint files, email and scheduling.
• Migrated existing databases from Access into SQL Server creating tables, stored procedures, views and triggers.
• Responsible for data analysis and cleansing of data received from NHS Trust providers in excel and txt file format, including SUS datasets.
Technologies Used: SQL Server 2000/2005, SQL Reporting Services, SQL Server Integration Services, Access, Excel
• Developed a reporting environment using SQL Reporting Services linking to SQL databases to create Management Information Reports.
• Designed and developed SSIS packages to import data from flat files into a SQL 2005 database; incorporating package configurations, checkpoint files, email and scheduling.
• Migrated existing databases from Access into SQL Server creating tables, stored procedures, views and triggers.
• Responsible for data analysis and cleansing of data received from NHS Trust providers in excel and txt file format, including SUS datasets.
Technologies Used: SQL Server 2000/2005, SQL Reporting Services, SQL Server Integration Services, Access, Excel
Sql, Excel, Data Analysis, SQL Server, Database, Management, Integration, Stored procedures, Ssis, Developer, Server
2008 - 2008
freelance
Senior SQL Developer
Nightfreight.
• Developed a reporting environment using SQL Reporting Services linking to SQL databases to create Management Information Reports.
• Designed and developed SSIS packages to import data from flat files into a SQL 2005 database; incorporating package configurations, checkpoint files, email and scheduling.
• Developed web applications in C# linking to SQL 2005 databases.
Technologies Used: SQL Server 2005, SQL Reporting Services, SQL Server Integration Services, SQL Analysis Services, VB.NET, ASP.NET, Dundas Charts, Excel
• Designed and developed SSIS packages to import data from flat files into a SQL 2005 database; incorporating package configurations, checkpoint files, email and scheduling.
• Developed web applications in C# linking to SQL 2005 databases.
Technologies Used: SQL Server 2005, SQL Reporting Services, SQL Server Integration Services, SQL Analysis Services, VB.NET, ASP.NET, Dundas Charts, Excel
Management, SQL Server 2005, Vb, Server, Web, Developer, Net, Ssis, Integration, Sql, ASP, Vb.net, Database, C, ASP.NET, SQL Server, .Net, Excel
2007 - 2008
job
Senior SQL Developer
ConvaTec, Deeside.
• Designed and developed SQL databases: designing tables; writing views, functions, triggers and stored procedures; creating SSIS packages and creating and managing jobs.
• Developed a reporting environment using SQL Reporting Services linking to SQL databases to create Management Information Reports.
• Used SQL Server Integration Services to build, extract, transform, and load packages to update data warehouses, interact with external processes, clean and mine data, process analytic objects, and perform administrative tasks.
• Extracted data from SAP to create Data Warehouses for data analysis.
• Used ProClarity to query and analyse data: creating dashboards to show trends; scorecards to monitor Key Performance Indicators and designing and creating reports.
Technologies Used: SQL Server 2005, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Access, VBA, Excel, ProClarity, Dundas Charts, SAP, Data Warehouses
• Developed a reporting environment using SQL Reporting Services linking to SQL databases to create Management Information Reports.
• Used SQL Server Integration Services to build, extract, transform, and load packages to update data warehouses, interact with external processes, clean and mine data, process analytic objects, and perform administrative tasks.
• Extracted data from SAP to create Data Warehouses for data analysis.
• Used ProClarity to query and analyse data: creating dashboards to show trends; scorecards to monitor Key Performance Indicators and designing and creating reports.
Technologies Used: SQL Server 2005, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Access, VBA, Excel, ProClarity, Dundas Charts, SAP, Data Warehouses
Sql, Excel, Data Analysis, Writing, SQL Server, SAP, VBA, Management, Integration, Stored procedures, Ssis, Developer, Server, Processes, SQL Server 2005
2001 - 2007
job
Senior Developer
IPF.
• Responsible for leading and mentoring a development team which included managing developers working off-shore in India.
• Developed application software in VB6/.NET linking to Access and SQL databases.
• Designed and developed SQL databases: designing tables; writing views, functions, triggers and stored procedures; creating DTS packages and creating and managing jobs.
• Developed and maintained applications in Access databases: designing tables, forms and reports; writing queries and writing code-behind in VBA.
• Migrated data from 3rd party databases into Access and SQL databases by writing SQL scripts and using the import functionality and DTS packages (SQL).
• Provided estimates and technical specifications for development work, covering all aspects of the development life cycle.
Technologies Used: SQL Server 2000/2005, DTS, Access, Excel, VB6, VB.NET, VBA, XML, MS Project, PRINCE2, Visual Source Safe, Crystal Reports
• Developed application software in VB6/.NET linking to Access and SQL databases.
• Designed and developed SQL databases: designing tables; writing views, functions, triggers and stored procedures; creating DTS packages and creating and managing jobs.
• Developed and maintained applications in Access databases: designing tables, forms and reports; writing queries and writing code-behind in VBA.
• Migrated data from 3rd party databases into Access and SQL databases by writing SQL scripts and using the import functionality and DTS packages (SQL).
• Provided estimates and technical specifications for development work, covering all aspects of the development life cycle.
Technologies Used: SQL Server 2000/2005, DTS, Access, Excel, VB6, VB.NET, VBA, XML, MS Project, PRINCE2, Visual Source Safe, Crystal Reports
Stored procedures, Vb, Off-shore, Server, Senior Developer, Software, Development, Developer, Safe, Net, Sql, Vb.net, VBA, Mentoring, XML, Prince2, SQL Server, Writing, .Net, Excel
1998 - 2001
job
Software Developer
BICC.
• Developed applications in Access databases: designing tables, forms and reports; writing queries and writing code-behind in VBA.
• Responsible for documenting existing software and creating help files.
• Responsible for maintaining and trouble-shooting existing software applications.
Technologies Used: Access, VBA, Excel, VB6
• Responsible for documenting existing software and creating help files.
• Responsible for maintaining and trouble-shooting existing software applications.
Technologies Used: Access, VBA, Excel, VB6
Excel, Writing, VBA, Developer, Software
My education
1995
-
1998
Chester College
BSc, Computer Science
BSc, Computer Science
Stafford College
N/a, Foundation Course
N/a, Foundation Course
Aelfgar Comprehensive School
G C S.Es, N/a
G C S.Es, N/a
Karyn's reviews
Karyn has not received any reviews on Worksome.
Contact Karyn Jackson
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Karyn directly in Worksome.
are ready to help you
and get specific bids from skilled talent in Denmark