Ian Reyes Email & Phone Number

-Developed a Proof of Concept (POC) using Docker, Apache Kafka, Kafka Connect and Debezium to perform geospatial change data capture (CDC) between PostgreSQL and Oracle Source Databases to Oracle and Elasticsearch Sinks-Oversee End-to-End Data Pipeline Development, Database Design and Administration-Build and maintained a custom PLSQL based Workflow.

-Developed PL/SQL Procedures to load various data into normalized database tables-Developed Python programs to load large flat data into Oracle RDBMS-Developed custom data pipelines in an Oracle-based Workflow Management System

-Create and manage PL/SQL stored procedures to load data of various formats to Oracle RDBMS-Peer review co-workers data loading for quality assurance and data accuracy to reflect source data structure

Toronto, Canada Area

A collaborative project with other Bioinformaticians and members of the Greenblatt Lab on the development of a Web-Centred Human Transcription Factor Database. Responsibilities:Creation and management of server-side databases using Perl and MySQL.Creation of Extract,Transform,Load (ETL) scripting programs using Perl for other publicly accessible databases..

Scarborough, Ontario

• Responsibilities:
• Created and Modified XML files for international scientific journals using Adobe Dreamweaver.
• Worked independently and collaborated with other co-workers into forming a more efficient XML processing system.
• Proof-read XML code from other co-workers, requiring extensive review and attention to detail.
• Uploaded XML files using an FTP (FileZilla) for review and publishing.
• Updated the workers handbook with methods and tips for current and future employees.

Ontario College Graduate Certificate, Bioinformatics

Honours Bachelors Of Science, Human Biology