Darren Coleman Email & Phone Number

West Midlands

Joined as Data Analyst to facilitate a return to general sector following 12 years in the pharmaceutical industry, promoted to IT Manager in 2018 and to current position in January 2020. Reporting directly to Group CEO with responsibility for reporting platforms and end to end development of key systems on Linux and Windows serversKey Achievements:• Introduction of Management Information System and processing platform using PHP/MySQL running on Linux (Ubuntu) servers• Identified growth opportunities and took relevant initiatives to implement solutions that currently account for 23% of revenue• Creation and implementation of performance metrics (KPIs) providing substantial increase in infrastructure efficiency resulting in a 14% revenue increase• Analysis and reporting on data in both MySQL and SQL Server environments• Development of APIs (both REST and SOAP) to using Python and PHP• Setup of MySQL replication server instances in a relay-slave configuration• Installation and configuration of cloud-based infrastructure on GCP• Collaboration and development lead with 3rd party developers• Managed the implementation of internal helpdesk solution• Email based visual reports using PHP, Google Charts API, Python and Selenium• Development of visual dashboards and displays using Laravel

Stockley Park, Uxbridge, Uk

Supervision of offshore services (TCS - India) in the process of creating SAS checks and listings, ensuring adherence to timelines and resolution of technical issues. Primarily home-based working remotely with colleagues worldwide. Overseeing database development for clinical studies (using Inform and Central Designer). Detailed reporting and development of visualisations using Spotfire v6.0 and SAS v9.2

Hatfield, Uk

Creation/administration/maintenance of databases for clinical studies, writing of rules and derivations in PL/SQL using ClinTrial (v4.3/v4.5) for paper based studies and Inform (v4.6/v5.0) EDC studies using Central Designer (v1.1/v1.4). Development of functions for global use. Use of I-Review for reporting and extracting data as SAS datasets. Creation of SQL scripts to facilitate transition of data from InForm into SAS datasets for CDISC compatibility. Mostly home-based, working with CROs on studies, production of database specifications and data transfer documents for third party vendors. Involvement in creating procedures and standards for offshore affiliate, quality control and support for offshore activities

Reading, Uk

Creation/administration/maintenance of databases for clinical studies, writing rules and derivations in PL/SQL using ClinTrial (v4.4/v4.5) for paper based and EDC studies. Data import/export (inc. validation documentation). Ad hoc reports, development using Oracle Forms.

Allschwill, Switzerland

Creation and administration/maintenance of databases for clinical studies (phase 1-3), including writing of rules and derivations within ClinTrial (v4.2/v4.4). Ad-hoc queries and administration tasks of Oracle databases. Responsibility of ClinTrial and SQL training for new staff including development of a formal SQL training programme for Data Managers

Switzerland

Developed an online order tracking system, set-up and administered LAMP servers based in the US for a company operating out of China. Assisted a local business start-up in a consultancy role, developed a web platform and online driven procedures.

Basel, Switzerland

Project management / lead development from concept through to completion of web-based solutions mainly for SAEFL (Swiss Agency for Environment, Forests and Landscape) including clearing house mechanisms for biodiversity (CBD - Convention on Biological Diversity), biosafety (Cartagena Protocol) and the Swiss CDS (Catalogue of Data Sources - Aarhus Convention) using mainly PHP/MySQL (also Java/Oracle and Zope).

Aesch, Switzerland

Covering management of all IT related issues. Preparation of departmental budgets. Design and implementation of company intranet solution. Control of outsourced support. Administration of NT, Unix (Solaris), Oracle and Baan4 systems. Installation and administration of MS Exchange

Wolverhampton, Uk

Took over from outsource company (EDS), developed/recruited skills needed in-house. Major overhaul of in-house MIS. Integration of Unix (Solaris) system into Windows NT based LAN. Upgraded to IT systems whilst achieving a budget saving. Project managed move to new premises combining upgrade rollout

Halesowen

Delivering lectures, seminars and training on IT based subjects (inc. database theory, programming and networking) to lecturers and full/part-time students from both self-written and nationally standard courses.

Wolverhampton, Uk

Assisting EDS staff, providing technical help and programming services in connection with the in-house Paradox based management information system

Dudley, Uk

Audit of M.o.D. contracts, development of financial and logistic systems including EDC bar code technology (to military specification) and electronic data exchange interfaces for customers and clients using Visual Basic, Sage and MS Access, performed systems analysis and implemented a LAN

Walsall, Uk

Based in the automotive industry building relations with Johnson Controls, implementing VE/VA and other processes (MRP, JIT and Kanban). Set-up of PC network with integrated CAD/CAM systems, partnered with external consultant to attain of BS EN ISO 9001 accreditation

Halesowen, Uk

Initially an Auditor but moved to IT within Management Services Dept. Programming / maintenance of IBACS audit management software. Installation of Novell based LAN. Support of in-house (3 sites) and client systems

Bsc, Computing Information Systems

Activities and Societies: Year Board, Board of Studies

Ond, Electrical And Electronic Engineering