Software designer, founder, and technology consultant.

I am Lorenzo Dandrea, a technology consultant based in the Twin Cities, Minnesota. With over 15 years of experience in software development, project management, and product strategy, I specialize in delivering tailored digital solutions that drive efficiency and innovation. My expertise spans full-stack development, data analytics, and the integration of AI technologies to solve complex business challenges.

Internal Analytics Platform

Managed the creation of Executive dashboards that utilized the companies prorpietary data sets. The dashboarding technology was PowerBI and the database was a SQL database. Dynamic reporting was created for 3 different departments and one final report that was used to measure and monitor a proprietary metric and utilized by the executive team.
SQLPowerBI

API For Internal Use

Managed the development team and product team that over saw an internal API route that leveraged an event system. Wrote code directly against the API to help enrich and provide the appropriate information for dependent systems across the technical landscape.
LaravelPHPEloquent ORMSQL

Refactor of a 7 Year Old SQL Database

Managed an outside contractor and worked with the systems architect to rebuild a 7+ year old SQL database. Over 5000 lines of SQL written to consolidate down a 24 gigabyte database. Only 5% of the tables had foregin keys setup. After implementing those, we had a 300% increase in query speed alone.
SQLAWS

Converted Legacy Application from Vue.js to TypeScript

Took the product that I was managing and strategically aligned it to the rest of the tech stack. Consolidating down the frontend from Vue.js ot TypeScript, we were able to leverage more of the engineering team to work on user management system. This was executed in tandem with the database overhaul.
ReactInertiaLaravelSQLTypeScriptPHP

Multi-Million Dollar Event Management System

Consolidated an event management system into a companies proprietary application to allow highly related data to be more easily surfaced. The business model of this company only hosted private events, so the need to authenticate was critical to ensure only those who should be allowed to attend could register. Our payment processing was done through Stripe and we also created the ability to purchase using a proprietary currency.
Vue.jsLaravelSQLPHPStripe

Work

  1. Company
    Northern Widget
    Role
    Founder
    Date
  2. Company
    Nexstar Network
    Role
    Technical Product Manager
    Date
  3. Company
    SixSpeed
    Role
    Software Engineer
    Date
  4. Company
    HotDish
    Role
    Web Developer
    Date
  5. Company
    Imagine IT
    Role
    Account Executive
    Date
  6. Company
    Breakthru
    Role
    Account Executive
    Date
  7. Company
    Warners Stellian
    Role
    Account Executive
    Date
Download CV

Interested in working with me, please reach out to me via email

  • lgdandrea4@gmail.com