Diverse Solutions

LunaTek Consulting has worked with a number of diverse clients, including trade associations, non-profit organizations, and fast-track small businesses. Listed below is a representative sample of these clients and how LunaTek has helped them help their business.

Web Site Programming

Eric Burleyson, LunaTek's founder, is a partner in Health Literacy Innovations, creators of the Health Literacy Advisor, the nation's first interactive health literacy software tool. Eric is the Chief Technology Officer for the firm, responsible for, among many things, the back-end database coding for HLI's website HealthLiteracyInnovations.com.

Web Site Design

Stewards of the Potomac Highlands is a nonprofit 501(c)(4) organization formed to preserve open spaces, forests, farmland, rural communities and towns, and foster stewardship of the Potomac Highlands of West Virginia, Virginia, and Maryland.

Stewards approached LunaTek to improve the look of their website PotomacStewards.com. LunaTek rose to the challenge of working within the limited budget of this small non-profit and produced a simple, clean, consistent look, and consolidated and updated the information provided on the website.

Business Database Solutions

The National Community Pharmacists Association (NCPA), founded in 1898 as the National Association of Retail Druggists (NARD), represents the pharmacist owners, managers, and employees of nearly 25,000 independent community pharmacies across the United States. Independent pharmacists - more than 60,000 nationwide - dispense the majority of the nation's retail prescription drugs. They're on the web at www.ncpanet.org.

One of NCPA's activities is the annual NCPA-Pharmacia Digest. The Digest compiles and summarizes comprehensive financial data from independent pharmacies nationwide. Participating pharmacies provide financial information on their stores' revenues, expenses, and demographics. The survey has been compiled and reported for more than 60 years. In 2002 NCPA contracted with LunaTek Consulting to provide a database system to collect and analyze the surveys. LunaTek provided a system centered on a Microsoft Access database. The system was designed for ease of data entry and includes sophisticated error checking and discrepancy flagging. It allows the data to be further analyzed with Excel, and uses a Word merge to provide customized individual reports to participating pharmacies. Click here for some screen shots of this LunaTek Database System.

The Association of American Veterinary Medical Colleges coordinates the affairs 27 U.S. Veterinary Medical Colleges, 5 Canadian Colleges of Veterinary Medicine, Departments of Veterinary Science and Comparative Medicine, and the animal medical centers. Visit them at www.aavmc.org.

From 1996 - 2013, LunaTek provided the AAVMC with a database system to allow the collection and analysis of annual survey data concerning applicants to and students of their member institutions. Initially, the back-end database portions were developed in R:Base for Windows (to remain consistent with their existing database applications) with a stand-alone field survey program developed in Delphi. In 2006 LunaTek migrated the survey to a private website, using MySQL as the database engine and PHP as the scripting language. The database integrated with MS Excel for the number-crunching analysis.

Legacy Database Maintenance

Foundry United Methodist Church is located in the heart of Washington DC and "strives to provide a spiritual home in the city for all of our communities. We are an open, inclusive community dedicated to enabling persons to live a Christian life and to share Christ with others through worship, evangelism, witness, mission, education, and nurturing." Visit them on the web at www.foundryumc.org.

LunaTek has worked with Foundry in a variety of ways, mainly by supporting their Paradox for DOS membership database. LunaTek maintained and enhanced this database as Foundry migrated from a few DOS PC's to a LAN with Windows workstations. By having LunaTek keep this old database running for over a decade, Foundry was able to successfully postpone the cost of replacing it with a fully Windows-based system.