• 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.
