Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Jeff Rosenberg | Elance
 
176985602337900
Last Sign-in: Jan 21, 2016
Sorry, I am not available for new work at this time.

Jeff Rosenberg

Expert data management and programming
   United States
  |   Blaine, MN
  |  8:15 pm Local Time

Overview

Minimum Hourly Rate $30

I develop reliable, user-friendly solutions to help businesses of all sizes manage their data.

My expertise includes data analysis in Excel, database management in Access and SQL Server, and custom tools written in Microsoft's .NET framework. I am a Microsoft-certified specialist in Excel and Access, with a specialization in Visual Basic for Applications programming and Microsoft Office automation.

I stand behind my work with a lifetime guarantee. If you ever encounter any bugs in a project I have developed, I will fix them at no cost,...

Read More »
Aug 17, 2015|Database Development|$1,360|Completed
|
5.0
Feb 19, 2015|Database Development|$250|Completed
|
5.0
Feb 8, 2015|Database Development|$1,000|Completed
|
5.0
Jan 11, 2015|Database Development|$450|Completed
|
5.0

View All »

Portfolio

A popup interface for selecting multiple clients
A calendar view used to compare three different types of payroll data on a daily and...
A tab from a custom ribbon
Designed a custom-built Excel template to allow users to download data into Excel...
Designed a custom-built Excel template to allow users to download data into Excel...
Microsoft Excel 2010 Expert
Microsoft Access 2010 Specialist
This transcript shows all of the Microsoft certification exams I've passed

Skills (5)

Tested
Microsoft Access Administration
Microsoft Access 2007 Test
My Score
avg
Microsoft Access 2010 Test
My Score
avg
Microsoft SQL Server Programming
Knowledge of SQL Server 2008 Skills Test
My Score
avg
MS SQL Server 2005 Test
My Score
avg
ASP.NET
ASP.Net 3.5 using C# Test
My Score
avg
C#
Programming with C# Test
My Score
avg
Microsoft Excel
Microsoft Excel 2007 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg

Service Description

I am an expert in data analysis, spreadsheet and database development, data manipulation, and Microsoft Office automation. I am also proficient in .NET development.

I offer a lifetime guarantee of my work. Below are more detailed descriptions of my skills and my lifetime guarantee.

Microsoft Certified Access Specialist - skills include:
- Complex queries
- Visual Basic for Applications
- ActiveX Data Objects (ADO) for connecting to outside data sources
- Custom ribbons for easy access to database features

Microsoft Certified Excel Expert - skills include:
- Dynamic formulas
- Visual Basic for Applications
- Forms for easy data access
- Web requests for querying external APIs

Microsoft Office automation - skills include:
- Opening a file in one program from a procedure in another (i.e. clicking a button in Excel to launch Word and open a Word file)
- Opening programs invisibly for unobtrusive processing in the background
- Passing data and variables between procedures in different Office programs

SQL Server - skills include:
- Complex queries
- Stored procedures for safely updating and manipulating data while maintaining data integrity
- Linked servers and ad-hoc queries for querying external data sources

Data manipulation - skills include:
- Regular expressions for restructuring text data
- Visual Basic for Applications for restructuring data in Excel
- Google Refine for cleaning and standardizing data

C# development - skills include:
- Windows...

Read More »

Employment

Nichols Kaster, PLLP
Database Specialist
2009 - Present
Develop a custom-written database solution using Microsoft Access and SQL Server; Calculate damages for class-action lawsuits using Excel, Access, and SQL Server; Miscellaneous quantitative...
Ameregis
Research Associate
2008 - 2008
Collect and maintain large datasets using Access and SPSS; Analyze socioeconomic, transportation, and land-use data in Excel; Perform spatial analysis using ArcGIS.

Education

University of Minnesota
Master of Urban and Regional Planning
2006 - 2008
University of Minnesota
Bachelor of Arts
2002 - 2006
Overview  |  Job History  |  Portfolio  |  Resume/C.V.

Keywords

Excel
Access
VBA
Automation
C#
SQL
.NET
Data Analysis
My Snapshot
IT & Programming
7
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
1
4
0
Total
Milestones
Hours
Reviews
5.0
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
jeffrosenberg
Type
Individual
Member Since
November 2011
Elance URL
Verifications
0
Groups
Jeff Rosenberg | Elance

Jeff Rosenberg