Resume of Fred Scott Thompson

Palatine, Illinois 60074 United States
Download as PDF or as Word

Summary

Senior Application Developer with deep applications development, testing, troubleshooting, and implementation experience

Experience

PepsiCoBarrington, ILSenior Analyst
March 2011 - PRESENT

Technical and design lead on successful PepsiCo Global R&D projects

  • Enabled a proprietary analysis technology from a single-lab system to be used globally to reduce raw material inventory and improve testing speed and accuracy:
    • Re-engineered the system into a data-center-ready application using approved architectures to secure trade secret data including a separate vendor-facing portal to provide isolation between the internet and the sensitive internal data
    • Added multi-lab functionality and intelligent data access control to isolate the plant labs from each other and from the sensitive data available to the original lab
    • Designed and built the architecture needed to retrieve data from global labs
    • Co-designed and then automated the workflow between the quality analysis system and the pre-existing plant MRP system to save 15 minutes per sample
  • Provided better ways for consumers to self-serve or engage with PepsiCo
    • Redeveloped North American contact-us forms using the Sitefinity CMS
    • Redeveloped U.S. product locator user interface as drag-and-drop CMS widgets
    • Leveraged Sitefinity content to create brand-identified, light-weight mobile pages
  • Remediated IE8 dependencies to support enterprise-wide Windows 10 rollout
  • Lowered risk by reducing the attack profile of formula systems holding trade secrets
  • Helped reduce hosting costs by 40% by managing migration to a cheaper data center
  • Transitioned applications to offshore support to achieve cost savings
PepsiCo Business Solution GroupChicago, ILSenior Specialist
November 2008 - March 2011

Developed applications and supported Consumer Response's vendor solution

  • Improved hosting quality by migrating applications to a modern data center
  • Improved consumer engagement, data accuracy and call center productivity by consolidating the brand-managed North American contact-us forms into a single consumer-response-managed solution which preserved brand identity
  • Avoided security compliance issues by moving the consumer response system to its vendor's data center from where it could be consumed as SaaS
PepsiCo InternationalChicago, ILSenior Specialist
June 2005 - October 2008

Developed applications and supported Consumer Response's vendor solution

  • Designed and implemented a web service-based product locator for PepsiCo's U.S. brands which provides consumers with up-to-date information about as many as 90 million PepsiCo product placements in individual stores. By performing up to 75K searches per month the application saves PepsiCo roughly $1.2MM per year
  • Created economies of scale for IT and business stakeholders by converting Frito and Canadian call center solutions to the same solution used for Pepsi and Quaker Oats
  • Enabled reporting of North American finished product defect rates by:
    • Extracting the complaints from the consumer response systems
    • Integrating and providing the matching sales and production data
PepsiCoChicago, ILSenior Specialist
January 2003 - June 2005

Developed applications and supported Consumer Response's vendor solution

  • Reduced call center call volumes (and cost) by making Frito Lay delivery data available to consumers at the retired Snackfinder.com product locator site
  • Reduced Pepsi call center volumes by applying Quaker contact-us solutions
  • Reduced costs by consolidating Tropicana's call center solution with Quaker's
PepsiCoChicago, ILSenior Systems Analyst
August 2001 - December 2002

Maintained reporting and supported Consumer Response's vendor solution

  • Supported and extended the Quaker Oats and Gatorade Consumer Response system
  • Worked on the integration of Quaker Oats financial systems with PepsiCo's
Quaker OatsChicago, IL

Ran projects and managed a team of twenty before pursuing a techical career

  • Senior Systems Analyst
  • Unit Manager
  • Senior Systems Engineer
G. D. SearleElk Grove Village, IL

Managed data center for the Eastern U.S. and all finished inventory tracking

  • Distribution Systems Manager
W. W. GraingerNiles, IL

Business Analyst and Project Leader on projects of increasing responsibility

  • Senior Distribution Systems Analyst
  • Distribution Systems Analyst

Skills

Microsoft
  • Dot.Net
  • ASP.Net
  • C#
  • VB.Net
  • WinForms
  • WebForms
  • OpenXML
  • SQL Server
  • Windows Services
  • WCF
  • SOAP
  • IIS
  • Visual Studio
  • Azure DevOps
Web Development
  • HTML4 / HTML5
  • CSS2 / CSS3
  • XML
  • JSON
  • AJAX
  • JavaScript
  • jQuery
  • jQuery UI
  • jQuery Mobile
  • Prototype
  • Google Maps
  • Telerik Sitefinity
  • Cold Fusion
  • CDN
SDLC
  • Waterfall
  • Agile
  • Offshore
  • Change Control
  • Source Control
  • ITIL
Oracle
  • P/L SQL
  • SQL Loader
  • Oracle DB
  • MySQL
  • UNIX / Linux
  • Shell Script
Roles
(Click to Expand)
  • Team Member
  • Team Leader
  • Project Manager
  • Business Analyst
  • Systems Analyst
  • Technical Architect
  • Technical Writer
  • Developer
  • Tester
  • Trainer
  • Manager
  • On Call (24x7x365)
  • SysAdmin

Education

Bachelor of Arts (BA), Economics(Quantitative Methods)  
Claremont McKenna College, Claremont, California