CHERYL TUPPER

cheryl@sdwebpro.com 619-934-6761

Experienced Project Manager Web Presence Designer Microsoft Certified in Solution Architectures

9+ years upper-level business operations and project management experience, including inventory, logistics, forecasting and performance metrics, cost analysis and teambuilding.

6+ years applications development using HTML, SQL, SQL Server, ASP, Visual Interdev, Access, Excel, VB5, VB6, FrontPage, VBScript, and COM; almost 2 years help desk experience including support for Access, Excel, FrontPage, and Visual Basic. Graduate study in database design; significant DBMS design and admin experience.

Skill as a liaison, building strong working relationships between organizations and between organizational units. Well-developed ability to clarify and document project requirements.

Highly motivated, superior analytical, statistical, organizational, and communications skills. Experienced chairing projects and presenting results.

EDUCATION

Bachelor's (cum laude)	Psychology & Computer Science	Texas Tech University
Post Graduate work	Statistics and Outcome Measurement	University of Washington
Master's Candidate	Information Management	Seattle Pacific University
Software Engineering	Certification Prep (A+, Net.Ess. and VB)	Seattle Community Colleges

CAREER HISTORY AND ACCOMPLISHMENTS

12/2000-present      IT Business Consulting and Development     Solution Architech
My independent consulting firm offers its business customers complete IT solutions, from implementing networks, phone, security and POS systems to developing accounting packages, business applications, and internet presence.

11/2000      Develop, Test, and Document Operations Application      Amazon.com
For Amazon.com's Enterprise Integration Group, I developed, tested and presented a standardized form for their various supply partners' transfer of catalog information to Amazon's datawarehouse. This project was successfully completed ahead of schedule and under budget. For more information, contact Sean Dodson, sdodson@amazon.com

• Responsible for intranet and business applications development using, primarily, Visual Basic, Access and Frontpage on Windows2000 web servers with IIS 5. One major project I completed at PSE was automating the capture of data from a legacy telephony system at the IT Helpdesk and developing an application for analysis of demands and Helpdesk performance. I also provided expert, or Tier 2, support for Microsoft applications and primary support for the Puget Sound Energy Intranet. For more information and recommendation, contact PSE IT Manager, Chris Deitz, cdeitz@puget.com or Senior Analyst, Joel Chrisman, jchris@puget.com

• Document Manager and Assistant Project Manager for the WWOPS Scorecard, a major metrics integrity project, employing SQL Server 7.0 stored procedures, output to Access for display on the intranet, with VBA pivot table and chart drilldowns. I documented agreements as to World Wide Operations metrics definitions, utilized MS Project to establish and maintain schedule, and created Visual Basic routines to display data.
• Team and solo development of tools for Microsoft's intranet using Visual Source Safe, ADO, Visual Interdev, SQL Server 6.5 and 7.0. I developed a SQL stored procedure to calculate sales for the Greek Tax Commission.
• My other duties at Microsoft included using a Siebel Enterprise service manager to provide primary help desk support for an order entry tool used on the Microsoft world wide intranet. In conjunction with this support, I created a database of user information and a database update tool for Microsoft's intranet using Visual Source Safe, ADO, Visual Interdev, VBScript, and ASP2, which allows users to maintain and update their records via the intranet. For more information, contact Joni Farley, IMG Manager, Microsoft (425) 703-9460 or click here to see her letter of recommendation.

• Created a database management system to capture all student and course information relevant to the Distance Learning Program. This system quarterly inputs course and student data from three separate legacy systems, and consolidates the information into normalized Access tables. For more information and recommendation, contact Dennis Colgan, Director, Distance Learning Program, SSCC (206) 764-7930

• Managed inventory control department using a computerized MRP system, for Fortune 1000 company. My systems analysis and restructuring of the raw steel supply chain resulted in a savings of 15%.
• Chaired production project resulting in most efficient annual inventory count in the plant's history; chaired project to create inventory cycle count system.
• Created and implemented database of MRO inventory items, including conversion routines to the legacy system..

• I design and implemented ACC's first PC departmental LAN, consisting of five stations, including an image archiving workstation, shared physical resources, and terminal emulation to the company mainframe.
  
• Served as DBA for an Access DBMS with a Watermark front-end, used to archive purchasing history. In this, I improved procedural efficiency, throughput and the amount of data handled by the system. I also wrote several applications for my department including their Purchase Order Log.
  
• Using Access with Excel VBA input routines, I designed and implemented a procedure to track, index and distribute Material Safety Data Sheets (MSDS) and their respective chemical products in compliance with OSHA. In addition, using straightforward forms, clerks input percentages of hazardous chemicals shown on the MSDS and the unique MSDS number associated with each product and size. At the end of the year, purchasing history is input, resulting in accurate hazardous chemical consumption counts, as required annually by the EPA. For more information and recommendation, please contact Patricia Cecchini, Buyer, ACC (206) 382-8223

• Here I was part of a team which built a warehouse locator for use in Krusteaz' largest warehouse. The output from the tool was used by forklift operators, who put together orders and counted inventory. Output consisted of the shortest path through the warehouse necessary to gather an order, taking into account product age.

• Hired, supervised (and occasionally fired) a varying staff of artists, art students, and salespeople.
  
• Using Microsoft Word and Excel macros, I designed, implemented and administered a point of sales (POS) data management system for galleries to capture sales, payments to artists, and customer information.
  
• In 1992, I began putting together the team that developed hyperart: one of the first on-line art galleries. Between 1993 and 1995, hyperart featured dozens of NW artists, thumb-nailed catalogues that opened to download full screen-sized images of each piece, with descriptive text for guests to read while the image downloaded over 14.4 or 28.8 modems. hyperart also hosted live web transmissions in 1994 and was one of the first sites to use jpegs, counters, and online ordering.

• Supervised purchasing, working closely with Estimators and Engineers; producing 3000 contracts annually.
  
• Developed departmental library and organizational flowcharts to improve supply systems.

• Work culminated in a scientific publication, which I co-authored with Professor Neil Jacobson. Click here to see Prof. Jacobson's letter of recommendation.

A Certified Toastmaster, published author, and published statistical programmer