Seán Mcmahon Email & Phone Number

Dublin, County Dublin, Ireland

Dublin, County Dublin, Ireland

Lead of the operations subfunction of the Data Science and Engineering team (DSE) in the Cell Therapy organisation.

Dublin, County Dublin, Ireland

Pharmaceutical Client – Data Engineer• Worked as a data engineer for the cell therapy team of a multinational pharmaceutical company. • Transformed critical existing manual data transformation processes, and independently developed equivalent SQL code using DBT to automate these processes, while ensuring consistent data quality through value testing.• Experienced in working autonomously while maintaining effective collaboration with a global team through the utilization of Git for… Show more Pharmaceutical Client – Data Engineer• Worked as a data engineer for the cell therapy team of a multinational pharmaceutical company. • Transformed critical existing manual data transformation processes, and independently developed equivalent SQL code using DBT to automate these processes, while ensuring consistent data quality through value testing.• Experienced in working autonomously while maintaining effective collaboration with a global team through the utilization of Git for streamlined and efficient cooperation.Financial Services Client – Data Engineer • 1+ years of experience as a data engineer for the ETL process within a large enterprise data warehouse programme. • Engaged with source system SMEs and Business daily to better understand current system & requirements. • Used SQL (Teradata) to query and produce data source mapping to the Integrated Data Layer (IDL) and Access Layer (CAL/IAL) Show less

London, England, United Kingdom

• Created a culture of product experimentation by defining KPIs for product features and measuring the impact of new launches/feature improvements • Using SQL and Python, performed detailed analyses of product usage and user flows, identifying offline issues, file upload failures, drop offs in critical flows; proposed product improvements • Launched company-wide dashboards using Tableau to expose data and KPIs to all business departments

New York, New York

· Created comprehensive Country Risk Assessments for over 10 nations, focusing on travel and terrorism risk, political stability risk, security risk, macroeconomic risk, and cyber risk.· Created and maintained a key geopolitical events list for 2019 which tracked over 150 future events including elections, protests, state visits, and security risks· Collated and analysed all past corporate travel to Latin America in 2018-2019 to asses for potential risk.·Created weekly… Show more · Created comprehensive Country Risk Assessments for over 10 nations, focusing on travel and terrorism risk, political stability risk, security risk, macroeconomic risk, and cyber risk.· Created and maintained a key geopolitical events list for 2019 which tracked over 150 future events including elections, protests, state visits, and security risks· Collated and analysed all past corporate travel to Latin America in 2018-2019 to asses for potential risk.·Created weekly executive summaries which took complex technical information analysed by the department, and highlighted and simplified key issues to make it easily understandable at a glance to corporate management. Show less

County Dublin, Ireland

· Collated groundwater, surface water and soils data, screened against relevant Generic Assessment Criteria, and prepared draft Tables as part of an Environmental Risk Assessment (of a Contaminated Site);· Prepared drawings and figures for a range of projects including route selection projects, contaminated land, and EIAR projects;· Prepared desk-based studies for a range of projects, using various data sources including GSI, EPA, OSI and NPWS online… Show more · Collated groundwater, surface water and soils data, screened against relevant Generic Assessment Criteria, and prepared draft Tables as part of an Environmental Risk Assessment (of a Contaminated Site);· Prepared drawings and figures for a range of projects including route selection projects, contaminated land, and EIAR projects;· Prepared desk-based studies for a range of projects, using various data sources including GSI, EPA, OSI and NPWS online mapping;· Field assistant; observed and supported an experienced Ecologist as various ecological surveys were completed as part of a Route Selection Assessment along the N52· General office admin – prepared draft Scoping Letters issued as part of the EIAR process for a major residential development in Co. Louth. Show less

Master'S Degree, Statistics, First Class Honours

Minor Thesis based on assessing the factors affecting the susceptibility of dairy cows to sub-clinical vs clinical mastitis in Ireland..

Bachelor Of Science - Bsc (Hons), Environmental Biology, 2.1 Class Degree

Final year reserach was based on the phylogeny of the newly discovered Moeniiplasma found in Arbuscular Mycorrhizal Fungi