Lucy Kilonzo
I transform disorganized data and messy cloud drives
New to Contra
Lucy is ready for their next project!
Bulk Data Cleansing
Title: Multi-Source CRM Contact Database Standardization
Project Description:
Scrubbing and consolidating messy consumer data lists compiled across multiple event sign-up forms and legacy sheets into a single, clean master file ready for database migration.
What I Did:
Executed deep deduplication across 15,000 rows of raw customer contact text records.
Normalized phone numbers into standard international formats and fixed mismatched date structures.
Cleaned up text columns by fixing typos, capitalizing names, and separating merged text fields.
The Result: Delivered a 100% error-free, tabular dataset ready for smooth CRM integration without any broken entries.
0
7
Knowledge Management Mapping
Title: SharePoint Knowledge Base Setup & Metadata Tagging
Project Description:
Migrating an organizational document registry into a modern, searchable SharePoint environment to capture institutional memory and secure data sharing.
What I Did:
Designed a custom metadata mapping profile layout to organize documents cleanly.
Assigned explicit property tags (such as Project, Document Type, Fiscal Year, and Access Level) across the digital assets.
Configured permissions and access controls to ensure strict data governance.
The Result: Built a fully filterable internal wiki and knowledge repository that protected sensitive data while keeping information instantly discoverable.
0
14
Title: Google Drive Restructuring & File Taxonomy Design
Project Description:
Transforming a chaotic, 4-year-old corporate Google Drive into a streamlined, high-efficiency repository. The client was a growing regional operations team struggling with duplicate files, missing folders, and a complete lack of naming standards.
What I Did:
Audited over 3,000 corporate documents and removed a massive amount of duplicate file clutter.
Designed a standard 5-tier organizational taxonomy tailored to the company’s core business tracks.
Established and deployed a strict, mandatory naming convention framework (YYYYMMDD_DocumentName_v1.0).
The Result: Reduced employee file retrieval times from minutes down to just three clicks.
Project 2: Bulk Data Cleansing
Title: Multi-Source CRM Contact Database Standardization
Project Description:
Scrubbing and consolidating messy consumer data lists compiled across multiple event sign-up forms and legacy sheets into a single, clean master file ready for database migration.
What I Did:
Executed deep deduplication across 15,000 rows of raw customer contact text records.
Normalized phone numbers into standard international formats and fixed mismatched date structures.
Cleaned up text columns by fixing typos, capitalizing names, and separating merged text fields.
The Result: Delivered a 100% error-free, tabular dataset ready for smooth CRM integration without any broken entries.
0
18
Cleansed the Projects Dashboard for Machakos County
1
25