At estaie, I build Python/SQL ingestion and transformation workflows for internal and third-party APIs, integrating PostgreSQL data with CRM, GA4 and advertising sources in GCP/BigQuery. I implement incremental loads and upsert logic, validate and reconcile records, and monitor pipeline health and data freshness.
I also develop sales forecasts from historical performance, inventory growth and seasonality, and contribute to Gemini chatbot integrations through API handling, prompt refinement and response evaluation. In the SkyPoints Loyalty ETL project, I built a batch pipeline that validates and transforms member-profile files and nested JSON redemptions.
