Teamerat W. | Elance
 
176985602337900
Last Sign-in: Oct 26, 2014

Teamerat W.

Expert on Excel, SQL & Visual Web Ripper
   United States
  |   arlington, VA
  |  9:54 pm Local Time

Resume/C.V.

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.

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.
Education
Strayer University
Bachelor of Science Information Systems
- 2010
Employment
Marvelous Market
Supervisor
2003 - Present
Payment Terms
None specified
Teamerat W. | Elance

Teamerat W.