Ricardo Ruiz.
Open to Senior Data, Financial Analytics & Automation Roles

Turning complex financial data into zero-defect automation.

I'm Ricardo Ruiz — Factor & Financial Data Analyst at LSEG (London Stock Exchange Group) with 5+ years across LSEG and Amazon. I specialize in high-speed T-SQL automation, institutional data quality, Python/BI tooling, and pragmatic AI adoption.

Heredia, Costa Rica · Remote / Hybrid EN (C2) · ES (Native) · PT (B1)
Recruiter Quick View

Where I create immediate leverage

Switch lenses below to see how my track record maps to your open role.

Financial & Index Data Specialist

Track Record

Experience

Measurable outcomes across global financial markets, enterprise hardware supply chains, and multilingual risk operations.

LSEG (London Stock Exchange Group)

Current
Factor Analyst / Financial Data Analyst · Costa Rica
Aug 2023 – Present
~75% faster SQL batches 10% → 90% AI tool adoption 1,904+ J.P. Morgan AWD securities 0% controllable defects
  • Led a department-wide automation initiative with 6 analysts across the U.S. and Costa Rica, standardizing data validation, cleansing, and processing for equity indices covering 500 to 10,000+ securities.
  • Spearheaded AI integration, lifting team adoption of AI and standardized development tools from 10% to 90% in under a month via license allocation, stakeholder alignment, and live proofs of concept.
  • Engineered parameterized T-SQL automation for validation and index review, cutting query and batch runtimes by ~75% (~40 → ~10 min) through indexing strategies, CTEs, and temp tables.
  • Completed 100% of the J.P. Morgan AWD index review (1,904+ securities) in under 2 weeks with zero controllable defects; serve as final data-quality authority and audit liaison for index releases.
  • Diagnose missing FTSE Russell factor values and validate Worldscope data using T-SQL and Hampel outlier detection; provide on-call production support and onboard new hires on T-SQL, Git, and GitHub Copilot.

Contract Data Analyst

Consulting · NDA
Self-Employed · U.S. & European Operations (Remote from Costa Rica)
Sep 2025 – Sep 2026
PLX + Apps Script reporting pipelines US & EU rack-build inventory forecasting
  • Delivered automated inventory reporting for a confidential technology client's networking rack builds across U.S. and European sites using PLX scripts, Apps Script automations, and validated Google Sheets models.
  • Forecasted material shortages from supplier lead times, recommended mitigation options, and coordinated cross-site inventory transfers and escalations.

Amazon

3 Years · Promoted
Data Risk Management Coordinator (2021–2023) & Data Investigation Specialist I (2020–2021) · Costa Rica
Aug 2020 – Aug 2023
+14% above productivity targets 0% defect rate (12 consecutive months) 3 languages investigated
  • Investigated multilingual Kindle Direct Publishing content (EN, ES, PT) for fraud, consistently outperforming productivity targets by 14%+ while maintaining a 0% defect rate over the final 12 months.
  • Maintained and refined MySQL queries and master trackers underpinning real-time data integrity and fraud analytics.
  • Built Excel VBA automation macros that improved investigation accuracy, cleaned large datasets, and codified emerging fraud patterns into team SOPs.
Engineering & Analytics Showcase

Featured Projects

Production systems, automation pipelines, machine learning benchmarks, and relational database architecture.

Flagship Full-Stack System · In Production Multi-Tenant Beta Live

Job Hunt OS — Automated Career Intelligence Platform

Engineered an end-to-end job discovery and pipeline management operating system that scans 100+ company ATS career portals directly, computes explainable CV-to-job match scores (combining rule extraction with multilingual Workers AI embeddings), tracks applications with ghost-job & company cooldown logic, and delivers 2-way Telegram alerts.

TypeScript & Hono Python Scrapers Cloudflare Workers + Durable Objects SQLite / D1 + R2 Workers AI (bge-m3) Preact PWA GitHub Actions Telegram Bot API
Architecture Highlights
  • Per-user data isolation: 1 Durable Object with private SQLite + prefixed R2 storage per tenant.
  • Privacy-first CV parsing: PDFs parsed locally on-device via pdf.js; zero sensitive contact data sent to LLMs.
  • Explainable 0–100 scoring: Skills lexicon, seniority fit, location tiering (EN/ES), and cosine similarity.
  • 390+ automated tests: Full Vitest SQLite integration suite + Python unittest classification fixtures.
Automation Pipeline · Open Source

Career-Page Monitoring Pipeline

Scheduled serverless pipeline on GitHub Actions that queries company ATS endpoints (Workday, Greenhouse, Lever, SmartRecruiters, and more) and pushes instant filtered alerts to Telegram — removing dependency on noisy job boards.

Python GitHub Actions Telegram Bot API ATS REST APIs
Data Science & ML · TEC Costa Rica

ML Classification Algorithm Benchmark

End-to-end comparative evaluation of six supervised classification algorithms following disciplined preprocessing: statistical imputation, Min–Max feature scaling, label/one-hot encoding, and rigorous model comparison on Precision, Recall, F1-score, and ROC-AUC.

Python Pandas & Polars scikit-learn ROC-AUC / F1
Database Engineering · SQL Server

CourierFlash 3NF Relational Database

Designed and implemented a fully normalized 3NF courier-management relational database from a crow's-foot ER model, complete with transactional stored procedures, custom functions, integrity validation queries, and ~300 rows of realistic test data.

T-SQL / SQL Server 3NF Modeling Stored Procedures Data Integrity
Enterprise Data Engineering · LSEG

Parameterized Index Validation Framework

Architected reusable SQL Server validation workflows for global equity index rebalances (500–10,000+ securities), combining Hampel statistical outlier detection, CTE optimization, and automated audit-trail checks — slashing batch execution from ~40 to ~10 minutes.

T-SQL Optimization Hampel Outlier Detection FTSE Russell / Worldscope Audit QA
Additional curated public repositories on GitHub
Core Stack

Skills & Languages

SQL & Data Engineering

T-SQL SQL Server MySQL GoogleSQL Stored Procedures Functions & Transactions CTEs & Indexing 3NF Modeling PLX

Python, BI & Analytics

Python Pandas & Polars Power BI & DAX Excel (VBA, Power Query) Google Sheets & Apps Script Data Quality & QA Hampel Outlier Detection ML Classification Equity Factors Java (OOP)

AI, DevOps & Cloud

Agentic-AI Workflows GitHub Copilot Git & GitLab GitHub Actions Linux / WSL2 REST APIs Cloudflare Workers / D1 Google Cloud Foundations Jira & VS Code
Spanish Native
English C2 Proficient · EF SET
Portuguese B1 · McGraw Hill
Academic Foundation

Education & Credentials

Universidad Estatal a Distancia (UNED) Expected 2027
Associate Degree (Diplomado) in Computer Science

Coursework: Databases, Data Structures, Software Engineering, Statistics, Digital Logic.

Tecnológico de Costa Rica (TEC) 2025 – 2026
Professional Development Program in Data Science & Machine Learning

Certificates earned: Machine Learning for Data Science (Nov 2025) & Mathematics for Data Science (Sep 2025).

Universidad CENFOTEC Jul 2023
Business Analytics Program

Applied statistics, Power BI, SQL querying, and executive reporting.

Google Cloud Computing Foundations Scholarship · 2026
Cloud Infrastructure & Data Engineering Track

Awarded scholarship in 2026; cloud certification currently in progress.

Let's Connect

Hiring for a data or automation team?

I'm based in Costa Rica (UTC-6, aligned with U.S. time zones) and open to remote or hybrid opportunities in Financial Data Analysis, Analytics Engineering, and Data Quality Automation.

Send Email LinkedIn ↗ Resume PDF ↗