Multinational Retail Data Centralization
AiCore
Jun 2024 - Dec 2024 (7 months)
In my role focused on Multinational Retail Data Centralization, I was responsible for consolidating and managing sales data from various international sources to enhance reporting accuracy and efficiency. I utilized a Python script to transform and extract sales datasets from diverse formats, including S3 buckets, PDFs, and CSV files, into my local PostgreSQL database. Additionally, I performed SQL queries to address critical business questions, ensuring that the data analysis was aligned with strategic objectives. To facilitate better decision-making, I created a comprehensive dashboard using Power BI, showcasing key metrics that drove actionable insights. This integration of data analytics and cloud computing tools significantly improved