AIT USA Institute · Embedded technology partnership

From scattered data and missed leads to one CRM the team uses every day.

Sanitized AIT CRM pipeline organized by lead stage — **The result in use**Sanitized CRM view · Personal details removed

AIT is a 20-plus-year community institution serving immigrants, students, and local businesses through education and a family of service companies. DENEGRI works directly with ownership and staff as its long-term technology partner.

Client: AIT USA Institute
Relationship: Long-term collaboration
Role: Embedded technology partner

Reported operational impact

1–2 hourssaved per employee, per day

The starting point

The business had demand, history, and a committed team. Its systems could not keep up.

The original request was a data problem and a lead problem. A closer look showed that critical work was spread across spreadsheets, website platforms, ad accounts, inboxes, and personal phones—with no dependable connection between a customer inquiry and the team’s follow-through.

01Tens of thousands of rows spread across bulky, inconsistent Google Sheets
02Years of Wix inquiries without dependable follow-up, disconnected from daily work
03Limited visibility into follow-up, employee activity, classes, and attendance
04Outdated websites, personal phone lines, and fragmented business communications

How it changed

The advice, build, training, and follow-through stayed with one accountable partner.

The CRM was shaped with the people who know the business: make the hard product decisions, build around the way the team works, train everyone who uses it, and keep refining what ships.

Before

Scattered inputs

Dirty sheets · unread forms · missed leads · limited accountability

What DENEGRI built

One tailored CRM

PostgreSQL · automation · tasks · notifications · training · QA

After

A system the team uses

Live data · accountable follow-up · daily adoption · management visibility

What changed

Technology built around the business—not the other way around.

Multiple locations, business units, staff responsibilities, and customer paths had to remain clear inside one shared system.

CRM & team workflows

A purpose-built system shaped around multiple locations, business units, staff roles, and the daily realities of the team.

Data foundation

Wix history and spreadsheet records were consolidated and cleaned, with a flexible PostgreSQL data model shaped around the team’s needs.

Lead accountability

Website forms and campaign leads now enter the CRM automatically, with tasks, notifications, pipeline views, and follow-up oversight.

Management visibility

Role-aware views give administrators and senior coordinators a clearer picture of activity, classes, attendance, and open work.

Communications infrastructure

Business phone workflows were modernized so staff could use accountable company channels instead of personal devices.

Digital presence & support

AIT USA Institute and AIT Signs received website improvements alongside account recovery, campaign support, training, QA, and ongoing technical leadership.

Operational impact

Less clerical drag. Fewer blind spots. A system the team actually uses.

The strongest immediate result is time returned to the staff. Additional measures—including response speed, recovered opportunities, follow-up completion, and conversion influence—are now measurable inside the CRM.

1–2 hours

reported time saved per employee, per day

One system

for day-to-day CRM work across the employee team

Automatic

lead ingestion from active digital sources

Live visibility

into tasks, pipelines, classes, attendance, and activity

Evidence standard

Every published interface example uses sanitized or aggregate-only evidence so confidential CRM and customer data remain protected.

Operational proof

What the team uses each day.

These CRM views show how lead movement, follow-up, staff workload, and class attendance connect in one place. Personal information has been redacted for publication.

Sanitized AIT CRM Team Monitor with aggregate workload metrics — 02
**Team Monitor**
Management can see workload, overdue work, ownership, and missing follow-up without relying on presence signals.

Sanitized AIT CRM task queue with due and overdue work — 03
**Task accountability**
Due work, unassigned follow-ups, owners, and outcomes are surfaced in one shared queue.

Sanitized AIT CRM active class and attendance workspace — 04
**Classes and attendance**
Sessions, rosters, attendance, and class notes now live alongside the broader customer history.

Sanitized AIT CRM contact database with lifecycle and source fields — 05
**Structured contact history**
Clean records preserve lifecycle state, source, ownership, location, and last-edit history at scale.

Why the partnership works

Close enough to understand the team. Technical enough to build what it needs.

AIT does not receive a detached recommendation and a handoff. Ownership and staff work with one accountable person who can understand the problem, explain the tradeoffs honestly, implement the solution, train the team, and stay present as the next need appears.

That continuity turns a collection of vendors and tools into technology the business can rely on.

Explore multi-location systems integration

Owner perspective

“Alvaro is one of the very few people I trust when it comes to our business and technology. He doesn’t just tell us what to do—he sits with the team, listens, finds the real problem, and makes the solution work. When something needs to get done, he is there. He brings ideas we would not have seen on our own, tells me the truth, and keeps pushing until the system works for everyone. For AIT, he has become the person we rely on for anything technical.”

Frank Bardales Founder & Owner · AIT

Start with the problem

Where is disconnected technology slowing your team down?

Bring the spreadsheets, missed handoffs, outdated systems, or growth plans. The first conversation is about understanding the problem and choosing a practical place to begin.

Talk through the problem