Case Studies

JTechWorks provides consulting and programming services to organizations that cover a range of industries, from start-up firms to established companies.

Following is a partial list of our clients with accompanying case studies.

Rives Leavell & Co. is a leading provider of specialty investment bonds, focusing on church and faith-based organizations that need financing for new construction, renovations and property acquisition. In addition, Rives Leavell & Co. provides investment services to those wishing to invest in the bonds of their own church or other organizations.

As a securities Broker Dealer the company is heavily regulated and had developed a complex and disparate IT structure. Rives Leavell & Co sought streamlined integration of its data with back office operations, sales and marketing department, and management, which had been relying on multiple software products and duplicate manual operations.

With extensive investment industry experience, JTechWorks was selected to replace the systems infrastructure.

Rives Leavell & Co. Internal Operations

JTechWorks created a centralized Microsoft SQL Server database, network user systems for accounting, back office, and management with MS Access and Visual Basic, and an on-line investment management application built in Adobe ColdFusion, Microsoft IIS, and MS SQL Server.

The company-wide application provides back office trading, commission accounting, client management, and full reporting functions. In addition, investment regulatory issues were addressed for trade processing, investment registrations, and mandated FINCEN money laundering identification.

Rives Leavell & Co. Online Sales

Investment clients are better served with a new online sales system where they are able to purchase investment bonds from live inventory, create trading accounts, registrations, and update SEC and FINRA account cards as needed.

Institutional buyers and sales account executives have the ability to manage their clients, purchase investments, and access multiple reporting options.

Rives Leavell & Co. Public Website

Presentation of live bond inventory online to investors and potential clients is essential to Rives Leavell & Co.'s strategy of providing high-quality service to their clients. The infrastructure created for internal operations and online sales was used to develop a website that addresses the needs of both potential investors and potential loan origination clients, with easy access to the live inventory.

Additional features include interactive financial calculators for loan calculations and investment options and listings of multiple publications for both investors and borrowers, which RLC marketing staff updates with current issues though a custom control panel.  

Griswold Special Care is an international non-medical home care company referring caregivers who provide personal care, homemaking and companionship to the elderly and infirm. With a central managing office and several branch offices communication is essential to providing quality services.

Griswold Special Care managed their cases with multiple Microsoft Access databases that they had outgrown.

JTechWorks initially designed a browser-based case management system with a centralized database to run on a company intranet running Adobe ColdFusion, Apache Web server, and MySQL databases. Branch offices were able to log in securely via a Virtual Private Network and have immediate access to the most current information on all cases.

When the company found users outside their intranet required access to data, JTechWorks implemented an updated system running in a cost-effective VPS (Virtual Private Server) configuration running Adobe ColdFusion, Microsoft IIS, and MySQL databases. The VPS provides the performance and flexibility of a dedicated server without the associated expense. Maintenance and support is provided by a third party data center.

Management and Remote Office Reports are easily run from the browser, data can be downloaded to Excel, and the Administrator has an Access Interface to the MySQL database for ad hoc reporting. Multiple windows-based interfaces were implemented to offer local copies of all database tables, SQL queries, and other database specific functions.

Power Court Search is a provider of criminal record searches for pre-employment background screening.

With many years of experience providing public records information directly to clients, Power Court Search wanted to offer a self-service, online option to attract clients looking for 24X7 access.

Existing data was housed in a Microsoft Access database. JTechWorks developed an interface to export the data into a MySQL database and an easy-to-use, web-based program using Adobe's ColdFusion for client searches. Monthly updates received from the State are processed locally to match the MySQL database then uploaded to the online server, ensuring clients have access to the most recent data.

The online program includes a tracking ticket system that allows clients to create a support ticket from their search information. Power Court Search staff review the ticket information and respond to the client. They update the ticket, maintaining a record of their interaction with the client and the outcome.

Wizard of Paws Physical Rehabilitation for Animals needed a website that presented a current speaking and class schedule, an online store, and features that highlight the successes of their clients.

JTechWorks integrated these features, creating a web site that encourages return visits.

• A third party calendar tool that is easy to maintain
• PayPal Shopping Cart, including subscriptions to Wizard of Paws Journal
• A photo slide show of clients' blue ribbons and qualifying successes
• Get On The Ball photo slide show of clients using the exercise ball

Foley-Baker repairs and reconditions pipe organs. Their service and the quality of their work was well-known throughout the northeast.

Foley-Baker's online presence had been a one-page website that did little to demonstrate their capabilities or to attract national attention.

JTechWorks created a new site for Foley-Baker that includes a tour of their recently completed pipe organ renovation project at Boston's Symphony Hall, as well as details of the services they provide.

Their new site is optimized for organic search engine positioning, allowing them to attract clients in markets throughout the United Sates that need their expertise. FoleyBaker.com is now consistently first page listed by Google for the terms "pipe organ repair" and "pipe organ tuning".

Author Patti Lawson had a simple web site describing how her life-changing experience of adopting Sadie and getting a new leash on life lead to writing a book. In the months leading up to the April 2006 publication of The Dog Diet Patti wanted a custom-designed web site that promoted the book and her appearances.

JTechWorks designed and created a web site that incorporated the look of the book cover and illustrations of Sadie used in the book. The site includes information on purchasing The Dog Diet, press contact information and news highlights. In addition there are pages for Patti's book signing schedule and speaking engagement pages which are updated regularly.

A natural extension of Patti's website was The Dog Diet blog to showcase Dogs, Diets, Dating, her newspaper column, and other entertaining events that occurred during her book tour. Patti adds entries to the blog of Sadie's adventures, including her date with "Duke" Bush, as easily as working in a word processing program.

National Research Associates, Inc provides pre-employment screening services to corporate clients.

National Research came to JTechWorks with an idea for a web-enabled ordering system. JTechWorks created an online order entry application where clients can conveniently and securely order confidential screening reports.

National Research benefits by having control over the order entry format and by having all of their service offerings available to clients. Their order processing has been streamlined through downloads or interfaces and they now have a detailed client request database.

National Research and their clients are able to run real-time reports on order activity.

JTechWorks also created a corporate information web site for National Research as part of an overall marketing campaign.