SUMMARY

• Currently, a CSCI consultant supporting the Defense Finance and Accounting Services (DFAS), Defense Corporate Database (DCD)/Defense Corporate Warehouse (DCW) and correlating systems.
• Duties include translating client requirements into a technical design in order to develop custom solutions for these DCD/DCW databases/systems.
• Extensive career experiences utilized to accomplish project work, which include years of PLSQL development, logical and physical database design, performance tuning SQL statements, encrypting sensitive data, automated web service messaging design and development, ability to work closely with internal clients and outside business partners, ability to write complex COBOL calculations in accordance with legislative direction.

TECHNICAL SKILLS

• Oracle Database, Oracle EBS, Oracle Forms and Reports, SQL, PL/SQL, Packages, Procedures, Functions, Views, Materialized Views, Triggers, Indexes, Oracle Partitioning, Oracle Scheduler, Performance tuning.
• Unix Scripts
• DDL and DML scripts
• XML, XSD development and maintenance.
• COBOL development and maintenance.
• Toad for Oracle
• SQL*Plus
• SQL*Loader
• Tectia SSH Terminal and Tectia Secure File Transfer
• IBM ClearCase & ClearQuest
• UltraEdit & UltraCompare

PROFESSIONAL EXPERIENCE

Sr. Oracle Developer

Confidential

Responsibilities:

• Adhering to STIG security requirements, incorporated Oracle’s DBMS ASSERT package to ensure variables that cannot be bound in dynamic SQL are secure against SQL Injection.
• Mentored a new Government team member via instruction and demonstration in order to get the individual to a comfortable and productive level within our system.
• Extensive work in the construction, maintenance and purging of customer interfaces.
• Worked to archive/purge 100’s of millions of rows of data for several services freeing up a vast amount of crucial database space.
• Purged numerous obsolete interfaces from the system. Thus, removing unused code to comply with STIG requirements.
• During the archive/purge project rebuilt several large tables as partitioned tables which improves performance, manageability and availability.
• Incorporated Transparent Data Encryption (TDE) for personal identifiable information at the both the table level and column level.
• Redefined XML tables using Oracle’s DBMS REDEFINITION function in order to store LOB’s in the more SecureFile format as opposed to the old BasicFile format. SecureFile supports Transparent Data Encryption, encrypts data not only on disk but also in other images such as backups and makes backups and recovery easier by no longer have to deal with disparate procedures for file system data and relational data
• Assisted on numerous Production support issues in varying level of complexity.

Sr. Oracle Developer

Adesa

Responsibilities:

• Subject Matter Expert for the Automated Floorplan, Credit Availability and Title Updating web services among numerous other web services.
• Developed and enhanced the PL/SQL code for several new web services while working with our contracted IBM Websphere Message Broker resources in automating our floor planning and credit availability services with our partners. Overall these services allow for a better, faster, more accurate integrated solution for both the business and our partners
• These services allow floorplans and credit availability to be received and sent systematically from and to our partners in a more efficient manner.
• Previously the business would manually enter floorplans into our system sent from our partners in email and create credit availability files to be sent to our partners through email.
• This is a significant change considering roughly 13k floorplans a week while also sending thousands of dealer credit records to over a half dozen partners.
• Numerous enhancements were made to how the web messages processed in order to allow for customization specific to a particular business partner’s needs.
• Once the aforementioned web services were developed it was suggested by me that we automate the Title Updating process. Doing so:
• Saved the business time and money by negating the need for manual entry into the system to change the title status on a floorplan. As nearly 50% of our weekly floorplan count (roughly 13k) was affected.
• The change in title processing not only reduced the workload, but also allowed our partners to get paid much faster.
• Initially the business stakeholders had to be sold on giving up manual control in some cases and trust the system to an automated process. Especially, with high profile partners of which we have exclusive servicing contracts with. They needed to be reassured that proper system alerts and error handling throughout the technology stack were in place to notify our team immediately if a problem occurred.
• Countless Oracle Form and Reports changes.
• Tested Oracle Forms and Reports during a database upgrade.
• Worked extensively with end users in resolving production support related issues.

Sr. Oracle Developer

Confidential

Responsibilities:

• Corresponded with the Budget Director and Assistant Operations Director to translate legislation into technical designs for custom code developments.
• Worked the Dept. of Administration and Legislative Services Agency to develop a solution to calculate the 2007 property tax refunds per taxing district.
• Maintain, develop and test COBOL modules that were the backbone in calculating rates and levies for local units of government.
• Maintain, develop and test the Field Budget program in which the agency’s field reps and field supervisors use in processing local units of government budgets each year. The Field Budget Program was written in VB and utilized MS Access for a back - end per county, as well as Crystal Report XI for its reporting needs;
• Worked extensively with end users in resolving production support related issues.
• Mentoring and project managing of the intermediate and associate level programmers.