Systems Administrator Resume
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