John Finlay Email & Phone Number

Early, TX, US

• Develop and manage the company's IT operations at multiple locations.
• Implement best practices on SQL Server 2012 installation by offloading log files, backups and non-essential(test) database files to a separate disk array.
• Customize Prophet 21 ERP software using T-SQL stored procedures, triggers and SQL Agent jobs.
• Develop and implement SQL Server Integration Services packages to integrate Prophet 21 with 3rd party applications and cloud data stores.
• Develop & deploy custom reports in SQL Server Report Services and Crystal Reports.

Austin, TX, US

• Prepared, verified and submitted estimates for construction contracts in a 6 county area.
• Processed contract change orders, supplemental agreements and extra work orders.
• Monitored contractor compliance with federal requirements related to EEO and wages.
• Audited final contract records for submission to District construction office.

• Developed market-driven websites to promote products for affiliate programs and eCommerce.
• Analyzed markets and keywords for SEO.
• Developed websites using WordPress, HTML, CSS, JavaScript, PHP, MySQL.

Austin, TX, US

• Audited documentation for credit card purchases in Wichita Falls and Tyler Districts.
• Verified and matched documentation with charges on credit card vendor statement.
• Processed timely payments to vendor.
• Audited vendor invoices and department receipts for proper coding.

Austin, TX, US

• Developed a Python-based GIMP plug-in for mass processing of TIFF images of right-of-way maps comprising more than 79,000 miles of Texas public roads.
• Performed computer hardware and software installation and configuration.
• Maintained and controlled access to District assigned laptop/notebook computers.

• Developed and maintained custom software for clients using Microsoft Access 97 and 2000 with SQL and VBA.
• Primary software was Criminal Law Attorney Support System(CLASS), used by county & district attorneys to automate collection of hot checks or issuing warrants in absence of collection.
• Integrated with PostgreSql, Oracle and Microsoft SQL Server databases.
• Performed network and PC planning, installation, and troubleshooting for clients as needed.
• Provided Internet routing/email/firewall services for clients using Linux.

Corpus Christi, US

• Managed information systems for wholesale distributor with over 20 locations worldwide.
• Oversaw department of 3 that fulfilled daily IT support and data processing functions.
• Developed Visual Basic application for data conversion used in reporting to government entities.
• Developed Ad-hoc reports in Eclipse Software.

• Managed IT and data processing operations for 7 locations.
• Deployed Microsoft Windows NT 4.0 servers for web, proxy, and report archival.
• Analyzed and recommended improvements for network infrastructure.
• Automated and streamlined data processing functions using FTP and shell scripting.

• Led team of five in data processing and proof departments.
• Acted as Network Administrator for 100-node Netware, Windows NT, and UNIX systems.
• Prepared for EDP audits, including Y2K compliance.
• Actively participated in EDP Steering Committee.

• Managed accounts for West Texas area.
• In charge of product ordering and delivery, problem solving, and collection.
• Responsible for monitoring expenses and implementing promotions.

Bachelor Of Business Administration (Bba), Computer Information Systems

Education record