KeyAnalytics solves some of the unique challenges faced by many organisations, when implementing Business Intelligence (BI) solutions.Delivering Self-Service Reporting/Analysis – We can help you build a reporting layer and delivery program that is sustainable and enables self-serviceReporting/Analysing Across Multiple Systems – Our expertise in data will help integrate various systems and build a centralised reporting solutionSkills Gaps – We can support your project, overcoming skills gaps or difficulties with resourcing capacityLack of BI Strategy – We can help build your BI business case by a proof of concept; help audit the current BI architecture, understand challenges, design a road-map and deliver a Target Operating Modelhttps://KeyAnalytics.co.uk

Contract role with CSH Surrey – Social Enterprise providing community care to 6 CCG’sKey Responsibilities and Accountabilities: -• Successful roll out of a new online reporting tool for CSH surrey comprised of, new data warehouse/enterprise cube and Power BI on Azure• Provided reporting to 6 CCG’s via the CSH Surrey Power BI portal as well using it internally for operational and board reporting• Lead the BI technical architecture, data analysis, design & implementation• Liaised with CCG’s/CSH Board/CSH Exec/Service managers/Clinicians to understand their reporting deliverables, building insightful dashboards for multiple business units• Multitasked in a complex environment• Coordination across geographies, leadership levels, and domains• Demonstrated the ability to form alliances, collaborate with internal and external stakeholders, and fulfil business needs.

• Develop ‘Digital & Informatics’ strategy document for Salford’s newly formed GP federation• Scoping and development of Business Intelligence solution

• Develop ‘measurements for improvement’ and dashboard for the ‘Older Peoples Care’ initiatives being delivered in line with the STP.• Developing and defining avoidable admissions using Ambulatory Care sensitive Conditions and Ambulatory Emergency Conditions for opportunities in improvement • Deep dive into 'Vaccine Preventable' admissions• Care Homes developmental work as per ‘Long-term Needs and Last Phase of Life’ Group• Cost benefit modelling with Finance for initiatives in Strategy and Transformation Team.• Design and develop data specification to capture referrals, contacts and bedded care with all intermediate care/Rapid Response Providers across North West London• Information analysis work to offer potential opportunities for improving outcomes, quality and efficiency across North West London • Requirements gathering and analysis for Rapid Response Dashboard• Patient Activation Measures (PAM) Information analysis and development• Frail Patients resource utilisation in primary and secondary care• Case Management review in Primary Care

• Data warehouse and CCG-GP Intranet Project Lead • Project management and development of a breakthrough web-based solution which allows GP's to access information about their patient’s care outside the Practice. The GP portal provides a secure mechanism through which NHS Richmond can deliver online drillable data reports to GP Practices and internally to the organisation.• Linkage of Acute, Community, Mental Health, Social & Primary Care and other datasets to show the complete patient journey• Risk Stratification Project using ACG to predict patients at risk of falling into the high cost categories.• Successful delivery of BI project using Microsoft BI stack to develop a dimensional Data warehouse, OLAP cubes and Web based reporting. • Successful delivery of Richmond CCG Intranet and GP Portal to support collaboration and communication between CCG and GP Practices• Engaging with the work stream teams to ensure that they have reflected all of the possibilities that information based technologies can offer in their plans.• To receive, analyse and interpret complex and sensitive data and present this to a variety of audiences to aid understanding of performance and quality issues• Architectural Design and Development of dimensional data warehouse using the Kimball Method. Designing the star schema. Creating the fact and dimensions table alongside the data dictionary. • Analysing, capturing and defining reporting requirements for GP’s, Clinicians and NHS Richmond management team.

• Pushed the enterprise data warehouse strategy forward, placing it as an high agenda item to HRCH management• Assisting clinical managers with information and performance issues, enabling them to make informed decisions.• Successfully presented complex information to large groups.• Developing and improving a model that fully supports the business in strategic decision making and identifying trends• Liaise with HR, Finance, IT, Service Managers, Associate Director and Commissioners, as required to meet all information and Performance requirements.• Development of monthly, quarterly and annual activity reports for Commissioners, Clinical Executives, HRCH Management Team and other External bodies, to agreed timescale.• To change and improve information delivery and strategy for growth.• To extract, analyse, interpret and report on often complex and diverse information regarding performance and quality.• Identify and highlight areas of concern or risk and, where appropriate, make recommendations with regard to performance issues.• Development of the balance scorecard for HRCH Board Meeting.• Designing and supporting the implementation of reports/data visualisations/dashboards for spend and performance data• Regular scheduled and ad hoc reviews of data to derive insight and action recommendations.• Support ad hoc small data visualisation/reporting and analysis activities on an as needed basis.

• Technical Lead for the RiO Mental & Community Health Clinical System.• Took an instrumental role in defining strategy, specification and development of the platforms.• Managed the design and specification of development databases by providing expertise on the architecture, method of implementation and other assistance at the design stage.• Defined & implemented database design standards.• Ensured specifications and relevant documentation are created for each new project and be responsible for keeping the documentation accurate and up to date for all projects.• Facilitated, managed, and maintained timely and effective communication across teams, with department heads, Senior Managers and third parties. standards of performance and optimisation and clients expectations.• Identified & managed risk areas of a project via effective escalation and resolution as early as possible. • Adhering to production processes and procedures and adopting best practice coding, testing and development methodologies and styles. Assisting with the development of improved coding and testing practices. • Performance optimisation and development of performance improvement strategy.• Design and Development of Data Extract Process to deliver each NHS trust an extract of their database using ETL tool.

• Design and development of Data warehouse• Involvement in the decision making process surrounding, DR, SANs and SQL server High Availability Solutions. (Stratus ftServer , Log shipping and Clustering)

• Maintain & Support 24 Hour production systems. (Billing, Customer care, MIS, Accounting). • Data Migration, conversion using ETL Tool• Running and writing of general house keeping tasks (Archiving, Data transfers). • Support and implementation of development/test systems. • Workings with developers to ensure good database design, correct index selection, efficient transact SQL coding and solid security set up.• Sharing skills with trainee DBA's. • Performance and tuning, monitoring servers, locking investigation, index performance, query optimisation. • Disaster recovery planning & implementation, System monitoring. • Documenting procedures and methodologies.