Crystal Gleim

*** ******* **., *********, ** ****3

P: 803-***-****

E: acx82s@r.postjobfree.com

Skills:

7+ years of advanced skills in Access and SQL development using Microsoft SQL Server Studio

7+ years of advanced skills in Excel development

4+ years of experience with VBA coding

Experience creating web and windows applications in ASP.NET and ADO.NET

Data mining experience in SalesForce

Proficient with; Office 365, SharePoint, Adobe Photoshop, Adobe FrameMaker and Adobe Acrobat, Quark Xpress, Adobe PageMaker and Java coding

Experience:

Awards Network May 2016 to Dec 2016

Account Specialist (75% Access/25% SQL)

Importing and exporting data using Access and SQL to process orders from clients.

Building of macros in Excel increase customer usability in order processing.

Work with Sales Team and Account Managers to provide clients with a program that meets their employees’ needs.

Data mining in SalesForce to provide Sales with reports to help secure clients.

Data mining in SalesForce to provide clients with the information they need to track their awards programs.

Lubeznik Center for the Arts Sep 2014 to May 2016

Database Manager (80% Access/20% SQL)

Handled incoming financials for a non-profit organization using FastFund accounting software.

Separated non-financial information from FastFund into an in-house Access database.

Designed, constructed, and documented a database utilizing MS Access with VBA.

Handled all statistical and analytical reporting for marketing department.

People 2.0 Global/PWC/Virtual Business Associates Jun 2011 to Jul 2014

Data Analyst (90% SQL/10% Access)

Designing, maintaining, and modifying Access/SQL databases for major healthcare clients.

Write code to connect, to retrieve data from, and update data in a database in a server-side application.

Design a database in Microsoft SQL Server Studio.

Experience converting system from Access server to SQL server.

PCHO-Apple/Best Buy Mar 2009 to Jan 2010

Sales Associate

Worked as a Computer Sales Associate & Certified Apple Consultant selling hardware and software.

Aided in Geek Squad computer setup and preloading of software for computer packages.

Free Times (Portico Publications) Jun 2007 to Jul 2008

Advertising Assistant

Handled copy and payments for advertisements in a free weekly paper.

Sold advertising via in-person and phone.

Maintained an Excel record of advertising associate’s sales, appointments, and records.

Bruccoli, Clark, Layman Inc. Jan 2005 to Jun 2007

Editorial Associate/Photo Editor (85% Access/20% SQL)

Maintained a functioning database using Access and SQL to keep track of all visuals used in the company’s academic publications in order to provide an electronic archive.

Worked in Excel & Access to maintain a database for copyrighted material.

Started as an editorial associate, editing copy for academic publications.

Promoted from editorial associate to Copy Right & Permissions assistant- handled obtaining copyright and permissions for any quotes, illustrations, or photographs used in academic publications.

Received second promotion to Photo Editor where I handled choosing photographs and illustrations for academic publications. Obtained copyright/permissions for stated visuals.

Education:

Associate Degree in Computer Technology

Midlands Technical College

Bachelor Degree in Communications/Journalism

Shippensburg University

Contact this candidate