Mabrouk A. Mabrouk

***** ******* ****** *******. *******, VA 571-***-**** ac3jpp@r.postjobfree.com

Active Secret Security Clearance

OVERVIEW

Results-driven accounting and auditing professional with +15 years of Federal Government and commercial experience and extensive expertise in:

Analysis of complex financial data and reports (abnormal balance, elimination, suspense, reconciling budget funds with programs costs, etc.), performing root-cause analyses, and developing corrective action plans (CAP)

Leading discussions with senior management to improve financial operations issues and recommendations to solve financial problems (abnormal balance elimination, trading partner suspense, posting logic)

Financial Improvement and Audit Readiness (FIAR), systems accounting, auditing, internal control and financial management using Generally Acceptance Accounting Principles (GAAP), Federal Accounting Standards Advisory Board (FASAB), Federal Information System Controls Audit Manual (FISCAM).

U.S. Standard General Ledger (USSGL), Federal financial statements and budget execution according to OMB Circular A-136, A11, A-123 and requirements of Federal financial reporting systems

Automated financial systems including Department of Treasury systems and OMB, (FFMS, FACTSI, FACTS II, GOALS II, TROR, GTAS, CARS, DAI, OBIEE, and FMIS) and financial systems for risk management controls

External audit of DHA financial statements using Generally Accepted Government Auditing Standards

Preparing Standard Operation Procedures (SOP) and implementing financial reporting policies and procedures according OMB and US Treasury procedures and guides (OMB A-11, A-136, and A-123)

Flux analysis for financial reporting, year-end closing package, balance sheet and net cost reconciliation and prepared statements footnotes.

I’m team player as part of accounting team preparing accounting monthly any yearly closing package entries. Expert in preparing financial reports in compliance with Generally Accepted accounting Principles (GAAP) including analytical financial analysis.

Fully understanding of accounting cycle including: journal entries, monthly general ledger accounts reconciliations, bank reconciliations, Accounts Payable (AP)and Accounts Receivable (AR) functions and reconciliations, income statement variance analysis.

Also I’m expert in the accounting system of Property, plant and equipment (PP&E).

PP&E is also called tangible fixed assets. These assets are physical, tangible assets and they are

expected to generate economic benefits for a period of longer than one year. PP&E include land,

buildings and vehicles.

PP&E is also called tangible fixed assets. These assets are physical, tangible assets and they are expected to generate economic benefits for a period of longer than one year. PP&E include land, buildings and vehicles.

PP&E is recorded in the financial statements in the balance sheet. The cost of PP&E considers the actual cost of purchasing and bringing the asset to its intended use. This cost is called the historical cost., the historical cost could include the purchase price, transaction fees and any improvements made to the building to bring it to its destined use. The value of PP&E is adjusted routinely as fixed assets generally see a decline in value due to use and depreciation

Working with external auditors for the annually audit function, and preparing the monthly, quarterly and annual reports for internal in supporting accounting and Finance management functions.

PROFESSIONAL EXPERIENCE

Senior Financial Analyst, 1/2017- Present

GRA Corporation, 7700 Arlington BLV, Falls Church, VA Client: DHA Financial Operations Division (FOD)

●Managed day-to-day operations for multiple accounting staff including overall work strategy, assignments and issue resolution

●Advised senior leadership on application of financial management theories, concepts, principles, and standards related to development, execution and maintenance of strategic and operational plans.

●Developed and implemented accounting practices and procedures as required by DHA policy and procedures with generally accepted accounting principles (GAAP)

●Prepared monthly, quarterly and year-end financial statements, including Balance Sheet, Statement of Net Position and Statement of Net Cost and Statement of Budgetary Resources (SBR).

●Provided analytical techniques to solve accounting problems for operating programs.

●Provided internal reviews with senior management for various financial reports including development, analysis, auditing and leading recommendations for financial statements issues

●Interpreted guidelines in accordance with generally accepted accounting principles (GAAP) to account for execution of funds and prepared Standard Operation Procedures (SOP).

●Assisted external auditor with DHA financial statements using experience in the Generally Accepted Government Auditing Standards (GAGAS) to achieve many improvements to government programs and operations.

●Developed management programs and internal controls for financial reporting operations and system related processes and served as point of contact for Inspector General (IG) and Government Accountability Office (GAO).

●Monitored financial operations in compliance with established internal controls to identify problem areas, and recommended actions required to improve operating program effectiveness.

●Developed and implemented financial control procedures and systems to maintain documents for audits including Standard Operation Procedures (SOP) in compliance with US department of Treasury, OMB and GAO

●Applied internal control standards including conducting a risk assessment and developing risk mitigation plan

●Developed detailed financial improvements, audit preparation methodologies and guidance

●Provided technical guidance and advice to management related to planning, coordinating, and generating variety of complex cost accounting reports and financial statements.

Senior Accountant 10/2015 – 8/2016

IFAS Company, Financial Management Division. 810 7th St, NW Washington, DC

Client: US Department of Justice, Office of Justice Programs (OJP)

●Managed fiscal record keeping in compliance with the Generally Accepted Accountable Principles (GAAP) and FASAB Standards.

●Reviewed monthly financial statements and budget variances and provided analysis and recommendations.

●Conducted analysis of accounting data and produced monthly financial reports and financial statements

●Managed budget execution, analysis and quarterly reconciliation financial statements

●Led preparation and review of Financial Statements and variance analysis

●Prepared annual, quarterly, monthly Financial Statements including Balance Sheet, Statement of Net Position, Statement of Net Cost and Statement of Budgetary Resources (SBR)

●Prepared year-end adjusting entries including accrued benefit adjustments, workers’ compensation liability (FECA)

●Reviewed journal entries to ensure accuracy of posing logic and data is posted correctly into accounting system

●Prepared Federal financial statement compilation, flux analysis, financial reporting, year-end closing package, balance sheet and net cost reconciliation and yearly statements footnotes.

●Utilized financial systems including Oracle Federal financial and Federal Financial systems (FFMS, GOALSII)

●Prepared multiple financial Statements according to the Generally Accepted Accounting Principles –GAAP, and FASAB Standards.

●Prepared Standard Operation Procedures (SOP) for accounting and financial management to establish effective management control for programs and business processes within the Division.

Systems Accountant 02/2014– 09/2015

James Stephen Corporation, Financial Management Division (Federal Contractor) Client: US Defense Security Service (DSS) – 27123 Telegraph RD, Quantico, VA,

●Utilized GAAP principles to review accounting transactions and applied accounting standard issued by the Financial Accounting Standard Board (FASAB).

●Managed financial statements reconciliations and Budget Reconciling (SF-132/133, SF-224 CARS Cash Reconciliation) to develop financial reports for determining root cause, corrective actions Plan (CAP) and financial performance.

●Prepared Standard Operation Procedures (SOP) for Triannual Review Process, per guidelines of the Office of the Under Secretary of Defense

●Developed project plans for budget execution and utilized Defense Agencies Initiative (DAI) System to provide budgetary data analyses illustrating effect of changes in levels of funding for current projects

●Collaborated regularly with the Defense Security Service to interpret budget policy and practices as required by auditors

●Performed financial analyses on accounting data for various programs, including Standard Form SF- 133/SF-132, Balance Sheets, Statement of Net Cost, Statement of Change in Net Position, and Statement of Budgetary resources.

●Prepared recurring and special reports (Abnormal Balance, Eliminations Suspense) and distributed to program managers for compliance and audit readiness issues

●Contributed to improvement of DAI and OBIEE system report by mapping US Standard General Ledger (USSGL) accounting codes and description to OBIEE reports (open obligation; ULO; UMD; NULO; Invoices, Interest Invoices)

●Reviewed financial activities relative to appropriated fund accounts for allotment fund control, including the accounting cycle and reconciliation of the Trial Balance general ledger balances all reports internal and external.

●Provided abnormal balance analysis and resolved abnormal balances and discrepancies by creating adjustments journal entries.

●Coordinated with the external auditor to solve finding issues and weakness materials.

Senior Financial Accountant, 06/2011 – 01/2014

Federal Management Systems Inc. (FMS), 465 K ST, NW Washington, DC Client: Department of Education, Federal Student Aid

●Provided advisory services on accounting and regulatory matters, including accounting processes and controls (remediation, long-term contract accounting, and cost accounting)

●Prepared financial statements in accordance with Generally Accepted Accounting Principles (GAAP)

●Applied GAAP to identify and analyze accounting issues and recommend solutions

●Analyzed monthly, quarterly, and year-end financial statements

●Prepared Standard Operating Procedures (SOPs) for financial processes

●Performed GAAP conversion, transaction accounting, and financial reporting

●Developed Statements of Federal Financial Accounting Standards (SFFAS), Statements of Federal Financial Accounting Concepts (SFFAC), and OMB Circulars A-123, A-127, A-134, A-136.

●Managed financial and accounting transaction (TC) and posting logic for USSGL, including reconciliation of prior year adjustments for budgetary and proprietary accounts (Obligation A/P, A/R, FBWT, and PP&E)

●Served as point of contact between FSA and the Inspector General (IG) for inspections, audits, Government Accountability Office (GAO), and other federal Inter-governmental agencies.

●Prepared daily Journal Entries and uploaded it to the accounting System Preparing monthly financial Statements for FMS, and provide flux analysis for the Financial statements.

●Prepared monthly undelivered orders and reconcile the fund balance with SGL trial balance.

Senior Accountant, Grade Level: GS-0510-14 /5 10/2007 – 05/2011 US Department of Education, Federal Student Aid (FSA), 831 First St, Washington, DC

●Analyzed obligation, disbursement and unliquidated obligation balance and reconciled with the Statement of Budgetary Resources

●Established internal control process to be consistent with the OMB-Circular A-123 "Management Accountability and Control," and recommended an approach for evaluating, improving, and reporting on internal controls

●Prepared FSA financial reporting for monthly Direct Loan Financial Statements (Balance Sheet, Statement of Net Cost, Statement of Net Position, and Statement of Budgetary Resources)

●Provided financial analysis and key recommendations to senior management to make sound decisions

●Prepared FSA financial statements and flux analyses for the Direct Loan Program according to federal finance reporting standards and policies, including OMB Circulars A-11 and A-136

●Prepared monthly analyses for Transaction Information Executive Repository (TIERS) for FSA

●Prepared auditor PBC submission list and provided support for the annual audit.

●Served as Point of contact at FSA financial management to cooperate with external auditors to handle all finding issues, material weakness, and Correction Action Plan (CAP).

●Designed internal controls to safeguard assets, ensure compliance and promote efficient and effective operations

●Recorded daily accounting data into FMMS accounting system and ran weekly reports and reconciliations of Trial Balance and Cash Reconciliation.

●Prepared Standard Operation Procedures (SOP) and assisted in implementing financial reporting policies and procedures according OMB and US Treasury procedures and guides (OMB A-11, A-136, and A-123).

●Prepared Cost Metrological Analysis for indirect cost allocation to FSA programs, using the strategic goal rate to allocate the cost

●Prepared yearly financial statements Footnotes’ to clean all audit finding and PBC.

Systems Accountant, Grade Level: GS-0510-13 7/2002 – 10/2007 US Immigration and Customs Enforcement (ICE), 800 K Street, NW Washington, DC

●Analyzed results of Federal Financial Management System (FFMS) to design new and improved financial systems and processes

●Contributed to knowledge of governmental accounting practices and procedures of GAO, OMB, and Department of Treasury toward analyzing accounting systems and programs as well as net cost programs of ICE.

●Managed yearly financial statements in accordance with ICE accounting policies and procedures, and U.S. Standard General Ledger (USSGL) parameters

●Supervised financial analysis in support of DHS and Department of Treasury policies and prepared monthly, quarterly and yearly analyses of the Balances for the Transaction Information Executive Repository System (TIERS)

●Assisted in submitting Federal Agencies’ Centralizer Trial Balance System (FACTS I and FACTS II), supporting pre-closing adjusted trial–balance (ATB)

●Prepared footnotes and supplemental information for ICE financial statements.

●Provided monthly analysis and reconciliation of Fund Balance with Statement of Difference (SOD), Budgetary versus Actual, SF-132 and SF-133 with Statement of Budgetary Resources (SBR).

●Provided technical consultation and guidance to program managers advising them to develop the accounting method and treatment for the Immigration user fees and object class issues,

●Reviewed fund control system to ensure it reflects the financial activity of appropriated fund and designed tool

production tables for allotment fund control and prepared the fund reconciliation.

●During my working with ICE I control the recording of cost of newly-acquired fixed assets (both tangible and intangible), tracking existing fixed assets, recording depreciation, and accounting for the disposition of fixed assets. I used the Sunflower software in recording and tracking all fixed assets and the annually depreciation.

● My major participation in PP&E accounting function was as follow:

-Create and monitor a system of controls, procedures, and forms for the recordation of fixed assets.

-Recommend to management any updates to accounting policies related to fixed assets.

-Review the assign tag numbers to fixed assets.

-Record fixed asset acquisitions and dispositions in the accounting system.

-Track the compilation of project costs into fixed asset accounts, and close out those accounts once the related projects have.

-Reconcile the balance in the fixed asset subsidiary ledger to the summary-level account in the general ledger.

-Review the depreciation calculation of for all fixed assets.

-Review and update the detailed schedule of fixed assets and accumulated depreciation.

-Calculate asset retirement obligations for those fixed assets to which AROs are applicable.

-Investigate the potential obsolescence of fixed assets.

-Prepare monthly financial analysis for the status of fixed assets including PP&E balances

-periodic impairment reviews for intangible assets.

-Conduct periodic physical inventory counts of fixed assets.

Senior Accountant GS-0510, 12 3/2000 – 7/2002

US Immigration and Naturalization Service (INS), NW Washington, DC

● Team Lead for INS Office of Financial Management (OFM) accounting operations, managed Statement of Foreign Transactions (SF-1221), Statement of Transactions (SF-224), Vendor Payments process (SF-1166 report), and Collection Report (SF-215 and 5515)

● Performed reconciliation for Statement of Transactions (SF-224) with Treasury Reports SF-6653, 6654, and 6655

● Developed and introduced quality control plans and standard operating procedures (SOPs) targeting multiple financial programs in support to INS administrative programs

● Managed collection account for International Financial Service Centers (Bangkok, Mexico, and Paris)

● Reconciled obligation accounts and mandated correctional of all financial errors to meet critical timelines

● Collaborated with cost accounting teams from INS to redesign a model for procedures of Activity-Based Costing System (ABC), user fee costs, and modify the model every three years to update user fees cost

● Advised senior leadership on the application of financial management theories, concepts, principles, and standards related to development, execution, and maintenance of strategic and operational plans.

EDUCATION

University of Alexandria, Faculty of Commerce; Alexandria, Egypt

Bachelor of Business Administration, Accounting and Finance 160 Semester Hours; Chartered Accountant (CPA equivalent)

TECHNOLOGY SKILLS

●Oracle, Cognos, MONARCH, RMMS, FACS, FFMS, Advance Microsoft Excel(Pivot table, V Look Up Microsoft Word

●SECURITY CLEARANCE: Active Secret Security Clearance

Contact this candidate