Jay DixitProcess automation & offline tooling

Six Sigma + automation · Greater Harrisburg, PA

Complex work, turned into a process anyone on your team can run.

Auditing. Reporting. Reconciling numbers from systems that disagree with each other. The jobs that work today because one tenured person knows where to look and what to ignore.

I rebuild those jobs as offline browser tools that surface the right number at the moment the decision gets made, and that state the reasoning behind every step. The result is a process with the variability taken out, and a new hire who learns the logic by doing the work instead of shadowing someone for a month.

Nothing I build sends your data to an online service

Live demo · daily invoice reconciliation

Change it. The rule is a rule, not a judgement call.

0Lines checked
0Need attention
0No action

    Illustrative data. Runs entirely in this page.

    Offline
    3 hrs → 10 minOne task, prior deployment
    0Online services used
    10+Years in the IT channel
    Black BeltSix Sigma

    Four rules every tool follows

    These are not preferences. They are what makes the difference between a tool that sticks and a spreadsheet that gets abandoned in a quarter.

    01 / Security

    It runs offline

    No cloud service, no login, no API key, no data leaving your network. The tool is a file that opens in a browser you already have.

    02 / Training

    The tool is the documentation

    Every step states the rule it applies and why. Someone new learns the reasoning while doing the work, not from a binder nobody opens.

    03 / Attention

    Data arrives in context

    The number you need appears where the decision happens. No hunting across four systems, no tab-switching, no holding figures in your head.

    04 / Method

    Variability goes first

    Six Sigma before automation. Measure the process, find where it varies, fix that. Automating a loose process just produces errors faster.

    What I help with

    Four areas. Each names the experience or credential it rests on, so you can judge for yourself rather than take my word for it.

    Process automation and internal tooling

    The demo above is a stripped-down version of this work. I take a task that needs judgement, cross-referencing and a good memory, and build a tool that applies the rules consistently and shows only what needs a human.

    Typical candidates: invoice and shipment reconciliation, audit preparation, reporting that pulls from several systems, data cleanup before it reaches a report, quoting and configuration checks.

    The tools are plain HTML and run offline in a browser. No platform to license, no seat count, no vendor to migrate away from later. You own the file.

    Basis: Prior deployments in the IT channel. Six Sigma Black Belt. Google Data Analytics Professional Certificate.

    Ramp time and cross-training

    Most onboarding problems are really process problems. If a job needs tribal knowledge, every new hire costs weeks of someone else's time and the error rate stays high until they absorb it.

    When the logic lives in the tool rather than in a person, training becomes showing someone a sequence. They build the judgement by using it, and the business stops being exposed when one person leaves.

    Basis: Six Sigma Black Belt. 10+ years managing and training staff in retail operations. Google Project Management Certificate.

    Process analysis and gap assessment

    Before automating anything, it is worth knowing what the process actually is. I map how work really moves, measure where it varies, and separate the steps that add something from the steps that are there because they always have been.

    That assessment also looks forward: which reports nobody can currently produce, which numbers the business is deciding without, and what would have to change to get them.

    Basis: Six Sigma Black Belt, Management and Strategy Institute. Google Data Analytics Professional Certificate.

    IT procurement and vendor navigation

    Reading quotes, comparing what is actually being proposed, and sizing infrastructure and collaboration tooling against what your business needs rather than what fits the vendor's quarter.

    I have spent over a decade on the vendor and channel side of these conversations, so I know how the pricing and the pitch are assembled before they reach you.

    Basis: 10+ years in sales, vendor management and operations management in the IT channel. Cisco security, collaboration and small-business exams. HPE hybrid cloud and portfolio certifications.

    Potential benefits

    What this approach is built to change. Which of these matter, and by how much, depends on your process and your data, so they are targets to measure rather than promises.

    Time

    Less time per cycle

    Rules applied at once instead of line by line, and only the exceptions put in front of a person.

    Accuracy

    Fewer errors

    The same checks run the same way every time, rather than depending on attention at the end of a long task.

    Ramp

    Shorter ramp time

    Training becomes a walkthrough of a sequence. The reasoning is in the tool, so a new starter builds judgement by using it.

    Risk

    No single point of failure

    When the method lives in the tool rather than one person's memory, holidays and departures stop being operational events.

    Security

    Data stays in-house

    No cloud service and no third party in the path, so there is nothing new to review with your insurer or your own customers.

    Insight

    Reporting you did not have

    Once the data is reconciled consistently, numbers the business was deciding without become available as a by-product.

    Focus

    Less context switching

    One screen instead of four systems and a spreadsheet, so the work stops costing attention it does not need to.

    Ownership

    No new dependency

    Plain files you keep. No licence, no seat count, no platform to migrate off later.

    8 weeksPrior deployment

    From a prior deployment: a daily task, three hours to under ten minutes

    A recurring reconciliation ran almost entirely by hand: data pulled from several systems, cleaned in spreadsheets, cross-referenced by eye. Working with the stakeholders involved, I mapped what the process was actually doing, then built offline HTML tools that brought the sources together, applied the cleanup rules consistently, and presented the exceptions with the reasoning attached.

    The daily task came down to under ten minutes, and training someone into it became a walkthrough rather than a transfer of accumulated context. Further detail is available on request.

    • Multi-source reconciliation
    • Rule-based cleanup
    • Exception-only output
    • Self-documenting steps
    • Runs offline

    Background

    Twenty-plus years of operating experience across two industries. What each certification actually contributes to an engagement, rather than a list of exams, is set out on the expertise page.

    10+ yearsIT channel

    Sales, vendor management and operations management in the IT channel

    Over a decade across those three functions, working with vendor programs including Cisco and HPE. This is where the procurement knowledge, the infrastructure knowledge and the process work all come from. Specifics are available on request.

    10+ yearsRetail

    Retail sales and management

    Over a decade in retail sales and management: staffing, floor operations, and training people into jobs where consistency matters more than speed.

    DegreeMillersville

    Bachelor's degree, Business Management

    Millersville University of Pennsylvania.

    Black BeltMSI

    Six Sigma Black Belt

    Issued by the Management and Strategy Institute, a CPD-accredited training provider and member of the International Association of Training Providers.

    How an engagement runs

    Four steps. Nothing starts until the scope and the fee are in writing.

    1. Discovery call

      A conversation about the task that keeps going wrong, or the person everything depends on. No charge, and no obligation on either side.

    2. Process map and written scope

      I document what the process currently does and where it varies, then propose deliverables, a timeline, a fee, who owns what is built, and what sits outside the scope.

    3. Deposit and build

      Work begins once the scope is signed and the deposit is received. Cancellation terms are in the refund policy.

    4. Handover and validation

      We run the tool against known cases together, so you can see the rules hold. You keep the files and the documentation, and your team runs it without me.

    Contact

    Email is the only way to reach me, and that is deliberate: this site runs no contact form, so nothing you send passes through a third party on the way to my inbox.

    jaydixit@dixitjay.com

    Useful things to include in a first message: what the business does, roughly how many people, and the task that prompted you to get in touch. If you can say roughly how long that task takes today, better still.

    Based in the Greater Harrisburg area of Pennsylvania. Virtual-first: engagements run remotely, which keeps the cost down and the scheduling simple. Clients across Harrisburg, Camp Hill, Mechanicsburg, Hershey, Carlisle, Lebanon, York and Lancaster, and remotely throughout the United States.