Case studies.

Analyses of projects with which I've been involved.

Business intelligence tracking web app

Type of work
full-stack development, some UX design
Summary
Northcraft wanted to create an internal app they could use to track and trace business intelligence data and queries used for clients of their SingularIT product.
Results
Working part-time over the span of a few months, I developed the first version of a full-stack web app using their preferred Microsoft technologies: SQL Server, Entity Framework Core, C#, MVC. I collaborated with the CEO and the director of development to use and refine an initial data model they designed in the past. We battle-tested the app with data extracted from clients, and used this to further refine the experience and presentation, such as by adding searching and filtering where appropriate. The CEO began using it to further track and trace client data, and used it in demonstrations with potential clients to show how the company was keeping the integrity of client data. The success of these demos led to the CEO considering offering the app as an additional product for clients.
Tools
full-stack development, C#, .NET Core, ASP.NET Core, MVC, Razor Pages, Entity Framework Core, MS SQL Server, SQL, Linq, Bootstrap, HTML, CSS, JavaScript, APIs, REST, distributed version control, git, gitea server
Notes
NotesThis was my first development-focused project since becoming a UX designer 20+ years ago. I truly enjoyed building the application from the ground up, and focused initially on familiarizing myself with the various technology used. While getting basic forms in place for data entry and management, I collaborated closely with the client to better understand the domain and redesign some flows and forms to be more user-friendly and efficient. Over the course of developing the app, I deepened my experience with various facets of the development lifecycle, ensuring data and code integrity.

Transactional email redesign

Company
AT&T
Type of work
UX design, light development
Summary
Present a unified brand experience across all transactional communications with customers.
Results
I designed a single, flexible, more visually appealing transactional email template based on the company's online design system + an applied voice styleguide for content—replacing myriad outdated email templates, each with their own style, presentation, and voice exposing internal silos. Room was explored for future use with marketing emails.
Tools
Sketch, InVision, HTML/CSS/React

Read the case study

Modernizing a neglected experience

Company
AT&T
Type of work
UX design
Summary
A necessary but long-outdated customer experience needed some love: bring it into the company's online design system and provide quick-hit improvements to the experience where possible.
Results
Along with bringing the experience up to design system standards and consistent with the rest of the site, I made various quick-win design improvements for customers and clarified the overall process, while redocumenting lost knowledge from past efforts.
Tools
Sketch, InVision

Note: Full case study coming soon.

My github repos

Coding samples—mostly data science and R programming projects for Coursera data science courses.

https://github.com/jparnzen