Ricardo Portrait (3).png

Get in touch

<aside> <img src="/icons/mail_gray.svg" alt="/icons/mail_gray.svg" width="40px" /> [email protected]

</aside>

<aside> <img src="/icons/phone-call_gray.svg" alt="/icons/phone-call_gray.svg" width="40px" /> +1 309-750-7939

</aside>

Certifications

<aside> <img src="/icons/book-closed_lightgray.svg" alt="/icons/book-closed_lightgray.svg" width="40px" /> Microsoft Azure Fundamentals

</aside>

<aside> <img src="/icons/book-closed_gray.svg" alt="/icons/book-closed_gray.svg" width="40px" /> ETL in Python and SQL Certificate

</aside>

<aside> <img src="/icons/book-closed_orange.svg" alt="/icons/book-closed_orange.svg" width="40px" /> GitHub Professional Certificate

</aside>

<aside> <img src="/icons/book-closed_yellow.svg" alt="/icons/book-closed_yellow.svg" width="40px" /> FINRA Securities Industry Essentials (SIE)

</aside>

<aside> <img src="/icons/book-closed_brown.svg" alt="/icons/book-closed_brown.svg" width="40px" /> Series 99 Operations Professional

</aside>

<aside> <img src="/icons/book-closed_red.svg" alt="/icons/book-closed_red.svg" width="40px" /> Alteryx Designer Core

</aside>

Education

<aside> Fordham University

Master of Science in Business Analytics

GPA: 3.97/4.00

</aside>

<aside> Illinois Wesleyan University

Bachelor of Arts in Sociology, Minor in Data Science

GPA: 3.69/4.00

</aside>

About Me

I am a results-driven Data Engineer with 3+ years of experience in building scalable data pipelines, cloud architecture optimization, and real-time analytics solutions. I specialize in driving data reliability and accessibility to support business growth and decision-making.

Core Expertise:

ETL Development (Python, SQL, Airflow, DBT)
Cloud Migration (AWS Redshift, S3, EC2; Azure ADF, Synapse, Fabric; Snowflake; GCP BigQuery)
Data Modeling, Workflow Automation, Real-Time Analytics (Tableau, Power BI)

<aside> <img src="/icons/link_gray.svg" alt="/icons/link_gray.svg" width="40px" /> View My Resume

Ricardo_Lu_Resume.pdf

</aside>

Visit My LinkedIn

linkedin.com/in/ricardo-lu/

</aside>

Tools

Expertise

Services

Work Experience

<aside> <img src="notion://custom_emoji/41f6447b-8ba2-4ba3-a77f-fb4c575b4708/1e3f5002-8766-80e6-987f-007a137769cd" alt="notion://custom_emoji/41f6447b-8ba2-4ba3-a77f-fb4c575b4708/1e3f5002-8766-80e6-987f-007a137769cd" width="40px" /> Data Engineer US Tiger Securities (Mar 2021 – Apr 2024 | New York, NY)

Built and automated 50+ ETL pipelines handling over 1.3GB of daily financial transaction and client data, significantly improving data ingestion reliability and reporting efficiency using Python, SQL and Airflow.
Migrated and scaled core data operations to AWS (S3, Redshift, EC2), enhancing system stability, audit traceability, and reducing data pipeline failure rates by 40%.
Designed and productionized executive dashboards monitoring customer onboarding, transaction anomalies, and fraud risk indicators, enabling faster product and risk decision-making.
Developed custom data models and ingestion frameworks to standardize client activity datasets, reducing reconciliation turnaround times by 30% and increasing downstream data consistency. </aside>

Side Venture

<aside> <img src="notion://custom_emoji/41f6447b-8ba2-4ba3-a77f-fb4c575b4708/1e3f5002-8766-8003-b97a-007a9b6466e0" alt="notion://custom_emoji/41f6447b-8ba2-4ba3-a77f-fb4c575b4708/1e3f5002-8766-8003-b97a-007a9b6466e0" width="40px" /> Co-founder and Data Engineer Cherish and Love (Jul 2022 – Present | New York, NY )

Engineered real-time ETL pipelines integrating Shopify API sales and engagement data into Python and Tableau dashboards, enabling near real-time marketing and inventory optimization, and reducing manual reporting workload by 50%.
Designed and deployed scalable data models consolidating customer behavior, retention, and transaction datasets, improving business decision-making speed by 35% and enhancing campaign targeting precision. </aside>