Dylan Deeds, Cpa Email & Phone Number

Warren, New Jersey, Us

Oklahoma City, Oklahoma, Us

● Built a powerful year-over-year sales and orders analytics tool (Power BI report) that isheavily utilized by both the commercial sales team and finance.● Produced financial reporting and slides for monthly departmental, executive, and boardreviews. Reporting generally included Plan vs. Actuals vs. Prior Year among other KPIs.● Served as a cross functional resource for financial analysis and budgeting activities,primarily working with the commercial sales and supply chain departments.● Leveraged in-depth knowledge of the company’s data warehouse and data structure to gaininsights and develop Power BI reporting.● Generated price/volume/mix analysis.● Utilized the Hyperion FCCS Excel Add-In for creating excel files that pull live data fromthe financial system of record.● Supported cost accounting processes - responsible for maintaining accurate standard costsfor purchased goods and forecasting the standard margin impact when costs are changed.

Norman, Oklahoma, Us

•Responsible for detailed cash forecasting, performing daily borrowing on LOC, driving timely billings, and approving payments to subcontractors.• Analyze job and business unit financial performance to identify trends and driveorganizational change. • Created a Power BI model that connects directly to the Company's accounting SQL server database to visualize data and create custom reports.• Senior leadership member• Automated billing processes using excel-based unit trackers and a formula driveninvoicing template.• Greatly accelerated the collection of retainage receivables through proactive reportingand streamlining invoicing procedures.

Norman, Oklahoma, Us

• Direct report to the CFO. Cross-functional role focused on partnering with Companyoperations to meet financial goals, drive accurate reporting, and ensure compliance.• Created a complex 3-statement financial projection model in excel from scratch. • Co-led the implementation of a full-service fleet management software• Responsible for fixed asset accounting and assessing buy vs. lease vs rent options for equipment acquisitions• Insurance Manager - Produced insurance renewal documentation, provided guidance to management regarding coverages, worked with broker to ensure insurance-related contractual requirements are met, filed and monitoring claims, etc.• Sales Tax Manager - Interpret multi-faceted sales tax rules to determine when exemptionsdo or do not apply for jobs in multiple states. Filing of monthly sales tax returns.• Ad hoc financial analysis and projects.

Chicago, Il, Us

• Perform financial audit testing for clients in a variety of industries includingmanufacturing, financial services, professional services, and telecommunications.• Exhibit excellent project management skills: request documentation from clients, stick totimelines agreed to by the audit team, escalate issues when necessary, etc.• Technology driven audit approaches - Pulling and manipulating data from varioussystems, converting pdfs to excel format, performing v-lookups and calculations.• Lead testing over key areas such as revenues, operating expenses, fixed assets, etc.

Worldwide, Oo

• Performed quarterly review and interim audit work on a large investment bank• Worked on substantive analytics for both IS and BS items and investigated trends• Exposed to a repurchase agreement transaction and documented key terms via memos.

Chicago, Il, Us

• Contributed to the year-end audit process of a publicly traded REIT and other FS clients• Completed various testing and gained knowledge of the client's operations• Identified an account reclassification and requested corroboration from the client

Houston, Texas, Us

Treasury Services - Commercial Card Auditing Services Intern • Audited the Phillips 66 Commercial Card Account• Recommended changes for expense recognition process• Became proficient in SAP, Excel, and ACL• Presented to management on crude oil supply & trading processes

London, Gb

• Performed assurance case study & leadership activities

• Created and updated Excel spreadsheets for monthly production reports• Performed various data entry and filing including ownership and insurance updates• Sorted and mailed monthly billing to clients

Master'S Of Accounting

B.S.B.A, Accounting And Finance