John Hopkins

Skills

Core Skills
- MS Excel (30+ yrs.- all aspects incl. advanced VBA/ macros, MS Query, Excel Reports, Python- Matplotlib, Plotly),
- SQL (15+ yrs.- MS-SQL Server, T-SQL queries/ stored procedures/ cursors, MS-SQL Server Management Studio, SQL Server Data Tools- SSIS/SSRS, Power BI, MS Access),
- MS Visual Studio/ .NET Development (5+ yrs.- MS Visual Studio, C#.NET (3 yr.), LINQ-to-Entities, Entity Framework, VB.NET (3 yrs.)).

Achievements
- Used .NET, T-SQL, LINQ, VBA and MS Excel in the extraction, validation, organisation and analysis of complex data sets in various business environments (health management, NHS capacity planning, health cost data reporting, development of KPIs, statistical process control, automation of semiconductor production systems),
- Defined production status and KPIs using data reports (SPC, T-SQL, .NET, VBA, MS Excel) in the introduction of the world s first integrated optical CD measurement system (scatterometry) and associated semiconductor technologies for 90 nm DRAM and NAND flash fabrication (joint projects with Siemens, AMD- Germany, Samsung- Korea, Philips- NL, Siemens, Micron, Lucent- USA, IMEC- Belgium).

About

Highly proficient and numerate BI/ DATA ANALYST with extensive experience in the building of custom data management solutions to enable analysis, planning, forecasting and operational improvement within client organisations (hospital and health management, stock market trading, national infrastructure, factory automation, process control).