Financial Analyst Manager
Resume:
Tamer Makary
**** ****** **** **, ************, FL 32226
**************@*******.***
Professional Experience
AccruePartners consulting Nov 2019 – Present
Accounting Principal Consultant – TIAA Bank
Supports key corporate initiatives including acquisitions, new products and business model changes. Contributes in executing each planning and forecasting cycle.
Communicates with the various Finance Directors regarding assumptions and deliverables.
Creates presentations and dashboards for Executive Management
Provide variance explanation commentary for Actuals vs. Plan or Forecast for each Board of Directors meeting.
Prepares complex calculations, analysis and recommendations for senior leadership and executive management Analyzes financial information for management to assist with business decisions.
Formulate strategic and long term business plans and forecasts.
Analyze changes in interest rates impact a particular business unit’s Balance Sheet and Income Statement.
Advocates use of technology and systems to enable efficiency for each plan and forecast process
Maintains and monitors appropriate internal controls as related to planning and forecasting.
Liaison with the external reporting group to ensure changes to accounting policies are incorporated correctly with each plan and forecast cycle.
Partners with the business segments to advise and assist with establishing key drivers used in planning and forecasting.
Assist in documenting key assumptions used for each plan and forecast cycle
Understand the planning system (TM1) and be able to forecast for assigned business units accordingly.
Provide guidance and participate on projects that will continue to improve the planning system (TM1)
The CJS Solutions Group, LLC (HCI Group) Dec 2017 – Jul 2019
Sr. Manager Financial Planning & Analysis / Treasury
Partnered with the executive team to develop support for strategic, business planning, reporting, process improvement and performance management practices to achieve the organization vision in profitability.
Managed month end close, preparation of accounting accruals and bank accounts reconciliations.
Prepared monthly and quarterly consolidated financial statements, MD&A, financial reporting package and analyzed variances from the budget.
Prepared monthly and quarterly income statements, cash forecasts and other assigned financial analyses, including earnings releases, investors relations, industry and competitors analyses.
Managed the corporate annual budgeting and quarterly forecasting processes.
Assisted in preparing, reviewing and managing quarterly and annual earnings releases, SEC filings (10-Q, 10-K & 8-K).
Assisted in preparing the quarterly financial reporting calendars.
Coordinated with internal and external teams to facilitate SEC filings, including compiling financial & non-financial data.
Assisted in preparing and analyzing consolidated financial statements and footnote disclosures for SEC filings, including completing disclosure checklists to ensure financial statements compliance.
Assisted in the implementation of new accounting standards and regulation changes to ensure compliance with US GAAP, SOX and SEC regulatory requirements.
Assisted external auditors in audits relating questions to the financial statements.
Implemented new process improvements and streamlined financial tools.
Managed and trained staff, which included recruiting, hiring, monitoring and documenting employee performance per company guidelines, completed corrective action plans, additional skill development, and terminations as needed.
Provided monthly financial and operating metrics. Develop new metrics, KPIs.
Managed cash flow to ensure sufficient funds for operations.
Managed accounts receivable, accounts payable, expenses reimbursement departments.
Monitored debt levels and compliance with debt covenants and ensured interest are paid on a timely basis.
Managed all cash management functions, including forecasting, foreign and domestic wire transfers, posting cash receipts, cash disbursements, bank and general ledger account reconciliations, bank and credit cards relationships.
Negotiated and closed agreements for refinancing $60 million committed & uncommitted credit facilities and implemented new treasury services end of day investment and loan sweep to significantly reduce costs.
Implemented technology solutions to gain efficiencies by reducing the number of depository banks and associated expenses.
Managed the transition of the cash management system from one bank to another, performed analyses for bids, and transferred bank accounts. Completed within one month.
Ensured efficient banking structure, on-line access and functionality, reporting and balance tracking to improve efficiency of the cash management workflow.
Acted as security administrator of corporate-wide user access capabilities, and supporting the security setup and system controls of multiple electronic banking systems.
Managed the annual reviews and audits of users and enterprise-wide bank accounts.
Negotiated pricing with banks, merchants cards, and vendors resulting on hundreds of thousands in savings.
Led project to auto feed monthly bank statements to GL for auto reconciling of cash & daily feed to reduce manual entries.
Negotiated settlements with 3rd party vendors on disputed accounts, contracts for software and consulting.
Implemented new accounts receivable processes and reduced outstanding AR.
Provided Ad-hoc financial analyses, in particular for profitability, pricing decisions, and contract negotiations.
Adecco Group North America May 2016 – Dec 2017
Sr. Financial Analyst - FP&A
Partnered with the executive team to develop support for strategic, business planning, reporting, process improvement and performance management practices to achieve the organization vision in profitability.
Delivered Weekly results including revenue & expenses, headcount, and top client performance by segments.
Delivered monthly financial guidance to senior leadership team including revenue and expenses projections.
Prepared monthly financial statements, MD&A, financial reporting, Investor relation, Ops review & BOD presentations.
Prepared monthly revenue forecast by clients and various Financial models in excel.
Developed detailed spreadsheets to identify trends and forecasts. Consolidated and analyzed monthly and quarterly results.
Analyzed and reported monthly financial results including monthly state of the business review with SVP of finance and Director of FP&A focusing on translating results into actionable items.
Established dashboards and KPI’s reporting to track operational improvements.
Assisted management to create a strategic plan, integrating revenue growth strategies for organic growth and acquisitions.
Managed the corporate monthly forecasting by collecting and assimilating information from the various department heads.
Prepared quarterly and annual presentations for earnings releases, investors relations, industry and competitors analyses.
Prepared monthly variance analysis for revenue, SG&A expenses, headcount and provide explanations for current trends and variances to plan and Forecast.
Managed the development and implementation of various processes improvement and procedures within the departments.
Managed the improvement and effectiveness of the financial processes and supporting financial systems within the organization including budgeting, forecasting, and financial reporting.
Gathered and presented data for business valuations, including data mining & analytics for global operational reporting.
Prepared weekly & monthly financial forecasts, sales projections and operational reporting.
Prepared Monthly and quarterly Profitability and ROS analysis by Client and Business Unit.
Prepared quarterly price volume analysis, bridge analysis, year over year analysis.
Supervised for two Financial Analysts demonstrating the ability to manage a skilled team in a fast-paced environment.
Partnered with consultants and financials system team to lead micro-strategy BI implementations process and testing.
Lead various projects to develop new metrics, KPIs, Segmentation and statistical accounts in Hyperion.
Developed new reports/Ad-Hoc in excel and assisted in various other finance and accounting functions as needed.
Advanced Disposal Services, Inc. Dec 2012 – Mar 2016
Lead Financial Planning & Analysis Analyst
Partnered with the executive team to develop support for strategic, business planning, reporting, process improvement and performance management practices to achieve the organization vision in price/performance.
Conducted cost analysis, partnering with the departments heads to identify & execute cost saving plan of $4.5M.
Developed detailed spreadsheets to identify trends and forecasts. Consolidate and analyze monthly and quarterly results.
Analyzed and reported monthly results including monthly state of the business review with VP of investor’s relations focusing on translating results into actionable items.
Established dashboards and KPI’s to track operational improvements and statistical accounts metric to improve performance.
Conducted in-depth cost structure analysis post acquisition to identify estimate synergy of $35M in EBITDA.
Assisted management to create a strategic plan, integrating revenue growth strategies for organic growth and acquisitions.
Prepared quarterly earnings releases and investors relations presentations.
Delivered monthly financial guidance to senior leadership team including revenue & SGA expenses projections.
Managed the improvement and effectiveness of the financial processes and supporting financial systems within the organization including budgeting, forecasting, and financial reporting.
Prepared monthly financial statements, MD&A, reporting, BOD, Banks & Rating Agency presentation packages.
Performed weekly data mining & analytics for global operational reporting.
Assisted in preparing, reviewing and managing quarterly and annual earnings releases, SEC filings (10-Q, 10-K & 8-K).
Assisted in preparing the quarterly financial reporting calendars.
Coordinated with internal and external teams to facilitate SEC filings, including compiling financial & non-financial data.
Assisted in preparing and analyzing consolidated financial statements and footnote disclosures for SEC filings, including completing disclosure checklists to ensure financial statements compliance.
Assisted in the implementation of new accounting standards and regulation changes to ensure compliance with US GAAP, SOX and SEC regulatory requirements.
Assisted internal and external auditors in audits relating questions to the financial statements.
Implemented new process improvements and streamlined financial tools.
Wrote scripts to extract required data in SQL queries using joins, grouping, aggregation, etc.
Maintained SQL scripts, indexes, and queries for data analysis and extraction.
Modified & maintained automated processes using SQL, Script Runner, Marco to query data for analysis & reporting.
Managed & Maintained Cubes, Dimensions and Links in IBM Cognos TM1.
Prepared monthly variance analysis and provide explanations for current trends and variances to plan and forecast.
Partnered with consultants to lead IBM Cognos TM1 implementations process, SOP, and COA mapping process.
Managed various projects to develop new metrics, KPIs, and statistical accounts in IBM Cognos TM1.
Developed and maintained multiple financial models, reports and all ad-hoc project requests in Excel and IBM Cognos TM1.
Fanatics, LLC Dec 2011 – Dec 2012
Lead Financial Analyst - FP&A
Managed monthly & quarterly financial analysis for current trends and variances to plan/budget.
Managed monthly financial reporting package for management reporting and external reporting.
Prepared monthly payroll journal entries and reports for all corporate departments.
Prepared monthly reconciliation schedules for PL, balance sheet, cash flow, free cash flow and equity statements.
Managed annual budget by collecting and assimilating info from the various functional department heads.
Prepared monthly and quarterly Management Discuss & Analysis, investors relations, industry and competitors analyses.
Assisted in preparing, reviewing and managing quarterly and annual earnings releases, SEC filings (10-Q, 10-K & 8-K).
Assisted in preparing the quarterly financial reporting calendars.
Coordinated with internal and external teams to facilitate SEC filings, including compiling financial & non-financial data.
Assisted in preparing and analyzing consolidated financial statements and footnote disclosures for SEC filings, including completing disclosure checklists to ensure financial statements compliance.
Assisted implementing of new accounting standards and regulation changes to ensure compliance with US GAAP, SOX and SEC regulatory requirements.
Assisted external auditors in audits relating questions to the financial statements.
Managed development and implementation of process improvement and streamlined financial tools within the department.
Managed the improvement and effectiveness of the financial processes and supporting financial systems within the organization including budgeting, forecasting, and financial reporting.
Wrote scripts to extract required data in SQL queries using joins, grouping, aggregation, etc.
Maintained SQL scripts, indexes, and queries for data analysis and extraction.
Modified & maintained automated processes using SQL, Script Runner, Marco to query data for analysis & reporting.
Managed team of analysts during the month end reporting, budgeting, forecasting process and all other Ad-Hoc requests.
Managed implementation/documentation of BI reporting tool.
Developed and maintained multiple financial models, reports and all ad-hoc requests in IBM Cognos TM1.
Managed three Financial Analysts demonstrating the ability to manage a skilled team in a fast-paced environment.
Managed testing of Microsoft Dynamics AX6 during implementation/migration of financial module. Tested internal controls.
Developed new reports and assisted in various finance and accounting functions as needed.
Signature Brands, LLC Apr 2011 – Dec 2011
Financial Analyst
Managed to compile and analyze database of historical freight data to monitor trends, identify cost improvement.
Provided logistics analysis and support for other functional areas.
Provided Third party Logistics cost saving analysis.
Tracked and Audited all Third Party Logistics and freight invoices for accuracy and proper charges.
Developed and communicated freight cost metrics by customer, by location, etc.
Managed Key Performance Indicators related to freight.
Prepared monthly freight accrual and journal entries.
Prepared customer and products profitability analysis and other Ad-Hoc projects as needed.
Acosta Sales & Marketing Co. Jul 2007 – Mar 2011
Revenue & Receivables Analyst
Managed large volume A/R reconciliation and presenting statistics updates in a concise and coherent manner.
Maintained exception, aging, month-to-date-cash, and days-to-pay reports.
Reviewed contracts to ensure payment based on correct commission rate and payment terms.
Prepared explaining variance analysis, actual vs. budget, and no / low cash received report.
Gathered SOX required paperwork & assisted auditors. Initiate collections on past due receivables amounts.
Ensured accuracy of Oracle AR in researching and resolving delinquencies.
Audited Top and middle-tier clients revenue, including whitespace audit project.
Educational Background
University of Ain Shams – Cairo, Egypt
Bachelor in Accounting & Minor in Business
Technical Skills and Training Background
Proficient utilization of various systems such as: PeopleSoft, Oracle Financials, Great Plans, MAS, JD Edwards, Microsoft Dynamics AX 2009 & 2012 R3. IBM Cognos Planning, IBM Cognos TM1 (Café, Perspectives, BI), Tableau, Hyperion Essbase, PeopleSoft nVision, Atlas Report Manager, SAP, MicroStrategy BI, FRX Report Manager, BI360 “One Stop Reporting”.
Microsoft Office Products including Advanced Excel
Contact this candidate