Staff Accountant Senior

John Bolton

Dallas Texas 469-***-**** *******@***.*** www.linkedin.com/in/JohnBoltonSMU

EDUCATION

CPA in Progress

Southern Methodist University, Cox School of Business Dallas, TX Master of Business Administration, Finance & Business Analytics May 2024 Texas Tech University Lubbock, Texas

Bachelor Administration in Accounting August 2010

• Dean's Honor List

EXPERIENCE

Coca Cola Southwest Beverages Dallas, Texas

Senior Accountant – FP&A, Finance Department Apr 2019 - Present Full Cycle Accounting at Coca Cola Southwest Beverages. 20 to 30 people work in the Finance Department.

• Apply GAAP accounting standards by organizing and reconciling several balance sheet account reconciliations and recording related journal entries and adjustments for month close.

• Analyzed P&L variances in T&E, Telecom, External Audit, Freight & Miscellaneous accounts using customized Oracle SmartView templates and sub reports, providing actionable insights to senior leadership.

• Partnered with Procurement and Operations to develop annual spend projections, aligning budget forecasts with business strategy and cost-saving initiatives.

• Designed and developed an interactive financial dashboard for leadership using Power Query, Power Pivot, and Excel, enabling real-time analysis of AP department work production, vendor write-off trends, and employee recommendations.

• Automated data relationships and drill-down capabilities to allow managers to manipulate summaries, providing insights into vendor-level write-offs, employee activity, and business segment impact, improving decision-making and operational efficiency.

• Invent Travel and Entertainment Card account reconciliation and risk and opportunity templates with associations using relationships to match bank statement data to SAP data, resulting in improved efficiency by 90%.

• Created AP Metric Tool. The tool cleans up aged liabilities by assigning weights to several metrics. If enough metrics test positive, the aged liability can be written off. The tools used in the process are SQL, Advance Excel, and Snowflake. This results an improved efficiency by 90%. Miraca Life Sciences Dallas, Texas

Staff Accountant, Accounting Department Apr 2017 - Nov 2017 Experienced working as a Accountant for Miraca Life Sciences, a Pathology laboratory research company.

• Performed account reconciliations and journal adjustments related to Inventory, Legal and T&E.

• Investigated P/L variances from accounting analysis. Recommended P&L adjustments. Tribune Publishing Company Dallas, Texas

Staff Accountant, Accounting Department Aug 2015 - Apr 2017 Practiced working as a Revenue Accountant for an American newspaper publishing company

• Applied GAAP accounting standards by managing and reconciling A/R and Differed Revenue Account reconciliations and recording related journal entries and adjustments for month close. NQ Mobile US Operations Dallas, Texas

Staff Accountant, Finance Department Apr 2012 - Jul 2015 Accomplished working as an accountant for a small startup company providing consumer and mobile internet services

• Prepared Financial Statements under GAAP standards and reconciled several balance sheet account reconciliations and recorded related journal entries and adjustments for month close. TECHNICAL SKILLS

• Data Management: Designed and configured relational databases, Power BI, Snowflake

• Reporting: Power Query and Access reports, Oracle Financials, Budget Models for Denton County

Contact this candidate