Developed a central datawarehouse solution for a global retailer, replicating transactional data into a consolidated AWS RDS SQL Server instance to enable enterprise-wide group reporting.

Developed a central datawarehouse solution for a global retailer, replicating transactional data into a consolidated AWS RDS SQL Server instance to enable enterprise-wide group reporting

Developed a central datawarehouse solution for a global retailer, replicating transactional data into a consolidated AWS RDS SQL Server instance to enable enterprise-wide group reporting. Data Engineering

What we did

  • Ingested data from more than 20 source systems, including Oracle, SQL Server, and legacy operational databases.
  • Semantic model developed in Tableau along with sales and operational dashboards for enterprise-wide reporting.

Tech

AWS RedShift AWS RDS Microsoft SQL Server PostgreSQL Oracle Tableau

← Back to all work

Rob's AI Assistant
Ask about projects, work, certifications

Hi! Please share your name and email to start the chat. Rob may use these to follow up. Conversations are logged.

Initialising bot check…