EXPERIENCE:

Confidential, Vienna, VA

Sr. Software Application Developer

Responsibilities:

• Developed a Payables Interface in Confidential Integrated Acquisition System (IAS) to import and validate Invoice data to make invoices ready for payment by Confidential using PL/SQL language. The Confidential IAS is composed of decentralized Federal systems New system handles both 2 and 3 way Invoice Matching using XML feeds. Previous Confidential process was to manually enter Invoice Data into the system.
• New system utilizes Oracle’s Payables Open Interface and all validation rejections are exported back to Confidential reporting systems.
• Using Oracle Application Framework ( Confidential ) altered the business rule logic using Jdeveloper of Oracle Financials Vacation Rule screens in iProcurement module to implement new Confidential policy to allow only persons with equal or higher approval authority to approve Purchase Requisitions of Confidential employees on leave.
• Provided technical expertise during Confidential Office of Procurement Technical Team meetings.
• Made enhancements to existing Apex 4.2 Applications and created new Apex 5.0 applications.
• Created a team GIT software repository using BitBucket

Confidential, McLean, VA

Sr. Software Application Developer

Responsibilities:

• Maintaining and enhancement of Confidential custom packages written in PL/SQL in both ERP and DW applications. Dynamic SQL and PL/SQL Collections are used. Performance tuning done using TKPROF utility to view SQL Trace files.
• Maintaining and enhancement of Confidential Data Warehouse using the IBM InfoSphere DataStage ETL tool. Includes work on their Analytical Data Store (ADS) and Operational Data Store (ODS), and various other Data Marts that comprise Confidential ’s Enterprise Data Repository. Responsible for creating and maintaining views of warehouse data to meet various downstream apps across Confidential in various formats (xml, csv, json, html, etc.).
• Support Data Warehouse Production systems including troubleshooting and developing solutions.
• OnTime Interface - JSON to XML to SQL Java Interface Prototype - Pulling data from external system via web services calls, converting the received JSON formatted data into XML formatted data, cleaning up special HTML codes, then importing into Oracle SQL databases.
• Jasper Server and Reports Implementation - Setup Jasper Report Server web portal and recreate Proj20 Reports in JasperReports used by Confidential Project Manager to get weekly used vs available budget dollar numbers.

Sr. Software Application Developer

Confidential

Responsibilities:

• Oracle EBS R12 Upgrade including reimplementing all Confidential AP Payment process in new R12 Confidential Payments ( Confidential ) module from old retired R11 AP Payment module. All Payment modules required new scripting for SSH encrypted file transfers written in PL/SQL. Performed developer and oversaw user level testing.
• BI Publisher Related Work including AP Printed Check and other templates as part of 11i to R12 migration of payment processes from AP module to Oracle Payment ( Confidential ) Module
• PO Buyer POSigner Java App - Java app used by Confidential Purchasing Department Buyers to apply their hand signatures to Purchase Order PDF and to digitally signed the PDF with their PKI Certificate before sending to our vendors. Streamlined the Purchasing process and increased security to eliminate risk.
• Enhance previously delivered system discussed below. Based on new requirements from other Financial Departments that wish to utilize this tool, re-architect the design. The gathering, renaming, and placement of files into category directories are now performed internally and a zip file is produced. Zip files of archived files are transmitted to http web server so files can be retrieved by users from their Internet browser eliminating the setup of FTP Server on users’ computers. Written in PL/SQL.
• Technical Lead role during install in 2004. Continue as Technical Lead role, in past year instrumented several major upgrades of the vendor-provided software and several major dataloads as Confidential has rolled out system to various financial departments. Recently have trained other staff to allow myself to work on other projects.
• Heavily parameterized (39 parms) UNIX shell script that provides friendly easy-to-us migration interface to move customized changes to Oracle E-Business Suite Application Object Library entities in a repeatable and reliable fashion during software migration or upgrades. A wrapper for Oracle's FNDLOAD syntax intensive command to export and import AOL entities.
• Worked with Bank of America to design, implement, and test interface. Solution included PGP encryption, UNIX Shell Scripting, Active FTP protocol, and PL/SQL packages.
• Lead role from Requirement phase to Delivery. Financials Users can request copies of their financial reports for any period; the reports are transmitted to user’s PC or department’s archive system for placement on storage media for future inspection by auditors. Replacement for large bulky monthly report binders required for auditor inspections. Developed further enhancement to call JAVA PDF Library to convert reports to PDF format before transmittal. Written in PL/SQL.
• Provided presentations to other departments on Confidential Oracle Financials System activities.
• Provided oversight over phases of requirement discovery, design, code, test, implementation, and acceptance testing and vendor selection during Electronic Supplier EDI Payment Project. Confidential now pays most of our vendors electronically saving time and money.
• 90% involves customizing Oracle Reports for Confidential Financial department using PL/SQL; remaining 10% involve customizing data feeds using PL/SQL packages.
• Sought out by junior members and other teams for my expertise in methodologically troubleshooting technical glitches. Critical role during our 4 Oracle mandated upgrades of Confidential ’s Oracle Financials System in last 5 years.

Confidential, Vienna, VA

Software Developer (Sr. Member Technical Staff)

Responsibilities:

• Provide traditional software engineering principles to corrective and perfective software maintenance efforts to United States Coast Guards Finance Center’s Oracle Financial system suite.
• Engineered from Requirement to Delivery phases the Confidential ’s Yard Time Entry System Interface called Yard, Time and Absence ( Confidential ) Interface System to pull project tasks charge files from remote sub system and import into Oracle Project Task open interface tables and push project task refresh data to their Confidential sub system.

Confidential, Rosslyn, VA

Software Developer

Responsibilities:

• Performing Confidential compliance upgrading of the Confidential worldwide information management system.
• Provided traditional software engineering principles to the upgrade effort.
• Granted Secret Security Clearance for this position.

Confidential, Falls Church, VA

Team Member

Responsibilities:

• Managed daily operations of the company’s nationwide IVR Time Entry System. System now exported worldwide to Confidential Europe and Confidential Australia units.
• Confidential System ran in production over 13 years.
• Managed the project at all levels; providing design, analysis roles. Met with department managers to meet division objectives.
• Work across organization structure to accomplish objectives.
• Analyzed and Developed code design upgrades for Confidential under DOS and UNIX versions involving performance upgrades including:
• Fax Server Load Balancing sub-system.
• Diagnostic System Failure Paging sub-system.
• Report Prioritization & Load Balancing Generation sub-system.

Confidential, Falls Church, VA

Software Developer

Responsibilities:

• Member of small programmer team contracted by Confidential .
• The Confidential ’ Alcohol and Drug Information Tracking System ( Confidential ).
• The Confidential ’ Substance Abuse Information Management Operations System ( Confidential ).

Confidential, Falls Church, VA

Software Developer

Responsibilities:

• Member of three programmer team developed the Regulatory Tracking System (RTS) for EPA’s Regulatory Development Branch. .
• Member of two programmer team contracted by EPA’s Office of Solid Waste and Emergency Response ( Confidential ). Contracted to design and develop, and maintain all department’s early database tracking systems including:
• The Confidential Budget System for use in a Novell LAN environment.
• The Confidential CABLE System for EPA’s Office of International Activities ( Confidential ).
• EPA’s Office of Solid Waste Communication, Analysis, and Budget Division (CABD) Controlled Congressional Tracking System.
• EPA’s CABD’s FOIA Tracking System.
• EPA’s Office of Solid Waste Quarterly Report System to provide trend and data statistics for use by budgetary decision making.
• Onsite Technical Liaison management role between EPA department management and Confidential hardware and software subcontractors on the development of EPA’s Confidential Business Information Tracking System (CBITS).