Crystal Gleim
*** ******* **., *********, ** ****3
P: 803-***-****
E: ********@*****.***
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