Rod Smalt

Responsibilities

• Database Administrator – Perform regularly scheduled and ad hoc maintenance and administration functions for six Oracle 11gR2 instances and five SQL Server 2005 instances, including (but not limited to): installation, patching and upgrade of database instances; implementation of security-related software patches directed through DoD Information Assurance Vulnerability Alerts, in accordance with relevant Security Technical Implementation Guidelines; backup and recovery planning and implementation; table and index size estimation and storage capacity planning; database health checks and performance monitoring; SQL query tuning and optimization; implementation of discretionary access controls (roles and privileges), implementation of Oracle Transparent Data Encryption, and development of Virtual Private Database contexts, policies and packaged predicate functions.

• Principal Database Analyst - Software Design Lead (Front End / Back End / Legacy Reuse) for SQL Server instances supporting the NAVAIR Knowledge Management System and ManTech Help Desk/Asset Tracking System, Contract Management System, and Engineering & Systems Support Group Info Center.  Oracle database and back end software developer for the NAVAIR Military Flight Operations Quality Assurance System.  Database design consultant for PMA-281 Weaponeering And Stores Planning Common Component.

Accomplishments

      Designed, developed, and maintained database structures, interfaces, and supporting documentation to sustain crucial business processes of both Navy and ManTech customers.  Conducted technical analyses of software requirements, system enhancements, legacy data migration, and interface updates for key DoD, Navy, and ManTech systems.  Evaluated and developed solutions to emerging technical issues.

Mentored junior programmers, and consulted with developers in other specialties over critical database design/management issues.

• Responsibilities – Design and development of database structures, and associated back end software.

• Accomplishments – Developed the database, supporting code and XML mapping for an eCommerce application that permits claimants to submit Forms 720, 2290 and 8849 (and associated Schedules) to the IRS electronically, for the refund of excise taxes paid on certain bio-fuels, diesel and kerosene.

• Responsibilities – Design and development of database structures, and associated back end software.

• Accomplishments – Designed a web-based application for managing the foster care and adoption of retired racing Greyhounds from the Seabrook Greyhound Park, Seabrook, New Hampshire.

• Responsibilities – Develop curricula, conduct classroom lectures and labs, administer and grade exams, and provide additional instruction as required.

• Accomplishments – Taught systems analysis/modeling/design, SQL, PL/SQL and Developer Forms and Reports to students enrolled in the Oracle Software Developer Training Program.

• Responsibilities – Team Leader for Marconi Financial Programming Group at the Naval Air Warfare Center – Aircraft Division, Patuxent River.  Maintained and enhanced direct and indirect funding data processing applications for the Office of the Comptroller at four sites.  Performed on-site managerial duties, including work oversight and performance evaluation.

• Accomplishments – Completed a massive migration of Material Accounting Subsystem forms from Oracle Forms 3.0 to Forms 4.5, including Y2K compliance changes and testing, several months ahead of schedule.

• Responsibilities - Team Leader for Marconi Financial Programming Group at the Naval Air Warfare Center - Aircraft Division, Patuxent River.  Supervised a staff of four Oracle developers.  Designed, developed, and maintained software used in the daily processing of approximately $45 million in Navy Industrial Fund transactions.
• Accomplishments - Worked with comptroller personnel at three sites to develop a method for automatically entering relevant daily material transactions into the Navy’s Standard Accounting and Reporting System.  Converted data from mainframe, legacy systems at two sites to assume their material accounting functions.

• Responsibilities - Supported the Material Accounting Subsystem at the Naval Air Warfare Center - Aircraft Division, Patuxent River.  Maintained over 200 programs, functions, procedures, reports, forms, and scripts.

• Accomplishments - Applied understanding of accounting principles and experience in Naval aviation to quickly grasp the complexities of the Material Accounting Subsystem, and each of the subsystems with which it interacted.

• Responsibilities - Tested and evaluated object-oriented software projects for the squadron and the Navy.

• Accomplishments - Worked with squadron Flight Surgeon to develop a PC-based, relational database and programs to manage the squadron’s Remedial Physical Readiness Program.  Reduced from three weeks to two days functions such as test scheduling, compiling results, and reporting.

• Responsibilities - Worked with departmental end-users to design, develop, and maintain systems that integrated functions such as flight event tracking, aircrew training and qualifications tracking, and reconciling flight hours with operational funding.

• Accomplishments - Designed a fast, flexible system which 1) allowed interaction between Operations, Training, and Personnel databases and directly contributed to zero-discrepancy annual Command Inspections, and 2) improved accounting for an operating budget of $1.5 million to within one percent of the Naval Air Force Atlantic Fleet goal.

• Responsibilities - Provided software configuration control and generated target acoustic and oceanographic simulation software for three multi-million dollar simulators, used by six tenant commands and other foreign units.

• Accomplishments - Worked with squadron Training Officers to design a PC-based Simulator Scheduling/Activity Analysis & Reporting system to track asset utilization and provide timely readiness feedback to squadron Commanding Officers.  Developed a comprehensive, PC-based target construction program from simulator specifications, allowing instructors with little or no simulator experience to build well engineered, acoustically accurate targets. 

• Responsibilities - Designed, developed, and maintained applications for ground and aircraft systems.

• Accomplishments - Developed numerous applications for squadron departments, including an Optical Character Recognition message formatting/printing program which allowed users to generate standard Naval messages from free-form, word processed text.  Deployed several acoustic analysis programs aboard squadron aircraft, including a hyperbolic fixing program which allowed operators to perform long-range, hull-to-sonar correlation against multiple targets using only three sonobuoys.