Resume
THOMAS HERMAN
317 Woodward Ave SE ? Atlanta, GA 30312 ?------------ ? T------------
________________________________________
Financial Planning and Analysis Manager
High-performing professional with demonstrated ability to successfully complete challenging and complex assignments leveraging financial background to uncover significant areas of improvement ________________________________________
Experienced Finance professional with accounting degree seeking to enhance a leading organization’s overall performance and positive growth through complex financial analysis. Proven ability in financial reporting, analytical problem solving, quantitative analysis, international communications, and supporting existing worldwide financial database systems.
Budgeting ? Forecasting ? Financial Modeling ? Cost Center Reporting ? Advanced Excel Macros and Pivots ? Transaction Reconciliation ? Ad-Hoc Reporting ? Tax Accounting ? Financial Analysis ? SOX ? Transfer Pricing ? Retained Margin Analysis ? Intercompany Profit Elimination ? Database System Administration ? Robotic Process Automation ? Cash Management
Technology
SAP BPC ? Longview ? SAP ECC ? SAP BI ? Oracle ? Microsoft Navision ? Excel ? Visual Basic ? Hyperion Enterprise ? Access ? Thinkcell ? Power Pivot ? BI ? SQL ? Automation Anywhere (RPA)________________________________________
PROFESSIONAL EXPERIENCE
Georgia Pacific (GP) 01/19 – 06/19
Treasury Technology Business Analyst
Member of Finance and Cash Management Team within Georgia Pacific’s Treasury Department. $19Billion Dollar Revenue Business with a Treasury Team managing $3 Billion Dollars in working capital. I was hired to take over managing the Treasury Cash Management software system Kyriba. Worked closely with Cash Manager and Accounts Payable to design a new Wire request and approval process to handle loss of the previous Wire management software, resulting in a more reliable Wire process as well as an easier to use platform within which the analysts could operate.
? Managed day to day activity with Kyriba Cash Management tool, ensuring all wire payments were successful and that bank communication to the platform was functioning
? Worked with our banking partners to implement new banking instruments to improve our processes, save money and enable us to better manage our working capital across GP’s businesses
? Improved the Wire process at GP in regards to the Wire Request and Approval workflow, moving the process from an internal legacy system to a scoped version of Service Now (SN). This resulted in better controls on Wire requests and an easier platform for the end users than the previous process system. We were able to leverage existing technology GP had access to and have IT create a unique instance this process
? Process automation using Automation Anywhere a Robotic Process Automation tool. Designed and automated several processes within Treasury department. Created a tool using Automation Anywhere to read our utility invoices from Excel and populate corresponding payment information into our payment software, this process was being added onto our SN Wire process to free up time by removing manual data entry from our Treasury Analysts. An estimated savings of $40-50K the first year of operation.
? Corporate Compliance Officer for Treasury. Ensuring that department was in line with corporate compliance standards considering the level of sensitive information accessible by Treasury
Mueller Water Products (MWP) 01/18 to 12/18
Sales and Marketing FP&A Manager
Member and Manager within the Mueller Water Finance Department. MWP is a $1billion Revenue business. Brought on to take over the managing of the Sales and Marketing Analysis for MWP over the newly formed Value Stream management structure, part of the new 2018 Mueller strategy. Work closely with head of National Sales in US and Canada and COO to provide accurate forecasting for Orders to manage production.
? Redesigned the monthly and quarterly Orders Forecast between the different Value Streams and Sales Teams to enact a better overall forecast process using certaing key Economic Macros and Pricing Analysis
? Managed to decrease the overall time taken to run the Orders Forecast on a monthly basis just three business days from two weeks
? Provide key analysis to important customers, mainly sales, to help support and respond to business opportunities and decisions
? Process improvement to our Business Intelligence(BI) platform to provide better and more timely analysis to our customers
? Design, build and maintain long-term economic models for the company for long term strategic forecasting
? Provide monthly decks for key financial reporting to business for Executive Leadership Team
HD SUPPLY FACILITIES MAINTENANCE 09/15 to 01/18
Sr. Financial Analyst/Database Admin
Member of HD Supply Facilities Maintenance (FM) FP&A Team. FM is a $1billion EBITDA business. Brought on to help migrate FM business from San Diego, CA to Atlanta, GA. Primary focus was to take ownership of SAP BPC Reporting platform and become the database administrator and expert analyst on that system. Additionally tasked with improving the Month End Close process and system ownership.
? Traveled to San Diego for 6 months to facilitate transfer of FM business to Atlanta
? BPC lead administrator for ERP system for all of FM reporting and financials.
? Process improvement to BPC close process, initially a 2.5-hour process for every system download from SAP BI, reduced to under 5 minutes. Allowing faster updates to the system and more timely analysis for month end close and reporting.
? Support and train new employees on the use of BPC, BI, and Longview
? Led a 6-month project to update and repair our BPC platform due to an incomplete implementation. Worked with iTelligence (SAP Consulting firm) and updated the entire architecture of the system to improve performance to fall under best practice. Overall improvements in system response times and user satisfaction.
? Manage corporate FM B/S for monthly actuals, ongoing forecast and budgeting, focusing analysis on A/R, A/P, and Inventory to make sure we are meeting our cash flow plan.
GREYSTONE IT 06/14 to 9/15
Account Systems Specialist
Member of Navision IT Accounting Support team for Greystone Inc. Managing tickets from different accounting departments from Greystone Property and Healthcare for Navision issues, system updates, and consolidations. Cultivate a working relationship with Accounting and Finance Department for multiple companies within Greystone in order to provide a high degree of customer satisfaction.
? Collaborated with a team of 3 to build and maintain the internal architecture of corporate structure, within Navision, for monthly consolidations and reporting.
? Handle tickets from Account departments from Greystone Property and Healthcare for Navision support with quick response and resolution to the problem; most tickets resolved in less than 10 minutes.
? Create and maintain financial reports pull data from Navision for management and executive reporting
? Support and train new employees on the use of Navision and JET Reporting for their everyday use in their positions
? For annual IT meeting presented, to the executives of Greystone, a product(FireEye) to increase our security against zero-day cyber attacks and protect our financial information and personnel information
TENSAR CORPORATION 06/13 to 6/14
Global Financial Analyst and Database Administrator
Member of Global Finance/Accounting Consolidation Team for an international grid textile corporation. Responsible for the consolidation of East and West sectors of Tensar. Database administrator for Longview, Global ERP system, maintaining and improving current ERP system and assisting IT in potential upgrade as well as acting liaison between IT and finance department.
? Active member of the corporate consolidation team as the lead financial analyst performing numerous traditional accounting and financial duties for the monthly close.
? Prepared and maintained tools for analysis and reports used by management for results evaluation
? Managed Longview accounting system to ensure an efficient working system and ease of access for global users
? Provided service to global users to troubleshot errors on a daily basis.
? Worked closely with external auditors during annual audit of financial statements and testing of the accounting system (KPMG and EY)
? Assisted in preparation for sale of company regarding all due diligence requests
SIEMENS 06/10 to 06/13
Financial Analyst – SII HQ Reporting/Finance
Member of the HQ Reporting Team that manages a $300 million cost center structure, overseeing Siemens Industry's eight main entities with North America of a $47 Billion global business. Brought on board to help integrate new Financial Database systems and automate lagging closing processes. Consolidating multiple reporting systems for Financial Reporting and analysis, as well as ERP reporting processes. Excel expertise a contributing factor in obtaining position.
? Cost Center Reporting and Controlling, created and managed Cost Center Reports manually with excel as well as facilitating meetings with Cost Center Owners to control costs and deal with any one time substantial expenses.
? Monthly reporting of department/cost center budget and forecast versus actuals and investigating the drivers behind variances
? Reconciling HQ costs back to financial statements
? Collaborate with all HQ departments regarding any changes to actuals and the direct impact to long term planning throughout fiscal year
? Corporate Allocation of Headquarter SGA costs out to different divisional businesses that fall under SII
? Development of Budget and Forecast for functional corporate departments
? Reconciling SAP to Hyperion Enterprise System
? Preparation of monthly reports/statements to divisions down to business segment detail
________________________________________
EDUCATION
Bachelor of Science / Accounting / Mercy College, NY/ GPA 3.6 / Magna Cum Laude / August 2009
THOMAS HERMAN
317 Woodward Ave SE ? Atlanta, GA 30312 ?------------ ? T------------
________________________________________
Financial Planning and Analysis Manager
High-performing professional with demonstrated ability to successfully complete challenging and complex assignments leveraging financial background to uncover significant areas of improvement ________________________________________
Experienced Finance professional with accounting degree seeking to enhance a leading organization’s overall performance and positive growth through complex financial analysis. Proven ability in financial reporting, analytical problem solving, quantitative analysis, international communications, and supporting existing worldwide financial database systems.
Budgeting ? Forecasting ? Financial Modeling ? Cost Center Reporting ? Advanced Excel Macros and Pivots ? Transaction Reconciliation ? Ad-Hoc Reporting ? Tax Accounting ? Financial Analysis ? SOX ? Transfer Pricing ? Retained Margin Analysis ? Intercompany Profit Elimination ? Database System Administration ? Robotic Process Automation ? Cash Management
Technology
SAP BPC ? Longview ? SAP ECC ? SAP BI ? Oracle ? Microsoft Navision ? Excel ? Visual Basic ? Hyperion Enterprise ? Access ? Thinkcell ? Power Pivot ? BI ? SQL ? Automation Anywhere (RPA)________________________________________
PROFESSIONAL EXPERIENCE
Georgia Pacific (GP) 01/19 – 06/19
Treasury Technology Business Analyst
Member of Finance and Cash Management Team within Georgia Pacific’s Treasury Department. $19Billion Dollar Revenue Business with a Treasury Team managing $3 Billion Dollars in working capital. I was hired to take over managing the Treasury Cash Management software system Kyriba. Worked closely with Cash Manager and Accounts Payable to design a new Wire request and approval process to handle loss of the previous Wire management software, resulting in a more reliable Wire process as well as an easier to use platform within which the analysts could operate.
? Managed day to day activity with Kyriba Cash Management tool, ensuring all wire payments were successful and that bank communication to the platform was functioning
? Worked with our banking partners to implement new banking instruments to improve our processes, save money and enable us to better manage our working capital across GP’s businesses
? Improved the Wire process at GP in regards to the Wire Request and Approval workflow, moving the process from an internal legacy system to a scoped version of Service Now (SN). This resulted in better controls on Wire requests and an easier platform for the end users than the previous process system. We were able to leverage existing technology GP had access to and have IT create a unique instance this process
? Process automation using Automation Anywhere a Robotic Process Automation tool. Designed and automated several processes within Treasury department. Created a tool using Automation Anywhere to read our utility invoices from Excel and populate corresponding payment information into our payment software, this process was being added onto our SN Wire process to free up time by removing manual data entry from our Treasury Analysts. An estimated savings of $40-50K the first year of operation.
? Corporate Compliance Officer for Treasury. Ensuring that department was in line with corporate compliance standards considering the level of sensitive information accessible by Treasury
Mueller Water Products (MWP) 01/18 to 12/18
Sales and Marketing FP&A Manager
Member and Manager within the Mueller Water Finance Department. MWP is a $1billion Revenue business. Brought on to take over the managing of the Sales and Marketing Analysis for MWP over the newly formed Value Stream management structure, part of the new 2018 Mueller strategy. Work closely with head of National Sales in US and Canada and COO to provide accurate forecasting for Orders to manage production.
? Redesigned the monthly and quarterly Orders Forecast between the different Value Streams and Sales Teams to enact a better overall forecast process using certaing key Economic Macros and Pricing Analysis
? Managed to decrease the overall time taken to run the Orders Forecast on a monthly basis just three business days from two weeks
? Provide key analysis to important customers, mainly sales, to help support and respond to business opportunities and decisions
? Process improvement to our Business Intelligence(BI) platform to provide better and more timely analysis to our customers
? Design, build and maintain long-term economic models for the company for long term strategic forecasting
? Provide monthly decks for key financial reporting to business for Executive Leadership Team
HD SUPPLY FACILITIES MAINTENANCE 09/15 to 01/18
Sr. Financial Analyst/Database Admin
Member of HD Supply Facilities Maintenance (FM) FP&A Team. FM is a $1billion EBITDA business. Brought on to help migrate FM business from San Diego, CA to Atlanta, GA. Primary focus was to take ownership of SAP BPC Reporting platform and become the database administrator and expert analyst on that system. Additionally tasked with improving the Month End Close process and system ownership.
? Traveled to San Diego for 6 months to facilitate transfer of FM business to Atlanta
? BPC lead administrator for ERP system for all of FM reporting and financials.
? Process improvement to BPC close process, initially a 2.5-hour process for every system download from SAP BI, reduced to under 5 minutes. Allowing faster updates to the system and more timely analysis for month end close and reporting.
? Support and train new employees on the use of BPC, BI, and Longview
? Led a 6-month project to update and repair our BPC platform due to an incomplete implementation. Worked with iTelligence (SAP Consulting firm) and updated the entire architecture of the system to improve performance to fall under best practice. Overall improvements in system response times and user satisfaction.
? Manage corporate FM B/S for monthly actuals, ongoing forecast and budgeting, focusing analysis on A/R, A/P, and Inventory to make sure we are meeting our cash flow plan.
GREYSTONE IT 06/14 to 9/15
Account Systems Specialist
Member of Navision IT Accounting Support team for Greystone Inc. Managing tickets from different accounting departments from Greystone Property and Healthcare for Navision issues, system updates, and consolidations. Cultivate a working relationship with Accounting and Finance Department for multiple companies within Greystone in order to provide a high degree of customer satisfaction.
? Collaborated with a team of 3 to build and maintain the internal architecture of corporate structure, within Navision, for monthly consolidations and reporting.
? Handle tickets from Account departments from Greystone Property and Healthcare for Navision support with quick response and resolution to the problem; most tickets resolved in less than 10 minutes.
? Create and maintain financial reports pull data from Navision for management and executive reporting
? Support and train new employees on the use of Navision and JET Reporting for their everyday use in their positions
? For annual IT meeting presented, to the executives of Greystone, a product(FireEye) to increase our security against zero-day cyber attacks and protect our financial information and personnel information
TENSAR CORPORATION 06/13 to 6/14
Global Financial Analyst and Database Administrator
Member of Global Finance/Accounting Consolidation Team for an international grid textile corporation. Responsible for the consolidation of East and West sectors of Tensar. Database administrator for Longview, Global ERP system, maintaining and improving current ERP system and assisting IT in potential upgrade as well as acting liaison between IT and finance department.
? Active member of the corporate consolidation team as the lead financial analyst performing numerous traditional accounting and financial duties for the monthly close.
? Prepared and maintained tools for analysis and reports used by management for results evaluation
? Managed Longview accounting system to ensure an efficient working system and ease of access for global users
? Provided service to global users to troubleshot errors on a daily basis.
? Worked closely with external auditors during annual audit of financial statements and testing of the accounting system (KPMG and EY)
? Assisted in preparation for sale of company regarding all due diligence requests
SIEMENS 06/10 to 06/13
Financial Analyst – SII HQ Reporting/Finance
Member of the HQ Reporting Team that manages a $300 million cost center structure, overseeing Siemens Industry's eight main entities with North America of a $47 Billion global business. Brought on board to help integrate new Financial Database systems and automate lagging closing processes. Consolidating multiple reporting systems for Financial Reporting and analysis, as well as ERP reporting processes. Excel expertise a contributing factor in obtaining position.
? Cost Center Reporting and Controlling, created and managed Cost Center Reports manually with excel as well as facilitating meetings with Cost Center Owners to control costs and deal with any one time substantial expenses.
? Monthly reporting of department/cost center budget and forecast versus actuals and investigating the drivers behind variances
? Reconciling HQ costs back to financial statements
? Collaborate with all HQ departments regarding any changes to actuals and the direct impact to long term planning throughout fiscal year
? Corporate Allocation of Headquarter SGA costs out to different divisional businesses that fall under SII
? Development of Budget and Forecast for functional corporate departments
? Reconciling SAP to Hyperion Enterprise System
? Preparation of monthly reports/statements to divisions down to business segment detail
________________________________________
EDUCATION
Bachelor of Science / Accounting / Mercy College, NY/ GPA 3.6 / Magna Cum Laude / August 2009