Mandira Hawaldar

1. Data & Analytics Datasets:

1PEPCAN Dashboard (Sweet, Salty, Weekly Tables)

Tools: Azure Databricks, PySpark, SQL.

• Developed end-to-end ingestion pipelines for Nielsen datasets, implementing Bronze–Silver–Gold architecture in Databricks.
• Created weekly analytics tables (product, market, fact, and period) for FLC and Quaker product categories used for business reporting.
• These datasets are used in a one-of-a-kind 1PEPCAN dashboard for all business units: FLC, Qkr, and Beverages across Canada.

POS Data Ingestion: Walmart and LCL.

Tools: Azure Databricks, PySpark, SQL.

• Built and maintained POS data ingestion pipelines for major retail customers, including Walmart and LCL.
• Refactored pipelines to align with the PGT framework, and migrated data sources to Teradata from PSA, enabling reliable downstream analytics.

Crossmark Audit Data Processing.

Tools: Azure Databricks, PySpark, SQL.

• Implemented and automated Crossmark audit event pipelines, supporting 9 audit events in 2025.
• Refactored legacy pipelines to PGT-compliant Databricks workflows for improved reliability and maintainability.
• Currently working on the Crossmark Beverage ETL pipeline.

Employee Data ETL Automation (DDH)

Tools: Azure Data Factory, Azure Blob Storage, SQL Server.

• Built a metadata-driven ADF pipeline to ingest employee CSV datasets from Blob Storage.
• Implemented dynamic file detection, metadata extraction, data loading into SQL Server, and automated archival.

Pricing Scorecard Analytics.

Tools: Azure Databricks, PySpark, SQL.

• Built pricing scorecard datasets using Nielsen data to support pricing analytics for FLC and Quaker product lines.

Trifacta to Databricks Migration.

Tools: Azure Databricks, PySpark, SQL.

• Converted multiple Trifacta data transformation workflows into Databricks PySpark notebooks, including Brand Ladder, Pricing Scorecard, and RGM flows.
• Implemented transformation logic using Spark DataFrame operations to improve scalability and maintainability.

2. Supply Chain Datasets:

Fleet Driver Scorecard Automation.

Tools: Azure Databricks, PySpark, PowerApps, and SharePoint.

• Designed and implemented an end-to-end automation pipeline for Fleet Driver Scorecard reporting.
• Developed Databricks ETL workflows to generate weekly and historical datasets consumed by PowerBi dashboards.