Loren Saunders
Business Systems Architect, Developer & ERP Consultant
Professional Summary
Solutions architect, database architect, developer, and ERP consultant with 20+ years of experience automating business systems for architecture and civil engineering (A/E) firms.
Working in Deltek Vision/Vantagepoint since 2003.
All work done remotely, on-site as needed.
Core Expertise
- Current Platforms: Deltek Vantagepoint and Deltek Vision
- Strategy: fractional CTO/CIO, business process audits, operations strategy, applications infrastructure strategy, mission critical business path analysis
- Implementation: fitment analysis, configuration, data conversion and migration, historical data cleanup, Vision-to-Vantagepoint migrations, vendor accountability, legacy ERP to Vision/Vantagepoint migration, implementation rescue and re-implementation
- Customization: user components or modules (infocenters/hubs), wizards, workflows, reports, invoice formats
- Integration & automation: application integration, data validation, ETL
- Technical: SQL Server, T-SQL, SSRS, SSIS, database and data warehouse architecture, C#, .NET object-oriented development, API and web service integration
- Business analysis: requirements, process re-engineering, project work breakdown structure design, general ledger cleanup and design, training, documentation
Select Projects
RMF Engineers (Baltimore, MD · ~350 employees)
2017 – Present
Platform: Deltek Vantagepoint
- Implemented Purchasing module for subconsultant cost control.
Generated purchase order history from existing transaction data (1,200 POs) ensuring data is contiguous from day one. - Designed and implemented purchase order origination and daily processing workflow for subconsultant cost control.
- Built custom workflows to enforce business rules and automate data entry, including automatic PO numbering and PO voucher summary data.
- Provided comprehensive subconsultant cost report including a PM view of each project's POs, vouchers and paid/unpaid status.
- Developed custom project management module for top line metrics, estimates and project status.
- Continue to deliver custom reports, workflows, custom hubs as needed.
Ghirardelli Associates (GAI) (Pleasanton, CA · ~150 employees)
2021 – Present
Platform: Deltek Vantagepoint
- Corrected prevailing wage automation solution abandoned by Deltek partner, including Certified Payroll Report and paystub report extensions.
- Rescued Vantagepoint Purchasing implementation abandoned by Deltek partner to manage subconsultant budgets, contracts and commitments on large, multi-year projects.
- Generated purchase order history from existing transaction data: 500+ POs with transaction data running continuously back to the original Vantagepoint go-live.
- Built custom components to bypass cumbersome UI and provide single point of entry for contracts.
- Developed purchasing workflows based on database triggers and stored procedures since workflow engine not available in purchasing module.
- Built consolidated reporting solution providing top down visibility from project, PO, sub consultant all the way through vendor invoices and payment details.
I & S Group (ISG) (Mankato, MN · ~300 employees · 20 offices in nine states)
2019 – 2024
Platform: Unanet A/E
- Rescued at-risk implementation and migration from Peachtree to Unanet A/E and reached go-live within 90 days.
- Re-architected and rebuilt invoicing and contract management framework inside Unanet A/E to overcome limitations of product native design.
- Built workflows and project setup wizards to replace cumbersome UI elements.
- Delivered timesheet review and approval solution to replace subpar out-of-the-box process.
Civil Engineering Consultants (CEC) (San Antonio, TX · ~200 employees · now part of KCI Technologies)
2019
Platform: Deltek Vision, Unanet A/E
- Migrated entire enterprise from Deltek Vision to Unanet A/E.
- Found and corrected flawed historical accounting transaction data in Deltek Vision before migration.
- Rewrote chart of accounts and project structure to correct flawed legacy implementation.
- Delivered custom solutions and reports as needed.
Valicooper & Associates (Emeryville, CA · ~300 employees)
2018
Platform: Deltek Vision
Designed, built, and implemented lights out solution for prevailing wage labor cost tracking and project assignment. Cut timesheet errors from 50% to 10% and reduced admin hours for labor processing and payroll by 80%. Solution included integration with self-service benefit selection SaaS platform through SSIS ETL.
Ronald Lu and Partners (Hong Kong · ~300 employees)
2010
Platform: Deltek Vision
Took accounting department from 10% to 80% automation in six months; restructured project work breakdown structure (WBS) across current and legacy transactional data.
Andrews Engineering (Springfield, MO · ~150 employees)
2008
Platform: Deltek Vision
Redesigned project structure, chart of accounts, timekeeping and accounting methods, moving firm to a new configuration with business continuity and historical data intact.
MNS Engineers (Santa Barbara, CA · ~130 employees)
2008 – 2009
Platform: Deltek Vision
Rescued at-risk Deltek FMS-to-Vision conversion - legacy data scrub, GL account remap, re-architecture, implementation and user training.
FMV Opinions (Irvine, CA · ~75 employees)
2006 – 2008
Platform: Deltek Vision
Evaluated 40 ERP platforms, then led a two-year phased Deltek Vision implementation replacing every mission-critical business application with Deltek Vision. Included custom InfoCenters, reports, workflows and data migrations.
Technical tools, programming languages:
MS SQL Server, SSRS, SSMS, Visual Studio, C#, Javascript
Claude Cowork (desktop)
Earlier Career
Database Architect, Senior Developer & Business Systems Analyst
1996 – 2003
Business systems architecture, database design, ETL and application development, data warehousing, full stack development.
House of Blues (Hollywood, CA), architected customer data warehouse for data mining, integrated Ticketmaster data feeds and automated in-house sales groups.
Education
- University of California, Santa Barbara — B.A., Business Economics; B.A., French Linguistics
- Institut d'Études Politiques, Grenoble, France — year of study abroad
November, 2026