This is one of the users at Freelancer.com. If you wish to post your own project or become a service provider please signup here.
Username:
josephrowan
Last Login:
12-22-2009
Name/Company:
thatguyjoe.com
Country:
United States
City:
Wheaton
Area of Expertise:
Member Since:
11-22-2008 15:31 EST
Vision:
Describe shortly your vision
Skills:
Excel and MS Office in general
Data Manipulation
Data Entry
Keywords:
excel data formula keyword
Average Pricing:
$8/hour
Rating:
(No Feedback Yet)
Skills: MS Office Suite with a focus on Excel (data analysis, complex formulas, macros, database, VBA etc), data scrubbing, light SQL scripting, Adobe Suite, web page editing and other applications.
Work Experience
6/08 – Present
Freelance Analyst
Various Clients, Nationwide
- Data analysis, content management, data research.
4/08 – 6/08
Contract Management Analyst
ATT, Chicago, IL
- Analysis of legacy contracts from regional ATT subsidiaries
- Verification of contract charges versus current obligations.
1/08 – 3/08
Asset Management Analyst
Encyclopedia Britannica, Chicago, IL
- Examination and renaming of digital assets from acquired encyclopedia database.
- Cleanup and re-insertion of caption data to database.
- Identification of publishing rights for current digital photo assets.
10/07 - 11/07
Scheduling Analyst
Cricket Communications, Chicago, IL
- Update and maintenance of scheduling spreadsheet.
- Extrapolating of information for management of wireless telecommunications sites.
07/07 to 10/07
Data Conversion Analyst
Douglas Shaw & Associates, West Chicago, IL
- Created conversion processes to quickly and accurately extract data in PDF, Access and other formats into spreadsheet format for scrubbing and aggregation.
10/06 to 6/07
Keyword Analyst
Info.Com, Chicago, IL
- Keyword and key phrase sorting, categorizing, de-duping and preparation of lists for upload to Google/Yahoo/Ask campaigns for this search engine.
- Heavy MS Excel activity including mass categorization of disparate phrases based on concordances, phrase counts and other taxonomic methods.
10/05 to Present
Other Projects Telecommute and Local
- Establishment Productions.tv (Hollywood, CA) - Normalization of film and actor database.
- Hands-OnSolutions.com (Redmond, WA) - Data parsing from separated data sources.
- Easy~Ware.com (Chicago)- Data conversion from client files in assorted formats to importable data sets.
- Wamu.com/Seimens (Chicago)- System shutdown assistance. Testing of connectivity, user support.
- YesVideo.Com (California)- DVD Kiosk installations at Wolf Camera locations throughout Chicagoland.
- MarkRossPhoto.com (Chicago)- Technical support for AP photography studio.
10/03 to 10/05
Client Care Worker / SCIMS Database Operator
Volunteers of America, Chester, NY
- Population tracking in a 1,001 bed, adult men's homeless shelter.
- Monitored all client movement within the facility.
- Maintained spreadsheet database for reporting point-in-time samples and projected occupation.
- Developed backup procedures in the event of main database failure.
8/00 to 10/03
Freelance Technical Consultant - Corporate Meeting Presentation Services, New York, NY
- Contract work in trade show IT Services.
9/97 to 8/00
Technical Support - Corporate Meeting Presentation Services
MJM Creative Services, New York, NY
- In house and offsite administration of Mac/PC environment for corporate meeting production company.
9/96 to 9/97
Freelance Technical Consultant
New York, NY
- System software installations, hardware configurations, troubleshooting, application support and web page construction.
1985 to 1996
Technical Director/Stage Manager
New York, NY
- Stage manager and lighting designer for touring, modern dance companies. IMAX & 16/35mm projectionist.
Education
Towson State University, Towson, MD
Technical Theatre
Buyer Rating:
(No Feedback Yet)
Latest Open Projects:
(No Open Projects)
Latest Frozen Projects:
(No Frozen Projects)
Latest Closed Projects:
(No Closed Projects)
Provider Rating:
(No Feedback Yet)
Latest Bids on Projects:
Latest Won Projects:
Latest Lost Projects: