Excel VBA developer and business consultant
I'm an experienced Excel VBA developer and business consultant. I create advanced Excel VBA based tools (reports, dashboards) to improve your business.
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 as Excel VBA developer since October 2011, and I have many satisfied clients (SMEs and large corporations) 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 was at the top of the list of 300,000-plus Excel VBA professionals on Elance. Since Upwork Global Inc. merged Elance and Odesk into Upwork I moved from Elance to Upwork to be on the top of Excel VBA developers list on Upwork.
I work by myself as Excel VBA developer and business consultant and I own/manage Excel Business Intelligence LLC (registered in Wyoming, USA) with a team for data management (data entry, data verification) jobs.
Excel VBA is a great tool to help your business. And the main advantage of hiring me is that I don't just write Excel VBA macros, but I help you to improve your business first of all. I created a lot of simple Excel macros and many advanced Excel Add-Ins. My clients increased their profit and reached their goals using my help.
Be excellent with Excel Business Intelligence!
=== 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 also have Windows 8 and Windows 10 for testing purposes.
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 percent 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.
=== Payment Terms ===
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), we will create another Upwork job with my hourly rate for the extra tasks.
I have been working with Excel VBA for about 15 years – the last 4 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.