We provide IT Staff Augmentation Services!

Systems Administrator Resume

5.00/5 (Submit Your Rating)

Denver, CO

OBJECTIVE: To obtain a position as a VBA programmer\\analyst where my strong technical and interpersonal skills can be best utilized.

EXPERIENCE:

11/2007 - 7/2009 Confidential. Denver/CO
VBA Programmer

  • Corrected errors by making appropriate changes and rechecking Excel and Word applications to ensure that the desired results are produced.
  • Conduct trial runs of Excel and Word applications to be sure they produced the desired information and that the instructions were correct.
  • Wrote, updated, and maintained Excel and Word applications to handle specific jobs such as tracking trust documentation, storing or retrieving data, automation and General Ledger searches.
  • Consulted with managerial, and technical personnel to clarify Excel and Word application intent, identify problems, and suggest changes.
  • Compiled and wrote documentation for Excel and Word application development. and subsequent revisions, inserting comments in the coded instructions so others can understand the program.
  • Researched, designed, developed, tested and implemented a Billing Attorney Daily Cash sheet application for the Accounting department in Excel using VBA.
  • Researched, designed, developed, tested and implemented an Excel Addin using VBA to build a pivot table from all Billing Attorney data gathered from their legacy LMS database.
  • Researched, designed, developed, tested and implemented a General Ledger lookup application in Excel using VBA.
  • Researched, designed, developed, tested and implemented a Trust Fund Document management system and generator in Word using VBA.

10/2007 - 10/2007 Confidential Englewood/CO
Member, Software Configuration Management Team

  • Tested system modifications to prepare for implementation.
  • Documented software defects, using a bug tracking system, and reported defects to software developers.
  • Identified, analyzed, and documented problems with program function, output, or content.
  • Maintained a database of known test defects.
  • Planned test schedules or strategies in accordance with project scope or delivery dates.
  • Reviewed software documentation to ensure technical accuracy, compliance, or completeness, or to mitigate risks.

8/2007 - 8/2007 Confidential Broomfield/CO
Systems Administrator (Contracted to National Cinemedia)

  • Maintained and administered computer networks and related computing environments including computer hardware, systems software, applications software, and all configurations.
  • Diagnose, troubleshoot, and resolve hardware, software, or other network and system problems, and replace defective components when necessary.
  • Configured and maintained email applications
  • Conferred with network users about how to solve existing system problems.

9/2005 - 6/2007 Confidential Broomfield/CO
IT Generalist (Contracted to Timminco Corporation)

  • Developed labeling application using Microsoft Access and Loftware ActiveX for sister company in Mexico reducing cost from $25.00 to $2.00 per hour
  • Developed Packing List application using Microsoft Access for sister company
  • Wrote code in Outlook VBA to automate the stripping of specific email, upon delivery, of attachments and post the attachments to intranet web site
  • Updated 15+ Microsoft Access database code from DAO to ADO
  • Maintained and updated existing Access databases and Excel spreadsheets

SKILLS:

Excel programming - VBA, formulas, VLookup, automation, reporting
Access programming - VBA, queries, forms, tables, reports and SQL beyond using built-in wizards
Word programming – VBA, vbscript for document management

CERTIFICATES:

Microsoft Corporation
Microsoft Certified Database Administrator
Microsoft Certified Professional
Microsoft Certified System Engineer

We'd love your feedback!