A highly motivated, resourceful, and ambitious professional with over 4+ years of experience in:

 Excel modeling and Data analysis:

• Create tables and variance reports,
• Experienced in manipulating datasets to extract insights and support decision-making,
• Link and manipulate multiple Excel sheets, 
• Import, and clean data in Excel,
• Advance Microsoft Excel knowledge, including but not limited to building and manipulating Pivot tables, Power Pivot, and Formulas such as Vlookup, Hlookup, concatenate, index, match, etc.
• Create insightful reports and dashboards with charts, tables, and summary statistics. 

Financial modeling and forecasting: 

• Building 3 statement models,
• Use advanced Excel formulas and functions to make robust and dynamic models.
• Perform scenario analysis, sensitivity analysis
• Build DCF model  in Excel and  calculate a firm’s weighted average cost of capital,
• Financial analysis including ratios, rates of return, risk assessment, and more
• Revenue variance analysis,
• Price and volume variance analysis,
• Short-term to long-term projections of customer demand (kWh) that depend on the insight gained from data analysis and what is currently happening in the market, for example, fuel cost expectations and the uptake of energy solutions.

Statistical analysis. 

• Timeseries and Regression analysis,
• Forecasting 
• Calculate statistical parameters such as correlations, covariances, and other summary statistics