Experience

M3

• United Kingdom
• Internet Publishing
• 1 - 100 Employee

• Head of Data Analysis

  • Feb 2018 - Present

  Manager of Data Team. Migration of existing MS BI Stack Data Warehouse and reporting system to Snowflake and Qlik Sense SaaS. ELT/ETL from MS SQL using Qlik Data Transfer, Matillion, Snaplogic. Development and maintenance of Doctors.Net / M3 Europe's T-SQL Datawarehouse. Multidimensional OLAP database of 30 SSAS cubes, ETL combining data sources of MS SQL, Postgres, MongoDB Json and CSV files with SSIS, Self-service and Data-driven reporting with SSRS, Targit BI and Flex, using SQL and MDX. Mentoring junior members of the team in SQL and BI technologies. Providing DBA Support for live OLTP SQL Server. Show less



Doctors.net.uk

• United Kingdom
• Technology, Information and Internet
• 1 - 100 Employee

• Senior BI Developer

  • Jun 2012 - Present

  Development and maintenance of Doctors.Net / M3 Europe's T-SQL Datawarehouse of website activity of 300,000 doctors. Approx 100 million impressions per year. Multidimensional OLAP database of 30 SSAS cubes, ETL combining datasources of MS SQL,Postgres, MongoDB Json and CSV files with SSIS, Self-service and Datadriven reporting with SSRS and Flex, using SQL and MDX Development and maintenance of Doctors.Net / M3 Europe's T-SQL Datawarehouse of website activity of 300,000 doctors. Approx 100 million impressions per year. Multidimensional OLAP database of 30 SSAS cubes, ETL combining datasources of MS SQL,Postgres, MongoDB Json and CSV files with SSIS, Self-service and Datadriven reporting with SSRS and Flex, using SQL and MDX



Achilles Information Limited

• United Kingdom
• Information Services
• 100 - 200 Employee

• Senior Software Engineer

  • Jan 2008 - May 2012

  Senior Software Engineer – Procurement software. Design, implementation and support of Websites to replace legacy systems. Web Services, Winforms and WPF applications. ·1 Implementation of Supplier Questionnaire and Search web applications – ASP.NET .Net 2/3.5, C#, T-SQL, SSIS, SQL 2005/2008, DTS ·2 Configuration tools for global unified web platform – Winforms, WPF, C# ·3 Lead developer for development of integration mechanism for legacy application websites and global unified web platform with data migration - SQL 2008, C# ,ASP.NET .Net 4, SSIS ·4 Technical lead for data migration of legacy databases - SQL 2008 , SSIS, SSRS Show less



Ardentia

• SQL Server DBA / BI Developer

  • Oct 2002 - Jan 2008

  IT Manager/DBA/Developer for healthcare software company – data warehouse development and maintenance, as well as maintenance of company’s internal IT infrastructure (Backups, security, VPN, Exchange server, NHSNet connection, Demo Website); implementation, support and development. · Consultant DBA for several NHS trusts. · Implementation and Support of Applix TM1 Olap tool including TM1 Web. Deployment on web, SQL 2000, Analysis Services, Access, Excel. · Development and maintenance of data warehouse of NHS datasets using SQL Server 2000. · System to automate loading SQL warehouse and TM1 Cubes using Visual Basic 6, ASP/HTML, TM1 API, SQL 2000 DTS Components. · System to drill through to data warehouse from website using ASP/HTML, COM components, XML, SQL 2000, TM1 API, VB6. Show less



Ciber Global

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Software Developer / Consultant

  • Jan 1999 - Sep 2002

  Consultancy Company. 2/3 Tier client-server, enterprise, intranet applications. Projects undertaken on client sites and in house. ·1 Army Personnel Management System 3-tier ASP/DHTML, JavaScript, VBScript, VB6, SQL7/SQL2000, MTS, COM, COM+, IIS ·2 Contact Management System; 3-tier SQL7, MTS, COM, VB6, Outlook Forms/VBScript, CDO, MS Message Queue ·3 Volunteer Admin system 3-tier; SQL7, VB6, MTS, COM, Active X documents/controls ·4 Farmers’ Administration system 2-tier Access97, SQL6.5, 7, VB6, VBA ·5 Contact management system development 2-tier VB5, SQL 6.5 Show less



Videcom Ltd

• Henley

• Software Developer

  • Mar 1996 - Dec 1999

  Implementation of client-server solutions for the airline industry. Projects undertaken: · TCP/IP interface between Videcom proprietary LAN and an airline host mainframe (VB3, Access, Windows Sockets, Dart controls, Win API) · Development of client-server Baggage Reconciliation System involving PSC scanners, IER & UBI tag printers and R.F. Handheld computers. On site work in China, Turkey, Bahrain (VB3, VB4, Access, Win API) · TCP/IP client interface programmes for airport data servers implementing Active-X components (VB5, VB4 16 bit, Access 97, Sockets, Win 32 API) · E-Mail client & server for transferring data to airports(VB4, MAPI Messaging) Show less



Matrica

• IT Services and IT Consulting
• 1 - 100 Employee

• Software Developer

  • Oct 1994 - Mar 1996

  Small consultancy company specialising in Neural Network forecasting software. Experience gained includes: · Gas requirement forecasting program using Lotus 123 Macros · Development of Neural Network modelling application (VB3, Access, Object Pascal DLL) · Gas shipping forecasting package(VB3, Access, Pascal DLL, Excel Macros) Small consultancy company specialising in Neural Network forecasting software. Experience gained includes: · Gas requirement forecasting program using Lotus 123 Macros · Development of Neural Network modelling application (VB3, Access, Object Pascal DLL) · Gas shipping forecasting package(VB3, Access, Pascal DLL, Excel Macros)