Mary Hollaway
Sugar Grove,IL
Summary
Developed strong analytical and strategic planning skills in high-paced corporate finance environment. Effective at managing financial operations and implementing process improvements. Strong background in financial analysis, budgeting and forecasting. Develops and implements financial plans and delivers strategic financial advice. Adapts quickly to challenges and changing environments. Proven ability to identify business needs and develop valuable solutions by consolidating Big Data using BI to drive accuracy and process efficiency. Seeking to transition into new field where financial acumen and strategic thinking can drive success.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Senior Finance Manager
Ecolab
07.2023 - Current
- North America Nalco Supply Chain FP&A and Logistics Finance Manager.
- Direct annual budget process and quarterly forecast updates, integrating financial data from multiple sources to ensure accurate projections for all of North America Nalco Supply Chain with an annual budget of $450M operationally.
- Present and report out month end results, providing insights and conducting variance analysis to internal Operations Leadership and Finance stakeholders.
- Identified areas for improvement within the internal finance team, leading to increased productivity and reduced errors while documenting standard operating procedures.
- Validate standard cost setting process for annual cost roll for our Manufacturing and Logistics operations.
- Conduct in-depth analysis of the company's financial performance against forecast, highlighting areas for improvement or potential risks to Supply Chain Leadership weekly.
- Streamlined month-end close process through automation initiatives that increased data accuracy while reducing time spent on administrative tasks, leading 2 financial associates.
- Created financial dashboards and presentations to provide insights into key performance indicators.
- Participate in cross-functional teams focused on continuous improvement initiatives within the organization's supply chain operations.
- Lead North America Transportation budget for 3rd party and internal fleet operations, partnering with the VP of Logistics.
- Develop monthly Transportation variance reports and quarterly forecasts to track actual performance against projected budgets, facilitating corrective action when necessary.
Business Intelligence Manager
Ecolab
03.2020 - 07.2023
- Managed Global BI team of 4 BI analysts and architects providing cross -divisional and cross - functional finance personnel support in database reporting and efficiencies.
- Created first of its kind North America database consolidating dozens of BEX extracts, SAP reports and custom tables to empower finance with useful, timely and accurate information updated daily.
- Created, owned and managed Power BI workspace housing over 45 global and customized reports for FP&A, Corporate Account and Sales Leadership to track key metrics such as daily sales, price capture, new business trends and gross margin improvement initiatives.
- Created and managed a first of its kind global database and most complete with over 92% of monthly sales spanning 5 years worth $6B in annual revenue with sales and cost trends at customer and product level.
- Project lead for Ecolab wide unit and solution report for global, cross-divisional visibility into customer and product buying behavior for C-suite and leadership support use.
- Partnered with EDO as key business contact and consult in creating revamped Ecolab wide data lake.
- Worked closely with Finance, Sales and Marketing leadership on key initiatives to drive business visibility and change management.
- Presented project progress and successes in monthly stakeholder meetings with finance leadership.
- Created workflow diagrams and Gantt charts to clearly demonstrate processes and timelines throughout project management.
Senior Financial Analyst
Ecolab
02.2019 - 03.2020
- FP&A Finance Lead for a $300M Division for Food and Beverage and Manufacturing business units.
- Developed and present financials to inform and educate on business performance in weekly and monthly leadership meetings made up of 12 key stakeholders.
- Developed, analyze, and communicate daily sales trends in order to project month end performance vs. budget to corporate leadership.
- Created Power BI cloud reporting for sales leadership use to understand key performance trends using multiple KPIs.
- Performed advanced reviews of business operational trends and expected obligations to prepare accurate monthly sales and expense forecasts.
- Partnered with General Manager, supply chain, marketing, and sales leadership to create operating budgets and initiate annual financial planning.
- Lead project to solve complex $3.6M gross margin problem for senior leadership and finance team to execute in order to meet budget.
Senior Financial Analyst
Ecolab
01.2017 - 02.2019
- Project lead to build and maintain 4 Power BI cloud reporting databases to streamline key financial metrics for sales leadership and corporate sales team.
- Consolidated key financial data into presentations for monthly leadership meetings.
- Built and maintained standard operating procedures for forecasting and tracking price and gross margin performance.
- Lead the corporate account finance gross margin improvement bi-monthly review meetings which helped capture over $3 million in annual gross margin impact.
- Developed and maintained the 2018 price plan process with 500+ sales team members for a business unit with $500 million in annual revenue.
- Deployed and managed quarterly billing arrangement review process with the sales and sales administration teams.
- Verified and loaded mass product pricing templates in SAP.
- Wrote VBA code and used macros to speed processes and maximize accuracy for several finance processes.
Financial Analyst
Conagra
11.2015 - 12.2016
- Consolidated data analyzing actual financials vs. forecast and budget for weekly and monthly brand meetings for a business unit with $230 million in revenue.
- Developed, analyzed and reported financial statements by segment, category or customer for various weekly ad hoc requests.
- Worked closely with brand management and sales to determine pricing, margins and risk factors for several weekly pricing requests.
- Analyzed, consolidated and loaded volume and missing rates for the monthly forecast and annual budget into SAP BPC.
- Calculated and reported actual quarterly royalty sales and annual forecast sales to 4 licensing companies.
- Developed and compiled COGS savings by category as well as overall operational efficiency for plant consolidation projects.
- Computed and analyzed the impact of trade promotion requests from the sales team on a weekly basis.
Financial Analyst
Conagra
09.2014 - 11.2015
- Analyzed and ensured the accuracy of all trade promotion accruals and expenses within QAD for 4 business channels for the Retail Bakery division worth $800 million in revenue and over $60 million in annual trade spend.
- Prepared complex journal entries and facilitated account closing and reconciliation procedures each month in accordance with GAAP.
- Loaded and reconciled trade expense data into the CPPL Hyperion reporting tool for customer and SKU level analysis.
- Created and organized monthly reports detailing trade expense drivers affecting the P&L for all 4 channels.
- Proactively participated in monthly and quarterly trade review meetings with cross-functional teams.
Associate Financial Analyst
Conagra
11.2013 - 09.2014
- Analyzed and booked all intercompany transactions for the Frozen Bakery division in QAD.
- Reconciled finished goods inventory for 10 warehouse locations monthly.
- Performed general accounting functions, including preparation of journal entries, account analysis and balance sheet reconciliations for over 20 accounts.
- Implemented and maintained a structured account reconciliation and journal entry review process.
- Project lead for the conversion of journal entry reviews into electronic format within the CAE Tool.
Accounting Manager
Hollaway Meyer's
05.2010 - 11.2013
- Maintained the integrity of the general ledger, including the chart of accounts, for a company with annual sales of $3.2 million.
- Generated financial statements and facilitated account closing and reconciliation procedures each month.
- Created periodic reports comparing budgeted costs to actual costs and provided advice to increase company profits.
- Managed, prepared and distributed payroll for staff of 30 on a weekly basis.
- Monitored payments due from clients and promptly contacted clients with past due payments.
- Reconciled vendor statements and handled payment complaints or discrepancies.
Education
MBA - Management Information Systems
Northern Illinois University
Dekalb, IL05.2022
Bachelor of Science - Accounting
Indiana University Kelley School of Business
Bloomington, IN05.2010
Skills
- Strategic forecasting and planning
- Financial analysis and reporting
- Financial modeling
- Key Performance Metrics
- Project Management
- Verbal and written communication
- Mentoring and training
- Superior organization and attention to detail
- Advanced skills in Microsoft Excel, Access, Power BI, and PowerPoint
- SAP and QAD ERP system experience
- Data collection and analysis
- Collaboration and problem solving
Certification
Certified Scrum Product Owner (CSPO)
Timeline
Senior Finance Manager
Ecolab
07.2023 - Current
Business Intelligence Manager
Ecolab
03.2020 - 07.2023
Senior Financial Analyst
Ecolab
02.2019 - 03.2020
Senior Financial Analyst
Ecolab
01.2017 - 02.2019
Financial Analyst
Conagra
11.2015 - 12.2016
Financial Analyst
Conagra
09.2014 - 11.2015
Associate Financial Analyst
Conagra
11.2013 - 09.2014
Accounting Manager
Hollaway Meyer's
05.2010 - 11.2013
Certified Scrum Product Owner (CSPO)
MBA - Management Information Systems
Northern Illinois University
Bachelor of Science - Accounting
Indiana University Kelley School of Business
Similar Profiles
Kayla MeadwellKayla Meadwell
Brand Protection Advisor at EcolabBrand Protection Advisor at Ecolab
Rogelio GuerreroRogelio Guerrero
Field Operations Manager at EcolabField Operations Manager at Ecolab
William CliffordWilliam Clifford
Assistant Vice President, Corporate Account Sales at EcolabAssistant Vice President, Corporate Account Sales at Ecolab