Client work 2
A detailed Competitive Intelligence report based on custom heuristic criteria
I am proud of the above case study because it was an enormous undertaking. I was given a deliverable and a time limit and found a way to execute a complex report using spreadsheets and a scoring system that I came up.
However, when I was on this project, I was frustrated by the process and what was being asked. I saw a better way and the untapped potential that we could've been selling to the client.
If I were in charge of this project, I would have delivered a relational database with a front end that generates the charts and graphs needed by these executives. This would've been more scalable, accurate, repeatable, and flexible.
I spoke up at the time and went as far as to reach out on slack in hopes we had some SQL engineers on the team. I even researched the basics of data modeling in preparation for going down this path and created the gist of what I envisioned could work (see below).
I hope this story helps lend some context to my personality. I love processes, thinking of the big picture, and working smarter.
Data model that could've been used for a more scalable version of this project
name(char) e.g. adp, paychecks
name(char), e.g. desktop, mobile
name(char) e.g., advisor, participant
name(char) e.g., small, large
// Competitive Benchmarks
name(char) e.g. discoverablility, consistency
name(char) e.g. sitemap depth, navigation structure
name(char) e.g. wellness options, digital purchase