Jonathan J. Guastaferro
1756 Beechwood Drive
Farmington, NY 14425
585 317-9291
[Send email using form at bottom]

OBJECTIVE:  				
	To continue and continue my opportunities in the field of Information
Technology.

EDUCATION:		
Rochester Institute of Technology
College of Computer Science and Information Technology
Major: Information Technology				Concentration: Interactive Media Design
Degree: Bachelor of Science
Dean’s List 1993-1997

WORK EXPERIENCE:	Paramount Computing Associates
Batavia, New York
September 2005 – Present
Programmer/Developer: Created and edited back end, batch and web-driven programs
using Oracle’s PLSQL and UNIX Korn Shell scripting for Xerox Capital Services.

	
Global 360
Rochester, New York
February, 2004 – September 2005
API Support Engineer: Researched problems in large-scale workflow software and
custom code using the Oracle, SQL Server 2000 and DB2 Database Management
systems.  
Created and resolved issues on custom forms and workflow API’s using stored
procedures, Visual Basic, .NET, HTML and JavaScript.
	
Structured Technologies Inc.
Rochester, New York
October, 2000 – February, 2004
Programmer: Created and edited programs using UNIX Bourne and C Shell scripting,
Perl, C, Pro C, VB.NET, Crystal Reports and Oracle’s SQLLOADER, SQLPLUS, and
PLSQL.
Web Application Developer: Created web pages using HTML, cgi scripts,
JavaScript.  Created WEB pages using HTML, VB script and JavaScript.
Software Technical Support:  Supported all the applications created by
Structured Technologies.
	
Xerox
Webster, New York
December, 1997 – June, 2000
Programmer: Created and edited programs using UNIX Bourne and C Shell scripting,
and PLSQL/SQL.
Software Support: Resolved user issues using legacy system interfaces and legacy
software.
	
Digithead Computers
Canandaigua, New York 
August, 1996 – July, 1997					
Network Administrator Consultant: Set up networks using the Microsoft Network
and Windows; constructed and repaired computers.
Web Designer: Designed and created web pages using JavaScript and HTML. 
Programmer: Created programs for specific business needs using Visual Basic and
Microsoft Access.
	
Hahn Automotive Computer Center
Rochester, New York
October, 1995 – September, 1996					
Computer Technician: Repaired computer hardware problems; researched software
problems using UNIX.
Support Technician: Answered hardware and software computer-related questions
and solved computer-related problems for stores nationwide.


COMPUTER COMPETENCIES:			
      Languages:	BOURNE Shell, Korn Shell and C Shell: 
	Created programs that extracted and loaded Oracle data from one
database into another.  
	Created programs to manipulate data from the Oracle DBMS. Created
scripts to create or manipulate flat files.  
	Created cgi scripts for web applications to display data queried from
the Oracle DBMS or other data manipulation.
	HTML and JavaScript: 
	Created web pages for Xerox.com and Xerox internal use
	SQL: 
	Create “ad-hoc” queries from the command line, Oracle’s PLSQL
developer, as well as create SQL flat files. 
	Created queries within shell scripts, perl and Pro-C programs that
extract data from one database to be loaded to another.  
	Created queries for date to be displayed on web pages.
	Created large-scale queries that use all types of joins.
	VB.NET: 
	Created internal business applications that connect to external
databases (SQL Server and Microsoft Access).  
	All applications were created using the Visual Studio Framework.
	Perl: 
	Edited programs that extracted and loaded Oracle data from one database
into another.  
	Edited programs to manipulate data from the Oracle DBMS. Created
scripts to create or manipulate flat files.  
	Created cgi scripts for web applications to display data queried from
the Oracle DBMS or other data manipulation.
	C: 
	Used the C language to manipulate flat files
     
    	Crystal Reports: 
	Created custom crystal reports for specific customer needs.
      
   Systems:	UNIX: 
	Created complex UNIX shell scripts using the vi editor

Database Management Systems:	
SQL Server Tools and Languages
	T-SQL:
	Created stored procedures using Transact SQL for test systems and
specific business needs.

Oracle Tools and Languages:	PLSQL:  
	Created Packages, stored procedures, triggers and functions that query
and manipulate data from a database.  
	Created PLSQL programs and back-end web procedures for Xerox and Xerox
Capital Services. I also used PLSQL to update or insert data into another table,
extracted and manipulate data, put into temp files or tables for later retrieval,
display or loading into another database.
	SQL*LOADER:  
	Created control files and loaded data from a “flat file” using the
sqlload command
	SQL*PLUS: 
	Created queries to display data or extract data from a database table
to be loaded into another table.  
	Used as a tool to research problems from programs that use Oracle
databases.
	Created large-scale queries that use both inner and outer joins.
  	Pro-C:  
	Used the Oracle features available for pro-C (insert command, update
command, and sql features)
Database Administration Experience:
		Create and drop tables and views 
	Modified columns in and views
	Created and manipulated tnsnames file
Add and modify grants and permissions for users to tables and views and
performance tuning

REFERENCES:	
Available upon request.