Jeff McDowell
Senior Consultant at Sage Consulting Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Data Visualization: Storytelling
LinkedInNov, 2018- Oct, 2024 -
Excel 2016: Advanced Formulas and Functions
LinkedInNov, 2018- Oct, 2024 -
Excel 2016: Business Process Analysis
LinkedInNov, 2018- Oct, 2024 -
Excel Data Analysis: Forecasting
LinkedInNov, 2018- Oct, 2024 -
Machine Learning and AI Foundations: Classification Modeling
LinkedInNov, 2018- Oct, 2024 -
Excel 2016: Introduction to Formulas and Functions
LinkedInOct, 2018- Oct, 2024 -
Excel: Statistical Process Control
LinkedInOct, 2018- Oct, 2024 -
Excel: Tracking Data Easily and Efficiently
LinkedInOct, 2018- Oct, 2024
Experience
-
Sage Consulting Group
-
United States
-
Business Skills Training
-
Senior Consultant
-
May 2019 - Present
Project: Department of Defense Office of the Inspector General (DoD OIG) Financial Reporting Provide subject matter expertise to OIG in all aspects of financial reporting. Support the agency in responding to prepared by client lists (PBCs) and notices of findings and recommendations (NFRs), and developing corrective action plans (CAPs). Provide technical expertise in inception year reporting of capital assets for existence, completeness, and valuation, on the Balance Sheet. Research USSGL guidance and provide analyses of DAI general ledger trial balances and financial statements and review posting logic and tie point variances. • Conducted extensive research into applicable DoD and federal accounting and reporting regulations on reporting of Property, Plant, and Equipment (PP&E) assets. • Met with OIG components to ascertain availability of asset information and reviewed reports from DPAS, the agency’s accountable property system of record (APSR), and DAI acquisition reports to determine the degree to which the agency purchases property items that qualify for capitalization. • Developed analytics and decision documents and presented to OIG management on various aspects of asset capitalization including useful life requirements, bulk purchase reporting criteria, capitalization threshold options, and options for inception year reporting on the financial statements. • Developed a comprehensive white paper to a) summarize the requirements for capital asset reporting for the sub-categories of PP&E applicable to DoD OIG: General Equipment, Internal Use Software, and Leasehold Improvements b) document decisions made by DoD OIG management with regard to asset reporting, and c) outline the planned approach to compiling an initial capital assets inventory and reporting in DAI and financial statements, including a discussion of the applicable general ledger accounts for assets, depreciation, and construction in progress. Show less
-
-
-
-
Senior Analyst
-
Sep 2016 - Nov 2018
Project: Washington Headquarters Services (WHS) Audit Readiness Provide technical subject matter expertise and support to WHS for audit readiness assertions and subsequent examinations of their financial statements and related schedules, while complying with OSD (Comptroller) Financial Improvement and Audit Readiness (FIAR) Guidance and associated regulations to include OMB, Treasury, GAO, FMR, GAAP, etc. • As team lead for the Budget to Report (B2R) end to end business segment, perform multiple tasks related to ongoing readiness efforts for Appropriations Received/Funds Distribution, Financial Reporting, and Fund Balance with Treasury (FBwT). • Develop assertion documentation based on WHS’s ERP system (Defense Agencies Initiative (DAI) to include business process narratives, flows, risk analyses, Financial Reporting Objective (FRO) matrices, and others. • Perform analyses and reconciliations of DAI general ledger trial balances to Defense Departmental Reporting System (DDRS) financial statements, footnotes, and schedules. • Develop Corrective Action Plans (CAPs) to remediate examination Notices of Finding and Recommendation (NFRs) and to correct control deficiencies discovered during internal reviews and testing. • Work with Agency personnel to develop policies and procedures to mitigate audit risks and internal control deficiencies. • Prepare analyses, schedules, and briefing documents to respond to FIAR data calls. • Respond to Prepared by Client (PBC) requests from the ongoing FY 2018 DoD Inspector General (DoDIG) examination. Show less
-
-
-
TeraThink Corporation
-
United States
-
Information Technology & Services
-
1 - 100 Employee
-
Principal Consultant
-
Dec 2013 - Aug 2016
Project: Washington Headquarters Services (WHS) Audit Readiness Provide technical subject matter expertise and support to WHS for audit readiness assertions and subsequent examinations of their financial statements and related schedules, while complying with OSD (Comptroller) Financial Improvement and Audit Readiness (FIAR) Guidance and associated regulations to include OMB, Treasury, GAO, FMR, GAAP, etc. • As team lead for the Budget to Report (B2R) end to end business segment, perform multiple tasks related to ongoing readiness efforts for Appropriations Received/Funds Distribution, Financial Reporting, and Fund Balance with Treasury (FBwT). • Develop assertion documentation based on WHS’s ERP system (Defense Agencies Initiative (DAI) to include business process narratives, flows, risk analyses, Financial Reporting Objective (FRO) matrices, and others. • Perform analyses and reconciliations of DAI general ledger trial balances to Defense Departmental Reporting System (DDRS) financial statements, footnotes, and schedules. • Develop Corrective Action Plans (CAPs) to remediate examination Notices of Finding and Recommendation (NFRs) and to correct control deficiencies discovered during internal reviews and testing. • Work with Agency personnel to develop policies and procedures to mitigate audit risks and internal control deficiencies. • Prepare analyses, schedules, and briefing documents to respond to FIAR data calls. • Respond to Prepared by Client (PBC) requests from the ongoing FY 2018 DoD Inspector General (DoDIG) examination. Show less
-
-
-
Grant Thornton LLP
-
Canada
-
Accounting
-
1 - 100 Employee
-
Manager
-
May 2011 - Dec 2013
Project: WHS ICOFR and Audit Readiness Developed an internal control over financial reporting (ICOFR) program and audit readiness assertion documentation for WHS Appropriations Received and the Statement of Budgetary Resources (SBR), to comply with OMB Circular A-123 and Department of Defense (DoD) Financial Improvement and Audit Readiness (FIAR) guidance. • Performed materiality and statement to process analyses, and quantitative/qualitative drilldowns for SBR line items. • Evaluated, analyzed, and reconciled extensive general ledger transaction and trial balance data produced by legacy (Washington Headquarters Services Accounting and Allotment System – WAAS) and primary (Enterprise Budget Accounting System – Defense (EBAS-D)) financial systems. • Performed comprehensive analyses of WHS Appropriations and allocation/sub-allocation processes, used as basis for redefinition/re-scoping of WHS funds management and financial reporting responsibility for audit readiness, from over $16 billion to under $3 billion. • Documented end to end business processes – including Order to Cash (Reimbursable Work Orders) and Budget to Report, identify key controls by interviewing business process owners and other cognizant Agency personnel • Prepared process cycle memorandums, flowcharts and risk assessments that met the requirements of GAO’s Financial Audit Manual (FAM), DoD’s Financial Management Regulation (FMR), and FIAR guidance. • Prepared control testing plans, selected statistical samples, and tested key controls over financial reporting for assessable units. Documented testing results including Notices of Findings and Recommendations (NFRs) for control deficiencies. • Developed Corrective Action Plans (CAPs) for control deficiencies and worked with Agency management to implement improvements to control environment. Show less
-
-
-
Kforce Government Solutions, Inc. (KGS)
-
United States
-
Government Relations Services
-
1 - 100 Employee
-
Senior Financial Manager
-
Oct 2010 - Apr 2011
Project: United States Coast Guard, Washington, D.C. (October 2010 – April 2011) Supported the Coast Guard in their efforts to develop a baseline of Real Property assets for financial statement reporting purposes. Specifically, designing a methodology for identifying, tagging, and tracking Real Property assets – including buildings, land, and structures – and valuing those assets using historical cost records or estimating using similar facilities data, engineering cost estimates, or deflated plant replacement value.• Researched and analyzed alternatives adopted by industry and government organizations for cost effective solutions to establish the existence and completeness of real property assets, through innovative marking, identification and tracking best practices. • Provided recommendations for an enterprise wide marking tool that included estimated start-up cost, estimated maintenance cost, personnel needs, IT requirements and maintenance equipment. • Reviewed USCG property and procedures, conducted stakeholder reviews with real property program managers to develop USCG real property marking, identification, and tracking requirements. • Conducted site visits to test proposed marking and tagging systems.• Developed an implementation guide that incorporates the design, training, and other needs as identified.• Created, developed and produced (via vendor) 2000 weather resistant real property tags and provide Coast Guard with the ability to reproduce tags going forward.• Provided a detailed weekly progress report, addressing earned value of completed work, risk assessment to current task, and notification of work on the critical path. Show less
-
-
Senior Financial Manager
-
Sep 2009 - Sep 2010
Project: United States Marine Corps, Alexandria, VA (9/2009 – 9/2010)Supported Marine Corps Headquarters during first external audit of the Statement of Budgetary Resources (SBR) in audit assessment and coordination, and financial and analytical support. • Worked with USMC client and auditors to obtain, review and provide quality assurance for source documents required in response to auditor requests. • Performed research and produced topic papers on financial management issues concerning areas of audit focus, e.g. Undelivered Orders (UDOs), Unliquidated Commitments/Obligations (ULOs), accounts payable accruals, and progress payments. • Performed detailed analyses of USMC Fund Balance with Treasury (FBWT) reconciliations for funding years 2003 – 2010 for each USMC standalone and shared appropriation (approximately seventy (70) individual FBWT reconciliations per fiscal quarter). • Performed detailed transaction level reconciliations between Defense Cash Accountability System (DCAS) and USMC Standard Accounting, Budgeting, and Reporting System (SABRS). • Analyzed USMC general ledger account structure against the United States Standard General Ledger (USSGL) to ascertain impact and crosswalk to the SBR and other financial statements such as Balance Sheet. Show less
-
-
Senior Financial Manager
-
Aug 2007 - Aug 2009
Project: Architect of the Capitol (8/2007 to 8/2009)Served as a Senior Financial Manager on the Architect of the Capitol (AOC) cost accounting and general accounting projects. • For cost accounting, worked with Agency cost accounting and other personnel to develop a cost accounting system to: a) comply with federal managerial cost accounting standards and b) collect cost information necessary to accomplish objectives associated with strategic planning, decision making, control, and reporting full program costs. • Assisted AOC in determining sources of cost accounting data, designing methodologies and reviewing information systems and database tools for collection and accumulation of cost data, and analyzing and reporting on accumulated cost accounting data (Momentum Financials, Hyperion, Excel). • For general accounting, prepared quarterly and year-end financial statements using Department of Treasury and OMB guidelines, including Balance Sheet and Statements of Net Cost, Net Position, Budgetary Resources, and Financing.• Generated and presented numerous monthly accounting operations reports, including accounts payable, accounts receivable, inventory, investments, interagency payments and collections, FBWT, Undelivered Orders (UDOs), ULOs and others.• Performed reconciliations supporting the monthly Treasury Statement of Transactions (SF-224) including payroll abstract with National Finance Center, FBWT, interagency payments and collections (IPAC), and employee receivables. Show less
-
-
-
E*TRADE
-
United Kingdom
-
Wholesale
-
1 - 100 Employee
-
Lead Internal Auditor
-
Mar 2006 - Mar 2007
Performed audits of E*TRADE Financial component businesses to include Bank, Corporate, and Brokerage operations. • Designed, conducted, and managed audits to evaluate business operations in accordance with applicable laws, regulations, policies and procedures. • Performed risk analyses and business process evaluations including data and information flows. • Produced audit reports to summarize work performed and communicated key findings and recommendations to senior management. • Audited areas included E*TRADE Bank deposit operations, Global Asset Management, corporate aircraft, E*TRADE Brokerage compliance, surveillance, and stock loan. Show less
-
-
Lead Business Analyst
-
Nov 2004 - Mar 2006
Integrally involved in E*TRADE’s first and second year (2004 and 2005) Sarbanes-Oxley (SOX) 404 compliance efforts, including full scale testing in 2004 and bottom-up rework of all 2004 SOX processes in 2005. Business areas included, but were not limited to: deposit operations, global asset management, loan accounting, investment accounting, deposits accounting, general accounting, derivatives, hedging, treasury, credit administration, and mortgage loan pricing and sales. • Worked with business owners to identify and document internal controls over business processes critical to financial statement reporting and Sarbanes-Oxley compliance, and recommended enhancements and additional procedures to strengthen internal control structure,• Prepared control/risk matrices and data flow diagrams to document business processes and associated controls,• Designed testing methodologies and templates used to test internal control operating effectiveness,• Performed testing, documenting results and working with management to remediate gaps,• Monitored and managed testing progress via compliance software system (Certus), and reported results on an ongoing basis. Show less
-
-
-
East Coast Migrant Head Start Project
-
Education Administration Programs
-
200 - 300 Employee
-
Grants Analyst
-
Dec 2001 - Nov 2004
Oversaw eight (8) Head Start agencies, with combined funding of approx. $26 million. • Designed audit programs, procedures, and analysis tools for reviews of agencies’ financial operations to ensure compliance with applicable regulations and standards, e.g., OMB, Code of Federal Regulations (CFR), and Department of Health and Human Services (DHHS) Head Start Standards, • Performed on-site financial reviews of agency operations, interviewing cognizant personnel, performing extensive audit procedures and analyses, documenting all procedures performed, and preparing audit reports for internal and external audiences, • Provided training and technical assistance on all facets of agency financial and programmatic functions to include budget preparation and performance, • Monthly analysis of agency financial reports, general ledger reconciliations, and processing of expenditure reimbursements. Show less
-
-
-
US Government Accountability Office
-
United States
-
Government Administration
-
700 & Above Employee
-
Senior Evaluator
-
Jul 1989 - Sep 2000
Project: U.S. Armed Forces Military Readiness Database • Designed, maintained, and updated classified ‘secret’ Access database containing military readiness data from fiscal year 1990 onward, for appx. 10,000 reporting entities (military units) from the four military services, • Managed multiple concurrent projects requiring comprehensive database analysis using advanced Access and Excel tools, e.g. macros, modules, queries, • Designed reports and graphical and spreadsheet analyses portraying military readiness information to congressional committee staff to assist them in making decisions concerning allocation of resources and determining the Armed Forces’ level of preparedness to perform their wartime missions. Project: CFO Act: U.S. Army and Navy Stewardship Reports • Interviewed Army and Navy officials to determine original sources of information relating to military assets, identifying systems and processes used to collect and report asset information, • Prepared data flow diagrams to depict the myriad interrelationships and flows of data among responsible activities and systems, such as asset managers, inventory management systems staff, and financial reporting officials, • Used statistical sampling methods to select detailed asset-related transactions for subsequent verification, • Designed extensive schedules and spreadsheets to assist in analyzing and testing transactions. Other GAO projects included aircraft programs in the Air Force, Marines, Navy and Army, recruit basic training in all military services, ammunition and supply stockpiling requirements, and NASA’s Space Station program. Show less
-
-
Education
-
Old Dominion University
Bachelor's degree, Business Administration and Management, General
Community
