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
60
