Story 01 · Woodbine Entertainment · HR Data Migration
HR Centralized Reporting Solution
Challenge
- HR candidate data from Lever was split across six Excel files
- Resumes were held in a separate bulk export
- Scope changed shortly before the deadline
My Role
- Performed the data migration end to end
- Rebuilt the Lever data structure from scratch
Approach
- Analyzed the data to design an efficient, accurate structure
- Defined primary and foreign keys to prevent discrepancies
- Built linked datasets and data models in Power BI, SharePoint, PowerShell, and Excel
- Matched each resume to its candidate profile ID
Result
- 450,000 records restructured
- Six Excel files combined into one structured file
- Delivered on schedule despite late scope changes
- HR can open any of 160,000 filtered profiles, with its resume