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 skills. I don't just create a macros for you, I help you to improve your business with an Excel based tools. Last 2 years I work full time as freelance developer on Elance. Have clients from USA, Canada, UK, EC, Norway, Australia, South Korea, Singapore etc. One of my clients with long ongoing relationships is Royal Dutch Shell - the Global Fortune Top 1 company.
My 5.0 rating in IT&Programming category was reduced with only one false feedback.
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.
Kyiv National University of Construction
Master of Project and Program Management
Kyiv National Economic University
Bachelor of Finance and Credit