Computer system and database developer, with strong statistical analysis skills, and extensive experience creating mathematical models.
  
KEYWORDS: Software Engineering, Visual Basic, VBA, SAS, SPSS, Lotus Notes, Java, UML, Oracle,
            Visual Studio, Case Tools, Mathematical Modeling, ERP, Project Management, MS Office, SQL,
            MS Project, Visio, ERWIN, Case Tools, Unix, Windows, Crystal Reports, Active Reports, OLAP, 
            SDLC, CMM, Roscoe, Librarian, RoboHelp , Doc2Help, User & Systems Documentation, HIPAA.

MS Access Experience:
· Niagara Mohawk Power Corporation - reporting from the plant asset database
· Xerox Corporation – finance department
· Thompson Consumer Electronics – return parts
· Qualex  (Kodak) – photo finishing database
· Philips Broadband Networks (Motorola)
(1) Sales tracking
(2) Training schedule tracking
· Meals on Wheels – scheduling  
SQL Server Experience:
· New York Compensation Managers
· Amtek Corporation
· I2eyenet,com

Lotus Notes Experience:
· Error tracking
· Safety tracking
· Maintenance scheduling
  
Visual Basic Experience:
· Niagara Mohawk Power Corporation – graphical display of energy consumption
· NY Comp Managers – Workers Compensation Claim Tracking
· Taught Visual Basic at Syracuse University
  
Java
· Parts Maintenance

SAS
· Niagara Mohawk Power Corporation - Gas Bids and Offers
· Xerox Corporation
SPSS
· Xerox Corporation
· Center for Organizational Development (C.O.D.)
  
Market Research
· Center for Organizational Development
(1) Cessna Owners
(2) Dentists
· Flordia Orange Growers
· Xerox Corporation

Leadership Experience
· Project manager with P&L responsibilities at Xerox Corporation -Improved revenues by $500,000/month. 
Supervised 18 people.
· Managed direct mail operation, mailed 1 million direct mail solicitations per month Supervised 3 people 
· Project Lead for corrective action at a Nuclear plant. Supervised 2. 

Professional Experience
· Forecasted revenues and performed month-end close
· Coordinated worldwide copier production – reduced production lead times by 50%
· Saved man-years of work by creating a worldwide-finished goods inventory application.
· Reduced training costs permanently by changing union bumping rules
· Improved prospect qualification (sales forecasting) system based upon survey data.
· Saved late charges at a photo-processing plant by changing the bag sorting process
· Measured management performance with a ‘Balanced Scorecard’ application. 
· Administration experience for NT Server and for the Macola ERP system
· Enhanced productivity with a tracking & scheduling database for training & repairs
· Improved Safety Incident Reporting & Tracking with a workflow application
· Conducted several market research studies

Employment History

2004 MVInTech - Programmer/Analyst. Used Visual Basic and SQL Server 2000. Updating Aircraft Tracking software.

           2004 IDEZ - Programmer/Analyst. Used PHP and MySql to update a WEb Site.

2003 Amtek Corporation – Programmer/Analyst. Updating and documenting a web-based Loan
Origination System. Using ASP Pages, Visual Basic, JavaScript, VBScript, and XML.
2001- 2002 I2eyenet.com – Analyst. Updated loan origination system to work under citrix and
 MS Terminal Server. Enabled i2eyenet to win an industry award from CUNA. Used Visual Basic,
 Visual Source Safe, Crystal Reports, and SQL Server. Wrote TS/SQL Stored Procedures,
 user documentation, and systems documentation.
2000-2001 Special Metals Corporation – Business Analyst, Lab Management & Safety.
Team leader for the re-designed of a LIMS (Laboratory Information Management System) 
used citrix to interface analytical instruments with a PC network. Oracle, Java, and Lotus Notes 
development. Designed and installed a safety tracking system. Improved quality control by 
linking a Notes Quality inspection database with the Oracle Production processing database. 
Documented user interviews with Use-Case analysis (UML). Worked with XML.
 
1989-2000 AY Consulting ­ Worked with several clients:
® Arcom Labs, served as NT network administrator, and updated PC hardware & software.
Installed network switches and routers. Implemented barcode tracking of production batches. 
Used Macola ERP & MS Access.
® Qualex (Kodak), interfaced PC network with GBS package sorter. Saved late charges.
    Used MS Access.
® General Electric Corp., Team leader for design and installation of 2 closed loop quality control
     systems. Used AS/400 & COPICS. Wrote user specification document.
® Niagara Mohawk Gas & Electric, implemented incident tracking system at a Nuclear Plant 
which consolidated 15 tracking systems. Built a natural gas ask/bid system. Used SAS & MS Access.
® Thompson Consumer Electronics, designed and implemented customer returns processing.
     System using MS Access. Over 6000 returns per month.
® Philips Broadband, interfaced CAD drawings with Surface Mount PCB board processing
    machine. Built sales tracking systems. Used MS Access.
® OCM BOCES, built a tracking system for Science kits using barcodes. Used MS Access.
® NY Comp Managers, built a worker’s compensation claim tracking system and a medical bill claim analyzer.
 Project Leader. Used Visual Basic, MS Access, and SQL Server. SQL Server DBA.
® Center for Organizational Development. Designed / analyzed market research studies.
    Used SPSS.
 
1974-1998 Xerox Corp., Held positions in Operations Research, Finance, and Direct Marketing.
Direct Marketing: Mailed 1 million pieces month, ran successful sales programs.
  As Quality Control Project leader, was able to reduce order entry manpower waste.
Finance: Coordinated worldwide copier production – reduced production lead times by 50%,  
 Saved man-years of work by creating a worldwide-finished goods inventory application.
 Forecasted both copier sales and average monthly copy volumes.
Operations Research: Forecasted copier market size and market share based upon survey data,
 determined monthly product seasonality, Simulated bumping rules during union contract
 negotiations, Improved prospect qualification (sales forecasting) system based upon survey data.
 Used APL, SAS, SPSS, COBOL, ISPF, & Mark IV.
  
1968-1973 Glidden-Durkee Division of SCM Corporation ­ Operations Research Analyst.
Designed and programmed a Paint-Formula calculation system, and a Paint Production Order
Processing system. Used Fortran and COBOL.
 
Education/Other
· MBA degree in Applied Economics , University of Rochester
· BS degree in Biochemistry, Ohio State University.
· HIPAA Certifications: Administrator, Professional, & Security 
· Graduate work in Operations Research at Case Western Reserve University.
· taught Microeconomics for Genesee Community College.
· Instructor in Finance and Microeconomics for Columba College.
· taught Visual Basic’ at Syracuse University.
· Awarded prize for ‘tip of the month’ by SearchDomino
· Article: 'Getting down to Work' Published by the Wall Street Journal.
· Wrote several articles for the CNY Business Journal.
·Member of Toastmasters International

Arthur Yates

ayates@twcny.rr.com
4985 F. M. Road
Manlius, NY 13104
United States