Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Per Lyngemark | Elance
 
176985602337900
Last Sign-in: Oct 4, 2012

Per Lyngemark

Excel VBA and Dashboard expert
   China
  |   Shanghai, Shanghai

Overview

Minimum Hourly Rate $30

Worked with Excel since 1992, expert in VBA scripting and Dashboards.
Worked for Groupon; did a Dashboard with one button click to import 9 CSV files to Access, where it generated RAW data that was the basis for 8 different reports and 1200 unique customized reports and e-mailed each report to 1200 different people.
Expert in Data cleaning, large data sets (billion rows) and automation.
Last year worked extensively in MySQL scripting and Tableau for amazing Dashboards and live data.
Swedish national, lived in Taiwan and China for 22 years.

Read More »

Portfolio

The main Dashboard for Groupon, generates 1146 reports and e-mails them to 1146 people....
Dashboard that creates all the 220 city reports for Groupon China. As the reports are...
Each City report have six sheets, this is an example of the 1st sheet for each city,...
First page of the Sales report, where the sales person can see his/her daily revenue,...
A 17 page daily report in Excel that updates 36 different Charts and tables from a live...
A financial model, where the CFO can modify parameters with sliders and see instant...

Skills (5)

Tested
Data Warehousing
Microsoft Access Administration
MySQL Administration
Microsoft Excel
Tableau Software

Service Description

I will solve your data problems and go the extra mile to make it very easy for your to maintain, if that is a one button click or a few drop down choices is up to you.

Read More »

Employment

Major Game Company
VP of Business Intelligence
2012 - Present
Setting up a Datawarehouse in MySQL with billions of rows in 150+ tables. Made numerous Excel macros to clean data, create MySQL ready CSV files for MySQL from FaceBook, GoogleAnalytics, Twitter,...
Groupon.com
Vice President Analytics
2010 - 2012
Worked on very complex data crunching for 110 cities, 5000 employees and 10s of thousands of daily orders. Made five different commission structures in Excel that were based on: Different cities,...

Keywords

Excel
VBA
Tableau
Dashboard
Data cleaning
My Snapshot
IT & Programming
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
PerLyngemark
Type
Individual
Member Since
June 2012
Elance URL
Verifications
0
Per Lyngemark | Elance

Per Lyngemark