Williams Computer Consulting
Software Makes 'em Work!
Our computer consulting company specializes in Visual Basic, Access, Excel, Microsoft Office and HTML. Put some real management tools to work and stop using your abacus.
Jason Gabriel Williams
I graduated early from
I attended college at The
I attended vuSME virtual university for
two classes: International Market Research and
I have completed
covered were: error messages,
dates and times, event handlers, prompts and variables, properties, hierarchy of
objects, functions, after-effect commands, math variables, calling functions
with forms, passing information to the function, creating random numbers, if and
branching, if/else statements, for loops, while loops, arrays, animation, and
form field validation.
I have completed
6 Visual Basic classes, and a relational database management systems class at
Computer Consulting Packages
Service: This package allows a service company to track events and manage their books. An event flows through the software from scheduling, assigning to employees, completion of task, billing, invoicing, cash receipts, statements, and payment to employees. There is a 12-step payroll that figures tax, prints checks, hardcopy reports and more. The Circular E is now 66 pages long this software makes it easy. More info if requested. (Visual Basic / Access Design)
Retail: We developed an Inventory package for one of our customers (KRW Added
Accounts Payable: Every business has trouble keeping track of their checkbook. This software makes it easy. If you can use a checkbook you can use this software. We have incorporated easily used expense accounts, Default Expense Account #ís, a means of tracking petty cash, and all of our reports are based on date ranges. More info if requested. (Visual Basic / Access Design).
Using Visual Basic and Access I helped design and write an Accounts Receivable,
Inventory, Invoicing, Sales Commissions, Payroll, Trailer Rental, Storage
Garage, and Accounts Payable system.
several subjects on the World Wide Web. I installed a backup tape drive and
performed a backup. I installed a touch sensitive mouse into a Win Book laptop.
I helped prepare and present an ACT software course. I prepared a board meeting
presentation for a major multi-year plant expansion. I helped create eight hours
of Microsoft Office classes in PowerPoint. I helped create a package to keep
track of, and report on, EPA Volatile Organic Compounds (VOC) Emissions. The
package interfaces Access and Visual Basic with Excel (Color Formula Documents)
and calculates the VOC emissions.
I helped modify
programs for this manufacturing company (Bill of materials Clipper software).
I helped develop
a Microsoft Access database system. One piece of the system creates mailing
label reports that pre-sort their mail to cut their operating cost. The software
also creates a member lists that helps them track various types of members.
International Model Management, Inc.
I performed a
needs-assessment for this model management agency. Go International then
utilized me in many areas. I developed a model database. I helped them with some
accounting options. Parts of my duties were to scan and manipulate photos. While
I worked on this project I used ACT, Microsoft Windows for Workgroups, Peachtree
Accounting, and Microsoft Word and Excel.
this oil companyís FoxPro software.
this auction centerís FoxPro software.
and presented a multimedia presentation explaining the software of a print and
apply label system. The print and apply system would print a bar-coded
label then apply it to a product (bag in a box) or a pallet full of product on
Cokeís production lines. This presentation also proposed a hand pack label
system for smaller businesses. The hand pack system was a user-friendly
graphical user interface, which allowed users to use standard label formats to
label their product. I presented this to part of the Wisconsin Label Groupís
I designed an
inventory tracking system that would track where food came from (local donor,
food drive, government agency) and where food went (Pantry, soup kitchen,
shelter). The package allows them to generate invoices and summary reports. I
wrote this package using Microsoft Access.
I educated the
owners on the World Wide Web and the technologies surrounding it. I designed and
implemented a web site to test the market for rare antiques on-line. I have sold
200 items on eBay for them. I designed an auction-listing (Visual Basic Ė
convert this preplanned funeral trust's software from a Dos 1.1 operating system
that used the GWBasic programming language to Microsoft Access. We converted
their data by writing a program in GWBasic that would throw all of the fields
into a comma-separated file. Then we pulled the comma-separated file into an
Access database. Then we wrote a Visual Basic front-end user-interface to
manipulate and propagate the data.
I helped rewrite a shipping broker
package (Accounts Receivable & Accounts Payable) using Access Databases,
Visual Basic front end, and
I worked in the Accounts Payable Department as an auditor. Duties
included: matching invoices to receipts, data entry, resolution of cost
differences and unit differences, charge backs, filing, record retention, and
auditing checks and invoices. I used a Lawson interface to connect to an AS400
to enter and retrieve data. I was able to link Access tables to the AS400
databases through ODBC (open database connectivity) to query data. I also
modified and created several Excel spreadsheets.
I worked in the Textile Technology Quality Assurance Department assisting
textile technologists with the color approval process. I helped the laboratory
technician with the testing of fabrics & garments and created reports based
on results. I created 30 report formats based on tests put forth by the American
Association of Chemists and Colorists & the American Society for Testing and
Materials. These reports will be used by Limited Brands testing facilities and
by the Limitedís vendorís laboratories for the testing of fabrics, garments,
and garment accessories. I also created an accredited laboratory spreadsheet.
The spreadsheet lists the vendor laboratories and what tests they have
been accredited to run.
I worked for the
Human Resources Stores Department as a programmer. I wrote three software
packages using Visual Basic, Access,
I created a
weekly reporting and activities package for the Human Resources Home Office
Department. This package allows associates in the department to communicate the
who, what, where, when, why, and how of their jobs to their manager. This
package has a Visual Basic front end connected to an Access database on a
designed a labor scheduling projection tool for the Financial Planning and
Analysis Department. This
application looks at the distribution centers outbound projections (which are
broken out into categories) and an individual storeís contribution to the
overall company (based on historical selections) and the amount of time it takes
to process a category item to project the number of hours to schedule for
processing the incoming inventory. This project had many interesting exceptions
to handle; such as, new stores, relocation/remodeling stores, stores not
included in the distribution centers projections. With the exceptions handled
and a good process created this tool helps to bring the future into focus. Tools
which enable you to see the future can greatly improve the bottom line.
I filled in for a
textile technologist on maternity leave.
One of my duties was to visually evaluate color for garment trims. Using
a light box to compare trims to color standards and bulk history I would approve
or reject lab dips and bulk lots. Then comment on the approvals or rejections,
to help give direction to the vendors. I
would submit elastics, fabrics, and garments for testing and based on the
results approve or reject the item. Then the information is reported to vendors
and designers. All of these tasks generate a lot of data. So I have become
familiar with Web PDM a global database package.
After finishing this position I continued to work on an Excel spreadsheet
project. The spreadsheet helps merchants communicate their purchases or desired
purchases to the Quality Assurance department. Based on the merchant selection
of buy type the spreadsheet adjusts testing defaults and displays remaining
options. When Quality Assurance
receives the merchant work request, they know exactly what needs done.
Kolbus Controls is involved very much in PLC programming, specializing in Electroplating.
Working with them, we have written the software to control several very large Robots.
For Masterguard Electroplating in
For Rolls Royce in
For General Super Plating in
We created an Access Database Visual Basic project that keeps track of
Customers, Orders, Scheduling, Raw Materials, Finished Goods and Recipe
information for this large plastics manufacturer, that was opening a plant in
Newark, Ohio (740)-281-0671 RonAndJason@WilliamsComputerConsulting.com