The Solutions Group - News

Welcome Page

About Us

Products & Services

In the News

Send Us Email

Client List & Links

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
New Clients and New Projects with Existing Clients!

US Army Dept. of Defense, Vintage Health Resources, American Society of Professional Estimators, Allergan Medical, International Paper, Skyline Displays, FedEx, Farris Mathews Branan Bobango Hellen & Dunlap PLC, Central Church North, Memphis Property Services, KTL Industries, Computer AC, CompUSA Training, Berkeley Training, Think Signs, Dr. Pedro Diaz, General Medicine; Open Road Technologies; Manhatttan Eye, Ear & Throat Hospital; Julie Coffey, MSARC / City of Memphis; Lubin Enterprise, Inc.; Boys & Girls Club of Placentia, CA; Larry Moss Auctions; Dr. Kim Huch VA / Univ. of TN, Nephrology; Dr. Jerome Rubin, CA; Oncology, Shultz Brothers Excavating, MS; Special Kids & Families; Sports Medicine at Saint Francis Memorial Hospital, CA; XO Communications!

The Solutions Group is pleased to announce the conversion of BusinessFM, AssociationFM, PatientFM & GivingFM to FileMaker Pro version 9.

 

Select Project Overviews - Examples of our Work - Client Highlights
FedEx, International Paper and The City of Memphis

Federal Express (FedEx), Global Operations Control Center (GOC),
Memphis, TN, Employee Scheduling Application

GOC is often referred to as "the nerve center of the FedEx transportation system"

History: Current Client; 1997-2006; version 5 - 8 databases used to manage work schedules and FAA required training administration for multiple shifts, and disciplines, 24/7. "Control and Intelligence" allows employees to "swap, slide and do IOUs" with other employees without a manager having to approve changes in the schedule. Powerful, accessible reports organize, count and subtotal by employee, manager, shift, discipline, day, pay period and work code.

Result/Benefit of our Contributions to FedEx GOC:

  • The database is an "intelligent system" with thousands of if statements making sure employee schedule changes are "ok" by internal policy and by FAA rules.
  • The use of a securing window plug-in, control tables, advanced calculations and scripting, secures the environment so all movement is via button / hyperlinks upon logon. A change log documents usage.
  • An email client is used to automatically notify managers and staff of select changes to the schedule.
  • Many very sophisticated reports analyze the data set allowing staff and managers instant viewing and answers regarding work.
  • Over the years, it was been added to continually. First designed for Domestic GOC with over a hundred employees, then International GOC and Crew Scheduling adopted it as well, with adjustments.
  • Currently, partnering with FileMaker.com for software upgrades for GOC, we are converting and migrating v6 related files into v8 related tables and will be deploying FileMaker Pro Server 8 Advanced as the engine to offer new on-demand access via web publishing from "anywhere, anytime".
  • Since 1997, we have been there year after year for support, as FileMaker Development is and will continue to be our primary focus.

 

International Paper (IP), Customer Commitment Center
Memphis, TN, Project Management Database

History: Current Client; 2002-2008; version 5 - 9 databases used to manage value-added services of graphic design, structural design and lab testing projects. I was hired in 2002 to support a v5 database running in a client / fmp server environment. Since that time, it has evolved over the years adding in one to many relationships and converting v5 files to v9 related tables. We are nearing deployment of totally web based Project Management Solution using FMP Server 8 Advanced.

Result/Benefit of our Contributions to IP:

  • A powerful multi-departmental completely web based Project Management Database.
  • The use of an automated script activation plug-in, creates a level of intelligence that runs multiple queries every 5 minutes and acts upon the results including auto-emails, report sending, notices and alerts.
  • Many very sophisticated interactive web based reports analyze the data set allowing staff and managers instant viewing and answers regarding work., including the comparison of two date ranges for two years, counts and total of hours and costs.
  • The v8.5 web viewer is used to set and view digital documents referenced in an innovative digital library schema.
  • Currently, partnering with FileMaker.com for software upgrades for IP, we are nearing roll out of a totally browser based project management solution driven by a powerful FileMaker Pro Server 8 Advanced engine.

 

The City of Memphis, MSARC, Memphis Sexual Assault Resource Center
Memphis, TN, Medical Records

History: Current Client; 2001-2006; version 6 clients connecting to fmp server 6 running on a City of Memphis Server. 1st hired to support misc. changes to an existing v4 flat file EMR, The Solutions Group, has asked by the new Director, Julie Coffey, to upgrade to v6, add server, a statistical front-end and set up VPN remote support.

Result/Benefit of our Contributions to MSARC:

  • Statistical front-end for Electronic Medical Records offers Control and Analysis.
    • The Center has several funding sources (grants), and offer many services such as counseling and advocacy.
    • Control tables and values were added and a front-end was added to control and capture all staff activities for the purpose of tracking clients (patients) and knowing what and how many services are being delivered, and to who (demographics).
  • All "one to many" data relationships were identified and moved to related tables to achieve quick access to and counts of related records, such as session notes.
  • An interactive finding / report screen was added to make it easy to find information and get counts.
    • The Director and Managers, now press buttons to print out daily, weekly, quarterly, yearly or a custom date range report required by each funding source, that provides an extremely detailed statistical analysis, in most every way imaginable.
  • VPN remote support always connection to City Servers to make changes remotely when needed; We work for five minutes and bill for five minutes.
* *

The Solutions Group is pleased to announce that Christ United Methodist Church, of Memphis, TN is using a customized FileMaker Pro based Gifts Giving database to acknowledge memorials and honorariums.

ExploreFaith, a ministry affiliated with Calvary Episcopal Church in downtown Memphis, has engaged The Solutions Group for web publishing data management including task tracking. Explorefaith.org

Memphis based, TN based Fortune 100 corporation, International Paper, has engaged The Solutions Group to enhance a client server FileMaker Pro based Project Management Solution. The solution allows for user friendly input and tracking of project costs by remote users around the country connecting to FileMaker Server.

The Solutions Group adds PDA (Palm handhelds) capability to our EMR solution PatientFM. Using "text strings" on their FileMaker Mobile enabled Palms, doctors enter patient notes, diagnosis and charge codes, as well as, reference ePocrates, then each day "sync" with the host database; The sync prints notes for filing and returns to their Palms, a list of active patients (the census), their schedule and partially completed S.O.A.P notes for the days rounds. Truly a cutting edge use of the technology to speed documentation and administer billing. THE POWER OF FILEMAKER AND THE HANDHELD.

A Utah based legal services firm, has engaged The Solutions Group to create a database, based on development shells, to manage clients and cases which includes the printing of legal merge-form documents, as well as, a web case status component, for access by clients and account reps.

The Medical Practice of Dr. Henry DeGroot, III, M.D. F.A.A.O.S., Board Certified Orthopaedic Surgeon, Clinical Associate Professor of Orthopaedic Surgery at The Univ. of Mass., Boston, MA has selected PatientFM by The Solutions Group as their EMR database. The database uses FileMaker Pro Server and voice recognition software in a client-server environment on a Windows 2000 server and is accessible via a HIPPA compliant encrypted VPN (Virtual Private Network) from remote locations; a second office, home and two wireless access points within a hospital. Through remote control / admin. software, The Solutions Group provides secure remote support. Visit Dr. DeGroot Online.

The University of Memphis Department of Music has selected The Solutions Group to automate management of prospects, undergraduates, graduates and alumni, as well as, marketing and publishing event and staff schedules using both LAN and Web-based technologies.

The Solutions Group is pleased to announce the release of RegistrationFM+. A Secure, Powerful, Adaptable, Affordable Web Based Registration Solution! Powered by FileMaker Pro's web engine. Ideal for Colleges / Universities / Schools; Membership Associations; Meetings and Convention Industry; and Product cCommerce. Own it or we will host options.

SARC, a City of Memphis Community Services Provider has selected The Solutions Group to convert their client/server data management solution to a Web-based solution.

The Solutions Group is pleased to announce the release of a clinical EMR, PatientFM v2. The new upgrade includes appointment scheduling, to-do items, coding and billing reports.

The Solutions Group is pleased to announce the release of InventoryFM+web. Five Solutions in One. Utilizes FileMaker Pro Unlimited to allow hundreds of individuals to access your site in real-time. Sales team, Buyers, Supply Reps, Customers, Management. Currently available using "instant web publishing". A more robust version using customized HTML pages is in alpha development stage. Release is planned for Jan. 1, '03.

The Solutions Group is pleased to announce Studio. An innovative integration of training and development, for Word, Excel, PowerPoint, Outlook and Access. Studio is custom tailored, limited prep, problem-solving, solution driven training. Studio Catalog. The final product is a software solution for use on-the-job, created and understood by the student.

Concord EFS, Inc. has selected The Solutions Group to deliver their Microsoft Office corporate training program.

The Women's Foundation for a Greater Memphis selected The Solutions Group to create a state of the art Gift and Donor Management Database Solution, including Marketing, Grants Management, Donor & Fund Management, and Financial Management, Volunteers and Task Management. The development included incorporating MarketingFM into the multi-user relational database solution. The WFGM was voted Memphis best new Association of the year in 2000. GivingFM

Georgia School Counselors Association, has engaged The Solutions Group to enhance and maintain their Membership and Event Databases.

The Veterans Administration Medical Hospital in Memhpis, TN selects The Solutions Group to teach Microsoft Group Training Classes under contract for the third straight year. Intro through Advanced Word, Excel, PowerPoint, Access, and Outlook.

Berkeley Technology Training, of Bala Cywd, PA has contracted The Solutions Group to deliver its IT software training solutions in the Memphis Area.

Crew Resources Dept. of Federal Express, to eliminate paperwork and enter into the 21-Century, has enlisted The Solutions Group to develop a customized web-enabled version of AutoSked for deployment 6/1/01. Key reasons: The reports; ability of schedulers to swap work shifts without mgmt. approval; mgmt. time savings in these two key areas. FedEx and AutoSked

SARC, a City of Memphis Community Services Provider has selected The Solutions Group to upgrade their existing information management solution.

The Solutions Group is pleased to announce that FedEx International flight control will begin using a customized version of AutoSked beginning 6/1/01. Selection of software solution provider was based on the success of AutoSked by Domestic Flight Control for the past 3 years.

University of Tennessee College of Medicine and The Solutions Group begin co-creating a state of the art Electronic Research Medical Records Database. PatientFM

The Museum of the American Quilter's Society, Paducah, KY selects The Solutions Group's MarketingFM - Media Contact and Marketing Tracking Solution. The Quilt Museum

Universal Asset Management, Memphis, TN selects The Solutions Group's Digital LibraryFM - Store and Search all your text documents in a digital library and MarketingFM - Media Contact and Marketing Tracking Solution to auto-email press releases to key contacts in the aviation industry. UAM

Federal Express Global Operations Control, US - Memphis TN recognizes AutoSked by The Solutions Group, as entering its 3rd year of providing work shift scheduling and reporting for the Domestic flight control specialists in the command bunker. FedEx

New York State Association of Fire Chiefs, selects The Solutions Group's AssociationFM - Association Membership, Publication and Event Managment Solution.

The Valuations Group, purchases modules with customization from The Solutions Group's BusinessFM development shell. No more paper! A multi-user total office automation solution. The Valuations Group

Memphis Home Education Association, engages the The Solutions Group's AssociationFM development shell to streamline the administration of it's 1200 member association, newsletter subsriptions and annual conference event. MHEA

 The University of Mississippi Center of Southern Cultural Archives in Partnership with the Library of Congress, engages The Solutions Group's technical expertise with FileMaker Pro to release an educational product on CD containing over 1200 farm photos taken by the Roosevelt Administration during the 30s. The collection not only captures a place and time, but were taken by some of the best photograhers of the time.

Ellendale Electric Company speeds up with Quik Quotes & a number crunching Job Sales, Commissions & Invoice tracking solution using FileMaker Pro and The Solutions Group's JobSalesFM development shell. Ellendale Electric, for all your electrical needs.

Fire & Security Division of Ellendale Electric Company uses The Solutions Group and FileMaker Pro to create an accounting solution for tracking Monitoring customer accounts .

Federal Express Global Operations Control Center automates scheduling of personnel using FileMaker Pro. Go FedEx!

Human Resources Dept., The Regional Medical Center automates employee performance evaluations using FileMaker Pro and The Solutions Group's HRevalFM development shell.

ACCRAbond, Inc. automates with a state of the art order/sales & manufacturing delivery solution using FileMaker Pro and The Solutions Group's BusinessFM development shell.

The Regional Medical Center selects The Solutions Group to deliver hospital wide Microsoft Office Classroom Training.

^ Top of Page