John Goliash

Counts that match. Reports people trust.

John Goliash

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 10+ years, I’ve helped companies make sense of their numbers. I ensure accurate reports on inventory, sales, and fulfillment go out daily, getting critical insights into decision-makers’ hands before they even have to ask.

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 questions interviewers often ask, with my real answers. As you scroll, 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 in Access and SQL Server, two Microsoft programs that store and sort large amounts of data. When Aon bought Univers, I was promoted to senior systems analyst. In 2018 I joined Deluxe Building Solutions as a Data Analyst / IT Specialist, building spreadsheets, supporting plant IT, and implementing data applications to handle large volumes of modular manufacturing data. Since 2021 I’ve run reporting at English Riding Supply, a distributor of horse-riding (equestrian) supplies. From 2022 to early 2026, I was also the IT director at AFC Industries, a furniture plant, in charge of its computers and network. I kept my English Riding Supply job part-time during those years.

  3. Question 2 of 6

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

    At English Riding Supply, we count what’s really on the shelves and compare it with what Sage, our business software, says should be there. When a bin (one spot on a shelf) doesn’t match, I don’t just type in the new number. I find out why. Once, an order had shipped, but nobody marked it as shipped in Sage, so Sage still thought it was on the shelf. Another time, the item was sitting in the wrong bin. Each time, I fixed what caused the mismatch. Then the count matched for real.

  4. Question 3 of 6

    “How do you keep reports going out?”

    I keep Knowledge Sync running. It’s a program that pulls numbers out of Sage and emails reports on a schedule, more than 10 every day: open orders, backorders (orders waiting for stock to come in), shipping and sales. People get them without having to ask, and nobody has to rebuild the same report by hand. Our purchasing team uses my reports to see what’s selling, plan ahead, and order equestrian supplies in time to fill customer needs.

  5. Question 4 of 6

    “Have you worked in a plant?”

    Yes. At AFC Industries, a furniture plant in Berwick, I ran JobBOSS, the plant’s main business system (its ERP), which tracked every job from order to shipping. I built reports on orders and shipping for three groups: the plant leaders, the supervisors, and the purchasing team, the people who order the materials. Before that, at Deluxe Building Solutions, I fixed computer problems right on the factory floor.

  6. Question 5 of 6

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

    I’ll tell you, and then I’ll learn it. Right now I’m learning Power BI, Microsoft’s tool for charts and dashboards. So far my reports have been in Crystal Reports, Excel and Access, pulling data from SQL Server databases and ERP systems. The skills carry over to any tool: start with clean data, measure what matters, and build every report with the reader in mind.

  7. Question 6 of 6

    “Why should we hire you?”

    I make sure the numbers are right before anyone acts on them. I check where each number came from, find the cause when one is wrong, and explain it in plain words. That protects your profit. When the inventory count is right, you don’t run out of what customers want, and you don’t tie up cash in stock nobody needs. Customers get their orders, and they keep coming back.

    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 keep up automated reports in Crystal Reports, Excel and Access. More than 10 go out every day on their own, so nobody waits for someone to make one by hand. The purchasing team uses them to decide what to order and when.

  • Counts that match

    I compare what’s really on the shelf with what the computer says should be there. When a number is off, I find the cause before anyone acts on it. Right counts mean fewer surprises: no running out of what customers want, and no cash stuck in extra stock.

  • Warehouse and shipping data

    I work with barcode scanners and with shipping data from UPS WorldShip, FedEx Ship Manager and LTL freight. LTL means “less than a truckload”: a shipment too big for a parcel service but too small to fill a truck. Some of my reports are made just for the warehouse and shipping crews.

  • Plant and ERP data

    At a furniture plant I ran JobBOSS, the plant’s ERP (the main system that tracks orders, jobs, stock and shipping), and Infor SalesLogix, which kept track of customers. I built reports on job status, late jobs, materials and shipping for the plant’s leaders.

Résumé

The same résumé as the PDF, set for reading on a phone. New to a short form like ERP or LTL? The plain-English dictionary below explains each one.

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

A KPI (key performance indicator) is one number that tells you how something is going, like a grade on a report card. Open the Measures menu, pick one of 14, and change the numbers. Each one shows the formula, explains it in plain words, and says how I would read the result. It all runs on your own device and nothing you type is sent anywhere. File > Save keeps your numbers on this device.

KPI Lab Inventory accuracy

Inventory

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.

In plain words

Inventory accuracy tells you how often the computer is right about what’s on the shelf. Count a set of bins, then check each count against the system. A bin only counts as a match when the two agree exactly.

The formula

Inventory accuracy = bins that matched ÷ bins counted × 100

Why it matters

If the computer says you have 10 and the shelf has 4, you’ll promise orders you can’t ship. Every other report is only as good as this number.

ReadyRuns on your device

Plain-English dictionary

Short forms and shop talk from this page, in plain words. Anywhere on the page, tap a highlighted word to see what it means in a bubble.

Active Directory
The list at work that says who can log in and what each person is allowed to open.
API
A doorway one computer program uses to ask another program for something and get an answer back.
B2B web portal
A website for other businesses, not shoppers. They log in to see prices and place orders.
Backorder
An order that has to wait because the item is out of stock. It ships when new stock comes in.
Barcode scanner
A handheld reader that beeps when it reads the striped label on a box, so nobody has to type the item number.
Bin
One small spot on a shelf with its own address, like A-04-02. It’s how a warehouse knows where each thing lives.
CAD
Computer-aided design: drawing things, like the parts of a house, on a computer instead of on paper.
Census data
In benefits work, a list of a company’s workers: names, birthdays, pay and so on.
Cleanse (data)
Fix the typos, copies and blanks in data so people can trust it.
Cloudflare
A company with computers all over the world that show websites fast. This site lives there for free.
CRM
Customer relationship management: a program that remembers every customer, what they bought, and when someone last called them.
Crystal Reports
A program that turns rows of data into neat reports you can print or email.
Cycle count
Counting a few bins every day, instead of shutting down to count the whole warehouse once a year.
Days of supply
How many days your stock will last if sales keep the same pace.
Distributor
A company that buys lots of goods from the people who make them, then sells them to stores and other businesses.
Downtime
Time a machine was supposed to be running, but wasn’t.
EOQ
Economic order quantity: the order size that keeps the cost of ordering plus the cost of storing as low as it can be.
ERP
Enterprise resource planning: the main computer system a company runs on. It keeps orders, stock, jobs, shipping and money in one place. JobBOSS and Sage are both ERPs.
Fill rate
Out of everything customers ordered, how much you actually sent them.
HR
Human resources: the team that hires people and takes care of pay and benefits.
Inventory accuracy
How often the computer’s count matches what’s really on the shelf.
Inventory turns
How many times a year you sell all your stock and buy it again.
IT
Information technology: computers, networks and software, and the people who keep them working.
JobBOSS
An ERP made for factories and job shops. It follows each job from the order to the shipping dock.
Knowledge Sync
A program that watches business data and emails reports on a schedule, all by itself.
KPI
Key performance indicator: one number that tells you how something is going, like a grade on a report card.
Lead time
How long you wait between ordering something and having it on your shelf.
Linux
A free operating system, like Windows, that runs most of the world’s servers.
LLM
Large language model: the kind of AI that reads and writes words, like ChatGPT or Claude.
LTL
Less than truckload: a shipment too big for a parcel service but too small to fill a truck, so it shares one with other shipments.
Modular construction
Building parts of a house in a factory, then trucking them to the lot to put together.
NAS
Network-attached storage: a box of hard drives on the office network that keeps shared files and backups.
OEE
Overall equipment effectiveness: how much of a machine’s planned time made good parts at full speed.
Perfect order
An order with nothing wrong: on time, complete, not damaged, and billed right.
Pivot table
An Excel tool that adds up thousands of rows in seconds, like total sales for each month.
Power BI
Microsoft’s tool for making charts and dashboards from data.
Proxmox
Free software that lets one computer act like several smaller computers.
Purchasing team
The people who decide what to buy, how much, and when, so the shelves never run empty.
Reconcile
Compare two lists that should match, like the shelf count and the computer, then fix the reason they don’t.
Reorder point
The stock level that tells you: time to order more.
Safety stock
A few extra on the shelf, just in case sales jump or a truck is late.
Sage
Business software that keeps track of stock, orders, customers and money.
Scrap
Things you made that can’t be sold or fixed, so they get thrown out.
SQL
Structured query language: the words you use to ask a database a question, like “show me every late order.” SQL Server is Microsoft’s database.
Tailscale
A tool that builds a private, locked network (a VPN) between your own devices.
Takt time
The beat of a factory line: how often one finished thing has to come off the end to keep up with orders.
Ticketing system
A to-do list for help requests. Each problem gets a number, so nothing gets forgotten.
Ubiquiti and Cisco
Brands of network gear: the boxes that connect a building’s computers to each other and to the internet.
UPS WorldShip and FedEx Ship Manager
Shipping programs that print box labels and send out tracking numbers.
VBA
Visual Basic for Applications: a small programming language inside Excel and Access that makes them do boring jobs by themselves.
VLOOKUP and XLOOKUP
Excel tools that find something in one list and bring back the match, like looking up a price by part number.
VPN
Virtual private network: a private, locked tunnel over the internet, so only your own devices can get in.

Things I’ve built

Outside work, I build and run small websites and a computer server at home. All my sites follow one written list of 33 rules I learned the hard way. They cost $0 a month to run, and their colors are measured, not guessed, so the words are easy to read. Newer sites follow the rules from day one. Older ones get fixed as I touch them.

  1. 01 / Data reportsOpen the reports

    Animal Crossing Villager Data Reports

    All 391 villagers from Animal Crossing: New Horizons, from a public Kaggle dataset. I check the data first, then chart who’s most popular and why. You can try the same checks on your own spreadsheet.

    • Data checks
    • Charts
    • Kaggle data
  2. 02 / Home labRuns at home. Ask me about it

    Self-hosted AI agent

    An AI helper that runs on a server in my own home, not in someone else’s cloud. Only my own devices can reach it, through a private, locked connection (a VPN). It sends questions to an AI language model and brings back the answers. Next up: talking to it by voice and text message, with speech-to-text that works without the internet.

    • Proxmox
    • Ubuntu
    • Tailscale
    • LLM API
  3. 03 / Side projectVisit mixyz.xyz

    MixYZ

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

    • Cloudflare Pages
    • HTML, CSS and JavaScript
  4. 04 / My businessVisit wint.win

    Win Twin

    The site for my tech consulting business in Northeast PA: databases, reports, cloud services and security. Every message sent through its contact form is saved to a Google Sheet.

    • Cloudflare Pages and Workers
    • Google Apps Script
  5. 05 / Client siteVisit OliUni.com

    Oliver’s Universe

    A gallery for the nature photographer Oliver Norden: fifty photographs and a viewer I built for them. I moved the site from one web host (Firebase) to another (Cloudflare Pages).

    • Cloudflare Pages
    • Responsive video
  6. 06 / Client siteVisit SliceOfH.com

    Slice of Heaven

    A menu website for Slice of Heaven, a pizza place in Mocanaqua, PA. It’s built so hungry people find the menu fast.

    • Menu design
    • Local business
    • Fast loading
  7. 07 / Client siteVisit SpiritImageBand.com

    Spirit Image Band

    A website for the band Spirit Image, built to connect with fans and show off their sound.

    • Music
    • Audio
    • Event ready
  8. 08 / Client siteVisit NewportTownship.com

    Newport Township

    A website for the Newport Township Community Organization in Luzerne County, PA. It posts newsletters, obituaries and community news, on free hosting from DreamHost.

    • WordPress
    • Non-profit
    • Community hub
  9. 09 / My businessVisit john.cyou

    John Cyou

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

    • Netlify
  10. 10 / You are hereSee how I built it

    This site

    Written by hand in HTML, CSS and JavaScript, the three building blocks of every web page. No page builder. The section below tells how it was made.

    • Cloudflare Pages and Workers
    • Google Apps Script

Frequently asked questions

Straight answers on background, systems experience, and availability.

Who is John Goliash?

John Goliash is a dedicated, hard-working data analyst and operations specialist in Northeast Pennsylvania, currently seeking his next career opportunity in the workplace. With over 10 years of hands-on experience across manufacturing plants, warehouse distribution, and corporate IT environments, John specializes in inventory reconciliation, ERP reporting, data auditing, and turning complex operational numbers into clear, trustworthy decisions that protect profitability.

What services and systems does Goliash specialize in?

John Goliash specializes in end-to-end data analysis, business systems management, and operations support, including:

  • Inventory Reconciliation & Accuracy: Tracing physical vs. system count variances, uncovering unposted shipments and missing receipts, and fixing root causes.
  • KPI Reporting & Executive Dashboards: Automated metrics for open orders, backorders, fill rates, on-time shipping, OEE, and inventory turnover.
  • Database Queries & Automated Delivery: SQL Server, Microsoft Access, Excel, and Crystal Reports, with scheduled automated email distribution via KnowledgeSync.
  • ERP & Plant Systems: Administration and reporting across Sage 100, JobBOSS, Infor SalesLogix, and custom manufacturing workflows.
  • Web Dashboards & Data Tools: Clean, bespoke browser tools (like the KPI Lab) and data analysis pipelines.
What ERP and inventory management platforms does Goliash support?

All of the above. In addition to deep daily experience with Sage 100, JobBOSS, Infor SalesLogix, and KnowledgeSync, John is a quick learner who can be rapidly trained on any company’s specific platform or proprietary process—including SAP, Oracle NetSuite, Microsoft Dynamics 365, Epicor, or homegrown database applications. The core fundamentals of relational data validation, inventory balancing, and reader-focused reporting apply universally.

Where is Goliash based?

John Goliash is based in Northeast Pennsylvania (NEPA), centrally situated for on-site or hybrid roles across the Berwick, Bloomsburg, Wilkes-Barre, and Scranton PA area. He is also fully equipped and available for remote opportunities nationwide.

How I built this site

I made this site with Claude Opus 5.5 and Gemini, pair-programming with AI to combine operations rigor with zero-framework web craftsmanship.

It costs $0 a month to run on Cloudflare Pages, loads in under 200 milliseconds, and features an interactive KPI lab and full privacy controls.

Read the technical breakdown in the blog →

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.