Projects

• Untitled New Product Mar 2024 - Present
  Online dating industry

  Design and development of a new online dating product.

  Tech: C# Microservices in Azure, Postgres databases, Azure Table Storage, Azure AI services.
  
  

• Automated Payment Streams Oct 2021 - Jun 2023
  Commercial utility billing and payments industry

  Design and development of new automated payments system to replace a legacy system.

  • Record automated payments in multiple formats (ACH, Physical check, RPPS), in accounting system.
  • Consume bank transaction files in BAI format.
  • Clear payments in accounting system that have been cleared by the bank.
  • Develop new physical check template print cut paper checks out of the accounting system.
  • Develop databases to hold data to be recorded in accounting system.

  Tech: C# Microservices in Azure, Postgres databases, NetSuite SOAP/REST APIs, Apache Kafka transport, Protobuf transport protocol, some console apps to run on a schedule.
  
  

• Custom Utility Billing and Activations system Apr 2012 - Dec 2020
  Single family home leasing and management industry

  Design and development of enterprise software to manage utility activations and billing at leased single family homes.

  • Design utility activations process while working with Operations, and develop software to encompass the process.
  • Develop multiple web portals for client interaction and reporting.
  • Design and develop software for billing process to charge utility provider charges to residents at single family homes.
  • Design databases for the new systems.
  • Develop ETL (extract-transform-load) processes to load data received from multiple sources into client's system.
  • Develop reporting for the product.
  • Develop notification system to notify Operations users about upcoming utility activation appointments.
  • Seamless integration of new single family-specific product into client's existing enterprise software.

  Tech: SQL Server, ASP.Net Web Forms, Windows Forms desktop apps, C# on-premise APIs, various console apps that run on a schedule, SQL Server Reporting Services reports.
  
  
  
  

• Utility Expense Management (UEM) system May 2007 - Apr 2012
  Multi-family housing utility billing industry

  Design and development of enterprise software to capture and manage utility expenses from utility provider bills.

  • Design and develop architecture and databases for UEM system.
  • Design and develop data entry software for capturing bill data.
  • Design and develop software and processes to identify exceptions, missing bills, mispaid bills, etc.
  • Design and develop billing process to seamlessly channel capturing expense data to monthly resident bills.
  • Develop ETL (extract-transform-load) processes to load data received from multiple sources into client's system.
  • Develop extensive reporting for the product.
  • Develop processes to send out funding requests to clients.
  • Seamless integration of new product into client's existing enterprise utility billing software.

  Tech: SQL Server, ASP.Net Web Forms, Windows Forms desktop apps, C# on-premise APIs, various console apps that run on a schedule, SQL Server Reporting Services reports.

• Utility Billing system Apr 2005 - May 2007
  Multi-family housing utility billing industry

  Design and development of enterprise software process to bill utility billing charges to monthly bills for residents at multi-family housing (apartment) properties.

  • Design and develop architecture and databases for billing system.
  • Design and develop billing software and processes to identify charges, add them to ledgers, and print on bills mailed to residents.
  • Develop extensive reporting for the product.

  Tech: SQL Server, ASP.Net Web Forms, Windows Forms desktop apps, C# on-premise APIs, various console apps that run on a schedule, SQL Server Reporting Services reports.