Customer Service Sql Server

Education

November **** University of Phoenix

Masters of Business Administration

San Antonio, TX

January 2002 University of Texas at San Antonio

Took an E-Commerce course using ASP and VB Script

December 1997 Southwest Texas State University

Bachelor of Business Administration

Major: Computer Information Systems

Overall CIS GPA: 3.333

601 University Drive

San Marcos, TX 78666-4615

1985-1988St. Philip’s College, earned 94 hours

1801 Martin Luther King

San Antonio, TX 78203

Major study: Computer Information Systems

1984Sam Houston High School

High School Diploma

4635 East Houston

San Antonio, TX 78220

Professional Objective

Seeking a software engineering position in an industry-related business, which will provide opportunities for professional growth and creative application of my Information System background to real-world problems.

Educational Highlights

Earned the rank of Life while in the Boy Scouts

Made the Dean’s list twice at St. Philip’s college

Voluntarily installed all software on the hard disk for a nursing home and instructed the user on how to use the word processor, Database, spreadsheet, DOS, and accounting software. Created all the data tables in Dbase IV for the patient and employee databases.

Worked full-time while in college and financed 100% of my tuition.

Technical Skills

Languages: COBOL, SQL, VB 6, VB.NET, ASP.NET, AJAX, HTML, CSS, XML

Applications: SQL Server, MS Access, Office, Crystal Reports, IIS, Visual Studio 2012

Patrick Lamza Page 2

Employment History

1/06 – 5/18 Senior Applications Developer, VIA Metropolitan Transit.

Developed the Employee Portal website using VB.NET, ASP.NET, CSS, HTML and SQL Server stored procedures and queries, which provided a self-service platform for viewing of earning statements and reporting of bus accidents saving in the cost of paper and facilitated management reporting processing time.

Developed the on-line employment application website allowing HR to streamline the application process.

Re-designed the open-enrollment website to make the site more efficient allowing for a better user experience by the use of AJAX controls, HTML and CSS.

Developed multiple desktop applications using VS2008 thru VS2012 for multiple areas of the company, Finance, Marketing, Operations, Maintenance, HR and procurement.

Analyzed and maintained several legacy applications to include performance, diagnosis and troubleshooting of program issues and processes.

Captured business requirements and translated requirements to system specifications for programming.

Documented application changes for clarity and transparency saving development team time in maintenance and knowledge transfer.

Developed the Affordable Care Act XML file required by the IRS saving the Human Resources Department weeks of manual labor costs.

2/98 – 11/05 Programmer II, Friedrich Air Conditioning Co.

Worked with Purchasing and Accounting Departments to develop a Purchase Requisition application which streamlined the process of entering of purchase items, vendor validation, and manager and VP approval process.

Worked with Accounting and developed an Accounts Payable Matching system.

Developed a Return Authorization VB6 program for Logistics and Customer Service.

Developed the Friedrich Order Entry System using VB6 and SQL Server 2000, allowing customer quotes to be entered, obtain accurate pricing, gather ship and bill to information and allows validation of quote to a customer order streamlining the order process and improve order accuracy.

Worked to get the Order Entry System converted into a web based application using Visual Studio 2003 with ASP.Net, VB.Net, HTML and Java Script for ease of pushing software changes and lessened the need for processing power on PC’s.

Developed warehouse management programs using Microsoft Transaction Server and Three-Tier software architecture. Created DTS packages to bring data across from an ERP system, which comprise of a set of integrated applications that tie together and streamline business processes across Accounting, Engineering, Manufacturing, Order Entry, Purchasing and Shipping Departments.

Developed Warehouse Radio Frequency Scan Gun programs using RF Gen and ActiveX DLL’s saving time and producing accurate inventory results during yearly inventory.

Patrick Lamza

6755 Raintree Path San Antonio, TX 78233 Cell 210-***-****

Contact this candidate