Marc

Background

Marc’s background is in law enforcement, where he worked as an intelligence analyst for the National Crime Agency where he conducted complex and wide-ranging analysis within a tactical/operational environment. From the analysis of complex data, Marc frequently provided actionable insights in high profile investigations that lead to various arrests and convictions of Organised Crime Group (OCG) members.

Prior to his career as an intelligence analyst, Marc completed a Bachelor of Science degree in criminology and politics where he gained skills in qualitative and quantitative research methods and analysis.

During the COVID-19 pandemic, Marc has worked as a member of NHS Digital’s Shielded Patient Team (SPL). This involved running the SPL assurance documents, investigating and analysing any issues from the reporting using SQL. To improve reportability Marc has implemented variation rules in the SQL code and has been involved in rewriting elements of the SPL code to improve functionality and viewability using SQL and Power BI.

Marc also led the gap analysis on COVID-19, including the analysis of the SPL related disease codes that Oxford provided in order to identify and report on which disease codes had been missed or not collected.

Technologies

• SQL Server
• Python for data extraction and manipulation
• Databricks
• GITlab
• VS code
• Power Bi
• Excel

Methods

• Creative thinking and hypothesis generation
• Making sense of complex data (pattern analysis, geospatial, time series etc)
• Research and investigation
• Data manipulation and cleansing
• Data visualisation using Python

A fun fact about you

I enjoy Aire Soft :). But most of spending with my family; Wife, Toddler, 2 dogs and a cat.