Financial Planning Analyst
Current Managed month-end closing, revenue forecasting, and annual budgeting reports for Photography Company by conducting variance and trend analysis using Excel (VLOOKUP, pivot tables). Automation and standardization of financial reporting process in Marco. Utilized SAP for journal entries and month-end result reviews, preparing adjusting entries as needed. Managed using SAP HANA, improving reporting management accuracy by 15%. Collaborated with sales & marketing teams to identify $500K inefficiencies in cost savings by analyzing actual and predicted revenue and cost data. Performed financial metrics analysis, incorporated assumptions into forecasting models, renegotiated shooting contracts, reduced 10% in material costs. Implemented customizable Tableau dashboards to report on key inventory KPIs (including net margins, gross profit, and current ratios) across all product lines. Leveraged advanced analytics to visualize client retention rate and sales growth rate, helping leadership make future decision. Conducted comprehensive ad-hoc analysis on profitable shooting portfolios and created monthly reporting packages for stakeholders. Delivered in-depth financial analysis, including product performance against targets and strategic recommendations, resulting in a 15% improvement in overall product profitability.
