Selected Projects
Completed 100%, Personally by John McKinney
Download Word Version Resume Home Email John McKinney

John McKinney
370 Hemenway St, Suite 303
Marlborough, MA 01752-6601
Telephone: (845) 705-6911
Email: JM@JMcKinney.biz

Microsoft Partner Program Registered Member
Rapid Application Development
using Microsoft ACCESS/Visual Basic for Applications (VBA)/MS Expression Web/Office development tools and HTML.

Microsoft ACCESS, VBA ... Hudson Trading, Ossining, NY
Designed and developed database application for managing their business.  The application was converted from EXCEL spreadsheets.  The key part of the ACCESS application keeps track of orders and shipments.  It includes information about customers, truck lines, and individual shipments.  The person primarily responsible for maintaining and using the data commented: “…everything looks wonderful.  I understand it completely and it is easy to work with.”

Microsoft ACCESS, VBA, FrontPage; HTML ... Philip Morris, Westchester, NY
Designed and developed Intranet website to show world-wide business problem status. Top executives can instantly see business problem locations from color codes on the screen and drill down to first see summaries of the problems and then down to details of the problems. ... Problems are entered into the ACCESS database. The ACCESS database automatically updates the HTML documents among the approximately 1,000 HTML documents on the site.

Microsoft ACCESS, VBA ... Philip Morris, Westchester, NY
Designed and developed database application for managing software compliance. The database helped this client track compliance and test status for thousands of products… both information technology products and factory and infrastructure products. Included a process for consolidating information and providing it to all factory users even though the technology was not available for worldwide on-line updates. Information is also tracked for Business Partners. Follow-up functions provide notification of dates to follow up with vendors and when to initiate contingency plans for Business Partners that have high risk. Headquarters locations can quickly see the compliance status of their factory subsidiaries.

Microsoft ACCESS, VBA ... Philip Morris, Westchester, NY
Designed and developed database application for managing projects in Treasurer’s office. Created database of projects in the Treasurer’s office (examples of projects are capital expenditures, dividends, investments). Created methodology for scanning documents and linking them to the projects (examples of documents are approval signatures, photos of real estate, photos of machinery, letters, and memos). The system provides on-line immediate access to information that previously was difficult or impossible to locate.

Microsoft ACCESS, VBA ... International Bank, Manhattan
Redesigned and developed new improved version of Profit and Loss reporting system. Created new chart of accounts and system to permit client to change chart of accounts without requiring programming changes.

Microsoft ACCESS, VBA ... Philip Morris, Switzerland
In less than a month redesigned and developed database application for managing software testing and compliance.

Microsoft ACCESS, EXCEL, VBA ... Philip Morris, Westchester, NY
Designed and developed database application for budget reporting from major markets. Converted application from 80 separate Excel spreadsheets to on-line Access database. Created tables, queries, macros, Access basic code, forms, and a very complicated report that duplicated many separate spreadsheets. Created Excel macro to convert data for input to Access. The first consultant they hired quit saying that it could not be done in Access.

Microsoft ACCESS, VBA ... Philip Morris, Westchester, NY
Converted applications from old version of Access to latest version of Access.

Microsoft ACCESS, VBA ... Manufacturer's Representative, Poughkeepsie, NY
Designed relational database for sales analysis. Created tables, forms, queries, macros, Access Basic code behind forms and reports. Included customers, invoices, products, sales analysis reports. Allowed for the possibility of different manufacturers having the same customer number for different customers; and the same product number for different products.

Microsoft ACCESS, VBA ... Insurance Company, Manhattan
Background: A consultant suddenly quit a major Access development project. John McKinney was called in to analyze the state of the tables, forms, queries, macros, Access Basic code and reports. - Analyzed the work and documented it in detail. Resolved clients concerns. Retained the client for the consulting company.

Microsoft EXCEL, VBA ... Manufacturer, Poughkeepsie, NY
Created application with macros to track equipment loaned to a dozen different divisions.

Microsoft FrontPage; Outlook VBA, HTML; JavaScript ... Philip Morris, Westchester
Designed and developed Intranet website for information communication. Users throughout the company in diverse parts of the world can obtain information from the files of a central office. The site includes a search page that will search messages in Microsoft Exchange Public Folders.

Microsoft OUTLOOK/ Microsoft EXCHANGE ... Philip Morris, Westchester, NY
Designed and developed Public Folders application with Outlook forms and views. Created Visual Basic application to convert items in old 16-bit Exchange forms to the same items in Outlook 32-bit forms.

Download Word Version Resume Home Email John McKinney