Recent projects

Migration of MRP and engineering data to support sale of legacy product line

• Downloaded and filtered MRP item masters and bill of material to include only items related to the sale
• Created MS Access database to bridge the export of data from seller's MRP system and input of data into purchaser's MRP system
• Updated legacy engineering data files to use consistent file naming conventions and eliminate "8.3" filenames
• Identified and migrated engineering documentation to purchaser's network
• Authored desktop file retrieval application

Office setup and initial entry of legacy data into MRP system for startup company

• Coordinated with parent company resources to setup office space and furniture, install computers, printers and reprographics equipment and setup user accounts
• Investigated parent company MRP system, generated procedures and trained users in proper data entry and migration of data to new MRP system
• Established ISP account and created initial website

Custom database reporting

• Created custom reports for MS CRM environment using Visual Studio and MS SQL

E-Commerce setup for small business entering Internet market

• Established ISP account
• Reserved domain name
• Created email accounts
• Created initial website
• Uploaded product and pricing lists
• Trained end user in order fulfillment process and site maintenance

Implementation of Intuit Quickbooks Online Edition for non-profit organization

• Created chart of accounts
• Setup bank accounts
• Created custom reports
• Created user accounts
• Trained users in day-to-day bookkeeping activities
• Migrated year-end account balances from previous accounting system
• Provided walk-through assistance to users on first day of use

Assisted accounting group with database development

• Assisted in-house resources with query and report development for use by project managers

Promis-e CAD administration

• Updated Promis-e part database to include new parts from MRP system and update costs on existing parts
• Created MRP cost download utility and procedures to allow users to automatically update Promis-e part database costs from MRP system
• Worked with in-house personnel to troubleshoot design environment issues
• Created user manual to provide procedures to correct and eliminate common errors to ensure accurate costed bills of material

Resume     Accomplishments