Summary
Overview
Work History
Education
Skills
Language Profile
Profiles
Certifications And Education
Timeline
Generic

ESTHER-ALEXANDRA NGALEBA-ZE

Toronto

Summary

I am a passionate data practitioner with over 5 years of experience in the data management field, specializing in optimizing and building scalable data systems. With a strong background in database management, data orchestration, and workflow automation, I have worked across various roles, including data developer, data analyst, and CRM database specialist. I am skilled in working with a wide range of database management systems, designing data pipelines and implementing efficient processes to collect, clean, and transform data for actionable business insights. My extensive experience across numerous facets of data management allows me to collaborate effectively with cross-functional teams and stakeholders to deliver high-quality data solutions that drive digital transformation and support business goals.

Overview

6
6
years of professional experience

Work History

Data Cleanser Specialist

IPEX
03.2023 - 11.2024
  • Company Overview: Contributed to data preparation and profiling efforts to ensure data quality for a large-scale data migration project, where cleansed and validated data were transferred to a new SAP platform.
  • Data Cleansing & Transformation: Leveraged advanced Excel functions (VLOOKUP, INDEX-MATCH, IF combined with AND/OR) to process customer and material master data, including customer contact information and product (raw, semi-processed, and finished goods) dimensions ensuring alignment with SAP standards. The cleansed data was subsequently uploaded into a staging area platform, which was later integrated into SAP.
  • Data Quality & Governance: Collaborated with the data governance team to maintain and validate a city master list (containing cities, regions, provinces, states, and countries). Ensured the data matched predefined SAP codes and was accurate, ensuring consistent data across multiple systems and preventing discrepancies in SAP migration.
  • Data Cleansing Standards & Automation: Assisted in the development of data cleansing rules to enforce consistency across datasets and improve overall SAP warehouse efficiency. This included defining standard processes for data validation, ensuring scalable, automated data processing workflows.
  • Data Analysis & Problem Resolution: Conducted data analysis to identify data quality issues, assess their scope, and develop effective solutions. Collaborated with relevant teams to implement fixes and optimize data pipelines for the SAP migration.
  • Issue Tracking & Collaboration: Used Jira to monitor data quality issues and assign tasks to relevant team members, ensuring efficient issue resolution. This improved team collaboration and ensured that the data cleansing process was synchronized with SAP project milestones and data migration schedules.
  • Contributed to data preparation and profiling efforts to ensure data quality for a large-scale data migration project, where cleansed and validated data were transferred to a new SAP platform.

SAP Data Services Developer

SAAQ
11.2021 - 08.2022
  • Company Overview: Designed and implemented scalable data pipelines and ETL workflows that support the integration and transformation of large datasets within an enterprise data ecosystem.
  • Data Extraction & Integration: Extracted data from legacy systems and integrated it into a centralized data warehouse using SAP Data Services. Configured ETL jobs to efficiently transfer data and ensure smooth migration from legacy systems to the new platform.
  • Data Pipeline Development: Developed and optimized complex data workflows, to meet business requirements, leveraging SQL and SAP Data Services Designer (GUI) along with its built-in functions. This ensured the correct sequencing of ETL (extraction, transformation, and loading) operations across multiple data sources, enabling seamless and accurate data flow.
  • Data Transformation & Validation: Designed data flows that replicated ETL processes through SQL-based transformations, validating and cleansing incoming data to meet business rules. Developed data validation checks to ensure only accurate, consistent, and relevant data was loaded into target systems.
  • Automation & Workflow Orchestration: Automated data processing tasks and orchestrated workflows to streamline recurring data operations, reducing manual interventions and improving pipeline efficiency.
  • Testing & Debugging: Used SQL and Microsoft SQL Server to rigorously test and validate the robustness of data pipeline components, ensuring the stability and reliability of the data pipeline infrastructure. Performed unit tests on individual jobs and integration tests to verify seamless interaction between modules within the data pipeline.
  • System Integration: Executed IDOCs and configured job orchestration to ensure seamless data transfer between systems, specifically integrating SAP S/4 HANA into the larger data environment, enhancing system interoperability.
  • Designed and implemented scalable data pipelines and ETL workflows that support the integration and transformation of large datasets within an enterprise data ecosystem.

Database Administrative Assistant

OMERS
10.2021 - 07.2022
  • Company Overview: Led data cleansing initiatives and designed processes to improve data quality and operational efficiency within the Microsoft Dynamics CRM system, contributing to more accurate data management and reporting.
  • Data Cleansing: Cleansed and updated over 60K CRM records, collaborating with business stakeholders to ensure the accuracy and relevance of the data.
  • Data Deduplication & Consolidation: Developed and executed processes to identify and merge duplicate and obsolete CRM records, improving the integrity and usability of the database.
  • Collaboration for CRM Reporting: Worked closely with developers to design and configure custom CRM reports that provided real-time insights into data health.
  • Data Quality Monitoring & Dashboard Development: Supported the creation and maintenance of a data quality dashboard, enabling stakeholders to track the progress of the data cleaning project and measure improvements over time.
  • Documentation & Process Improvement: Documented the data cleaning procedures and best practices, creating reusable guides to streamline future data management efforts. Developed templates and workflows for ongoing data maintenance, ensuring long-term consistency and quality.
  • Led data cleansing initiatives and designed processes to improve data quality and operational efficiency within the Microsoft Dynamics CRM system, contributing to more accurate data management and reporting.

CRM Database Specialist

Porsche Cars Canada Ltd
01.2021 - 07.2021
  • Company Overview: Led database cleansing efforts to optimize customer data management within an SAP-powered CRM platform, ensuring data quality, system efficiency, and actionable insights for marketing and sales teams.
  • Data Quality Management & Planning: Designed and implemented a comprehensive data cleaning strategy for the CRM system, identifying data issues, establishing resolution methods, and defining quality metrics. Automated the monitoring of data quality, ensuring visibility and timely reporting for stakeholders and enabling ongoing improvements.
  • Project Leadership & Resource Management: Managed a cross-functional team through all stages of the data cleaning project, utilizing project management methodologies to allocate tasks, estimate costs, and manage resources. Ensured project milestones and deadlines were met while staying within budget, optimizing both human and technical resources.
  • Data Collection & Preparation: Created documentations, to gather sales related information from dealers, and used them, in collaboration with affiliated agencies, to update the CRM virtually eliminating data issues associated with approx. 20K fields within the database which positively affected dealers' KPIs.
  • Data Integration: Updated 100K+ clients' information in SAP by integrating external data sources (e.g., Excel files, dealer inputs) to update empty fields, enhance marketing communication and sales compensation process.
  • Data Pipeline Optimization & Workflow Automation: Re-engineered notification workflows to automate and streamline the flow of customer inquiries from online platforms to Porsche Centers. Optimized processes to reduce lag time and enhance real-time data updates, improving customer engagement.
  • Advanced Analytics & Segmentation: Leveraged SAP HANA to perform client segmentation and generate actionable insights for decision-making.
  • Reporting & KPI Dashboards: Developed dashboards that showcased KPIs and work progress related to the data cleaning project. Presented reports and insights to management, sales teams, and external stakeholders, facilitating informed decision-making.
  • System Configuration & Data Enrichment: Configured CRM fields to enrich data and improve lead status tracking, enhancing sales forecasting and performance analysis.
  • Documentation & Knowledge Sharing: Created comprehensive documentation and guides in English and French, detailing CRM best practices and usage tips. Published guides through company newsletters and shared insights through presentations to sales teams, promoting better data management practices and improving overall data quality.
  • Led database cleansing efforts to optimize customer data management within an SAP-powered CRM platform, ensuring data quality, system efficiency, and actionable insights for marketing and sales teams.

Data Analyst I

GE Grid Solutions
08.2020 - 11.2020
  • Company Overview: Meticulously analysed, stored, and structured data related to installed products within Salesforce, ensuring it was organized for easy access and retrieval.
  • Data processing: Performed data analysis, data cleansing, and generated reports on large datasets.
  • Report generation: Developed reports using Salesforce and MS Excel Pivot Tables to track data updates and cleaning progress.
  • Data extraction: Developed data extraction strategies from multiple sources and tools to capture relevant data.
  • Stakeholder collaboration: Collaborated with regional IB leads to evaluate data requirements, identify gaps, and assess progress towards data-driven objectives.
  • Data update documentation: Created document showcasing procedures to follow to accurately update data.
  • Meticulously analysed, stored, and structured data related to installed products within Salesforce, ensuring it was organized for easy access and retrieval.

Data Input Associate

LinkedIn
02.2020 - 05.2020
  • Company Overview: Researched and gathered data from multiple sources to update and restructure account hierarchies in Salesforce, ensuring accurate, up-to-date, and actionable customer data for improved sales efficiency.
  • Researched and gathered data from multiple sources to update and restructure account hierarchies in Salesforce, ensuring accurate, up-to-date, and actionable customer data for improved sales efficiency.

Bilingual Data Associate

Amazon Canada
02.2019 - 01.2020
  • Company Overview: Contributed to language solutions that power voice-controlled products.
  • Contributed to language solutions that power voice-controlled products.

Education

Applied Data Engineering Diploma -

WeCloudData
10.2023

IBM AI Engineering Professional Certificate -

IBM
04.2025

Excel to MySQL: Analytic Techniques for Business Specialization -

Duke University
04.2020

Bachelor of Commerce (Honors) - Minor in Economics

McMaster University
11.2012

Skills

  • Data Management
  • Data Modeling
  • Data Analysis
  • Data Visualization
  • Data Quality Assurance
  • Data Pipelines
  • Data Conversion
  • Data Migration
  • Data Integration
  • Data engineering
  • Database Configuration
  • Database Cleaning
  • Big data
  • Cloud Computing
  • Report Development
  • Dashboard Development
  • Financial Concepts
  • Accounting Concepts
  • Agile Project Management
  • Budgetary Control
  • Resource Management
  • ETL
  • Microsoft Dynamics 365
  • AWS
  • Salesforcecom
  • SAP HANA
  • SAP S/4HANA
  • SAP Data Services
  • Docker
  • Tableau
  • Microsoft Power BI
  • Microsoft SQL Server
  • Microsoft Visual Studio Code
  • Snowflake
  • DBeaver
  • Jupyter Notebook
  • Databricks
  • Apache Spark
  • Apache Spark Streaming
  • Apache Parquet
  • Apache Hadoop
  • Apache Hive
  • Apache Airflow
  • Apache Kafka
  • Apache Superset
  • Apache Lucene
  • Apache Nifi
  • Debezium
  • Zookeeper
  • REST API
  • MySQL
  • SQL
  • NoSQL
  • Python
  • PySpark
  • HTML
  • Linux Command
  • Shell script
  • Elasticsearch
  • Kibana
  • Jira
  • Confluence
  • Microsoft Excel
  • Microsoft Access
  • Microsoft Word
  • Microsoft PowerPoint
  • Microsoft Outlook
  • Windows 11
  • Linux
  • Ubuntu
  • IOS
  • Process Improvement
  • Problem Solving
  • Organizational Skills
  • Interpersonal Communication
  • Verbal Communication
  • Written Communication

Language Profile

  • English
  • French
  • Spanish
  • Japanese

Profiles

https://www.linkedin.com/in/alexandrangalebaze, https://ngaleba.wixsite.com/my-portfolio, https://github.com/ProcessOptimizingDataAnalyst

Certifications And Education

  • Applied Data Engineering Diploma, WeCloudData, 04/01/23, 10/01/23, Programming Foundations, Cloud Computing, Docker and Kubernetes, RDBMS and Data Warehouse, Data Lake, NoSQL Database, Data Integration and Data Pipelines
  • IBM AI Engineering Professional Certificate, IBM (Via Coursera), 09/01/22, Present
  • Excel to MySQL: Analytic Techniques for Business Specialization, Duke University (Via Coursera), 05/01/19, 04/01/20, Business Metrics for Data-Driven Companies, Mastering Data Analysis in Excel, Data Visualization and Communication with Tableau, Managing Big Data with MySQL
  • Bachelor of Commerce (Honors), Minor in Economics, McMaster University, 09/01/08, 11/01/12

Timeline

Data Cleanser Specialist

IPEX
03.2023 - 11.2024

SAP Data Services Developer

SAAQ
11.2021 - 08.2022

Database Administrative Assistant

OMERS
10.2021 - 07.2022

CRM Database Specialist

Porsche Cars Canada Ltd
01.2021 - 07.2021

Data Analyst I

GE Grid Solutions
08.2020 - 11.2020

Data Input Associate

LinkedIn
02.2020 - 05.2020

Bilingual Data Associate

Amazon Canada
02.2019 - 01.2020

Applied Data Engineering Diploma -

WeCloudData

IBM AI Engineering Professional Certificate -

IBM

Excel to MySQL: Analytic Techniques for Business Specialization -

Duke University

Bachelor of Commerce (Honors) - Minor in Economics

McMaster University

Similar Profiles

CREATE PROFILE
ESTHER-ALEXANDRA NGALEBA-ZE