Sr SAS Developer & Analyst

John L. Herritt

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

Shippensburg PA 17257

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

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

Email: ************@*****.***

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.

CLEARANCE:

August, 2009 (Active) - Top Secret

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

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; MS SharePoint; 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).

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

Page Two Resume of John Herritt

OPERATIONAL SKILLS OVERVIEW (CONT):

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

Consultant HCL Technology

November 2009 - Present 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

• Used SQL Server Reporting Services and SQL Server Analysis Services

• Reviewed testing requirements

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

• 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

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

Page Three Resume of John Herritt

• Converted UNICODE and International File formats into ASCII

• 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

• Used Excel VBA for analysis and reports

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

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 for software configuration management

• Part of CCM and CCB boards

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

Page Four Resume of John Herritt

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

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

Page Five Resume of John Herritt

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

COMSO, INC., Greenbelt, MD – Senior Programmer/Analyst (May 1997 - October 1997)

• For their FDIC contract, supported, maintained, nationwide financial/credit applications

• Created database models.

• Administered, provided user support, trained and used PVCS as a version control and baseline storage tool

• Assisted with testing and revising of new C++ libraries for the Windows NT platform

• Assisted with migration of Clipper applications and data to Windows NT/SQL Server environments

• Creation of SQL Server triggers and stored procedures

• Performed support development for Visual Basic and Crystal Reports v7.0 document management application

• Supervised team of 12 developers.

EDUCATION:

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

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

Page Six Resume of John Herritt

ADDITIONAL EXPERIENCE:

• Enhanced data migration routine of Clipper data to ADABAS/Natural application for EPA – Premier Incorporated (February 1994 – October 1994)

• UNISYS 1100/2200 operations management, production control, systems programming - McDonald-Bradley (January, 1990 – January,1992); Lockheed Martin (October 1992 – March 1993)

• DMS 1100/2200 database administration-McDonald-Bradley (January, 1990 – January,1992); Lockheed Martin (October 1992 – March 1993)

• CICS (with CA-InterTest) COBOL 78 programming with DMS II databases for the US Department of Housing and Urban Development – McDonald-Bradley (January,1990 – January, 1992); Sysorex Fairfax VA (August 1995 – February 1996)

• Migration of DMS II data to DB2 for the US Department of Housing and Urban Development – McDonald-Bradley (January,1990 – January, 1992)

• Migration of DB2 to Sybase for the US Department of Housing and Urban Development – AIA (February, 1995 – August, 1995)

• CICS (with CA-InterTest) COBOL 78 programming – Anthem BC/BS Indianapolis IN (May 1996 – September 1996)

• CICS (with CA-InterTest) COBOL 78 programming – BRC Associates Bethesda MD (February 1986 – October 1986)

• IBM 3090 and 4330 operations, production control, and systems programming – PRC Fairfax VA (August 1985 – February, 1986); McDonald – Bradley (January, 1990 – January, 1992);

• Used Crystal Reports v4.0 - Independent Consultant (May 1993 - June 1993)

• Developed FoxBASE and FoxPro applications – Arlington County Government (January 1989 – January 1990; McDonald – Bradley (January, 1990 – January, 1992)

• Developed and administrators for FoxPro for Windows applications/databases – Sysorex (August 1995 – January 1996); Independent Consultant (December 1996 – March 1997)

• Used Visual FoxPro 3.0 - 7.0 – CenCor (September 1996 – December 1996); Comso (April 1997 – October 1997); RMSI (October 1997 – May 1998); Independent Consultant (May 1998 – August 1998); SAIC (August 1998 – September 1999); STG (January 2000 – August 2001); Independent Consultant (October 2001 – February 2002)

• Created triggers and stored procedures for SQL Server – UNISYS/Martin Marietta (September 1992 – February 1993)

• Developed document management application for Department of Veterans Affairs to scan policy binders (August 1987 – December 1987)

• Maintained bar code scanner application for document management inventory system for Hennage Printers, Alexandria VA. (May 1985 – January 1986)

Contact this candidate