I'm a data analyst with proven expertise in streamlining analytics across ERP and TMS platforms. I specialise in turning raw operational data into clear, actionable insights. My background includes deep experience in cross-system data flows, API and EDI integrations, and building custom reporting tools for logistics, supply chain, and financial operations.
Core Competencies
Data Cleaning, Transformation & Visualization
Dashboard Development (Power BI, Tableau, Excel)
SQL & Advanced Excel Reporting
ERP/TMS Integrations & Data Flow Mapping
API & EDI Data Exchange (JSON, XML, X12, EDIFACT)
Data Migration, Validation & Reconciliation
Cross-functional Stakeholder Collaboration
ERP Systems:
SAP S/4HANA – Module-level reporting, cost center analysis, data modeling
Oracle Cloud ERP – Procurement, financials, custom integrations
Microsoft Dynamics 365 – Power Platform dashboards, custom connectors
TMS & Logistics Platforms:
MercuryGate – Rate analysis, EDI 204/214/210 processing
CW1 (CargoWise One) – Warehouse/Freight & Borders cross-module data sync
Magaya – Shipment visibility, inventory trends, EDI/XML integrations
Alpega TMS – Route optimisation reporting, API-based data feeds
Integrations & Data Exchange
EDI Transactions: Experienced with logistics EDI formats such as 850, 204, 210, 214 (inbound/outbound), ensuring smooth data flow between TMS/ERP systems and trading partners.
API Integrations: Developed and maintained API connectors to synchronise shipment, invoice, and master data across systems, including D365, Alpega, MercuryGate, and external CRM/finance tools.
Data Mapping & Transformation: Built data pipelines and mapping logic to translate data between formats (e.g., JSON → XML → SQL) and platforms for clean, consistent reporting.
Integration Tools: REST APIs, Webhooks, Postman, Power Automate, Zapier, SFTP file drops, middleware platforms (e.g., Boomi, MuleSoft exposure).
Project Examples
Integrated Dashboard Suite – Unified data from D365, Magaya, and MercuryGate into a single Power BI view with real-time metrics.
Automated EDI Processing – Created workflows to automatically parse and validate EDI 204/210 files from freight partners into CW1 and Oracle Cloud.
API-Based Shipment Sync – Built API flows to send shipment status updates from Alpega to customer-facing platforms.
ERP-TMS Reconciliation Tool – Developed tools to reconcile freight costs and delivery metrics between S/4HANA and multiple TMS platforms.