Design, build, and maintain interactive Power BI and Advanced Excel/Google Sheets dashboards to monitor operational KPIs, order management trends, and resource allocation. Develop automated backend Python scripts (Pandas, NumPy) and advanced SQL queries to extract, clean, and merge multi-source inventory, order, and distribution data. Establish rigorous data quality auditing protocols, ensuring 100% accuracy in stock forecasting, budget calculations, and executive reporting prior to stakeholder distribution. Partner with operational and logistics leads to identify workflow bottlenecks, implementing Python and SQL automations that eliminate manual reporting tasks.

Maintained, audited, and optimized multi-environment production databases (Oracle, SQL Server, PostgreSQL), maintaining 99.5%+ uptime and high data integrity. Automated ETL pipeline executions and integrity checks to catch drift and data inconsistencies before reaching analytical dashboards. Built monitoring dashboards in Grafana to track operational metrics and set up automated alert thresholds for real-time anomaly detection.

Built automated ETL data pipelines to transform raw transactional and inventory data from ERP systems into structured operational reports under ISO 9001 quality standards. Administered Linux/AWS database servers housing operational data repositories, ensuring 99.9% uptime and reliable pipeline execution for order tracking.

Engineered ETL pipeline transformations to consolidate inventory, sales, and supply chain data into centralized SQL repositories for distribution analysis. Analyzed historical order trends, stock levels, and product delivery schedules to support demand forecasting and inventory allocation across distribution points. Executed SQL database query tuning and automated recurring inventory tracking workflows to improve data availability for supply chain operations.

Customized enterprise ERP software (ICG, Pol21) for retail and distribution clients, authoring T-SQL stored procedures, triggers, and complex views for order management. Modeled transactional database structures to track order fulfillment, inventory stock levels, supplier coordination data, and store allocation.

Authored 50+ SQL Stored Procedures to automate business logic and standardize reporting across operational systems. Conducted transactional data migrations and data hygiene audits, reducing reporting preparation cycles by 40%.