Personal information hidden
This job seeker has chosen to hide his personal information and contact info. You can contact him using this page: https://www.work.ua/resumes/7214171
Automation Developer (Excel, Google Sheets), Business Analyst, Project Manager
- Employment:
- Full-time, part-time.
- City of residence:
- Kyiv
- Ready to work:
- Kyiv, Remote
Contact information
Name, contacts and photo are only available to registered employers. To access the candidates' personal information, log in as an employer or sign up.
Work experience
Automation Developer | Business/Data Analyst | Project Manager | Microsoft Excel & VBA | Google Sheets & Google Apps Script
from 01.2018 to now
(6 years 4 months)
Automation Development
Upwork Top Rated Plus Freelancer
Professional Microsoft Excel & Google Sheets Development
Formula Nativity | Advanced VBA / Google Apps Script (JavaScript)
Full Automation | Workflow Optimization | Digital Integrations
Complex Calculations, Dynamic Conditional Formatting, Pivot Tables & Pivot Charts
Instant Actions, Macros, User-defined Functions, UI Forms, Data Scrappers, Web-connections, Data Backups, Emailing — any custom functionality
Automated Reporting and Data Analysis, Processing of Complex Datasets, Data Transformation, File Generation, Database Management, External Controlling
Data Summary & Data Visualization | Dashboards, Charts & Graphs, KPIs — professional, beautiful, clean & dynamic
Financial Modeling, Data Analytics Planning, Forecasting
Advanced Graphical User Interface (GUI) | Architecture Design | Elegant Workflows
Intuitive Designs | Best UX | Effortless Maintenance | Instant Results
Smart Decision-Making Tools, Solvers, Schedulers, Triggers, Alerts & Notifications
Business Tools, Trackers, File Processors, Bar/QR Code Generators
Custom Calculators of any type: Business, Financial, Insurance, Fitness, etc.
Workflow & Data Integration between Microsoft Office Products – Word, PowerPoint, Outlook, SharePoint, InfoPath, OneNote
Interaction with WinApi | FileSystemObject (FSO) | ADODB (MS Access, MS SQL) | Web APIs
Workflow & Data Integration between Google Workspace (G Suite) Components – Admin Console, Drive, Gmail, Docs, Slides, Calendar, Forms, Sites, Keep
Advantages
Automation Development since 2010
Deep engagement into modern IT tech
Low-Code/No-Code Enthusiast
Fast typing (top 1%, >100 WPM)
100% Googling skills
Advanced English | IELTS C1
BA – English Translation
Native Ukrainian & Russian
Professional Negotiator
Confident Public Speaker
Strong Financial Background
Erasmus+ MA Student (Krakow, Poland)
MA with Honors – Financial Management
BA – Corporate Finance
Top Rated Plus Upwork Freelancer
Worked in three international companies
More than 50 successful long-term projects
Over 2500 clients (US, Canada, UK, Australia)
I worked with:
Crypto Traders | Investors | Stockbrokers
CEOs | CFOs | Senior Management | Startups
I worked with most industries:
Finance • Marketing • Sales • Insurance
Manufacturing • Construction • Real Estate
Government • Healthcare • Education
Agriculture • Media • ... • And many more
Additional Digital Skills:
Airtable • Google Data Studio • Power BI • Databox
Power Query • Power Pivot
Microsoft Flow • Zapier • IFTTT • Integromat • Automate.io
Power Automate • Automatic Mouse & Keyboard • FileMaker Pro • AC Tool • iCUE Corsair • Stream Deck
Power Apps • App Sheet • bubble.io • Webflow • Telegram Bots
WordPress • HTML • CSS • JavaScript • PHP • SQL • Hostings • Domains
Trello • Jira • Confluence • Microsoft To-Do • Google Tasks • ServiceNow
Canva • diagrams.net (draw.io) • Paint.net • Photoshop
Business/Data Analyst | Automation Developer Microsoft Excel & VBA / Google Sheets Expert | Tutor
from 01.2018 to 06.2020
(2 years 5 months)
Got It AI, Київ (Artificial intelligence (AI))
Clients Onboarding, Requirements Diagnosis, Guiding & Tutoring
Creating Excel, VBA & Google Sheets test materials
Creating Excel & Google Sheets learning & practical materials
Mentoring Excel experts, building & analyzing KPIs
Customer Support & Problem Resolving
Developing Excel, VBA, Google Sheets & Google Apps Script solutions
Product Manager | Data Analyst
from 11.2017 to 04.2018
(5 months)
Samsung Electronics Ukraine Company, Київ (Wholesale, distribution, imports, and exports)
Data Analysis & Data Analysis Automation
Processing of business data & financial statements
Data reporting, visualization & presentation
Excel VBA Report Generation Automation
Developing concept, strategy & marketing of Samsung Innovation Center
IT Project Manager | Information Service Analyst
from 01.2017 to 11.2017
(10 months)
Philip Morris Ukraine, Київ (Light industry)
Project Management of Ideation Platform for Factory Manufacturing
Manager and Developer of Educational Platform for employees
Trainer of advanced Excel, Outlook, PowerPoint courses
Web development (SharePoint, HTML, CSS, JS)
Workflow Automation (Excel, VBA, InfoPath) | Data Analysis | Data Reporting | Data Visualization
Customer Support (ServiceNow)
Creating documentation, flowcharts, business cases, project charters, SLA, test scenarios, technical requirements, user stories, acceptance criteria, translating Information Service principles & practices
Webmaster | Translator | Excel Developer
from 01.2010 to 12.2016
(6 years 11 months)
Freelance, Київ (Freelance)
WordPress web development (HTML, CSS, PHP,JS)
Landings, blogs, e-shops, forums
Translating texts & documents (English, Russian, Ukrainian)
Creating Excel calculation files, complex formulas, VBA scripts
Forum & Social Media Administrator | Content Creator
from 01.2010 to 12.2016
(6 years 11 months)
Prime World, Київ (PC Gaming)
Moderating large online MOBA Game Forum & Socials
Customer Support, bug reporting & consolidation, beta-testing, newbie help, game consulting
Creating YouTube videos (Sony Vegas), Twitch broadcasts (OBS), Game Data Analytics, Game Guides
Creating website (HTML, CSS, PHP,JS), previews & posters (Paint.net)
Community Engagement
Education
Krakow University of Economics
Financial Management, Krakow (Poland)
Higher, from 2016 to 2017 (1 year)
Erasmus+ exchange program
Master Course
Corporate Investments, Portfolio Management, Advanced Corporate Finance, Financial Engineering, Social Philosophy, International Trade Simulation, International Financial Crises, FDI In Central And Eastern European, Polish language
Kyiv National University of Trade and Economics
Financial Management, Київ
Higher, from 2016 to 2018 (2 years)
Master Degree (with Honours)
*Master Degree taught in English
Kyiv National University of Trade and Economics
English Translation & Philology, Київ
Higher, from 2013 to 2017 (4 years)
English Translation & Philology
Bachelor's Degree
Second language: German
Kyiv National University of Trade and Economics
Corporate Finance, Київ
Higher, from 2012 to 2016 (4 years)
Corporate Finance
Bachelor's Degree
Additional education and certificates
Scrum 4 Teams training
2017
Japanese language courses
2015, 6m
Knowledge and skills
Language proficiencies
- English — fluent
- Ukrainian — fluent
- Russian — fluent
- German — beginner
Additional information
Scientific Article
Financing of Culture and Art: The Experience of Japan, Kyiv, 2016
Publications
Diagnostics of Enterprise Financial State and Ways to Improve It
Sales Promotion Tools and Their Genesis in the Modern Marketing Environment
Foreign Experience of Financing the Culture and Art (Japanese Example)
Excellent Science as a Priority Programme Of "Horizon 2020"
Cooperation Features Between Ukraine and Japan in Funding Social and Economic Development
Investment Planning for Enterprise
Financing the Arts and Culture
World Economy and Stages of Its Development
Branch and Territorial Structure of the Vinnytsia Region Economy
Conferences
Instruments of Improving the Financial State of a Company
Priority Areas of Research and Technical Cooperation Between Ukraine and the European Countries in the Program "Horizon 2020"
Tools of Sales Promotion and Their Genesis
Restrictions of Speech Freedom and Information
Honors and awards
The 2nd PwC International Financial Reporting Standards Tournament
High Performance in Scientific Activities and Excellent Study
Final Tour of Student Olympiad in Financial Economics
Best Translation of Robert Burns Poem
OmniPapers Writing Contest: The Ideal Higher Education Model for My Country
Completed EU Economic Law Summer School (2016)
XVI Petro Yatsyk Ukrainian Language International Competition
Interests
Technologies & Innovations
AI, AR/VR, ML, Big Data, Crypto, Decentralization
High-tech and innovative products
Kickstarter & IndieGoGo
Gaming
Live Streaming & Blogging
Content Creation
Exploring countries, languages & cultures
News & Politics
Philosophy
Pets (favs are pugs)
Anime, tv shows, movies
Forums, Live Conversations, Discussions
Alternative Music (Powerwolf, The HU, Heilung, Muse, Placebo, Radiohead, Bondage Fairies, Abney Park)
My Portfolio:
https://docs.google.com/document/d/1YYa5SdeNikhM2uzei1SsxnH8ZitLamReJc_z6M800to/edit?usp=sharing
More resumes of this candidate
Kyiv, Lviv, 2 more cities
Andrii Dubok VISIONARY ENGINEER Business Analyst | Project Manager Data Analyst | Automation Developer Custom automation tools and solutions since 2010 Time is the most valuable resource. Business process...
Kyiv
Andrii Dubok VISIONARY ENGINEER Business Analyst | Project Manager Data Analyst | Automation Developer Custom automation tools and solutions since 2010 Time is the most valuable resource. Business process...
Similar candidates
Information Security Specialist, менеджер з інформаційної безпеки, бізнес-аналітик, Project manager
Kyiv, Dnipro, Remote
Бизнес-аналитик, проджект-менеджер, CRM-интегратор
Remote
CMO, Business Analyst, Project Manager, Sales
Kyiv, Remote
Проєктний менеджер, project manager, керівник проєкту
25000 UAH, Kyiv, Lviv
,
more 3 cities
Менеджер IT-проекта, бизнес-аналитик
115000 UAH, Kyiv