With our focus on application development for web-based and client-server deployments, Randall Solutions Group provides expertise and professional services throughout the entire project from concept to implementation, user training and maintenance. Whether your solutions uses a traditional systems development approach or object-oriented analysis and design, our consultants deliver results every step of the way.

Below is a list of solutions developed for a few of our clients. These solutions represent a sampling of Randall Solutions Group's portfolio.

United States Government, Department of State / Department of Defense

• Performed systems analysis and designed application for Department of State Human Resources to supplement a PeopleSoft HR ERP implementation at Department of State. Architecture includes MS Access and Oracle database, with Visual Basic, Cold Fusion and Active Server Page intranet capability. System was developed using standard lifecycle design created for DOS and gathers data from worldwide posts and calculates pay schedules for State Department employees.
  
• Created ASP interface to allow users to enter information about worldwide posts and job openings at these posts. System allows the user to upload files for browsing on Intranet through ASP front-end connecting to SQL Server back-end. Reporting on statistics using Crystal Reports Active-X Viewer.
• Responsible for gathering and analyzing requirements for a new DLA Criminal Incident Reporting System. Developed a software and hardware configuration, which incorporated all factors from the mean time between failures for user access to the system. Merged multiple database systems into one master database structure, which is able to interface with multiple external systems. Designed web based graphical user interface prototypes and a risk database for the client's new system. System was designed using Oracle back-end and a Cold Fusion front-end.

University of Maryland Medical Systems, Baltimore, MD

• Created client-server database to trace and match organ transplant patients with donors. System uses UNOS transplant matching rules to determine suitable organs for patients.
• Developed client-server application for Department of Neurosurgery to track patients from diagnosis through surgery and recovery.
• Designed database to log spectator injuries occurring at Oriole Park/Camden Yards. System generates end of season reports to analyze and improve safety standards.

DataOverTheWeb Inc, Washington, DC

• Developed multiple web-based systems including trouble ticket and change log, training videos and mailing list registration data using ASP.NET, VB.NET and SQL Server. Systems utilize advanced security and search functionality allowing users to view, search, and manipulate data online.
• Also created multiple client-server applications

International Women’s Forum, Washington, DC

• Implemented client-server application to replace existing database. System increased staff productivity over 50% and reduced operational costs by 30%.
• Interfaced client-server system with new web based registration to import, process and report on registrants and later created real-time link to share data between multiple systems.

National Academies, Washington, DC

• Converted existing ASP search functionality into client-server database on CD-ROM for worldwide distribution.

Rappahannock Electric Cooperative, Fredericksburg, VA

• Designed and implemented client-server marketing database to replace multiple client developed systems. New application reduced in-house development costs by 70% and significantly increased staff productivity.

Organization of American States, Washington, DC

• Develoepd client-server database and web interface for searching and viewing documents on Internet.

Potomac Consulting Group, Arlington, VA

• Programmed mail merge e-mail system to allow merging names, addresses and other data into an individually addressed e-mail message. Benefits include reduced mail handling by staff, reduction of postage costs and improved communication with members. Currently in use by numerous clients in various industries.

Cable and Wireless Inc., Vienna, VA

• Designed enterprise proposal order provisioning system using client-server and web based technologies. Database tracks order through complete life cycle.
• Developed system to export legacy data on scheduled basis to new relational database for reporting purposes.

Employee Health Program, Bethesda, MD

• Developed system to process drug test results and e-mail results to clients utilizing MS Visual Basic and MS Mail Server.
• Also created MS Visual Basic telephony system to inform clients of drug test results.
• Systems were on the cutting edge of technology at the time using unprecedented functionality.

National Law Enforcement Officers Memorial, Washington, DC

• Designed database to track information on deceased law enforcement officers and their survivors using client-server framework. System generates files used to engrave names on memorial. Memorial has multiple sections of varying lengths and system determines best placement for 200-300 new names per year. Advanced calculations include ability to place multiple officers a specified number of sections from each other.