Our client - A Subsidiary Of MARS, Inc.

Our Client - Wrigley, a Subsidiary of MARS, Inc.

The William Wrigley Jr. Company based in Chicago, Illinois is ranked #482 among Fortune 500 companies. Wrigley is a recognized leader in the confectionery field and the world's largest manufacturer and marketer of chewing gum. The company markets its world-famous brands in more than 180 countries. Three of these brands - Wrigley's Spearmint®, Juicy Fruit®, and Altoids® – have heritages stretching back more than a century. Other brands include Doublemint®, Life Savers®, Big Red®, Boomer®, Pim Pom®, Winterfresh®, Extra®, Freedent®, Hubba Bubba®, Orbit®, Excel®, Creme Savers®, Eclipse®, Airwaves®, Alpine®, Solano®, Sugus®, Cool Air®, and P.K.®.

Their Problem – Not Enough Functionality for Product Specifications

The company has several divisions operating from its Global Innovation Center in Chicago on Goose Island including Quality, Research & Development, Packaging Innovation, and Global Engineering. These departments needed a solution to maintain a database of specifications. Packaging engineers routinely develop new specifications. It was important that these documents be stored for retrieval by production personnel and third-party vendors. Several departments were using an Excel-based solution that was lacking in functionality, versatility, and in ease-of-use.

Our Solution – Custom Production Specification System

The Wrigley Company selected alligatortek to develop a new customized solution that would help with the transition from its current Microsoft Excel application to an inter-department application to manage specifications. The customized Microsoft Access-based product enables engineers to build new specification documents based on a series of thirteen pre-defined templates. Each document begins in an experimental state and is then published and finalized by the author. Production personnel can then query the system based on a series of design parameters.

This Microsoft Access database application provides for engineers worldwide to input and query on engineering specifications. The parameters are stored in a centralized SQL Server database hosted at a data center at Corporate Headquarters.

alligatortek has been supporting and updating the system for over 7 years. As technology and systems have evolved, the system has been continuously updated to use recent technology and satisfy new requirements from Production Engineers at Wrigley.

Software Used: Microsoft Windows 7, Microsoft Windows Vista, Microsoft Windows XP, Microsoft Access 2007, Microsoft Access 2003, SQL Server 2005, SQL Server 2000, Windows Server 2003, Adobe Acrobat Reader

Company Industry: Consumer Goods, Confectioners

  • A Transportation and Logistics Company

    The great benefits of working with alligatortek is their depth of knowledge within our industry, their retention, their notes, their ability to go back and truly understand our industry from the groun...
  • A Non-Profit Domestic Hunger Relief Organization

    The old process we used was frustrating because it required our donors to manually enter a lot of information, and when you’re out on the farm, it’s difficult to get to a computer to do that. With the...
  • A Premier Hospitality Group

    The process by which alligatortek approached our new website design was incredible. They asked the right questions, we provided them with information, they collected the data and came up with a brand ...
  • Chicago Community Trust

    Your team has been great in understanding our business needs. You continually translate these needs into successful projects on budget with a smile.
  • New Jersey Primary Care Association

    My organization has used the services of alligatortek for a number of years. They have yet to fail us! They are responsive and thoroug...
  • Large Manufacturing Plant

    We have happily been working with alligatortek since 2007 and are very satisfied. Every major project has been implemented by the desi...
  • Chicago Botanic Garden

    alligatortek architected, upgraded and executed the Chicago Botanic Garden’s Plant Records database and Plant Production database. The...
  • Wm. Wrigley Jr. Company

    I want to thank you for your help…This [system] works fabulously.
  • OSI Industries

    alligatortek did an outstanding job translating our needs and wants into a workable program, and after the development I have been ver...
  • Lettvin Development Company

    alligatortek has done a terrific job for us in our Web based customer service data base. Our company depends on this system continuall...
  • Pallay Insurance Agency, Inc.

    alligatortek designed and implemented a database for our firm a decade ago. Since that time they have made a number of updates for us ...
  • Chicago Botanic Garden

    [The alligatortek staff is] extremely knowledgeable and great to work with, willing to go the extra mile and work with us until a prob...
  • O'Donnell Homes

    I am 100% satisfied. The site turned out great. You have been very patient with my lack of 'tech savvyness'. alligatortek was very ple...
  • Mickey's Linen

    I feel as if Mickey’s Linen hit the jackpot when we found alligatortek. We started out by giving them a few small SQL projects to do s...
  • HandsOnSite

    alligatortek was great to work with. As I small business owner, without our own I.T. person, I needed to believe I could trust that th...
  • A Zoological Garden

    The team is transparent, honest, and truly looks out for what's best for the client.
  • EFE

    Your company has completed several projects for us and we've been extremely satisfied with all of them. Your staff is very knowledgeable, accessible, professional and easy to work with.
  • Bulk Material Handling and Storage

    You've been a pleasure to work with and have done a great job customizing our database to the unique requirements of our specific application.
  • Southside Landscaping

    I was completely impressed with the help I received from alligatortek...I am not very computer literate but you made it easy for me to...
  • CPI

    alligatortek is always friendly [and] very customer service orientated by being attentive to our company’s needs and requests. [They] ...
  • Judicial Attorney Services Inc.

    You continue to do an excellent job with the design, updating and maintenance of our company program. Work is performed in a timely and professional manner. I could not ask for more. Thanks for all th...
  • Bimbo Bakeries USA

    alligatortek’s experienced staff worked diligently to come up with a solution to our reporting needs. They shared their extensive know...
  • American Board of Endodontics

    alligatortek fixed the issue and it is ready for me to pull the report – this has saved me the hours of work that doing it manually would have required. alligatortek was a delight to work with and so ...
  • Chicago Botanic Garden

    I am forever in your debt! The problem you fixed has been a bug-a-boo haunting the website for months!
  • Calumet City Plumbing Co., Inc.

    We are impressed with the website services alligatortek provides. The ease & speed of our website updates makes our relationship hassl...
  • The Association of Michigan Basketmakers

    Oh my goodness – I LOVE IT!!!! You guys are doing an AWESOME job!!!! I have been looking through each screen and [I] am so happy. I can’t say enough [about] what a great job you are all doing. Thank y...
  • All About The Children

    The site looks great. Thank you and your team very much for the great job in the facelift!
  • American Medical Technologists

    The work that alligatortek performed was terrific. The [billing] process has been running smoothly for us. Work completed July 2010
  • MBT

    You did an outstanding job developing an application for my group. The application met all of our needs (and more), was well thought out, and was delivered on time and on budget. Plus, your team is ju...
  • MEDRAD Inc.

    Your support staff is always prompt to respond and is extremely knowledgeable. I feel confident that my requests will be handled promptly.
  • Wm. Wrigley Jr. Company

    It has been a pleasure working with you and [your team]. Thanks for your help.
  • HandsOnSite

    alligatortek responded to my small business computer crisis with speed and professionalism. They listened and understood my problem, I...
  • Pulmonary Fibrosis Foundation

    Very professional, courteous and customer service oriented. We were very pleased with our end result.
  • SAFC Biosciences (Sigma-Aldrich)

    Your team is fantastic to work with and extremely responsive. I inherited a project that was several months old with your group and you helped me get up to speed and worked with me as if I had been on...
  • Shelbourne Development Group, Inc.

    You’re first off always so nice! Secondly, totally thorough and quick-to-respond – you’re awesome!!
  • Large Manufacturing Plant

    We have happily been working with alligatortek since 2007 and are very satisfied. The entire staff is knowledgeable and professional, ...
  • South Suburban Mayors and Managers

    [You] have been able to [develop] a reasonably complex web site and have it professionally maintained with issues being handled quickly.
  • USF

    I have worked with alligatortek for the past two years and I appreciate the personal interest put into my projects and software develo...
  • Wireless Training Department

    Wow!! I really like what you and your team have accomplished. I do like the fact how I can edit the dropdowns in the database. This function is very easy to use!
  • Village of Phoenix

    The staff at alligatortek did an excellent job of building our web site and providing our staff with valuable service for future web s...
  • Jennifer Nelson, LLC

    Recently I had the crippling issue of not being able to receive new emails on my business account. No matter what I tried, I could not find a fix. My employer directed me to a specific person at allig...
  • Accurate Personnel, LLC

    No matter what the inquiry, I know I can always expect patience and flexibility from the staff at alligatortek.
  • A Zoological Garden

    Great people to work with.
  • Royal Group

    They get things done on time and are very easy to work with.
  • Illiana Financial

    Epitomizes the philosophy of people helping people.