Accountant/Controller (Reynoldsburg)

Vickie L.
Ellis Accountant/Controller Active Secret Clearance Education Doctor of Philosophy (PhD), Current, Advanced Studies in Human Behavior, Capella University (Minneapolis, MN) Master’s Degree, Religious Studies, May 2010, Howard University (Washington, DC) Bachelor’s Degree, Accounting, June 1996, Otterbein College (Westerville, OH) Computer Skills Microsoft Word, Microsoft Excel, Quattro Pro, ARTMS, Quick Books, Great Plains, Crystal Reports, Peachtree, GATES, Access, Display Write Four, Approach, AS 400, One Write Plus, Ami Pro, Lotus 123, Word Perfect, Fosse, Solomon, IMIS, Mas 90, Construction Manager, Lawson, Infinium, Query, Lotus Notes, Creative Solutions, FRx, eMass, MICP, Turbo Tax, Proseries, Tax Cut, Tax Pro, Defense Department Reporting System-Budget (DDRS-B), Defense Department Reporting System-Audit Financial Statements (DDRS-AFS), Deltek Costpoint 8.
0.
19, Corporate Electronic Document Management System (CEDMS), Account Management and Provisioning System.
Employment Accountant Consultants International - (March 2023 – Present) Senior Accountant: I work for multiple companies and individuals.
• Software: Microsoft Word, Microsoft Excel, PowerPoint Presentation, and QuickBooks.
• Completed the following duties: Financial statements, federal taxes, state taxes, personal property taxes, city taxes, accounts payable, accounts receivable, reconciliation of bank statements, customized reports, journal entries, fixed assets, 1099, payroll, budgets, compiling credit card statements, month end account reconciliations, depreciation of assets, financial reporting, create general ledger accounts, set up new accounting systems, corrective action plans, internal controls, purchase orders and other accounting and auditing duties as assigned.
Budget Analyst III – Federal Government Contractor (April 2021 – February 2023) Paragon Technology Group: I worked for the United States Department of Defense on the Air Force Financial Improvement & Audit Remediation Project as a Federal Government Contractor.
• Software: Microsoft Word, Microsoft Excel, Microsoft Visio, PowerPoint Presentation, Adobe Pro, Defense Department Reporting System-Budget, Defense Department Reporting Deltek Costpoint 8.
0.
19, System-Audit Financial Statements, Corporate Electronic Document Management System, Account Management and Provisioning System (AMPS), • Completed the weekly activity report for our team of ten workers.
• Completed work duties according to the Financial Statement Compilation & Reporting (FSCR) Guidance.
• Completed work duties according to the Financial Improvement & Audit Readiness (FIAR) Guidance.
• Updated the Notice of Findings & Recommendations in the Office of the Deputy Chief Financial Officer (ODCFO) database.
• Updated Corrective Action Plans in the ODCFO database.
• Completed the Defense Enterprise Accounting & Management System (DEAMS) posting logic compliance with the United States Standard General Ledger.
• Reviewed the DEAMS Business Cases and reviewed the Accounting Treatment Manual.
• Reviewed the Trail Balance and Journal Voucher (JV) logs for accuracy.
• Reviewed JVs for accuracy.
• Reviewed purchase orders for accuracy.
• Reviewed liquidity for accuracy.
• Reviewed JVs, Notice of Findings & Recommendation and financial statements to ensure audit readiness according to the FIAR Guidance.
• Utilized the Treasury Financial Manual to verify accuracy of general ledger account transactions.
• Reviewed the FSCR process cycle memos for accuracy.
• Reviewed the Defense Department Reporting System Balance Sheet, Statement of Budgetary and Statement of Net Cost Drilldowns for accuracy.
• Reviewed the FSCR Process Narrative and added updates.
• Reviewed the FSCR Process Flow Flowcharts for accuracy.
• Assisted with the Root Cause Analysis.
• Assisted with Risk Management Framework • Assisted with the DEAMS Report and edited it for accuracy.
• Read the Department of Air Force, Agency Financial Report and updated for accuracy.
• Updated Management Representation Letters.
• Updated messages from the Chief Financial Officer Letters.
• Updated messages from the Secretary Letters.
• Updated the Task Management Tool Guides.
• Updated the Electronic Staff Summary Sheets.
• Updated the Management Response Glass Door Letters.
• Updated Management Response Letters.
• Updated the message from the Secretary of the Air Force Glass Doors Letters.
• Updated the Effectiveness of Internal Control Over Operation Reports.
• Read and edited the Draft Statement of Assurance Material Weaknesses & Significant Deficiencies.
• Updated the Summary of Management Report.
• Reviewed the General Accounting & Finance System-Reengineered JV logs for accuracy.
• Completed the following duties in Deltek Costpoint for timesheet accounts for two Federal government contractors: setup my accounts, setup and updated passwords, viewed vacation time available and used, viewed accrued sick and vacation time, selected direct and indirect general ledger accounting codes according to the project year and duties performed, made comments/explanations for changed hours and entries, ran queries on previous timesheets and made changes as necessary.
Accountant Consultants International (November 2020 – April 2021) Senior Accountant: All duties are completed for companies and individuals.
• Software: Microsoft Word, Microsoft Excel, PowerPoint Presentation, Peachtree, QuickBooks, Great Plains, Crystal Reports, Drake Tax Software, Turbo Tax, HR Block Tax, Ultimate Tax, Tax Slayer Pro, Tax Act, and OLT Pro Professional Tax Software.
• Completed multiple business taxes for companies, non-profit organizations, and government agencies.
In fact, I complete federal, state, local, property, and sales taxes.
• Completed multiple types of personal taxes for individuals that live in the United States of America and individuals that live internationally.
In fact, I complete federal, state, local, personal property, and sales taxes.
• Customized and create companies, non-profit organizations, and government agencies accounting and financial system from start to finish.
• Customized accounting and bookkeeping for companies, non-profit organizations, and government agencies, so the accounting and bookkeeping can be done easily for everyone that in entering data into the accounting system.
• Trained others how to use multiple accounting systems.
• Completed purchase orders • Completed account receivables duties and accounts payable duties for companies, non-profit organizations, and individuals.
• Completed budgets, financial reports, analysis for multiple companies, non-profit organizations, and individuals.
• Assisted companies and individuals get audit ready for financial audits, IT audits, and individual audits.
• Assisted companies with any and all accounting, bookkeeping and tax services from start to finish.
Financial Audit Consultant – Federal Government Sub-Contractor (March 2020 - November 2020) Sub-Contractor for EDC Consulting Company: I worked for a Federal Government Contractor at the United States Department of Defense on the General Fund Enterprise Business System (GFEBS) Project.
• Software, Websites and Applications: Microsoft Word, Microsoft Excel, PowerPoint Presentation, Deltek/Costpoint, PCLAIM, WordPress, SLACK, Survey Monkey, TEAMS, Survey Monkey, Deltek Costpoint, JKO Training, Security Training, Education & Professionalization Portal (STEPP), SAP, and Cisco Webex.
• As a Financial Audit Consultant, I completed sustainment operations, quality assurance procedures, configuration management assignments and audit assurance work.
• Completed the following work duties, Script Touch-Point Reports, Edit Checks and Validation Reports, Technical Design (TD) Error Identification Reports, TD Reports, Army FY19 ITACS Per System Listing Report, Non-Disclosure Agreement (NDA), Business Process Application Control Reports, GFEBS Entitlement Reports, Redstone DD-2875 Documents, NIPR DD-2875 Documents, GFEBS Control Catalog Baseline Report and Contract Vendor Pay (CVP) Interface Report.
• Analyzed, utilized and reviewed the following reports: Cost Model, GFEBS Contract Pay Narrative, U.
S.
Department of the Army FY 19 Financial Statement Audit, General Fund and Working Capital Fund - FY19 GFEBS SSAE 18 - Notice of Finding and Recommendations Report, GFEBS FAMS Pilot Scope PowerPoint Presentation, GFEBS FY20 Control Metrix, Business Process Document (BPD) Narrative Reports, Business Process Overview Temporary Duty (TDY) Report, Business Process Overview Government Purchase Card (GPC) Report, Business Process Overview Miscellaneous Payment Report, Business Process Overview Reimbursable Report, Business Process Overview Supply Procurement Report, Business Process Overview Civilian Payroll Report, Statement of Budgetary Processes, Financial Management Reports, Business Process Application Control Reports, Cost Model Reports, Baselined Report, U.
S.
Department of the Army Procure-to-Pay Report, GFEBS Spending Chain Module Report, Commit and Obligate Funds, CVP Commit and Obligate Fund Reports, CVP Perform GFEBS Entitlement Report, CVP Perform Contract Closeout, CVP Execute Miscellaneous Payment Report, GPC Reports, Transportation of People Reports, Transportation of Things Report, Reimbursable Work Order-Buyer Reports, Army Construction Reports, GFEBS Control Catalog Baseline Reports, Control Catalog Report, GFEBS Control Catalog Baseline Report, GFEBS OS DB Patch Management SOP, GFEBS System Engineering Management Plan Report, GFEBS ARIS Standard Report, GFEBS Process Details Report, GFEBS Configuration Management Plan Report, GFEBS System Security Plan Report, Access Management Report, Configuration Management Report, Contingency Planning Report, Security Management Report, Segregation of Duties Report, Contingency and Business Continuity Plan Report, GFEBS Documentation Inventory Report, • Researched and examined TD Reports for master data, purchase request, purchase orders, inventory receipt/goods receipts, disbursements, and data reporting.
• Completed the following duties in Deltek Costpoint for a Federal government contractor to complete my daily timesheet: setup my personal account, setup and updated passwords, viewed vacation time available and used, viewed accrued sick and vacation time, selected direct and indirect general ledger accounting codes according to the project year and duties performed, made comments/explanations for changed hours and entries, and ran queries on previous timesheets and made changes as necessary.
Financial System Analyst/System Manager (March 2015 – March 2020) United States Department of Defense, Defense Finance & Accounting Service • Software: Microsoft Word, Microsoft Excel, PowerPoint Presentation, Enterprise Mission Assurance Support Service (eMass), Managers’ Internal Control Program (MICP), and Configuration Management Information System (CMIS) • As a System Manager, I manage a team of Developers, Programmers, and Information System Security Managers (ISSM).
• Saved the Defense Finance and Accounting Service (DFAS) over $70,000 in Defense Information Systems Agency (DISA) invoice charges.
DISA’s, invoices were incorrect and overstated.
Therefore, I spoke directly to the DISA customer account representative (CAR) and she issued DFAS multiple credits on the Transportation Support System (TSS) application.
• Saved DFAS over $300,000 annually by managing the retirement of the Transactions by Others (TBO) application and the Transportation Support System (TSS) application.
Therefore, since both applications were decommissioned, DFAS will save over $500,000 annual for many years to come.
• Managed Audit Readiness (AuR) and Non-AuR financial systems such as Standard Contract Reconciliation Tool (SCRT), TSS, and TBO.
• Validated that correct the AuR and Non-AuR regulations were in place and properly utilized according to federal government regulations for the SCRT, TSS and TBO applications.
• Managed the retirement of the TBO application.
Even so, the TBO application retired on May 31, 2017.
• Managed the retirement of the TSS application.
Even so, the TSS application retired before it’s estimated retirement date.
It retired on March 19, 2019.
• Utilized the National Institute of Standards and Technology (NIST) 800-53 to research and apply Federal government security and privacy control regulations to Federal information systems.
• Provided analysis, evaluation, and maintenance of plans and programs to meet activities and government objectives in the area of accounting systems.
• Completed audits that comply with the Federal Information Security Management Act (FISMA).
• Utilize knowledge of automated information systems development, particularly functional design concepts and techniques in support of government financial management systems.
• Completed audits that comply with the Federal Financial Management Improvement Act (FFMIA).
Therefore, I complete the notes, federal sources, and validations for the audit trails, system controls and documentation, general controls, system access, system design and architecture, system performance, and system security chapters.
• Assisted with the completion of Risk Management Framework (RMF).
• Applied internal controls, information assurance, and serve as an Information System Security Manager (ISSM).
• Completed functional interpretation of system changes and enhancements received from the user community and directed by regulatory changes and for taking appropriate and corrective action on malfunctions and deficiencies reported by system users.
• Completed audits that comply with the Federal Information Controls Audit Manual (FISCAM).
Therefore, I determine initial risk levels, testing methods, control frequencies, risk descriptions, testing methods, population sizes, sample sizes, and testing documentation locations.
• Completed DoD information technology annual budgets for multiple financial accounting systems.
• Work with the Defense Information System Agency (DISA) to establish Planning Estimates (PE) for each systems IBM charges, Unisys charges, storage charges, and server charges.
In addition, other charges such as enterprise services, other reimbursable services, and milCloud are included in the PE.
• Reviewed annual budgets monthly to ensure financial accounting DoD system budgets are not overstated or understated.
• Completed reports and agreements such as System Access Controls, Interface Agreements, System Security Plans (SSP), Incident Response Plan (IRP), System Identification Profiles (SIP), DoD Information Technology Portfolio Repositories (DITPR), Appointment Letters, System Integration Tests (SIT), System Acceptance Tests (SAT), Information System Contingency Plans (ISCP), Privacy Impact Assessments (PIA), Configuration Management Plans (CMP), Bodies Reports, and Post Implementation Metrics Report for monthly releases.
Senior Accountant Contractor (June 2011 – March 2015) Self-Employed Accountant: All duties are completed for companies, organizations, and non-profit organizations • Software: QuickBooks, Great Plains, Crystal Reports, Peachtree, AS 400, Solomon, Mas 90, Construction Manager, Creative Solutions, FRx, Microsoft Word, and Microsoft Excel • Customized and set-up general ledger, invoices, collections, spreadsheets, financial statements, journal entries, commission calculations, sale tax, federal tax, personal property tax, state tax, local tax, payroll tax, depreciation of asset, shareholder distributions, budgets, payroll, consulting, bank reconciliation’s, fixed asset, accounts receivable, and accounts payable.
Senior Audit Specialist – Federal Government Contractor (July 2009 –June 2011) Haynes, Inc.
: I worked for a Federal Government Contractor at the Department of Health and Human Services, Administration of Children and Families, Office of Grants Management: Federal Government (Office of Management and Budget (OMB) Circular A-133, A-21, A-110, A-122, and A-87): All duties were completed globally for grantees.
• Software: GATES, ARTMS, Microsoft Word, and Microsoft Excel • Reviewed and make recommendations according to current regulations on audits and ARRA audits sent from the grantee’s independent auditor to the Clearing House, then to the Office of Head Start in Washington, DC.
• Reviewed legal documents sent from the Office of Inspector General (OIG) and National External Audit Review (NEAR).
• Requested corrective-action plan’s (CAP) from the grantee’s audits missing CAP’s and/or supporting documentation needed concerning the audit findings.
• Reviewed grant regulations to make sure the grantees are in compliance with current Federal regulations.
• Audited all management and monetary findings for all grantees that receives $500,000 or more in Federal awards annually.
• Completed an Audit Determination Letter (ADL), Official Clearance Document (OCD), and Analysis and Conclusion documents for all audits Letter and documents display audit findings, recommendations, resolutions, and revenue analysis calculations.
Senior Accountant – Contractor (January 2008 – July 2009) Convera Technology: All duties were completed for Convera Tech in France, United Kingdom, Canada, and the United States.
• Software: Great Plains, Microsoft Word, and Microsoft Excel • Completed twelve bank reconciliations monthly, daily bank transfer journal entries, trail balances, income statements, balance sheet account reconciliations, recurring journal entries, deferral journal entries, closing journal entries, depreciation of asset spreadsheets, journal entries, amortization schedule spreadsheet, and conversion of United States currency to Euro using exchange rates.
• Adjusted financial statements according to monthly exchange rate changes, prepaid expenses, head count spreadsheets, fixed asset and pivot tables.
• Audited bi-weekly cobra reports, bi-weekly payroll reports, account receivables, and accounts payable.
Internal Control Audit Coordinator – Contractor (February 2007 – January 2008) District of Columbia Water and Sewer Authority: Monitored and coordinated audits for internal control purposes for the Finance and Budget department and completed the following duties: • Software: Lawson, Microsoft Word, and Microsoft Excel • Utilized OMB Circular A-123 • Organized, directed, and monitored audits in payroll, accounts payable, general ledger, asset management, and treasury.
• Performed payroll coordination and monitoring, which included W-4 forms, new hire Information, terminations, manual checks, and direct deposit request forms.
• Completed, accounts payable coordination and monitoring, which consist of vendor payments, purchase cards, travel cards, petty cash, and cellular phone documentation.
• Monitored the general ledger coordination involving bank reconciliations, general ledger reconciliations, computer information system uploads, journal entries, and unclaimed property outstanding checks.
• Involved in asset management coordination and monitoring which included capital asset additions, inventory, and depreciation.
• Performed treasury coordination and monitoring that involved cash and marketable securities, and reconciliation of the concentration account.
• Created monthly reports to review and analyze the testing results.
Assistant Controller – Contractor (January 2005 – February 2007) National Association of Social Workers: Completed all duties for the organization in Washington, DC and Germany.
• Software: Solomon, FRx, Microsoft Word, and Microsoft Excel • Reconciled accounts, researched account transactions, audited, managed accounts receivable, accounts payable, cash disbursements, month end close of the general fund, chapter development fund, international chapter, and the benefit fund.
• Completed monthly financial reports for the general fund, international chapter, and chapter development fund.
• Completed sales taxes, international fund bank reconciliations, chapter development fund bank reconciliations, and the benefit fund bank reconciliation.
Senior Accountant – Contractor (May 2003 –January 2005) Metropolitan Restaurant Management Company: All duties were completed for 15 Popeye Chicken restaurants.
• Software: Creative Solutions, Crystal Reports, Microsoft Word, and Microsoft Excel • Balanced and reconciled daily sales reports.
• Completed management fees, wage transfers, food transfers and bill backs between restaurants, bank statements, and sales taxes.
• Reported weekly sales to corporate.
• Calculated royalty fees payable to corporate, and advertisement fees payable to corporate.
• Audited sales reports and reconciled accounts.
• Reported net sales to real estate owners, entered payables for management fees, calculated royalty fees, and calculated advertisement fees.
• Created invoices, prepared approximately 20 bank deposits weekly, and created special spreadsheets for tracking purposes.