ARTHUR J. WATTS

770-***-****

adl5sl@r.postjobfree.com

TECHNOLOGY PROFESSIONAL

Technical / Project lead in Nuclear Access Security implementing and supporting all Nuclear Plant Access adhering to Nuclear NEI (Nuclear Energy Institute) and PADS (Personnel Access Data System – National database for every nuclear utility in the United States) guidelines at TVA for over 25 years. Primary support in integration across LMS (Learning Management System), NANTEL (National Academy for Nuclear Training e-Learning), PADS, and UAA (Unescorted Authorization Access to Nuclear Plant) aligning business directives with Nuclear Plant industry Standards and TVA’s higher standards of security, regulatory requirements, security compliance, and data integrity. Have experience with Oracle 7.3, 8i, 9i, 10g, 11g, and 12c writing PL/SQL packages/triggers/procedures for all integrations. Responsible for creating tables and indexes. Technically responsible for optimizing queries and sub-queries. Technical lead in support of vendor applications including MEDGATE (Saftey/Health/Training Tracking System), Maximo (Work Management System), and HIS20 (Health Physics Information System – Radiation Exposure Tracking System). Over 15 years serving as technical lead for the core of all NPG plant Access and integration processing. In addition, highly skilled in Oracle, PL/SQL, SQL Server and Web-based applications. Very experienced using Borune/Korn/Bash scripts and DBMS Scheduler. Experience with APEX (Oracle Application Web-based development) used to build web applications managed in the cloud. Very proficient with Oracle database in creating/updating PL/SQL packages/procedures/triggers/functions/views.

EDUCATION

B.S., Computer Science, Jackson State University

Computer Science, Virginia Tech (Graduate Studies)

CERTIFICATION

ITIL V3 Certified

Performance Awards

Special ACT Performance Award 2013

Special ACT Performance Award 2001

Special ACT Performance Award 1989

areas of excellence

•US Navy veteran

•SSIS/SSRS

•Change Management

•Oracle/ PL SQL

•SQL Server 2008/2012/2019

•SFTP/FTP

•IT Project Management

•Oracle APEX

•PL/SQL Developer/Toad/SQL-Navigator

•SQL Loader/SQL PLUS

•Requirements Analysis and Definition

•SQL Server Management Studio

•Windows

•Linux/Unix - Korn/Bourne/Bash shell

•Waterfall

•Agile process

•TFS

Powershell/Shell scripting

security: ts/ci (1988-1992); program integrity/critical group (1995-prese

PROFESSIONAL EXPERIENCE

TeamHealth

Knoxville, TN 07/2020 -Present

Oracle Developer

System Development and Support

Developed PL/SQL packages/triggers/procedures/views to support billing and management for health care billing system using Oracle database (11g, 12c). Maintained Oracle forms Case Manager System for health care professionals. Collaborated with the team of five members. Helped develop reports and a new web-based application (Case Manager System). Converted the Oracle Forms Health Care Billing System to Oracle APEX system. Created database jobs to run on a daily schedule. Created/designed Oracle database objects for the new health billing system using PL/SQL Developer. Technically responsible for all Oracle database objects and testing any changes deployed to production. Worked directly with the Director of Information Technology on change management process and complex queries. Responsible for optimizing queries and complex subqueries to enhance performance. Created ad hoc queries and reports (HTML and SSRS) to address critical business needs. Automated recurring processes with appropriate monitoring controls. Responsible for developing SQL scripts for all Production change management process.

Tennessee Valley Authority (TVA)

Chattanooga, TN 04/2003 -07/2020

Software Engineer

System Development and Support

Developed Integration for Personnel Access Data System (PADS), Learning Management System (LMS), Saftey/Health/Training Tracking System (MEDGATE), All integration processes written in PL/SQL (packages/views/triggers) using Oracle (10g, 11g, 12c). Responsible for writing PL/SQL jobs to load external data from vendors into the Oracle database for production purposes. Work Management System (Maximo), Health Physics Information System (HIS20 – Radiation Exposure Tracking System) and NANTEL integrations were written using PL/SQL packages and scheduled to run to support the business needs. Collaborated with the vendor to implement a new web-based Nuclear Access System with Oracle database. Responsible for all technical requirements to install the external-facing application (ePHQ –electronic Personnel History Questionnaire). Technically responsible for all integration for the nuclear access system using Tibco, Informatica, Linux/Unix, Shell and Power Shell (SFTP/FTP). Updated the Oracle database objects to keep the data flow almost real time. The integration jobs were scheduled via DBMS scheduler and Cron Jobs. Implemented the system in an Agile environment. Worked directly with the vendor to troubleshoot issues and worked independently to resolve issues with the software. Worked close with the business and built relationships across nuclear organization at all levels.

Data Conversion

Migrated data from SQL server database to Oracle database (11g, 12c)

Migrated data from Oracle to sql server database using SSIS packages

Created data dictionary for data conversion

Created sql for queries /stored procedures/functions/views/tables/schemas for Oracle and sql server database

Testing

Created testing documentation for PADS, LMS, and UAA-SSIS – unescorted access system (web-based application with Oracle database)

Created testing documentation for EM-PACT – Employee Plant Access system (web-based application sql server database).

Technical Lead

Developed and lead technical team of seven with a project plan to implement .NET application for Nuclear Access Services (EMPACT – and UAA-SSIS).

Programmer Analyst 04/2001 – 04/2003

System Development and Maintenance Support

Developed Integration for Personnel Access Data System (PADS) and CHIPS (Check In Process System with Oracle database). The integration was for Training and Employee data along with PADS for access to Nuclear Power Plants.

Testing

Created testing documentation for CHIPS and PADS

Programmer Analyst 04/95 – 04/2001

System Development

Developed PowerBuilder/Oracle radiation exposure tracking application

Supported HIS20 application.

Data Conversion

Migrated data from Model 204 database to Oracle database.

Testing

Created tests and testing documentation for PowerBuilder radiation exposure tracking application

Project Lead

Developed and lead technical portion of project plan to convert COBOL application to PowerBuilder application

Consultant

Maintenance

Maintained COBOL/Model 204 radiation exposure tracking application

SHC Inc.

Stone Mountain, GA 08/1992 – 03/1995

Technical Analyst

Analyzed and designed databases using dBase III. Also trained users to modify and design databases. Also installed hardware and software.

Planning and Research Inc.

Vienna, VA 09/1990 – 07/1992

Programmer/Analyst - US Department of State

Analyzed, coded, tested, documented, maintained and implemented COBOL/Model 204 applications. Also responsible for PL/1 and C-List applications.

National Geospatial-Intelligence Agency (NGA)

Springfield, VA 06/1988 – 08/1990

Computer Systems Analyst

Wrote Clipper/dBase III and COBOL/Model 204 applications. Also installed hardware and software. Maintained applications to support daily/monthly reports.

Contact this candidate