SQL Customer Segmentation and Reporting at Citi Cards by JP GerardSQL Customer Segmentation and Reporting at Citi Cards by JP Gerard

SQL Customer Segmentation and Reporting at Citi Cards

JP Gerard

JP Gerard

SQL and SAS customer modeling for credit-card decisions
The problem Risk, pricing, and marketing teams needed usable customer segments, predictive decision support, and clearer portfolio reporting.
My work At Citi Cards, I developed predictive models and customer-segmentation frameworks using SAS and SQL. I also built and automated Excel-based dashboards and forecasting tools for executive reporting and portfolio management.
The result The models and reporting tools supported campaign, risk, and portfolio decisions. This is a summary of historical work; no internal data, model performance figures, or proprietary code are included.
Like this project

Posted Sep 24, 2026

Developed SAS/SQL customer models and segments, plus automated Excel reporting tools for risk, marketing, and portfolio decisions.