SUMMARY:

Accomplished information technology consultant with over 25 years of experience as a project manager, technical lead, web and database developer for various government agencies, non - profit organizations and private sector companies. Broad experience in all phases of the software development life-cycle, from requirements analysis and development to testing, documentation, and training. Specific skills include ColdFusion programming, JavaScript, jQuery, XML, relational database development in Oracle, SQL Server, and Access, and IIS/Apache web server administration. Conducted several large-scale data migrations and is highly proficient with Transact-SQL and PL/SQL. Active State Department Secret clearance.

TECHNICAL PROFILE:

Languages: ColdFusion 10, JavaScript, jQuery, HTML, CSS, XHTML, XML, SAS, PL/SQL, T-SQL, ASP, VBA

Databases: Oracle 9i/10g/11g, SQL Server 2000/2005/2008 , Sybase, Microsoft Access, SAS

Tools: Dreamweaver, TOAD for Oracle, SQL Developer, Rational ClearCase, CA Software Change Manager, Remedy, ASIST, Microsoft Office, Project, Visio

Platforms: Windows XP/7/Server 2003/2008/2012 , Red Hat Enterprise Linux 5.10, AIX

PROFESSIONAL EXPERIENCE:

Confidential

Senior Web Developer

Responsibilities:

• Led the migration of five USAID web sites from a SAS EBI platform running on Windows Server 2003 to an Oracle 11g/ColdFusion 10 platform running on Red Hat Enterprise Linux 5.10.
• Through the IBM CM process at USAID (Remedy/ASIST), provisioned VM servers in development and production environments and established the appropriate NetScaler and firewall configurations. Installed ColdFusion and configured the Apache web server in RHEL.
• Used Citrix, Managed FTP, RDP, nano, and Toad for Oracle to administer the web files and database schemas.
• Wrote scripts to transform and export SAS data to text and import to the Oracle 11g database. Wrote PL/SQL scripts to perform periodic updates of the data using external tables and SQL Loader.
• Used ColdFusion, CSS, Javascript, jQuery, and jVectorMap to develop the Section 508-accessible front-end for the new consolidated site.
• Incorporated Google Analytics into the site to provide web usage statistics.
• Prepared all required SDLC documentation.
• Provided IT services, ranging from database-driven web sites to desktop Access database solutions, to the following clients:
• Developed, maintained, and provided end - user technical support for the VETS Operations and Programs Activity Report (VOPAR) on-line reporting system (vopar.doleta.gov). VOPAR is a secure, role-based system for tracking performance of all VETS grant and transition services programs. It was developed using ColdFusion, SQL Server 2005, and JavaScript and then migrated to an Oracle 9i backend in 2010.
• Led the migration of the Uniformed Services Employment and Reemployment Rights Act Information Management System (UIMS) from Denver, CO to Washington, DC and modified the ColdFusion-based system to provide access to staff with the Office of the Special Counsel (OSC) and the Department of Justice (DOJ) to manage cases referred to them by VETS.
• Developed a desktop Access database application that interfaces with QuickBooks to allow for quick and easy calculation of the company s government overhead rates.
• Developed a desktop Access database for tracking school construction costs in fast growth counties in the United States.
• Using ColdFusion, Access, and JavaScript, developed a web site for the entry of water quality data collected at monitoring sites throughout the Chesapeake Bay watershed
• Developed a desktop Access database for grants management and analytical reporting using VBA.
• Developed a desktop Access database for client management and analytical reporting using VBA.
• Acted as Technical Lead, Database Developer and/or Programmer for a number of applications for both commercial and government clients, providing new capabilities and improving client productivity.
• Developed a secure, role-based, user-friendly interface to the U.S. Department of Housing and Urban Development s (HUD) Management and Marketing Database using SQL Server, Cold Fusion and JavaScript.
• Developed a secure, role-based application for tracking HUD SAMS help desk calls and other work items using SQL Sever, ASP and JavaScript.
• Managed the development and deployment of the U.S. Drug Enforcement Agency s (DEA) Intelligence Program Tracking System, a Merlin intranet application designed to allow DEA intelligence analysts to submit career related information as part of their career path selection within DEA.
• Performed back-end Oracle 8i database development and tuning, front-end Cold Fusion programming, data manipulation and migration and coordination of project tasks.
• Managed the development of the United States Customs International Property Rights TRACER database project.
• Performed requirements analysis, back-end Access database modeling and development and front-end VBA development for data entry/edit and reporting capabilities.
• Managed the development of a secure, on-line questionnaire for compiling member information for the Society of the Plastics Industry.
• Performed requirements analysis, documentation and back-end SQL Server database development and implementation of stored procedures for inserting/updating/retrieving data.
• Also worked with the client s ISP to determine requirements for SQL Server s xp sendmail extended stored procedure and wrote batch files and SQL scripts for importing data downloaded from the web site and updating to the local Sybase database.
• Managed the development of the United States Customs International Property Rights TRACER database project.
• Performed requirements analysis, back-end Access database modeling and development and front-end VBA development for data entry/edit and reporting capabilities.
• Managed the branding conversion of the enviroglobe.com web site due to change of ownership.
• Performed back-end SQL Server database administration, running data transformation service (DTS) packages to update database content and Cold Fusion programming for remote administration capabilities.

Confidential

Project Manager/Senior Database Administrator

Responsibilities:

• Lead a group of database administrators in the conversion repository of environmental monitoring data from SAS flat-files to relational SQL Server databases, improving data integrity and allowing for public access to the data.
• Worked with federal, state, non-profit, and for-profit organizations, in the development of the database schema for the water quality and point source database and provided technical expertise to junior level DBAs.
• Wrote SAS scripts to output hundreds of SAS data sets to text, imported the data into MS-Access databases (proof of concept) and then to SQL Server.
• Also developed a web interface to the databases using HTML, Cold Fusion and JavaScript, providing public access to the data for the first time.

Confidential

Database Administrator

Responsibilities:

• Developed and administered a centralized, Oracle relational database for managing various types of environmental data collected for use in watershed characterizations, modeling, and planning projects of the department.
• Migrated hundreds of existing environmental data sets (SAS format) from an IBM mainframe to an Oracle database on an IBM RISC6000 running Unix/AIX.
• Also developed database applications for the reporting of summary statistics for inclusion in published reports.