Served on the Accounting System Selection Team and the EDCAPS Implementation Team, as the Reporting Team lead, for both the Oracle Financials 1103 and the 11i FMSS implementations.

Designs and Develops Reports, Writes program code for the Systems Operations and Maintenance Group using Cognos Report Studio (10.2) and Oracle Report Builder. Provide complete Reporting and Ad Hoc support such as system and audits queries, individual troubleshooting, while also holding workshops and classroom training.

Serves as Cognos Business Intelligence Suite Administrator (8.2-10.2) creating views and packages among various financial systems while providing full conversion support between implementations and upgrades. Also maintains all user access using Oracle Active Directory security account profiles.

Acts as Education Lead, FMSS Lead and QA Manager for development of web based reports. Built the EDCAPS Reporting Web Server, creating and updating the sites content and maintaining the Oracle Reports software and interfaces, while providing full system support.

Serves as Reports Systems Administrator by managing and maintaining system support for the various reports writing software, including software installations and upgrades, revisions to the database joining structure and the creation of SQL views, summary tables and powercubes to create various end-user layers. Also creates and maintains all user ID�s and security account profiles.

Designs and Develops Finance, Accounting, AR, AP/PO, Travel, Procurement, Gants and Management reports while assisting and instructing Department employees on usage of these various Cognos (Impromptu\Powerplay) and Oracle (Discoverer/Report Builder) report writing tools by providing one on one as well as classroom training.

Provides accounting system general ledger support. Manages and assigns projects while updating and maintaining transaction code tables. Perform GL reconciliations, monitor and safeguard the use of suspense accounts. Acts as liaison with computer system programmers and the different finance and budget offices. Assists and instructs in the uploading and downloading of transfer files among the various financial systems while coordinating and developing security access procedures among these systems.

Installs, maintains and instructs the use of NFC software such as PC-Purch and PC-Travel while serving as the System Administrator

Acts as Education�s EDI Accounting Lead keeping Education EDI compliant, while also serving on various federal government EDI/Electronic Commerce working groups.

Plan, direct and manage financial operations including Accounting, Payroll, Travel, and Imprest, while serving as both the Chief of Accounting and the Assistant Director of Financial Services.

Discovered and corrected a major programming flaw in the accounting system that allowed unapproved requisitions to be procured and which went undetected for 15 yrs. Uncovered and curtailed the misuse of Appropriated funds then organized Appr Law Seminars open to all contract, procurement and accounting staff.

Organized monthly Budget/Finance meetings with organizational heads.

Assist in the formulation of work plans and cycle memos for National Coordinated Audits and audits pertaining to the National Office.

Prepare audit work papers, flowchart procedures, and draft statements and summaries of significant findings.

Supervised accountants, interns and newly assigned accounting personnel in the application of the utilization of the accounting system, the principles of accounting, and the rules and regulations, which ascertain the validity of appropriation expenditures.

Acted as a major conduit between management, branch heads and staffs of the EOP agencies by providing accounting advice and support for 40 appropriations, including personally handling the White House and the Vice President's Residence accounts.

Troubleshot work priorities and significant problems encountered in the development of special studies and analyses of unusual transactions or current media issues. Provided assistance in the formulation and development of written procedures to maintain a proper day-to-day operation.

Spearheaded independent analyses by running accounting and AD HOC reports. Reviewed trends, problems and relationship of accounting and budget data by creating and analyzing spreadsheets.

Developed improvements, recommended design changes and made major revisions to the accounting system. Advised management officials in FMD on problems within the mainframe. Ran and scheduled system jobs, and was responsible for running daily edits and conversions. Acted as liaison with computer consultants and the EOP management.

Performed all reconciliations with the Department of Treasury and provided complete month-end and year-end fiscal reports for the agencies supported by the Executive Offce.

Assumed Duties of Accounting Officer in his absence.

Reviewed, classified and maintained reporting of all travel expenses, assuring that each expenditure was accounted for and adhered to the rules governing each contract. Made payments for travel-related invoices and reimbursements, obligated and deobligated funds, while posting transactions to the accounting system.

Reconciled major accounts as well as creating graphs for BDM's monthly financial reports.