Manufacturer

Here are some clients we have helped in the Manufacturer industry:

Client

Location

Project Description

Ryson Conveyor Yorktown, VA We were subcontracted to Ryson through our network engineering strategic partner Network Technologies and Solutions (NTS). Ryson's Chief Operating officer had been slowly putting together and Access Database to replace a series of complex Excel files in order to manage the process of building conveyor belts. We took over the Access database, enforced naming conventions, developed easy to use navigation forms and maintenance tables. Now this conveyor manufacturer has a backbone database application that provides completion timeline information to the engineering departments, the manufacturing departments, the finance departments and the sales department. A calendar is created for everyone to see. Huge printouts showing all current projects and the people needed to sign off are printed out and put up throughout the facility. We hope to replace these with direct feeds to monitors.
Ferrara Candy Chicago, IL Ferrara Candy is a Candy Manufacturer the produces Candy in the United States and Mexico. Our Access database tracks, manages, and reports the overall equipment effectiveness of the manufacturing plants.
Ritchie and Associates Philadelphia, PA Ritchie is a management consulting firm that was working for Fortune 500 firm Meadwestvaco (now WestRock). They were advising the paper and packaging firm to build an historical demand based Access Database. This Access database was used to manage inventory for their paper packaging manufacturing client: MeadWestvaco (Fortune 500) in Richmond, VA. It incorporated not only ERP fed historical demand, but also provided advanced logistic support to this Paper and packaging corporation. This Access database determined optimim supply levels in plants and warehouses throughout the US including Maine, North Carolina, Ohio, California, Texas, Colorado, Washington, Oregon, and Michigan.
Simpson Strong Tie Baltimore, MD Built New Batch process tracking Access database to manage the production and shipping of batches. Simpson Strong Tie is a Fortune 500 company that strategically uses Access Database to manage department activities
Uptime Solutions Richmond, VA Quality tracking and improvement Access database for a manufacturing firm: Greystone in Toano, VA (near Westpoint and Williamsburg). This application receives multiple excel files throughout the day that are produced from quality control machiney in the plant. The excel files are imported to the Access database automatically. The Access database scrolls through the excel files, parsing out the relevant information from the excel file and appends the relevant data points to a table that is then used to run monthly and quarterly quality control reports. The data is pertinent to the automobile manufacturing process and determines which production batches should or should not be accepted for Greystones automobile manufacturing clients. We built this database through our strategic partner: Uptime Solutions, a premier network integration and engineering firm in Richmond, VA and Tampa, FL.
Sycom Technologies Richmond, VA Access Database to track Employee Stock Distributions. Sycom's client, Tredegar Industries, needed to get out of a Lotus 123 Spreadsheet and into an Access database. We converted they're advanced Lotus Macros and now they create distributions, deposits, etc. for their stock plan with the new Access database. We were the Microsoft Access Database programmers for this project
ActivSupport New York, NY Partner/Subcontractor to fix various Access, SQL Server, and Sharepoint Databases for their clients in Charlottesville, VA. Active Support needed an expert database company to support their clients without having to worry about the end results. Keeping their client happy was most important to ActivSupport. Our Access database skills helped them.
MatlenSilver Group ltd. Richmond, VA Partner / Subcontracted to their Tobacco /Food Manufacturing Philip Morris (now Altria) for Manufacturing Training Tracking in Richond, VA. Matlen Silver is a staffing firm with a contract at Altria, the tobacco and food products giant. Altria desired to track which employees had what training in their plants and what certifications were going to expire. This Access database tracked that information and provided reports to help schedule future training of employees
Networking Technologies and Support Yorktown, VA This Access database for a conveyor manufacturing company tracks is a project management database with multiple dates for the completion of manufacturing and engineering tasks with advanced calendaring.
Tredegar Corporation Richmond, VA About Tredegar: Deeply rooted in manufacturing, Tredegar Corporation is a global operating company with industry-leading businesses in the plastic films and aluminum extrusions markets. We were engaged through one of our strategic partners to help Tredegar manage a special bonus functionality in the Human Resource department. We've built many commission and bonus related Access databases in a variety of firms including Fortune 500 Altria and more, so we were well positioned to referred to Tredegar for this Microsoft Access database consulting engagement. Tredegar has a Lotus 123 spreadsheet (yes! Lotus 123) for keeping track of retired employees and the distributions those employees choose to take out of their retirement. Tredegar asked us to convert this Lotus 123 Spreadsheet into an Access Database. The new Access 2013 database will replace the Lotus 123 spreadsheet functionality of managing and administrating this human resource function of retired employee distributions. We were the Microsoft Access Database consultants for this project
Pepsi Bottling - Tulsa Tulsa, OK Build Access database - Manufacturing Process Efficiency Tracker
WestRock Glen Allen, VA Build Access database for Fortune 500 paper and packaging company. Database manages 1 Billion of Inventory

Contact



Our Process

  1. Discovery Conversation
  2. Agree to scope of work
  3. Test plan creation
  4. Iterative database development with client input
  5. Database rough draft delivery
  6. Database final implementation
  7. Database user documents
  8. Database developer documents