COMBINING IT & ACCOUNTING FOR RESULTS
ROBERT J YORDE
Home
About Me
Contact Me
Project List
Client List
Related Links
resume
Home | About Me | Contact Me | Project List | Client List | Related Links
Phone & Voice Mail: 614.888.7076
Cell: Don't use 614.940.8140 after 3/10/08
E-mail: [click the envelope above]
TO CONTACT ME by email, click on the envelope:
OBJECTIVE
Project, Contract Or Temporary Opportunities in central Ohio needing a mixture of IT skills, business operations knowledge and accounting aptitude. Situations requiring problem-solving, meaningful communication with all levels of staff, and results-oriented outcomes are ideal. Specializing in MS Access applications, MS Excel macro creation, data conversion, custom report development, data validation and application interfaces.
RECENT WORK HISTORY
Independent Consultant 1992—2004
Provide consulting to small and mid-market companies in a six state area, combining theory with reality to produce results. The business is based on integrity, honesty, reliability, fair rates and the commitment to deliver the highest skill level appropriate for the particular engagement.
Owner – Columbus Computers and Laptops 2005—2007
Repair and sales of personal computers and laptops in Central Ohio through five small retail outlets and an online store. Specialized in hard-to-find parts for older systems. The business emphasizes personalized service, guaranteed products and reliable service. Business closed during 4th Quarter, 2007.
AREAS OF EXPERTISE
· Data Conversion
· Interfaces between applications
· Data Collection, Normalization and Preparation for upload to accounting systems
· Custom Programming
· Report Development
· Application Implementation
· IT Project Management
· Procedure Documentation
· End-User Application Training
PROJECT SYNOPSYS
Directed historical data conversion for over forty new ERP implementations in a variety of industries including automotive, electronic component, printing, capital equipment and machine shops for users of Symix. Many of these engagements used MS Access or Excel.
Implemented shop floor data collection using bar coding in over ten sites for labor reporting, time & attendance and inventory control for users of Symix; included development of many custom reports
Designed, wrote and implemented a custom data collection and normalization program for high-volume business in the aggregate industry using SAP; included presentations to EDP committee, Division management committee and Board of directors
Design, set up, train and implement an insurance application tracking methodology for a large insurance agency over an eight-month period using MS Access
Directed data conversion efforts using 4 sub-contractors for $85M make-to-order manufacturer from fifteen year old, heavily modified, legacy software running on a proprietary operating system to standard ERP software on Unix
Created custom programs and modified standard programs written in 4GL database (Progress) during 18-month project for $25M fabricator and distributor of abrasive products
Developed custom macro programs for Excel and Word users, eliminating manual operations and saving time for many clients
Developed Activity Based Costing (ABC) application with MS Access for manufacturing client
Developed inventory control application with MS Access for tracking maintenance, supply and other materials in a manufacturing environment
Prepared custom database and multiple reports using MS Access for accounting department of large manufacturer to extract job, project and inventory costs from Macola
EDUCATION
Ohio Wesleyan University Delaware, Ohio BA
Ohio State University Columbus, Ohio MS
Visual Basic for Applications (VBA)
SQL
Progress 4GL
Microsoft Access
Microsoft Excel
Microsoft Word
Crystal Reports
Symix ERP
BMG Seltec
QuickBooks
Last Modification: 3/8/2008