Business Unit Project Analyst

Tracey McDermott

Fort Worth, TX *****

214-***-**** ad18sb@r.postjobfree.com

www.linkedin.com/in/tracey-mcdermott1008

PROFESSIONAL EXPERIENCE

Emburse-Beacon Hill Staffing, Remote Contract July 2023 to Nov 2023 Billing Revenue Analyst

This position required contract reading, interpretation and ability to pull key data from contract terms to properly invoice customer. This position utilized many systems.

- Work in Google

- Billing system BP software

- Accounting NetSuite

- Sales (Salesforce)

- Customer inquiry (Zendesk)

- Project Mgmt. (Smartsheet)

- Pivot tables

- vlookups and fuzzy lookups

TD Industries LHH Solutions, Remote Contract Mar 2023 to May 2023 Project Analyst

Prepare, records, analyzes, and reports on the cost of producing the organization's products and services.

• Perform project set up, change order entry, and overall maintenance of a project Maintain project files. Prepares and enters project related journal entries.

• Prepared and submit monthly project billings to include both lump sum and cost-plus projects. Prepare and submit all required reports for assigned projects – CIP reports, lien waivers, project audits, etc.

• Accomplish month-end closing tasks for assigned business unit.

• Reconcile and prepare monthly sales report for assigned business unit.

• Conducts business unit account reconciliations – suspense, previously closed, incentive, etc. Conducts gross margin analysis to ensure the financial integrity of projects

Direct Line Global, Remote May 2022 to Feb 2023

Project Analyst

• Audited weekly, monthly and YTD Reports for time keeping and billing purposes

• Reviewed weekly and month-end employee timesheet data entry in Excel templates (Pivot tables and VLOOKUPs of large data sets)

• Weekly site meetings of all projects and projections

• Periodic reviews with the sites regarding the contractor’s hours on timesheets verse their Agency’s hours invoiced

• Established and reviewed site level monthly billing packages

• Established and updated site timecard templates for Runops T&M and GMP projects Reviewed Contracts/Purchase Orders and Work Orders

• Reviewed and coded material invoices for summary reports

• Updated monthly schedule of values (SOV) including retainage for GMP projects

• Created monthly invoices to upload into client’s invoice portal (Supplier Connect Software)

• Review of clients billing portal (Supplier Connect) contract values and change orders verses Direct line’s ERP system (Pro-Contractor by Viewpoint) and Construction Management Software (CMIC)

• Monitoring and reporting on AR and tracking remittance notifications

• Assisted Project Manager with monthly labor projections/forecast Reports

• Collaborated with team members on creating and streamlining processes

• Worked with client’s project management/auditing teams to address corrections to observations made during the monthly auditing process E4H Architecture, Fort Worth, TX Oct 2021 to Apr 2022 Project Accountant

• Coordinate with project managers the set-up of projects in the Deltek Ajera software

(budgets, plans, costs, invoicing, consultants)

• Maintain project-related records, including contracts and change orders

• Authorize the transfer of expenses into and out of project-related accounts

• Review and approve supplier invoices related to a project, code and enter into Ajera system. Review and approve time sheets for work related to a project

• Review account totals related to project assets and expenses

• Investigate project variances and submit variance reports to management

• Confer with receivables staff regarding unpaid contract billings

• Maintained accrual, backlog excel spreadsheets

• Report to management on project profitability, any opportunities for additional billings, and the remaining funding available for projects

• Create or approve all project-related billings to customers

• Compile information for internal and external auditors as required.

• Close out project accounts upon project completion.

• Monthly summary to project manager, controller, and CFO on invoicing Transglobal Services, Fort Worth, TX Oct 2019 to May 2020 Senior Accountant/Contract Administrator

• Responsible for all accounts payable and posting all cash and positive pays, reconciled and posted all credit card transactions in QuickBooks online software

• Reconciled AR and sent out open invoice reports to all managers

• Assisted in payroll processing, paid all payroll taxes, maintained company accounting procedures and processes and recorded other financial information for analysis

• Assisted in implementation of new ERP NetSuite

• Assisted the controller CPA in improving processes, preparing reports for upper management

• Maintained account balances and reconciled bank statements, printed W9’s and 1099’s

• Maintained and reconciled general ledger and assisted in month-end processes as well as audits. Ensure compliance with all internal processes, reviewed contracts before signature and performed special projects

JQ Engineering, Fort Worth, TX Mar 2016 to Mar 2019 Project Administrator

• Partnered with Project Managers and Engineers as Financial Support

• Setup new projects in Deltek Vision software, handled all project modifications, job cost review and reporting

• Reviewed commercial and government contracts and sub-contracts

• Coded and approved all supplier’s invoices for assigned project portfolio’s

• Created reports for business lines and project managers as needed

• Prepared subcontracts and processed job cost transfers in Deltek

• Created monthly AIA billings with lien waivers per contract requirements

• Prepared monthly statements and called clients regarding past due invoices

• Collected 2.5 million in past due revenue the first year 2016

• Set up meetings for webinars and presentations for the office EDUCATION

Certificate for Advanced Excel Skills

Palo Alto College, San Antonio, TX (Accounting Course) John Jay High School, San Antonio, TX

Advanced Excel Certificate

SKILLS

Operating Systems; Microsoft Windows 10, 11 and MAC Del-Tek Vision, Deltek Ajera, NetSuite, Salesforce, Oracle, JD Edwards, QuickBooks Sage Timberline, Peachtree 8.0, People soft, Reynolds & Reynolds, Construction Management software (CMIC), Pro-Contractor View Point (PCMX), Supplier Connect software, Dynamics D365

Google Docs, Microsoft Office 365 (Word, Works, Excel, Power Point, Outlook, STARS Risk Management Information Software for Insurance Carrier’s Software conversion with Electronic Service Control (ESC) integrated with QuickBooks Former Member of NAWIC (National Women in Construction) Certified Notary Public

Contact this candidate