Simon Anderson developed an Organization Data Extraction Stored Procedure for the DEFRA/epr-common-data-api repository, focusing on upserting organization data, including both registered and deleted compliance schemes. Using SQL and database development skills, Simon implemented robust data quality checks and transformations within the stored procedure to ensure accurate, up-to-date records for regulatory reporting and downstream analytics. The solution automated the upsert process, reducing manual reconciliation and minimizing data drift. By maintaining a clear change history and well-scoped extraction logic, Simon laid the groundwork for scalable data governance and easier future enhancements, demonstrating depth in stored procedures and data management practices.