JOHN CROCKETT

• Managed a 30-member cross-functional team in identifying audits process areas that needed improvement.
• Researched, developed, and reviewed Engagement Feasibility Assessments (EFA's), Audit Programs and Audit plans on a variety of audit topics
• Monitored the billable hours to the engagements, managed and intervened as necessary to ensure engagement economics stay within expectations
• Developed and wrote compelling proposals and grant applications, resulting in secured funding for the organization
• Managed workloads across the project(s) to ensure equitable and level assignments of work
• Designed and developed new employee onboarding process for BDO
• Develop comprehensive GAGAS OIA Compliance Matrix requirements to guarantee accurate reporting for the VHA
• Meet regularly with each engagement team member and/or team leader to discuss progress against engagement goals and feedback
• Monitored engagement economics throughout the job and intervene as appropriate
• Assisted with scoping project and constructing fee estimate/budget
• Gained an understanding of client business to engagement to identify additional areas of work and/or cross servicing
• Educated and developed staff (associate/senior) on how to complete their section of work assignment efficiently and accurately
• Identify high risk areas and potential technical problems
• Provided structure reports, memos, and client communications (including emails) so they are clear and concise
• Monitored and routinely updated manager on engagement status and budget
• Proactively identify potential issues and research appropriate solutions to issues; discuss technical implications of complex issues with the engagement leader, engagement review partner and appropriate client personnel
• Worked with the engagement leader toward final resolution of complex issues
• Established strong relationships with clients and stakeholders, ensuring long-term partnerships and repeat business.
• Improved team performance by providing comprehensive training and fostering a collaborative work environment.
• Applied comprehensive technical knowledge of applicable accounting and auditing standards.
• Led cross-functional teams to achieve project milestones and deliver high-quality results.

• Analyze the AO’s cost-estimating methodology to compare with best practices
• Research and collect best practices in IT project cost estimation from federal government sources
• Develop a detailed cost template showing life cycle cost estimates by each phase including operations and maintenance costs at the applicable phases and identified lifecycle areas needing each program office’s attention
• Assess the accuracy and comprehensiveness of the AO’s cost estimation approach
• Obtained an understanding of the AO’s cost estimation approach/methodology
• Obtained relevant data on AO’s past cost estimates and actual expenditures
• Compared the AO’s cost estimates with the actual costs extracted from JIFMS incurred for past projects
• Analyzed the accuracy and completeness of the historical cost data from JIFMS to the invoices from PACTS 360 and Office 365
• Assessed comprehensiveness by evaluating whether the AO consider all relevant cost components
• Identify similarities, gaps, and areas for AO’s methodology enhancements to align with the best practices
• Developed an IT Project Management (ITPM) Framework gap analysis for the AO cost estimation process
• Developed a GAO-20-195G Cost Estimating and Assessment Guide into the ITPM Framework (12 steps) gap analysis for the AO cost estimation process
• Performed gap analysis on AO’s methodology by reviewing gaps noted from our interviews with stakeholders and review of the requested documentation
• Replicate the AO’s cost estimate for PACTS 360 and Office 365 and identified the missing costs and gaps in the AO’s estimates
• Gathered AO’s existing cost estimates and actual costs for PACTS 360 and Office 365
• Obtained an understanding of the methodology and assumptions used by the AO for each system
• Re-performed the AO estimate for PACTS 360 and Office 365 in the newly developed Comprehensive Cost Estimate template by using the existing cost estimate, actual cost, and assumptions provided by the AO
• Identified any cost or factors not included in the AO’s estimates.

• Conduct monthly, quarterly, and year-end quality assurance reviews to support USDT development and preparation of the consolidated financial statements and related disclosure information
• Assist in reviewing the monthly consolidated Treasury Information Executive Repository (DHSTIER) financial statements and manual Roll-forward templates for quarterly financial statements
• Develop and prepare the Internal control financial analysis and reporting systems (FARS) gap analysis including, Internal control National Institute of Standards and Technology (NIST), Department of the Treasury Departmental Offices Information Technology Security policies (DO 910) to Treasury Shared Services Enterprise Cybersecurity (TSSEC) policies
• Prepare and deliver OMB Circular FY23 Treasury A-123 Toolkit, consisting of Root Cause Analysis/ Corrective Action Plan Template, Risk and Control Matrix Template and Summary of Aggregated Deficiency (SAD) Template
• Support USDT in reviewing, monitoring, and analyzing monthly Component submissions and financial reporting deliverables
• Assist in maintaining and improving financial policy manuals in the Department
• Prepare consolidated financial statements and related disclosure information in accordance with Office of Management and Budget (OMB) Circular A-136
• Prepare documentation to address auditor inquiries
• Provide a quality assurance review of consolidated financial statements, footnotes, and supporting data
• Provide a quality assurance review of financial statements for Government.
• Provided strong leadership to enhance team productivity and morale.

• Consulted with the IPA and Army stakeholders to assist with audit facilitation administration including: Coordinated and hosted meetings
• Facilitated communication between Army and IPA personnel
• Managed multiple centralized mailboxes
• Coordinated planning for site visits/walkthroughs
• Administered Army Audit Response Tool (AART) operations
• Coordinated and submitted extension requests for audit PBC and Sample requests
• Performed quality control and quality assurance
• Advised on protocol, problem-solving, managing metrics
• Updated Standard Operating Procedures (SOPs)
• Facilitated and consolidated operations improvements from Lessons Learned and After-Action Reviews
• Advised clients on potential solutions specifically pertaining to audit operations, after identification of gaps
• Facilitated the Sensitive Activities portion of the Full Financial Audit hosted solely in the classified realm due to the sensitive information
• Reviewed existing and updated new Standard Operating Procedure (SOP) and One Pagers/Checklist to ensure daily audit readiness and response operations
• Provided direct financial management and internal control support specifically for the Real Property (RP) Balance Sheet line item
• Provided ongoing process improvement, change management, and communication support to facilitate knowledge sharing and adoption of audit compliance and sustainment concepts
• Researched and advised Army on complex accounting treatment of equipment with shared accountability across entities and recommended audit compliant reporting approach
• Provided full-spectrum audit liaison support for RP line item for the full financial statement audit, including PBC request response and management, guidance on sampling approach to IPA, sample management, and review of IPA sample/control testing results
• Facilitated walkthroughs, testing, and development of testing matrices and checklists
• Coordinated review and execution of NFRs with Business Mission Area Champions (BMACs)
• Facilitated CAP workshops
• Supported RP BMAC use of the OSD CAP Tool
• Prepared RP content for senior level briefings including Council of Cornels (CoC), RP quarterly workshops, and Monthly BMAC
• Detailed tasks included: IPA Audit Support: site visit management, PBC preparation and management, Formal Issue/NFR management, FM&C CAP execution, CAP management (AART, OSD), Issues by Site/Dashboard Management, Controls
• Project Management: Integrated Project Plan (IPP) - Existence and Completeness (E&C), IPP – Valuation, APLUS Tool, Weekly Standup Slides, Monthly Standup, BMAC
• Completeness: developed policy and procedures to establish a baseline for RP inventory balances to support the completeness assertion
• Developed an excel dashboard to easily identify the status of all items, provide the ability to run status reports, and provide extracts to Commands on current Audit Status
• Reviewed past and current NFRs to address audit findings pertaining to validating Completeness assertion for Environmental & Disposal Liabilities (E&DL) BRAC population
• Reviewed existing Business Process Management (BPM) process maps and details, Army control catalog, relevant policy documents, and SOPs to provide recommendations that help strengthen internal controls and improve audit readiness
• Reviewed historical audit samples and new documentation to for sharing with auditors to identify gaps and advise clients on potential solutions to close gaps or alleviate audit impediments
• Edited and amended the Army PPE EXORD for EDL, a formal directive tasking Army agencies and staff with EDL specific actions to support the auditability of Cost-to-Complete (CTC) packages
• Participated in audit walkthroughs to gain insight into the auditor’s concerns and methods to ensure designed solutions met the auditor’s intent
• Hosted weekly status meetings to review current and upcoming sprint activities and facilitated stakeholder meetings to gather consensus on process or control updates with Army leadership
• Facilitated and consolidated operational improvements based on studies and analyses of existing data, supporting documentation, applicable regulatory guidance, Lessons Learned, and After-Action Reviews
• Submitted high-visibility metrics for the monthly Army Leadership briefs
• (E&DL) BRAC population.

• Consulted with the FORSCOM and Army Corps to assist with audit facilitation administration including, but not limited to: Coordinated and hosted meetings
• Facilitated communication between Army Directorate (G1, G4 & G8) personnel and the Corp
• Coordinated planning for site visits/walkthroughs and other travel
• Administered Army Audit Response Tool (AART) operations
• Coordinated and updated Standard Operating Procedures (SOPs)
• Developed and delivered the FY22 PBC and sample Measurement Statical Analysis (MSA) reporting workbook which automatically produces agile scorecards
• Managed Operation and Maintenance (O&M) of AART to support timely Army financial audit submissions
• Provided day-to-day AART support by troubleshooting user issues and providing training
• Developed FORSCOM Travel SOP and updated the requirements and document
• Developed and delivered the Internal PBC and Sample Internal Tracker reporting workbook
• Developed and delivered Site Visit and Walkthrough Tracker
• Developed and delivered CLT weekly metrics to measure audit activity which helped management and directorates make informed decisions related to resource allocation and training
• Coordinated FORSCOM onboarding activities
• Developed CLT Daily Task Tracker (roles and responsibilities, expectations, key performance indicators (KPI’s)
• Drafted and submitted the CLT Daily Update to PM and Deputy PM
• To support work stream efforts, provided continuous e-mail, phone calls, and MS Teams sessions with CST, FM&C, the field and other required POCs
• Developed and presented CLT Operational briefing deck walkthrough and work session
• Leveraged metadata extracted from AART to provide FORSCOM leadership with a snapshot of the current audit state based on work volume, and timeliness
• Developed high-visibility metrics for the monthly FORSCOM Leadership briefs
• Provided ongoing process improvement, change management, and communication support to facilitate knowledge sharing and adoption of audit compliance and sustainment concepts
• Researched and advised FORSCOM Army Directorate (G1, G4 & G8) on complex Audit procedures shared accountability across entities and recommended audit compliant reporting approach
• Provided full-spectrum audit liaison support for FORSCOM for the full financial statement audit, including PBC request response and management, guidance on sampling approach to IPA, sample management, and review of IPA sample/control testing results
• Provided guidance to FORSCOM Army Directorate (G1, G4 & G8) in walkthroughs, testing, and development of internal testing matrices and checklists
• Provided weekly Developed Corps Liaison Team CLT Auditability briefings to the Internal Review (IR) Director
• Assisted with the development of the FORSCOM dashboard to easily identify the status of all items and provide the ability to run status reports and extracts to FORSCOM Army Directorates (G1, G4 & G8) on current Audit Status.

In July 2020, BDO Public Sector, LLC acquired MorganFranklin Consulting, LLC’s Public Sector practice.

• Consulted with the IPA and Army stakeholders to assist with audit facilitation administration including: Coordinated and hosted meetings
• Facilitated communication between Army and IPA personnel
• Managed multiple centralized mailboxes
• Coordinated planning for site visits/walkthroughs
• Administrated Army Audit Response Tool (AART) operations
• Coordinated and submitted extension requests for audit PBC and Sample requests
• Performed quality control and quality assurance
• Advised on protocol, problem-solving, managing metrics
• Updated Standard Operating Procedures (SOPs)
• Facilitated and consolidated operations improvements from Lessons Learned and After-Action Reviews
• Advised clients on potential solutions specifically pertaining to audit operations, after identification of gaps
• Facilitated the Sensitive Activities portion of the Full Financial Audit hosted solely in the classified realm due to the sensitive information
• Reviewed existing and updated new Standard Operating Procedure (SOP) and One Pagers/Checklist to ensure daily audit readiness and response operations.

• Served on a three-part engagement for the Department of Defense (DoD) Office of Inspector General (OIG), a financial statement audit of the MERHCF, financial statement audit of CRM, and financial statement audit of MRF
• Executed planning, internal control, and substantive testing procedures for all cycles
• Led and documented walkthrough meetings conducted with MERHCF, CRM, and MRF personnel
• Worked with Accounts Payable, Expenses, Budgetary Resources, Accounts Receivable, and Fund Balance with Treasury
• Performed reconciliations, fluctuation analyses, attribute testing, and tracing and agreeing financial statements
• Performed control testing for the Triangle Reconciliation used to identify the Actuarial Liability and Incurred but Not Reported (IBNR) line items on the financial statements
• Designed and performed the expense testing for MERHCF and CRM
• Designed a new testing approach to gain efficiencies for the Benefit Payment line item which is the largest balance on the MRF Financial Statements
• Tested systems that include Oracle, Trust Fund Reporting System, and Defense Departmental Reporting System – Budgetary and Audited Financial System
• Collaborated closely with the actuarial subcontractor on the project regarding if Actuarial Liability and IBNR line items were determined correctly
• Prepared control testing and analytical procedures that were implemented to determine if the Quarterly Distribution Plan was created and that there were no material errors in the calculations used to develop the Plan
• Designed testing for the Budgetary Resources and Accounts Payable cycles
• Reviewed workpapers completed by the staff and retrieving PBC requests
• Conducted meetings with the client and financial management committee and was one of the client’s primary contacts.

• Conducted monthly, quarterly, and year-end quality assurance reviews to support the development and preparation of the consolidated financial statements and related disclosure information
• Assisted in reviewing the monthly consolidated DHS Treasury Information Executive Repository (DHSTIER) financial statements and manual Roll-forward templates for quarterly financial statements
• Supported in reviewing, monitoring, and analyzing monthly Component submissions and financial reporting deliverables
• Assisted in developing and implementing processes to review the completeness and sufficiency of Component-furnished financial data, including supporting documentation associated with abnormal balances, United States Standard General Ledger (USSGL) analytics, Fund Balance with Treasury (FBWT), and suspense accounts of Component trial balances, as well as elimination entries and adjustments at the consolidated financial statement level
• Assisted in maintaining and improving financial policy manuals in the Department
• Prepared consolidated financial statements and related disclosure information in accordance with Office of Management and Budget (OMB) Circular A-136
• Prepared documentation to address auditor inquiries
• Provided a quality assurance review of consolidated financial statements, footnotes, and supporting data
• Provided a quality assurance review of on-top journal vouchers (JV)
• Provided a quality assurance review of financial statements for Government Financial Reporting System (GFRS) financial statements and footnotes
• Designed and implemented tools to facilitate preparation of the consolidated financial statements and GFRS financial statements
• Performed a gap analysis of OMB Circular A-136, and Federal Accounting and Standards Advisory Board (FASAB) Standards
• Assisted DHS, its components, and Federal trading partners, in resolution within Government material differences in Department of Treasury (DOT) reporting
• Provided a quality assurance review of Legal Liabilities claims for compliance with DHS requirements and inclusion in the Annual Financial Report (AFR)
• Worked to resolve DHS Component differences and verify that Component financial information was reflective of the Component’s operations
• Developed a process for FM to identify and resolve accounting and audit issues
• Assisted DHS and DHS Components in preparation for Government-wide Treasury Account Symbol (GTAS) reporting, including reviewing requirements, identifying solutions for overcoming obstacles to meet those requirements, and assisting in solving errors.

• Engagement required the use of both the Budgetary Estimates and Like-Kind asset valuation methodologies according to Statement of Federal Financial Accounting Standards (SFFAS) thirty-five, Estimating the Historical Cost of General Property, Plant, and Equipment
• Researched individual assets within various legacy asset classes pertaining to either the booked improvement costs or the historical acquisition cost
• Valuation estimates were calculated and presented to the USCG based on the allocation of appropriations, construction and acquisition, and overhead costs
• Valuations supported budgetary reconciliations, dating back 70 years
• Collaborated with the USCG Valuation and Validation department to secure approval of all personal property asset packages within the scope of the engagement.

• Managed drafting, understanding phase documentation in the personal property, real property, and leased revenue cycles
• Specifically, involved in conducting walkthroughs, performing tests of internal controls, executing site visits, and conducting substantive testing
• Assessed internal control effectiveness and appropriate financial reporting over the personal property, real property, and leased revenue cycles
• Developed revisions to the audit plan due to changes in the control environment and mid-year system conversion
• Assisted with walkthroughs, internal control testing, and substantive testing audit cycles: Fund Balance with Treasury (FBWT), accounts receivable/revenue, accounts payable and other expenses, payroll/sensitive payments, financial reporting, and internal use software
• Reviewed Financial Statements, Notes, and Management Discussion Analysis, per A-136 compliance
• Created Microsoft excel spreadsheets to track audit team’s travel budget
• Created a pivot table and spreadsheet to analyze and test value(s) of real and personal property
• Created financial statement Tie-point metrics to analyze financial statements from current and previous year(s)
• Provided strategic advice and consulting services to the Internal Control Program Management Office (ICPMO) as they strived to obtain an opinion on their balance sheet
• Developed the DHS methodology for IPIA compliance, which was rolled out to all components
• Assisted in training components on this methodology.

• Served as a cost accountant that reported and reconciled financials for four diverse lines of business while specifying and comparing factors affecting prices and profitability
• Developed macros that enhanced productivity in monthly closing process
• Orchestrated and presented monthly, quarterly, and annual financials to senior-level management for multiple business lines
• Mitigated recurring losses by initiating effective third-party leasing and billing procedures
• Performed annual audits and cycle counts on multiple lines of business
• Analyzed financial information to produce forecasts of business, industry, and economic conditions
• Performed an Internal Audit Risk Assessment and developed the Internal Audit Plan
• Performed Accounts Receivable Audit.

• Led Internal Audit projects, including planning, executing, and reporting
• Audits included operational, financial, regulatory, and information systems elements
• Audits and projects performed included Internal Audit Risk Assessment, Mortgage Quality Control, Item Processing, ACH Processing, Wire Transfer Operations, Consumer Loan Collections, Home Equity Securitizations, Home Equity Servicing, Credit Card Collections, Secondary Marketing, Branch Audits, and Treasury Operations.
• Supervised operations staff and kept employees compliant with company policies and procedures.