Brilliant
Inventions

Garrison Roberts

(518) 469-6496 ·garrison.roberts@gmail.com ·Long Beach, CA

Reliable architecture · Brilliant, intelligible business analysis · Full-stack authorship

Let's turn your six-month project into four - with no slop.

Do you work in an environment that’s become entangled by a multitude of apps all trying to interact with each other, and things are grinding to a halt? Are you in the medical industry and suspect, or know, that you’re out of HIPAA compliance?

To solve your business problems, many architects will do some business analysis, recommend a “textbook” pre-packaged box solution to you, and proceed to dismantle your existing platforms to install their new recommendation. This obviously carries risk of missing or misunderstanding existing business rules and features that you’ve developed over years, which every business has. Their end result leaves you stuck with longer & more expensive timelines, where your final state has less functionality than you started with. My expertise and advantage: an ability to quickly but thoroughly assess your environment with you, understand the detailed elements of your problem, and to improve or correct software that you already own. Across my career I’ve beaten teams on project duration & cost countless times, because stripping & replacing software is the lazy, unimaginative solution, and usually the far less efficient one.

Garrison Roberts
Scroll↓

Depth

Decades supporting finance, healthcare, and engineering.

I have decades of deep knowledge in data warehousing, ETL, Microsoft full-stack development, Azure & on-prem, networking and scripting, bringing it all to usefulness through experience with BI platforms like Tableau or Power BI accompanied by custom reporting. I have extensive experience in HIPAA-protected environments, and can bring your organization into compliance correctly if needed, while retaining database performance. I excel in bringing data from a wide variety of sources and locations into normalized formats for BI analysis.

Leverage

Not a robot army, but a one-man garrison.

Though I lead teams naturally, I find that Claude, Kimi & DeepSeek are capable assistants on subordinate tasks, so you gain the advantage of a full development team by hiring someone who knows how to guide AI coding correctly.

architect’s judgment + AI coding = a full development team

Talent

When language & mathematics meet form & artistry.

Fluent in French; gifted composer; when we work together you get the most creative, original, most ideal solutions. Whether you know it or not, you want creativity supported by form and mathematics, not just the CS major who regurgitates the latter.

French · composer
Career highlights 01 / 05

United Healthcare / VisionWorks

UnitedHealthcare

billing run, after the fix

Davis & Goliath

Insurance provider Davis Vision (VisionWorks) experienced crippling performance and data storage issues in their benefit delivery platform. I was contracted to analyze, and Accenture was simultaneously contracted to offer opinions on the same. After two months, Accenture provided work estimates of 3,200 hours to replace the billing platform with a full rewrite. Before they were even able to make their sales pitch to executives, I had already resolved the problems by correcting the existing architecture. Billing runs dropped from 18 hours to 36 minutes, and Davis canceled Accenture’s contract, saving the company over $3.5M on the billing platform alone. Afterward, much more was saved correcting the more complex benefits & enrollment platforms.

Mechanical Dynamics & Analysis

Mitsubishi Heavy Industries

SAP to Epicor, one division

No SAP for you!

Mechanical Dynamics & Analysis, owned by Mitsubishi Japan, uses Epicor ERP for financials and shop process. They acquired a new division that used SAP, which Mitsubishi also does. Mitsubishi mandated that MD&A's existing 8 divisions convert to SAP with a 2-year $10M project cost, using this new outlier as the impetus for MD&A to become homogenous with Mitsubishi. The new division was given a 4-month deadline to integrate into MD&A, and Mitsubishi declared it "impossible" to convert them from SAP to Epicor on that schedule.
I was the technical lead on MD&A's attempt to do the impossible... which we did. The new division was converted & conformed with the rest of MD&A, forcing Mitsubishi to abandon their mandate. Beyond the project cost and labor hours of a company-wide SAP conversion, we saved the much higher annual licensing cost of SAP software and 6 additional developers required to support SAP going forward.

Microsoft · Marketing Division

Microsoft

survey data, in native character sets

Global ETL, multinational reporting

Lead designer and developer for Microsoft Marketing Division’s “Customer Satisfaction Portal”, a complex ETL that received customer survey responses from Microsoft accounts across the planet, accompanied by an array of web tools that reported in native language & character sets to Steve Ballmer’s executive team for actionable analysis. Drilling from high-level aggregate graphics into the specific native-language survey responses was done on-demand. The sheer amount of data couldn't live in a web browser, so I invented event-driven browser-to-server query tools in the years before AJAX existed.

Goldman Sachs, AYCO

Goldman Sachs

first class performance and security

Wall Street standards

While developing advanced financial modeling with Goldman and AYCO, and working in one of the most OLTP-intense environments on earth, I was trained by Symantec on attack surfaces and defenses. Today, AI automation out-guns any human attempt to take advantage of vulnerabilities, but my understanding of the attack mechanisms position me to properly direct AI to analyze and defend. This type of thinking has become an essential part of software architecture in every industry.

6N Systems

Centers for Medicare & Medicaid Services

the premier Medicaid MDS vendor

A premier Medicare MDS vendor

Architect and developer of 6N System’s MDS/EMR for Medicare-based nursing homes. Of dozens of MDS vendors, my software was one of only three that met the CMS vendor deadlines. 6N was publicly recognized as a premier Medicare MDS vendor, and chaired the IT panel of the National Association for the Support of Long Term Care.

Encore Vet Group · Advanced Medaesthetic Partners

From startups to industry leaders

Bespoke Data Warehousing

Using career-long lessons in database architecture and ETL techniques, I built ground-up boutique warehouses for both Encore Vet Group and Advanced Medaesthetic Partners. Both firms are consolidators of retail locations in their fields, and strive to avoid disruption of acquired locations to a minimum, particularly by not forcing them to change their POS and medical systems. As such, data was collected from a variety of vendor platforms and standardized to a single homogenous source of truth. My reputation for remarkably fast construction & delivery of such platforms, having accurate results and useful cross-org reporting, caused these companies to seek me out. The warehouse designs I implemented were highly performant on very low-cost Azure hardware. I avoided many potential pitfalls during the design phase, based not only on my past experience but also on the unique ideas that I envisioned when improving past customers’ legacy platforms.

Let's Go

Ready to improve everything about the software around you?

Work experience, professional certifications, education and references are in the PDF, or write to me directly.