Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel Business Intelligence | Elance
 
176985602337900
Last Sign-in: Apr 16, 2014

Excel Business Intelligence

Excel,VBA,XML,SQL,CSV,PDF, data management
   Ukraine
  |  11:21 am Local Time

Overview

I'm experienced VBA developer focused on creating of advanced business tools for Microsoft Excel. Also I work with other Microsoft Office applications such as Word, Outlook, PowerPoint, Access, Visio. And I'm not just a developer, I'm experienced business consultant with a Master's degree in project management and a Bachelor's degree in finance. Worked as IT project manager and CIO in manufacturing, retail, real estate development and marketing companies with from 15 to 20000 employees.

My advantages are analytical and project management...

Read More »
Jan 15, 2013|Financial Reporting|Private|Completed
|
5.0
Nov 21, 2012|Financial Reporting|Private|Completed
|
5.0
Sep 10, 2012|Accounting|Private|Completed
Jun 14, 2012|Accounting|Private|Completed
|
5.0

View All »

Portfolio

Complex Excel Add-Ins: pivot tables, charts, advanced formulas, advanced VBA code...
In large and complex VBA projects I use my own centralized error handling system. Error...
In all my Excel projects if any macro works more then just a moment I use Progress Bar...
Ribbon button with menu buttons: 1) to apply formatting to selection, active sheet or...
https://www.elance.com/j/excel-plug/30911450/
OCR, excel formulas and VBA macro to split data, manual data veifying
https://www.elance.com/j/church-directory-pdf-excel-conversion/26759143/

Skills (12)

Tested
Microsoft Excel
Microsoft Excel 2007 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg
VBA
Microsoft Office
Project Management
English-Russian Translation
Russian To English Translation Skills Test
My Score
avg
Passed
Microsoft Project
Microsoft Word
Microsoft PowerPoint
Microsoft Access Programming
Microsoft SQL Server Programming
MySQL Programming
Google AdWords
Knowledge of Google AdWords Test
My Score
avg

Service Description

I create complex Excel based applications with advanced formulas, named tables, pivot tables, charts, dashboards, customized ribbons, user forms etc. I use SQL queries to work with Microsoft SQL and MySQL databases, Access, Excel and CSV files. I work with REST and XML web services as well as with Microsoft Windows and third-party applications API calls. I use Office 2013 64 bit on Windows 7 to develop but i still have 2010 64 bit and 2007 32 bit (on Windows XP) to test. I do not support Office 2003 anymore.

My team of highly educated data management professionals (almost everybody has master's degree in mathematics etc.) with my management and VBA skills can provide fast delivery and 100% accuracy in either automated and manual PDF to Excel|CSV conversion jobs. We use advanced mathematical algorithms in VBA procedures and in custom Excel formulas to provide fuzzy data processing: data matching, data cleaning, duplicate removing etc.

Read More »

Keywords

Excel
VBA
macro
Visual Basic for Applications
Add-In
spreadsheet
workbook
XML
CSV
Word
Outlook
PowerPoint
xml-rpc
duplicate removing
fuzzy comparison
formula
graphs
charts
PDF
Company Snapshot
3
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
Private
Private
Total
Per Client
Identity
Username
xlbin
Type
Company
Member Since
July 2011
Elance URL
Verifications
0
Groups
Excel Business Intelligence | Elance

Excel Business Intelligence