Uncategorized

Business Analysis & Scaling

I’m thinking about business analysis and scaling businesses for a meeting.

On the one hand, you don’t want to build The Titanic for a little weekend fishing trip. On the other hand, you don’t want to go out in a row boat only to learn the sea is too rough; you’d end up in deep water…

It’s rare for businesses to over commit resources but it can happen. The most common over commitment is the little website or tech startup that wants robust servers to handle 100,000,000 unique visitors every day. Let’s be honest, at the start you simply will not have that much traffic and you’re spending too much time and money on a problem that doesn’t exist yet.

For established businesses, especially consumer products & services, it’s more common to go out in a row boat and drown (or come close).

Think of a retail store that hires temporary staff every holiday season. Those temporary workers come at a higher price than regular staff. It might cost time to train them, they might make more errors that cost money, or you may have to pay them extra since a temporarily worker doesn’t have a sustainable income. Imagine instead if that retailer could add online sales so the increased holiday load is smaller since increased fulfillment/shipping is easier to account for than increased foot traffic. Or, imagine the small retailer ran off-season sales to even out annual demand. Or, imagine that small retailer implements self serve options, self-checkout, and other automated tools.

All of those options allow the business to scale flexibly without costs scaling disproportionately to income. I.E. the last thing you want is a 110% increase in costs for every 100% increas in income. After 900% growth the business will end up losing money.

Here’s the thing, it’s really easy to see the fish biting and go out in a small row boat. The knee jerk reaction to respond immediately to good news, like increased income, prevents human nature from pausing and thinking about the best, most-sustainable solutions.

I’ve recently determined I’m in a great intersection of business and technology/automation. I’m able to ask “what’s the problem”, “what’s the root cause”, “what’s the current solution”, and “can tech do better”. If you find yourself saying “that’s the way we’ve always done it” or “that’s how our competitors do it” some introspection might be valuable.

I love helping people and I love solving problems. If you think you have a scalability challenge I’m happy to bounce ideas around.

Senior Underwriting Analyst – Cansure Insurance

Feb 2016 to Jul 2018

  • A newly created role designed to streamline audit & compliance processes and build management information systems.
  • Built a standardized audit template resulting in faster audit responses and less need for discussion around audit response.
  • Audit response time decreased from 18+ months to 2 months.
  • Received praise from Lloyd’s markets and audit staff on the efficiency of the system, usability, and comprehensiveness.
  • Built, operated, and maintained a data lake on 2 distributed servers within the office network.
  • The data lake was able to import 1,800,000+ rows from 4,200+ Excel spreadsheets in less than 24 hours.
  • Brought the data from ~24,000 claims in ~2,000 spreadsheets into the data lake and built a tool for searching claims. Underwriters used this tool for renewals rather than discussing each renewal and each claim with the claims staff.
  • Built reports combining all spreadsheets of underwriting and claims data. These reports were used in Lloyd’s contract negotiations to show immediate impact of management decisions.
  • Built an online insurance quote tool in 2 months that worked within Lloyds’ requirements for human review of policies prior to binding. The tool was so efficient and easy to use it was preferred by internal underwriting staff as well.
  • Built an web app for policy renewals in 4 months that was integrated in an associations website for the members’ use. Within specified criteria association members could fill out renewal details, obtain a quote, issue a policy, and pay by credit card.

Co-Founder – Lakebed.io

Jan 2018 to Present

I built a data lake for Cansure. At the same time I was volunteering for the City of New Westminster on their Open Data. The City of New West expressed frustration about the number of disparate data sources (taxes, business licenses, dog licenses, building permits, etc, etc, etc). They also expressed frustration that it takes a day or more to “anonymize” data before making it openly available. The Open Data files are then hosted as flat, text files on their website server.

The challenges New West staff expressed sounded awfully similar to the challenges Cansure expressed, and before that Optimum Insurance. I believe all businesses need to pull together disparate data, make it easily accessible, query via APIs, and manage permissions/security.

So, I built Lakebed!

Senior Software Engineer – ITS Consulting

Aug 2020 to Present

  • Reviewed client legacy code and developed an agile project plan/estimate for upgrade, bug fixes, documentation, and maintenance. Successfully continue delivering on that upgrade plan.
  • The legacy application is so old/out-dated it still uses HTML tables and jQuery AJAX calls. The plan is to slowly upgrade the entire app to modern API’s, microservices, and React front-end component.
  • Senior front-end (React/Bootstrap) and back-end (PHP, SQL, Bash) developer.
  • Built an AR app for a startup R&D project.
  • Built an AWS S3 file storage integration with WordPress for a religious organization.
  • Built an internal dashboard for managing information security event notifications.

On-Prem Social Networking

This’ll be my [central] place to collect details, data, and thoughts on self-hosted social networking.

There has been some recent, concerning changes to Twitters ownership and mass-social-media is getting worse. This spurs, yet another, conversation about a secluded network for private use in our community.

Options:

  • https://www.capterra.ca/alternatives/148853/open-source-social-network
  • https://itsfoss.com/mainstream-social-media-alternaives/
  • https://blog.containerize.com/2022/01/12/top-5-open-source-social-networking-software-in-2022/
  • https://opensource.com/article/19/9/open-source-social-networks
  • https://medevel.com/open-source-solutions-to-build-your-own-social-network/
  • https://medium.com/geekculture/how-to-setup-an-xmpp-server-for-private-messaging-dcb1f4740fe
  • https://www.discourse.org/
  • https://itsfoss.com/open-source-forum-software/
  • WordPress
    • The reality is, WordPress already does comments, likes, posts, accounts, picture/video sharing.
    • It does a lot and it wouldn’t be hard to implement limits like short post limits.

What are the functions/uses of a social network?

  • Organize events, get togethers, etc.
  • Post a short status.
  • Share an update.
  • Post longer thoughts/opinions.
  • Direct messaging and group messaging.
  • Sharing photos/videos/links.
  • BUying/selling/sharing.
  • Liking, thumbs up, etc.
  • Comments (single/multiple threads).
  • Hare/collaborate on projects/work.

Important features:

  • Login/account with existing Facebook, Twitter credentials. This empowers third-degree connections to join and engage with people already on the platform.
  • Or, allow anonymous, public interactions for non-community members.

Human Evolution & Notifications

I was talking to a friend the other day and said “I’ve long held the belief that the increasing anxiety/stress/ADD is a result of human evolution/timeline”.

Let’s for a second think of an alert or notification as “something that needs our attention”. In the early days those things were lions roaring, lighting, etc. In modern times that’s email “bings” and car horns.

According to this Stack Exchange Discussion and Wikipedia it takes 50-100,000 years for a predominant trait to evolve in/out of a species.

I’ve drawn up an anecdotal, totally-not-science-based chart of how many “notifications” a human likely heard. In this chart it is average notifications over a 10 day period (.1 means 1 notification every 10 days, 1 means 1 notification per day for 10 days):

https://dl3.pushbulletusercontent.com/qAOgGHTWt8gu09QsvFnfeyjpl3SpbQgv/image.png

Putting that in context and combining our understanding of evolution with the approximate notifications we receive; we are evolved to hear approximately 1 notification per day but I estimate we hear 50.

If we assume the human body/mind is evolved to treat notifications and sudden noises as danger/threat/action-required, we are stimulated 50x per day while we are expecting 1x per day.

I believe our brains are simply not accustomed to that constant state of alert/stress.

 

Sources Used:

https://www.researchgate.net/publication/324578667/figure/fig1/AS:616574960541696@1524014334749/A-timeline-of-human-development-within-the-concept-that-this-is-very-approximate-and.png

https://static.skepticalscience.com/graphics/Timeline_TempVCivilization_1024w.jpg

 

Revenge

This is great advice/insight:

No alternative text description for this image

Great advice that I really [REALLY] want to follow.

I work extremely hard every day, post-crash, post-brain-injury, to not become like the imbecile insurance lawyers who accused me of lying, insurance doctors who conveniently asked & documented only what they wanted, and the unaware drivers who put us all at risk every day.

Sadly, I have less control of my brain since the crash and more-often-than-not I fail to move on.

Maybe if I write it down it’ll come to pass.