$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Senior BI Consultant
Osita Okoli
,
Chatham, United Kingdom
Experience
Other titles
Skills
I'm offering
I am a BI Developer who enjoys and has a passion for problem solving. In the last 11 years I've channelled this passion into Developing and Designing SQL Server Databases, SQL Stored Procedures, SSIS Packages, SSRS reports and a host of other applications but this will suffice. I've worked in Private Sector, Schools, Health Sector and housing
My Expertise are as follows
• Expert level Microsoft SQL Server, SSIS, SSRS, Access, Excel and others
• Plan, design, and implement application database code objects, such as stored procedures, views and triggers
• Design, build and maintain SQL scripts and complex queries for data extraction
• Designing and creating Extraction Transformation and Loading (ETL) packages via SSIS for data conversion/sharing between databases
• Report creation and deployment though SSRS
• Report creation and though MS Excel
• Reliably meeting demands and targets under pressure
• Rational and analytical approach to problem solving.
• Identify business requirements and communicate effective solutions.
I enjoy solving extremely complex data issues with my skill set. Let's talk about your project and see if I am a good fit!
My Expertise are as follows
• Expert level Microsoft SQL Server, SSIS, SSRS, Access, Excel and others
• Plan, design, and implement application database code objects, such as stored procedures, views and triggers
• Design, build and maintain SQL scripts and complex queries for data extraction
• Designing and creating Extraction Transformation and Loading (ETL) packages via SSIS for data conversion/sharing between databases
• Report creation and deployment though SSRS
• Report creation and though MS Excel
• Reliably meeting demands and targets under pressure
• Rational and analytical approach to problem solving.
• Identify business requirements and communicate effective solutions.
I enjoy solving extremely complex data issues with my skill set. Let's talk about your project and see if I am a good fit!
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Industries
Language
English
Fluently
Available
My experience
2020 - 2021
freelance
Information Analyst
Buckingham Healthcare NHS Trust.
• Used BI tools (Microsoft SQL Server, Stored procedures, Excel, Power BI) to generate, extract and analyse data in response to ad-hoc queries.
• Optimised and automated various reporting and extraction processes.
• Designed and created various reports for the trust
• Optimised and automated various reporting and extraction processes.
• Designed and created various reports for the trust
SQL Server, Sql, Excel, Data analysis and visualization, Business Intelligence, Reporting
2020 - 2020
freelance
Database Developer
Merthyr Valley Homes.
Investigate requirements for integration, understanding what information needs to be shared between applications
o Understand method of extracting data from CRM, Asset Management and Housing Management system
• Produce integration map showing information flow between the applications
• Design Data Warehouse Schema for Integration
• Develop Data Warehouse objects for optimised transfer and storage of data
• Develop and test integration packages using SSIS and associated tools to extract data from application sources
• Write scripts to identify data records for import into applications. Scripts for:
o CRM
o Asset Management System
o Housing Management System
o MATS (low code platform proposed)
• Implement MATS On-Premise Adaptor (MOPA) for loading data into Mats Application Cloud.
• Lead and advise on Data Warehouse best practice for continued development
o Understand method of extracting data from CRM, Asset Management and Housing Management system
• Produce integration map showing information flow between the applications
• Design Data Warehouse Schema for Integration
• Develop Data Warehouse objects for optimised transfer and storage of data
• Develop and test integration packages using SSIS and associated tools to extract data from application sources
• Write scripts to identify data records for import into applications. Scripts for:
o CRM
o Asset Management System
o Housing Management System
o MATS (low code platform proposed)
• Implement MATS On-Premise Adaptor (MOPA) for loading data into Mats Application Cloud.
• Lead and advise on Data Warehouse best practice for continued development
Design, CRM, Database, Data Warehouse, Cloud, Asset Management, Management, Integration, Test, Ssis, Developer, Development, Storage
2018 - 2020
freelance
Senior Information Analyst
NHS South Central and West CSU.
• Used BI tools to generate, extract and analyse data in response to adhoc queries.
• Automate various reporting and extraction processes.
• Provided understanding of dataset to end users
• Write various SQL scripts to feed into reports
• Design and create various reports to support CCG
• Automate various reporting and extraction processes.
• Provided understanding of dataset to end users
• Write various SQL scripts to feed into reports
• Design and create various reports to support CCG
Design, Sql, Support, Analyst, BEE, Processes
2018 - 2020
freelance
Specialist BI Consultant
Herts Valleys CCG.
(SLAM Project - adhoc basis)
• Validate SLAM data in warehouse
• Extract the data to different environment
• Write various SQL scripts to feed into reports
• Design and create various reports to support Contracts and Finance teams
• Validate SLAM data in warehouse
• Extract the data to different environment
• Write various SQL scripts to feed into reports
• Design and create various reports to support Contracts and Finance teams
Design, Sql, Contracts, Finance, Support, BEE, Contracts
2017 - 2018
freelance
Senior BI Consultant
NEL Commissioning Support Unit.
• Worked with Contract team.
• Developed and maintained SSIS packages.
• Used BI tools to generate, extract and analyse data in response to adhoc queries.
• Automated various reporting and extraction processes.
• Provided understanding of dataset to end users
• STP work involving setting up sql queries and processes to extract figures for STP dashboard
• Automated a few import processes including local referrals via SSIS and SQL
• Developed and maintained SSIS packages.
• Used BI tools to generate, extract and analyse data in response to adhoc queries.
• Automated various reporting and extraction processes.
• Provided understanding of dataset to end users
• STP work involving setting up sql queries and processes to extract figures for STP dashboard
• Automated a few import processes including local referrals via SSIS and SQL
Sql, Ssis, BEE, Processes, UP, STP
2015 - 2017
freelance
Datawarehouse Developer
Bedfordshire Clinical Commissioning Group.
• Developing Datawarehouse to house SLAM and SUS Data
• Standardising SLAM data with SQL Server for analysis purposes
• Work with Contract team
• Managing data and intelligence tools
• Developing and maintaining SSIS packages.
• Developing SSRS Reports
• Automating various reporting and extraction processes.
• Helping users to understand and appropriately use data, including understanding limitations
• Standardising SLAM data with SQL Server for analysis purposes
• Work with Contract team
• Managing data and intelligence tools
• Developing and maintaining SSIS packages.
• Developing SSRS Reports
• Automating various reporting and extraction processes.
• Helping users to understand and appropriately use data, including understanding limitations
Sql, SQL Server, Ssis, SSRS, Developer, Server, Processes
2014 - 2014
freelance
Data Management Lead
NHS Herts Valleys Clinical Commissioning Group.
• Standardising SLAM data with SQL Server for analysis purposes
• Work with Contract team
• Managing data and intelligence tools
• Developing and maintaining SSIS.
• Providing sanitised data sets to all other teams
• Helping users to understand and appropriately use data, including understanding limitations
• Leading PBR road test activity in support of the annual planning cycle
• Working with all teams to help ensure compliance with IG standards
• Use and create stored procedures, T-SQL scripts and functions.
• Use and administration of MEDE Analytics Business Intelligence tool.
• Reporting, handling and processing of SUS and SLAM datasets
• Translate functional specifications into a finished report output in SSRS or any other suitable platform.
• Work with Contract team
• Managing data and intelligence tools
• Developing and maintaining SSIS.
• Providing sanitised data sets to all other teams
• Helping users to understand and appropriately use data, including understanding limitations
• Leading PBR road test activity in support of the annual planning cycle
• Working with all teams to help ensure compliance with IG standards
• Use and create stored procedures, T-SQL scripts and functions.
• Use and administration of MEDE Analytics Business Intelligence tool.
• Reporting, handling and processing of SUS and SLAM datasets
• Translate functional specifications into a finished report output in SSRS or any other suitable platform.
Analytics, Processing, Planning, Server, Support, SSRS, Ssis, Compliance, Test, Sql, T-SQL, Management, Stored procedures, Data management, SQL Server, Business Intelligence, Administration
2014 - 2014
freelance
Senior Information Analyst
NHS Herts Valleys Clinical Commissioning Group.
• Managing data and intelligence tools
• Completing/validating all data returns
• Providing sanitised data sets to all other teams
• Helping users to understand and appropriately use data, including understanding limitations
• Leading PBR road test activity in support of the annual planning cycle
• Working with all teams to help ensure compliance with IG standards
• Development of the solutions for this service to ensure emerging and future customer (internal and external) service needs are met and leading the implementation of such solutions.
• Ensuring appropriate systems and processes are in place to enable a high quality and effective service to be provided to all internal and external customers
• Supporting the wider development of the CSU, ensuring that all data management and intelligence services are provided appropriately and effectively to deliver agreed service specifications and to respond to future customers' needs.
• Use and create stored procedures, T-SQL scripts and functions.
• Completing/validating all data returns
• Providing sanitised data sets to all other teams
• Helping users to understand and appropriately use data, including understanding limitations
• Leading PBR road test activity in support of the annual planning cycle
• Working with all teams to help ensure compliance with IG standards
• Development of the solutions for this service to ensure emerging and future customer (internal and external) service needs are met and leading the implementation of such solutions.
• Ensuring appropriate systems and processes are in place to enable a high quality and effective service to be provided to all internal and external customers
• Supporting the wider development of the CSU, ensuring that all data management and intelligence services are provided appropriately and effectively to deliver agreed service specifications and to respond to future customers' needs.
• Use and create stored procedures, T-SQL scripts and functions.
Sql, Data management, Stored procedures, Management, T-SQL, Test, Service, Compliance, Implementation, Support, Analyst, Development, Planning, Processes
2013 - 2014
freelance
Interim Data Warehouse Developer
NHS Milton Keynes CCG.
• Information Analysis and development of database solutions.
• Translate functional specifications into a finished report output in SSRS or any other suitable platform
• Analysis and development of diverse SSRS reports (charts, drill through and so on) for the General Practitioners, Validation team, Directors and Analysts to facilitate the work of the PCT. This improved the speed of existing reports.
• Create and automate SSIS packages.
• Use and create stored procedures, T-SQL scripts and functions.
• Produce adequate report documentation.
• Create MS Access and MS Excel Solutions when required
• Reporting, handling and processing of SUS SEM, SUS PbR datasets
• Translate functional specifications into a finished report output in SSRS or any other suitable platform
• Analysis and development of diverse SSRS reports (charts, drill through and so on) for the General Practitioners, Validation team, Directors and Analysts to facilitate the work of the PCT. This improved the speed of existing reports.
• Create and automate SSIS packages.
• Use and create stored procedures, T-SQL scripts and functions.
• Produce adequate report documentation.
• Create MS Access and MS Excel Solutions when required
• Reporting, handling and processing of SUS SEM, SUS PbR datasets
Sql, Excel, Database, Data Warehouse, Stored procedures, T-SQL, Ssis, Access, SSRS, Developer, Development, Processing, Interim, SEM
2010 - 2013
freelance
Interim Data warehouse Manager
NHS Bedfordshire & NHS Luton.
• Information Analysis and development of database solutions.
• Using Mede Analytics to set up various reports.
• Translate functional specifications into a finished report output in SSRS or any other suitable platform
• Analysis and development of diverse SSRS reports (charts, drill through and so on) for the General Practitioners, Validation team, Directors and Analysts to facilitate the work of the PCT. This improved the speed of existing reports.
• Produce adequate report documentation.
• To produce report user guide to ensure that users at all levels can use the report.
• Create and automate SSIS packages
• Quality assuring all SSRS reports, SSIS packages and other projects before they are deployed to users
• Build and populate the data warehouse with data from several sources including Sollis.
• Automate data warehouse processes.
• Use and create stored procedures, T-SQL scripts and functions.
• Manage own workload and respond to requests for information and ensure that requests are completed in a timely fashion.
• Analyse, investigate and resolve complex database and information related queries, issues and problems such as system errors, user requirements
• Create MS Access and MS Excel Solutions when required
• Reporting, handling and processing of SUS SEM, SUS PbR datasets
• Using Mede Analytics to set up various reports.
• Translate functional specifications into a finished report output in SSRS or any other suitable platform
• Analysis and development of diverse SSRS reports (charts, drill through and so on) for the General Practitioners, Validation team, Directors and Analysts to facilitate the work of the PCT. This improved the speed of existing reports.
• Produce adequate report documentation.
• To produce report user guide to ensure that users at all levels can use the report.
• Create and automate SSIS packages
• Quality assuring all SSRS reports, SSIS packages and other projects before they are deployed to users
• Build and populate the data warehouse with data from several sources including Sollis.
• Automate data warehouse processes.
• Use and create stored procedures, T-SQL scripts and functions.
• Manage own workload and respond to requests for information and ensure that requests are completed in a timely fashion.
• Analyse, investigate and resolve complex database and information related queries, issues and problems such as system errors, user requirements
• Create MS Access and MS Excel Solutions when required
• Reporting, handling and processing of SUS SEM, SUS PbR datasets
Access, UP, Manager, Processes, Interim, Processing, Guide, Development, SSRS, Sql, Ssis, Analytics, T-SQL, Stored procedures, SEM, Fashion, Data Warehouse, Database, Excel
2010 - 2010
freelance
Developer
FJ McManus Ltd.
(subcontractor)
• Design and create SSRS reporting portal for a new tool with a potential of it being used globally. This tool is used to view SSRS reports and has a fully functional role based access system that enables or disables features for logged in users based on their assigned role.
◦ Fully functional role based access system
◦ Solution integrated with SSRS 2008R2
◦ Dynamic menu system and other extra features
• Design and create SSRS reporting portal for a new tool with a potential of it being used globally. This tool is used to view SSRS reports and has a fully functional role based access system that enables or disables features for logged in users based on their assigned role.
◦ Fully functional role based access system
◦ Solution integrated with SSRS 2008R2
◦ Dynamic menu system and other extra features
Design, SSRS, It, Developer, Portal
2008 - 2010
freelance
Information Analyst/MSSQL & MS Access Developer
Colchester Hospital University Foundation Trust.
(Contract)
• Design and create database/Excel solutions as and when required.
• To ensure that extraction processes, database solutions and other processes are adequately documented
• Extraction and Analysis (both routine and ad hoc) of data and present this information in the most appropriate format to meet the needs of information users
• Manage own workload and respond to requests for information in a timely fashion.
• Analyse, investigate and resolve existing reporting systems
• Producing periodic weekly and monthly returns
• Create and automate daily SSIS packages to update the information team's SQL Server 2005 data warehouse.
• Design and create database/Excel solutions as and when required.
• To ensure that extraction processes, database solutions and other processes are adequately documented
• Extraction and Analysis (both routine and ad hoc) of data and present this information in the most appropriate format to meet the needs of information users
• Manage own workload and respond to requests for information in a timely fashion.
• Analyse, investigate and resolve existing reporting systems
• Producing periodic weekly and monthly returns
• Create and automate daily SSIS packages to update the information team's SQL Server 2005 data warehouse.
Design, Sql, Excel, SQL Server, MSSQL, Database, Data Warehouse, Fashion, Ssis, Access, Developer, Analyst, Server, Processes, SQL Server 2005
2007 - 2008
job
Implementation Consultant (Permanent)
Keystone Asset Management Solutions.
• Discuss and identify business requirements with stakeholders and communicate effective solutions.
• Manage and deliver multiple deadlines/timelines for key project milestones and work as part of a team to deliver those timelines
• Update clients about project status via email, telephone, face to face meetings and weekly progress status reports.
• Migrate, cleanse and analyze large amounts of data with the use of Microsoft Access, MSSQL 2005, Microsoft Excel and in-house software.
• Build SQL scripts on MSSQL 2005 to resolve client data issues.
• Delivery of customer implementations and consultancy projects.
• Make presentation to Clients on site and chairing meetings.
• Manage and coordinate clients UAT process.
• Document entire client project.
• Manage and deliver multiple deadlines/timelines for key project milestones and work as part of a team to deliver those timelines
• Update clients about project status via email, telephone, face to face meetings and weekly progress status reports.
• Migrate, cleanse and analyze large amounts of data with the use of Microsoft Access, MSSQL 2005, Microsoft Excel and in-house software.
• Build SQL scripts on MSSQL 2005 to resolve client data issues.
• Delivery of customer implementations and consultancy projects.
• Make presentation to Clients on site and chairing meetings.
• Manage and coordinate clients UAT process.
• Document entire client project.
Sql, Excel, MSSQL, Implementation, Software
Osita's reviews
Osita has not received any reviews on Worksome.
Contact Osita Okoli
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Osita directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark