Patrick Sutherland Email & Phone Number

Fort Worth, Texas, United States

• Daily management of all cash assets and logging for C-level executives.• Budget reporting on the facility level, utilizing graphs and formatting to showcase trends.• Prepared financial statements quarterly and curated submissions for government projects.• Performed month end close at corporate level for multiple companies and assets. • Assisted with year-end audit to ensure accuracy and efficiency.• Managed company payroll and payroll based Journal for all locations

Grapevine, Texas

• Directly responsible for all financial items, including general ledger auditing and project reporting.• Advised changes to back end and SQL functionality for company resources.• Created master invoices and SAAS using multiple large data sets for all platform consumers.• Collaborated in data clean up with development team utilizing SQL and excel to insure uniform formatting and validity. • Managed payables and receivables for entire company using self-made resources.

Irving, Texas, United States

• Created reports with a map interface for all (275+) Locations as well as 40 open markets to deem if they were fit for expansion• Reports were created by importing data with a third party resource for potential customers in a given market. • This would be cross referenced against the Master Customer resource in Excel to remove duplicates between potential and current customers. • Once refined a digital map was created by stacking Potential Customers, Current Customers, Competitors and Current locations. • All maps would be formatted to spec with custom identifiers for all 4 data points. • Expedited this function by creating data templets in Excel with a macro to format the data and apply a formula to all lines to calculate potential spend• Assisted in data clean up on employee resources. Using Excel functions to create logic with If statements, concentrates and VLOOKUPs. Identified duplicate entries with different aliases, and the correct employment status for each

• Served in a business analyst role in corporate transfer to SAP from legacy JDE system. • Represented the Accounting and Accounts groups on all ad hoc project teams.• Responsible for entire southern region reporting and ledger management on a weekly basis. • Collaborated with IT to resolve any pain point issues or errors due to back end implementations. Introduced improvements and programs for other teams• Removed redundancy in staff data entries by introducing SharePoint and smart spreadsheet support. • Create custom Excel sheets to improve efficiency/automate of day to day tasks. • Data manipulation for company mileage reimbursement. Also, conversion of utility billings from the bill consolidation site. Converted measure units to system standard and applied cost codes for ledger posting in JDE• Extensive data cleansing and analysis, using pivot tables, formulas (VLOOKUP and others), data validation, conditional formatting, and graph and chart manipulation. Created custom monthly reports • Use Excel pivot tables to manipulate data in order to perform data analysis. Showed accrual trends and operational efforts on clearing debt on unpaid invoices• Use a variety of systems to deliver results for stakeholders• Collaborate with all teams to ensure proper accounting codes are used • Worked with SharePoint and MyHelpdesk for ticketing/support

• Scanned and processed all invoices• Oversaw utilities management• Processed employee reimbursements in a timely manner• Maintained client confidentiality

• Maintained landowner relations and lease upkeep• Built relationships by communicating with owners, suppliers and labor crews• Reported performance and daily output of multiple sites• Responsible for 24-hour management of new on-site projects

Education record

Accounting