Application Developer/DBA
Resume:
Tim R Anders
**** ** **** ** * Gresham, OR *****
hob0o4@r.postjobfree.com
SUMMARY
A responsible, dedicated Software Developer with 18 years relevant experience in transportation industry, developing software for the leasing, mechanical and accounting operations. Principal strengths include developing in PowerBuilder 10.5, MS SQL Server, and Microsoft Access. Known for exceptional skills in problem solving, strategic thinking and job completion under tight time constraint. Direct, hands-on experience as DBA,SQL Server
* MS SQL Server 2000/2005
* MS Access
* Sybase PowerBuilder
* MS Excel 2003
* MS Word 2003
* MS Office 2003
* ACT - Contact data management software
* Epicor Accounting System
* Filenet
PROFESSIONAL EXPERIENCE
The Greenbrier Companies
Worldwide Corporate Headquarters Lake Oswego, OR 1990-2008
The Greenbrier Companies, Inc. is engaged in designing, manufacturing and marketing of railroad freight car equipment in North America and Europe and is a provider of railcar refurbishment, parts, leasing and other services to the railroad and related transportation industries in North America.
DBA/Developer 1996-2008
As a developer I had DBA privileges to create new databases for new projects. Developed all the SQL Server roles, permissions, tables, views and other required objects on new projects. Analyzed and organized database objects to target data mappings.
* Created over 100 SQL Server stored procedures in T-SQL.
* Created SQL Servers database tables with triggers.
* Created clustered, nonclustered, compound and primary key indexes.
* Created SQL Server views.
* Created SQL Server stored procedures and views that through a linked service would keep tables synchronized between the production server and a test development server.
* Administered security.
* Updated statistics on database tables.
* Created constraints between database tables with foreign and primary keys.
* Monitored performance and ran traces on problem scripts.
* Developed a document storage database that would keep track of documents sent to offsite storage facility.
* Monitored SQL Server log files for problems after nightly backups.
* Created SQL Server DTS package that would read ASCII data into database tables.
Tim R Anders Page 2
Applications Developer 1996 -2008
Responsible for maintaining four PowerBuilder and five MS Access applications. Provided user support and enhancements. Responsible for helping users in all corporate departments with Microsoft Access, troubleshooting for hardware and software problems, and training.
* Developed a mileage calculation application resulting in a savings of over $400,000 a year on state taxes.
* Developed a Car Hire Accounting system to track railcar per diem amounts, allowing exponential growth without requiring additional staff. Created this application to also interface with Epicor accounting software.
* Designed centralized database for storing company contact information.
* Developed an application which tracks possible sale proposals for the marketing and sales department.
* Enhanced PowerBuilder application that tracks leasing information allowing for more detailed customer records.
Supervisor, Car Accounting 1990 - 1996
Responsible for over two million dollars of receipts and disbursements to lessees.
* Converted a Lotus 1-2-3 into a Dbase IV.
* Wrote a Dbase program that translated ASCII data into a Dbase front-end, which reduced a two-week keypunch process to a one day procedure.
* Developed SQL data base that contained over 100 tables.
Clark Community College, Vancouver, Washington 1998-1999
Instructor
* Taught evening class on Microsoft Access 97
Consulting
* Developed a marketing application for a national siding company resulting in better tracking of their sales and appointment scheduling.
Tim R Anders Page 3
US Navy, Naval Mobile Construction Battalion FIVE 1986-1990
Operations Department 1989-1990
* Responsible for maintenance and training for department computer equipment.
* Responsible for inventory and maintenance of all software; troubleshooting for hardware and software problems.
* Developed Lotus 1-2-3 financial analysis software, writing macros to track Battalion timekeeping information. This effort resulted in reduced department overhead, eliminating personnel-related costs.
Administration and Legal Services 1986-1990
* Responsible for typing correspondence and documentation.
* Developed a Dbase program for legal department.
* Letter of commendation from Admiral of U.S. Construction Battalion's U.S. Pacific Fleet, Pearl Harbor, in recognition of high level of work accomplished for the Legal Services Department.
Member of Portland Access Users Group (PAUG)
Member of International Sybase Users Group (ISUG)
Professional Development
Certificate of Achievement in developing .NET application for Visual C#:
Completed classes in: Java Technology for Structured Programmers, Business Requirements Management, Ethics and Security for IT Professionals
Contact this candidate