Customer: Rodan + Fields Skincare Company
Type: Business Intelligence
Requirements: Rodan & Fields is a growing Anti-Aging Health Care company. The Project involved migrating the company’s legacy system to a new system and providing production and technical support after the migration. The project also include maintaining existing SQL Server data warehouse and migrating data from Hybris Ecommerce system to MS SQL Server OLTP database and from OLTP database to OLAP EDW data warehouse. Additionally our team was required to first migrate data to SalesForce cloud database and then integrate it with the company's on-premise SQL Server database.
Challenge:The key challenge in the execution of this project is converting historical dates to UTC while accounting for daylight saving times before migrating data to Salesforce cloud database. This is because Salesforce stores datetime records in GMT.
Solution:Our team wrote a T-SQL script to convert current and historical datetime records to GMT while accounting for daylight saving times.
Results:Exactbid's business analysts and SMEs were satisfied with our work such that we were given production support project.
Region: United States of America
Engagement model: Variable cost model
Technologies: SQL Server, TSQL, SSIS, SSRS, SSMS, Jira, Git/Bitbucket
Duration: 12 months
Staff: 4 BI developers, 2 SQL Server Developers