About Jarann Consulting

Background Management Accomplishments

Accomplishments

Created website for local basketball, fitness, and training center. The website is built using a Microsoft Access database along with HTML, Active Server Pages (ASP), and VBScript. A special administrative site was created and password protected so site updates could be made from any computer with access to the Internet.

Developed e-commerce application for a regional company to market Step2 products on the Internet. The website manages product images, prices, and descriptions along with handling prices for shipping and taxes. Real-time credit card processing is handled through the website's Shopping Cart feature. The website was built using third-party development software to minimize development time and cost, but was customized extensively to fit the specific needs of the client.

Designed Microsoft Access database application to organize the keeping of statistics for a local weekend softball tournament. The database provides for efficient entry of all game statistics and includes various reports to display results and statistics for both teams and individuals. Created a tournament website using HTML, Active Server Pages (ASP), and VBScript along with thedatabase as its foundation to display all the results and statistics. The database and website were designed so that upon completion of the annual tournament, the website can be update with the new information by simply replacing the database from the priot year with the new database.

Created website for the coaching staff of a local high school basketball team as a communication device between coaches, players, and parents. The website is built using a Microsoft Access database along with HTML, Active Server Pages (ASP), and VBScript. A special administrative site was created and password protected so site updates could be made from any computer with access to the Internet.

Part of a team of developers responsible for maintaining and enhancing an E-Commerce application used by a manufacturing company and their North American distribution system to order products. The system was built originally using an Oracle database, but was converted to SQL Server. The system combines HTML, Active Server Pages (ASP), and Active-X code written in VBScript and Visual Basic. Active-X forms are accessed in the system and completed by users. The ASP code provides for the navigation between the forms and communication with the database. Initially, learned the system while serving as the single technical support contact.

Project Manager/Software Developer responsible for rewriting and enhancing a system to track reimbursement requests for manufacturing parts under warranty. The new system was developed in Visual Basic using an Oracle database. Reporting functionality was integrated into the application using Crystal Reports. Worked closely with current users in understanding the requirements of the application. Used this understanding in developing screen design and system flow. Utilized Oracle for data management by creating and modifying tables, creating report views, and writing SQL scripts to convert data from the previous system. Tested the system thoroughly to verify that user requirements were being exceeded. Conducted user training classes prior to implementing the system. Created a user manual and integrated it into the application as a help system using HTML. Produced detailed system documentation and met with IS staff members to transfer knowledge regarding application design. Project management tasks included developing a project plan, managing the scope of the project, monitoring task estimates versus actuals, distributing weekly progress reports, conducting bi-weekly status meetings, and creating databases in Microsoft Access to document development issues and user testing.

Webmaster for annual basketball tournaments run by a local organization. Designed a Microsoft Access database for keeping track of game results and pairings. Updated results daily to keep the information on the website as current as possible. Also designed the format to display the tournament brackets so they would display quickly and look professional. Technical support issues were handled through regular monitoring of e-mail.

Developed multi-user Microsoft Access database for a manufacturing company to track critical documents that need to be submitted by sales and the shop floor. Automated daily e-mail notifications are sent to departments failing to submit the required information. The system also includes a tool for generating customized reports to assist in meeting quality control guidelines.

Client/server developer responsible for maintaining and supporting a Visual Basic application for an engineering department in a manufacturing company that automated selection of multiple configurations for uninterruptible power supply (UPS) systems. The application was built around a Microsoft Access database and utilized Crystal Reports for handling reporting and graphing. The application was made available for sales offices across the country via the Internet. Running the application directly off a website eliminated the need for coordinating distribution of the database when changes were made.

Client/server developer responsible for maintaining and supporting a Visual Basic application used by the legal department of a large multi-lines insurance company. Using a Microsoft Access database, the system managed information for various types of legal cases handled. Reporting was managed in Access via OLE Automation.

Client/server developer responsible for maintaining and supporting a commercial software package that provides property information for economic development organizations. The application design implemented OLE Automation technology for a client/server interface. The client application was developed using Visual Basic while the server application was developed using Visual Basic and an Access database. Printing and report processing were implemented in Access via OLE Automation.

Created a Visual Basic application used to synchronize data between a manufacturing company's ERP software package and a customized quality control system. Triggers were added to the quality control system, a Visual Basic program using an Oracle database, validated for accuracy, and sent to the ERP Progress database through the synchronization program. The synchronization program was designed to run constantly and it also read information from Progress via ODBC connections directly into the quality control Oracle database.

Client/server developer responsible for coding custom enhancements to an integrated manufacturing software package according to customer requirements. The enhancements included creation and modification of online menus, reports, data entry screens, database tables, and data conversion. Used Progress, a 4GL development tool set and database.

Project leader responsible for coordination, enhancement and implementation of a life insurance application developed with Visual Basic and a SQL Server database. The system is used to generate health and life insurance rate proposals for sales offices in Ohio, Indiana, and Kentucky. Primary responsibilities included design of input screens and output reports, system testing for rate calculation accuracy, and writing on-line documentation.

Designed, enhanced and supported a renewal system which imports data from a mainframe administration system, calculates renewal rates for existing business, updates renewal rates and generates client and broker renewal letters. The system was developed in Visual Basic and an Access database. Responsible for design of system flows, screens and reports, monthly download of data from the mainframe, generation of renewal letters, upload of data for rate updates, and development of all system revisions and enhancements.

Programmer/Analyst on a project to develop an automated storage system. The system was used to assist in tracking inventory at multiple off-site locations. Involved in all phases of the project lifecycle including training employees to understand the new process flow.

Programmer/Analyst responsible for developing an invoice tracking system, which generates invoices and tracks the reconciliation. Unreconciled invoices are flagged and follow-up letters are generated. Designed, programmed and tested the system as well as supplied training and detailed system documentation.

Designed, programmed, tested and implemented a claims turnaround system. The system tracks claims inventory and generates reports for the company president detailing claims payment targets. Extensive data entry is associated with this application, so data entry screens were created to maximize efficiency. Also responsible for training employees, installing the system, and preparing detailed system documentation.



Back Contact the Webmaster Site Map Top

Copyright © 2001 Jarann Consulting, LLC All Rights Reserved.