Step 1: Consolidate Files Step 2: Format Date in EcomStore Step 3: Fill Missing Data Step 4: Normalize Order IDs Step 5: Add Order Status to EcomStore

The client aimed to analyze NFL 3rd down conversion percentages for all teams from 2019-2023. Project Goals: Extract NFL data using an authenticated API.

Created an automated ETL workflow to consolidate data from various CSV files, including sales, customer information, and product details, into a centralized rep

Developed an ETL solution to integrate data from multiple web services APIs, parsing JSON responses and transforming the data for a comprehensive marketing anal

Description: Migrated product and inventory data from an Oracle database to an e-commerce platform. Leveraged Pentaho Data Integration (PDI) to automate the ext