Skip to content
EN | ES, Ver en español | FR, Voir en français
Résumé

Manuel Pérez Senior Data Engineer in the Greater Toronto Area

Senior Data Engineer with 17 years in data, moving banking and insurance data to the cloud and proving it arrived intact. I have led a bank’s migration of 400 ETL processes to Azure Data Factory, migrated a health insurer’s clients and members to a new core platform in two countries, and automated a regulated monthly reconciliation. Today I work on Scotiabank’s International Banking data migration to Google Cloud. Strong in SQL, PL/SQL and Python, data modeling, and the validation that lets the business sign off. I build AI agents and use AI assistants every day (GitHub Copilot, Claude, Gemini, ChatGPT) in enterprise and commercial projects, and check every result against the data.

Download résumé (PDF)

PDF in English, ready to share.

Experience

  1. International Banking Data Migration & Cloud Transformation Scotiabank

    June 2026 – present

    • Profile, map and document International Banking data assets across multiple countries for the migration from on-premises systems to Google Cloud.
    • Build the transformation and standardization logic across the landing and standardization layers that feed the new cloud platform.
    • Write complex SQL for data discovery, profiling and validation to confirm data quality and business readiness.
    • Document data lineage, mapping specifications and business rules with subject matter experts and technical teams.
    • Build AI agents and use GitHub Copilot (including its premium models) to speed up data discovery, profiling and mapping documentation, and validate every AI-generated query against the source data before it is used.

  2. Chief Technology Officer (CTO) Cool Digital Marketing

    October 2022 – present

    • Build and maintain client and company websites from a reusable multilingual template (PHP 8, MySQL) deployed from GitHub, with automated accessibility, layout and unit tests (Playwright, axe, PHPUnit) and a Content-Security-Policy.
    • Run technical SEO and consent-first analytics (GA4, Search Console), engineer HubSpot marketing automation, CRM and API integrations, and build AI agents with Claude, Gemini and ChatGPT.

  3. Data Integration Consultant FOREBRA

    2023 – 2026

    • Architected and ran the migration of about 20,000 clients and 55,000 insured members (35,000 of them dependents), with their policies, contacts and extended data, into a new health-insurance core platform, live in Costa Rica and Honduras.
    • Proved 100% data integrity through testing in several environments, cross-checks with subject matter experts and formal sign-off before each go-live.
    • Moved historical records with Oracle Data Pump, Python and PySpark mapping, staging via direct database links and cloud storage, and high-performance bulk loads using SQL*Loader across multiple cloud-hosted Oracle databases.
    • Cut PL/SQL execution time by 30% by tuning procedures and triggers in a high-concurrency environment.
    • Replaced a manual monthly billing and reconciliation process under Puerto Rico Law 95 with an automated Python and SQL pipeline: rules in SQL, steps in Python, exceptions sent to review.

  4. Senior Data Engineer & Technical Lead Banco BHD

    2018 – 2023

    • Led the data warehouse team (six people) in the Digital Transformation Unit, breaking data initiatives into epics and sprints with scrum masters and product owners.
    • Rebuilt 400 Pentaho ETL processes as ELT pipelines in Azure Data Factory, cutting load times by 50%.
    • Automated validation and profiling of each migrated load, cutting manual testing by 40%.
    • Supported the implementation of the bank’s customer Master Data Management (MDM) solution as part of the data warehouse program.
    • Moved the warehouse from on-premises Oracle to Oracle Cloud, feeding Tableau and BI Publisher reports.
    • Ran the largest volumes of my career: a warehouse of 50M+ historical records, about 1.5 million account-snapshot rows a day kept for 7 years, and 10 years of bank-wide transactions at 500,000 to 999,000+ a day.

  5. Data Engineer Banco BHD

    2013 – 2018

    • Designed star and snowflake models and nightly ETL from Oracle, SQL Server, DB2, XML and JSON sources, meeting 100% of critical processing windows.
    • Ran day-to-day loads and support for a data warehouse of 50M+ historical records.
    • Owned QA for ETL processes, with testing protocols that reduced post-release defects and supported user acceptance testing.
    • Cut messaging costs by 75% by moving customer alerts from SMS to email.

  6. Oracle Database Developer Marsh

    2009 – 2013

    • Developed and tuned PL/SQL stored procedures, functions and packages for business-critical Oracle applications.
    • Built desktop applications with Oracle Developer Suite 9i and Oracle Forms.
    • Maintained data dictionaries and technical documentation for new data models.
Let’s talk

Hiring a data engineer?

Tell me about the role or the project. I read every message and reply personally.

Send me a message Download résumé (PDF)