Wrote shell scripts to transfer flat files from centralized locations to specific directories and
execute SQL*Loader and PL/SQL routines to load the data into load and staging tables and then to
production tables. Wrote the PL/SQL routines to perform the previous operations. PL/SQL packages
were written to build data transactions from company data for the TrueComp commissions system.
Supported operational testing.

Wrote routines in PL/SQL to perform consensing, load data into an opt-out database, and purge database
tables for a datawarehouse on Oracle 9i for subscriptions. Work involved optimizing code and queries
for a multi-million record database. The rules for a production system were automated, consisting of
PL/SQL routines for the individual rules and for ordering the execution

Documented programs that computed least cost routing for trunk groups. Wrote shell scripts that processed
call detail record data from remote switches. The data arrived in compressed format and had to be
uncompressed, loaded into temporary tables in the Oracle database via SQL*Loader, and formatted and
inserted into production tables.

Assisted Northrop Grumman in the conversion of Medicaid program data from a legacy system to Oracle
10g. Wrote PL/SQL routines to transfer data from external files to production tables. PL/SQL programs
were optimized for resource and speed.

Supported work on the Core Extracts ETL process. Modified Perl scripts to read
data from the database and produce XML files using spreadsheets as input. Wrote Data
Technical Design for extract process.

<!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; mso-layout-grid-align:none; punctuation-wrap:simple; text-autospace:none; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p.MsoBodyText, li.MsoBodyText, div.MsoBodyText {margin-top:0in; margin-right:0in; margin-bottom:6.0pt; margin-left:0in; mso-pagination:widow-orphan; mso-layout-grid-align:none; punctuation-wrap:simple; text-autospace:none; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p.Achievement, li.Achievement, div.Achievement {mso-style-name:Achievement; mso-style-parent:"Body Text"; margin-top:0in; margin-right:0in; margin-bottom:3.0pt; margin-left:12.0pt; text-align:justify; text-indent:-12.0pt; line-height:11.0pt; mso-pagination:widow-orphan; mso-list:skip; mso-layout-grid-align:none; punctuation-wrap:simple; text-autospace:none; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; letter-spacing:-.25pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:1561331883; mso-list-type:hybrid; mso-list-template-ids:-1819476614 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:.25in; mso-level-number-position:left; margin-left:.25in; text-indent:-.25in; font-family:Symbol;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} -->

·         Assisted Northrop Grumman in the conversion of Medicaid program data from a legacy system to Oracle 10g. Wrote PL/SQL routines to transfer data from external tables to production tables. PL/SQL programs were optimized for resource and speed.

<!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 0 0 -2147483648 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; mso-layout-grid-align:none; punctuation-wrap:simple; text-autospace:none; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p.MsoBodyText, li.MsoBodyText, div.MsoBodyText {margin-top:0in; margin-right:0in; margin-bottom:6.0pt; margin-left:0in; mso-pagination:widow-orphan; mso-layout-grid-align:none; punctuation-wrap:simple; text-autospace:none; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p.Achievement, li.Achievement, div.Achievement {mso-style-name:Achievement; mso-style-parent:"Body Text"; margin-top:0in; margin-right:0in; margin-bottom:3.0pt; margin-left:12.0pt; text-align:justify; text-indent:-12.0pt; line-height:11.0pt; mso-pagination:widow-orphan; mso-list:skip; mso-layout-grid-align:none; punctuation-wrap:simple; text-autospace:none; font-size:10.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman"; letter-spacing:-.25pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} /* List Definitions */ @list l0 {mso-list-id:620185989; mso-list-type:hybrid; mso-list-template-ids:1678943566 67698689 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:; mso-level-tab-stop:.25in; mso-level-number-position:left; margin-left:.25in; text-indent:-.25in; font-family:Symbol;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} -->

·         Supported work on the Core Extracts ETL process. Modified Perl scripts to read data from the database and produce XML files using spreadsheets as input. Wrote Data Technical Design for extract process.