Hello Bob,
Would you please advise if I can help you fulfil the objectives for financial modeling work.
I have been working for more than 6 years in an Insurance Company in Actuarial Department, joining Technical Section for Group Health Insurance Pricing and Group Life Pricing later as VBA Programmer and Actuarial Analyst.
I have recently designed for Swiss Consultancy a Net Present Value project evaluation tool that advises financial managers on the suitability of a project based on its NPV or Equivalent Cost. I am also familiar with and can develop financial derivative pricing including option pricing models.
In addition to above,
Came to design;
a) Group Health Insurance Pricing Program
b) Cash Value Illustration Program (Unit Linked Life Insurance)
c) Integrated IBM Lotus Notes with Excel for updating Excel based database
d) Developed Text to Excel converters
e) Designed and developed Claim amount analysis (Simulation based) tool for gauging average claim amount for a given malady or medical treatment. The tool compares existing data to a normal distribution through Normal Distribution graph based on the actual data mean and simulates random values for Normal Random Variable, in order to determine the claim amount distribution.
f) I have also worked in regression, Bayesian testing and Credibility Based Pricing
besides developing several User Defined Custom Functions, Add-Ins, and Text Stream Reader.
As an example of past work, please find attached
1- Amortization Calculator (Excel formula and some VBA involved) .
2 - Pivot Table & Power Point (Updates Pivot Table & Chart through Excel based data and Exports Chart output to Power Point) - (All VBA)
3- MaxIf (Custom function to allow for calculating criteria-based maximum value in a range - Excel's built-in functions do not offer this functionality)
Shall be glad to do a financial modeling project for you, if you might like me to.
Thanks and regards,
Kamran Hyder.