Post Job Free
Sign in

Operations analyst, Microsoft Access Database developer, advanced exce

Location:
Loganville, GA, 30052
Posted:
November 21, 2014

Contact this candidate

Resume:

Carla B. Houk

Loganville, GA

678-***-****

*****.****.*@*****.***

Summary

Analytical and technical minded professional with expertise in Microsoft Access database development, advanced

excel spreadsheet design, software testing, support, and setup. Bookkeeping skills that include account

reconciliation, payroll, a/r, a/p, inventory, and accounting software setup. Ability to solve complex reporting challenges

through data manipulation and report templates.

Experience

Southern Cross Corp, Norcross, GA 2006-2014

Wireless Communications Coordinator and Data Analyst

Saved the company over 36 thousand dollars annually on phone costs by renegotiating the phone contracts

Prevented loss of inventory by tracking ownership of more than 500 phones and electronic devices

Managed the device roll-over when the Nextel network was decommissioned. Coordinated the deliverables to projects

nationwide.

Developed and wrote databases (using Microsoft Access and VBA) for several different projects. Designed Access

Database to track all field equipment locations, phone assignments, vehicle maintenance, field audits and evaluation

results. Database included front end dashboard and forms for ease of use

Reduced reporting time by as much as 50% by creating report templates (using Microsoft Excel) for Operations

Teamed with project supervisors, shipping, accounting, IT, and sales on different projects

Admin for Actsoft’s Comet Tracker program to capture payroll, production, and GPS breadcrumb data via cell phones.

Responsible for user setup, manager logins, troubleshooting, reconciliations reviewing breadcrumb data.

Vines Nursery Inc, Loganville, GA 2003-2004

Bookkeeper/Office Manager

Improved the system for posting and applying daily cash to simplify bank reconciliations

Maintained inventory controls which included adjustments for damaged/lost inventory, pricing updates, and form

development ensuring the accuracy of balance sheet information

Processed payroll and payroll taxes timely and accurately

Processed monthly sales tax

Write/post entries to Peachtree Professional Accounting software

Appliance Showcase, Lilburn, GA 2002-2003

Bookkeeper

Reconciled 9 separate bank accounts

Post daily sales into Quickbooks and reconcile with Swiftlink POS software

Process Accounts Payable

Process payroll for store employees through ADP

1 Page

Carla B. Houk – Resume (continued)

Accountemps, Duluth, GA 2000-2002

Accounts Payable Coordinator, Data Entry, and Bookkeeper

Matched invoices to receivers for a manufacturing company. Verified proper pricing, Keyed invoices into AS400

Accounting system. Resolved discrepancies between vendors and purchasers. Responsible for more than 60 vendors

Processed accounts payable for a lighting company. Matched invoices with purchase orders, input into Peachtree

Accounting Software. Processed checks. Reconciled a subsidiary company’s bank statement to Quickbooks.

H2 Technologies, Stone Mountain, GA 1999-2000

Customer Support Technician

Partnered with programmers to develop and troubleshoot the accounting link between ServiceWorks and Timberline

Accounting Software

Successfully resolved clients’ software issues via telephone, fax, and email

Tested new versions of ServiceWorks and accounting links to Peachtree Accounting, Quickbooks Pro, Starbuilder, Great

Plains, and Timberline accounting programs, documenting all issues in an info base

Peachtree Software Inc, Norcross, GA 1996-1999

Professional Services Support Technician

Resolved an average of 40 technical issues per day through incoming calls, faxes, and emails, specifically supporting

accounting professionals.

Compiled training information and taught training classes for new support technicians

Consistently received quality scores for 100%

Linton Piping & Construction Co, New Castle, PA 1994-1996

Office Manager

Managed and organized daily office activities

Developed and implemented a job cost system using Lotus 1-2-3. Prepared weekly job cost reports and monthly job profit

analysis reports

Implemented a computerized accounting system using ACCPAC software

Prepared monthly financial statements and reconciled bank statements to cash

Generated payroll and payroll taxes for a biweekly payroll of 40 employees

Prepared quarterly sales tax and payroll returns

Education

1983-1989 Grove City College, Grove City, PA

BA, Business Administration, Operations Management

Worked full time while attending college 1987-1989

1992-1993 Westminster College, New Wilmington, PA

Work toward Master’s Degree

Intermediate Accounting I,II and Auditing courses

Maintained a 3.7 GPA

2 Page



Contact this candidate