Excel Business Intelligence | Elance
 
176985602337900
Last Sign-in: Aug 28, 2015

Excel Business Intelligence

Excel,VBA,SQL,XML,CSV,PDF, data management
   Poland
  |  5:05 am Local Time

About the Company

I am 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 and Visio.

I have a master's degree in project management and a bachelor's degree in finance. I worked as an IT project manager and CIO in various manufacturing, retail, real estate development and marketing companies, with anything from 15 to 20,000 employees, before I started my own business.

I’ve been working on Elance since October 2011, and I have many satisfied clients from all over the world, including the USA, Canada, the UK, Ireland, Germany, the Netherlands, Sweden, Norway, Israel, Australia, South Korea, Singapore and more.

My profile is at the top of the list of 300,000-plus Excel VBA professionals on Elance. The main advantage of hiring me is that I don't just write VBA code, but I help you to improve your business as well.

Be excellent with XLBIN!
Service Description
First of all, I can answer any question you have if you want to know how you can use Excel VBA to improve your business. I understand what businesses need, whether it's a small private business or a large corporation. My list of satisfied clients includes small stores and large retailers, local manufacturers and global manufacturing corporations, airlines with two aircraft and those with 100 aircraft, insurance companies, marketing and financial reporting companies, and many, many more.

To help you improve your business, I can create complex Excel-based applications, with advanced formulas, named tables, pivot tables, charts, dashboards, customized ribbons, user forms and so on.

In my VBA code, I never use unnecessary and slow operations (which are usually created by Excel Macro Recorder). I never use For...Next and other loops where it's possible to use just one operation instead, such as one SQL query. I use SQL queries to work with Excel data as well as to work with Microsoft SQL, MySQL, Access databases, CSV, text files and so on. That’s how my applications work so quickly, even with large amounts of data.

I work with web services (REST, XML-RPC and so on). I can get any data from the web into Excel, send any data from Excel to the web, manage Internet Explorer from Excel (DOM), send SMSes and faxes from Excel-based applications, and much more.

I use Office 2013 64-bit on Windows 7 64-bit to develop but I still have Office 2010 and Office 2007 32-bit to test my code. I’ve been working with Excel since Excel 97 but I no longer support Office 2003 (except for the migration from 2003 to the newest versions).

I know PHP and JavaScript well enough to integrate my Excel-based tools on to web servers – I can use MySQL as centralized data storage for Excel files with multiple users (XML is used for data transfer). I have my own LAMP servers in Amazon Cloud and can provide you with a complete solution, including Excel-based tools and PHP scripts already installed on my web server.

My team of highly educated data management professionals (almost everybody has a master's degree in mathematics or similar), together with my own management and VBA skills, can provide fast delivery and 100 per cent accuracy for either automated or 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 processing – data matching, data cleaning, duplicate removing and so on.
Education
Kyiv National University of Construction
Master of Project and Program Management
-
Kyiv National Economic University
Bachelor of Finance and Credit
-
Year Founded
2011
Number of Employees
1-5
Payment Terms
For fixed price jobs, we use Elance Escrow to protect your money. You pay per completed milestone. For hourly rated jobs, we can use Elance Time Tracker, and you pay weekly (the bill is sent each Monday).

I can accept a fixed price if the job is simple (days of work, rather than weeks or months) and with a detailed and clear description. In other cases (include updating VBA code created by other developers), I would prefer an hourly rated job.

If the fixed price work is completed to your original requirements but you want to change something that wasn't described in the original specification (for example, reformat sheets, add new functionality and so on), I will create another Elance job with my hourly rate for the extra tasks.

I have been working with Excel VBA for about 15 years – the last three years almost full-time – so I have in-depth knowledge and experience of the language. I also have a large VBA code library, so I can work really quickly. That’s why you will pay less overall with my hourly rate compared to other developers who have lower hourly rates – and you also get the best solution for your business.
Excel Business Intelligence | Elance

Excel Business Intelligence