Get a Quote

Send us awesome idea of your future software product and we will certainly get back to you in two business days.
contact@eclisoft.com
+1 (510) 761-5579
Contact

Rodan and Fields Skin Care

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

Industry: Health

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

Category

Health