Sql Server Customer
Resume:
Dan Demshar
*** ******* ***. * **********, MA ***63
978-***-**** ********@*******.***
Summary
o MICROSOFT CERTIFIED TECHNOLOGY SPECIALIST (MCTS) SKILLED IN AREAS OF
DATABASE DEVELOPMENT, ADMINISTRATION AND RDBMS;
o Certified SQL Fundamentals technician adept at both client side and
server side applications;
o Detail oriented with interpersonal skills in a quick paced team
environment with the ability to work independently. Motivated to take on
additional responsibilities as needed. Willing to learn new skills.
Areas of expertise and professional/technical competency include
. SQL Server 2005
. SQL
. PHP/MySQL
. CGI/Perl
. XML
. DHTML
. AJAX
. Javascript
. CSS
. HTML/XHTML
. Access
. Dreamweaver
. QuarkXPress/InDesign
. Illustrator/Photoshop
. Acrobat/Distiller
. MS Word/Excel
Career Highlights
o DEVELOPED AND MAINTAINED COMPANY WIDE DATABASE DRIVEN WEB TRACKING SYSTEM
USING SQL QUERIES TO SOLVE PROBLEM OF JOB TRACKING SAVING COMPANY OVER
$10,000. EAGLE GRAPHICS
o Developed and maintained a data backup system to retain completed files
to save time and money. Next Generation
o Designed, developed and maintained both client side and server side
application components for a 70+ page company commercial website. Eagle
Graphics
Certifications
MICROSOFT CERTIFIED TECHNOLOGY SPECIALIST (MCTS) 2010
SQL Server 2005
SQL ANSI Fundamentals Certification from Brainbench 2010
SQL ANSI Certification (for experienced users) from Brainbench 2010
Education/Training
SALEM STATE COLLEGE, SALEM, MA 2009
WEB DATABASE DEVELOPER CERTIFICATE
o SQL Server 2005 implementation and administration - Installation,
database/object creation, querying, data transfer, stored procedures,
functions, triggers, XML framework, maintenance & backup, log
shipping, monitoring performance, publisher/distributor/subscriber,
troubleshooting and optimizing, security.
o SQL - Groups & querying, filtering, joins, views and indexes,
transaction processing, cursors, security
o PHP & MySQL -- Installation, creating dynamic sites, error handling,
apache installation & compatibility, developing web applications,
cookies, sessions, security, content management, e-commerce
o Oracle 10g
o XML - DTD, entities, DOM, XSL style sheets, SQL Server usage
o HTML, XHTML, CSS, DHTML, Javascript, AJAX, CGI/Perl - including web
design and web publishing
Chelmsford Community Education, Chelmsford, MA 2009
FUNDAMENTALS OF TECHNICAL WRITING, WRITING GREAT TECHNICAL DOCUMENTS
Clark University Computer Career Institute, Cambridge, MA 2000
WEBMASTER CERTIFICATE
o website design/layout including the creation and optimization of
images;
o database design using RDBMS principles, including functioning and
maintenance;
o retrieval of information in database by website using SQL queries;
o network fundamentals and troubleshooting and e-commerce.
Dan Demshar
Page 2
Abilene Christian University, Abilene, TX
MASTER OF ARTS
Completed 3-year course of studies in Language.
University of California/San Diego
BACHELOR OF ARTS
Completed 4-year course of studies in biology/pre-med.
Relevant Experience
NEXT GENERATION PRINTING, CANTON, MA 2003 - 2009
PRINT PRODUCTION/DATA ADMINISTRATOR/WEBMASTER
Data Administrator
o Initiated proposal for a system to backup processed files previously
deleted upon completion;
o Developed backup system using existing hardware/software resulting in
no additional cost;
o Regularly backed up and removed processed files from system to free up
space on server;
o Trained operators on retrieval system to enable them to implement
system when needed;
o Saved company time and money since older files now available for
reprints rather than needing to redo job.
Website Management
o Updated website using Dreamweaver to reflect changes;
o Restored and enabled database to locate files used in past jobs;
o Programmed PHP upload function resulting in ability of customers to
send files directly to company;
o Developed website capability to allow customers to view large PDF
files for proofing purposes;
o Monitored requests for printing based upon displayed samples in
company website.
Print Production
o Made edits to customer files according to instructions to save
customer time and frustration;
o Prepared customer files from application programs for print
production;
o Created new print pieces from customer supplied text and graphics;
o Developed close relationship with client resulting in generation of
over $100,000 in last 10 years alone.
Eagle Graphics, Inc., Boston, MA 1987 - 2003
DESKTOP PUBLISHING/ WEBMASTER/DATA ADMINISTRATOR
Database Driven Web Application Development and Maintenance (2000-2003)
o Designed, implemented and maintained database containing records of
all customer jobs;
o Developed ASP application to create and update customer jobs using SQL
queries enabling account executives access to current customer job
status;
o Implemented changes to database retrieval system to comply with
company needs.
Commercial Website Design, Development and Maintenance (2000-2003)
o Designed the layout of the 70+ page website and over 100 graphics
resulting in quick viewing;
o Implemented Perl script to allow for customer uploads;
o Wrote all copy for each page;
o Revised website to include pages for e-commerce resulting in order
placement;
o Added computers and troubleshooted network connects to enhance system.
Data Administration
o Backed up and maintained company files preventing loss of critical
data;
o Restored corrupted or lost files from backup to save time needed to
redo job.
Desktop Publishing
o Designed brochures, newsletters, and other printed pieces to comply
with customer guidelines;
o Manipulated images, paginated and imposed pages for accurate print
production.
[pic]
[pic]
[pic]
Contact this candidate