Контактна інформація

Шукач приховав свої особисті дані, але ви зможете надіслати йому повідомлення або запропонувати вакансію, якщо відкриєте контакти.

Досвід роботи

Automation Developer | Business/Data Analyst | Project Manager | Microsoft Excel & VBA | Google Sheets & Google Apps Script

з 01.2018 по нині (7 років)
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

з 01.2018 по 06.2020 (2 роки 5 місяців)
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

з 11.2017 по 04.2018 (5 місяців)
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

з 01.2017 по 11.2017 (10 місяців)
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

з 01.2010 по 12.2016 (6 років 11 місяців)
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

з 01.2010 по 12.2016 (6 років 11 місяців)
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

Освіта

Krakow University of Economics

Financial Management, Krakow (Poland)
Вища, з 2016 по 2017 (1 рік)

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, Київ
Вища, з 2016 по 2018 (2 роки)

Master Degree (with Honours)
*Master Degree taught in English

Kyiv National University of Trade and Economics

English Translation & Philology, Київ
Вища, з 2013 по 2017 (4 роки)

English Translation & Philology
Bachelor's Degree

Second language: German

Kyiv National University of Trade and Economics

Corporate Finance, Київ
Вища, з 2012 по 2016 (4 роки)

Corporate Finance
Bachelor's Degree

Додаткова освіта та сертифікати

Scrum 4 Teams training

2017

Japanese language courses

2015, 6m

Знання і навички

• MS Excel
• Adobe Photoshop
• Jira
• HTML
• Trello
• CSS
• WordPress
• JavaScript
• PHP
• SQL
• Confluence
• Canva
• Google
• MS Power BI
• VBA
• Telegram
• DaVinci Resolve
• draw.io
• Paint.NET
• Zapier
• Airtable
• Webflow

Знання мов

• Англійська — вільно
• Українська — вільно
• Російська — вільно
• Німецька — початковий

Додаткова інформація

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