Trish Stoverink Ambrogio

Business Analyst · Automation & Systems Builder

I find the problem, then I build the fix.

I'm the only business analyst in a company of 700+, so I don't stop at the requirements doc.

I design the database, write the SQL, wire up the Salesforce and Power Automate flows, and ship working apps. Lately that includes full-stack products I build with AI-assisted coding. MBA, Webster University.

See the work Get in touch
toolkit.sql9 rows · 0.02s
SELECT skill, area, level
FROM   trish.toolkit
WHERE  level IN ('Expert', 'Proficient')
ORDER BY years_used DESC;
skillarealevel
Business analysisProcessExpert
Salesforce automationCRMExpert
Power AutomateAutomationExpert
SQLDataExpert
Database designDataExpert
Power BI / DAXReportingExpert
Power AppsAppsProficient
SOQLCRMProficient
AI-assisted codingAppsProficient

-- also: PowerShell, REST APIs, AWS, Redshift, Jira, Asana, HubSpot

What I do

Most teams hand off between the analyst, the admin, the data person and the developer. I cover all four, so a request goes from a hallway conversation to something people actually use.

01 · Understand

Business analysis

Requirements gathering, stakeholder interviews and process mapping. I find where work is done by hand, and what it costs.

  • Requirements
  • Process mapping
  • Jira roadmaps
  • Training docs

02 · Automate

Salesforce & Power Platform

Flows, triggers and integrations that remove repetitive work. API calls stitch the systems together where no connector exists.

  • Salesforce Flow
  • SOQL
  • Power Automate Cloud
  • Power Automate Desktop
  • Power Apps
  • PowerShell
  • REST APIs

03 · Build & measure

Data, apps & reporting

Relational schemas, SQL and dashboards that leadership trusts. I also build full applications using AI-assisted coding.

  • SQL
  • Postgres
  • Redshift
  • MongoDB
  • Power BI / DAX
  • Next.js
  • Supabase
  • AWS

Projects

Internal apps, automations and products I've planned, designed and built, from a one-month Power Apps deadline to a multi-tenant web platform.

Featured · Personal build · 2026

PS Homes

An operating system for short-term rental hosts. It puts bookings, cleanings, inventory, maintenance, payouts and branded guest pages in one place, replacing five spreadsheets and a group chat.

  • Designed the full relational data model in Postgres, with row-level security so each account only sees its own properties.
  • Four roles with their own views: owners, cohosts with per-person permissions, cleaners, and admins.
  • Syncs Airbnb and VRBO calendars over iCal, then drives cleaning schedules from the bookings.
  • Finance module splits payouts and bills by owner percentage, calculates cohost cuts and settles balances.
  • Password-protected guest guide per property: WiFi, check-in, appliance how-tos with photos and video.
  • Calendar
  • Cleanings
  • Inventory
  • Lawn care
  • Maintenance approvals
  • Purchases
  • Payouts & bills
  • Reports
  • Guest Connect
Visit pshomes.net
24database tables I designed
117row-level security policies
35schema migrations
170+commits since April 2026

Stack

Next.js · React · TypeScript · Supabase (Postgres, Auth, Storage) · Tailwind · Vercel. Built with AI-assisted coding.

Apps & platforms

Abstrakt Marketing Group
Power AppsBuilt in 1 month

A Player App

An internal performance app. Every role had different metrics; I needed one way to track them all daily.

  • Built the internal database behind every performance input.
  • Daily Wins: employees log metrics like "booked 3 meetings"; the app rolls them into a monthly score.
  • Audits: replaced inconsistent Excel audits with role-specific questions tied to contributor and client.
  • WFH: managers approve remote eligibility; contributors opt in and pick days, visible to their team and HR.

ResultMonthly scores now set remote-work eligibility automatically.

Product management2021–2022

SapperSuite

The company's primary internal application: company-wide data and the hub for every outside tool.

  • Managed a multinational development team and the Jira roadmap.
  • Client Overview: a client portal for managing meetings CRM-style, approving content and reviewing metrics.
  • Capacity: schedule onboardings, forecast employee capacity and track new-client revenue.
  • Content: write in SapperSuite, route to the client for approval, push straight to Outreach.
  • SQL
  • Redshift
  • Power BI
  • AWS Batch · S3 · CloudWatch
Power AppsStrategy team

Sapper Strategy App

Helps the strategy team spot common client performance problems without leaving their workflow.

  • Self Filter: deep-dive a client's targeting areas inside the app.
  • Asana tasks: one click creates a task with the right person tagged and client details filled in.
  • Each task posts to HubSpot as a note, so every team sees it.
  • Ran discovery, training and beta testing with the teams.
  • Power Apps
  • Asana API
  • HubSpot

Automation

Abstrakt Marketing Group
Power Automate · PowerShell3 hrs per client

Onboarding Automation

Client onboarding took about 3 hours of manual setup each. I automated it end to end.

  • API calls plus Power Automate Cloud handle DNS setup, DKIM enablement and name server assignment.
  • Power Automate Desktop drives PowerShell to create senders and domains in Office 365.

ResultSaves the company thousands of dollars every month.

Power Automate · PowerShellAPIs

Offboarding Automation

The companion to onboarding: the client offboarding process, automated so it no longer depends on someone doing it by hand.

  • Power Automate Desktop and Cloud orchestrate the steps.
  • PowerShell and platform APIs handle the teardown.

ResultAnother process saving thousands of dollars a month.

Migration1,500+ clients

Smartlead Transition

Helped lead the move from Outreach to Smartlead.

  • Migrated more than 1,500 clients and 10 million emails.
  • Automated adding senders to the new platform.
  • Built a daily feed of sending data into Power BI dashboards.
  • Researched the platform and trained the team on it.

Result10M+ emails moved, with daily sending data feeding Power BI.

Product & business

Maritz · Independent
Maritz Motivation2 years

AmazeCrate

A corporate subscription gift box for client and employee gifting. I joined at conception as associate product manager, working alongside a senior PM.

  • Worked across teams to build the formal process for flowing orders through the system.
  • Curated the products that went into each box.

RoleAssociate Product Manager, from concept to launch.

Own business~5 events / year

PS Occasions

A full-service event coordination business.

  • Initial consultation to learn the client's vision for the day.
  • Keep the plan on track and on budget, and connect clients with the right vendors.
  • Point person on the day, so everything runs smoothly.

RoleOwner and lead coordinator.

Experience

Product, operations and automation roles, most recently as the company's sole business analyst.

Abstrakt Marketing GroupFormerly Sapper Consulting
2021 – present

Business Analyst & Automation Expert

06/2023 – present
  • Sole business analyst for a company of 700+ people.
  • Build Salesforce and Power Automate automations, using APIs to replace tasks that used to be outsourced every day, saving thousands of dollars a month.
  • Designed automation that cut manual work and raised productivity by 50%.
  • Partner with cross-functional teams to analyze processes and roll out RPA solutions that streamline workflows and reduce errors.
  • Turn stakeholder reporting needs into Power BI dashboards, with advanced DAX measures for KPIs.

Manager of Strategic Operations

04/2022 – 06/2023
  • Led a team of 6 strategic operations analysts and client maintenance specialists through a process and strategy overhaul.
  • Built Power BI reports on SQL and Redshift to surface problems and improve client monitoring.

Product Manager

01/2021 – 04/2022
  • The company's go-to automation specialist across platforms.
  • Led a multinational, cross-functional development team on the primary internal application.
  • Monitored the app with Power BI on SQL and Redshift; troubleshot in AWS Batch, S3 and CloudWatch.
  • Owned the multi-tier Jira roadmap and wrote tutorials to roll out changes.

Maritz Motivation Solutions2015 – 2020

Associate Product Manager

08/2017 – 08/2020
  • Specialized in non-point rewards products, packaging each into an easy-to-execute format with forms and directions for project managers.
  • Supported product research, development and documentation: RFP reviews, product sheets and training.
  • Liaised between B2B clients and vendors; resolved vendor issues with warehouse, procurement and merchandising.

Assistant Buyer

08/2015 – 08/2017
  • Researched products and answered customer questions on BazaarVoice to drive sales.
  • Worked one-on-one with participants and vendors in the Personal Shopper Program.

Crider Health Center2014 – 2015

Care Coordinator

  • Provided targeted case management and community support to families through one-on-one sessions built around each child's treatment plan.

Education

Business training on top of a social science foundation: I study how people work before I change the systems they use.

Master of Business AdministrationWebster University, St. Louis, MO · 2016
BA, SociologyWebster University, St. Louis, MO · 2014

Contact

Have a process that should run itself? Let's talk.

pstoverink@gmail.com