Business Intelligence Analyst/Developer, Data Analysis, Reports development, visualisations and dash

* 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.

* 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 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.

* 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.

* 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 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 design, develop, test and implement projects using Visual basic and MS-Access.
* To develop and maintain databases and spreadsheets for reporting purposes.