Christopher Andrew
Let’s talk

Data & CRM Analyst BI

Making data
work for people.

I’m Christopher. I bring clarity to complex data, build useful reporting, and make everyday work easier through automation.

Explore my workDownload résumé
Open to data, BI & CRM opportunities
Christopher Andrew
Analytical by nature.Practical by choice.
Based in Taiwan韓健安
Experience where data meets business
EdTechBusiness intelligenceSalesforce & CRM

Selected work

Better data.
A tangible difference.

Real problems, practical improvements.
Selected work from Faria Education Group.

Data reconciliation

From three days
to seconds.

A recurring comparison across school platforms took days of manual work. I built a Python tool to make the differences clear, quickly.

PythonPandasData validation
Read the case study
Record reconciliationSample data
AdmissionsLearningDirectory
SchoolAdm.Lea.Dir.
Northfield420420420
Brookside312318312

Three sources.
One clearer picture.

Fictional records. A simplified example, not the original system.

Lead & Contact
Converted
Apex + Data Loader

Salesforce automation

Less repetition.
More reliable workflows.

Automating 5,000+ Lead-to-Contact conversions with custom Apex, linked to the appropriate school accounts.

Explore the workflow
Partner dataSchool recordsContact data
Connected CRM data

Data quality & integration

A stronger foundation
for business decisions.

Cleaning and matching information from 15+ external partners to support global teams and reporting.

See the approach

Market analysis & Salesforce reporting

Turning product adoption into a market opportunity map

From an unclear dashboard request to a prioritised view of approximately 17,000 candidate schools, delivered through Salesforce reports and dashboards.

Explore the analysis
~17,000Schools identified for prioritisation

What I bring

The detail matters.
So does the bigger picture.

I connect the technical work with
what a team actually needs.

Data you can trust

Clean, reconcile and connect information across systems so teams can work from a reliable foundation.

Python · SQL · Pandas · ETL

Reporting with a purpose

Connect business questions to useful reporting, with clear definitions and data that stands up to scrutiny.

Power BI · DAX · Excel · Power Query

Systems that work together

Turn repetitive CRM tasks into practical automations, with attention to permissions, data quality and the people using them.

Salesforce · Flow · Apex · SOQL
My approach

Understand the questionCheck the dataBuild & validateMake it useful

A little about me

Curious about systems.
Focused on people.

I’m a data and CRM analyst with a software development background. I enjoy understanding how things connect—and finding a simpler, more reliable way for them to work.

At Faria Education Group, I worked in a three-person Data and CRM Solutions team supporting global teams and senior management. That experience shaped how I approach data: with care for the details and a clear sense of who needs the result.

Based in Taiwan, I’m exploring opportunities in data analytics, business intelligence and CRM solutions, and I’m open to relocation.

More about my background
May 2024 — May 2026

Data Analyst

Faria Education Group

Data quality, CRM solutions & automation
Oct 2023 — Apr 2024

Services Data Analyst

Faria Education Group

Data preparation, validation & reconciliation
2016 — 2022

Software development

Professional & freelance work

Building the technical foundation
Education

Industrial Management · NTUST
Informatics · ITS

A space to build and experiment.

Small tools, practical ideas, and Chrele—my portfolio assistant.

Visit the lab

Let’s connect

Good work starts
with a conversation.

Have a data, BI or CRM role in mind?
I’d like to hear what your team is working on.

Get in touch c.andrew.jian.an@gmail.comDownload résumé