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:
(4.78)
8 feedbacks
(4.69)
14 feedbacks
Hours:
25
428
Assignments:
6
17
See all Work History & Feedback
Location:
Cagayan de Oro, Philippines (GMT+08:00)
English Skills:
(self-assessed)
5.0
Member Since:
January 7, 2008
Last Worked:
November 15, 2009
oDesk Ready:
Yes
Related links:
Trends for
Online Assistants
Trends for
Data Entry Professionals
Trends for
Visual Basic Programmers
Trends for
Excel Consultants
Trends for
Access Consultants
Carlo E.
-
"
VB6, Access, Excel: VBA, Excel Driver-SQL, Automation, Add-Ins
-
Freelance
Programmer / Developer
,
Philippines
"
Permalink :
$13.33
/hr
Overview
Résumé
Work History & Feedback (17)
Tests (21)
Portfolio (6)
My main objective is to help my buyers, whether as manager or administrator of projects, with clerical tasks ( using programming/accounting and what not combined), decision making. <br /><br />All you need is what I am: Excellent Accountant/Bookkeeper, Good Analyst, Good Programmer with 7 years experience. <br /><br />I am currently attending accounting seminars in the Philippines on IAS and IFRS and Philippine Taxes. I am also currently improving my skills in...
My main objective is to help my buyers, whether as manager or administrator of projects, with clerical tasks ( using programming/accounting and what not combined), decision making.
All you need is what I am: Excellent Accountant/Bookkeeper, Good Analyst, Good Programmer with 7 years experience.
I am currently attending accounting seminars in the Philippines on IAS and IFRS and Philippine Taxes. I am also currently improving my skills in programming. I also have experience doing jobs related to US Payroll Withholding Tax and Filling up Income Tax Returns for Individuals and Sole Proprietorship.
more
less
See All Work History & Feedback
(17 items, with Feedback)
Recent Work History & Feedback
Buyer ID
From/To
Job Title
Paid
Feedback
79404
11/2009 - 11/2009
Excel Programmer
$72 (4.33 hrs @ $16.67/hr)
3.5 Unfortunately Carlo fell ill and the timeframe for this job was unable to be achieved. Carlo is a lovely person and communicates well. Given I ende...
L
Provider-to-Buyer Feedback:
4.0
29657
06/2009 - 11/2009
excel add ons
$56 (fixed-price)
5.0 Carlo is a great guy, did a great job quick, i was really happy would give more work anytime 100% result
L
Provider-to-Buyer Feedback:
5.0
60755
05/2009 - 10/2009
Data Entry
$70 (13 hrs @ $5.56/hr)
5.0
L
Provider-to-Buyer Feedback:
5.0
100079
06/2009 - 08/2009
Excel-based financial market indicators
$189 (fixed-price)
5.0 Carlo did an excellent job on this project. He learned very quickly, was great at staying in touch and keeping me up to date on his progress, and d...
L
Provider-to-Buyer Feedback:
5.0
78395
07/2009 - 07/2009
Balanced scorecard KPI monthly report on Excel
$14 (0.50 hrs @ $27.78/hr)
4.0
L
Provider-to-Buyer Feedback:
5.0
See All Tests Taken
(21 items)
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
Accounts Receivable Test
4.00
99%
TOP 10%
2nd Place!
02/22/2009
33 min
Accounting Skills Test (Cash Flow)
4.00
98%
TOP 10%
3rd Place!
02/19/2009
28 min
Accounts Payable Test
3.75
98%
TOP 10%
02/24/2009
39 min
MS Excel 2007 Test
3.40
94%
TOP 10%
10/03/2008
40 min
Accounting Principles Test
3.25
92%
TOP 10%
02/19/2009
36 min
Recent Candidacies
Job Opening Title
Initiated By
Date
Excel project
Provider
November 21, 2009
Property Specialist
Provider
November 20, 2009
Bulding a Spreadsheet
Provider
November 20, 2009
Excel VBA Programmer with strong maths background
Provider
November 19, 2009
Excel Macros
Provider
November 19, 2009
Job Category Interests
Software Development
Desktop Applications
Application Interface Design
Other - Software Development
Networking & Information Systems
DBA - Database Administration
Administrative Support
Data Entry
Personal Assistant
Web Research
Other - Administrative Support
Business Services
Accounting
Bookkeeping
HR / Payroll
Financial Services & Planning
Payment Processing
Statistical Analysis
Other - Business Services
Skills
Skill
Experience
Level
Last Used
Description
Accounting
11 yrs
5.0
2009
I have already stated my experience or employments.
EXCEL-VBA
4 yrs
5.0
2009
4-5 years Experience of Excel-VBA(2 here in Odesk).
Latest Skills:
Program involving Shell Functions:
I created an Excel-Program which calls an Exe file that automatically displays data of the said Excel-Program. To wit: User highlights a range, and with a key stroke, the Exe pops up with the data.
Program involving the Excel-Driver:
Sometimes accessing ranges of an Excel Sheet takes time; hence, the Excel Driver. With this driver, A sheet range can be considered a database; hence, can be manipulated through SQL statements. This is very good in populating another sheet and list boxes.
Program involving Pivot Tables Automation:
This is self-explanatory.
Program involving Excel to Powerpoint/Word automation:
This is self-explanatory.
Program involving Chart Manipulations using VBA:
Some Charts need new data plus the legends to reflect the criteria used to refresh the data for the said Charts. Hence, the Chart Objects are accessed here through VBA.
My Old Skills:
My accounting knowledge is a very good compliment with my VBA Skills.
SKILLS:
Job Title: Update Member's Ledger
This application allows a clerk to update each member's ledger.
It includes generation of a deficit report for delinquent member.
Job Titile: Ultimate Payroll
Computes Payroll and automates deduction computations.
Job Title: Accounting Program
provides Trial Balance, General Ledger, Balance Sheet, Income Statement, Cash Flow. I used a General Journal which could accept any new customized Subsidiary Ledgers. I used here MS Query and SQL.
In addition, to the given programs I have developed. I could improvise solutions to any Accounting Related Problems.
MYOB
1 yrs
5.0
2009
I am actually into Accounting Applications as of late. It's not a problem for me because I am an accountant and a programmer rolled into one. I am actually putting Quickbooks and MYOB under my repertoire.
Peachtree
3 yrs
3.0
2008
I have a little hands on with PeachTree, but still I have a working knowledge with it. It's just that Excel was more needed when I was still an employee(accountant, auditor etc.). But I could raise the level of my mastery with Peachtree if the need arises.
Quickbooks and QODBC
1 yrs
5.0
2009
I have studied Quickbooks For Dummies, and I have set up a Quickbooks experimentally in my PC and I have one ongoing project locally about Quickbooks with QODBC and Visual Basic 6.
ALSO I HAVE DISCOVERED QODBC. This is the driver used to connect using Excel to the Quickbook tables and perform queries there.
US Payroll Taxes and Filling Up of Income Tax...
1 yrs
4.0
2009
I have done an Excel-VBA project. The purpose of which is to compute FICAÂ taxes, State Taxes, Fed Taxes, City Taxes, School Taxes.
I also have a client which I fill up the Income Tax Returns for her aside from bookkeeping.
Visual Basic
7 yrs
4.0
2009
Creating Data Environment
Data Report
SQL
Creating User Interface using:
Datagrid Control
Texbox Control
FlexGrid
ADO Control
Listbox Control
Certifications
Date Earned
Name
Score
Percentile
Organization
Description
1998
Certified Public Accountant [0100785]
PRC
I passed this exam just 6 months after I have graduated from College. The tests include Accounting Theory, Auditing Theory, Auditing Problems, Practical Accounting 1, Practical Accounting 2, Philippine Tax and Commercial Laws, Managerial Accounting
Employment History
From
To
Company
Title/Role
Description
06/2006
08/2006
Lao Accounting Office
Independent Contractor / Independent Contributor
Responsibility:
Audit a Client Foundation
Understand its system flows
Suggest improved system flow
Make Audit Report
04/2005
09/2005
Limketkai Manufacturing Corporation
Financial Accountant / Independent Contributor
Responsibility:
Using Excel VBA, I did:
VAT monthly remittances
VAT quarterly reporting
Creditable Withholding tax monthly remittances
Creditable Withholding tax quarterly remittances
Income Statement
Balance Sheet
Cash Flow Statement
Closing and Adjusting Entries(Arranging and Customing Data for Uploading to Database)
11/2003
09/2004
Mindanao Polytechnic State College-Employees Multi-Purpose Cooperative
Clerk / Independent Contributor
Responsibility:
Update Members' Ledgers( I used Excel-VBA at this point)
Prepare Deficit Report( I used Excel-VBA at this point)
01/2000
05/2001
Pryce Gases Incorporated
Internal Auditor / Independent Contributor
Responsibility:
Check Sales Centers Internal Control
Check and Reconcile Inventory, AP, AR
Check Fund Transfers and Cash Sales
Confirmation of Customer Accounts
Other Non-routinary jobs(i.e. checking computations of certain company incentives)
Make Audit Report
01/1999
05/1999
SGV & CO.
Staff Auditor / Independent Contributor
Responsibility:
Vouching of Documents
Testing Reasonableness of Accounts
Other Experience
IFRS SEMINAR MODULE 1
The seminar involves the interpretation on IAS's and IFRS's. What pronouncements should be followed in case of conflicts. In short, this is a sort of an overview about Accounting Pronouncements in general.
IFRS SEMINAR MODULE 2
The topics tackled here include: IAS 2 , IAS 8 , IAS 18, IAS 33 and PFRS 5.
Education
From
To
School
Degree
Area of Study
Description
06/1994
03/1998
San Beda College
Bachelors
Accountancy
My Basic Accounting Grade averaged 1.5 or 93. My Electronic Spreadsheet (Computer 2) grade is also 1.5. My Grade Point Average however is 2.24. Some of my lowest grades are Commercial Laws, and some Major Accounting Subjects (where my professors' happiness is hinged on seeing their students suffer and fail) The average for these subjects is at 2.5 ( 81 to 83). My Tax grade however is 2 (85).
My best grades are with Psychology, Sociology, Theology and any of those Social Sciences Subjects.. I could say I averaged 1.5 here. I was serious in programming way back then, but object oriented programming wasn't that popular then... when It came around in the 2000's IÂ never wasted seconds to study it.
06/1990
03/1994
Saint Columban College
Other
High School
I was a 4rth honorable mention in first year High School. I got more into Athletics then because it was where my heart was during that time;Nevertheless, I have learned so much from it and is happy about it -- HS taught me how to think out of the box, It shows now... I am an accountant/programmer now and a lawyer (to specialize on Philippine Tax) someday.
My achievements in High School:
4th place - Annual Pagadian City (DECS) History Quiz Bee(1991)
3rd place - Sportswriting Category (1992)
Champions -- Under 14 Milo Basketball team (Played Point Guard)
Runner Up -- Soccer, Division Meet 1991
Champions -- Soccer, Division Meet 1992 (Played Right Full Back)
Runner UP -- Basketball, Division Meet 1993 (Played Point Guard, Center)
I read so much about Sports Stories during High School, that even though I wasn't exemplary in the academics during that time, I have sharpened my English Skills particularly my comprehension.
I have always searched my heart as to what makes me happy. Because of it, I am always at my best in what I do. Right now, I am happy with Odesk, and I am always doing my best for my buyers.
06/1984
03/1990
Saint Columban College
Other
Elementary
I was a consistent Top 5 honor student of my class. I graduated School Salutatorian of my class.
I already played soccer, baseball, and basketball since my elementary days.
My first hit during the intramurals(grade 5) was a home run. I got a home run not because I hit the ball so hard, but my counterparts didn't know how to catch the ball. I just continued running from base to base knowing that they could not tug me out.
My game IQ was way ahead of my peers at that point in time.
Project Title:
Search Amounts, Words and Highlight&Delete and Word Automation Reporting
Attachment:
SEARCH AMOUNT.doc - 68KB
Completed:
05/19/2008
Category:
Software Development > Application Interface Design
URL:
none
Description:
This is a simple project but takes a lot of coding especially the timing of the processes. This involves searching, selecting and highlighting desired data.
Then Word Automation highlights this project too.
Project Title:
THE INCOME STATEMENT CONSOLIDATOR
Attachment:
THE INCOME STATEMENT CONSOLIDATOR MANUAL.doc - 187KB
Completed:
05/19/2008
Category:
Software Development > Other - Software Development
URL:
none
Description:
The INCOME STATEMENT CONSOLIDATOR
This project is about consolidating Income Statements from Quickbooks. The need for this application is to summarize Income Statements with three(3) new criteria groupings for managerial reporting purposes.
Project Title:
REAL ESTATE QUESTIONAIRE
Attachment:
REAL ESTATE QUESTIONAIRE(using VBA).doc - 161.5KB
Completed:
03/19/2008
Category:
Software Development > Other - Software Development
URL:
none
Description:
This is a simple questionaire that simply shows whether a client is qualified for a certain option.
Project Title:
A Tally Application with One-CLick Saving Feature
Attachment:
ADDITIONAL REMINDERS AND INTERFACE2.doc - 71.5KB
Completed:
02/29/2008
Category:
Software Development > Other - Software Development
URL:
none
Description:
This is actually the instructions I gave to my client.Â
The problem here lies in the fact that there are approximately 180 rows and about 10 columns at least to be process. A data is downloaded from a website, but since "x" are used instead of numeric data in the tabulation, It cannot be changed conveniently.
Â
So a program is needed to change all the x's and convert them to one, then creating a total automatically and separately for the meals and for the drinks with formulas(autosum) generated automatically for each.Â
Project Title:
INVENTORY MATCHING
Attachment:
INVENTORYMATCH and ACTION.doc - 64KB
Completed:
01/21/2008
Category:
Software Development > Desktop Applications
URL:
none
Description:
The program simply matches the corresponding product ID's of each of the two databases with one another and thereby generating results(see attachment).
Project Title:
THE GENERAL JOURNAL
Attachment:
THE GENERAL JOURNAL.doc - 78KB
Completed:
01/16/2008
Category:
Administrative Support > Data Entry
URL:
none
Description:
Hello.
The program summarizes accounting entries into a journal. The journal data will be used by the General Ledger Report summarizing the each account.
I was actually creating it for a small cooperative (a loose corporation in the Philippines) who can't afford an accounting software.
Â
Hourly Assignment History
Buyer ID
From/To
Job Title
Paid
Feedback
79404
11/2009 - 11/2009
Excel Programmer
$72 (4.33 hrs @ $16.67/hr)
3.5 Unfortunately Carlo fell ill and the timeframe for this job was unable to be achieved. Carlo is a lovely person and communicates well. Given I ende...
L
Provider-to-Buyer Feedback:
4.0
60755
05/2009 - 10/2009
Data Entry
$70 (13 hrs @ $5.56/hr)
5.0
L
Provider-to-Buyer Feedback:
5.0
78395
07/2009 - 07/2009
Balanced scorecard KPI monthly report on Excel
$14 (0.50 hrs @ $27.78/hr)
4.0
L
Provider-to-Buyer Feedback:
5.0
100571
06/2009 - 06/2009
Excel questionnaire template
$83 (5.00 hrs @ $16.67/hr)
3.3
L
Provider-to-Buyer Feedback:
5.0
61724
05/2009 - 05/2009
Simple & Quick Excel VBA Automation Spreadsheet
$50 (3.00 hrs @ $16.67/hr)
5.0 This was my 2nd job with Carlo and I am ready to hire him for #3! Thanks again for all of your efforts!
L
Provider-to-Buyer Feedback:
5.0
60755
10/2008 - 05/2009
Data Entry
$536 (161 hrs @ $3.33/hr)
5.0
L
Provider-to-Buyer Feedback:
5.0
61724
04/2009 - 04/2009
Simple Excel 2003 VBA spreadsheet macro
$22 (1.33 hrs @ $16.67/hr)
5.0 Great job from you, I received exactly what I needed to get finished!
L
Provider-to-Buyer Feedback:
5.0
81507
03/2009 - 03/2009
Excel template design
$167 (10.00 hrs @ $16.67/hr)
4.2 Carlo is a willing and able contractor with a great attitude, and good communication skills. The only reason we did not chose him as our main...
L
Provider-to-Buyer Feedback:
5.0
67123
12/2008 - 01/2009
excel macro/vba programmer
$283 (32 hrs @ $8.89/hr)
5.0 Carlo really went the extra mile to figure out how to do this assignment. He always maintained a great attitude no matter how many times we h...
L
Provider-to-Buyer Feedback:
5.0
54471
10/2008 - 11/2008
EXCEL US tax withholdings
$551 (62 hrs @ $8.89/hr)
No feedback given
L
Provider-to-Buyer Feedback:
5.0
22577
11/2008 - 11/2008
Senior Finance Expert with Top-Level MS Excel Skill
$34 (3.83 hrs @ $8.89/hr)
No feedback given
L
Provider-to-Buyer Feedback:
5.0
56986
09/2008 - 10/2008
EXCEL 2007, DEVELOPMENT OF DATA ENTRY, EXCEL SORTING, STATATICIAN/MATHEMATICIAN INTERPRETATION, ACCOUNTING
$313 (35 hrs @ $8.89/hr)
5.0 Carlo, Did a terrific Job! We worked Closely on the project and he delivered a "Supurb' VBA Product...I look foward to our next project together soon.
L
Provider-to-Buyer Feedback:
5.0
46114
06/2008 - 08/2008
Senior Excel & VBA Developer
$821 (92 hrs @ $8.89/hr)
4.5 Did a fine job
L
Provider-to-Buyer Feedback:
5.0
Fixed-Price Assignment History
Buyer ID
From/To
Job Title
Paid
Feedback
29657
06/2009 - 11/2009
excel add ons
$56
5.0 Carlo is a great guy, did a great job quick, i was really happy would give more work anytime 100% result
L
Provider-to-Buyer Feedback:
5.0
100079
06/2009 - 08/2009
Excel-based financial market indicators
$189
5.0 Carlo did an excellent job on this project. He learned very quickly, was great at staying in touch and keeping me up to date on his progress, and d...
L
Provider-to-Buyer Feedback:
5.0
94499
05/2009 - 05/2009
Experienced VB Programmer
$148
5.0
L
Provider-to-Buyer Feedback:
5.0
48169
12/2008 - 01/2009
Excel Proficient GURU
$33
No feedback given
L
Provider-to-Buyer Feedback:
5.0
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
Accounts Receivable Test
4.00
99%
TOP 10%
2nd Place!
02/22/2009
33 min
Accounting Skills Test (Cash Flow)
4.00
98%
TOP 10%
3rd Place!
02/19/2009
28 min
Accounts Payable Test
3.75
98%
TOP 10%
02/24/2009
39 min
MS Excel 2007 Test
3.40
94%
TOP 10%
10/03/2008
40 min
Accounting Principles Test
3.25
92%
TOP 10%
02/19/2009
36 min
Accounting Skills Test (Assets and Revenue)
3.25
88%
TOP 20%
02/20/2009
40 min
MS Excel 2003 Test
3.20
87%
TOP 20%
05/18/2008
39 min
MS Excel 2000 Test
3.35
84%
TOP 20%
05/18/2008
20 min
U.S. English Basic Skills Test
4.50
81%
TOP 20%
01/07/2008
22 min
Technical Writing Skills Certification
3.60
81%
TOP 20%
01/17/2008
23 min
MS Word 2003 Test
3.60
81%
TOP 20%
06/05/2008
39 min
Book keeping Test
3.50
80%
TOP 20%
02/19/2009
40 min
Accounting Skills Test (Securities, Derivatives and Investments)
2.50
79%
02/25/2009
38 min
Email Etiquette Certification
4.00
76%
02/28/2009
25 min
MS Access 2007 Test
3.40
75%
01/08/2008
33 min
Management Skills Test
2.75
69%
02/28/2009
31 min
Visual Basic 6 Test
2.50
49%
05/18/2008
24 min
U.S. English Chicago Style Editing Skills Test (For Writing Professionals)
3.40
48%
01/21/2008
23 min
Office Skills Test
3.40
47%
02/27/2009
25 min
Quick Books Pro 2008 Test
2.60
47%
03/18/2009
26 min
oDesk Readiness Test for Independent Contractors and Company Managers
06/02/2008
14 min
