Esther-Alexandra Ngaleba-Ze

Responsible for club financial policies, procedures, and controls as a volunteer treasurer. Supports governance of club finances through documentation and oversight of financial processes.

Contributed to data preparation and profiling to ensure data quality for a large-scale SAP migration by cleansing, transforming, and validating SAP master data. Used Syniti ADM, Excel, and Jira to support governance and automated cleansing rule development.

Designed and deployed end-to-end data pipelines to scrape and transform luxury watchlistings from multiple marketplaces. Orchestrated workflows with Apache Airflow (Docker) on AWS and stored cleaned data in S3 and PostgreSQL.

Designed and implemented scalable ETL workflows and data pipelines using SAP Data Services to integrate, transform, and validate large enterprise datasets. Automated recurring data processing tasks and supported testing, debugging, and SAP system integration using IDocs.

Led data cleansing initiatives within a Microsoft Dynamics CRM environment to improve data quality and operational efficiency. Updated and deduplicated CRM records, supported reporting, and helped maintain data quality dashboards.

Led database cleansing to improve customer data management within an SAP-powered CRM platform. Managed project delivery and used data integration and SAP HANA to support segmentation, KPI dashboards, and enrichment for sales and marketing stakeholders.

Analyzed, stored, and structured Salesforce data related to installed products to support data access and organizational decision-making. Performed data processing and cleansing and generated reports using Salesforce and Microsoft Excel pivot tables.

Researched and gathered data to update and restructure account hierarchies in Salesforce. Ensured customer data was accurate and up to date to improve sales efficiency.

Contributed to language solutions that power voice-controlled products. Worked on bilingual language-related tasks in support of voice-controlled experiences.

Activities and societies: Predictive credit risk model (linear regression/score-based classification; ROC/AUC, RMSE, confusion matrix). Capstone: long-term to short-term rental conversion analysis using SQL data extraction/integration, Excel financial models, Solver, and Tableau dashboards.

Completed the Excel to MySQL: Analytic Techniques for Business specialization, including coursework in data-driven business metrics, Excel analytics, Tableau visualization, and big data with MySQL. Completed a predictive credit risk project using Excel and statistical modeling, and a prescriptive analysis capstone using SQL and Excel financial modeling with Tableau visualization.

Earned a Bachelor of Commerce (Honors) with a minor in Economics from McMaster University.

Activities and societies: Midterm: Snowflake/S3 ingestion + PySpark/EMR transform and Power BI visualization with Lambda/Airflow. Final: real-time GPS streaming using NiFi, Debezium, Kafka (MSK), Spark Streaming, Docker, MySQL; visualized with Superset.

Completed an Applied Data Engineering diploma covering cloud computing, Docker/Kubernetes, RDBMS and data warehousing, data lakes, NoSQL, and data integration/pipelines. Completed projects using Snowflake, S3, PySpark, EMR, and Airflow, as well as an IoT GPS streaming application built with Kafka, Spark Streaming, and Apache NiFi.