Post Job Free

Resume

Sign in

Data Analysis Advanced Support

Location:
Sarasota, FL
Posted:
December 04, 2023

Contact this candidate

Resume:

Summary

Julie Gerharz

Contact 614-***-**** -ad1oo8@r.postjobfree.com St Petersburg, FL

Education B.S. Accounting Franklin University – Columbus, OH

-Over 6-years’ experience professional accounting experience (reporting, budgeting, forecasting, tax, data analysis, SOPs, JEs, accruals, invoicing, payments, AR, AP, P&L, unbilled, EE reimbursements, and payroll)

-Performed banking (ACHs, wires, positive pays) - release of payments, applying cash payments (team lead of 12, monitoring client POs to bill appropriately as well as requesting POs for exhausted funds, as well as creating vendor POs.

-Project KPIs weekly monitoring, revenue contract modeling, budgeting, reporting, project setup, and advanced PM support for any and all project concerns – historical project profitability, unbilled units, schedule impediments, change order, and more.

-Account reconciliation, payroll garnishment submissions, 40lk submissions, vendor management, CO requests and management, project setups, fee structure, pricing terms and contract amendments. Advanced support role, providing reporting to senior upper management.

Software:

MS Office – Excel Pivot Tables, vlookups, IF statements Sharepoint

Oracle SAP

Ariba HR Pyramid

Deltek Costpoint SQL -

GoogleDocs

Sage

Primary Contracts:

Senior AR Lead Analyst (Contract) Sanofi Chattanooga, TN 08/2022-Present

Deliver receivables management and incoming payments

Perform clearing of AR, analyze discrepancies, execute securitization program and factoring

Review AR ageing reports, perform collection & dunning, escalate & follow-up actions

Address operational issues and follow through to resolution in an effective and timely manner

Deliver operational KPIs and comply with Sanofi policies and guideline

Accountable for monthly balance sheet reconciliations.

Responsible for clearings. Perform analytic assessments, aging, and other outstanding discrepancies

Work cross-functionally and liaison with Controlling, Procurement, Procurement Operations Shared Service, Accounts Payable and Business Owners

Develop and perform relevant training for Finance, Purchasing, Procurement Operations shared services, and Business.

Act as a liaison contact for internal and external auditors.

Performs all related compliance controls.

Project Accountant (Contract) HDR Engineering Tampa, FL 11/2021-02/2022

Create accurate client invoices in compliance with contract terms, revenue models – etc (POC, fixed plus, lump sum), accounting schedules

Project setup and monitoring of project budgets up to 100 million and life cycles reaching 10 years

Establish project budgets and funding based on information included in contract documents provided by Project Managers

Work with project personnel to provide timely project performance updates as well as research and resolve financial issues

Ensure project accounting files reconcile with contract documentation and follow internal standards

Collaborate with Project Managers to document collection activities and resolve outstanding A/R issues

Process executed sub-consultant agreements into internal purchase orders

Review and process sub-consultant invoicing against approved budgets

Project closeout – finalizing budget, actual revenue obtained, final reporting, and closed for billables.

Project Accountant (Contract) A-C-T Environmental Bartow, FL 2/2021-9/2021

Review revenue contracts submitted by PMs in accordance to accounting procedures and internal controls

Project set-up, maintenance, track changes, and close-out, proposal research, analysis, reporting, monthly billing, and reconciliations. Worked with PMs and Project Accounting Team weekly reporting review for KPIs, pipeline, practice profitability, revenues to validate earnings, and if there are distressed projects, or project obstacles and issues.

Investigate variances between actual and budgets. Ensured billing of all contract terms and labor charges are managed in relationship with the project rate table. Maintained billing documentation. Implemented Change Orders/Amendments to project budget

Tracked and elevated aged receivables. Knowledge of Client Portals for payment submission and accuracy. Correct set up and maintenance of key system fields, including but not limited to - Rate Tables, Revenue methods, Compensation, Breakdown of subcontractors and expenses

Worked with PMs to flag receivables (billed and unbilled) that are outside of standard metrics for the project. Managed revenue and receivable adjustment process for billed and unbilled receivables. Worked with project team to keep all project fields in Vision updated/validated throughout project life cycle.

Project Accountant MAS Environmental Tampa, FL 3/2020 - 7/2020

●Created/setup new projects, pricing terms and payment agreement, contract amendments – change orders, Sub Contractor PO's

●Maintained project documents on network shared drive - signed contracts, invoices, YTD billing report, COIs, field notes and equipment log

●Entered project materials and reimbursements. Set up new projects, made transfers of employee billable hours/expenses, and opened/closed time. Prepared final invoice package containing draft and final invoices for all billable projects, including proper contract documentation for accounts receivable retention.

●Maintained expenses, consultant invoices, and monthly invoices, in accordance with standard procedures

Vendor Management Analyst (Contract) Bristol Myer Squibb Tampa. FL 7/2019 - 10/2019

●Maintained global vendor tacking, updated payment matrix with new payments, determined frequency, and if managed under budgeted PO.

●Notified authorized approver when invoices were received. Helped with operations process streamlining and accuracy of reporting

●Requested POs for budgeted expenses relating to HR benefits and contingent contractors.

●Amended PO master dates, currency, payment approval authorizers, requisition dockets, and any/all supporting documentation

AP Manager/Staff Accountant, Got-Rack Tampa, FL. 1/2019 - 6/2019

●Maintained daily KPI reporting to upper management - reviewing banking activity, AR, AP.

●COGs, material not invoiced.

●Created Sales orders, administered POs, made sure they were properly classed, project related - for P&L reporting, and/or acquisition material

●General accounts payable, release of payments, applying cash payments, review of outstanding POs, and review of project managers reporting against vendor invoices

Project Accountant Adurra King Engineering, Palmetto, FL. 8/2018 - 12/2018

●Maintained monthly operating reports - unbilled/WIP, and aged AR, and forecasted revenue, weekly reporting to upper project and accounting management

●Created/setup new projects, pricing terms and payment agreement, contract amendments – change orders, Sub Contractor PO's

●Maintained project documents network shared drive signed contracts, invoices, YTD billing report, and COls

●Coded and submitted subcontractor and material invoices to AP for payment processing

●Prepared final invoice package containing draft and final invoices for all billable projects, including proper contract documentation for accounts receivable retention

●Researched WIP issues to optimize the billing possibilities for the billing period. Worked with the cash receipts team member to reconcile variances that occur in the application of cash

Staff Accountant (Contract) Corban One Source St. Petersburg, FL 7/2017 - 8/2018

●Processed ACH/wires for client payment and their employee payroll Prepared/processed/transmitted federal, state, and local tax funding files and reports Processed/transmitted 401 K files weekly to provider

●Reconciled JEs against banking cash sheets weekly to post in accounting database Partnered with HR/Benefits Department to ensure the accurate and timely processing of benefit

●deduction adjustments, well as ensuring compliance with state policies and procedures. Assisted with billing client's, AP coding/payment, and review of vendor POs to ensure accuracy

●Created weekly financial snapshot to CEO

Pricing Analyst (Contract) Battelle Memorial Institute, Columbus, OH 2/2016 10/2016

●Cross-functional work with Technical, Project Control and Financial staff to utilize knowledge of overhead-rate

structure, accounting, and financial systems

●Calculated P&L on prospective and historical proposals to determine revenue analysis Developed and reviewed price and cost detail from technical estimates or labor, material, and contracts to ensure consistency

●Reviewed client requests related to pricing information and proposal requirements/data in preparation for preliminary meetings



Contact this candidate