SUMMARY:

• I possess over eight years of experience primarily in Oracle EBS, federal financial accounting and reporting. My federal experience focused on Oracle upgrade assessment, operations and management support, configuration, full - cycle accounting including accounts receivable, accounts payable, general ledger, budgeting, reporting, project accounting, compliance, audit, and various financial analysis.
• Oracle Federal Financials - DHHS, DSS, BEP, NIH
• Accounts Payable/Accounts Receivable
• General Ledger preparation/analysis
• Variance Analysis of Budgets and Forecasts
• Financial Audit/Audit Support
• Financial Reporting and Reconciliation

PROFESSIONAL EXPERIENCE:

Confidential, Ashburn, VA

Oracle EBS Functional P2P Consultant

Responsibilities:

• Assist the technical consultants to understand the customer accounting requirements to customize the functions and reports
• Support the production environments and users daily by resolving Incident/Helpdesk Tickets Initiated by users.
• Provide and conducted practice and Business Process Walkthrough sessions as needed to educate users.
• Extensively work on troubleshooting, fixing the issues with Internal/External requisition, PO Approval issues, Stuck Purchase Orders in the Workflow, PCARD Transactions and Reconciliation, AP Invoices, AR Receipts and Projects.
• Develop and coordinate Change Requests (CRs) and Service Requests (SRs) for operational data updates, required configurations and more.
• Closely work with the technical teams to deliver the solutions as per the functional designs and customizations.
• Perform Month End Mock in QUAL (cloned instance) to and troubleshoot any issues that may delay Month End close activities in production.
• Assist/support NIH’s Office of Financial Management with Month End Close activities in Production and prepare month end/year end close related WebADI in OMBMax.
• Conduct User Acceptance Testing (UAT) and assist/collaborate with the QA team for developing/updating the test plans, test cases and test data to be used in testing.
• Conduct the Gap Analysis to understand the 'as-is' and the 'to-be' scenarios.
• Documented the current process flows, business requirements and fit/gap analysis for PCARD E2E process.
• Provide Fiscal Year End close support.
• Perform ad Hoc analysis as required.

Confidential, Clifton, VA

Sr. IT Auditor/Oracle EBS Functional Consultant

Responsibilities:

• Review/Study the current business processes/requirements, examine IT related internal controls and future business flow in order to provide an integrated information system solution to ensure compliance and meet the business needs of the agency.
• Utilize OBIEE tool and build/share custom report per client's request with in DAI.
• Develop and coordinate Service Change Requests (SCRs) for special reports upgrades and development.
• Perform analytical services, process mapping as it relates to financial systems and audit readiness.
• Conduct business process walkthroughs and develop SOPs and Sustainment Plan for DAI and for other feeder systems.
• Perform ad hoc analysis as required.

Confidential, Rosslyn, VA

Oracle EBS Functional Consultant

Responsibilities:

• Served as Finance Lead on the R12.2 Upgrade Assessment project mainly responsible for Oracle Financials and Public Sales.
• Understood and Studied the current business processes/requirements and future business flow to provide an integrated information system solution to meet the business needs of the company.
• Prepared the New Features Report and Add on Modules Report for the Oracle’s new latest releases R12.2.3 & R12.2.4 to justify upgrade requirements of the client.
• Performed Regression Testing for Oracle Financials including but not limited to General Ledger, Accounts Payable, Accounts Receivable, Fixed Asset, Project Testing, Cash Management, iProcurement, Purchasing and Personalization Tasting for Financials.
• Delivered functional specifications for the new solution integration as a SME for Oracle EBS
• Coordinated the resources for upgrade assessment over multiple Operating Units
• Analyzed user needs, conferred with users to improve procedures and identified and solved problems
• Performed ad hoc analysis as required.

Confidential, Rockville, MD

Project Manager/Finance Consultant

Responsibilities:

• Managed finances for the Office of Director and several FOH Cost Centers.
• Collected and reviewed financial data and analyzes sales revenues, operating expense, contractual costs and intrafunds for all business lines of the FOH Cost Centers.
• Developed detailed spreadsheets to identify trends and develops forecasts. Consolidated and analyzed monthly results and budgets, and presented them to Budget Managers and Directors of different Divisions.
• Produced and delivered presentations, providing recommendations on short- and long-range operating budget plans, and identifies key risk factors and forecasting viability for future expenses.
• Established new forecasting tracking and management reporting worksheets on Microsoft Excel to improve availability and accuracy of financial data pulled from STM, PRICES, UFMS and FFSS.
• Obtained major role in Administration and Resources Management (ARM) component of FOH to assist with special projects that include major reconciliation of Contracts Charges.
• Worked with internal and external auditors during reviews and audits to ensure full cooperation from accounting staff and compliance with all qualified requests.
• Assisted the AP and AR teams, as needed, to process transactions such as IPAC, 1080 and Journal Vouchers using ORACLE Financial.
• Provided PSC-59 requests to Funds Control Team to reallocate expenditures previously posted to assist OPDIVs with UDO (Undelivered Orders) reconciliation.
• Performed in-depth variance analysis between actual operating results and budget forecasts including identifying and investigating variances for use by management in decision making.
• Performed ad hoc analysis as required.

Confidential

Project Manager

Responsibilities:

• Managed and led a team of 15 professionals, including: selection/hiring, objective setting, performance management, coaching/development, management consulting and at PSC.
• Obtained major role as the “Accounts Payable Team Lead” and assisted with special projects that included major reconciliation of Investigation Charges.
• Created and implemented accounting policies and provide guidance regarding accounting transactions.
• Worked with internal and external auditors during reviews and audits to ensure full cooperation from accounting staff and compliance with all qualified requests.
• Assisted the AP and AR teams, as needed, to process transactions such as IPAC, 1080 and Journal Vouchers using ORACLE Financial.
• Collected data from various sources for accounting purposes and administer the data on a daily, weekly and monthly basis.
• Generated budget forecasts for various charges on a quarterly basis and presented them to Budget Managers and Funds Control Departments of different Staff-Divisions.
• Processed PSC-59 G-schedule requests to reallocate expenditures previously posted and assisted OPDIVs with UDO (Undelivered Orders) reconciliation.
• Performed in-depth variance analysis between actual operating results and budget forecasts including indentifying and investigating variances for use by management in decision making.
• Regulated the accessibility of funds for various types of charges.
• Performed ad hoc analysis, as required.
• Introduced and trained other accountants to help familiarize with the systems at hand.

Confidential

Staff Auditor

Responsibilities:

• Assisted the KPMG audit team with the audit of the financial statements.
• Reviewed and verified records and external financial statements of the Department of Energy as part of an auditing process.
• Obtained and documented understanding on various accounting and reporting procedures and guidance performed at the Department of Energy.
• Analyzed financial statements, accounting policies and identified risks associated with various accounting and reporting task performed by the Department of Energy employees.
• Performed audit on various audit projects such as Payroll Audit, Financial Reporting Audit and Revenue Audit.
• Prepared narratives of understanding, memos of concluding audit test work and prepared audit reports presenting audit findings.
• Verified compliance of obtained reports to the policies, procedures and standards of the Department of Energy.
• Suggested improvement in accounting policies to avoid potential risks, including but not limited to automated reviewing and control self-assessments.
• Assisted with development of several audit procedures and perform ad hoc analysis as required.

Confidential

Junior Accountant

Responsibilities:

• Processed transactions for Federal government entities using ORACLE Financial.
• Prepared Journal Vouchers for Interagency Transfers of funding.
• Obtained major roles in special projects that include reconciliation of investigation charges.
• Reviewed and verified records and compliance with policies, procedures and standards.
• Recommended modification or changes to solve the identified problems in accounting records.
• Maintained accounts, verified payment documents and prepared monthly and daily billing entries.
• Collected data from various sources for accounting purposes and administered the data on a daily, weekly and monthly basis.
• Generated budget forecasts for various charges on a quarterly basis and presented to the Budget Managers and Funds Control Departments of different Staff-Divisions.
• Regulated the accessibility of funds for various types of charges.
• Performed in-depth variance analysis between actual operating results and budget forecasts including indentifying and investigating variances for use by management in decision making.
• Performed ad hoc analysis and introduced and trained other accountants as required.
• Received the Government Accounting Improvement Team .

Confidential, Rockville, MD

Accounting Associate

Responsibilities:

• Prepared weekly, monthly and quarterly expense statements for internal departments and partner institutions.
• Processed departmental accounts receivable and accounts payable daily.
• Collected data from various sources for accounting purpose and administer the data on monthly basis.
• Performed in-depth variance analysis between actual operating results, budgets and forecasts including indentifying and investigating variances for use by management in decision making.
• Met quarterly with the business unit’s management to review spend trends and assist in indentifying alternatives to meet financial goals.
• Prepared Journal Vouchers to transfer departmental charges.
• Prepared and analyzed General Ledger at the end of fiscal years for departmental accountants.
• Assisted with budgets and budget adjustments.
• Performed ad-hoc analysis as required.