• Designed Amazon RDS (Postgres) database for medical reimbursement for expat veterans • Updated large legacy system to encrypt PII data with Microsoft SQL Server Always Encrypted • Designed & developed Power BI reports including data integration with Halo PSA.

• Designed & implemented a new SSIS process to push invoice data to Salesforce leveraging KingswaySoft integration components. • Composed new Weighted Lead Time measure in tabular SSAS cube, combining SQL and DAX logic. • Validated Azure data architecture tables against existing on-premise architecture as part of an Analytics re-platform project. • Developed new Operations Yield reports in Power BI Paginated Reports

• Developed an Azure Databricks notebook (Apache Spark) to import Google Analytics data into an Azure Synapse SQL Database• Created a Power BI report to duplicate the native Google Data Studio report, ensuring it can be secured within Convercent's application• Assessed the capabilities of Power BI Embedded in terms of report accessibility, high contrast mode, and screen readers

Team and Technical Lead for a multi-organization team of Analytics developers supporting all Emergency Departments and Urgent Care centers in the largest hospital system in Colorado• Re-engineered ETL process for a 75% improvement in runtimes• Designed daily reporting process in SSRS with database-driven recipient list and failsafe checks to ensure ETL is complete• Interfaced to multiple 3rd party scheduling systems with XML, Json and CSV formats (SSIS and Python)• Interfaced with Redcap research database system (Python)• Built import from Everbridge trauma reporting system (Python)• Enhanced & Maintained SSAS Multi-dimensional Analysis Services cube for self-service ED reporting• Designed interface of Epic surgery schedule data for commercial 3rd party software iQueue for Operating Rooms with LeanTaaS• Provided data for numerous research projects

Led a small team of developers at warehousing/fulfillment startup as it grew from few clients to over one hundred. Continuously adapted and grew our internal and external systems to meet the needs of a stream of new clients, including warehouse operations, customer service and accounting functions. • Custom implementation of a 3rd party multi-carrier shipping system for an estimated 50% productivity increase in shipping department throughput along with improved quality control, including development of a WMS integrated front-end.• Adapted single-client WMS system for multiple clients• Developed corporate Internet web portal & standard interface to send & receive orders & confirmations• Built XML interface for processing dropship orders from major ecommerce websites via CommerceHub• Interfaced with FedEx, UPS and Endicia USPS shipping terminals• Implemented multi-carrier shipping system for an estimated 50% productivity increase in shipping department along with improved quality control. Managed project including product research, presenting to Management, installation & configuration, interface development, process improvement, development and implementation.• Planned development of ASP.NET based corporate intranet system for order processing and support.• Implemented SQL Server Reporting Services for internal & external reporting. (Also Crystal Reports)• Developed company standard API for clients to send & receive orders & ship confirmations.

Developed backend systems at early dot-com grocery startup for inventory, billing, and customer service, with an emphasis on reliability, better performance and greater ease of use.

Built and supported the first electronic system for receipt and processing of Treasury Bond auctions, system for tracking inventories of physical bonds, and system for processing Savings Bond orders and redemptions.