j
johnschank

John Schank

@johnschank

SQL and ERP Troubleshooting

Verenigde Staten
Engels
Sommige informatie wordt in het Engels weergegeven.
Over mij
I troubleshoot ERP/WMS systems and write SQL to fix messy inventory data — including legacy/homebrew platforms (AIX/RS6000-era) most freelancers won't touch. If your numbers don't add up or your system is a black box nobody understands, I'll find out why and fix it. ✅ SQL: extraction, cleanup, reporting ✅ ERP/WMS troubleshooting & inventory audits ✅ Legacy system experience ✅ Fast, honest, no-runaround communication Send me your data mess — I'll tell you straight if I can fix it, then get it done.... Lees meer

Skills

j
johnschank
John Schank
offline • 

Bekijk mijn diensten

SQL- en NoSQL-query's
I will write sql queries for your data
VanafUS$ 25 / projectMeer informatie

Portfolio

Werkervaring

The_Home Depot

Senior Supply Chain Analyst

The Home Depot • Fulltime

Jul 2013 - Present • 13 yrs

At HD Supply, I worked extensively with SQL and internal systems to support inventory accuracy, operational reporting, and cross-team visibility into performance metrics. Key contributions included: Legacy ERP/WMS Troubleshooting — Diagnosed and resolved inventory discrepancies and workflow issues within internal ERP and warehouse management systems, including legacy platforms with limited documentation or support. SQL Development & Data Analysis — Wrote and optimized SQL queries to extract, clean, and reconcile inventory and operational data across multiple systems, supporting accurate reporting and decision-making. Salesforce Dashboard Development — Built a reporting dashboard using Salesforce data to give field stakeholders real-time visibility into SLA performance and resolution quality, replacing manual reporting processes with automated, actionable insights. Process Improvement — Identified inefficiencies in existing workflows and reporting processes, and implemented solutions that improved data accuracy and reduced time spent on manual reconciliation. This role sharpened my ability to work with complex, sometimes undocumented systems, translate raw data into clear operational insights, and support field and stakeholder teams with reliable, actionable reporting.