Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Teamerat W. | Elance
 
176985602337900
Last Sign-in: Dec 25, 2013

Teamerat W.

Expert on Excel, SQL & Visual Web Ripper
   United States
  |   arlington, VA
  |  2:26 am Local Time

Verified Freelancer

Teamerat W.'s identity has been verified.  Learn More

Overview

Minimum Hourly Rate $18

I have more than ten years experience on data analysis using Microsoft Excel and SQL queries, data scraping, advanced formulas and functions, VBA macros, Pivot Tables and Charts. I have worked on projects on my full time job and recently on web scraping and uploading data on web sites. I am proficient in developing scenarios, goal seek, assumption sheets trend analysis using Microsoft excel.

Read More »

Portfolio

The data collected from "expowest.com" consists of 2382 rows and 11 columns....
http://http://www.expowest.com/ew13/public/MainHall.aspx?ID=1039339&sortMenu=101000

Skills (5)

Tested
Data Modeling
SQL Programming
Microsoft Excel
Financial Statements
Data Interpretation

Service Description

Data collection or web scraping using visual web ripper.
Simplify manual and routine Microsoft excel task with formulas and VBA macros programming.
Develop or customize database and spreadsheets.
Data conversion and data Import/export regardless of file format.
Fix problems and errors including spreadsheet construction inefficiencies on already developed excel spreadsheets.

Data analysis and Cleaning Bad data (Removing duplicate data/rows and spaces and non-printing characters from text, finding and replacing text, reconciling table data by joining or matching, data validation etc.)

Develop Microsoft excel based forms, conditional Formatting and invoices.

Simplify manual and routine Microsoft excel task with VBA macros programming.
Develop or customize database and spreadsheets.
Data conversion and data Import/export regardless of file format.
Web scraping for data/sales Quotes and upload in web sites.
Fix problems and errors including spreadsheet construction inefficiencies on already developed excel spreadsheets.

Data analysis and Cleaning Bad data (Removing duplicate data/rows and spaces and non-printing characters from text, finding and replacing text, reconciling table data by joining or matching, data validation etc.)

Develop Microsoft excel based forms, conditional Formatting and invoices.


Read More »

Employment

Marvelous Market
Supervisor
2003 - Present

Education

Strayer University
Bachelor of Science Information Systems
- 2010

Keywords

My Snapshot
Sales & Marketing
1
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
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
Twol
Type
Individual
Member Since
December 2012
Elance URL
Verifications
Teamerat W. | Elance

Teamerat W.