Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Vincent P. | Elance
 
176985602337900
Last Sign-in: Jul 20, 2016

Vincent P.

Expert data management and programming
   Switzerland
  |   Geneve, Geneva

Overview

Minimum Hourly Rate $22

I have been doing software development for over 20 years (especially on database application), as well as Business Analysis.
I am familiar with the entire software development life cycle and can follow a project from gathering requirements through development, testing and support.

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, whether it's been two weeks or two years. You shouldn't need to worry about how your spreadsheet or database works behind...

Read More »
Jul 20, 2015|Financial Reporting|$55|Completed

View All »

Skills (9)

Tested
Access
My Score
avg
Excel
My Score
avg
MySQL
My Score
avg
Passed

Service Description

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

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

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 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

MySQL 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

Statistical Analysis - skills include:
- Demand Planning
- SAP R/3 module
- Time Series...

Read More »

Employment

Procter & Gamble
Business Expert
2005 - 2015
WELLA
IT Administrator
2000 - 2005
TOTAL
IT Administrator
1996 - 2000

Education

ESME Sudria
IT Engineer
- 1996
Overview  |  Job History  |  Resume/C.V.

Keywords

My Snapshot
All Categories
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
aerobace
Type
Individual
Member Since
April 2014
Elance URL
Verifications
0
Groups
Vincent P. | Elance

Vincent P.