William N. Wells

Mazeranger LLC, 01/2014 to 09/2015

President/Owner

In-house work and consulting

• Wrote a C# ASP.NET MVC 5 / SQL Server application to make the search for clients and the maintenance of a network of contacts more efficient, effective, and enjoyable.  This multi-user web application uses 30 or more database tables.

• Reverse-engineered and adapted for different hardware an undocumented Android mobile app for controlling prototype medical instrumentation for a Johns Hopkins project.

Arena Technical Resources LLC, 08/2013 to 12/2013

.NET Developer

• Took over the development, enhancement, and deployment of a large C# ASP.NET MVC4 application for U.S. embassies.  Application had been mothballed for a year.

• Implemented code and database changes and set up an upgraded Visual Studio development environment and code repository.  Tracked down and/or replaced missing components and resolved build errors.

• Took part in international travel to U.S. embassies in Panama and Mexico to gather client requirements for upcoming installations and to plan with the local technical staff.

• Prepared and deployed remotely to the field application fixes and updates.

• Produced a data dictionary for the application using SQL Server extended attributes, a technique that ensures availability and updateability of the data dictionary because it became an integral part of the database.

• Improved application security by implementing restricted-access service accounts for connections to the SharePoint, IIS, and SQL Server components of the application. 

• Wrote standardized publishing profiles to allow for repeatable application deployments to reduce onsite time, schedule risk, and costs for installations in the field.

• Researched and proposed a solution for secure storage and handling of personally-identifiable information through implementation of row- and ield-level access restrictions in SQL Server using code already available online.

• Proposed inexpensive equipment enhancements and a maintenance regimen for the in-house server network to end disruptions from recurring server crashes.

Consultant (via eGlobaltech) to the U.S. House of Representatives

• Key technical contributor in the architecting and design of the replacement of an outdated system for scanning, processing, and routing thousands of incoming documents per day with a new SQL Server-based system.

• Developed, documented, tested, and deployed all of the Transact-SQL and .NET C# software programs and database objects needed to upload TIFF images and XML metadata from scanners, perform OCR processing, determine routing, temporarily store intermediate results, and download to Windows servers accessible to the end users thousands of barcoded TIFF images scanned daily by one of the largest ParaScript document-scanning installations deployed to date.

• Researched the tradeoffs involved between storing TIFF images in the SQL Server database as BLOBs versus FILESTREAM objects, and decided to use BLOBs owing to the size distribution of the TIFF images.

• Advised the DBA staff on how to manage fragmentation and reclaim disk space within the SQL Server database taken up by deleted files and BLOBs.

• Adapted and reworked Red Hat Linux-based Perl/JavaScript code left by predecessors into a CGI-based set of browser screens to provide control screens for the operators for printing barcodes and managing the system through interactions with the SQL Server database.

• Provided training, thoroughly-commented source code, and other documentation to the technical support staff to aid them in post-deployment maintenance and upkeep of the new system.

• Assisted with the deployment of the entire system to production.  The new system is successful, outperforms its predecessor, and is in routine, everyday use by the U.S. House of Representatives to process incoming documents.

Apex Systems, Inc. and Avaya Government Solutions, Inc., 12/2009 to 05/2011

Consultant to U.S. Department of Justice, Executive Office of Immigration Review

Clearance: Public Trust

• Acting across the Operations, DBA, and Development areas, made numerous and diverse technical contributions to a major migration and upgrade of legacy ColdFusion systems to a new VMware virtualized environment.

• Migrated applications and data between servers, and from legacy Windows 2003 servers to replacement VMware virtual machines. 

• Reworked server directory structures, IIS (Internet Information Services) configurations, and other environmental characteristics as needed to adapt the legacy applications to the new environment.

• Wrote migration scripts to carry out migrations from server to server in a testable and reproducible manner.

• Upgraded legacy ColdFusion code to ColdFusion 9, and reworked the code to work correctly in the new clustered environment and with updated versions of Internet Explorer and other applications.

• Reviewed old applications for security and performance issues, and documented areas needing improvement to make them acceptable.

• Working from engineering change requests, analyzed and made fixes to legacy ColdFusion source code.

• Prepared technically-detailed engineering change requests based on input from non-technical clients.

• While waiting offsite for security waiver to be approved and working with his own Windows 2003 server remotely using his own laptop, researched how to get ColdFusion9, Eclipse, IIS (Internet Information Services), and other products to interact best in a development environment.  Provided documentation on his findings to other team members.

SRA International, Inc., Fairfax, VA, 12/2004 to 10/2009

SRA consultant to POC (Pharmacy Operations Center), Department of Defense

Remote connection to Fort Sam Houston, San Antonio, TX.

Clearance:  ADP1

• Wrote a complete set of data-entry and editing screens for pharmacy data using PHP and MySQL, including the SQL code for database accesses.

• Provided on short notice using SSMS (SQL Server Management Studio) a prototype database design for associating pharmacy personnel, pharmacies, and jobs, together with commentary for non-specialists on the benefits and drawbacks of various design choices.

SRA consultant to MEPRS (Medical Expense and Performance Reporting System)

Remote connection to San Antonio, TX.

• Rewrote several ColdFusion templates using ColdFusion, Dreamweaver, and SQL Server to make use of a CFX tag instead of hard coding to carry out reverse-DNS lookups on the fly to identify hostnames of visitors to the MEPRS website.

• Upgraded ColdFusion programs to gather and display site statistics to provide a clearer picture of how the website is used.  Simplified, consolidated, rewrote, and debugged existing statistics code.

Support for an SRA proposal

• Installed Oracle Enterprise Edition on one of his own Windows 2003 servers, applied patches using his own Oracle MetaLink account to take the Oracle installation to the patch level required by Enterprise Elements, installed Enterprise Elements, set up a PKI (public key infrastructure) certificate server, and configured ISA (Internet Security and Acceleration) Server to allow access from the Web to the Enterprise Elements installation.

• Imported employee data from spreadsheets into SharePoint for display on the SRA portal.

SRA consultant to U.S. Department of Veterans Affairs, 11/2005 to 07/2009

Clearance:  High Risk (a VA clearance)

• Reviewed a new Perl/Apache-based wiki application (TWiki) for OEAM (Office of Enterprise Architecture Management), and suggested fixes for possible security issues.

• Performed troubleshooting of the TWiki installation and upgrade process, which entailed installing and configuring Apache, applying patches to Perl scripts, tracking down missing Perl modules on CPAN to download and install, and fixing permissions issues.

• Wrote PL/SQL interfaces between the new Java application code and legacy PL/SQL applications while serving as the Oracle specialist on WSMS, a Java development project.

• Wrote Oracle PL/SQL packages with complex queries to replace legacy applications accomplishing the transfer of veteran-related data between the Department of Defense and the Department of Veterans Affairs.

• Devised and implemented a software tool for mapping and matching data elements across DVA applications by reverse-engineering the DVA’s ISO/IEC 11179-based metadata repository, cloning its back-end database into Oracle XE Express, and writing PL/SQL routines to load metadata from Excel spreadsheets into the Oracle tables on his workstation.  Carried out detailed analysis of the 11179 standard and worked out the necessary mappings to store DVA metadata in the most optimal fashion for comparison, analysis, and retrieval.

• Installed Oracle and SharePoint onto his own Windows 2003 server at home and offered free access to the server to SRA to compensate for lack of software support by the DVA.

• Aided the DVA Government staffers in setting up their first SharePoint site, drawing on his experience setting up his own servers.

• Supported the development of the DVA’s XML interface standard by assembling a functional XML composition and processing system entirely out of free, open-source software.

• Performed data modeling with ERwin/ERX.

SRA consultant to U.S. Department of Defense, 11/2005

• Downloaded and installed RT (a trouble ticket system) and its support packages, primarily Perl modules, onto a Solaris 9 server, downloading packages as needed using CPAN and BlastWave, and wrote detailed documentation of the entire process.

SRA consultant to U.S. Department of Labor, 07/2005 to 11/2005

• Performed customer support and bug fixing for the ERDS application.  This entailed working with several technologies, including J2EE, Struts, Java, Ant, Eclipse, Java servlets, Apache Tomcat, Adobe PDF, JavaScript, IBM DB2, and IBM WebSphere.

SRA consultant to Pension Benefit Guaranty Corporation, 12/2004 to 07/2005

Oracle/TOAD database developer

Clearance:   Public Trust

• Developed and implemented major architectural changes to the MyPAA system by analyzing the existing system and recommending changes to the Oracle table designs, revising entity-relationship diagrams, and modifying and rewriting PL/SQL code.

• Carried out updating and revision of automated PAA administrative reports, and wrote PL/SQL code to implement new reports.  Experimented with GPG (GNU Privacy Guard) to provide cryptographic support for redesign of a test interface for banking transactions.

Performance Associates, Inc./Computer Associates, Inc., Columbia, MD, 08/2004 to 11/2004

Contractor/Consultant

• Updated, adapted, reconfigured, and/or wrote CA Advantage Ingres, C++, XML, and Microsoft SQL Server code to enhance the capabilities of a network security and auditing product.

• Performed Ingres installations and Ingres DBA activities to support development and testing.  Additional technologies required for the effort included ODBC, JScript, Cygwin, Windows 2000 server, Windows XP, InstallShield, and CVS.

Tidal Zone Associates, Inc., Landover, MD, 01/2000 to 03/2003

Information Engineer

• Acted as key technical contributor and lead Oracle PL/SQL developer (stored procedures, cursors, triggers, and exception handling) for a criminal justice information system modernization project for the F.B.I. Lead information engineer for the team migrating 10 years of data from a legacy mainframe to a new Oracle 8 system on an aggressive schedule.

• Designed, developed, and tested the overall data migration architecture and process flow, which included logical and physical data model and customer business rules for transforming the legacy data.  Developed and tested PL/SQL, SQL*Loader, Korn shell scripts, and Perl scripts for data migration.

• Devised and implemented techniques for managing errors and exceptions encountered while migrating the data, including tracking in the database and reporting on all errors and their causes, and identifying additional customer business rules to resolve exceptions.

• Prepared logical and physical data models and delivered in a formal design document.  Provided input on database normalization, data integrity, and optimization issues.

• Developed coding standards and documented all code and the steps required to migrate the data.

• Helped develop the architecture, standards, and intermediate processing for building a publication-focused data mart against the data warehouse containing 10 years of data described above.

• Estimated the effort required to migrate applications to Oracle9i/Java servlets by prototyping functionality in JDeveloper and O9iAS.

• Built applications to generate customer-specified publication content, provided technical training and user documentation for the development team and end users.  Key technologies included Oracle 8i/9i Designer, Developer, JDeveloper, PL/SQL, SQL*Loader, and Perl.

Dakota Imaging, 08/1999 to 12/1999

Senior Application Engineer

• Wrote scripts using the Cypress Enable scripting language to control the operation of counter-incrementing and scanning logic in high-speed digital scanning equipment.  Worked out techniques using ADO (Active-X Data Objects) to access Sybase and SQL Server databases from within Cypress Enable scripts.

Pixl, Inc. 03/1999 to 07/1999

Pixl consultant to U.S. Department of Justice, Washington, DC

Senior Analyst and Oracle Developer.

Clearance: NACI

• Served as de facto team lead and deputy project manager.

• Analyzed the data model for the grant application system and advised on aspects of the system architecture.

• Advised on how to improve software development management practices and how to place the development effort on a sounder basis through improvements in the requirements specifications.

• Examined issues of data migration between a publicly accessible Web server and an Oracle instance internal to D.O.J.

• Developed test plans for component modules of the system.

• Designed a PL/SQL package for testing Oracle job-submission features for moving applications from a Web server to the D.O.J internal network.

• Set up a bug-tracking system for the developers using Microsoft Project.

• Designed the architecture of a routing system for routing grant applications from one reviewer to another.

• Prepared a requirements-traceability matrix to demonstrate opportunities for re-use of code.

AshCourt, Inc. 09/1998 to 02/1999

AshCourt consultant to Overseas Private Investment Corporation

Analyst and Oracle Developer

• Drafted the functional specification for the interface between a new Oracle and Visual Basic system under development and the legacy Wang system it eventually was to replace.

• Using PL/SQL, designed and coded an Oracle package of stored procedures for carrying out the nightly download of Wang data to the new system.

• Prepared an analysis of alternative scenarios for maintaining concurrency between the old and new systems.

• Working with the Wang operating system, studied source code and data structures in Wang COBOL to develop the data model and resolve data conversion issues.

• Designed, coded, and documented a set of Oracle views to allow the customer to view downloaded Oracle data using previously-existing Access spreadsheets designed to view legacy data.

• Used Microsoft SourceSafe as the configuration management system for tracking revisions to the source code.

A.I.N.S., Inc., 06/1994 to 05/1998

A.I.N.S. consultant to U.S. Agency for International Development

Oracle/VB developer and team lead

Clearance: Public Trust

• Served as team lead on 25-member Visual Basic/Oracle application development team; also served as developer/technical lead on other teams.

• Supervised the 100+-node Banyan-TCP/IP network administration group consisting of Banyan engineers and Oracle DBAs.

• Wrote papers for the Government client and the development staff on public-key cryptography, digital signatures, network and application security, network architecture and administration, client-server application partitioning, Y2K, and other topics.

• Coded a Visual Basic VBX control for compressing text using Visual C++.

• Wrote SQL scripts, UNIX awk programs, and UNIX shell scripts for data conversions, and served as task leader and Oracle DBA for a data-conversion effort.

• Generated Oracle tables, managed user accounts, and performed data conversions.

• Used Erwin/ERX entity-relationship diagrams to create the logical and physical data model and to recommend changes.

A.T.R., 08/1992 to 05/1994

A.T.R. consultant to the Resolution Trust Corporation

Programmer/Analyst

• First programmer at RTC to work with Visual C++ and to explore the use of Visual C++, Microsoft Foundation Classes, object-oriented programming, and Windows NT to write utilities for job schedulers, alert message generators, and the like for network administration.

• Wrote a white paper for RTC management analyzing the potential of Visual C++, Visual Basic, and MicroFocus COBOL as alternatives to Paradox for client-server application development.

• Wrote client-server applications using Paradox and Microsoft SQL Server under OS/2 and Windows NT, and performed DBA duties.

• Used Erwin/ERX for entity-relationship diagramming and generation of DDL (Data Description Language) for use in creating Microsoft SQL Server tables.

TempCorp, 04/1992 to 08/1992

TempCorp consultant to Department of Health and Human Services, Indian Health Service

Programmer/Analyst

• Used Paradox and PLA to revise and extend a database application for tracking government-owned real estate.

• Wrote a query facility and year-end closeout routine.

The Registry, 02/1991 to 11/1991

The Registry's consultant to a large Baltimore consulting firm

Outside Consultant

• Served as a consultant brought in to salvage a multi-year project on which all progress had stopped owing to the resignation of the entire technical staff.

• Restored a cordial working relationship with the firm's client (who had been threatening litigation) by completing the first of three modules comprising the system.

• Assignment was to complete the Accounts Receivable, Reservations, and Rental Accounting modules of a MicroVAX II-based management system for a chain of time-share condominiums. Running under VAX/VMS, the modules consisted of tens of thousands of lines of code composing scores of programs written in a mixture of Powerhouse (a third-generation database language), VAX Basic with graphics, ReGIS (a VAX-based VMS scripting language), all in different states of completion and entirely devoid of comments or documentation.

• Brought the system up stage by stage by deciphering the undocumented code to determine its purpose, making additions and corrections where needed, and rewriting entire sections when the code was unsalvageable.

Norden Service Company, 1982-1990

Senior Engineering Asssistant

• Evaluated, tested, and debugged prototype and pre-production electronic systems and assemblies for advanced military equipment simulators, using the usual electronic test equipment plus logic analyzers, in-circuit emulators, specially-programmed single-board computers, and custom-built test equipment.

• Carried out IC gate-level debug of processor boards and other assemblies by tracing the operation of the logic with an oscilloscope and checking the results against microcontroller assembly language listings.

• Designed and built test fixtures using ECL, TTL, and programmable logic.

• Designed, coded, and implemented inventory, parts-tracking, and product-structure analysis systems on a VAX-11/780 using INFO, a relational database.

• Wrote programs in C for generating test patterns for checking video monitors.

• Developed menu-driven test programs using Basic on an IBM PC/XT host for operating via a GPIB instrumentation bus a suite of microwave test equipment including frequency counters and generators, spectrum and network analyzers, and custom test equipment.

• Developed series of test messages in Basic using a MIL-STD-1553 interface board in a host PC for testing equipment and software communicating over the bus.

U.S. Army

Clearance:  Top Secret Crypto

U.S. Army veteran with four years of service and an honorable discharge.  Cryptanalyst (nearest civilian equivalent) and Hausa linguist in Africa and Southeast Asia.

EDUCATION:

Pluralsight technical coursework (coursework is ongoing):

• Security and Encryption in SQL Server 2012 and 2014
• Practical SQL Server Security, Compliance, and Auditing
• Introduction to Data Warehousing and Business Intelligence
• Getting Started with Entity Framework 6
• Entity Framework 4.0 By Example
• Building Applications with ASP.NET MVC 4
• Introduction to ASP.NET MVC 3
• Introduction to ASP.NET MVC
• ASP.NET MVC Fundamentals
• LINQ Fundamentals
• C# Generics
• C# Fundamentals with Visual Studio 2015
• A Comparison of Microsoft Web Technologies
• Go (Golang): Getting Started
• Creating GUIs Using PowerShell Studio 2015 – The Essentials
• PostgreSQL: Getting Started
• PostgreSQL: Introduction to SQL Queries
• PostgreSQL: Advanced Server Programming
• PostgreSQL: Index Tuning and Performance Optimization
• The PostgreSQL Document Database
• JavaScript from Scratch
• Rapid JavaScript Training
• Front-end Web Development Quick Start with HTML5, CSS, and JavaScript
• Writing Content with Markdown

Online Coursework in XML technology from Altova, Inc., consisting of:

• XML Accelerated Series – Visual XSD, XML Schema Fundamental and Advanced, XSD Best Practices
• XSLT Accelerated Series – Navigating XPath 1.0, XSLT Fundamental and Advanced, XSLT 2.0

Undergraduate work, Electrical Engineering, University of Florida

Associate of Science, Environmental Science, Santa Fe College (all but one course)

Associate of Arts, Santa Fe College (all but one course)