PROFESSIONAL EXPERIENCE:

Confidential

Oracle Developer

Responsibilities:

• Formatted and updated data on the backend of the website. Pushed data through local, development and production environments.
• Wrote code using SQL and PLSQL to selectively update energy data.
• Wrote code in SQL and PLSQL to find erroneous patterns in data and then wrote code to correct the errors.
• Used Toad to do development work.

Confidential

Oracle Developer

Responsibilities:

• Produced and modified code in support of various Department of Education projects. The system ran Oracle 11g and I coded in SQL and PLSQL.
• Took previous year’s code and modified it for current year’s parameters using SQL and PLSQL.
• Wrote technical documentation.
• Monitored databases and reported on any problems.
• This was a contract position.

Confidential, Washington, DC

Oracle Developer, ETL/Reporting Designer/Tester

Responsibilities:

• Documented requirements and desired report and/or dashboard functionality based on scope.
• Produced and refined required documentation.
• Met with stakeholders to hammer out requirements and subsequent changes to requirements.
• Performed troubleshooting to fix issues that arose due to source data being in Oracle and target data in Teradata.
• Created test conditions and test scripts for SIT and CAT to validate ETL, report and/or dashboard functionality and data.
• Created mock data to use in testing via TOAD.
• Assisted in deployment of new tables, views, reports and/or dashboards to Production environment using SQL and PLSQL.
• Created SQL scripts to select data and insert data according to specifications needed for design.
• Consulted on a Datamart for the United States Postal Service.
• Took technical specification documents and translated them into Oracle code.
• Unit tested code and fixed any defects. Created test data to do more advanced testing.
• Created tables, views, materialized views, sequences per technical team's specifications.
• Involved in development of new projects. Assisted in moving code from Development to SIT to CAT environments and fixing any issues that arose as each environment was achieved.
• Modified existing code, adding enhancements that meet new specifications.
• Used both DML and DDL (SQL) to manipulate data and create database objects.
• Developed code using Toad using SQL and PLSQL

Confidential, Chantilly, VA

Oracle Developer

Responsibilities:

• Worked as a backend developer for a website. Created and modified Oracle packages, procedures, functions, triggers, etc. Created and altered tables, sequences, indexes, etc.
• Worked as part of an Agile team with 2 week sprints. Participated in bi - weekly cycle of point estimation, tasking, coding, testing, demonstration to the customer and retrospective.
• Used SVN to version control code.
• Possess Public Trust Clearance.
• Used Toad to write and edit code using SQL and PLSQL.

Confidential, Merrifield, VA

Programmer/Analyst

Responsibilities:

• Created database of Lobby Scales. Created Oracle tables, sequences. Imported data from the 50 Postal regions in an ETL process. Extracted data from 50 Microsoft Excel files and loaded it into Oracle using external tables. Created ETL scripts to take incoming data and modify it to make it conform to specifications (transformed zipcodes, addresses, etc.).Built function to take zipcodes of postal locations and return the corresponding Areas and Districts. Produced code to compare incoming data to existing lists of scales to make the list more accurate. Wrote procedure to add new records to database once the data was sufficiently transformed.Wrote procedure to deleterecords. Created procedure to update address and finance information. Provided reports to customer. Continuously worked to refine data and increase accuracy of Scale information. Collected all the modification procedures and functions into one master Modification package.
• Participated in creation of new master database of Post Office Locations. Brought together address information with financial information in a one-stop database. Oversaw weekly importation of data from the address source and the financial source in an ETL process. Used external tables to bring text files into the Oracle database. Used precise merge code to update existing information and to add new records to the database. Researched records that did not update to find out the reason.
• Possess Public Trust Clearance.
• Used SQL Developer to write and edit code.

Confidential, Elkridge, MD

Programmer/Analyst

Responsibilities:

• Wrote Oracle code for the PQRI project. Customer is Confidential / Confidential Services.
• Chief programmer for the Alternate NPI Feedback Report system.
• Read business requirements and developed code per requirements.
• Developed Oracle packages, stored procedures, functions using PL/SQL.
• Performed unit testing of code.
• Resolved any problems encountered during various testing cycles.
• Produced required documentation for the project.
• Used PL/SQL Developer 7.1 to create and maintain code.
• Used Subversion document management system to manage versions of documentation and code.
• Used JTrac system to manage builds of code.

Confidential

Various Database and Desktop Support

Responsibilities:

• Staffed busy IT Help Desk at Confidential Corporate Offices. Took calls from users and input their issues into the Track It Task management system.
• Assisted users with passwords and gaining access to Microsoft Outlook and Unix accounts.
• Added and deleted user profiles per company specifications.
• This was a contracting job.

Confidential

Responsibilities:

• Used Remedy Action Request System Version 6.03 to manage the tickets. Interacted with the rental agents to correct any problems they were having with the Rental computer system.
• Researched problems that agents had with the rental system and looked at the underlying Oracle code to find problems.
• Worked on data integrity issues in preparation for the 777 software update.
• Involved in testing additions to Confidential rental system.
• Created test rental documents and tracked data through system.
• Validated data against specifications.
• This was a contracting job.

Confidential

Responsibilities:

• Worked in the Financial Aid Department at the corporate offices of Confidential in Arlington, VA.
• Involved in the preparation of data for routine and special reports.
• Improved functionality of reports by adding code to report structure so data could be plugged into a table and processed instead of being hard-coded into the report.
• This was a contracting job.

Confidential

Responsibilities:

• Created PL/SQL code using packages, stored procedures and functions that gave selected individuals access to the module based on the privileges table.
• Added multiple checks into the PL/SQL code to restrict access to only authorized users and to lock the user account if there were too many log-in attempts.
• Developed PL/SQL code to allow administrators to lock and unlock user accounts.
• Analyzed structure of database objects to help data base administrator improve performance of database.
• This was a contracting job.

Confidential, Vienna, VA

Associate Programmer

Environment: Protection Agency (EPA), Office of Water (OW), Multiple Projects

Responsibilities:

• Developed PL/SQL scripts to compare new data that was submitted each year with the old data that was on file.
• Developed procedures in PL/SQL to prepare the data for loading: extracted data, re-formatted data, scrubbed data and then loaded it to the TMDL website.
• Coded new reports using PL/SQL and placed them on the EPA website.
• Coded the links to the explanatory column headings (Javascript pop-ups) and assembled the links into a Glossary of terms (an HTML table with PL/SQL behind the table).
• Coded procedure showing any state disclaimers information if it is applicable, (an HTML table assembled using PL/SQL).

Confidential, Arlington, VA

Lead programmer

Responsibilities:

• Oracle back-end with an Internet front end.
• This module was coded using PL/SQL, HTML and the Oracle Web Toolkit.
• Made continual improvements to this application: added email notification of new or updated tasks, tracking of task time, matrices, reports.
• Tracked task hours to line items of government contracts.
• Created tables and web-based forms to update the database, fill tables, modify data, delete data, display data, etc. using PL/SQL and the Oracle Web Toolkit (htpp).
• Used packages, procedures, functions, crons, sequences, stylesheets.
• Used PL/SQL, NDS, SQL*Plus, Unix Shell Script, HTML, Javascript in an Oracle environment.
• Used TOAD to write Oracle code.

Confidential, Merrifield, VA

Responsibilities:

• Worked on-site for a HQ Unit of the United States Postal Service.
• Employed full-time from 08/98 to 05/00; part-time (as a 2nd job) from 05/00 to 05/03.
• Managed contracts for Automated Purchasing section. Used SNAPS purchasing-document generation system to produce contract modifications and update contract files.
• Utilized the Postal Services Walker Accounting System to troubleshoot my own invoice payments.
• Key person for major archiving of contract files. Prepared boxes and paperwork according to very specific Postal regulations. Oversaw disposition of boxes to IronMountain storage