John Bonifas

7319 West Glass Lane
Laveen, AZ 85339
(602) 253-8801
john.bonifas@asu.edu

Skills
VBA, VBscript, HTML, CSS   13+ years
Transact-SQL, PL/SQL, Stored Procedures   11 years
ASP, SQL Server, DTS, ODBC   10 years
JSP, Servlets, JDBC, XML, Javascript   7 years
Java Apps and Applets, VB.NET, ASP.NET   3 years
PHP and MySQL   2 year
.NET   1 year
Education History
7/07 - Current Student Arizona State University W Campus Phoenix, AZ
Currently Attending Part-time as an Applied Computing major, ACO Program, New College. Projected Graduation date: May 2015.
 
Employment History
5/88 - 7/07 Programmer/Analyst - 2 The Boeing Co. Seattle, WA
     
Automation of Excel Charts using VBA Automated performance visibility charts using VBA for Excel to enhance work efficiency with SQL Server; automation project eliminated the need for manual update and reduced operating time from 1 hour to 5 minutes.
Inventory Visibility Web Application As a member of a 3-person team, developed a 2-tier ASP application to track inventory levels and department performance measures using a SQL Server database; also automated TSO mainframe-based SAS programs to enhance the efficiency of data compilation, Application allowed division personnel and managers to retrieve their own data, significantly reducing personnel hours required for IT labor.
Autosurplus Application Maintained and operated large-scale SAS application hosted on TSO mainframe. ApplicationÍs main function was to predict inventory overstock and surplus data for division personnel; responsible for applicationÍs reliability and accuracy during major changeover of all application data sources from mainframe-hosted to Unix-hosted Oracle data bases.
Overtime Application Developed a 2-tier ASP web application that replaced a manually-intensive, tedious process for monitoring overtime for a 300-person division.
Kitting Designer Application Maintained and operated a large-scale, three-tier Visual Basic application that managed standard parts inventory for Boeing 777 final assembly line. Application included custom components and a custom ActiveX DLL built in-house to communicate with the SQL server database; reliability was dubious due to age, but critical to smooth operation of final assembly standard parts areas, had high visibility, and required considerable vigilance to effectively maintain.