John Goliash

Data analyst for manufacturing and warehouse operations in Northeast PA

I make sure the numbers are right before anyone acts on them.

For more than 10 years, I have turned ERP, inventory and shipping data into reports people trust. That includes about six years in manufacturing. At a distributor today, my reports go out every day without anyone asking for them.

Download my résumé Send me a message

PDF, one page, updated October 2026.

Years in data and reporting
10+
Years in manufacturing
6
Automated reports sent every day
10+

Count sheet

Demo with sample data

Bin Item Count System Diff. Status
A-04-02Caster wheel, 3 in48480
A-07-11Hex bolts, box of 501501500
B-02-05Stretch wrap, 18 in36360
B-09-03Pallet labels, roll14140
C-01-08Shipping box, 12 in2102100
C-05-14Zip ties, bag of 1003003000

Bins matching 6 of 6

Inventory accuracy 100%

All six bins match the system.

A demo count sheet with sample data: six bin locations, each with a physical count and the quantity the system expects. When the two differ, the cause is traced and fixed until every bin matches.

Picture the interview

The job: data analyst at a plant or a warehouse in Northeast PA. Here are six common interview questions, with my real answers. Scroll, and the pictures follow along.

  1. Picture it

    You have my résumé. We sit down. Each answer below is mine, and every detail in the pictures comes from my own work.

  2. Question 1 of 6

    “Walk me through your background.”

    I started in 2008 at Univers, checking and fixing client data with Access and SQL Server. When Aon bought Univers, I was promoted to senior systems analyst. In 2018 I moved into manufacturing at Deluxe Building Solutions. Since 2021 I’ve run reporting at English Riding Supply, a distributor. From 2022 to early 2026, I was IT director at AFC Industries, a furniture plant.

  3. Question 2 of 6

    “Tell me about a time the numbers didn’t match.”

    At English Riding Supply, I reconcile physical inventory counts against Sage. When a bin doesn’t match, I don’t just change the number. I find out why. Once it was a shipment that went out but wasn’t posted, so Sage still showed it on the shelf. Another time, the item was sitting in the wrong bin. Fix the cause, and the count matches for real.

  4. Question 3 of 6

    “How do you keep reports going out?”

    I keep Knowledge Sync running. It sends more than 10 automated reports every day, built from Sage data: open orders and backorders, shipping, and sales. People get them without asking. That replaced a lot of one-off requests.

  5. Question 4 of 6

    “Have you worked in a plant?”

    Yes. At AFC Industries, a furniture plant in Berwick, I ran JobBOSS ERP and built reports on orders and shipping. Plant leaders, supervisors and purchasing used them. Before that, at Deluxe, I fixed IT problems right on the factory floor.

  6. Question 5 of 6

    “What if we use a tool you haven’t used?”

    I’ll say so, then learn it. I’m learning Power BI now. My reports have been in Crystal Reports, Excel and Access, pulling from SQL Server and ERP data. The ideas carry over: clean sources, clear measures, and a reader in mind.

  7. Question 6 of 6

    “Why should we hire you?”

    Because I make sure the numbers are right before anyone acts on them. I check the source, find the cause, and explain it in plain words.

    The rest of this interview is yours.

    Download my résumé Send me a message

What I bring to an operations team

  • Reports people use

    I build and maintain automated reports in Crystal Reports, Excel and Access. More than 10 go out every day, so nobody waits on a one-off request.

  • Counts that match

    I reconcile physical inventory counts against the system. When a number is off, I trace it to the cause before anyone acts on it.

  • Warehouse and shipping data

    Barcode scanners, UPS WorldShip, FedEx Ship Manager and LTL freight data. Some of my reports are built for the warehouse and shipping staff.

  • Plant and ERP data

    At a furniture plant I ran JobBOSS ERP and Infor SalesLogix. I built reports on job status, late jobs, materials and shipping for plant leaders.

Résumé

The same résumé as the PDF, set for reading on a phone.

Download PDF Open PDF

Data analyst with 10+ years turning ERP, operational and client data into accurate, recurring reports, including about six years in manufacturing and 5+ years at a distributor. Builds reports and KPI tracking for inventory accuracy, stock levels and backorders, open orders and on-time shipping, and job status from JobBOSS, Infor and Sage data. Checks and reconciles data before anyone acts on it, and explains results plainly to people who don’t live in spreadsheets.

Experience

  1. –

    3 yr 11 mo

    IT Director

    AFC Industries (furniture manufacturing), Berwick, PA

    • Built reports from JobBOSS ERP and Infor data on production and job status (including late jobs), inventory and materials, and orders and shipping, used by plant leadership, production supervisors and purchasing.
    • Administered JobBOSS ERP and Infor SalesLogix CRM, maintaining data integrity for daily plant operations.
    • Implemented NAS-based backups and Ubiquiti/Cisco networks with Starlink backup connectivity; reported status to plant leadership, managed support through a ticketing system, and mentored staff.

  2. –present

    5 yr 8 mo

    Data Operations Report Administrator

    English Riding Supply, Scranton, PA

    Equestrian products distributor. Full-time until March 2022, part-time since.

    • Build and maintain automated reports from Sage data in Crystal Reports, Excel and Access for inventory and stock, orders and shipping, purchasing and vendors, and sales and marketing, including reports used by warehouse and shipping staff.
    • Sustain Knowledge Sync, which sends 10+ automated reports daily, replacing one-off requests with recurring reports.
    • Reconcile physical inventory counts against Sage; work with barcode scanner systems and shipping data from UPS WorldShip, FedEx Ship Manager and LTL freight carriers.
    • Maintain pricing, inventory, customer and content data in Sage and the B2B web portal; provide local IT support.

  3. –

    2 yr 4 mo

    Data Analyst / IT

    Deluxe Building Solutions (modular construction startup, now closed), Berwick, PA

    • Developed data and analytics solutions for modular manufacturing, supply chain and CAD software; collaborated with software development on database initiatives.
    • Built spreadsheets and operating procedures from scratch; tested new software company-wide before rollout.
    • Administered Active Directory, cloud file permissions and the Ubiquiti network; fixed IT issues on the factory floor.

  4. –

    2 yr

    Senior Systems Analyst

    Aon, Hammonton, NJ

    • Promoted after Aon acquired Univers; imported and exported client census, coverage and deduction data in pre-approved formats and gathered benefit plan details with account management.
    • Investigated HR data-quality issues when client files arrived in inconsistent formats; applied Aon’s file-creator and post-file procedures to cleanse and reprocess the data.
    • Built SQL-based reports and extracts in Access (queries, VBA, forms) and SQL Server for sales and marketing reporting; partnered with developers on enrollment-team fixes that improved efficiency and accuracy.

  5. –

    8 yr 1 mo

    Systems Analyst (Data Analyst)

    Univers Workplace Solutions (acquired by Aon), Hammonton, NJ

    • Managed end-to-end client data import/export: validated, cleansed and reconciled data for accurate transfers.
    • Built reports and queries in Access and SQL Server; troubleshot data discrepancies with clients and internal teams.

Skills

Reporting and analysis
Crystal Reports, Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, macros/VBA), KPI and operational reporting, data validation and reconciliation, data import/export and cleansing, process improvement
Inventory and shipping
Physical inventory reconciliation, inventory accuracy, stock levels and backorders, open orders and on-time shipping, barcode scanners, UPS WorldShip, FedEx Ship Manager, LTL freight
Data and ERP
SQL Server, Access (queries, VBA, forms), JobBOSS ERP, Infor SalesLogix CRM, Sage, Knowledge Sync
Tools and systems
Power BI (learning), Microsoft Copilot, ChatGPT, self-hosted LLM tools, Windows Server / Active Directory, Ubiquiti and Cisco networking, Proxmox / Linux

Education

  • B.S., Computer Engineering Technology
    Northeastern University, Boston, MA
  • CompTIA A+ certification training
    Hardware, software, networking and security. Tampa, FL

KPI lab

Pick a measure and change the numbers. You’ll see the math and how I would read the result. It all runs in your browser. Nothing you type is sent or saved.

Measure

Of the bins you counted, how many matched the system?

With JavaScript off, here is one worked example: 492 of 500 counted bins matched the system, so inventory accuracy is 98.4%.

Inventory accuracy

98.4%

492 matched ÷ 500 counted

8 of 500 bins were off. Recount those first. Then look for a pattern by item, aisle or shift so it doesn’t repeat.

Things I’ve built

Outside work, I build and run small websites and a home server. All the sites share one written standard of 33 rules I learned the hard way: $0 a month to run, no analytics, and color contrast that is measured, not guessed. Newer sites follow it from day one. Older ones get fixed as I touch them.

  1. Self-hosted AI agent

    An AI agent in an Ubuntu container on my Proxmox home server. You can only reach it over a Tailscale VPN, and it talks to a language model through an API. Next up: voice and messaging, with offline speech-to-text.

    Proxmox, Ubuntu, Tailscale, LLM API

  2. mixyz.xyz

    MixYZ, a one-page site about mixing two technologies into something new. Its Mix lab runs in your browser.

    Cloudflare Pages, plain HTML, CSS and JavaScript

  3. wint.win

    Win Twin, the site for my technical consultancy: databases, reporting, cloud and security in Northeast PA. Its contact form logs every message to a Google Sheet.

    Cloudflare Pages and Workers, Google Apps Script

  4. OliUni.com

    A gallery for the nature photographer Oliver Norden: fifty photographs and a viewer I built for them. I moved it from Firebase to Cloudflare Pages.

    Cloudflare Pages, responsive video

  5. john.cyou

    My site for web design and in-home tech support in Northeast PA.

    Netlify

  6. This site

    Hand-written HTML, CSS and JavaScript. No framework, no build step, no trackers. The section below says how it was made.

    Cloudflare Pages and Workers, Google Apps Script

How I built this site

Build notes, October 2026

An AI helper wrote the first draft of this site. I set the rules, checked every page, and fixed what it got wrong. Here is who did what.

Who did what

I wrote the rules this site had to follow. They came from my other sites: no trackers, a short intro you can skip, light and dark mode, and words a sixth grader can read. I also decided what it should say about me, and I checked every claim against my real work. The AI wrote the first draft of the rest. That means the pages, the styling, the intro, the count sheet, the KPI lab, and the notes that explain how it all fits together.

Where it went wrong

  • It mixed blue and amber to make the green you see all over this page. In light mode the two colors sat just over halfway around the color wheel, so the mix came out purple. Moving them a few degrees fixed it.
  • An earlier AI-made PDF of my résumé stored every job date at the top of the file’s hidden text. A hiring system could read the dates apart from the jobs. The new one keeps each date with its job.
  • It told me it had added eight questions to my interview notes. It had added seven.
  • It animated the stops on the story’s road from gray to green. In Chrome they turned black instead. The fix was to fade a green dot in on top.
  • On phones, the interview story started late. It waited until 12% of the section was on screen, and that section is several phone screens tall.
  • The speech bubble in the last scene covered my head.

Each one looked fine in the code or in the chat. Each one was wrong when checked. They got caught because the work was measured and looked at, not just read.

Why say any of this?

Because it’s how I work with data too. A first draft is fast. Checking it is the job. Nothing here went live until a person had read every line.

Under the hood

Hosting
Cloudflare Pages, free plan
Built by hand
Plain HTML, one style file, one script. No website builder
Outside code
None. Not even fonts
Analytics
None. Nobody is watching you
The green
color-mix(in oklch, blue, amber), worked out by your browser
Contact form
A small Cloudflare Worker hands your message to a Google Sheet and my inbox
Running cost
$0 a month, on purpose

Get in touch

Hiring for a data, reporting or inventory role in Northeast PA? Have a question about something on this page? Send a message. I read every one myself.