I will automate excel spreadsheets, calculators and dashboards

India

I speak English

An Actuarial Analyst enjoying Excel

Develop customized Excel-based financial solutions, including portfolio risk dashboards, options pricing and Greeks calculations, derivative hedging models, automated market data extraction tools, lar...
About this Gig

Is your Excel data messy, slow to update, or hard to explain to your team? I turn raw spreadsheets into clear answers, clean dashboards and reports you can present right away.


I'm an actuarial professional working in insurance and reinsurance, so I'm comfortable with financial, claims, reserving and reporting data, as well as general business data.


WHAT I DO

- Data cleaning and structuring

- Analysis with pivot tables, formulas and Power Query

- Charts and dashboards

- Insights summary and executive summary

- Custom Excel automation (macros, auto-refresh reports)


WHAT YOU GET

- An editable Excel file

- A short summary of findings and next steps

- Revisions until it's right (see packages)


HOW IT WORKS

1. Message me with your file and the question you want answered

2. I confirm scope and timeline

3. I deliver a draft, then revise


Your data stays confidential. NDA available.


Not sure which package fits? Message me before ordering.

Analysis type:

Statistical Analysis

•

Regression Analysis

Expertise:

Web analytics

•

Business Insights

•

Experiment design

Technology:

Excel

•

Power BI

•

Power Query

Programming language:

Python

•

R

•

SQL

•

VBA

My Portfolio