Post Job Free

Resume

Sign in

Pl Sql Project Manager

Location:
Knoxville, TN
Posted:
September 14, 2023

Contact this candidate

Resume:

Rodney Lott

Knoxville, TN 615-***-****

adzpc8@r.postjobfree.com LinkedIn

Senior Software Management Specialist

Summary

An accomplished and well-respected senior IT project lead developer and senior software engineer with 30+ in the design and development of software applications with a focus on productivity, quality, scalability, sustainability, and usability. Possess superb collaboration skills with management, business/technical teams, management, and users, and is adept at translating business requirements into technical specifications. Highly skilled in architecting global solutions for multiple systems and technologies. Excel in establishing frameworks and developing prototypes and proofs-of-concept to recommend cost-effective technologies.

Technology Expertise

Oracle

MS SQL Server

Visual Studio .NET

VS Code

COBOL

HP UNIX

Oracle Forms

PL/SQL

Shell Scripting

Cognos Framework

C#

ProC

TOAD

Professional Experience

Acato Information Management, Oak Ridge, TN 07/2016–06/2023

Senior Information Management Specialist

Conducted in-depth testing of custom software applications for the Department of Energy. Performed SQL extracts for financials, employee enrollment, financials, inventory, and related topics. Developed complex SQL queries to perform thorough testing of the data warehouse (DW) to guarantee data integrity for reports that retrieved data from the DW.

Recipient of the National Nuclear Security Administration (NNSA) Excellence Award to recognize outstanding contributions to the Best-in-Class G2 development processes throughout the 3-year G2 Agile Transformation initiative. Spearheaded exceptional teamwork and continual learning to lead the program to achieve a significant increase in development capacity and a reduced timeframe of concept to delivery.

NNSA G2 Project 15th Anniversary recognition for outstanding contributions to the NNSA’s G2 program. Since its 2007 inception, the G2 system has become widely used by NNSA to manage ~$4B in annual appropriations. G2 is known for its capabilities and impact on managing NNSA’s critical national security missions.

Technical skills: HTML, Markdown, MS SQL Server, NodeJS, PL/SQL, and SQL.

Altar’d State, Knoxville, TN 11/2014–06/2016

Senior Developer

Designed and developed Oracle Reports for company financials. Developed and supported the computer interface for shipping processes.

Technical skills: Java, SQL Server, SSIS, and SSRS.

ClinixMIS, Inc., Brentwood, TN 07/2013–10/2014

Senior Developer

Assigned to develop and maintain the ClinixPM Oracle Forms application and other interfaces in the Oracle 10g/11g environment. Served as a member of the Oracle Forms development team to upgrade ClinixPM to provide a modern presentation to all Oracle Forms which enhanced the company's marketability.

Designed a sales and inventory software application that was integrated into ClinixPM to perform audits and track inventory levels, open orders, open transfers, perpetual daily inventory, and vendors. The project incorporated extensive PL/SQL blocks.

Technical Skills: Oracle Forms and Oracle PL/SQL.

Insight Global, Inc., Brentwood, TN 08/2012–06/2013

Senior PL/SQL Oracle Developer

Served as an integral member of Hewlett-Packard Data Extract team for the client, Healthways. Developed complex SQL data extract scripts. Also applied PL/SQL functions and methodologies to prepare multiple SQL extracts.

Technical skills: Oracle SQL, PL/SQL, and TOAD.

TekSystems, Inc., Knoxville, TN 05/2012–08/2012

Oracle Software Consultant

Supervised technical teams for an upgrade project in the Oracle 11g environment. Guided the process to convert all Oracle 9i forms and reports platform to the Oracle 11g middleware forms and reports platform to support two fleet management applications at the University of Tennessee.

Prior roles: IS Project Manager at Cracker Barrel Old Country Stores (1999–2011) and System Analyst at Goody’s Family Clothing (1996–1999).

Education

Bachelor of Arts

Mathematics

University of Tennessee at Knoxville

Certifications

Certified Tester, Foundation Level (CTFL)

American Software Testing Qualifications Board (2017)



Contact this candidate