Ken C. Email & Phone Number

London, United Kingdom

I am currently part of the Data and Analytics team that provide BI solutions for projects under development. My main project here has been working on delivering ETL and data modelling solutions for regulatory accounting and reporting. This involves thoroughly understand and analyse the project requirements, create estimate and detailed plan for delivery of Design and Development phases including Waterfall and Agile methodologies, consider integration with wider systems, ensure appropriate unit testing is conducted and documented, provide technical input and support when engaging with other domains and team, utmost focus on high data quality as this data is used by bank-wide analysts and timely delivery of solutions.

Milton Keynes, United Kingdom

I worked within the Legal & Regulatory Data Analytics team at Santander concentrating mainly on Financial Crime related projects that are GDPR compliant including triage data analysis for remediation work, anti-money laundering and SAR activity requiring TACT and POCA disclosure to NCA. This involves delivering business intelligence and data warehouse solutions using Kimball's dimensional approach and enterprise DWH design and implementation on SQL Server 2016 platform alongside Hadoop data lake querying.

London, United Kingdom

Undertook bespoke client projects for Argus Software who specializes in commercial real estate valuation and management. Main responsibilities include providing best data and reporting solutions to clients acquiring Argus Enterprise software on SQL Server platform (SQL Server 2014). Most reports were developed in SSRS with some basic reporting in Qlikview. Client legacy systems and diverse data sources required use of both SSIS and Talend to move data to enterprise data warehose.

Hemel Hempstead, United Kingdom

Worked here both as a permanent employee and subsequently as a consultant in developing data solutions for KPI reporting in MS Excel, SSRS, Smartfocus and Webfocus. Working on SQL Server 2005 database engine to migrate data from various sources including Foxpro, Excel, Access, CSV files into data warehouse.

Petersfield, United Kingdom

- Responsible for daily production schedule of several production lines to meet global service level targets - Design, development, construction and deployment of management, operational and adhoc reports - Identified areas of risk associated with stock procurement and production activities and through enhanced data collation and analytics. (AS400, Microsoft Access, Excel, VBA)