PortfolioMODUS Oracle

Project indexInternal proposal tool

MODUS Oracle project register, search filters and project matches
The project register and filters. The count describes the register in this screenshot.

MODUS Oracle

A full set of team résumés, already laid out in the MODUS proposal format.

When an architect needs our team’s résumés on short notice, I select the people and their relevant projects in Oracle. The tool I built generates editable InDesign files in the layout I designed for MODUS. I can make the final edits and send the architect a finished set.

See the team résumé export
My role
Proposal workflow design and AI-assisted development
Scope
Project and staff database · Editable InDesign team résumés (.idml)

Why I built it in-house

Our old project database, MODUS PAL, could take hours to run a full export. I remember sitting at my desk thinking, “I know I don’t know how to do this yet, but maybe I could learn by going step by step through the process.”

I wanted to give MODUS this capability without spending thousands of dollars on a commercial platform like OpenAsset. I built Oracle with AI, revision by revision, connecting our project records, staff profiles and proposal workflow in one tool, with the option to keep the database local.

Narrow the register without losing the results

The register shown here contains 7,932 matching records before secondary filters are applied. Search accepts project and client terms. The adjacent controls let the writer narrow by architect, employee, role, category, office, state and completion date.

The result carries more than a name. A writer can inspect a project, check its location and team mapping, then change a filter without leaving the list. That makes it possible to distinguish a similar building from experience the proposed team can genuinely claim.

Oracle’s register with 7,932 matches, a filter panel and project records.
Project register with search, secondary filters and a page of matching records.

From staff records to an editable InDesign package

For each person on the proposed team, I choose the experience that fits the architect’s brief and add that résumé to the team packet. Oracle exports the assembled résumés as InDesign Markup Language (.idml) files. Each résumé opens in Adobe InDesign with our typography and page layout in place.

I still have the copy controls when all I need is a list of project names. When the architect needs the full team, I can edit the pages in InDesign and send them over on short notice.

I use Oracle regularly. On a recent city hall renovation proposal, it saved me two hours just assembling the team’s résumés.

Oracle’s proposal formatter with résumé profiles, project matches, copy controls and an InDesign export.
The proposal formatter lets me pair a résumé with selected project experience, add it to the team packet and export the packet to InDesign.

Keep the relationship decision with the team

Software can find that someone worked on a particular assignment. A colleague can tell you whether that person handled the phase the client is asking about. Oracle gives them a better place to start that conversation. The pursuit team still checks the scope, confirms the team and decides what belongs in the response.

Search portfolio