Sql Server Years Experience 10
Resume:
David L Crandall
Wilmington, NC 28412
Phone: 910-***-****
Email: *****.***.********@*****.***
Detail-oriented IT professional with seventeen years of experience as an
applications developer, systems support, and systems/network technician.
Skilled at operating in a wide range of platforms and programming
languages. Excellent written and oral communication skills, capable of
explaining complex software issues in easy-to-understand terms.
KEY SKILLS:
Communication:
Ability to communicate with internal and external customers at all levels
via telephone, conferences and email, to ensure successful communication
via actively listening and probing questions.
Problem solving:
Resolves in-depth queries in a methodical manner independently and with
internal and external business partners to find appropriate resolutions,
efficiencies and high level of quality.
Planning and organizing:
Refined planning and organizational skills that balance work, team support
and ad-hoc responsibilities in a timely and professional manner.
Systems knowledge:
Windows XP, Windows 7, Microsoft Office, Microsoft SharePoint Server 2007
and 2010, Oracle (7, 8i, 9i, 10g), SQL Server (2000, 2005, 2008, 2008R2).
Developmental languages/tools:
TSQL, PL/SQL, SQL Plus, HTML, CFML, CSS, XML, Java, JavaScript and .Net.
(Currently studying HTML5, CSS3 and MVC using on-line resources and
purchased publications)
Adobe Creative Suite, Visual Studio, SQL Server Management Studio, SQL
Server Reporting Services (SSRS), SQL Server Integration Service (SSIS),
Microsoft SharePoint Designer 2007 and 2010, Quest TOAD, Oracle BI
Discoverer, Oracle Forms and Reports Developer.
Solid understanding of RDBMS principles, database design and normalization.
Expertise in complex query design, stored procedures, views and functions.
Development in Object Oriented programming. Experienced programmer,
capable of creating, optimizing and troubleshooting complex SQL code used
in application development.
IT Project Lifecycle:
Requirements Analysis, ROI Analysis, Cost & Budgeting, Project Scheduling,
Testing, Q/A, Rollout and Support.
SECURITY CLEARANCE
Current TS/SCI, termination date - 05-09-2016
PROFESSIONAL LICENSES/CERTIFICATES
CompTia Security+
ITIL v3
Six Sigma Black Belt
EXPERIENCE
08/2010 to 07/2013; 40 hours per Week; IT Specialist (INET); GS-2210-13; 3
yr Term Appointment; not on a temporary promotion; II Marine Expeditionary
Force (II MEF), Camp Lejeune NC 28542.
Duties include: Directed the activities of contractors and support staff in
Portal and Collaboration Support and development of II Marine Expeditionary
Forces websites. Provide technical support to II MEF Staff and Subordinate
Commands for SharePoint, Adobe Connect and .Net application development.
Responsible for ongoing design of portal: site redesigns, new pages,
features and site maintenance.
Responsible Officer of 2.6 million dollar inventory for the II MEF IMO
equipment.
Manage large-scale initiatives involving the transition of programs to new
platforms and the merger of disparate systems.
Achieved seamless migration of Domino web site to SharePoint portal and
integrations transparent to client customers, accomplished with no
unscheduled downtime. Conducted review of the Disaster Recovery Plan used
by II MEF support staff and directed changes to insure the portal is
available 24/7. Back-up and restore procedures have been tested and
implemented.
Successfully deployed with 2d MEB in support of Bold Alligator 12 and Bold
Alligator 13. SharePoint availability was 100% during both exercises.
Reason for leaving this position: Retired from Government Service 30 June
2013.
12/2007 to 08/2010 ; 40 hours per Week; IT Specialist (DATAMGT); YA-2210-
02/GS-2210-12; permanent employee; not on a temporary promotion; FRC-E, PSC
Box 8021 Code 7.2.2.2 Cherry Pt NC 28533-0021; Jennifer Dudley, 252-464-
7218; may contact supervisor.
Duties include:
Lead Developer/Web Administrator. Serving as Lead developer and manager of
the FRC-East Intranet, and external Internet web sites. Creating both local
intranet and external Internet sites on Windows IIS servers, insuring IIS
is configured to Navy specifications. Ensure the servers are operating
securely, and all required security updates are current. Review log files
and page coding to find tendencies that may affect the usage and security
of the web sites.
Coordinate efforts of the local and NAVAIR Corporate web developers to
insure all web applications in use within NAVAIR are developed within
guidelines and are working properly at all times.
Responsible for the Oracle data warehouse.
Reason for leaving this position: Promoted to GS-13 position.
10/2000 to 12/2007; 40 hours per Week; Computer Specialist; GS-2210-
11(INET); permanent employee; not on a temporary promotion; FRC-East, PSC
Box 8021 Code 7.2.2 Cherry Pt NC 28533-0021; Theresa Butch, 252-***-**** ;
may contact supervisor.
Web Server Administrator. Seven years experience. I served as the manager
of the FRC-East Intranet and external Internet web servers.
Duties include: Creating both local intranet and external Internet sites on
various types of servers, insuring IIS is configured to local and corporate
specifications, add users and set access permissions, and studying the log
files to find tendencies that affect the usage of the web sites. Local
Intranet was a ColdFusion front end with SQL Server database back end.
ColdFusion Administrator and Programming. Six years experience
administering the ColdFusion servers by configuring data sources, setting
processes that are run at scheduled times/days. Insuring the different
servers are updated and patched to the latest levels. Created databases and
stored procedures in support of developed CF applications.
Developed CF applications using stored procedures and in line SQL queries
to input, store, and present data utilized by manufacturing, logistics and
personnel offices.
Dealt with various SQL Server issues while creating tables and relation
between the tables, adding, updating and deleting the data in the tables
and also developed complex stored procedures, functions, packages.
Microsoft SQL Server administrator. Nine years experience installing MS/SQL
Server, creating and maintaining databases, creating and setting user
permissions.
Oracle Database administrator. Six years experience. Duties include;
Creating/changing tables, creating stored procedures, creating users and
setting permissions, creating and maintaining backup processes, and
insuring data types are functional to the applications.
Reason for leaving this position: Promoted to GS-12 Lead Developer
position.
02/1998 to 10/2000; 40 hours per Week; Computer Specialist; GS-0334-11;
permanent employee; not on a temporary promotion; NAVAVNDEP Cherry Pt, PSC
Box 8021 Code 7.2.4.2 Cherry Pt NC 28533-0021.
Performed preventive and corrective maintenance on Desktop Computers,
computer peripherals and network hardware.
Technical Lead and administrator of the Remedy Help Desk application -
Duties included; SQL server administration and development of applications
(Help Desk, asset tracking, work flow, and reporting)
Produced ad-hoc queries and developed reports to support business needs.
Reason for leaving this position: Due to the Navy Marine Corps Internet
contract I was moved into a developer position.
04/1996 to 02/1998; 40 hours per Week; Electronics Digital Computer
Mechanic; WG-2608-11; permanent employee; not on a temporary promotion;
NAVAVNDEP Cherry Pt, PSC Box 8021 Code 7.2.4.2 Cherry Pt NC 28533-0021.
Performed preventive and corrective maintenance on Desktop Computers,
computer peripherals and network hardware.
Reason for leaving this position: Promoted to GS-11 Computer Specialist.
12/1995 to 04/1996; 40 hours per Week; Electronics Digital Computer
Mechanic Leader; $12 per Hour; permanent employee; not on a temporary
promotion; MANCON contracted employee located at MCAS Cherry Pt, NC.
Performed preventive and corrective maintenance on Desktop Computers,
computer peripherals and network hardware.
Reason for leaving this position: Moved from contract to full time
Government employee at same location.
U.S. MARINE CORPS SERVICE INFORMATION
Active Duty: 07/1975 to 08/1995 - U.S.M.C Retired
Campaign badges and expeditionary medals received:
Southeast Asia Service Medal w/ 3 Devices, Kuwait Liberation Medal,
Navy Achievement Medal, National Defense Service Medal,
Humanitarian Service Medal, and Sea Service Deployment Ribbon
Honorable Discharge
Retirement Rank: SSGT.
Retirement date: 08/01/1995
EDUCATION
Oak Park High School, Kansas City, MO; 1975 High School Diploma
PROFESSIONAL TRAINING
Six Sigma Online May 2012
Exin - ITIL version 3 March 2011
Blue Star Learning Security+ Jan 2010
Conducting Effective Peer Reviews Feb 2009
In Search of Excellent Requirements Feb 2009
Oracle Database 10g: Backup, Recovery and Server Tuning Feb 2008
Developing SQL Queries for Oracle Databases Feb 2008
Yellow Belt Training - Airspeed, Sept 2007
NDMS Life Cycle Management Plan, Sept 2007
Oracle Reports Developer 10g: Build Reports, Sept 2006
Oracle Forms Developer 10g:Build Internet Applications Ed1, Aug 2006
Accelebrate, Intro to Fusebox 4.1, Sept 2005
Oracle 9i: Programming with PL/SQL, Jun 2003
Productivity Point, Building Oracle XML Applications, Sept 2002
Interactive Fun, Macromedia Advanced Dreamweaver Week, Nov 2001
Interactive Fun, Macromedia Dreamweaver 4 Advanced, Aug 2001
Interactive Fun, Macromedia Dreamweaver 4 Basics, Aug 2001
Allaire, Fast Track to ColdFusion, Mar 2001
PROFESSIONAL RATINGS, AWARDS, AND RECOGNITIONS
Performance Award - Time off award 1 Oct 2011 through 30 Sep 2012
Performance Award - Time off award 1 Oct 2010 through 30 Sep 2011
NSPS Rating of Record 4.0 for appraisal period 1 Oct 08 through 30 Sep 2009
Award tokens 8/7/2009, 6/26/2009
Letters of Appreciation 3/9/2009, 7/31/2002, 7/6/1998
Special Act Award 9/5/2008
OTS Awards 05/30/08, 2/9/1999
SEA Awards 7/20/2007, 6/13/2006, 7/18/2005
Individual Cash Award 6/23/2003
Performance Award 5/26/2000
Service Awards 8/29/1999, 8/30/1998, 8/31/1997, 9/19/1996
Contact this candidate