Dave O.

DATA ANALYST

610 euro
Freelancer
18 ans
Nottingham, UNITED KINGDOM

Mon expérience

Voir plus

FreelanceJuly 2018 - Présent

I provide data analysis and performance management support and solutions to public and private sector organisations that require interpretation of and insight into the data they hold.

I am highly conversant in SQL, SSRS, Power BI, Excel and Sharepoint.

I have particularly strong experience of the Adult Social Care system Liquid Logic and the finance and contract management system ContrOCC, having been integral to the implementation and ongoing support of the system at Nottingham City Council. I have expert knowledge of reporting data from the data warehouse, using SQL, SSRS and Power BI, and have worked with colleagues across the organisation to develop forms and procedures to streamline operational processes and capture key data within the system.
Voir plus

Nottingham City CouncilFebruary 2019 - May 2019

Specialist consultant lending highly innovative skills to solve business reporting issues through expert business and systems knowledge, complex SQL queries, and Power BI dashboards.

Responsibilities:
•    Provide expert knowledge of the Liquid Logic (LAS) and ContrOCC systems to current and new team members
•    Build complex and highly informative performance and intelligence reports using SQL, SQL Server Reporting Studio (SSRS), and Power BI
•    Teach new members of the team how to use SQL and SSRS in relation to both LAS and ContrOCC
•    Conceptualise, design, and build a Residential Care Power BI dashboard that enables up to the minute performance intelligence to be provided to heads of service and corporate directors to aid strategic decision making
•    Gave assistance to the Adult Social Care Performance Manager to meet the expectations of senior managers within Adult Social Care strengthening the reputation of the performance team within the Adult Social Care service
•    Provide expert knowledge on the NHS Digital statistical returns, most notably SALT, SAC, and ASC-FR so that these can be delivered a significant time before the mandatory deadline with little to no change needed for the second cut (where applicable)
Voir plus

London Borough of Tower HamletsOctober 2018 - January 2019

Interim senior manager of newly created team of 9 analysts to build and develop a highly reactive performance function across three key areas of the organisation (Public Health, Adult Social Care, and Community Safety). Used knowledge and management experience to lay the groundwork for effective performance management whilst playing a key role in the beginning of the wider business intelligence strategy.

Responsibilities:
•    Developed the strategic approach for the Health, Adults & Communities (HAC) Intelligence and Performance Team following a complete restructure of the intelligence and performance function
•    Built strong lasting relationships with heads of service and corporate directors, identifying needs and agreeing expectations for delivery
•    Set the strategy for the development of the HAC Performance & Intelligence Team into a well-rounded performance function, identifying strengths and weaknesses and how these would be addressed moving forward
•    Had the challenging conversations with managers, heads of service, and corporate directors around the difficulties the team had in delivery prior to my arrival and ensured that reputation of the team was restored by delivery of accurate, timely, and useful reporting
•    Envisaged, designed, built, and ed key performance frameworks that set the standard for the team. Provided guidance as to how these reports were constructed and afforded knowledge and expertise to the team in building future reports
•    Was part of the senior management team that began to develop the business intelligence reporting strategy with the aim of providing an intelligence tool for the whole of London Borough of Tower Hamlets to use
•    Ensured that the HAC team was fit for purpose, developing permanent staff members and recruiting expert interim staff where appropriate
•    Designed, developed and built reporting dashboards on the Pentana performance system and ensured that these dashboards were kept up-to-date
Voir plus

Nottingham City CouncilMarch 2013 - July 2018

Spearheaded a multi-disciplinary team of 4 analysts to develop and implement an informative and imaginative self-service reporting framework. Recommended and developed high quality systems to manage complex data accurately, securely and to tight deadlines in a high pressurise environment.

•     Practised SQL coder with SQL Server Management Studio, delivering efficient code that simplifies even the most complicated request
•    Innovative user of SQL Server Reporting Studio, producing engaging self-service report content that drags the user in and offers a detailed understanding of complex reporting measures at the touch of a button
•     Advanced user of Power BI, making performance dashboards that optimise available space to inform users whilst incorporating simple design to deliver key messages
•    Expert knowledge of Microsoft Excel including VLOOKUP, IFERROR, SUMIFS, AVERAGEIFS, COUNTIFS as well as basic VBA coding
•    Highly competent user of Excel pivot tables, ability to integrate Excel PowerPivot and Excel PowerQuery to allow seamless data manipulation across large datasets
•    Logical thinker that grasps processes and large datasets quickly, regardless of knowledge base
•    Ability to liaise with colleagues throughout an organisation from senior director to junior level
•    Able to quickly conceptualise user needs, working collaboratively to develop a bespoke solution rather than opting for a ‘one size fits all' approach
•    Promotes a team approach to testing, working together to achieve project aims without rushing key aspects
•    Vastly experienced in working in a fast-paced moving environment, thrives on having multiple projects or tasks to undertake at the same time
•    High level of initiative, experienced in completing large projects to a high specification, on time, and with excellent user engagement and satisfaction
•    Able to work successfully across multiple agencies and departments with conflicting viewpoints and priorities to find a solution to satisfy all parties

Nottinghamshire PoliceMarch 2005 - March 2013

Mes compétences

SQL, Project Management, Microsoft SQL Server, Data analysis