Looking for a job

Amanjot kaur

@amanjotkaur1

Data Analyst at CNIB who segments donor audiences, evaluates campaign results, and builds Salesforce and Excel dashboards.

Canada

Message

At CNIB, I use SQL to validate donor records and prepare targeted fundraising audiences based on giving history, geography, and communication preferences. I also completed an RFM donor segmentation project to support engagement planning.

I build Salesforce and Excel dashboards to report on donor activity and fundraising performance, and compare campaign test and control groups to share findings with my manager. I also train analysts on internal systems and data processes.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

CNIB

Nov 2020 - Present (6 years)

Extract and validate donor records using SQL, build Salesforce and Excel dashboards, and support campaign evaluation. Train 3-4 analysts on internal systems and data processes.

SQL Salesforce Excel Data Validation Data Reconciliation Campaign Segmentation KPI Reporting Data Quality Python Pandas

Data Analyst Intern

Ricoh Canada

Sep 2019 - Dec 2019 (3 months)

Cleaned and validated customer data in a master data management environment involving more than 5 million records. Supported data integration and reporting activities.

Data Cleaning Data Validation Master Data Management Data Integration Reporting

Assistant Professor

Chitkara University

Aug 2016 - Sep 2018 (2 years 1 month)

Taught C, C++, Python, databases, and CCNA networking labs. Mentored students on technical projects and provided feedback to improve project quality.

C C++Python Databases CCNA Teaching Mentorship

Research Assistant

Chitkara University

Aug 2013 - Jul 2016 (2 years 11 months)

Supported computer science research projects involving machine learning and data analysis, contributing to technical investigation and academic research work.

Machine Learning Data Analysis Research