From Databases to Application Design

www.oxo.com

• OXO Product Database – This internal-use web application allows authorized users to access a library of current and deprecated products made by OXO including materials, patent information and regulatory requirements.  It also tracks consumer complaints and Amazon ratings, which are uploaded to the database on a regular basis in Excel format, which then analyzed, allows for easy-to-understand data visualizations and the early detection of any possible production issues.  This has been in production for several years.
• OXO Product Database Importer – This application was developed and used to collect and combine data from disparate data sources to produce the consolidated OXO Product Database
• Multiple upgrades — we added a comprehensive compliance module that streamlined the data input necessary to generate country-specific documentation to fulfill the legal requirements of multiple countries.

www.bhienergy

• OutageNet – Managed by BHI Energy ( http://www.bhienergy.com/ ), OutageNet is a multitenant, multi-role employee timesheet management system that was developed to allow the management and reporting of maintenance work performed at many of the nations nuclear power plants during periodic planned outages.  This has been running in production for 7 years during which there has been a constant steady stream of requested and fulfilled enhancements.
• TDProjectNet – This multi-role application allows an electric utility to document and manage service requests and fulfilments for equipment such as downed power lines or malfunctioning transformers.  The web-based interface allows some users to input, others to view on a limited basis and still others to have complete control over the information.

www.moneymovers.com

• Online Business Manager (OBM) – This PCI-compliant, multitenant, multi-role, multi-portal application allows health clubs to manage employees, members and third-party trainers.  Managers, members, trainers all have separate portals.  Credit card and ACH billing is performed in-application and many user roles are supported within the management module, which includes extensive reporting capabilities.  PCI compliance, audited annually requires the highest level of security including database encryption and key management.  This has been running in production for 6 years during which there has been a constant steady stream of requested and fulfilled enhancements that continue even today on a monthly basis..
  • AccessPass – These are IOs and Android apps, both currently available from Apple’s app store and Google Play, that allows health club members of OBM clubs to have rapid access to the member portal, which presents a scannable member barcode and allows for the purchase of products and training sessions.
  • OBM GateKeeper – This device, developed by Logical Developers, allows for unattended, after-hours access to a health club by authorized members.  It features a camera and always-on window facing barcode scanner that checks the eligibility of the scanned member barcode, and if eligible, activates a relay that automatically unlocks the door.  Health clubs wishing to broaden their revenue stream have now begun to take advantage of this new option.
• NIHCA Rewards ( https://nihcarewards.org/ ):  In production for 2 years now, this HIPPA-compliant, multitenant, multi-portal, multi-role application allows dozens of member health insurance companies to reimburse health club members whose monthly attendance rises above a threshold level.  It links hundreds of thousands of members with thousands of clubs to those insurance companies.  Members have their own portal where they can review their workouts and reimbursements.  Clubs have their portal, where member status can be reported and workouts can be submitted.  Insurance companies have their portal where member/club information can be maintained.  Ever month, request files containing workout numbers are submitted by clubs.  Shortly after, response files are sent by the insurance companies, confirming member reimbursements.  The application then generates the appropriate ACH files, which Money Movers then processes.

www.PJSC.COM

A client for about two decades, we have developed many solutions over the years beginning with website content management in the late 90s.  Two of our  much more modern web-based applications are currently in production:

• PJSC Contact Manager is a secure, internal-use custom CRM application and database that allows for detailed searching and filtering of client data as well as call and meeting minutes reporting.  It is also the source of mailing list generation.  PJSC Contact Manager included the development of a custom Microsoft Outlook Add-In that facilitated adding one’s personal Outlook contacts to the centralized CRM database.
• PJSC Expense Manager is a secure, internal use custom multi-role web application that allows employees to easily enter, categorize and attribute business expenses.  Managers can review and approve those expenses and generate expense reports in multiple formats.