Banner Image

All Services

Business & Finance

MS Excel and financial models expert

$15/hr Starting at $80

I developed numerous user-friendly Excel-based models over the past 18 months. A few highlights are : 1. At Energy Intelligence, I am working on a tool that determines returns on an investing in energy efficiency (EE) upgrades. A part of my responsibility includes analyzing different EE financing strategies and determine optimum returns for a given site. I have included data on different financing strategies, potential government rebates, and operating models to optimize the application of this tool. Pivot tables, superior organization, and logical flow make this tool very easy to use. 2. At EnerNOC, I developed a budget tracking tool for the project managers that reduced tracking time by 40%. I interfaced this tool with three different platforms to import contractors costs, insight analyst costs, and project data. By using macros I could automate the tool. After a detailed research (mainly online) and attending a couple of seminars, I edited the macros to decrease the run time for this tool. 3. At GreyLock McKinnon Associates, I developed an excel-based model to calculate the profitability of investing in energy-efficient, waste-water treatment techniques. I performed technical and financial analysis of various combined heat and power (CHP) techniques and calculated ROI on all investments. The focus was to make a user-friendly and dynamic model to facilitate use by investors. I incorporated a few graphics and extrapolation to make the model visually appealing.

About

$15/hr Ongoing

Download Resume

I developed numerous user-friendly Excel-based models over the past 18 months. A few highlights are : 1. At Energy Intelligence, I am working on a tool that determines returns on an investing in energy efficiency (EE) upgrades. A part of my responsibility includes analyzing different EE financing strategies and determine optimum returns for a given site. I have included data on different financing strategies, potential government rebates, and operating models to optimize the application of this tool. Pivot tables, superior organization, and logical flow make this tool very easy to use. 2. At EnerNOC, I developed a budget tracking tool for the project managers that reduced tracking time by 40%. I interfaced this tool with three different platforms to import contractors costs, insight analyst costs, and project data. By using macros I could automate the tool. After a detailed research (mainly online) and attending a couple of seminars, I edited the macros to decrease the run time for this tool. 3. At GreyLock McKinnon Associates, I developed an excel-based model to calculate the profitability of investing in energy-efficient, waste-water treatment techniques. I performed technical and financial analysis of various combined heat and power (CHP) techniques and calculated ROI on all investments. The focus was to make a user-friendly and dynamic model to facilitate use by investors. I incorporated a few graphics and extrapolation to make the model visually appealing.

Skills & Expertise

AnalysisFinancial AnalysisMs ExcelResearch

0 Reviews

This Freelancer has not received any feedback.

Browse Similar Freelance Experts