Javier Torres

01 — About

Twenty years of fixing the process, not just the symptom

03 — Experience

Where I've done the work

1. Inventory & Supply Chain Analyst

   Golden Pet Brands · Richfield, WI · Jan 2025 – Present

   • Reconcile hand-written production and consumption records for every operation line against NetSuite, correcting whichever side is wrong so batch, lot, and work order data stays accurate and audit-ready.
   • Investigate material variances by tracing lot movement through bins and work orders, identifying where usage was mis-posted, and correcting documentation to match what was physically produced.
   • Rebuilt daily data validation using SuiteQL queries and Saved Searches to work around an ERP configuration with no API access, surfacing duplicate entries, leftover balances, and mis-posted consumption before month-end.
   • Built a macro-driven Excel review tool that flags entry errors, leftover balances, and batch inconsistencies, replacing a manual page-by-page check.

2. Data Engineer

   Medline Industries · Libertyville, IL (Remote) · May 2022 – Aug 2024

   Hired as Programmer / Analyst; title changed with job family reclassification.

   • Owned the daily Build & Gather process that consolidates item-change data from multiple systems for upload into SAP — ran the 4:00 PM release, stayed on for after-hours recovery, and traced recurring upload errors to their root cause, fixing either the business rule or the code behind it.
   • Partnered with developers on a bot-driven customer setup workflow: a bot extracted request details from a shared mailbox, my program enriched them with the required table and field lookups, and the output generated a Winshuttle template that created the customer in SAP on a schedule — eliminating the manual lookups that previously consumed staff time.
   • Created and led "Intro to SQL," a training program built on the division's own data as a running scenario, delivered as written documentation, a chaptered video series, and live webinars; raised self-reliance across the team.
   • Wrote SQL queries against SAP HANA for teams throughout the division and served as the division's informal SQL resource; administered Zendesk accounts and access control.

3. Master Data Management Analyst

   Medline Industries · Northfield, IL (Remote from Mar 2020) · May 2019 – May 2022

   • Designed and directed a web-based Country of Origin application, built start to finish remotely with a developer — requirements, user interface, database structure, workflow rules, automated notifications, escalation for overdue requests, and full testing. Cut response time from over a week to instant where data was on file and eliminated the manual email coordination between Government Sales and product managers. The application was adopted across departments company-wide.
   • Led a company-wide barcode cleanup: verified that every Medline item carried a Medline barcode matching its box art and that GTIN assignments met GS1 standards. Resolved a conflict where US barcodes were being reused by the Canada team by establishing separate barcode buckets for US, Canada, and other markets so it could not recur.
   • Ran DataSync and Country of Origin operations; prepared and uploaded item data to 1WorldSync on customer request.
   • Reduced a monthly license-expiry report from roughly 16 hours by narrowing the data scope to customer-specific expiration windows instead of full three-year account downloads.
   • Wrote Standard Operating Procedures by sitting with each team member to learn their job, then presenting the documented process back to the team; produced chaptered training videos and delivered separate webinar sessions for the two audiences that used the Country of Origin application (product managers and Government Sales).

4. Programmer / Analyst

   Medline Industries · Northfield, IL · Jan 2018 – May 2019

   • Modernized legacy FoxPro reporting by writing stored procedures against SAP HANA that reproduced the existing DBF output exactly — including documented legacy defects — so downstream systems saw no change. Removed the exclusive-file-lock outages the old process caused and cut processing time.
   • Tested and debugged 300+ Winshuttle scripts for the SAP 5.0 to ECC 6.0 upgrade, tracing failures to renamed or relocated fields and correcting and retesting each script so automation was ready at go-live.
   • Developed and scheduled SSRS reports for multiple departments, from requirements gathering through delivery.

5. Business Process Analyst

   Medline Industries · Mundelein, IL · Nov 2009 – Jul 2017

   • Led the redesign of fabric inventory control across 5 subcontractor sites in Mexico and the US, moving the division from a single annual physical inventory to a daily barcode cycle-count discipline: assigned every fabric roll a unique ID, barcoded warehouse slots and work areas, and captured cut recaps in the scanner so any roll could be traced to the purchase order it produced — establishing recall-ready traceability where none had existed.
   • Moved cycle counting from a full day every Thursday to a few specific slots counted each morning, using A/B/C classification to direct attention to the highest-demand fabrics. Accuracy improved enough that the annual physical inventory in Mexico was eliminated.
   • Built a cycle-count dashboard consolidating subcontractor progress toward projected production, top fabrics gained and lost, performance trends, and an accuracy score. Cut the weekly production meeting from 60 minutes to 30 and surfaced problems the old report hid.
   • Deployed microservers at each subcontractor site, consolidating what had been 15 separate desktop data files into 5 local hubs, and wrote a Robocopy synchronization job that ran overnight — reducing transfer errors and the daily manual exchange of files.
   • Automated goods-receipt variance correction: a program detected where US shipment quantity and Mexico receipt quantity disagreed, generated the correction file, and a Winshuttle script posted it automatically instead of the manual adjustment being made by hand.
   • Cut the time to receive data files from Mexico from 2 days to 3 hours by introducing shared collaboration tools, later replaced by the automated synchronization described above.
   • Identified the root cause of long-standing fabric discrepancies as a system timing problem — fabric consumed to receive a purchase order before the fabric had been received into inventory — and documented the control weakness with a recommended fix.
   • Served as the division's de facto helpdesk for internal staff and all subcontractor sites; trained staff in Spanish on Excel, FoxPro, and internal systems, both one-on-one and in groups.

6. Production Scheduler

   Medline Industries · Mundelein, IL · Nov 2007 – Nov 2009

   • Scheduled production for subcontractors in Mexico against line capacities for made-to-order products; created production orders in SAP and adjusted schedules for expedited orders.
   • Built per-subcontractor Excel packages showing order requirements and each line's capacity so they could plan their own production, and forecasted item usage to balance inventory without surplus.
   • Coordinated daily in Spanish with subcontractors to verify order status, and gave sales representatives proactive notice of delays rather than after-the-fact excuses.
   • Served as backup for the in-house FoxPro inventory control system — the entry point into the programming work that followed.

7. Data Analyst

   Reliable Plating Works, Inc. · Milwaukee, WI · 2005 – 2007

   • Designed and maintained the Access database that captured production inspection, lab, and polishing data.
   • Built a second Access database for the sister company and was placed in charge of all computers at that site in my second year.
   • Interpreted between plant workers and HR management (English/Spanish) and handled Windows Server user and workstation administration.

8. Owner

   The STUFF Networks LLC · Milwaukee, WI · 2006 – Present

   • Run a small technology services business serving clients who could not otherwise afford help: hardware and software troubleshooting, home and small office networking, web design and hosting, and one-on-one computer instruction.

9. Earlier Experience

   • Data Entry Clerk, Credit Solutions S.C., Milwaukee, WI (2003 – 2004) — maintained the database of filed cases and managed a six-workstation Windows server environment.
   • Master Data Analyst, Medline Industries, Mundelein, IL (2001 – 2002) — entered new item information into SAP and ran FoxPro error reports to catch bad data at the point of entry.

05 — Home Lab

Where the infrastructure skills actually live