Fred Scott Thompson       
1042 East Patten Drive  
Palatine, Illinois 60074   

Phone: 1.847.347.8649  

Email: Fred@FredScottThompson.com    

URL: http://FredScottThompson.com 

Profile: Creative, Hard-working IT and Web Professional who Leads Challenging Projects and Contributes Solutions

Capabilities:

- Roles: Team Member - Project Leader - Business Analyst - Technical Architect - Systems Analyst - Developer - Tester - Trainer - Support (24x7x365) - Manager - Team Leader - System Administrator  

- Languages: HTML/CSS/XML - JavaScript/AJAX - ColdFusion - PL/SQL - SQL - Shell - Progress 4GL - DOS - WSH - Java - Perl - PowerBuilder - FOCUS - COBOL - CICS - JCL - BASIC 

- Databases: Oracle - MySQL - Progress DB - DB2 - RDB - IMS 

- Applications: Consumer Response - Voice Response - Product Locators - Business Intelligence - Supply Chain - Application Security - Invoicing - Tax Reporting - Trade Payments - Accounts Receivable - Decision Support - Operations Research - Statistics 

- Platforms: Windows Server - HP-UX 11 - External Hosting - Linux - IBM Mainframe - VAX - Burroughs - IBM 8100 (DPPX) - BSD - Tektronics 4051

Experience: 

- PepsiCo  Chicago, Illinois  8/3/2001 - Present

.. Senior Specialist - PepsiCo Business Solution Group  11/1/2008 - Present
... Wrote adaptive routines to protect PepsiCo’s product locator from DDOS attacks.
... Provided seamless hosting transition for Consumer Response web applications. 
... Created Google Maps-based presentation of Frito-Lay's product locator results.
... Enhanced the maintenance system which enables PepsiCo's product locators. 
... Implemented 'Reply' forms to facilitate automatic routing of consumer responses. 
... Implemented standardized but differentiated 'Contact Us' forms for all PepsiCo brands. 
... Helped plan the outsourcing of hosting for PepsiCo's Consumer Response systems. 
... Provides enhancement to and 24 hour support for various UNIX-based batch systems.

.. Senior Specialist - PepsiCo International  6/27/2005 - 10/31/2008
... Created the back end which supports the product locators for all PepsiCo brands. 
... Created network monitoring tools which led to the solution of performance problems. 
... Implemented web-based quality reporting by building a report generator. 
... Performed programming to support pilots of a voice-response product locator. 
... Reduced the PepsiCo product locator reload time threefold by using parallel processing. 
... Designed and piloted new a process for receiving internet contacts from consumers. 
... Provided design and programming for the conversion of Frito-Lay Consumer Response. 
... Designed and implemented interfaces and conversion strategies for SAP deployment. 
... Established a standard deployment for PepsiCo's Consumer Response systems. 
... Created an interchange system to assemble and publish sales and production data. 
... Led the conversion of Quaker's Canadian Consumer Response system. 

.. Senior Specialist - PepsiCo  1/1/2003 - 6/26/2005
... Led the transformation of Tropicana's Consumer Response system. 
... Created the since-retired http://snackfinder.fritolay.com product locator site. 
... Supported and extended PepsiCo's Wilke-Thornton Consumer Response systems. 
... Applied Quaker web contact processing technology to Pepsi web sites. 
... Assumed support an out-of-maintenance business intelligence system. 

.. Senior Systems Analyst - PepsiCo  8/3/2001 - 12/31/2002
... Applied an architectural-level solution to change accounting calendars safely. 
... Supported and extended the Quaker Oats and Gatorade Consumer Response system. 
... Built a simple-looking front end to create complex Business Objects queries. 

- Quaker Oats  Chicago, Illinois  3/1/1985 - 8/2/2001  

.. Senior Systems Analyst  1/1/2000 - 8/2/2001
... Built an internal product information system using internal and external data. 
... Built a multimedia intranet site for consumer response which included reporting. 
... Stabilized a new [alpha-release] consumer response system and upgraded it. 
... Served on the hand-picked Y2K SWAT Team. 

.. Sr. Application Tech Support Analyst  9/1/1994 - 12/31/1999
... Designed and co-implemented an automated trade claims approval system. 
... Created tax reporting to meet regulatory requirements and to realize tax savings. 
... Provided ad-hoc accounts receivable systems to support a series of divestitures. 
... Created departmental decision-support environments using FOCUS. 
... Supported FOCUS and trained others to use it effectively. 

.. Senior Systems Analyst  9/1/1993 - 8/31/1994
... Created FOCUS reporting of various types against large DB2 tables. 
.. Applications Consultant  10/1/1992 - 8/31/1993
... Served on the Technical Architecture team for a conversion to a DB/2 environment. 
... Co-developed and used a framework for the mass production of report programs. 

.. Unit Manager  3/1/1986 - 9/30/1992
... Managed 10-20 programmers and analysts, both contract and permanent. 
... Managed support of post-shipment processing including invoicing and sales reporting.
... Oversaw the implementation of the company's first client-server application. 
... Led the team that shook out the batch portion of a new order processing system. 

.. Senior Systems Engineer  3/1/1985 - 2/28/1985
... Led invoicing enhancement projects which generated over $1MM annual savings. 

- G. D. Searle  Elk Grove Village, Illinois  2/1/1983 - 2/28/1985

.. Distribution Systems Manager  2/1/1983 - 2/28/1985
... Made technical and administrative reforms to stabilize a small data center. 
... Managed the turn around of lot tracking for drug recall purposes. 

- W. W. Grainger  Niles, Illinois  12/1/1979 - 1/31/1983
.. Senior Distribution Systems Analyst  12/1/1981 - 1/31/1983
... Co-designed and tested a stock locator for new 1.2MM square foot facility. 
... Designed a warehouse floor scheduling and control system. 
.. Distribution Systems Analyst  12/1/1979 - 11/30/1981
... Created a packaging optimization program which drew pictorial instructions. 
... Tested, rolled out, and upgraded the company's first automated work scheduler. 

- On my own  1/1/2000 - 12/31/2008

.. Web Development  2/2/2008 - 12/31/2008  
... Created an on-line gallery, http://YvonnePitts.com, for an artist. 
... Created a user-generated content site, http://EasyPhotoCube.com, as a dot com. 

.. Server Administration  1/1/2000 - 6/30/2007  
... Created a load-balanced personal web server cluster based on OpenBSD machines. 
... Upgraded a Linux SAMBA server and revised the backup scripts for an accounting firm. 

Education: 

- Claremont McKenna College  Claremont, California 
.. B. A. in Economics with emphasis in Quantitative Methods 
... My Senior Thesis explored cost vs. quality trade-offs for an analytical chemical lab.