Douglas Hartunian
Weymouth, MA 02189
****************@*****.***
Professional Experience
Home Market Foods – Norwood, MA Dec 2025 to Present
Finance Manager (Contract- Maternity Leave)
Inventory Management and Valuation Reporting: Write Off Recognition
OPEX Reporting, Utilities Analysis, and Accrual Management
Burden Calculation
Capex Management
Ahold Delhaize USA – Quincy, MA
Lead Analyst Jul 2022 – Jun 2025
•Daily Activities: P&L and Balance Sheet Analysis, Financial Modeling, Accrual Calculation, Ad hoc Journal Entries.
•Owned month-end close, accruals, and vendor management processes, ensuring accuracy of P&L and balance sheet reporting across multiple business units.
•Financial Modeling: Designed and implemented SAP/BPC reporting tool that broke out OPEX section of spend.
•Served as liaison for Accounting Team on SAP S/4HANA implementation, validating data migration and ensuring expense data integrity.
H.C. Starck Inc / Materion – Newton, MA
Assistant Controller Nov 2020 – Jun 2022
•Daily Activities: Resource/Material Spend Reporting, Financial Modeling, Accrual Calculation, Ad hoc Journal Entries.
•SAP S/4Hana Administrator - G/L Mapping
•Weekly Presentation of following areas to C-Suite:
oSales Flash Reporting
oCost Center Analysis / Forecasting via open orders (Daily communications with business owners)
•Inventory, Cycle Count, and scrap mini physicals oversight and reporting.
•CAPEX Management which included Financial Modeling FCF / NPV dealing with equipment valuation.
Hub Promotional Group (HPG) – Braintree, MA
FP&A Manager Apr 2019 – Jun 2020
•Daily Activities: Financial Modeling, P&L and Balance Sheet Analysis, Accrual Calculation, Ad hoc Reporting for Ownership (P/E).
•Managed and added relevant schedules to financial consolidation file (model) with roll up/split out of 7 companies (5 US and 2 Canadian) - Income Statement, Balance Sheet, Cash Flows, What-If Analysis, and KPI Dashboards
•Designed Gross Margin Reporting Tool - Broke out Product/Class scheduling between revenue vs. COGS and resulting GM metrics
•Guided company analyst and accountants on month end process following GAAP.
•Budget template creator for all companies. Involved with Full Budget Cycle process.
Robert Half Salaried Professional Services – Boston, MA Nov 2017 – Apr 2019
Sr Management Consultant – FP&A
General Activities: Special Project Help, Short/Long Term Financial Resource
Tableau creator, allowed end users to manipulate and create visualization within dashboard and easily updatable – showed company performance/stock ownership metrics. Used VBA Macro to update data quickly.
Created Sales Commission Model that broke out Quarterly Payout of Sales Team, with claw back functionality.
What If Scenario Forecasting and Cash Flow Analysis on Site planning project
Product level Actual vs. Budget Analysis
Budget Leader for Yearly Budget Cycle – R&D Team. Created templates, had one on one conversations with budget owners. Finalized with team and uploaded into system.
KPI Reporting
Independent Contractor - Boston, MA
Senior FP&A Consultant
GCP Applied Technologies/Henkel (Contract) Jun 2017 – Nov 2017
Aegerion Pharmaceutical (6-month Contract) Jan 2017 – Jun 2017
Vista Higher Learning (6-month Contract) Jul 2016 – Dec 2016
Houghton Mifflin Harcourt (Contract – Paternity Leave) Mar 2016 – Jun 2016
Massachusetts Eye and Ear Infirmary (Contract – Maternity Leave) Jan 2016 – Mar 2016
Helped create slides used in monthly board deck to review financials for stakeholders (All)
Automated both headcount and OPEX reporting. (Aegerion)
What-If Analysis using historical data and showing forecasted scenarios. (GCP/Aegerion)
Wrote/maintained SQL queries to pull data source files from database (GCP/Aegerion/RH)
Documentations of various financial workflows for FP&A, Tech Spend, Rev Rec) (All)
Created monthly/quarterly financial reporting with data pulled from SAP and using BPC module add-on data querying within Excel (GCP)
Full monthly P&L Reporting (Rev, COGS, OPEX, EBIT/EBITDA, and NI) (Aegerion)
System Implementation Testing and Scripting (SQL): EPIC Health Records System (MEEI)
Created JE’s for monthly reconciliation process (MEEI)
Scheduled the budgeting/forecasting of vendor spend within technology group. (HMH)
Ad-Hoc: Balanced Scorecard Project and Technology Group Department Mapping (HMH)
Atlantic Tele Network (ATN) – Beverly, Massachusetts
FP&A Analyst Mar 2014 – Jan 2016
•Depreciation/amortization scheduling for capital assets/loan repayment
•Ran file transfers/data linking of subsidiary companies using CoA mapping
•Updated data files using VBA modules
•10Q/10K Reporting and Bank Covenant Compliance– Updated with relevant scheduling
•NetSuite Implementation: Complete transfer of financial reporting package
•Board Deck creation and presentation: complete view of company consolidation and then drilled down into domestic/international subsidiary level reporting
GainsKeeper (Wolters Kluwer Subsidiary) – Waltham, MA
Jr. Financial Analyst 2010 - 2014
•Capital Gains Tax implications concerning stock market events
•Analyzed and broke down Corporate Action events into excel calculations
•System Testing within software.
•Cost Basis analysis on stock market events surrounding non-cash stock events (EDI, DTCC, and Bloomberg Data/Terminal sourcing)
Education
Endicott College - Beverly, MA – MBA – Finance and Data Analysis
Independent Study: Marine Fisheries
Study Abroad Program: Italy
Wittenberg University - Springfield, OH – BA – Business Administration / Accounting
Study Abroad Program: Stirling, Scotland – Import/Export Markets and International Business
Technical Experience (years of experience)
Microsoft Office
Excel [Nested IF’s, SUMIFS, Pivot Tables/Charts, Power BI] (25)
Access (12)
PowerPoint [Board Decks, Org Charts] (15)
Word (27)
Power BI and Power Pivot (7)
Visio (3)
OneNote (7)
Other Software/ERP/CRM
QuickBooks (10)
SAP (R3/BW/Business Objects/BPC) (8)
NetSuite (8)
Oracle (Essbase/SmartView/Hyperion ERP) (7)
Tableau/MicroStrategy/In-house BI (5)
Crystal Reporting (3)
Salesforce (5)
Adaptive Insights (7)
Programming
C++ (1)
Excel: Automation/VBA Module Creator (15)
SQL: Querying and Data Warehousing (12)
Python (Hobby Programming)