Context
OEC connects insurers, repair shops, and OEMs across the vehicle parts and repair ecosystem, but was running seven disparate products, each with its own database and application stack — expensive to maintain and impossible to report on as a whole.
What I Did
- Directed a methodical migration mapping and moving data from seven disparate products into a single consolidated source, with a workflow to track and correct migration state when anomalies appeared.
- Directed design of a scalable star-schema data warehouse supporting multiple customers simultaneously from a single source of truth.
- Consolidated seven products and their underlying databases into one lower-cost cloud instance, and implemented automatic shutdown of non-production environments outside business hours.
Outcome
- 30% reduction in operational costs through consolidation
- “Pull together and complete a tremendous amount of work in a short time.” — Sara Wojtowicz, Sr. Project Manager, OEC
Capabilities Demonstrated
Data Migration
Data Warehouse Design
Cost Optimization
Cloud Architecture
