Haydee Jureidini: Senior Financial Analyst in Downey, CA

Build ad-hoc business financial models and reports using Solver BI360 and Excel for 30 pier terminals, 4 companies, 9 job types, and 7 billing types providing commentary on variances to budget. Prepare case study analysis and project post mortem presentations examining historical financials, payroll/billable hours, g/l transactions, vendor spend trends, and contract analysis as a guide to nego- tiate pricing on future projects as well as understand lessons learned, wins, and losses. Perform monthly/weekly reconciliations including gross margin analysis, casual labor savings vs. hours, job performance sales revenue forecasts using Acumatica, MS Access, SQL Server sources.

Streamlined monthly financial reporting package for Small Cell & Fiber businesses with supporting variance analysis and explanations to variances budget and guidance to actuals. Prepared and enhanced monthly P&L financial models for Small Cells and Tower businesses with $908M (West Region) in annual revenue providing business insight analytics to senior leadership. Identifying opportunities for improvement such as pass-through expense recovery process, coding accuracy, enhance reporting from excel to automated on demand BI reporting. Supported regional management team with headcount reporting, FTE and contractor overtime report- ing, legal expense analysis, and monitoring expenses to achieve objectives despite org changes. Created dynamic visualizations on Tableau to monitor travel expense spend for 20 BUs (for 1 year). Developed overtime reporting into dashboards in Power BI for senior leadership decision making. Prepared daily service gross margin and revenue recognition service dashboards for various complex Towers job construction billable milestones on over 2,000 work orders in the pipeline. Supported PNW and NorCal markets small cell project delivery and fiber construction with project P&L, pass-thru revenue, and processing budget increase requests for capital committee review. Managed $113M in capital budget projects portfolio by analyzing sales ROI models, complex con- tracts, bifurcated budgets in JD Edwards and Oracle, and conducting project risk reviews analysis. Managed $403M in capital budgets for Small Cell SoCal market portfolio supporting 4 PgMs 15 PMs by updating weekly job completion forecasts and assessed capex budget risks (Nov. 2017-Apr. 2019). Established annual budget targets for travel expenses, temporary labor, and overtime by business unit. Developed and analyzed quarterly forecast models such as deferred rent revenue milestone billing, capital pass-throughs revenue, sustaining capex; and performed historical trend analysis. Performed sunk cost analysis on node deselection or project cancellations while interfacing with estimating, program management, and job cost accounting to adjust budgets and write-off assets.

Managed end-to-end accounts payable operations for civil engineering firm with $272 M annual revenue. ? Developed project management skills collaborating with IT staff on multiple projects including re- engineering a modernized payables system using MS Project to monitor project milestones. ? Assisted in implementing Deltek Costpoint conversion, T&E payment system, and credit card pro- gram with account mapping and coding configurations training all levels of employees. ? Provided employees with technical support and customer service related to payment requests. ? Reviewed and posted payment vouchers (approx.$4M/wk) verifying proper cost accounts, projects, BU codes, and approvals for client invoice billing. Developed relationships with vendors. ? Supervised, motivated, and cross-trained staff of 3 A/P specialists in constantly changing department. ? Managed master vendor database with subcontractor contracts, W9s, certificates of insurance, and various payment terms to ensure audit compliance, automate invoice coding, and report 1099s. ? Engaged with Audit teams and Controller during quarterly and annual audits, tested SOX system con- trols, prepared audit work-papers, and updated desktop procedures. ? Corporate credit card administrator of ~$200K monthly spend for 80 employees, streamlined process- es from manual accrual entries to automated expenses in banking system and accounting system.

Prepared monthly tour margin cost accrual margin report by reconciling costs, guest count, and rev- enue per booking (60avg./mo.) to determine gross margin by product line. ? Developed financial operations summary results with commentary comparing revenue, cost of sales, G&A expenses, and marketing expenditures actuals to budget using multiple data sources. ? Month-end close duties: maintained G/L trial balance to ensure all accounting transactions were post- ed timely; prepared journal entries for prepaid, accruals, deferred air revenue, trip insurance, and maintained amortization/depreciation schedules; and bank reconciliations of check disbursements. ? Prepared daily cross-border wire transfers in multiple foreign currencies resolving any rejected wire payments or comply with foreign assets regulations; and weekly cash requirement forecasts. ? Validated foreign vendor and hotel invoices against contracted rates and worked with managers to resolve any discrepancies prior to payment overseas. ? Assisted Senior Leadership with annual budget preparation, year-end audit, ad-hoc reporting, 1099 reporting and other business state, federal, travel industry filings. ? Backup support for accounts receivable applying credit card, check, cash payments to customer ac- counts in revenue/booking system and reporting daily cash to management.

Prepared various account analysis reports for cost center budget planning, travel expense tracking, purchase order reconciliation, consultant payment schedules, and aging reports for cash management. ? Lead several process improvement initiatives that significantly improved invoice processing lead time from 2 weeks to 10 minutes by implementing Oracle Financials and trained employees. ? Responsible for full cycle accounts payable operations in a fast-paced environment, processed weekly check runs, handled complaints, backup during supervisor absences, and revised corporate policies. ? Processed high volume contractor, consultant, and temp agency invoices as well at T&E employee expense reports reports during merger of three companies to accurate account codes. ? Verified accurate coding on Capex and Opex purchase orders and invoices to gain understanding into GAAP due to impact on integration projects in the financial statements.