Hi, I'm John Romer Alimane.
Hi, I'm John Romer Alimane.
Data Analyst | Spreadsheets Automation & ETL Specialist
Data Analyst | Spreadsheets Automation & ETL Specialist
Embedded Files
Python • SQL • Google Sheets • Apps Script • ETL • API Integration • Looker Studio • Dashboard Design
Python • SQL • Google Sheets • Apps Script • ETL • API Integration • Looker Studio • Dashboard Design
I build automated dashboards, custom Google Sheets systems, and end-to-end data workflows that transform raw data into reliable business reports. Using Python, SQL, Power BI, Google Workspace, and ETL pipelines, I develop automation solutions that reduce manual work, improve reporting accuracy, and support data-driven decision-making.
I build automated dashboards, custom Google Sheets systems, and end-to-end data workflows that transform raw data into reliable business reports. Using Python, SQL, Power BI, Google Workspace, and ETL pipelines, I develop automation solutions that reduce manual work, improve reporting accuracy, and support data-driven decision-making.
Below are my case studies, showing my proficiency in processing and presenting data using different mediums.
Below are my case studies, showing my proficiency in processing and presenting data using different mediums.
🚀 Configurable Python ETL Pipeline with Audit Logging
🚀 Configurable Python ETL Pipeline with Audit Logging
Designed and developed a configurable Python ETL pipeline that automates the extraction, validation, cleaning, auditing, and reporting of multi-channel e-commerce datasets. The project generates standardized datasets and audit reports for Power BI dashboards, demonstrating real-world ETL development and data quality monitoring.
Designed and developed a configurable Python ETL pipeline that automates the extraction, validation, cleaning, auditing, and reporting of multi-channel e-commerce datasets. The project generates standardized datasets and audit reports for Power BI dashboards, demonstrating real-world ETL development and data quality monitoring.
📸 Folder Structure
📸 Folder Structure
Purpose:
Shows the modular architecture of the ETL pipeline, including configuration files, ETL modules, datasets, and utility scripts.
₿ Crypto Market Dashboard with API Integration (Google Sheets Automation)
₿ Crypto Market Dashboard with API Integration (Google Sheets Automation)
Developed an automated reporting system that retrieves external API data and converts it into interactive dashboards and monthly KPI comparisons.
Developed an automated reporting system that retrieves external API data and converts it into interactive dashboards and monthly KPI comparisons.
📊 BI Case Study –Project page Business Performance Dashboard
📊 BI Case Study –Project page Business Performance Dashboard
Built an interactive KPI dashboard that transforms raw data into actionable insights through dynamic charts, product filters, and month-over-month analysis.
Built an interactive KPI dashboard that transforms raw data into actionable insights through dynamic charts, product filters, and month-over-month analysis.
📊 Internal Staff Operations Automation (Google Sheets & Apps Script)
📊 Internal Staff Operations Automation (Google Sheets & Apps Script)
Automated internal staff workflows using Google Sheets, Google Forms, Google Sites, and Google Apps Script to streamline data collection, reporting, and email notifications.
Automated internal staff workflows using Google Sheets, Google Forms, Google Sites, and Google Apps Script to streamline data collection, reporting, and email notifications.
FINANCIAL DASHBOARD
FINANCIAL DASHBOARD
📊 Ecommerce Marketing Performance & Budget Tracking System
📊 Ecommerce Marketing Performance & Budget Tracking System
Created a marketing dashboard to monitor budget pacing, campaign performance, and planned versus actual spend across multiple channels.
Created a marketing dashboard to monitor budget pacing, campaign performance, and planned versus actual spend across multiple channels.
BUDGET PACING (WEEKLY)
BUDGET PACING (WEEKLY)
🐍 Sales ETL Pipeline & Business Performance Dashboard
🐍 Sales ETL Pipeline & Business Performance Dashboard
Built a Python-based ETL pipeline to clean and standardize large CSV datasets, generate SQL-based reports, automate Google Sheets integration, and deliver interactive business dashboards through Looker Studio.
Built a Python-based ETL pipeline to clean and standardize large CSV datasets, generate SQL-based reports, automate Google Sheets integration, and deliver interactive business dashboards through Looker Studio.
📸 Folder Structure
📸 Folder Structure
Purpose:
Shows the modular architecture of the ETL pipeline, including configuration files, ETL modules, datasets, and utility scripts.
RAW CSV FILE
RAW CSV FILE
CLEANED CSV FILE
Get in touch at johnromeralimane09@gmail.com
Get in touch at johnromeralimane09@gmail.com
Page updated
Google Sites
Report abuse