Allan Mercader del Mar

About Allan Mercader del Mar

With over a decade of experience, I lead initiatives in large-scale data transformation, pipeline optimization, and data quality governance. My background spans high-growth fintech at PayPal to complex financial migrations at Northern Trust, where I reduced engine processing times by over 91 percent. At Datassential, I leveraged expertise in ETL and ELT orchestration to build syndicated databases and optimize data lakes, fostering actionable insights that drove consistent business growth.At PayPal, my main focus is architecting Asset-Based Finance reporting frameworks for multi-billion dollar loan externalization portfolios. I orchestrate the integration of upstream sources including critical static pool analysis, delinquency roll rates, and eligibility logic with data engineering teams. This collaboration ensures we automate and deliver high-stakes investor reports with precision and timeliness.I am a proactive adopter of agentic AI tools and prompt engineering to validate data logic and accelerate delivery. By building reusable AI workflow libraries, I have reduced team-wide resolution times by 40 percent. My core mission is to foster business growth by ensuring a seamless, accurate data flow that serves as the foundation for strategic decision-making.

Experience

1. Data Credit Platform Analyst

   PayPal

   Aug 2025 — Present · Chicago, IL, US

   At PayPal, I specialize in data platform analysis, focusing on credit performance analytics and investor reporting for large-scale loan portfolios. I own the development of reporting frameworks and data infrastructure using BigQuery and GCP to support major product transitions and high-stakes migrations. By engineering automated solutions and leveraging AI-assisted analysis, I enhance data integrity, streamline issue resolution times, and provide critical insights for cross-functional upstream and downstream partners.

Education

• DePaul University

  Certification (Non-Degree), Big Data Using Hadoop

  2017 — 2017

• Computer Systems Institute

  Certifications, Network and System Administration/Administrator

  2014 — 2014

• AMA University

  Bachelor's degree, Computer Science

  1993 — 1999

• DePaul University

  Certification (Non-degree), Data Science for Business

  2017 — 2017