Працював в 6 компаніях 14 років 9 місяців
IT, Електроніка та електротехніка, FMCG
Automation Developer | Business/Data Analyst | Microsoft Excel & VBA | Google Sheets & Google Apps S
Upwork Freelance
IT
6 років 11 місяців
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
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 Pro
Додаткова інформація
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)
Андрій
Андрій
Data analyst
Київ
Готовий переїхати: Львів
Активно шукає роботу
повна зайнятість, неповна зайнятість, проектна робота
Характер роботи: віддалена робота, гібридна, в офісі/на місці
Оновлено 1 тиждень тому