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

Excel,VBA,VB.NET,XML,SQL,CSV,PDF, data management
   Ukraine
  |  8:47 am Local Time

Overview

I'm an experienced Excel VBA developer as well as a business consultant. I create advanced Excel based tools for SMEs and large corporations.

I also work with Access, Word, Outlook, PowerPoint, Visio.

VBA is my "native language".

I have Master's degree in project management and 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 before started my own business.

I work on Elance since October 2011. Have happy clients...

Read More »
Jul 5, 2014|Investment Analysis|Private|Completed
|
5.0
Jan 15, 2013|Financial Reporting|Private|Completed
|
5.0
Nov 21, 2012|Financial Reporting|Private|Completed
|
5.0
Sep 10, 2012|Accounting|Private|Completed

View All »

Portfolio

Excel Business Intelligence has more then hundred of happy clients. We work with sole...
About 100 jobs in IT & Programming category completed on Elance. From $20 simple...
https://www.elance.com/s/xlbin/job-history/10183/
https://www.elance.com/s/xlbin/job-history/10186/?t=1
Multiple jobs in Admin Support category completed on Elance. Amazing feedbacks with 5.0...
https://www.elance.com/s/xlbin/job-history/10179/?t=1
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...
Complex Excel VBA project. Months of full time work. More than 10 thousands of VBA code...
More than two months of full time work. Thousands of VBA code rows. New worker was...
Advanced Excel VBA forms and VBA code created for existing tool. Multiple tabs,...
Excel VBA tool to parse multiple large OCRed PDF documents into CSV files. SQL queries...
Ribbon button with menu buttons: 1) to apply formatting to selection, active sheet or...
https://www.elance.com/j/excel-plug/30911450/
Months of full time word. Thousands of VBA code rows. Advanced tool for wooden windows...
Excel VBA tool created to get financial reports from specific password protected web...
Form to filter data from large Excel database by multiple fields. SQL queries used to...
Microsoft Word VBA program to parse multiple Word documents (reports) with similar (but...
Access VBA tool for transport optimization created. The tool uses third party DLL...
Access VBA functions created to send SMS via web bulk service as well as sample form to...
PDF file OCRed by FineReader 11, then excel formulas and VBA macro used to split data...
Excel VBA tool to get data from multiple Excel files, process it and create multiple...
Excel VBA tool created to generate PDF files for each record in Excel database and...
Excel based tool to generate XML files of specific structure with data provided in...
Monte Carlo algorithm implemented.
Excel based tool for Search Engine Optimization. The tool allows to use Excel to work...
Excel VBA function created to send faxes via online fax sending service. Sample form to...
Custom Excel VBA fuzzy string matching functions created. Usage samples provided....

Skills (16)

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

Service Description

First of all I can answer any your question which sounds like "How I can use Excel VBA to improve my business?". I understand what businesses need, doesn't matter it's a SME or a large corporation.

To improve your business 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. That is how my applications can work fast even with large amounts of data. E.g. I can import data from multiple Excel files into a master file without even opening all source files in Excel.

I work with web services (REST, XML). I can get any data from web into Excel, send any data from Excel to web, send SMSs and faxes from Excel based application etc.

I can use VB.NET. I use Office 2013 64 bit on Windows 7 64 bit to develop but i still have Office 2010 64 bit and Office 2007 32 bit (on Windows XP) to test my code. I work with Excel since Excel 97 but I do not support Office 2003 anymore (except migration from 2003 to newest versions).

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 or CSV conversion jobs. We use advanced mathematical algorithms in VBA procedures and in custom Excel formulas to provide fuzzy data...

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
1
1
0
Total
Milestones
Hours
Reviews
5.0
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