Pranesh Rajasekaran

QXO-Demand Planning (Current)

• Built and maintained data integration pipelines on the o9 Integration 3.0 platform, enabling automated ingestion and publishing of demand data.
• Developed PySpark and Spark SQL transformations and Python scripts to process large datasets sourced from Google Cloud Storage (GCS).
• Performed pipeline monitoring, debugging, and performance tuning to ensure stable and accurate data flows into the o9 Demand Planning model.

ISI-Demand and Supply Planning

• Designed and supported ETL workflows using SSIS to load and transform data for o9’s Demand and Supply Planning modules.
• Created and optimized SQL Server queries, stored procedures, and transformation logic to ensure high-quality planning data.
• Integrated upstream datasets from AWS S3, automating ingestion and improving reliability across planning cycles.

Developed interior design software utilizing flood-fill algorithm and SAM for color alteration and object segmentation.
Created an interactive GUI for placing segmented objects within targeted room layouts.