j
johnschank

John Schank

@johnschank

SQL and ERP Troubleshooting

Estados Unidos
Inglês
Algumas informações são exibidas no idioma inglês.
Sobre mim
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.... Saiba mais

Habilidades

j
johnschank
John Schank
offline • 

Conheça meus serviços

Consultas SQL e NoSQL
I will write sql queries for your data
A partir deUS$ 25 /projetoMais detalhes

Portfólio

Experiência profissional

The_Home Depot

Senior Supply Chain Analyst

The Home Depot • Período integral

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.