Datawarehouse

• Implemented a financial data warehouse in a team environment using Kimball’s Bottom-Up Approach. • Tasks included but not limited to Data Warehouse design (Star Schema), design rules for data integration, data mapping, handling of slowly changing dimensions and junk dimensions. • Deployed an AWS EC2 instance using AWS CLI to host the Data Warehouse on RedShift database and presented visually appealing interactive dashboards on Tableau Desktop.