Business Intelligence Consultant
Nationwide Building Society
Keywords
Skills
SQL server data migration, SQL server 2008, 2012, 2014, SSRS, SSIS, PL-SQL (Oracle SQL, MS-office, Qlikview 12, Nprinting 18, Qliksense, Power BI, data processing, Analytics, database, SQL server databases, databases, data modeling, data quality, SQL server, Qlikview, data warehouse, SQL, ETL, MS-Access, SQLServer, SQLServer 2000 and 2008 environments, cloud, source control, stored procedures, SSIS packages, SQL server management studio, pivot tables, Excel, SQL server reporting services, MS, Access, reporting tools, Explorer, data migration, MS - access, spreadsheets, audit trail, SQL queries, crystal, adhoc queries, Visual basic and MS-Access
Project history
07/2019
-
03/2020
* Working for Member data processing team within Data & Analytics.
* Liaising with stakeholders and various business users within the society to gather and
understand requirements.
* Liaising with various parts of the business and database owners to understand processes and
data flow.
* Data discovery and analysis to find right information required using front end systems and SQL
server databases.
* Data extraction from various databases and data modeling in Qliksense to transform data based
on user requirements and business rules.
* Develop visualizations on Qliksense dashboards.
* Highlight data quality issues and exceptions.
* Give insights to the business for better decision making and process improvements.
* Managing and administering Qliksense processes and applications on QMC (Qlik management
console) to make sure information is available to stakeholders on time.
* Provide support to users on using dashboards and getting useful insights and data.
* Liaising with stakeholders and various business users within the society to gather and
understand requirements.
* Liaising with various parts of the business and database owners to understand processes and
data flow.
* Data discovery and analysis to find right information required using front end systems and SQL
server databases.
* Data extraction from various databases and data modeling in Qliksense to transform data based
on user requirements and business rules.
* Develop visualizations on Qliksense dashboards.
* Highlight data quality issues and exceptions.
* Give insights to the business for better decision making and process improvements.
* Managing and administering Qliksense processes and applications on QMC (Qlik management
console) to make sure information is available to stakeholders on time.
* Provide support to users on using dashboards and getting useful insights and data.
05/2017
-
06/2019
Business Intelligence Developer
Homeserve PLC
* To design and develop financial reporting.
* To develop reports for underwriting team showing net premium and Insurance Premium tax on
policies incepted and remitted to Aviva.
* To design SSIS packages to import data (financial transactions, sales, call data, customer
service representatives, claims, complaints data) from various systems into SQL server
database for reporting into Qlikview.
* To develop and automate various financial reports within Qlikview for better decision making
and save time for finance department.
* To develop dashboards for sales, marketing, customer relations and finance teams to show sales
analysis, trends and customer retention rates. These dashboards are also used to track the
performance of customer service representatives.
* To develop claims and complaints dashboards, which are used to decide right pricing/excesses
on products and track the number and frequency of claims made within a specific period on
specific products.
* To support delivery of data warehouse platform by assisting in analyzing and testing data.
Developing Qlikview reports using data from data warehouse.
* To liaise with the business to gather and understand requirements for reports to be developed
from a new policy system, called eServe. To develop finance and underwriting reports along
with other sales dashboards from this new system. To integrate the data into both existing
reporting and data warehouse environments.
* Designed and developed reports on Qlik Nprinting 18 which are distributed in a PDF format to
various engineers in different regions to monitor their performances.
* To monitor the SQL agent and Qlikview management console daily for smooth functioning of BAU
and ensure delivery of reports to the business in a timely and accurate manner.
* To develop reports for underwriting team showing net premium and Insurance Premium tax on
policies incepted and remitted to Aviva.
* To design SSIS packages to import data (financial transactions, sales, call data, customer
service representatives, claims, complaints data) from various systems into SQL server
database for reporting into Qlikview.
* To develop and automate various financial reports within Qlikview for better decision making
and save time for finance department.
* To develop dashboards for sales, marketing, customer relations and finance teams to show sales
analysis, trends and customer retention rates. These dashboards are also used to track the
performance of customer service representatives.
* To develop claims and complaints dashboards, which are used to decide right pricing/excesses
on products and track the number and frequency of claims made within a specific period on
specific products.
* To support delivery of data warehouse platform by assisting in analyzing and testing data.
Developing Qlikview reports using data from data warehouse.
* To liaise with the business to gather and understand requirements for reports to be developed
from a new policy system, called eServe. To develop finance and underwriting reports along
with other sales dashboards from this new system. To integrate the data into both existing
reporting and data warehouse environments.
* Designed and developed reports on Qlik Nprinting 18 which are distributed in a PDF format to
various engineers in different regions to monitor their performances.
* To monitor the SQL agent and Qlikview management console daily for smooth functioning of BAU
and ensure delivery of reports to the business in a timely and accurate manner.
06/2015
-
04/2017
Business Intelligence Developer
Coventry & Warwickshire Partnership NHS Trust
* To assist in doing regular datasets and submissions and making processes efficient.
* Developing new dataset (IAPT - Improving Access to Psychological Therapies) by gathering and
following guidance from HSCIC.
* Developing a process for Child and Adolescent Mental Health Service (CAMHS) to track 18 weeks
breaches. The process helped services to avoid braches and achieve targets.
* Successfully setting up an ETL process in SQL server for the contracting team and migrating
the data and procedures from MS-Access to SQL server to speed up the process and make it
efficient. This brought down the manual validations and workings drastically leaving the staff
to do more analysis on data. The data is used for regular reporting.
* Liaising with IT and other teams to gather requirements and business rules while building up
this process.
* Supporting the migration project from ePEX to CareNotes system. Redesigning and developing
datasets and KPIs to be submitted to commissioners and developing processes for contracting
and Performance department to extract data from new system using SQL server.
* Liaising with community services and getting their accurate data and KPIs for submission to
commissioners.
* Analyzing data and suggesting ways of improvements in service to meet commissioning targets.
* Supporting the Immunization and vaccination project and extracting and analyze the data.
* Liaising with Finance team to setup activity plan for a financial year.
* Extracting, analyzing and providing data to services on adhoc basis for service improvement
and new contracts.
* Supporting and training team on SQL server.
* Developing new dataset (IAPT - Improving Access to Psychological Therapies) by gathering and
following guidance from HSCIC.
* Developing a process for Child and Adolescent Mental Health Service (CAMHS) to track 18 weeks
breaches. The process helped services to avoid braches and achieve targets.
* Successfully setting up an ETL process in SQL server for the contracting team and migrating
the data and procedures from MS-Access to SQL server to speed up the process and make it
efficient. This brought down the manual validations and workings drastically leaving the staff
to do more analysis on data. The data is used for regular reporting.
* Liaising with IT and other teams to gather requirements and business rules while building up
this process.
* Supporting the migration project from ePEX to CareNotes system. Redesigning and developing
datasets and KPIs to be submitted to commissioners and developing processes for contracting
and Performance department to extract data from new system using SQL server.
* Liaising with community services and getting their accurate data and KPIs for submission to
commissioners.
* Analyzing data and suggesting ways of improvements in service to meet commissioning targets.
* Supporting the Immunization and vaccination project and extracting and analyze the data.
* Liaising with Finance team to setup activity plan for a financial year.
* Extracting, analyzing and providing data to services on adhoc basis for service improvement
and new contracts.
* Supporting and training team on SQL server.
04/2012
-
05/2015
Business Intelligence Analyst/ Developer
National Express Ltd
* To provide skilled support for the provision of data for the Coach Commercial and Finance
department and wider business as necessary.
* successful delivery of a Qlikview 11 implementation replacing legacy reporting in 5 months;
the initiative delivered 6 figure benefits and the wider achievements were used in Qlik global
marketing
* To support delivery of a SQLServer 2012 data warehouse platform; consolidation and upgrade of
legacy SQLServer 2000 and 2008 environments, implementation of cloud based source control
platform through VS Online
* To write stored procedures, SSIS packages and schedule jobs on SQL server management studio to
automate reports.
* To ensure daily ETL process runs properly so that accurate reports go out on time.
* To check and build processes to monitor that correct data is loaded from various sources on a
regular basis.
* To develop and extract reports from SSRS. Creating drill down, drill through, sub reports in
SSRS.
* To develop reports/ dashboard on Qlikview (using QVDs, charts, pivot tables, set analysis etc)
using data from the data warehouse.
* To produce and maintain number of regular and ad hoc reports on daily basis, using SQL server,
Excel and Qlikview, to enable commercially sound business decisions to be made.
* To develop board reports and KPI reports for the stakeholders.
* To provide regular trading reports to the Commercial and Finance departments.
* To help ensure that the data used for management information, taken from the data warehouse
and other sources is appropriate and accurate.
* To do a forecast for right decision making.
* To liaise and support other departments like Finance, marketing and business development as
and when necessary by providing required data ad reports on Qlikview to make right decisions.
* To provide management information to support business projects, ensuring it is accurate and
delivered within given deadlines.
department and wider business as necessary.
* successful delivery of a Qlikview 11 implementation replacing legacy reporting in 5 months;
the initiative delivered 6 figure benefits and the wider achievements were used in Qlik global
marketing
* To support delivery of a SQLServer 2012 data warehouse platform; consolidation and upgrade of
legacy SQLServer 2000 and 2008 environments, implementation of cloud based source control
platform through VS Online
* To write stored procedures, SSIS packages and schedule jobs on SQL server management studio to
automate reports.
* To ensure daily ETL process runs properly so that accurate reports go out on time.
* To check and build processes to monitor that correct data is loaded from various sources on a
regular basis.
* To develop and extract reports from SSRS. Creating drill down, drill through, sub reports in
SSRS.
* To develop reports/ dashboard on Qlikview (using QVDs, charts, pivot tables, set analysis etc)
using data from the data warehouse.
* To produce and maintain number of regular and ad hoc reports on daily basis, using SQL server,
Excel and Qlikview, to enable commercially sound business decisions to be made.
* To develop board reports and KPI reports for the stakeholders.
* To provide regular trading reports to the Commercial and Finance departments.
* To help ensure that the data used for management information, taken from the data warehouse
and other sources is appropriate and accurate.
* To do a forecast for right decision making.
* To liaise and support other departments like Finance, marketing and business development as
and when necessary by providing required data ad reports on Qlikview to make right decisions.
* To provide management information to support business projects, ensuring it is accurate and
delivered within given deadlines.
09/2011
-
04/2012
Senior Information Analyst
Birmingham Community Healthcare NHS Trust
* To support a data warehouse project
* To extract data from data warehouse for statutory national returns based on national guidance
and as per service requirements.
* To develop a dataset for Referral to Treatment (18 weeks RTT) to be used for statutory returns
and to monitor and improve performance of the trust.
* Designing reports on SQL server reporting services (SSRS) as per business requirements.
* Gathering national guidance and requirements from various sources like department of health,
training and data quality department, information managers and services for the RTT dataset
development
* Analyzing and presenting the dataset to the team and also managers from finance, contracting
and performance departments.
* To extract data from data warehouse for statutory national returns based on national guidance
and as per service requirements.
* To develop a dataset for Referral to Treatment (18 weeks RTT) to be used for statutory returns
and to monitor and improve performance of the trust.
* Designing reports on SQL server reporting services (SSRS) as per business requirements.
* Gathering national guidance and requirements from various sources like department of health,
training and data quality department, information managers and services for the RTT dataset
development
* Analyzing and presenting the dataset to the team and also managers from finance, contracting
and performance departments.
11/2007
-
09/2011
Information and Performance analyst
Coventry & Warwickshire Partnership NHS Trust
* To collect, analyze and provide information and reports using MS- Excel, Access, SQL server
management studio and reporting tools like MARS (Multilevel Analytical and Reporting system).
* To provide solutions or output as per business requirements to various business units and
departments by effectively coordinating and liaising with them and the technical team and
implementers.
* To perform analysis and provide information to stakeholders for decision making and improve
trust performance.
* To submit monthly, quarterly and annual statutory national returns like the 18 weeks RTT, KH03
(bed occupancy and availability), inpatients and outpatients statistics to Strategic Health
Authority and department of health by nationally specified timescales.
* To check for accuracy and to analyze and monitor data quality of the information before
submission.
* To extract the Hospital Episode Statistics (HES) to be submitted to Secondary Uses Service
(SUS).
* To evaluate the Care Quality Commission (CQC) indicators and compare them against those from
the Information centre to monitor the performance of the trust, which was required for the
trust to become member of foundation trust.
* To do regular datasets like the mental health minimum dataset and also the commissioning
datasets submitted to the commissioners on monthly basis.
* To assist in the rollout of patient information system called ePEX (Electronic Patient
Explorer) throughout the trust and also support data migration from legacy systems to this new
system.
* Developing reports and datasets using data from the new system.
* Undertake ad hoc information analysis by using MS - access, SQL server management studio and
spreadsheets to extract and manipulate the information.
management studio and reporting tools like MARS (Multilevel Analytical and Reporting system).
* To provide solutions or output as per business requirements to various business units and
departments by effectively coordinating and liaising with them and the technical team and
implementers.
* To perform analysis and provide information to stakeholders for decision making and improve
trust performance.
* To submit monthly, quarterly and annual statutory national returns like the 18 weeks RTT, KH03
(bed occupancy and availability), inpatients and outpatients statistics to Strategic Health
Authority and department of health by nationally specified timescales.
* To check for accuracy and to analyze and monitor data quality of the information before
submission.
* To extract the Hospital Episode Statistics (HES) to be submitted to Secondary Uses Service
(SUS).
* To evaluate the Care Quality Commission (CQC) indicators and compare them against those from
the Information centre to monitor the performance of the trust, which was required for the
trust to become member of foundation trust.
* To do regular datasets like the mental health minimum dataset and also the commissioning
datasets submitted to the commissioners on monthly basis.
* To assist in the rollout of patient information system called ePEX (Electronic Patient
Explorer) throughout the trust and also support data migration from legacy systems to this new
system.
* Developing reports and datasets using data from the new system.
* Undertake ad hoc information analysis by using MS - access, SQL server management studio and
spreadsheets to extract and manipulate the information.
08/2007
-
10/2007
Information analyst and developer
Princess Royal Hospital NHS Trust
* To analyze data using MS - access and Excel and also submit statutory returns to department of
health.
* To analyze and reconcile the 18 weeks RTT data and do returns for the same.
* Using a patient information database called Semahelix to view patient audit trail and
inpatient - outpatient activities.
* Undertake adhoc work as and when required.
health.
* To analyze and reconcile the 18 weeks RTT data and do returns for the same.
* Using a patient information database called Semahelix to view patient audit trail and
inpatient - outpatient activities.
* Undertake adhoc work as and when required.
12/2006
-
07/2007
Information analyst
Birmingham Primary Care Shared Services Agency
* To collect, analyze and report information using MS- Excel, Access and SQL queries.
* To generate monthly and quarterly reports including the key performance indicator reports and
stakeholder reports using various databases, datasets and spreadsheets
* To run and generate financial reports like purchase ledger and sales ledger using crystal
reports and transforming them into presentable format for various PCTs.
* To use corporate business systems like integra to extract reports.
* To be responsible for the updating and maintenance of the purchasing cards system (ReportaXL)
and analyze the purchasing cards transactions.
* To maintain databases and spreadsheets to respond to adhoc queries and to ensure that that the
information provided is understood.
* To develop and provide management information/datasets for stakeholders and customers from a
range of data sources (national databases - NSTS and self-produced databases and
spreadsheets).
* To produce, analyze, present and maintain range of information across the Financial and
Contractor Services Directorate and PCTs.
* To generate monthly and quarterly reports including the key performance indicator reports and
stakeholder reports using various databases, datasets and spreadsheets
* To run and generate financial reports like purchase ledger and sales ledger using crystal
reports and transforming them into presentable format for various PCTs.
* To use corporate business systems like integra to extract reports.
* To be responsible for the updating and maintenance of the purchasing cards system (ReportaXL)
and analyze the purchasing cards transactions.
* To maintain databases and spreadsheets to respond to adhoc queries and to ensure that that the
information provided is understood.
* To develop and provide management information/datasets for stakeholders and customers from a
range of data sources (national databases - NSTS and self-produced databases and
spreadsheets).
* To produce, analyze, present and maintain range of information across the Financial and
Contractor Services Directorate and PCTs.
07/2004
-
03/2005
IT support professional
Sitel India Private Limited
* To trouble shoot and resolve technical queries of Dell computer customers throughout.
* To deliver good customer service whilst seeking and giving feedback to improve service.
* To share knowledge within the team through intranet, meetings and training.
* To deliver good customer service whilst seeking and giving feedback to improve service.
* To share knowledge within the team through intranet, meetings and training.
09/2003
-
06/2004
Developer
E-Tel Solutions Private Limited
* To design, develop, test and implement projects using Visual basic and MS-Access.
* To develop and maintain databases and spreadsheets for reporting purposes.
* To develop and maintain databases and spreadsheets for reporting purposes.
Local Availability
Open to travel worldwide
I am open to remote working roles from Europe. Thanks
