937.903.3875      info@moonshadow-sw.com
  Overview Services Experience Samples
Accounting and Management Data Conversion and Import/Export Email and Websites
The Accounting and Management programs utilized Visual Basic or VBA through MS Access, Excel, Word, and Project, some with back-end databases in Oracle and SQL Server. Developed for a variety of businesses, from government to retail to service providers to internal management, with varying requirements as to the type of data that needs to be captured, processed and reported. Some projects are stand-alone applications, meaning it does not interface to other applications, and others require integration of the new application to an existing one. Other projects involved modifying the source code for an existing application to tailor it to the needs of the company, such as collecting and processing additional data, and adding or modifying functionality, user screens and reports. Often data needs to be transferred and/or converted to fit into a new or different database format. Sometimes the program needs to run unattended, while others call for user-friendly interface screens. Many MS Access data imports and exports have been done, both manually and programmatically, with a variety of platforms including other versions of MS Access, Excel, Oracle, SQL Server, Lotus Notes and plain text files. Several modules and small applications were developed to import information by implementing normalized data tables, data integrity checks and, for traceability, error log creation. ETL (Extract, Transform, Load) programs were written to handle electronic file transfers between Oracle and MS Access databases and business partners' legacy systems. Sometimes an application needs to be accessed by a large population, either internally to the business or on the Web. Utilizing HTML, ASP and VBScript, an interactive website was built to display company policies, standards, history, hierarchy, etc. Basic informational websites and online storefronts have also been created. These dynamic web pages have the ability to extract data from most databases, including MS Access, SQL Server, and Oracle.

To send mass emailings, a software module was developed which allows the user to select values within desired fields through a screen with list selectors. The user then enters a subject line, selects a document and the email is sent to all included recipients.

Educational Administration Telephony Commercial
Including tasks surrounding Admissions, Financial Aid, Attendance, and Forecasting, custom data management software can eliminate many hassles of administering a school. Developing a well-planned suite of applications to assist the faculty and staff in all their duties makes more efficient use of everyone's time. A powerful report generator provides quick access to student, teacher and class information. Seamless integration with existing school software and data providers permits sharing of neccessary information, like instant access to FAFSA data. An Interactive Voice Response (IVR) application that accesses text files, as well as several dBase III and MS Access databases, was developed in Visual Basic with Visual Voice. In this application there is very little GUI, rather the user interface is the telephone. Another audio application is a transcriber, which allows the user to listen to .wav files with standard controls to stop, start, rewind, and fast-forward, while typing text into appropriate data entry fields. As a fun and creative twist, the GUI for this application emulates a CD player. Several projects primarily need to store and report large amounts of data. Most of these relational database systems are intended for a limited number of users (less than 100) and are implemented with distributed database designs. Typically they are report-driven and consist of many tables and complex queries. Applications include: Home Inspection, Contact Management, Gift Certificates, and Maintenance Management.

Human Resources Technical
Various user screens, reports, and data exports to Excel spreadsheets and Word form letters were developed to assist Human Resource departments with managing and tracking employee relations, certifications, education, work visas, and time & attendance. Several of these projects also require raw data imports, which are summarized in the section about Data Conversion and Import/Export. Usually written in Excel VBA, Visual Basic, or C these are generally small programs which integrate with existing applications, each meant to accomplish a specific task. Some have user interfaces and others are time or event and hidden from the user used to perform necessary processes on the data.
Improving productivity with custom software solutions.
Moonshadow Software
Springboro, OH 45066
© 2004-2019 Moonshadow Software. All Rights Reserved.