Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Jery V. | Elance
 
176985602337900
Last Sign-in: Apr 24, 2015

Jery V.

Simplifying Finance and Accounting thru MS Excel.
   Indonesia
  |   Semarang, Semarang
  |  5:43 am Local Time

Verified Freelancer

Jery V.'s identity has been verified.  Learn More

Overview

Minimum Hourly Rate $7

A Certified Public Accountant in the Philippines with a Masters Degree in Business Administration major in Financial Management. Working about 4 years in the finance and accounting works.

Excel applications may cover Data Entry Automation, Accounting, Bookkeeping, Finance, Operations and Capital Budgeting, Financial Modeling, Management Advisory Services, Business Administration and Quantitative & Non-Quantitative Techniques in Business.

Years I spent with various discoveries to simplify and speed up things using MS Excel. I can even...

Read More »
Mar 17, 2015|Other - Finance & Mgmt|Private|Working
Aug 20, 2014|Financial Reporting|Private|Completed
|
4.9
Jun 29, 2014|Accounting|Private|Completed
|
5.0
Jun 15, 2014|Accounting|Private|Working

View All »

Portfolio

It can display list of your inventory according to Category and Subcategory.
Can add / edit questions saved within the workbook according to subject, course and group.
Can calculate interest payment and principal on loans with early or late funding date...

Skills (8)

Tested
Microsoft Excel
Microsoft Excel 2010 Test
My Score
avg
Accounting
Accounting Skills Test (Assets and Revenue)
My Score
avg
Bookkeeping
Book keeping Test
My Score
avg
Accounts Payable Management
Accounts Payable Test
My Score
avg
Accounts Receivable Management
Accounts Receivable Test
My Score
avg
Financial Statements
Components Of Financial Statement Test
My Score
avg
Auditing
Analytics
Analytical Skills Test
My Score
avg
Passed

Service Description

My services will mainly include solutions involving MS Excel such as:
- Excel VBA coding and macro programming
- Financial Modeling
- Financial Forecasting and Budgeting
- Interactive Data Analysis with automation
- Data Entry (using Excel as the program and the database at the same time)
- Complex excel formula creation, correction and analysis
- Provide Financial Analysis for past years' finances and other data
- Graphical and numerical analysis
- Specially customized Excel Applications (with and without Excel VBA integration)

Read More »

Employment

QBE Group Shared Services Company
Finance Services Senior Analyst
2014 - Present
PT Pacific Furniture
Accounting Head - Foreign Country Assignment
2013 - 2014
Pacific Traders & Manufacturing Corporation
Accounting Supervisor
2012 - 2014
Lincoln College of Global Standard Education Inc.
Accounting Head
2011 - 2012
University of Cebu - Banilad Campus
Accounting Professional Instructor
2010 - 2011
Bigfoot Studios Inc.
Senior Accountant
2009 - 2010
Luis Canete & Company, CPAs
External Audit Associate
2008 - 2009

Education

University of Cebu Graduate School
Masters in Business Administration - Financial Mgt
- 2013
University of Cebu - Main Campus
Bachelor of Science in Accountancy
2005 - 2008

Keywords

Excel VBA
Excel Automation
Finance
Accounting
Audit
Business Administration
Managerial Accounting
Management Advisory Services
Financial Modeling
Quantitative & Non-Quantitative Techniques in Business.
My Snapshot
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
7
5
15
Total
Milestones
Hours
Reviews
5.0
Recommend
Clients
Total
Repeat
Earnings
Private
Private
Total
Per Client
Identity
Username
Janje-Vhermosa
Type
Individual
Member Since
April 2013
Elance URL
Verifications
0
Groups
Jery V. | Elance

Jery V.