Працював в 6 компаніях   14 років 10 місяців

IT, Електроніка та електротехніка, FMCG

Automation Developer | Business/Data Analyst | Microsoft Excel & VBA | Google Sheets & Google Apps S

Upwork Freelance

IT

7 років

12.2017 - до теперішнього часу

Primary Skills & Work Experience

  • 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

Additional Digital Skills

  • Airtable • Google Data Studio • Power BI • Databox
  • Power Query • Power Pivot
  • Microsoft Flow • Zapier • IFTTT • Integromat • Automate.io • Parabola • Clay • n8n.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 • ShareX • Sony Vegas • DaVinci Resolve
  • Java • Python • Delphi • PascalABC.NET • VBS • Batch Scripts
  • OBS • Streamlabs • Stream Elements • Restream • Voicemeeter Potato • Voicemod • Snap Camera NVIDIA Broadcast • RTX Voice
  • Virtualbox • Blue Stacks • Samsung DeX • Sandbox • Teamviewer • Chrome Remote Desktop
  • Cheat Engine • ArtMoney
  • Facebook • Twitter • Reddit • Discord • Telegram • Medium • Instagram • YouTube • Twitch • TikTok Dlive • Patreon • Snapchat • Pinterest • Live.me • LinkedIn • Quora

Business/Data Analyst | Automation Developer | Microsoft Excel & VBA / Google Sheets Expert | Mentor

Got It AI

IT

3 роки 4 місяці

01.2018 - 05.2021

  • 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

Samsung Electronics Ukraine Company

Електроніка та електротехніка

3 місяці

10.2017 - 01.2018

  • 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

Philip Morris Ukraine

FMCG

7 місяців

03.2017 - 10.2017

  • 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

Freelance

IT

6 років 11 місяців

01.2010 - 12.2016

  • 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

Prime World

IT

6 років 11 місяців

01.2010 - 12.2016

  • 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

Ключова інформація

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
  • Fluent 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)

Навчався в 4 закладах

Kyiv National University of Trade and Economics

MA (with Honours): Financial Management

Kyiv, 2018

Kyiv National University of Trade and Economics

BA: English Translation

Kyiv, 2017

Krakow University of Economics

Erasmus+ MA: Financial Management

Krakow, 2017

Kyiv National University of Trade and Economics

BA: Corporate Finance

Kyiv, 2016

Володіє мовами

Англійська

вільно

IELTS — C1

Російська

рідна

Українська

рідна

Курси, тренінги, сертифікати

Scientific Activity & Rewards

Kyiv, 2016

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 Europea

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

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, moviesForums, Live Conversations, Discussions
  • Alternative Music (Powerwolf, The HU, Heilung, Muse, Placebo, Radiohead, Bondage Fairies, Abney Park)

Андрій

Business Analyst

Київ

Готовий переїхати: Львів

31 рік

Активно шукає роботу

повна зайнятість, неповна зайнятість, проектна робота

Характер роботи: віддалена робота, гібридна, в офісі/на місці

Оновлено 1 годину тому