SUMMARY:

Work well under pressure, enjoy multi - tasking in interrupt-driven environments.

AREAS OF SPECIALIZATION:

Oracle Federal Financials (FED e-Biz) version 11.5.10, R12, Oracle Financials (EBS) versions 10.7, 11, 11.5.10, PL/SQL, Microsoft ASP.NET, C#, UNIX, C, XML/XSLT, UML

AREAS OF COMPETENCE:

Oracle e-Business Open Interfaces (Open Interface Tables and APIs), Relational Database Management System (RDBMS) Design and Implementation, Object Oriented Design (OOD) and Implementation, Functional Documentation, Technical Documentation, Data Warehouse Design and Implementation.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Monitor inbound/outbound interfaces with variety of tools.
• Assess impact of anomalies.
• Document daily statuses for Operations Management.

Confidential

Responsibilities:

• Provided technical assistance for bids on Confidential projects.
• Provided 3rd party consulting for Oracle EBS Interfaces.
• Completed R12 Oracle Subledger Accounting Fundamentals .

Confidential

Responsibilities:

• Assisted cross-functional application developers using internal knowledge of apps and business processes to resolve defects in complex processes.
• Developed Test Conditions and Expected Results (TCER) documents and constructed detailed test scripts to support defects and issues raised by government users.
• Responded to Customer Relationship Management (CRM) comments provided by Functional Management Office (FMO) /Project Management Office (PMO).
• Executed test scripts with FMO personnel during Integration testing.
• Assisted Accenture help desk in analyzing and resolving defect tickets raised by government personnel.
• Created Process Flow documentation using action and sequence diagrams (UML) for:
• Custom Fixed Assets (FA) program that updates audit information for transactions split across Purchase Receipts and/or Purchase Invoices.
• Inbound Oracle Projects transactions that create billing events, generate revenue and invoices then interfaced to AR.
• Oracle Fixed Assets (FA) SME:
• Supported custom extension issues and Fixed Assets process.
• Resolved application issues for complex defects.
• Documented mass additions formatting for the base Oracle Projects import scenarios

Confidential

Responsibilities:

• Employee performance appraisal system on two platforms Oracle e-Business R12.2.4 OAF and custom JBOSS. My role was to support back end custom pl/sql packages for the Oracle e-Business platform.

Confidential

Responsibilities:

• Primary support for the 18 inbound/outbound interfaces comprising the SDDC financial management system. The interfaces CARE (Government Purchase Cards), DTS (Defense Travel), DCPS (Defense Civilian Payroll), CDS (Central Disbursing), Requisition/Purchase Order/Accounts Payable Imports are comprised of inbound/outbound files, custom staging objects, mapping to the Oracle Open Interface tables and standard Oracle Import Functionality. My primary role as Technical Lead, involved mentoring staff to ensure timely/accurate completion of tasks and ensuring effective communication with the government customer (SDDC and DFAS Accountants).
• Re-engineered DCPS inbound payroll process to simplify importing actuals and accruals into General Ledger and Projects.
• Developed audit process to display all journal entries for individual purchase orders and invoices. This cannot be done through the application without reviewing all the journals containing the purchase order and invoice.
• Extensive modifications to AP/PO Interfaces accommodating revised business rules used to determine correct Project and Task for Purchase Orders and Invoices.

Confidential

Responsibilities:

• Prototyped conversions/interfaces of GL, Budget Execution, Receipts, AR, Customer and HRMS data using Open Interface feature of Oracle FED e-BIZ.
• Developed a tutorial document outlining the basics of BPEL in an effort to augment Oracle’s BPEL tutorials. This dealt mainly with translating instructions from the eclipse plug-in, to instructions for jdeveloper. The document also dealt with installation of the BPEL process manager, installation of jdeveloper and deploying a BPEL process.

Confidential

Responsibilities:

• Design Documentation for an Oracle PL/SQL stored procedure process that replicates high volumes of data to a data warehouse. This is a “close to” real time process that uses dblinks and dynamic sql to replicate the data.
• Designed and developed a C#, ASP.NET, Oracle Data Provider (ODP.NET)/Oracle 10g“Enterprise dashboard” to monitor interface status. This was enterprise in that the several regions had to be represented on one page. The project was developed in Visual Studio 2003 and emphasized reusable Object Oriented Design
• Specification (UML Documentation and Functional Hierarchy in VISIO) and development for the database component of an interface that performs inventory movements. This was an Oracle pl/sql stored procedure called from a C# service and performed the following:
• Data Validation
• Business rule validation
• Error Logging
• Actual inventory movement

Confidential

Responsibilities:

• Architect for an Oracle .NET Web Application that makes changes to Bill of Materials (BOM) attribute information. Also, wrote the Functional Specification, the Technical Specification and created a prototype.
• Participant in a Tuning and Performance Enhancement Initiative. Redesign and optimization of a process that posts inventory cost to the General Ledger for GLOVIA Procurement activities.
• Design, Development, Implementation of an XML application to extract criminal history and pass this information as XML documents to the Maine Dept. of Public safety for use as “rap sheets”. Design and Development of a web viewing tool to examine the XML documents using XSL stylesheets.
• Design, Development, Implementation of a complex Data Warehouse, using PL/SQL as an ETL tool to accommodate standard reporting for the District and Superior Court system of the State of Maine. These reports were for Case Disposition, reports for the National Court Statistics Project and Case Management statistics that measured elapsed time between the case benchmarks of filing, arraignment, trial, finding and sentencing. These reports also provided a complex encapsulation of probation violations. Design and Development of a web viewing tool to view the reports using XSL stylesheets. This project also required extensive tuning due to the complex indexing structure.

Confidential

Responsibilities:

• Design & development of procedures that emulate creation of GLOVIA Purchase Orders and emulate GLOVIA Inventory Receipt transactions.
• Design & development of a procedure that returned a BOM explosion from GLOVIA, to an ADO Recordset for Web Apps.
• Design & development of a price change application that encapsulated the many complexities of automatically creating change requisitions, for a web system that interfaces to the GLOVIA Purchase Order Management System. This system also was a kernel for development of a price inquiry system that could forecast the impact of price changes on all outstanding Purchase Orders.