👤 About — ricardo.exe

Ricardo Cordero

FP&A  |  Pricing & Revenue Analytics  |  Data Infrastructure / Analytics Engineering

I build the data infrastructure behind the numbers. Ten years across consumer goods, investment operations, and wealth management — delivering ~$1.3M in measured cost savings, returning 780+ hours/year of reporting capacity to the business, and reconciling $1B+ AUM across 35 custodians. Production-grade Python/SQL engineer with deep financial-systems fluency. NYC-based.

$1.3Mmeasured savings
780+hrs/yr capacity returned
$1B+AUM onboarded
35custodians reconciled
4M+records resolved
📁 C:\Career\Experience

Professional Experience

Senior Financial Analyst — Puratos

Global bakery & ingredients manufacturer · Feb 2026 – Present

  • Engineered an automated reporting pipeline that parses disparate source data into P&L statements — eliminating 780 hours/year of manual work.
  • Own customer pricing database integrity in SAP CRM — price lists, contracts, and records — protecting margin at the source of commercial transactions.
  • Cut pricing exceptions by reconciling pricing data across sales, purchasing, and finance into a single validated source.
  • Version-control all pricing and reporting logic in Git; formalized manual workflows into data schemas with dynamic validation and real-time alerting.

Strategic Pricing Analyst — Essity

Global hygiene & health company, 150+ countries · Nov 2022 – Feb 2026

  • Delivered ~$1M in one-time savings with a custom Python entity-resolution pipeline resolving 4M+ material and customer records; master data adopted by multiple downstream teams.
  • Shipped a containerized (Docker → Podman) value-based pricing pipeline to production, directly supporting revenue-generating pricing decisions.
  • Owned end-to-end ETL/ELT, data quality (schema, freshness, lineage, alerting), and Power BI staging models for segment and product-mix profitability.
  • Ran A/B tests validating pricing strategies; maintained GitHub Actions CI/CD and trained commercial end-users.

Senior Operations Analyst — The Swarthmore Group

$1.7B SEC-registered investment adviser · Oct 2019 – Jun 2022

  • Saved $280K annually by leading the Investnet → SS&C Advent platform migration and absorbing the client services function.
  • Automated firm-wide AUM and fixed-income reporting — eliminating a full reporting role.
  • Executed institutional Treasury trading within the Bloomberg CMGR compliance framework; analyzed portfolio and market data in BSQL.

Operations Associate — Williams Jones Wealth Management

NYC-based SEC-registered RIA · Jan 2016 – Sep 2019

  • Reconciled 4,000+ accounts daily across 35 custodians — equity, fixed income, and crypto — in an SS&C Advent environment.
  • Onboarded $1B in AUM in 3 weeks — validated 500 parent / 1,500 child accounts with clean data intake at scale.
  • Built and maintained the InvestCloud client portal serving 1,000+ high-net-worth clients; led firm-wide cybersecurity awareness training.
🛠 C:\Lab\Projects

Selected Technical Projects

Job-Market Intelligence Platform

Containerized ETL pipeline (Python, FastAPI, Docker) ingesting multiple job-board APIs with dedup/upsert into SQLite, served through a read-only REST API with an analytics frontend — deployed on a Raspberry Pi k3s cluster. End-to-end data engineering, built as self-directed job-search infrastructure.

Personal Knowledge Platform ("Second Brain")

Context-aware LLM orchestration (Ollama, Weaviate/FAISS, knowledge graphs, LangChain) that routes and curates information for daily decisions — integrated with smart-home control and desktop automation.

Private Cloud / Homelab

Self-built 5-node k3s cluster running 18+ services: Nginx/Caddy reverse proxies, Pi-hole/AdGuard, Grafana/Prometheus/Uptime Kuma observability, Gitea + CI runners, NAS, VLAN-segmented network, WireGuard/Tailscale mesh VPN, and an SDR signal-monitoring pipeline.

🧰 C:\System\Skills.dll

Skills Inventory

Languages & Engineering

Python (pandas, NumPy, Dash) · SQL (Spark SQL, BSQL) · Rust · JavaScript/TypeScript · Power Query (M) · Git, GitHub Actions CI/CD

Data Engineering

ETL/ELT · dbt · Apache Airflow · Databricks (Spark SQL, Delta Lake) · Snowflake · BigQuery · entity resolution · data quality, lineage & freshness monitoring

Infrastructure & Cloud

Docker · Podman · Kubernetes (k3s) · AWS · Azure · Google Cloud · Linux · reverse proxies & TLS (Nginx, Caddy) · observability (Grafana, Prometheus)

BI & Financial Systems

Power BI (expert) · Looker · SAP CRM/CPQ · Oracle ERP · SS&C Advent · Bloomberg AIM/CMGR & Terminal · multi-custodial reconciliation

AI / LLM Infrastructure

RAG pipelines · LangChain · vector databases (Weaviate, FAISS, Pinecone) · Ollama local models · LLM orchestration & prompt routing

FP&A & Analytics

P&L construction · pricing strategy & value-based frameworks · margin analysis · forecasting & scenario planning · A/B testing · SaaS metrics (ARR, NRR, CAC, LTV)

✉ C:\Contact\Reach_Out

Get In Touch

New York, NY · Open to FP&A, pricing analytics, and analytics engineering conversations.