Ian Mullan

Data Reporting Application Manager @Apples And Oranges Data Solutions

FR

Creation of user-friendly, dynamic and interactive oversight tools for clients. Having worked internationally in both the sponsor and CRO environment on phases I – in a range of therapeutic areas, I have gained experience and skills across the full range of data management orientated tasks utilising both in-house and industry standard data management systems (Clintrial, Inform & Rave). I have developed an excellence in Microsoft Excel, combining VBA with a dynamic use of Excel syntax to create user-friendly Excel reports from raw data extracts. Such reports have included CRF tracking tools, reconciliation reports (lab, IVRS, PK), macro-enabled query management systems, protocol violation detection systems, logical check testing and department standard metric reports. Below is a non-exhaustive summary of skills and experience that are now being directly and indirectly turned into new reporting creations for our clients: • DM Lead/Project Manager;• DM documentation & creation;• Inform EDC screen design;• SAE reconciliation;• Query generation & testing;• Coding (MedDRA/WHO Drug);• Lab/PK/IVRS reconciliation;• Excel VBA literacy;• GCP-ICH awareness.

University of Ulster Coleraine

Human Nutrition and Dietetics