Teresa M. Blackburn
12220 Harrowgate Road
Chester, VA 23831
H: (804)796-5523 C: (804)712-4761
Email: [Send email using form at bottom]
OBJECTIVE
Provide my Microsoft Access skills to enhance functions necessary to accomplish
productivity, customer service, internally and externally.
QUALIFICATIONS
Excellent problem solving skills, both computer and off-line; Highly organized,
punctual; Respond quickly to priority changes, flexible, versatile; Team player,
helps train others in better ways to utilize technology; Experience with Windows,
Novel LAN and IBM mainframe environments; Versed in MS Access, Visual Basic, SQL,
Crystal Reports Power Builder (used with Oracle); MS Access, MS Excel, Business
Objects, Oracle queries, SQL queries, Visual Basic scripting, MS Word, Outlook.
On-Demand, Monarch. Also, experienced with MS Desktop Applications.
EDUCATION John Tyler Community College
Associates in Applied Science - IS Programming Specialization May 2002
Associates in Applied Science - IS Microcomputer Applications Specialization
May 2002
PROFESSIONAL SUMMARY
Owens & Minor, Mechanicsville, VA Jun 2008 Feb 2011
Systems Automation Analyst Contract
Designed, created, built, implemented OS&D application using access, excel,
outlook thru internet using Citrix server.
ADM(Automated Debit Memos) Report database
Shands (vendor) labels using Vendors MS Excel spreadsheet prepared to use in
MS Word, via MS Access
Ship Failure Form Database created similar to OS&D above.
Macros that scrape data from IBM Mainframe and put in spreadsheet and visa
versa.
Contracts - EDI Reject Report.mdb and EDI Reports New.mdb databases created so
that data can be stored and researched by users with a frontend database. The
frontend is used with many dbs in many locations because of the amount of data
and size of db. Created to eliminate the printed copies daily. EDI
Reject/Expired Contracts maintained and archived regularly.
EDI Report Daily Cover Sheet.mdb created for researchers showing work edited
by users on previous day
EDI Issues Log.mdb created to monitor issues from EDI statements from various
vendors
Invalid UOM.mdb created using On-Demand reports batched nightly from Mainframe
imported into MS Access and prepared and exported to MS Excel to be used in the
OMNI mainframe.
Individual Expiring Contract Letters were sent to vendors three times a month.
Business Object queries were used to import needed data into MS Excel. When the
spreadsheet was available to use, the spreadsheet was imported into MS Access. A
switchboard was used for each time the contract letters needed to be sent. It
dated the letters created in Outlook Express to email to Vendors as needed. All
tasks were processed using Visual Basic/SQL. This process saved many man hours
by not needing to manually fax contract request letters.
Daily EDI/Audit Report Counts by UserID On-Demand reports linked into MS
Access for Supervisors to monitor users performance daily by MS Excel reports.
Download tool many reports/models/tables created for various departments
which created dbf files for use in MS Access
Forms created in DIW (Document imaging workstation) with Visual Basic, short
pay deduction, dropship, expense duplicates forms used by Accounts Payables.
Many reports pulled from On-Demand and put into Access, resulting in those
reports not being printed daily.
Documentation/presentation/implementation/instruction for all the above.
Cash/Rebate reconciliation reconciled rebate system with general ledger
system
Physical inventory application brought 19 various reports together from
numerous applications and reconciled inventory when needed.
Maintained many databases and folders for space capacity
Many macros in word, excel, access
Alcoa, Inc. Richmond, VA March 2006-March 2007
EHS Assistant - Contract
Designed, created and implemented numerous reports and data warehouses for EHS
department using MS Access Industrial Truck
Pre-Use Inspection Reports, PPE (Personal Protection Equipment) Room
Inventory. Used Training Tracker program and ran reports from this program on MS
Access. More details upon request.
Sun Chemical Sub-Contracted through Alcoa, Inc. Richmond, VA
Data Analyst - Contract February 2005-March 2006
Developed MS Access database to store ink return inventory
Input ink labels into database, monitor use of recycled inks in MS Excel
Input formulas, materials, and jobs into NOVAFLOW system which prepared inks
for use on jobs
Input pull sheets into MS Excel to monitor how many times job was stopped and
the reasons related to it.
Chester Roofing and Repair, Chester, VA March 2003-December 2006
Office Manager
Payroll, A/R, A/P, Billing, prepare and file taxes.
Developed Accounting program with MS Access and Visual Basic which enables
information to be posted in individual accounts that can be used directly on tax
forms.
SAAB Buddies, Brodnax, VA January 2001 - May 2001
Programmer - Contract
Developed web page with FrontPage, MS Access, enabling customers to see
inventory of company and inquire about parts and services via e-mail.
1998-2001 Full-time Student-John Tyler Community College, Chester, VA
AlliedSignal, Hopewell, VA February 1997- March 1998
Mechanical Integrity Clerk
Developed 1998 Maintenance Budge System using MS Access
Developed Incident Reporting System using MS Access
Designed, created, and implemented the Mechanical Integrity application using
Visual Basic, MS Access, MS Word and Crystal Reports. Allows users to query,
view and report data from an MS Access database. User may select data from MS
Access, which will open MS Word documents.
Overnite Transportation Company, Richmond, VA October 1995-February 1996
Financial Specialist
Developed a Scorecard for management using MS Access to track service center
shipments, weight, revenue, and employees.
Developed Compensation and Incentive Plan, using MS Access, which budgeted
goals for service center managers to reach in order to receive their Incentive
Bonus.
Developed monthly budget, using MS Access based on past data from a Daily
Revenue Report.
Overnite Transportation Company, Richmond, VA September 1988-October 1995
Secretary
Designed, created and implemented numerous reports and data warehouses for
upper management on Payroll/Revenue %, Set Work Hours, Profit/Loss Report, Fixed
vs. Variable reports, using MS Access.
Terminal Equipment and Data Summary tracks all service center equipment, using
MS Access, (i.e. trucks, trailers, PCs, printers, etc.)
Dock studies to analyze dock layout to improve handling of freight.
Profitability studies; Production Analysis; Productivity reporting using
mainframe applications.
Utilized Atlas Graphics to determine service areas for new facilities using
data warehouses on mainframe.
Wheat First Securities, Richmond, VA June 1986-September 1988
Order Clerk- Commodities Exchange
Balanced profit/loss daily for commodities. Coordinated computer conversion
for new system, balancing parallel reports for the system. More details upon
request.
APPS Para Medical Services, Richmond, VA February 1983-June 1986
Office Manager details upon request.
State Farm Insurance, Richmond, VA October 1981-August 1982
Clerk details upon request
COMMUNITY ACTIVIES
Volunteer-Special Olympics, Chesterfield County, VA; Transport Teams to Area
Games (roller skating, soccer, ice skating). Assist Coach with Skating.
References and Portfolio upon request.
|
