James Lofton

Freelance Database Programmer & Windows Programmer

Location:Georgetown, Texas, United States
2 Skills
120 River Bend Dr #521
Georgetown, Texas 78628
(915) 630-8296


• Highly analytical with a strong work ethic and strong attention to detail. A problem-solver, with the ability to adapt to new environments, teams, and procedures quickly and effectively.
• A creative thinker for solutions through technology, with proven success in developing, enhancing, and streamlining database processes and spreadsheet applications.
• Self taught dBase programming in order to design, code, debug and implement custom database software used for note servicing company for over ten years.
• Adapts well to changing demands and deadlines due to variations in job demand.
• Advanced proficiency in computer hardware and software: MS Office (Excel and Word); exceptional working knowledge with relational databases (e.g. Dbase, Access). Quick study with new systems and software applications.
• 5 years payroll and accounting experience with Creative Solutions general ledger and payroll modules.


Accounting Clerk, Classic Charms, Cedar Park, Texas 01/11 – Present

• Create VBA code to streamline data entry process for website update
• Provide accurate and timely A/P and A/R services within company guidelines.
• Provide customer service as needed via telephone and in person to handle customer needs.
• Process customer orders; to include ordering out of stock items, receive shipments from vendors, ensure order is properly filled and shipped when ready.
• Employ Quick Books Enterprise Edition software to enter and receive purchase orders, sales receipts and invoices.
• Maintain, update and correct inventory records as required.

Excel/VBA Programmer, Independent Contractor 10/10 – 12/10

Independently and remotely streamlined and enhanced existing budget spreadsheet application for Clint Independent School District, El Paso, TX.

• Efficiency improvements and introduction of VBA enhancements reduced spreadsheet file size in half resulting in reduced update time on resource starved systems.
• Developed enhanced user form and report functionality per specifications verbally provided.
• Instituted data integrity check processes in VBA to speed the development of future enhancements to the sheet.

Data Entry Clerk, HOV Services, El Paso, Texas 12/09 – 06/10

Enter medical insurance claim information into custom company software system. Type 55 wpm with 90% accuracy.

• Cross trained to coding applications within two months employment.

Independent Bookkeeper, El Paso, Texas 01/05 – 06/10

Perform monthly bookkeeping services for two separate Automobile Repair Shops.

• Monthly bank reconciliation.
• Weekly payroll verification.
• Quarterly and Yearly payroll tax reporting.
• Monthly sales tax reporting

Accounting Clerk, Comprehensive Coding Solutions, El Paso, Texas 01/03 – 01/07

• Monthly bank reconciliation.
• Weekly payroll processing and reporting.
• Quarterly and Yearly payroll tax reporting.
• Monthly sales tax reporting.
• Quarterly Workman’s Compensation processing.

Manager, Southwest Escrow, Inc., El Paso, Texas 11/99 – 10/09

Manage all collection and operational aspects of third-party Collection and Escrow Company for owner-financed real estate notes, with 2,000 accounts and $3 million in annual collections.

• Act as Liaison with Attorney for implementation of Texas Real Estate Code relating to status of loans and payments; implementation of adjustments to system when approved by Bankruptcy Trustee; and served as Primary contact with Brokers and Note Holders for payment report interpretation.
• Modify business processes in our database program to satisfy customer needs and to address annual legislative changes in Real Estate Law, for collection of service fees and the legal process for foreclosure.
• Set up new collection accounts; explain concept of compound interest, property taxation, and property valuation appeal process to Payers; and close loan process when property is paid off, including Release of Lien or Warranty Deed for legal compliance.
• Designed, coded and debugged Database Program to track payments, amortizations, bankruptcies and insurance coverages, to facilitate business operations and for simplified retrieval of customer information.
• Modify software and procedures to comply with “Local Taxing Authority Guidelines” on annual basis.
• Adjust payment information for all accounts to assure accuracy of property taxes collected with payments.
• Manage annual audit, billing, collection, and payout records for property tax escrowed for customers to local taxing authorities, in accordance with their established procedures.

Excalibur Hotel & Casino, Las Vegas, Nevada 01/99 – 11/99

Worked in three departments simultaneously, as Poker Dealer, Sports Book Clerk, and Keno Operator.

• Revised and generated monthly operational reports for Poker and Keno Departments, through application of industry-specific computer systems.

Casino Dealer 04/95 – 06/98

• Camel Rock Casino, Santa Fe, New Mexico
• Cities of Gold Casino, Santa Fe, New Mexico
• Speaking Rock Casino, El Paso, Texas

Manager, Southwest Escrow, Inc., El Paso, Texas 11/92 – 02/95

Served as Manager of daily operations for third-party Collection and Escrow Company to include receipt, deposit, disbursement, and recording of payments on owner-financed notes.

• Responsibilities commensurate with manager of daily operations.

Inventory Clerk/Purchasing Agent, Executive Technical Services, Dallas, Texas 1989 – 1991
(Aircraft Instrument Manufacturing and Repair Facility – Defense Contractor)

Maintained levels of repair and replacement parts for Commercial and Military aircraft instrument repair facility for inventory totaling $2 million.

• Researched, tracked, and obtained repair and replacement parts for aircraft instruments, normally under severe time constraints, to enable grounded aircraft to resume normal operations as quickly as possible.
• Inspected materials and parts to ensure compliance with military and commercial specifications.
• Worked hand in hand with Instrument Technicians and three repair shops to assure inventory levels and ordering of parts facilitated business operations at all times.
• Reported inventory age, usage and deficiencies to owner of company on monthly basis.


? Austin Community College, Round Rock, Texas – Continuing BBA in CIS
? El Paso Community College, El Paso, Texas – 2010 Begin BBA in CIS
? Naval Nuclear Power Plant Operator Training Program – 1982 - 1984.
? University of Texas at El Paso, El Paso, Texas – 1981 - 1982
? Eastwood High School, El Paso, Texas – 1976 – 1981