SUMMARY

Systems and Software Engineer, Database Administrator and Developer for a wide variety of applications with significant experience in all areas of the software development life cycle ranging from requirements analysis to implementation and testing. Also proficient in the design and development of databases in Oracle and SQL Server environments.

PROFESSIONAL EXPERIENCE

Employer: Goold Health Systems, a subsidiary of Change Healthcare Jul 2014 – Feb2016

Job Title: Software Engineer III – 1 year

Responsible for developing SQL Server Integration Services (SSIS) applications for providing operational support. Assisted with resolving operational failures caused by user errors, invalid data, or timing issues.

Developed a set of procedures to load medical and pharmacy related claims data from West Virginia weekly.

Developed an SSIS package to export Iowa claim data to medical care organizations.

Developed an SSIS package to import data from medical care organization.

Developed a suite of Confluence pages to support providing operational support; these pages made information available to the support staff without having to do extensive research or locate a subject matter expert.

Employer: PTI, Augusta, ME Jul 2013 – Mar 2014

Job Title: Tester – 1 year

Responsible for testing the functionality of the new release the birth portion of the DAVETM system used by the State of Maine.

Developed test procedures to supplement the test procedures provided by the DAVETM developer; the original test procedures verified designed functionality; the new procedures validated that the system would work in its operational environment.

Executed all of the test procedures.

Developed interactive training for users of the DAVETM using Adobe Captivate; this interactive training provided individualized training without having to coordinate and schedule classes for small groups.

Created Excel spreadsheets that allowed the users to copy the contents of a text file into a worksheet, and display the data in a more usable form on a different worksheet in the same workbook.

Employer: CashStar, Portland, ME Nov 2012 – Mar 2013

Job Title: ETL Report Writer – 5 months

Responsible for providing extract, transform and load (ETL) support to the company

Developed and generated reports using Jasper iReports and Talend to provide information to management and to clients.

Employer: Technical Software Services, Inc., Pensacola, FL Oct 1993 – Aug 2012

Job Title: Chief Engineer – 10 years

Managed the implementation and deployment of applications for several customers. Provided CMMI training and guidance to customers to help them achieve desired maturity levels.

Managed the implementation and deployment of four web-based applications, using a SQL Server database as a repository for the Space and Naval Warfare Systems Center Atlantic (SSC Atlantic).

Trained and managed the development team to ensure that they had the necessary database knowledge and skills, showing them how to use Access as a front end for the SQL Data to allow the users to retrieve data without having to learn all of the details required by the SQL Server tools.

Developed six management plans for the Space and Naval Warfare Systems Support Center, Charleston, SC (SSCC), leading to a CMMI Maturity Level 3 rating.

Converted an Oracle 10g database to a SQL Server 2008 database.

Installed a version of Oracle in a client's environment so that they could load the database from a company that they had acquired so that they could still meet corporate obligations.

Analyzed the existing database environment in order to map the tables, views, and procedures from Oracle to corresponding objects that would have the same functionality in SQL Server. Once the conversion was complete, the client was able to switch seamlessly from using the Oracle database to the SQL Server database.

Job Title: Database Administrator and Developer – 6 years

Designed and implemented the Jackpot Database by working with others to establish the requirements for the database. The database was designed primarily to support the collection and analysis of software measurement data. The database used Oracle products, including a Web Server, Developer/2000, and Net8. The work accomplished in 12 months what the previous contractor could not do in two years. The Jackpot Database provided a solid foundation for establishing process improvement procedures throughout the agency.

Expanded the Jackpot Database to provide the tools to support the collection and analysis of data about the agency's diverse software systems using web pages maintained in the Oracle database.

Developed a web-based questionnaire using Oracle web packages and embedded JavaScript to collect data about current and legacy systems, allowing the agency to establish a baseline upon which decisions can be made to eliminate or keep the systems. The initial baseline was built in three months, and contained over one thousand systems almost half of the total inventory.

Generated several ad hoc reports in response to requests from Congress.

Managed three contractors from other companies to build additional reports and data entry forms.

Updated the database from Oracle version 8i to Oracle version 9i, and installed the newly released Oracle Application Server.

Upgraded the forms capability from Oracle Forms 6i to Oracle Forms 9i. All of these upgrades were performed as part of semi-annual releases.

Created an automated process for generating a spreadsheet compatible output on a daily basis so that it could be used by some of the analysts that were uncomfortable with accessing data directly in a database.

Created roles and views to ensure that only authorized users had access to some of the sensitive data.

Established procedures for backing up the database on a weekly basis in addition to the backups performed by the network support group.

Generated a quick reaction capability to meet critical mission needs in three weeks, allowing users to enter either requirement information or personnel information to allow the customer to track this information, and make appropriate assignment decisions. The customer was very pleased with the responsiveness and quality of work.

Added additional tables to the Jackpot Database to capture information about an effort to move UNIX applications to an NT environment.

Designed and helped implement a set of data entry forms to capture information about legacy databases. This information was provided to other contractors to help them migrate the data from the old databases to a new, more up-to-date database. The initial capability was deployed within two months. Because the customer was not ready to collect data when the initial prototype was delivered, they asked for additional modifications that we added without any problems.

Job Title: Technical Director – 3 years

Managing the technical aspects of all development and maintenance efforts.

Developed the company's design and coding standards.

Established the company's configuration management procedures.

Performed Independent Verification and Validation (IV&V) on the development of the TACINTEL II system, which was developed using the Shlaer-Mellor object-oriented analysis and design methodology.

Reviewed the following TACINTEL documents: Software Development Plan, System Specification, System/Segment Design Document, Software Requirements Specification, Software Test Plan, Software Design Document, and Software Test Description.

Developed the Database Administrator (DBA) portion of the database course that was taught by the University of West Florida for the Naval Security Group (NSG). These lessons taught the student a variety of DBA skills, including: how to install a SYBASE Relational Database Management System (RDBMS), allocate resources, manage user accounts and perform backups and recovery. Upon successful completion of the course, the students were awarded 3 semester credit hours.

Developed all the database lab sessions for the above database course. These labs covered skills ranging from accessing the database to actually designing and building simple databases.

Designed and implemented a database to support the Air Force's Housing Information Management System. This effort involved converting an un-normalized Microsoft Access database into a normalized ORACLE database. These database modifications resulted in queries taking only minutes instead of hours.

Designed and developed the database for NSG's System Security Plan software. This effort involved converting an un-normalized dBase III application to work in a FoxPro environment.

Designed and developed data entry screens for NSG's System Security Plan software using FoxPro's tools.

Supervised the analysis of data collected by the Naval Security Group Activity Pensacola. This analysis has resulted in several reports on the metrics effort and how to improve it.

EDUCATION

University of West Florida, Pensacola, Florida 32503.

M. S. Degree in Software Engineering.

Naval Postgraduate School, Monterey, California 93940.

M. S. Degree in Electrical Engineering.

University of Texas, Austin, Texas 78712.

B. S. Degree in Mathematics;

B. A. Degree, Major: Computer Science.

COURSE WORK

Oracle RDBMS

Oracle Web Server Development

Object-Oriented Analysis and Design

Ada

SQL

PL/SQL

VAX/VMS

TECHNICAL SKILLS

Programming Languages

Operating Systems

RDBMS

Software Packages

Ada

SQL

PL/SQL

Transact SQL

C

Pascal

FORTRAN

Lisp

Assembler

HTML

JavaScript

UNIX

AIX

Solaris

Sun OS

Windows

VM/CMS

VAX/VMS

MSDOS

CP/M

MAC OS X

Oracle

SQL Server

MySQL

Access

dBase II

dBase III+

dBase IV

SYBASE

Paradox

FoxPro

MS Office

Oracle Application Server

Developer/2000

SQL*Forms

SQL*Report

SourceSafe

DOORS

MS Project

Visio

Appraisal Wizard

Contact this candidate