SQL Developer/Programmer

Dan Demshar

*** ******* ***. | N Chelmsford, MA *1863

978-***-**** ********@*******.***

SUMMARY

--Microsoft Certified Technology Specialist (MCTS) skilled in areas of database development, administration and RDBMS;

--Certified SQL technician adept at both client side and server side applications;

--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

--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

--Developed and maintained a data backup system to retain completed files to save time and money. Next Generation

--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

--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.

--SQL – Groups & querying, filtering, joins, views and indexes, transaction processing, cursors, security

--PHP & MySQL -- Installation, creating dynamic sites, error handling, apache installation & compatibility, developing web applications, cookies, sessions, security, content management, e-commerce

--Oracle 10g

--XML – DTD, entities, DOM, XSL style sheets, SQL Server usage

--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

--website design/layout including the creation and optimization of images;

--database design using RDBMS principles, including functioning and maintenance;

--retrieval of information in database by website using SQL queries;

--network fundamentals and troubleshooting and e-commerce.

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:

--Initiated proposal for a system to backup processed files previously deleted upon completion;

--Developed backup system using existing hardware/software resulting in no additional cost;

--Regularly backed up and removed processed files from system to free up space on server;

--Trained operators on retrieval system to enable them to implement system when needed;

--Saved company time and money since older files now available for reprints rather than needing to redo job.

Website Management:

--Updated website using Dreamweaver to reflect changes;

--Restored and enabled database to locate files used in past jobs;

--Programmed PHP upload function resulting in ability of customers to send files directly to company;

--Developed website capability to allow customers to view large PDF files for proofing purposes;

--Monitored requests for printing based upon displayed samples in company website.

Print Production:

--Made edits to customer files according to instructions to save customer time and frustration;

--Prepared customer files from application programs for print production;

--Created new print pieces from customer supplied text and graphics;

--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):

--Designed, implemented and maintained database containing records of all customer jobs;

--Developed ASP application to create and update customer jobs using SQL queries enabling account executives access to current customer job status;

--Implemented changes to database retrieval system to comply with company needs.

Commercial Website Design, Development and Maintenance (2000-2003):

--Designed the layout of the 70+ page website and over 100 graphics resulting in quick viewing;

--Implemented Perl script to allow for customer uploads;

--Wrote all copy for each page;

--Revised website to include pages for e-commerce resulting in order placement;

--Added computers and troubleshooted network connects to enhance system.

Data Administration:

--Backed up and maintained company files preventing loss of critical data;

--Restored corrupted or lost files from backup to save time needed to redo job.

Desktop Publishing:

--Designed brochures, newsletters, and other printed pieces to comply with customer guidelines;

--Manipulated images, paginated and imposed pages for accurate print production.

Contact this candidate