Chris Sumner

I am a multi-skilled, experienced, reliable, hard-working and confident individual specialising in Data-Driven Analytical and Developer roles. Having worked within the data field for over 14 years, I am
completely comfortable in using both Excel and SQL Server Management Studio to manipulate and showcase data. I use SQL on a near-enough daily basis and am comfortable putting scripts, jobs, views and stored procedures together, as well as automating processes and undertaking the queries themselves. Within the SQL Stack, I also have experience of using both SQL Server Reporting Services, to create bespoke reports and SQL Server Integration Services to create and test packages to automate regular processes.

I am competent with the Microsoft Office suite of products, and also have strong experience in creating dashboards using software such as Power BI and Dundas, as well as some experience using GIS software such as ArcGIS. I have also obtained experience in creating new applications by using Microsoft Power
Apps, using SharePoint for document storage and data warehousing and Power Automate to automate various tasks within the app, including creating CSV files of available tables using JSON.
Within my most recent role as a Power BI Analyst, I have built relationships with a number of key colleagues and stakeholders. I have been instrumental in creating numerous dashboards for different areas of the firm, which are updated automatically and give the user the option to drill down and view figures over time. In addition to this, whilst working within the NHS I have worked with other NHS trusts to help
develop processes and iron out any issues, as well as visiting them to analyse their data processing procedures and share ideas.

Also, whilst in the BI Developer role with the NHS, I liaised successfully with the finance team with regards to developing a new ‘Cash Collection’ and ‘Credit Card Transaction’ form, based within Dundas
dashboard software, to ensure that data is easily recorded and viewed. I have been sure to keep the finance team informed along all aspects of the process and have listened intently to the feedback
received, acting on it by providing further insight or by fixing issues that have arisen within the data or the forms.

In my most recent role, I have liaised with the management team and purchasing team within the IT Department to obtain requirements to build a new Ordering System app within Microsoft Power Apps
to replace a Microsoft Access-based system. I have had good feedback when showing a demo of the app, and have used SharePoint to store documents and as a Data Warehouse to store all of the records created within the app. I have also implemented security measures within SharePoint to ensure that the correct individuals have access and also at app-level so that management are the only team allowed to approve new orders.

Considering that I have a good few years of experience as both an analyst and a developer, I find it beneficial to have both a grasp of the data itself and the work that goes on behind it. When presenting
information, I believe that it is important to gauge the requirements of the target audience and present to them the interesting and clear points of your analysis. I have also undertaken ad-hoc reporting requests, ensuring that I ask the end-user how they would like their data presented, use the most appropriate graphs and cover the key facts.
I also ensure that when I send the report/dashboard that I include a small summary as to what is included within the report and if there is anything to look out for, as although the report would cover the key facts, it’s important to be clear as to what extra information the report is presenting to the end user if it is not covered clearly initially.

I am more than comfortable working with large data sets, manipulating and benchmarking where necessary and presenting the required data in a clear and concise manner. I have undertaken processes in the past such as contract monitoring, reviewing referrals data, creating key performance indicator
dashboards, creating applications and providing datasets for research purposes along with Data Dictionaries. As mentioned previously, I ensure that the data I present is clear to non-technical
audiences and tells a clear story.

Within the previous roles I have held with other employers, I have also managed to turn around projects by simplifying processes and therefore received good feedback from clients for doing so. I pride myself on giving a good service and performing to the best of my ability, and considering the problem-solving
mind-set that I thrive on, I strive to improve and streamline processes and projects that I am involved with should the opportunities arise.

Power BI Analyst – June 2021 – February 2024
Ashfords LLP, Exeter
Responsibilities:
• Creating Dashboard Solutions using Power BI for other areas of the organisation.
• Creating a new in-house ordering system solution using PowerApps to replace a current Access version, writing to a SharePoint site which is used by the App as a Data Warehouse and to store
documents.
• Implementing CSV download capabilities using Power Automate and JSON.
• Updating user guides in a consistent manner aligned to the organisation’s requirements.
• Fixing issues with existing Dashboards within the organisation to ensure that the required data is being pulled through.
 

Business Intelligence Developer – March 2019 - May 2021
Devon Partnership NHS Trust, Exeter
Responsibilities:
• Creating dashboards for other areas of the organisation.
• Migrating SQL Databases to new servers.
• ETL Process to provide data securely for research purposes.
• Creating and updating SQL Stored Procedures and Jobs to undertake daily tasks.
• Undertaking ad-hoc tasks to provide data insight to other colleagues in the organisation.
• Creating new web forms using Dashboard software for Finance teams to record Cash Collection and Card Transaction data, writing to a SQL database.
• Undertaken audit/trace processes to determine which tables and databases are in use and whether users should have access to the tables and databases in question.

Information Assistant/Business Intelligence Developer – July 2015 – March 2019
NHS Northern, Eastern and Western Devon Clinical Commissioning Group, Exeter
Responsibilities:
• Undertake Contract Monitoring against NHS Trusts
• Checking trusts’ financial plans against actual year-to-date results.
• Create and Run SQL scripts and stored procedures.
• Use Excel and Pivot Tables to showcase and filter data.
• Automate procedures using Pivot tables linked to SQL scripts.
• Creating dashboards to show the current trends/positions in certain areas.
• Undertaking ad-hoc data requests and analysis using Excel/SQL Server to assist other colleagues.
• Liaise with colleagues and NHS Trust employees to ensure satisfactory outcomes and swift solutions to any issues.
• Spending time with NHS Trust employees to observe their working methods and provide advice and ideas where applicable.
• Looking after and creating SSRS reports to determine referrals data.
• Creating and testing SSIS packages to automate regular processes.

Data Assistant – November 2009 – July 2015
Landmark Information Group, Exeter
Responsibilities:
• Provide telephone and email support to customers.
• Looking after various mailboxes relating to the work I was undertaking.
• Adding and verifying multiple addresses for energy assessors using web-based forms to upload them to a database.
• Using GIS software to pinpoint new build locations, collating a database of local council public access websites whilst doing so to help improve productivity going forward.
• Maintaining Access databases with data for Car Parks and Cycle Paths for government purposes.
• Collating points of interests mapping orders for customers using GIS software and SQL and dispatching them accordingly.
• Undertaking technical requests for the Office of National Statistics.
• Collating clear and concise procedure notes to help train and assist other colleagues.

COURSES UNDERTAKEN

2019
Microsoft - Administering SQL Server Databases – 5-day course

2020
Praxis Project and Programme Management - Foundation