Quantitative Modelling Skills
• Advanced MS Excel (Macros, Vlookup, Pivot Tables and VBA)
• SPSS – Regression Analysis
• MS Office, SQL, OLAP, SQL Server, Oracle
Financial analysis
• Identification & reporting of key metrics
• Quantitative Methods and Statistical Analysis
• Financial Statement and Ratio Analysis
• Capital budgeting using discounted cash flow (NPV, IRR, WACC)
WORK EXPERIENCE
- Analyse and interpret monthly variances and trends between budgets, actual and prior results in developing projections and forecast ƒ
- Track and review gross and net sales including gross margins in producing forecasts and trend analysis on an on-going basis ƒ
- Provide financial support and analysis to Operations and Marketing areas for strategic business decisions and cost savings initiatives ƒ
- Create NPV, IRR, discount cash flow, and ROI models for evaluating financial implications of new products and investments, and provide recommendations to senior management
- Created an innovative client tailored narrative financial summary report
- Developed financial and valuation models to evaluate corporate and industry operating performance and efficiency
- Charted operational performance and efficiency data by industry, conducting in-depth financial analysis
TECHNICAL SKILLS
- Generated financial models and templates utilizing Excel spreadsheet, including Pivot Tables and Macros
- Prepared presentations utilizing PowerPoint and other Microsoft Office Applications