Rory O'Shea

Experience

• 

  W. L. Gore & Associates

  Feb 2013 - Jul 2013

  Laboratory Technician
• 

  LumiraDx

  Sept 2016 - Apr 2019

  QC Technician

  • Laboratory equipment, process and software validation• LumiraDx product validation & verification• Working to GMP, GLP, GCP, GDP, COSHH and safety regulations• All work to ISO 13485 and CLSI standards• Performing data analysis and generating statistical summary reports• Laboratory process characterisation and development• Writing laboratory documentation (SOPs, work instructions, records, logs)• Operation, maintenance and calibration of laboratory instrumentation• Planning and conducting stability, interference, shipping & handling studies• Troubleshooting product and instrumentation issues Show less

• 

  CodeClan

  Apr 2019 - Nov 2019

  Trainee Software Developer

  16 week, intensive vocational course with a focus on full stack web development. Technologies utilised include:• Ruby with Sinatra and Minitest• Javascript with VUE, Node and Mocha• Java with Spring and React• SQL with PostgreSQL• HTML and CSSExperience working with Agile methodologies for software development.

• 

  The Scottish Government

  Dec 2019 - Apr 2022

  • EnterpriseDB / PostgreSQL with PL/pgSQL• Relational database design with physical and logical modeling• Establishing, modifying and maintaining data structures and associated components• Creation and optimisation of custom procedures, packages and queries to meet business requirements• Query performance analysis and tuning• Maintaining and implementing information handling procedures• Ensuring data quality and integrity• Advising and supporting software developers on use of data structures and associated components• Conducting database migration from Oracle to Postgres• Construction and automation of data warehouses• Synchronising data from national exchanges• Code reviews and testing• Data manipulation and processing for report generation• Investigation/correction of anomalous data Show less

  • Database Developer & Administrator

    Oct 2021 - Apr 2022

  • Database Developer

    Dec 2019 - Oct 2021
• 

  LRQA

  Apr 2022 - now

  • Senior Data Engineer

    Aug 2024 - now

  • Data Engineering Specialist

    Aug 2022 - Aug 2024

  • Business Data Specialist

    Apr 2022 - Aug 2022