Fernando F.

About Me

Fernando is a data engineer and SQL expert with domain knowledge in finance and healthcare. He's created companies and data systems for some well-known entities such as the Olympics Committee and Queen's University. Fernando's work in the medical research field was pivotal in obtaining over $50 million in investment, and he also co-founded an innovative DaaS healthcare company that was later acquired by a multibillion-dollar conglomerate.

Database

DevOps

Amazon Web Services (AWS)

Other

Work history

Pfizer - PGS Operations Insights
Data Engineer
2022 - 2023 (1 year)
Remote
  • Developed a data warehouse and data pipelines to ingest logistic and pharmaceutical data.

  • Reduced ETL pipeline complexity by re-designing the data model and process.

  • Improved data quality by adding QA checks to the pipeline to ensure consistency and accuracy.

SQLData EngineeringPythonETLAmazon Web Services (AWS) Python 3
CONTINUUM HEALTH VENTURES
Data Advisor
2021 - 2023 (2 years)
Remote
  • Automated due diligence processes to reduce cost. Applied NLP on financial and pitch documents for context extraction.

  • Completed due diligence using data analytics tools on benchmarking against the universe of potential investments.

  • Integrated multiple data feeds into our data lake to potential benchmark investments.

Data Analytics Big DataData Lakes Amazon Web Services (AWS)
Goodwater Capital
Senior Data Architect
2021 - 2022 (1 year)
Remote
  • Migrated environment to Google Cloud Platform (GCP) while managing two data engineers and one data scientist.

  • Moved over 20 TB of data to BigQuery. Set up ETL pipeline using Airflow. Tuned queries and designed BI architect system.

  • Managed a team of three data professionals. Migrated the entire environment to the cloud.

Google Cloud Platform (GCP) BigQuery Apache Airflow Big DataSQLETLPython 3
NobleProg
Corporate Training Director
2017 - 2020 (3 years)
Remote
  • Trained the Royal Canadian Navy on how to do data analytics on AWS.

  • Coached a team of DBA and database developers working for the federal government of Mexico in PostgreSQL administration.

  • Instructed a team at Logitech Asia headquarters in testing and tinning PostgreSQL queries.

  • Developed the curriculum and syllabus for the following technical areas: PostgreSQL, database development and administration, AWS cloud computing, GCP cloud computing, and MariaDB administration.

  • Trained multiple clients in data visualization using PowerBI.

Amazon Web Services (AWS) PostgreSQLOracleMongoDBMySQLPHPSQL
Immutable Data, Inc.
Technical Director
2017 - 2020 (3 years)
Remote
  • Developed data warehouses for various clients, including ETL jobs, data lakes, and data pipelines. I designed and administered MySQL clusters as well as PostgreSQL instances.

  • Built a custom sports analytics platform for the US Olympic Committee using MySQL, PostgreSQL, Snowflake, and Python. Using DMS, I created an ETL pipeline and used Snowpipe to move raw data dumps into a virtualized Snowflake data lake.

  • Set up a data warehouse for a professional social media platform. I designed a pipeline that ingested data from MySQL and PostgreSQL and combined them into a data warehouse I created.

  • Performed DBA tasks on MySQL and PostgreSQL instances to ensure reliability and availability. It included troubleshooting slow queries, configuring buffers, provisioning hardware, and networking equipment.

  • Created ETL jobs using ETL works platform etlworks.com. We performed multiple transformations from raw dumps, PostgreSQL dumps, to Redshift.

  • Hired a team of seasoned data scientists to support client operations.

  • Developed multiple dashboards for multiple clients using PowerBI, Metabase, Tableau, and Looker.

Amazon Web Services (AWS) SnowflakeRelational Database Services (RDS) PostgreSQLMySQLRedshiftPythonSQLMetabaseData VisualizationBig DataGoogle Cloud Platform (GCP) Google BigQuery BigQuery ETL
Q2 Metrics
Co-founder
2013 - 2017 (4 years)
Remote
  • Created a physician influence tracking tool using over 1.2 billion records from both government and private companies. The transnational nature of the application was powered by a cluster of five MySQL servers.

  • Optimized MySQL cluster to ingest over 1 billion records and perform sub-1-second queries with over 1000 concurrent connections.

  • Managed a high-performing team of full-stack developers.

  • Negotiated the sale of the company to a multibillion-dollar conglomerate.

PostgreSQLOracleMongoDBMySQLPHPSQLETLAmazon Web Services (AWS)
Queen's University
Clinical Applications Developer
2008 - 2013 (5 years)
Remote
  • Built the first online patient randomization system. It was a revolutionary way to enroll patients into blind randomized control trials. The system was powered by our on-premise My-SQL database cluster of three nodes.

  • Developed an open source longitudinal in-patient electronic data capture system in conjunction with Vanderbilt University.

  • Constructed a custom electronic data collection system for the largest nutritional-based randomized in-patient clinical trial study.

  • Performed SysAdmin tasks on a cluster of Unix servers where MySQL was installed and running. It included patching, troubleshooting slow queries, and ensuring uptime.

Canadian Cancer Institute of Canada
Oracle Developer
2007 - 2008 (1 year)
Remote
  • Developed Oracle Forms to collect and analyze clinical trial data.

  • Implemented a proprietary EDC system called Medidata Rave.

  • Migrated the past clinical trial data from a legacy system into a new system.

Hendrick Autoguard
MongoDB Architect
Present (2025 years)
Remote
  • Advised a team of engineers on designing and implementing a data lake for centralized data repositories.

  • Created a NoSQL data model to integrate multiple data sources.

  • Provided advice around best practices when dealing with data.

MongoDBPyMongo SQL
Androdon Capital, Inc.
Senior Data Engineer
Present (2025 years)
Remote
  • Collected 20 years of currency trading data and inserted it into a PostgreSQL database.

  • Created a custom Python ETL to aggregate financial data into currency data.

  • Developed a high-frequency trading algorithm using C#.

Showcase

Physician Influence Tool
  • Tracks physician performance across various metrics: procedures, billables, articles, patients, and social media.

  • Focuses on identifying influential physicians to facilitate product pitching.

  • The tool aims to measure and visualize physician influence within a specific field.

Data Warehouse and Pipeline for the US Olympic Committee
  • Developed an internal tool to collect and analyze athlete performance data.

  • Created a data warehouse using Redshift and Airflow.

  • Integrated wearable/sensor data, questionnaire data, and medical records into a unified data warehouse.

High-frequency Trading Algorithm
  • Developed a high-frequency trading algorithm for a boutique financial firm in Toronto.

  • The algorithm analyzes current pricing and trends of currency pairs.

  • The algorithm executes trades based on a predictive model.

Central Randomization System
  • The Central Randomization System addresses challenges in randomized control trials involving multiple centers and geographical areas.

  • It utilizes a central randomization system to ensure a balanced set of arms, regardless of the number of centers.

  • The system offers different access levels for patient unblinding, maintaining study blinding while providing flexibility.

Google Cloud Badges
  • BigQuery Basics for Data Analysts

  • Baseline: Infrastructure

  • Google Cloud Essentials

Education

Education
Postgraduate Certificate in Digital Marketing
Power Business School
2021 - 2022 (1 year)
Education
Advanced Diploma (Graduated with Distinction) in Computer Programmer Analyst
St. Lawrence College
2006 - 2008 (2 years)
Education
Bachelor of Science Degree in Computer Engineering
URBE University
2002 - 2006 (4 years)
Education
Continuing Education Diploma in Big Data Analytics
Caltech via Coursera
Education
Continuing Education Diploma in Big Data Analytics
MIT xPRO
Education
Master of Business Administration (MBA) Degree in Business
PowerMBA