The Lamplit Scribe

Calgary and nearby communities

Clean up your data. Keep it consistent.

I help Calgary-area law, accounting, and consulting firms clean up client records, prepare software imports, and reconcile recurring reports. You get clean records and clear rules for keeping them consistent.

A person comparing a printed list with a spreadsheet beside a window overlooking Calgary
When this helps

Client lists contain duplicates, time entries and billing exports disagree, or someone rebuilds the same report by hand every month.

Services

Start with one workflow.

Bring a client list, an export for a software migration, or the workbook behind a monthly report. We’ll look at how your team uses it and where the records disagree.

Data Quality Assessment

C$495 introductory fixed fee

A focused review of one workflow using a redacted sample from up to two related files.

  • A summary of duplicates, missing fields, and conflicting values
  • A cleaned sample, suggested validation rules, and a prioritized list of fixes
  • A walkthrough and a quote if you want help implementing the fixes

Data Cleanup & Standards

C$1,500–3,500 planning range for one workflow

Get a cleaned file and a documented way to keep it current. I’ll confirm the scope and fixed quote after the assessment.

  • Cleaned records based on rules agreed with your team
  • A change log and a short list of records that need a decision
  • A guide to naming, required fields, and validation checks the team can reuse

Data standards

Give your team rules it can use.

I’ve developed naming and validation rules for operational data. I’ll identify which industry, customer, and software requirements apply to your workflow and turn them into field definitions, checks, and instructions for handling exceptions.

Client and contact lists
Agree on how to name client records, preserve branch and unit details, and flag possible duplicates for review. Canada Post addressing guidelines
Software migrations
Map source fields to the new system’s import template. Flag missing required values and keep a record of how old IDs map to new ones.
Time and billing reports
Use agreed client and engagement IDs to compare time and billing exports. Document which system supplies each field and who resolves discrepancies.

Fictional example

Two exports. One client list.

The contact list and billing export use different ID formats. The office manager confirms the match, and the change log shows what was merged and why.

Incoming records

Client IDProvincePostal code
C-042Albertat2x1a1
C042ABT2X 1A1
C-061AlbertaMissing

Two formats for client 042 and a missing postal code for client 061.

Cleaned client list

Client IDProvincePostal code
C-042ABT2X 1A1
C-061ABMissing

Client 061 stays on the review list until the postal code is confirmed.

Change log

Source IDChangeApproval or next step
C042Merged into C-042. Both records belonged to the same client.Approved by Jane, office manager
C-061Postal code flagged as missing.Office manager to confirm the address
Eric Bell

About

Eric Bell

My background is in data stewardship. I’ve cleaned and standardized product and model data at scale, including building naming conventions and repeatable checks for teams that maintain those records.

Data Steward Foundations from LinkedIn Learning

Currently working toward DAMA International’s Certified Data Management Professional (CDMP) certification.

Eric Bell on LinkedIn

How I handle your files

Before you send any client records, we agree on which fields are needed, how to transfer them, and when the project copies will be deleted. Alberta’s Personal Information Protection Act (PIPA) sets out responsibilities for handling personal information.

Read the privacy policy
  • I use business-grade accounts for client work and limit access to the project.
  • Files are transferred using an agreed secure method.
  • I never put client data into public AI tools.
  • I confirm deletion of the agreed project copies at closeout.

Common questions

What kinds of files can we start with?

Excel workbooks, CSV exports, and exported Google Sheets are a good starting point. Common examples include client lists, exports for a software move, and time and billing reports.

Can you help before a software change?

Yes. I can review a structured export against the destination’s import template, flag missing fields, and prepare a cleaned copy for your team or implementation partner to review.

Who is this service for?

It’s designed for professional-services firms with fewer than 200 employees in Calgary and nearby communities. It works best when there’s one workflow to improve and someone on your team can confirm the rules.

Do you make changes in our live systems?

I work from approved copies and return the cleaned files and change log for your review. Your team controls which changes are applied to its live systems.

Get in touch

Which file is slowing your team down?

Tell me what your team uses the file for and what keeps going wrong. We can use a 15-minute call to see whether an assessment makes sense. A short description is enough to start.