Design, modernize, and support Microsoft Access and SQL Server applications across financial, legal, healthcare, and nonprofit organizations. Lead full life‑cycle development from requirements to deployment, specializing in converting fragile legacy Microsoft Access systems into stable, secure, multi‑user enterprise applications.

Key Work & Responsibilities

• Architect and build Microsoft Access / SQL Server systems supporting financial modeling, compliance, operations, analytics, and workflow automation.

• Modernize legacy Microsoft Access databases with SQL Server backends, redesigned schemas, VBA automation, and performance‑optimized architectures.

• Lead requirements gathering, data modeling, documentation, testing, deployment, and long‑term production support.

• Build automation solutions across Access/Excel/Outlook/Word including PDF generators, ETL routines, reporting engines, and integration workflows.

• Troubleshoot and refactor failing systems, improving stability, speed, and maintainability.

Architect and developer of mission‑critical Microsoft Access / SQL Server applications supporting provider compensation modeling, financial benchmarking, and productivity analysis. Long‑term partner on application enhancements, workflow automation, and performance tuning.

Key Applications

• PCPBS (Provider Compensation, Productivity, and Benefits Survey) – Enterprise Microsoft Access application used for productivity benchmarking, compensation modeling, and multi‑specialty analytics.

• RVU Calculator – Calculation engine enabling consultants to compute RVUs, compensation scenarios, and productivity metrics without reliance on spreadsheets or external teams.

Key Achievements

• Engineered SQL‑driven logic, optimized complex queries, and automated reporting workflows.

• Built user‑friendly interfaces with validation, error‑handling, and governance controls.

• Delivered continuous enhancements supporting consultant deliverables over a 20‑year engagement.

Architect and developer of enterprise‑grade Microsoft Access / SQL Server applications supporting compliance, risk management, and financial operations. Delivered high‑performance database solutions for mission‑critical corporate workflows.

Key Applications Delivered

• AML — Anti‑Money Laundering system supporting compliance analytics and investigation workflows.

• CAMP — Compliance and operational monitoring platform with automated reporting pipelines.

• FIRM and FIRM 2 — Financial and risk‑management applications used across multiple business units.

Key Achievements

• Designed SQL Server architectures (tables, indexes, stored procedures, validation rules).

• Built multi‑user Microsoft Access applications with automation frameworks, audit trails, and exception handling.

• Developed reporting engines, PDF generators, and ETL workflows.

• Led requirements gathering, documentation, deployment, training, and long‑term support across a 10‑year engagement.

Designed and built three major Microsoft Access / SQL Server applications supporting financial, operational, and legal workflows. Provided long‑term modernization, troubleshooting, performance optimization, and automation across the organization.

Key Applications Delivered

• EBN — A high‑volume bankruptcy image‑processing system that lets multiple users safely review, validate, and convert daily TIFF images into structured notice records through a controlled, SQL‑backed workflow.

• iSCL — An enterprise‑grade litigation management system that unifies case processing, search, document automation, billing, and data integration across Ophrys’ entire State Court Litigation workflow.

• PoC Cop — An automated workflow system that generates, validates, files, and tracks bankruptcy Proof‑of‑Claim and Transfer‑of‑Claim documents while seamlessly updating Time Matters and managing all related court‑specific requirements.

Core Work

• Built optimized SQL Server schemas, stored procedures, indexing strategies, and data‑integrity rules.

• Developed advanced Microsoft Access front‑ends with workflow automation, document processing, and validation logic.

• Integrated applications with Time Matters, Excel automation, and organizational data sources.

Sole developer of iLSTS, a multi‑user Microsoft Access/SQL Server application supporting loan‑servicing workflows and operational data processing.

Key Work

• Designed SQL Server schemas, stored procedures, and validation logic.

• Built Microsoft Access front‑end interfaces with advanced VBA automation and reporting.

• Delivered full life‑cycle development including requirements, testing, documentation, and production support.