Javascript must be enabled to properly navigate this site.
Home
Why oDesk
Tour
Who Uses oDesk
FAQs
Press
Find Providers & Jobs
Find Providers
Find Jobs
Tests
Trends
oConomy
Groups
My Jobs
Openings
Candidacies
Assignments
Post a Job
Manage & Work
Team Room
Work Diary
Reports
Team Admin
Staffing Console
Payments
Financial Activity
Payment Methods
Withdrawals
Referrals
Sign In
or
Create an Account
Community
What's New
Forums
Blog
Store
?
Help
Help Center
A-Z Index
Resources & Downloads
Contact Support
Providers
Jobs
Tests
Community
Help
Find Providers
Find Jobs
Tests
Trends
oConomy
Groups
Share
Flag as Inappropriate
Last 6 mos.
All-time
Feedback:
none
(5.00)
1 feedbacks
Hours:
0
0
Assignments:
0
1
See all Work History & Feedback
Location:
Ajax, Canada (GMT-05:00)
English Skills:
(self-assessed)
5.0
Member Since:
July 26, 2008
Last Worked:
May 18, 2009
oDesk Ready:
Yes
Related links:
Trends for
Online Assistants
Trends for
Data Entry Professionals
Trends for
Excel Consultants
John P.
-
"
MS Excel expert
-
Freelance
Consultant
,
Canada
"
Permalink :
$16.67
/hr
Overview
Résumé
Work History & Feedback (1)
Tests (7)
Portfolio (0)
I have over 14 years of experience in the field of actuarial science, focusing on valuation of liabilities, product development, actuarial studies, financial projections and related functions. I'm seeking opportunities where my data analysis and detail-oriented skills can be utilized. I am quick to learn any software as evidenced by my current and previous employments which use company-developed software for actuarial valuations. I have also gained an expertise in Microsoft Excel from my work...
I have over 14 years of experience in the field of actuarial science, focusing on valuation of liabilities, product development, actuarial studies, financial projections and related functions. I'm seeking opportunities where my data analysis and detail-oriented skills can be utilized. I am quick to learn any software as evidenced by my current and previous employments which use company-developed software for actuarial valuations. I have also gained an expertise in Microsoft Excel from my work experience.
more
less
See All Work History & Feedback
(1 items, with Feedback)
Recent Work History & Feedback
Buyer ID
From/To
Job Title
Paid
Feedback
61724
05/2009 - 05/2009
Simple Excel 2003 VBA Automation & Clean-up
$50 (fixed-price)
5.0 John was amazing... he reached a tight deadline at the last minute and producd quality results. I will surely hire him again.
L
Provider-to-Buyer Feedback:
5.0
See All Tests Taken
(7 items)
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
MS Excel 2003 Test
4.80
100%
TOP 10%
2nd Place!
09/27/2008
17 min
MS Word 2003 Test
4.50
99%
TOP 10%
09/27/2008
20 min
MS Excel 2007 Test
3.90
98%
TOP 10%
05/14/2009
37 min
MS Excel 2000 Test
4.00
98%
TOP 10%
07/26/2008
15 min
Office Skills Test
4.40
96%
TOP 10%
09/27/2008
10 min
Job Category Interests
Software Development
Desktop Applications
Administrative Support
Web Research
Other - Administrative Support
Skills
Skill
Experience
Level
Last Used
Description
FoxPro
10 yrs
3.0
2005
Used FoxBase/FoxPro/Visual FoxPro for database management and manipulations for input in the actuarial valuation software.
Microsoft Excel
14 yrs
5.0
2009
I have gained advanced MS Excel skills with complex data calculations including macro programming
Certifications
Date Earned
Name
Score
Percentile
Organization
Description
No Certifications
Employment History
From
To
Company
Title/Role
Description
01/2006
Present
Mercer
Retirement Analyst / Independent Contributor
Mercer (http://www.mercer.ca) is a consulting company specializing in retirement pension, investment, and health and benefits. I am a team member of the Retirement Service Center operating out of Toronto, ON.
Responsibilities include:
- Provide technical support to consultants in the conduct of pension valuations for clients in Canada and the U.S.
- Perform costings and individual benefit calculations for clients in Canada
11/1994
05/2005
PhilamPlans, Inc.
Assistant Manager, Actuarial Valuation Department / Team Lead
PhilamPlans, Inc. is a pre-need company affiliated with the Philippine American Life Insurance Company. I managed a team in the Actuarial Valuation and Research Department.
Responsibilities included:
- Supervised the conduct of monthly valuation of liabilities, product development and actuarial studies
- Conducted profit and loss studies, financial projections and assisted in the development of a new agency compensation program
Education
From
To
School
Degree
Area of Study
Description
06/1994
03/1996
University of the Philippines - Diliman
Masters
Applied Mathematics
05/1990
12/1993
De La Salle University
Bachelors
Applied Mathematics, Major in Actuarial Science/Statistics
No items in portfolio
Hourly Assignment History
Buyer ID
From/To
Job Title
Paid
Feedback
Hourly Assignment History is empty
Fixed-Price Assignment History
Buyer ID
From/To
Job Title
Paid
Feedback
61724
05/2009 - 05/2009
Simple Excel 2003 VBA Automation & Clean-up
$50
5.0 John was amazing... he reached a tight deadline at the last minute and producd quality results. I will surely hire him again.
L
Provider-to-Buyer Feedback:
5.0
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
MS Excel 2003 Test
4.80
100%
TOP 10%
2nd Place!
09/27/2008
17 min
MS Word 2003 Test
4.50
99%
TOP 10%
09/27/2008
20 min
MS Excel 2007 Test
3.90
98%
TOP 10%
05/14/2009
37 min
MS Excel 2000 Test
4.00
98%
TOP 10%
07/26/2008
15 min
Office Skills Test
4.40
96%
TOP 10%
09/27/2008
10 min
MS Word 2007 Test
3.60
94%
TOP 10%
04/18/2009
36 min
oDesk Readiness Test for Independent Contractors and Company Managers
07/26/2008
6 min