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.80)
3 feedbacks
(4.80)
3 feedbacks
Hours:
11
11
Assignments:
5
5
See all Work History & Feedback
Location:
Memphis, United States (GMT-06:00)
English Skills:
(self-assessed)
5.0
Member Since:
September 15, 2009
Last Worked:
November 21, 2009
oDesk Ready:
Yes
Related links:
Trends for
Visual Basic Programmers
Trends for
Access Consultants
Marcus Lewis
-
"
VBA Programming, HTML Scraping, Excel Modeling, SQL, Financial Markets
-
Freelance
Programmer / Developer
,
United States
"
Permalink :
Overview
Résumé
Work History & Feedback (5)
Tests (6)
Portfolio (3)
Over the last 8 years, I have developed a wide range of spreadsheet modeling applications and database/web mining tools utilizing SQL and VBA for Applications. My core competencies are in the manipulation and development of automated spreadsheets and database applications through the use of VBA programming. I am seeking opportunities to utlilize my skill set to help you retrieve, categorize and submit information more efficiently while eliminating errors. I also have experience in the...
Over the last 8 years, I have developed a wide range of spreadsheet modeling applications and database/web mining tools utilizing SQL and VBA for Applications. My core competencies are in the manipulation and development of automated spreadsheets and database applications through the use of VBA programming. I am seeking opportunities to utlilize my skill set to help you retrieve, categorize and submit information more efficiently while eliminating errors.
I also have experience in the following areas: SQL data mining, automated HTML scraping, VBA for application, and Microsoft Office applications.
more
less
See All Work History & Feedback
(5 items, with Feedback)
Recent Work History & Feedback
Buyer ID
From/To
Job Title
Hours
Feedback
61422
11/2009 - Present
Creating an Excel Data coding interface
7 hrs
Job in progress
112516
11/2009 - 11/2009
Computer Programing - Financial Modeling
—
5.0 Marcus did a great job on this assignment and was very capable, professional, responsive and showed great ability. I will work with Marcus in the ...
L
Provider-to-Buyer Feedback:
5.0
104399
10/2009 - 10/2009
Data Scrape Project - Text and Photos
4 hrs
No feedback given
L
Provider-to-Buyer Feedback:
No feedback given
96712
10/2009 - 10/2009
Need an excel scheduling program: only apply if you know excel and algorithms/m
ath
—
4.7 Excellent work. Knows what he is doing and is keen to ask questions to make sure everything is clear. Love to work with him again!
L
Provider-to-Buyer Feedback:
5.0
125781
09/2009 - 09/2009
data entry
—
5.0 Marcus was my first hire on odesk and it could not have gone much better. If you are looking for someone to do any work on excel spreadsheets...
L
Provider-to-Buyer Feedback:
5.0
See All Tests Taken
(6 items)
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
MS Access 2003 Test
3.75
92%
TOP 10%
11/07/2009
20 min
MS Excel 2003 Test
3.10
85%
TOP 20%
09/26/2009
29 min
Stock Trading Test
4.10
66%
11/07/2009
17 min
U.S. English Basic Skills Test
4.00
55%
09/20/2009
23 min
Visual Basic 6 Test
2.50
49%
11/11/2009
32 min
Recent Candidacies
Job Opening Title
Initiated By
Date
Web Programming/Data Scrape
Provider
November 22, 2009
Outlook VBA Programmer
Provider
November 17, 2009
Develop excel pivottable worksheet and data importing workflow
Provider
November 16, 2009
VBA development for Excel quote sheet
Buyer
November 12, 2009
Excel Scripting Expert
Provider
November 5, 2009
Excel Macro - Calculate Number of rows in days for data analysis
Provider
November 4, 2009
Process of a CSV File
Provider
October 31, 2009
Excel Macro Developer
Provider
October 31, 2009
Job Category Interests
Web Development
Other - Web Development
Software Development
Desktop Applications
Scripts & Utilities
Other - Software Development
Networking & Information Systems
DBA - Database Administration
Other - Networking & Information Systems
Business Services
Financial Services & Planning
Statistical Analysis
Other - Business Services
Skills
Skill
Experience
Level
Last Used
Description
SQL, HTML scraping, VBA for Applications
8 yrs
5.0
2009
Developed an VBA script to automate the procurement of contact information (over 1,000 names/phone numbers/addresses) from a website search engine to an Excel spreadsheet for use by sales and marketing team.
Developed a VBA script to extract numerical data from a flash application and import into an Excel spreadsheet.
Designed custom VBA/HTML programming to connect excel spreadsheets to web pages for ongoing retrieval of data as it is updated.
Certifications
Date Earned
Name
Score
Percentile
Organization
Description
No Certifications
Employment History
From
To
Company
Title/Role
Description
01/2007
Present
Diversified Trust Company
Vice President / Manager
Diversified Trust is an employee-owned comprehensive wealth management firm based in the Southeast with $3 billion of client assets under management. Our clients include individuals, multi-generational families, foundations, endowments and retirement plans.
05/2003
01/2007
Securities Trading Broker/Dealer
Vice President / Manager
Founded in 1933, Stephens Inc. is a privately-held, independent financial services firm focused on building value for companies, state and local governments, institutions and high-net-worth investors.
Education
From
To
School
Degree
Area of Study
Description
08/2001
05/2003
Vanderbilt University
Masters
MBA - Finance and Information Systems
08/1993
05/1997
Vanderbilt University
Bachelors
Mechanical Engineering
Minor in Computer Science
Project Title:
Flash program extraction
Attachment:
none
Completed:
09/30/2009
Category:
Software Development > Scripts & Utilities
URL:
http://www.wordcount.org
Description:
Developed script to extract 86,800 records from the embedded flash module on
http://www.wordcount.org
Project Title:
Website Scraping
Attachment:
none
Completed:
09/15/2009
Category:
Software Development > Scripts & Utilities
URL:
http:///www.yellowpages.com
Description:
Scraped contact information from
http://www.yellowpages.com
, according to age and location, for Medicare provider company
Project Title:
Personalized budget finance database
Attachment:
none
Completed:
08/01/2009
Category:
Networking & Information Systems > DBA - Database Administration
URL:
http://www.bankofamerica.com
Description:
Developed personalized budget program to automatically download registry item's from clients bank account at Bank of America.
Hourly Assignment History
Buyer ID
From/To
Job Title
Hours
Feedback
61422
11/2009 - Present
Creating an Excel Data coding interface
7 hrs
Job in progress
104399
10/2009 - 10/2009
Data Scrape Project - Text and Photos
4 hrs
No feedback given
L
Provider-to-Buyer Feedback:
No feedback given
Fixed-Price Assignment History
Buyer ID
From/To
Job Title
Paid
Feedback
112516
11/2009 - 11/2009
Computer Programing - Financial Modeling
—
5.0 Marcus did a great job on this assignment and was very capable, professional, responsive and showed great ability. I will work with Marcus in the ...
L
Provider-to-Buyer Feedback:
5.0
96712
10/2009 - 10/2009
Need an excel scheduling program: only apply if you know excel and algorithms/mat
h
—
4.7 Excellent work. Knows what he is doing and is keen to ask questions to make sure everything is clear. Love to work with him again!
L
Provider-to-Buyer Feedback:
5.0
125781
09/2009 - 09/2009
data entry
—
5.0 Marcus was my first hire on odesk and it could not have gone much better. If you are looking for someone to do any work on excel spreadsheets...
L
Provider-to-Buyer Feedback:
5.0
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
MS Access 2003 Test
3.75
92%
TOP 10%
11/07/2009
20 min
MS Excel 2003 Test
3.10
85%
TOP 20%
09/26/2009
29 min
Stock Trading Test
4.10
66%
11/07/2009
17 min
U.S. English Basic Skills Test
4.00
55%
09/20/2009
23 min
Visual Basic 6 Test
2.50
49%
11/11/2009
32 min
oDesk Readiness Test for Independent Contractors and Company Managers
09/15/2009
2 min
