John L. Herritt

*** ****** *****

Shippensburg PA 17257

717-***-**** (Home)

410-***-**** (Cell)

Email: vnacxj@r.postjobfree.com

Website: http://archangel0628.blogspot.com/

CAREER GOALS:

My life goals are to find long term, stable employment in the IT industry where I can provide financial security for myself and family. My ideal job is where I have a variety of responsibilities and I can enhance my current skills and develop new ones. I especially enjoy working on projects that helps people, especially children.

SUMMARY:

• Many years experience in a variety of roles:

• Configuration Management, Requirements Gathering, Systems Development.

• Network/Systems/Database Administration and Design.

• 10+ years as Oracle database developer/designer/administrator.

• 10+ years of data conversion and consolidation experience.

• Excellent communication and client interaction abilities.

• Outstanding multi-tasking and organizational skills.

EXPERIENCE:

Hardware: IBM PC; Macintosh; IBM 3090; IBM 4330; UNISYS Mainframe; IBM System 36, 38; IBM AS 400; Honeywell Midrange; SanDisk Remote Storage.

Operating Systems: Windows NT; XP; 2000; 2003; VISTA; UNIX; Linux; IBM MVS OS; OS400; AOS VS; DMS 1100; Mac OS

Networking Systems: Novel Netware 286; 386; 2.0; 3.0; 4.0; Banyan Vines; Microsoft Exchange; MS SharePoint; NBI; Lotus Notes

Software: Microsoft Excel; PowerPoint; Word; Microsoft Project; Word Perfect; Lotus 1-2-3; Erwin/ErBot; ClearCase; ClearQuest; Crystal Reports; InstallShield; Internet Explorer; Microsoft FrontPage; Visual Basic; Rational Suite; SQL Server Reporting Services; SQL Server Analysis Services.

Databases: MS SQL Server; Oracle; Sybase; Microsoft Access; FoxPro; Dbase; DB2; Lotus Notes; ADABAS.

Languages: Visual Basic; Clipper; C; C++; C#; Visual FoxPro; VBA; Natural; COBOL; XML; VB Script; Java Script; FoxBASE; FoxPro; FoxPro for Windows; Java.

Tools: Visual Studio; Visual InterDev; Cold Fusion; ADO; ActiveX; ASP; .NET; ASP.NET; HTML; RequisitePro; Expediter; CA-InterTest.

OPERATIONAL SKILLS OVERVIEW:

• Designed and developed a hardware inventory database using MS Access in a two week time frame (Headstrong).

• Designed both physical and logical data models for data migration from IBM mainframe to Oracle and SQL Server (HCL Technologies, Independent Consultant, Centech Group, STG, Premier Incorporated, Lockheed Martin)

• Created configuration management, disaster recovery, system re-engineering, system requirements, and project work plans (McDonald-Bradley, 01/1990 – 12/1991; Premier Incorporated, 02/1994 – 10/1994; VistaRMS).

• Developed and edited technical and end user documentation (Centech Group; STG; SAIC; Premier Inc.; Lockheed Martin (10/1992 – 03/1993).

• Assisting in preparing IT budgets (Arlington County Government (01/1989 – 01/ 1990; Center for Defense Information (04/1988 – 10/1989); Smithsonian Institution (04/1992 – 10/1992).

• Developed large scale applications using Active X, ASP, .NET, Clipper, VBA; Visual Basic 6.0; Visual FoxPro 7.0 (Centech Group; STG; SAIC; Independent Consultant; Premier Inc; Smithsonian).

• Provided end user support for all Microsoft Office applications (Sojourner Douglass College; VGS; DECO Security).

• Authored change management policies and procedures (Centech Group; STG Inc.; COMSO)

• Created web pages with XML, HTML, Java Script, VB Script, ASP, Visual Studio, Visual InterDev, .NET, VB.Net and Cold Fusion (Centech Group; SAIC; Vista RMS; Independent Consultant).

• Created triggers, stored procedures, for SQL Server, Oracle, and Sybase (Lockheed Martin; Maden Technologies; Independent Consultant; SAIC; STG).

• Database design, development, and administration for MS Access, FoxPro, SQL Server, Oracle, Sybase, and DB2 databases (Centech Group; McDonald – Bradley; DECO; RMSI; Sysorex (08/1995 – 01/1996).

• Implemented configuration management using Visual SourceSafe. PVCS (Serena® Tracker), ClearCase, ClearQuest and change control processes for mainframe, web, client-server, and embedded systems. (Headstrong; Centech Group; SAIC; COMSO; CENCOR).

• Performed data modeling/process modeling using Erwin/ErBot, Rational Rose, and Oracle tools (Headstrong; STG; COMSO; CENCOR)

• Has supervised teams of up to 12 developers (STG; COMSO; CENCOR)

• Converting FoxPro data to Oracle (CENCOR).

• Created and maintained document and forms management systems (SAIC; McDonald-Bradley; VGS/VistaRMS; Arlington County Government; PRC; Lockheed Martin; UNISYS)

RECENT WORK EXPERIENCE:

Documentation Specialist/Developer Armed Forces Services Corporation

December 2010 – February 2011 Alexandria, VA

• Authored functional requirements document using Microsoft Word to assist with systems conversion project from ADABAS/Natural to .Net/C#/SQL Server 2008.

• Assisted in the creation of configuration management plan.

• Imported the structures for 20+ ABABAS tables using Excel Spreadsheets for data dictionary.

• Created logical data model using Visio Professional 2010.

• Authored test scripts for the converted system using Microsoft Word and SnagIT.

Board of Directors Helping Other People through Empowerment

August 2005 – Present Baltimore, MD

• Currently sitting on Board of Directors for drop-in/referral center and transitional housing for mentally ill/homeless of Baltimore

• Responsible for administration of a combined annual budget of over $800,000

• Responsible for management personnel changes

• Assisted with relocation from 1426 Fairmount Avenue to 2828 Loch Raven Road in Baltimore MD.

Business Analyst II Exelon Energy

August 2010 – October 2010 Philadelphia PA

• Functioned as a Business Analyst assigned to Marketing Division

• Utilized MS Excel and MS Access to analyze performance of energy saver programs for residential and commercial customers.

• Created contract forms using MS Word and MS Access.

Consultant HCL Technology

November 2009 - December 2009 Whitehouse Station, NJ

• Temporary assignment at Merck & Co., Inc. in White House Station, NJ

• Migrating ADABAS data to Oracle 9i platform

• Using JCL and Oracle SQL Loader Utility

• Performed data validation testing

• Created project work plan, data mapping, and system documentation

Senior Systems Engineer Net World Technology

August 2009 – October 2009 Carlisle, PA

• Performed .Net and SQL Server 2008 maintenance development on an inventory management application for NAVSISA at Naval Support Activity in Mechanicsburg PA.

• Used Visual Studio 2008 with Team Foundation Server for version control

• Utilized Microsoft SharePoint Network 2008 with .Net for interface with Microsoft Internet Explorer

• Used SQL Server Reporting Services and SQL Server Analysis Services

• Reviewed testing requirements for compliance to Federal government standards

SQL Server DBA Disys

August 2008 – September 2008 Boston, MA

• Performed DBA functions for General Dynamics’ DOD client (Maxwell – Gunter AFB in Montgomery AL)

• Working with clustered servers with MS SharePoint at Lackland AFB (TX), Hickham AFB (HI), Barksdale AFB (LA) along with two test gateways

• Authored analysis document for assisting client in deal with performance issues utilizing physical data models (ERD diagrams), data dictionaries, and documentation of triggers and stored procedures for several SQL Server and Oracle applications

• Configuring DNS and TCP/IP servers for data transfer

• Authored deliverable for making recommendations on server optimization

• Used SQL Server Reporting Services and SQL Server Analysis Services

• Performed and reviewed test scripts involving SQL Server

• Utilized Microsoft SharePoint Network 2005 to create interface for Microsoft Word and Microsoft Outlook

Software Engineer Aerotek

March 2008-May 2008 Baltimore, MD

• Performed VBA development/analysis for an Excel application migration from Office 2003 to Office 2007 while in Becton-Dickenson in Rockville. MD

• Utilized code libraries from various sources ( i.e., Adobe Acrobat), along with ActiveX controls for a bio-medical research application

• Converted UNICODE and International File formats into ASCII

• Setup FTP services on workstations for data transfers

• Utilized Smart Client Software Factory and CAB for distribution.

• Authored and performed functional and validation testing

Volunteer Project HOP (t) E

November 2006 – March 2008 Baltimore, MD

• Working as a volunteer at Sojourner-Douglass College and Helping Other People

• (through) Empowerment in Baltimore, MD (A drop in and referral center for the mentally ill homeless)

• Supporting Microsoft Office (Word, Excel, PowerPoint, Access) and Visual FoxPro applications

• Assisting students and clients to create spreadsheets using Excel, documents using Word, PowerPoint presentation, and MS Access databases

• Assisted clients with setting up email accounts on Yahoo, Gmail, and Hotmail

Data Analyst Syscom Technologies

September 2007 – October 2007 Herndon, VA

• Was performing data analysis using Excel while a consultant with Verizon in Silver Spring MD

• Analysis took Oracle 10g data using PL-SQL from a web-based application that tracked customer and billing information.

• Converted UNICODE and International File formats into ASCII

• Modify web pages using Cold Fusion

• Utilized Eastman workflow for logical data model

• Used Excel VBA for analysis and reports

• Purpose of project was to improve database security for Verizon’s government customer accounts.

• Utilized Microsoft SharePoint Network 2005 to create interface for Microsoft Word and Microsoft Outlook

Configuration Management Specialist Headstrong, Inc of Fairfax VA

August 2006 – November 2006 Annapolis Junction, MD; Largo, MD

• Providing hardware configuration management for Harris Corporation for their Bureau of the Census contract

• Assisted data modeling team in creating a logical and physical models

• Using Oracle 10g databases and PL-SQL with Oracle Application Express on UNIX platform

• Raid Level 0 Storage Configuration – RAC Configuration

• Using ClearCase, ClearQuest, and RequisitePro (Rational Tools) for software configuration management

• Part of CCM and CCB boards

• Utilized Microsoft SharePoint Network 2.0 for file sharing and file transfer

Independent Consultant – SQL Server DBA/Database Designer/System Administrator/

User Support Analyst (February 2005 – August 2006) Baltimore, MD; Washington, DC

• Working as a volunteer at Sojourner-Douglass College and Helping Other People (through) Empowerment in Baltimore, MD (February 2005 – August 2006).

• As a consultant for the Maryland State Highway Administration (December ‘05-January ‘06), assisted with re-engineering Clipper and Excel (VBA) document management applications to the web using Cold Fusion and ASP.NET

Independent Consultant – SQL Server/Microsoft Access DBA/Database Developer/Cleared American Guard/System Administration (August 2003 – February 2005) Edgewood, MD; Worcester, MA; Freetown, Sierra Leone

• As a Cleared American Guard with Deco Security Services of Alexandria, VA for their US State Department contract. Created document templates using Microsoft Word.

• Provided database administration for MS Access database.

• Converted UNICODE and International File formats into ASCII

Centech Group of Arlington VA – Senior Programmer/Analyst (February 2003 - August 2003)

• Performed maintenance programming for document management application using ADABAS/Natural for their FBI contract; Improved system performance by modularizing code

• Used Expediter for batch processing

• Created logical and physical models of personnel systems using ErWin

• Data Migration of legacy applications (ADABAS) to Oracle 9i with PL-SQL

• Wrote DDL and DML stored procedures

• Used Cold Fusion, XML, C# and ASP.NET for creating web forms

• Performed functional and end user validation testing.

• Modifying JCL

VistaRMS of Reston, VA– Independent Contractor – Database Modeler (November 2002 - January 2003)

• Performed requirements gathering for a software re-engineering project

• Created ERD diagrams for MS Access database migration to SQL Server

• Creation of triggers and stored procedures for SQL Servers

• Utilized .Net 1.0 objects in forms.

• Performed project management was using Microsoft Project

Independent Consultant – Database Designer/Modeler/DBA/Business Analyst (July 2001 -August 2002) Arlington, VA; Glen Burnie, MD

• Performed data modeling with Maden Technologies for their DOD client using Oracle modeling tools.

STG of Fairfax, VA - Senior Database Designer (February 2000 - July 2001)

• On their Department of State contract, completed development of agency wide medical document management database application

• Merging MS Access data into the main Oracle 9i personnel database

• Used Crystal Reports v8.5 for reports

• Supported Visual FoxPro financial applications

• Utilized Access VBA code for developing form, queries, and reports

• Merge data from remote overseas posts to main Oracle inventory database

• Creation of PL-SQL triggers and stored procedures for Oracle 9i databases

• Created CSS using Cold Fusion for designing forms for intranet application

• Supervised data entry and end user documentation

• Converted UNICODE and International File formats into ASCII

• Performed end user validation testing using test scripts

• Utilized Documentum tools

• Created logical and physical models of Diplomatic Security inventory applications using Rational Rose

Saturn GM – Independent Consultant – Database Designer/Systems Analyst (August 1999 - January 2000) Columbia, MD; Wilmington, DE

• Used ASP.NET, ASP, IIS, Cold Fusion, along with WISE Installer, for an e-commerce application while an independent consultant in Columbia, MD.

• Migration of Clipper data/application to Visual Basic 6.0 and Crystal Reports v7.5 for DOD client (BuMed) in Columbia MD

• While with Saturn GM, supervised the development of forms for an application for monitoring quality on the production line using CorelDraw with Informix databases on a UNIX platform

SAIC of Abingdon, MD - Senior Analyst/Programmer (August 1998 - August 1999)

• Developed distribution process for enterprise wide client – server and web based applications

• Used .NET, ASP, and Install Shield, for a web enabled document management database application with text search capabilities.

• Used Cold Fusion and ASP.NET for web enabling project management system.

• Received CMM level 4 training.

• Wrote Excel VBA code for automating data conversion application

RMS International of Reston, VA - Programmer/Analyst (Technical Lead), (October 1997 - August 1998)

• For their Department of Defense (PA & E) contract, created project work plans, database models (Sybase 8.0) and performed project management was using Microsoft Project.

• Developed document management system for budget process using Docupact, Visual Basic 6.0, C++, and C#

• Supported Visual FoxPro and FoxPro for Windows 2.6 personnel

EDUCATION:

BS Ferrum College - Ferrum, Virginia - Major: Mathematics and Religious Studies

MTS Wesley Theological Seminary - Washington, DC - Major: Biblical Studies

Contact this candidate