Williams Computer Consulting

                                               Software Makes 'em Work!

Our computer consulting company specializes in .Net Framework, Visual Basic, Databases, Access, Excel, Microsoft Office, SQL Server, Web Developer, ASPX and HTML. Put some real management tools to work and stop using your abacus.

Jason Gabriel Williams

Personal Data

Phone: (740) 973-4562

E-mail: RonAndJason@WilliamsComputerConsulting.Com

Web Site: WilliamsComputerConsulting.Com

Education:

I graduated early from Newark Senior High School in January 1994. After graduation I started an apprenticeship with my father, programming computers. My dad’s teaching experience, coupled with our synergy, has made our teacher/student relationship both insightful and fun. We have been partners in Williams Computer Consulting for years and we have worked on many challenging projects together.

I attended college at The Ohio State University Newark branch. I am in the pursuit of a degree in computer and information sciences with emphasis on business. My first quarter I made the deans list and one of my papers was published.

I attended vuSME virtual university for two classes: International Market Research and Enterprise Development. Topics covered: Internet strategies for business, web technologies, electronic commerce, and on-line marketing resources. The university web address is http://www.vusme.org

I have completed 30 tutorials on JavaScript through Earth Web at JavaScripts.com. The topics 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 TrainingCenter.com.

Experience:

Williams 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 Touches in Pataskala , Ohio ). They had a need for a package where they could combine many components and raw materials, and labor hours into a set. We created a way to Record Receipts to Stock and Sales data to maintain Balance-On-Hand information. We are currently turning this Custom Visual Basic / Access Database into a Package anyone could use. More info if requested.

            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).

Independent Trailer Services                                     Dayton , Ohio

                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.

Label Graphix, Inc.                                                   Heath, Ohio

I researched 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.

Caine Corporation                                                    Hebron , Ohio                         

I helped modify programs for this manufacturing company (Bill of materials Clipper software).

Heisey Collectors of America                                   Newark , Ohio

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.

Go International Model Management, Inc.          Columbus Ohio

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.

Midcon Petroleum, Inc.                                            Newark , Ohio

I flowcharted this oil company’s FoxPro software.

Appletree Auction Center                                          Newark , Ohio   

I flowcharted this auction center’s FoxPro software.

Interleave Systems                                                     Heath, Ohio

I designed 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 sales force.

Food Pantry Network of Licking County               Newark , Ohio

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.

Zippy's Antiques                                                           Alexandria , Ohio

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 – Access – Crystal Reports) package to help keep track of auctions, sellers, buyers, emails, receipts, and expenses. It prints checks, labels, mail insurance claims, reports, envelopes, and more. The software has advanced search capabilities that make it easy to find or filter information.

Assured Protection, Inc.                                             Newark , Ohio

I helped 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. 

H&W Transportation                                         Heath, Ohio

            I helped rewrite a shipping broker package (Accounts Receivable & Accounts Payable) using Access Databases, Visual Basic front end, and Crystal Reports. This package handles load information between shippers and carriers. It prints invoices, statements, checks to carriers, cash requirements report, aging reports, find carrier to help cover a load, and much more.

Victoria’s Secret Stores                                              Reynoldsburg, Ohio  

                Victoria ’ Secret has utilized me in many different areas both as a temporary employee and as an independent contractor.  I believe my attention to detail and my ability to keep track of information is the reason they have used me in so many ways.

              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, Crystal Reports, and Microsoft Office to keep track of survey data. For each survey I created a user interface for the entry and manipulation of data and the printing of Crystal reports. I also created over 100 spreadsheets.

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 network with Crystal Reports.

I 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.

Mast Industries Inc.                                          Reynoldsburg , Ohio   

          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                                                                   Carrolton , Ohio

                Kolbus Controls is involved very much in PLC programming, specializing in Electroplating.

Working with them,  I have written the software to control several very large Robots.

                For Masterguard Electroplating in Veedersburg , Indiana we created a robot that monitored and controlled 14 Hoists, 128 Tank Locations, 100 Storage Locations, Six Elevators, Three Shuttles and around 50 other motors. This software was written in Visual Basic hooked to Access Databases and PLCs.  They chrome plate bumpers for the auto industry.

                For Rolls Royce in Indianapolis , Indiana we created a robot that monitored and controlled a One Hoists, 19 Tank Locations. This software was written in Visual Basic hooked to Access Databases and PLCs. The hoist did its thing based on part recipes which included the timings for all the tanks along with Rectifier information (Amps/Volts), drain times, etc. They copper plate jet engine parts for aviation industry.

                For General Super Plating in Syracuse , New York we created a robot that monitored and controlled 6 Hoists, 70 Tank Locations. This software was written in Visual Basic hooked to Access Databases and PLCs.  They chrome plate plastic handles for razors among many other things.

 Ampacet                                                                                             Heath, Ohio

                                                                                                            Queretaro , Mexico

                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 Mexico . It is expected to take six months to a year to integrate their corporate enterprise software into the mix, so they needed some software that would allow them to open the doors and start it up.