EXPERIENCE:

Confidential

Systems Analyst / Programmer

Responsibilities:

• Developed data conversion processes to upload near real time data from Visual Foxpro to an Internet MySQL Server.
• Developed data conversion and error checking systems to move electronic spreadsheet data from multiple sources to an Internet MySQL Server.
• These systems are written in Visual Foxpro.
• Provide general support for the existing Visual Foxpro system.
• Provide general programming support of new PHP and MySQL development.
• C# Bigcommerce.com integration research.

Confidential

Computer Programmer

Responsibilities:

• Software development using Visual Foxpro, T - SQL, and Crystal Reports on Microsoft SQL Server Platform primarily for Accounting Software modifications.

Confidential

Computer Programmer and Consultant

Responsibilities:

• Responsibilities included all initial client contacts, sales process, determination of user requirements, systems analysis, selection of software tools, programming, testing, and installation of completed solutions.
• Also provided help desk and hardware service support.
• I used Visual Foxpro also, once version 5.0 was released.

Confidential

Responsibilities:

• Customized Visual Foxpro Accounting Software modules of Sales Order, Accounts Receivable, Accounts Payable, Purchase Order, and Inventory Control. Added fields to data tables and added new tables when necessary. Modified the object oriented forms and reports of the accounting software for entry into new fields and tables and for all background functionality.
• Created General Ledger extract reports for management to use in an separate General Ledger system.
• Wrote dozens of special purpose reports using Visual Foxpro outside of the accounting system to access data within the system and sometimes merge it with outside data files.
• Designed and heavily customized an automated reporting engine which would fax or email hundreds of reports to the clients nursing agencies and to management daily, weekly, bi-weekly, and monthly.
• Had a prototype custom order entry application built by an outside consultant, and modified it heavily with Visual Foxpro over the years to achieve rapid customer service ordering. Designed all background tables in order to make the program smart enough to make some decisions for the customer service representatives and perform a variety of background activity. Shippers tracking numbers could also be retrieved.
• Had a prototype nurse web ordering application written with the West Wind Software Tool, and modified it heavily to provide a functional and secure web ordering capability to the system.
• Created several EDI text output programs according to the specifications of clients vendors ie Johnson and Johnson. Utilized for some an automated FTP upload.
• Created several EDI text output programs according to the specifications of clients customers for the various software packages that they used, for electronic billing and their own internal needs. Some of these were very complex.
• Worked with the vendors from UPS, FedEx, and Airborne for their ODBC interaction with the Visual Foxpro system. When monthly electronic bills would become available from UPS I had a program that would cross check the UPS bills against the data which was created at the time of the shipment and track the changes. This was a very complex program.
• Created a custom application for client to use with new nurse agencies to organize and quicken the process of what was called formulary creation. Client might have five different products to treat the same medical condition and the nurse agency management would choose which product they would allow their nurses to order.
• Researched software vendors and solutions for the replacement system for this client. Selected Fitrix by Fourth Generation Software Solutions, a modifiable accounting software which runs on IBM Informix Server. Educated the vendor initially on all major customization requirements, then continued to be the answer man for the vendor as the client created their own detailed project specification. I selected Cybercon as the server host facility. Worked with the Unix firewall consultant to solve a problem with having two simultaneous connections to the internet from the main office. Put in place a prior employee of mine to do the data conversion work, and supported him on the tough technical issues.

Confidential

Responsibilities:

• Converted all data from a custom Dataflex system to the Visual Foxpro Accounting System.
• I learned the pre-existing system and maintained it within Dataflex until year 2000.
• I added a custom job cost module within the accounting software. Employee payroll time card entries and accounts payable vendor invoices were assigned to a steel construction job.
• The job module itself allowed for estimates and actual job expenditures for constant monitoring by management.
• The vertical market replacement system that they eventually moved to used Visual Foxpro for reports.
• I assisted with modifying the template reports in that system, within the reporting engine available on that system.

Confidential

Responsibilities:

• Created a custom invoicing system and a payroll paymaster system using Foxpro 2.6 for DOS and the Confidential framework.
• Converted data from a prior Cobol system. The majority of the system was completed within the first year and there has been minor ongoing maintenance work since that time.
• A few years ago I added an external invoice printing program written in Visual Foxpro for more elegant invoices.

Confidential

Responsibilities:

• This made it possible to not rewrite the entire system but get the last few DOS users onto Windows systems.
• There are also sales reports written in Visual Foxpro and within the last year I added a complex sales reporting routine that uploads report data using Visual Foxpro to a MySQL database on the web.
• I used a PHP website generation tool to give the owner access to all of these reports using desktop or mobile devices.

Confidential

Responsibilities:

• I used the Confidential framework for the data entry screens.
• This company travels to clients and does hearing tests.
• One module of the system is used by technicians on the road within the mobile trailer.
• Hearing test machines, audiometers, send hearing test results through a serial cable to a laptop.
• The hearing results are averaged and calculated according to OSHA rules, and compared to prior tests.
• The back office system has maintenance screens for customers and thousands of test subjects.
• Several reports are generated, which are sent to the client companies.