Roger Foster - Financial Analyst Resume Simple
SUMMARY
Financial analyst with over 10 years of experience in the financial services industry. Proven ability to analyze and analyze data and develop insightful solutions.
SKILLS
  • forecasting, publisher, modeling, financial modeling, forecasts, p l, analysis, sales and
  • modeling, access, budgeting, budget, forecasts, trend analysis, reports, procurement, consolidation, finance, financial modeling, operations, financial reports, analysis, excel, p l
WORK EXPERIENCES
  • 2017-12-252017-12-25

    Financial Analyst

    Macy's Department Store

    • Provide financial modeling and analysis to support the business plan and forecasting. Create and maintain monthly forecasts for the company.
    • Prepare P&L statements for sales and service departments using MS Publisher.com. (Salesforce). Manage and maintain the company's financial database.
    • Analyze and report monthly sales, gross margin, and profit margins for all business units. Provide variance explanations for variances.
    • Prepare monthly financial package for the Board of Directors and executive Committee. Review and analyze all variances from plan and prior year.
    • Prepare and analyze monthly financial reports for the senior management. This includes the preparation of the annual budget and quarterly forecasts.
    • Prepare and analyze monthly sales reports for the sales team and the VP of Finance. Also, provide analysis of the revenue and expenses of the company.
  • 2017-12-252017-12-25

    Financial Analyst

    Volkswagen Group of America

    • Prepare financial reports, forecasts, budgeting, and forecasting for the R&D department. Responsible for the annual budget process for the division.
    • Responsible for monthly forecasting, budgeting, and variance analysis for the P&L and R&D operations.
    • Developed financial modeling tools to support the budgeting process for the supply chain Finance department. This tool was used to create a more efficient and automated consolidation system for the entire organization.
    • Develop and maintain a Microsoft Access budgeting tool to track and forecast future costs and provide trend analysis to the procurement team.
    • Prepared monthly financial reports for the Board of Directors and executive Committee. Presented and explained variances to budget and forecast.
    • Develop and maintain Excel models to track and forecast revenue and expenses for the business unit. Analyze and report on key performance indicators.