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 Management System-Developed a Python Data Ingestion tool to ETL Source data of various formats to Oracle RDBMS-Created a Team Wiki using Bookstacks to document data loading processes, integrating with Workflow Management-Maintain Data Synchronization between on-premise Oracle Database and AWS S3-Manage and mentor Junior Data Engineers on RDBMS concepts, PLSQL and Python Development

-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. Creation of a Unified Update Program for all data sources housed within the database.

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