Developer Sql Server
Resume:
SEAN MANSPERGER
301-***-**** (cell) North Beach, Maryland 20714 ***********@*****.***
SECURITY CLEARANCE: Top Secret (Granted March 2009); SCI - June 2010 & June 2012
Yankee White - July 2011
TECHNICAL SKILLS
Microsoft SharePoint 2007/2010 Object-Oriented Programming Visual Studio 2005/2008; C#; .NET
SQL Server 6.5/7/2000/2005/2008 Transact-SQL WinCVS; Visual SourceSafe
Oracle 8i/9i/10g SQL*Plus, PL/SQL Microsoft Office Suite 2007/2010
PHP, HTML, CSS, JavaScript ColdFusion 4.5/5/MX Model-View-Controller (MVC)
SUMMARY OF QUALIFICATIONS
Strong analytical and problem-solving skills
4 years of SharePoint 2007/2010 development experience
Strong understanding of relational database concepts and ability to design and manage databases
Expert at writing and optimizing SQL queries; years of experience coding PL/SQL and Transact-SQL
stored procedures
Experience analyzing data objects, identifying relationships, gathering requirements, and developing
systems documentation
Ability to learn new applications, technologies, and programming languages quickly
WORK EXPERIENCE
Software Developer, Lead / SharePoint Developer 8/2011 Present
CACI International, Inc., Arlington, Virginia
Working onsite for WHMO/WHCA, develops KM solutions using SharePoint 2007/2010, ASP.NET, C#, HTML,
XSLT/XML, JavaScript, and CSS. Development of web based solutions includes building solution packages in
Visual Studio, developing custom workflows using SharePoint Designer, and creating custom SharePoint web
parts.
Trains customers to use features of SharePoint and KM applications. Participates in the creation of software
documentation, making effective use of UML diagrams and use cases. Works with team members to understand
and develop resolutions to software problems.
Software Developer / Principal Consultant 6/2010 7/2011
RGS Associates, Inc., Arlington, Virginia
Provided document automation solutions as a HotDocs developer to the Department of Justice's National Security
Division (NSD). This work involved creating, publishing, and maintaining HotDocs templates and scripts that
support the mission of the NSD. Supported the division's attorneys by resolving technical issues, and supported the
timely implementation of frequent updates. Helped train new attorneys who were unfamiliar with using the
HotDocs software interface.
Worked on an ASP.NET web application to simplify the data entry of complex data by division attorneys. The
database was SQL Server 2005, and I designed and created new database objects for this project. My SQL strengths
were appreciated by the team, since I was able to optimize existing queries and views. As one of the principal
consultants on this contract, I participated in the effort to integrate existing software applications for the division.
Page 1 of 3
Information Systems Specialist / SharePoint Developer 5/2007 6/2010
Technology Concepts & Design, Inc., Reston, Virginia
Developed SharePoint 2007 web sites and portals, using SharePoint Designer and Visual Studio 2008.
Developed custom SharePoint web parts, using C# with Visual Studio, and uses XSL Transformations
(XSLT) language to customize the display of data in SharePoint lists.
Developed content and document management solutions for customers, including the identification,
analysis, and documentation of the system requirements and the technical design.
As an onsite contractor with the Department of State's Office of Verification Operations of the Bureau of
Verification, Compliance and Implementation (VCI/VO), I worked with a team that specialized in setting up
SharePoint sites for the three supported bureaus.
Webmaster (Sr. Help Desk Support Specialist) 5/2006 5/2007
Advanced Resource Technologies, Inc., Alexandria, Virginia
Worked with Oracle 8i and 9i databases, and developed in-house Section 508 compliant web applications for the
Office of Medical Services at the Department of State. These applications used ColdFusion MX, JavaScript,
dynamic HTML elements, and CSS. Worked on projects over the entire life cycle; beginning with the collection of
requirements, writing technical specifications, prototyping, building the database, coding, testing and
implementation. Developed a web application to support the collection of overseas exam clinic data in an
anonymous survey format.
Programmer Analyst 4/2005 4/2006
Association of American Medical Colleges, Washington, DC
Lead developer of an online financial assistance application
Conducted business systems analysis and wrote UML use cases to be used by the testers
Scheduled and conducted interviews with the key users of the system
Worked on ColdFusion MX web applications with Oracle 9i databases, and worked on a PHP online registration
tool. Designed a significant database upgrade to an existing system and implemented the changes in Oracle 9i and
wrote PL/SQL stored procedures and functions. Concurrent development activities were supported with WinCVS.
Applications Developer 7/2004 - 4/2005
Caspian Sea, LLC, College Park, Maryland
As an onsite contractor for the FDA/Center for Food Safety and Applied Nutrition, I worked on web applications
that supported the management and tracking of food and food additive data. These applications used ColdFusion 5,
ColdFusion MX, and Oracle 9i. I created online reporting tools and an official certification generation tool for one
of the departments. This work required the ability to comprehend complex concepts and issues in the Biochemical
field so that the correct business rules could be determined and applied in the system. Additional responsibilities
included: testing and debugging other programmers' code, writing systems documentation, creating user help
guides, and managing revision requests and change control records for multiple applications.
Webmaster (Help Desk Support Specialist) 10/2003 - 7/2004
Advanced Resource Technologies, Inc., Alexandria, Virginia
I was rehired in May 2006 by this employer for the same contract. The duties of the positions were similar.
Senior Programmer/Analyst 2/2000 - 7/2003
QRC Division of Macro International Inc., Bethesda, Maryland
Worked on Web-based data collection instruments (online surveys) for the National Science Foundation and
Page 2 of 3
National Institutes of Health. Used SQL Server 6.5 and 7 databases; with some systems using ColdFusion 4.5, and
some using proprietary software. Worked on Access 97 and 2000 applications that provided survey data entry,
tracking, and reporting. Performed database management and design consulting and created Transact-SQL stored
procedures for complex, rule-based validation of the survey data.
IT Support Specialist/Manager of the Computing Assistance Desk 12/1998 - 1/2000
University of Maryland, Baltimore, Health Sciences & Human Services Library
Responsible for a computer lab, which was used by students, faculty, and staff of the university
Hired and trained part-time employees to staff the lab; managed the work schedule and timesheets
Provided help desk support to callers and responded to email inquiries
Served as a back-up trainer for the computer classroom
Created an Access 97 application that tracked the customer support that was provided in the library
Data Specialist 9/1992 - 12/1998
Estate Recoveries Incorporated, Baltimore, Maryland
Responsible for processing weekly and monthly collection reports, and preparing/receiving EDI files containing
financial data. Created queries and reports in Access 2.0, 95, and 97. Developed and updated data entry interfaces.
EDUCATION
Graduate Certificate in Database Technology (Oracle 10g DBMS), GPA 3.7 5/2006 -Present
University of Maryland, University College, 9 credits completed of 12
Master of Science, Business, Specialization in Management Information Systems, GPA 3.8 12/2001
University of Baltimore, Maryland
Bachelor of Arts, Biology 05/1992
McDaniel College, Westminster, Maryland
CERTIFICATIONS
Project Management Professional (PMP) August 2011
CompTIA Security+ ce January 2012 Verification Code: H1YDCZ3KQDR42DCF
ADDITIONAL TRAINING
Fundamentals of Project Management 36 hours RGS Associates 02/2011
Introduction to Oracle9i: SQL exam (1Z0-007) Passed 03/2007
Introduction to Oracle9i: SQL and Oracle 9i Database: Fundamentals I SkillSoft 02/2007
Java Levels I, II, & III Montgomery College Information Technology Institute 03/2006
Class Diagramming Essentials and Object-Oriented Design The Inteq Group 12/2005
Introduction to PHP On-site training provided by AAMC 11/2005
Business Systems Analysis (using UML) The Inteq Group 05/2005
HTML 3.2 Brainbench Certified Master Transcript ID#: 1972380 12/2004
Allaire's Advanced ColdFusion Development course for ColdFusion 4.5 12/2000
Page 3 of 3
Contact this candidate