VantaCommerce is an end-to-end BI & data automation platform that turns messy, multi-source business data into reliable reporting. It combines Python/Pandas, REST APIs, CSV/Excel and SQL Server to automate ingestion, cleaning, validation, transformation and reconciliation before loading into Power BI. Includes Bronze-Silver-Gold ETL, data warehousing, dimensional modeling, incremental processing, SCD Type 1/2, logging and automated reporting across sales, customers, products, profitability
Tech & Development
Mohamad
BI & Data Automation Developer | Power BI, SQL, Python ETL
Verified ID2 portfolio pieces
Member since September 2026
Overview
I build the data infrastructure behind reliable BI reporting — not just dashboards.
I connect and automate data from multiple sources (REST APIs, CSV, Excel) into structured SQL Server warehouses, using Python/Pandas for ETL, incremental loading, and data validation. Then I build the Power BI layer (DAX, data modeling) on top of clean, trustworthy data.
If your data lives across scattered systems and nobody trusts the numbers, that's the problem I solve.
Data & AnalyticsData EngineeringAI & AutomationDatabase DesignAPI DevelopmentData Science
Work
2 portfolio pieces
Image 1 of 7
Data & AnalyticsDatabase DesignData EngineeringScripting & Automation
Image 1 of 5
Automated reporting pipeline that transforms raw Excel/CSV sales data into a structured SQL Server warehouse and Power BI reporting environment. Built a Python/Pandas processing layer for data profiling, cleaning and validation, followed by SQL Server staging and ETL. The warehouse uses dimensional modeling, incremental loading, SCD Type 1/2, reconciliation and ETL logging before delivering data to a Power BI semantic model. The final solution provides automated reporting
Data EngineeringData & AnalyticsDatabase DesignScripting & Automation
Reviews
No reviews yet