Особисті дані приховані

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 analysis, optimization & automation I don't waste it.

Unifying digital environment workflows

ACADEMIC BACKGROUND
ADVANTAGES
Krakow University of Economics
Automation Development since 2010
Erasmus+ English MA in Poland
Financial Management | 2016-2017 Deep engagement into modern IT tech
Low-Code/No-Code Enthusiast
Kyiv National University of Trade
Fast typing (top 1%, >100 WPM)
and Economics
100% Googling skills, Chat GPT 4 advance user
Master's degree (with Honours)
Financial Management | 2016-2018
Fluent English | IELTS C1
Kyiv National University of Trade
BA – English Translation
and Economics
Native Ukrainian & Russian
Bachelor's degree Professional Negotiator
English Translation | 2013-2017
Confident Public Speaker
Kyiv National University of Trade
and Economics Strong Financial Background
Bachelor's degree Erasmus+ MA Student (Krakow, Poland)
Corporate Finance | 2012-2016 MA with Honors – Financial Management
Scrum 4 Teams Training BA – Corporate Finance
Kyiv, 2017

CONTACT INFO Top Rated Plus Upwork Freelancer
Worked in three international companies
doobOak.ai More than 50 successful long-term projects
Over 2500 clients (US, Canada, UK, Australia)
Kyiv, Ukraine Portfolio:
doobOak.com
Crypto Traders | Investors | Stockbrokers
[відкрити контакти](див. вище в блоці «контактна інформація»)
CEOs | CFOs | Senior Management | Startups
[відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація») Finance • Marketing • Sales • Insurance
@AndreDeBonk Manufacturing • Construction • Real Estate

@doob_Oak Government • Healthcare • Education
Agriculture • Media • ... • And many more
upwork.com/fl/andredebonk
 PRIMARY SKILLS & WORK EXPERIENCE

Automation Developer | Business/Data Analyst
Microsoft Excel & VBA | Google Sheets & Google Apps Script
Project Manager
Upwork, Freelancer • San Francisco HQ | 2018 to 2023

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

Power BI (DAX) • Looker Studio (Google Data Studio) • 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
Airtable • 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
GOOGLE SHEETS/GOOGLE APPS SCRIPT | MICROSOFT EXCEL/VBA
| FINANCE MODEL
Business Automation | Dashboard | CRM | Data Visualization
Since 2010: Excel VBA Google Sheets Google Apps Script Professional Financial Modelling expertise with
Financial background (2xMa, 2xBA)
Transform Your Business with Advanced Automation Solutions Are you looking to eliminate manual tasks and
focus on significant, innovative business ventures? If you're a startup or a forward-thinking company, my
automation services can revolutionize your operations.
Why Choose My Services?
Efficiency at Scale: Automate the workload of hundreds, streamline processes, and embrace error-free,
scalable solutions.
Proven Expertise: A trusted partner to over 2,500 clients worldwide, including giants like Philip Morris,
Samsung, and GotITAI.
My portfolio spans across the US, Canada, Australia, the UK, Europe, and Ukraine.
Top Credentials:
Recognized as a Top Rated Plus freelancer on Upwork with 6+ years of experience.
Comprehensive Skill Set: Expert in Excel, Google Sheets, Google Apps Script, VBA, and more, with a strong
foundation in financial management and corporate finance.
I specialize in business automation, data visualization, CRM solutions, and workflow integration using the
latest no-code and low-code technologies.
What Sets Me Apart?
I'm your one-man army, a visionary engineer, process architect, and innovation advisor, dedicated to
transforming your business operations.
With a solid financial background (Master's in Financial Management, Bachelor's in Corporate Finance, and
English Translation), I've been pioneering automation solutions since 2010.
Special Offer for 2024: Secure my services at $100/hour before rates increase to $150/hour. This is your
chance to leverage my upcoming AI service, doobOak.ai, and elevate your business to the next level.
Industries Served: Finance, marketing, sales, insurance, manufacturing, construction, real estate, blockchain,
government, healthcare, education, AI, ML, VR, AR, agriculture, media, investment, and more.
Let's discuss how we can achieve excellence in your business operations together. I'm here to serve as your
business analyst, data analyst, project manager, and more
Looking 👁 for Business Automation? 👔🛠🌐📊🕶
Get rid of manual work, save your time 🕓 on doing big things and innovative business 🌎💰💸💎💱👑
Are you a startup or a progressive business? 📱 💻
My automation allows substituting the work of hundreds of people and whole departments. Faster processes,
error-free, scalable solutions
Worked with over 2500 clients globally International companies: #PhilipMorris, #Samsung, #GotITAI and led
innovative #US, #Canada, #Australlia, #UK, #Europe, and #Ukraine businesses.
#Top Rated Plus #Upwork Upwork Freelancer 6+ years
Interested in making #Business3.0 now?
#BusinessAnalyst #DataAnalyst #ProjectManager #VisionaryEngineer | #ProcessArchitect | #InnovationAdvisor at
your service! #Excel #GoogleSheets #GoogleAppsScript #VBA #Nocode #Lowcode #Automation #Dashboard
#CRM #Business #BusinessAutomation #Graphs #Visuals #AppSheet #Looker Studio (Google Data Studio)
#Microsoft #PowerBI, #DAX, #PowerApps #Data #Visualization #DataVisualization #FinancialModeling |
#BusinessTools | #Workflow #Integration #Airtable | #Zapier | #Make | #IFTT #JavaScript | #Python | #WordPress
| #js #html #css #php #GoogleWorkspace #MSteams #Sharepoint #Infopath #Telegram #Bots and much more!

I worked with #Crypto #Traders | #Investors | #Stocks #Brokers #CEO | #CFO | #SeniorManagement | #Startup
All kinds of industries
#Finance • #Marketing • #Sales • #Insurance #Manufacturing • #Construction • #RealEstate #Blockchain
#Government • #Healthcare • #Education • #AI • #ML • #VR • #AR #Agriculture • #Media • #Investment • … •
And many more
 EXPERT BUSINESS ADVISOR & AUTOMATION ARCHITECT
GPT-4/CHATGPT/PEOPLEGPT
Business Automation | Dashboard | CRM | Data Visualization
Visionary Engineer | Process Architect | Innovation Advisor | Product Owner | Project Manager | Business Analysis
| Data Analysis
I am the number one enemy for any routine process. If I have to do anything twice on my PC - it gets automated.
🚀 Welcome to Expert Business Advisory & Automation Architecture Universe 🚀
Embark on a transformative journey with me your guide and collaborator in the realms.
Since 2010, I've been at the forefront of custom automation tools and solutions, dedicated to optimizing business
processes and unifying digital workflows.
My mission is clear: Time is the most precious resource. I don't waste it.
Why Choose Andrii? 🌟
A proven track record with over a decade of experience in revolutionizing business operations for more than
2,500 clients globally, including industry giants like Philip Morris, Samsung, and GotIT AI.
A solid academic foundation with degrees from Krakow University of Economics and Kyiv National
University of Trade and Economics, specializing in Financial Management, Corporate Finance, and English
Translation.
Recognized as a Top Rated Plus freelancer on Upwork, embodying professionalism, unparalleled skill, and a
dedication to client success.
Premium Services Tailored for You: 💼
At a premium rate, my offerings encapsulate:
Comprehensive business process analysis and optimization 📊, ensuring your operations are streamlined
for maximum efficiency.
State-of-the-art automation solutions 🔧, custom-designed to enhance productivity and scalability, preparing
your business for the challenges of tomorrow.
A partnership model based on trust, transparency, and mutual success 🤝, aligning closely with your
business's unique identity and long-term goals.
Cross-Industry Innovation: 🏭
My expertise spans various sectors, from finance 💰 and marketing 📈 to healthcare 🏥, education 📚, and more.
Each strategy is meticulously crafted to address the specific challenges and opportunities of your industry,
guaranteeing impactful results that drive growth and innovation.

A Deep Dive into Technologies and Innovations: 🌐
My passion for technology, AI, AR/VR, ML, Big Data, and Crypto keeps me on the cutting edge, ensuring that the
solutions I offer are not just current but forward-looking. This technological savvy, combined with a profound
understanding of global business trends, positions me as a visionary in the field.
Scientific Pursuits and Global Engagement: 📚
My scientific contributions and active participation in international conferences highlight a commitment to
continuous learning and contribution to the broader knowledge base. This academic engagement enriches my
professional practice, ensuring a well-rounded and informed approach to every challenge.
Cultural Curiosity and Global Insights: 🌍
A fervent explorer of countries, languages, and cultures, my global perspective influences a unique approach to
business strategies, recognizing the importance of cultural nuances in the digital age.
Let's Craft Your Success Story: ✨
Together, we will navigate the complexities of today's business landscape, leveraging strategic insights and
cutting-edge technologies to unlock unprecedented potential for your business. Your vision, combined with my
expertise, will pave the way for a future marked by success, innovation, and growth.
📞 Ready to Transform Your Business?
Contact me to embark on a strategic partnership that transcends conventional consultancy. Let's redefine what's
possible for your business, creating a legacy of success and innovation for years to come.
Ready to make your Business 3.0?
 PREVOIUS WORK EXPERIENCE

Business/Data Analyst | Automation Developer
Microsoft Excel & VBA / Google Sheets Expert | Mentor & Tutor
Got It AI, Remote • San Francisco HQ | 2018 to 2020

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, Kyiv | 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, Kyiv | 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
Freelancer | 2010 to 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 | 2010 to 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
CLIENT FEEDBACK

Andrii had some good ideas right up front that save time and resulted in a solution that worked very
well. His quick understanding of my systems setup and the need to be met had a big impact on the
success of the project. The solution he developed worked the first time. He followed up well and was
interested in the overall success of what I was attempting.

Andrii did excellent work for me on this project. I needed code to integrate three separate computer
programs in an established workflow that had not been running smoothly. His solution had a big
impact. It effectively automated key steps of the workflow and made the entire process run in less
time and more smoothly (big drop in number of crashes). Andrii carefully studied the current
processes and made targeted suggestions. We worked through them methodically and came up with a
robust solution. His work is high quality and on time. His communication skills are excellent and he
always followed through meeting objectives we had agreed to. He is a pleasure to work with.

Andrei was an absolutely amazing freelancer to work with. He was super efficient, very helpful and
understood exactly what I wanted (even though I struggled to explain what I wanted myself.

Andrii was great to work with. Andrii was responsive and always sought to make sure I was getting the
best possible outcome. Thank you!

Andrii was amazing. He really took the time to understand the scope of the project, asked great
questions, took initiative and even improved our vision. We worked with him for two jobs already and
will certainly be using him again. I highly recommend him. Professional, skilled, a great communicator
and able to meet deadlines.

Andrii is incredible. We've been working with him for a while and this is the third job he did for us
successfully and exactly to our standards. I highly recommend him.

Andrii has completed several projects for me and each one has been done with the type of care I
would do if I had his skills. His attention to getting the project done right is a huge benefit. He can see
the big picture of what needs to be done, work through the details rigorously, and his interpersonal
style and skills make the process go smoothly. Thank you, Andrii!!

Andrii always does a great job. We've worked with him on numerous projects and will need his
services again in the future. He's highly recommended.

I've worked with Andrii on multiple projects at this point and really value his skill level, adherence to
details and punctual nature. He's also a great communicator. We'll be working with him again for sure.

Exceptional Work! In my honest opinion, during my time working with Andrii, his strategic thinking and
problem solving skills undeniably far out reaches anyone in business / IT logic. More projects
underway!
Andrii has exceptional knowledge in business and technology. We were able to successfully work
towards our end goal. Our solution now works flawlessly! Thank you!
 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 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 (Hardcore Lineage II old-school player)
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)
MUSIC
Alternative Rock
Metal
Classic Music
Electronic Music
BOOKS
What I have read in 2022
Updated list of book will be available at 420.bible
 MY SOCIALS & RESOURCES

Everywhere Andre de Bonk 🇺🇸 Andre de Bog🇺🇦

Twitch
X
Instagram
FB
Reddit
Telegram
YouTube
Pinterest

Portfolio:
doobOak.com

CONTACT INFO
420.bible

doobOak.ai

Kyiv, Ukraine

[відкрити контакти](див. вище в блоці «контактна інформація»)

[відкрити контакти](див. вище в блоці «контактна інформація»)
[відкрити контакти](див. вище в блоці «контактна інформація»)
@AndreDeBonk

@doob_Oak

upwork.com/fl/andredebonk
 innovative workspace at
doobOak.ai, designed for both
health and productivity:

- An expansive 200x100 cm desk,
adjustable up to 130 cm in height.
- A Xiaomi walking pad that goes up
to 6 km/h, perfect for staying
active.
- The Contessa Okamura chair
allows for comfortable work for 16+
hours.
- Lighting is top-notch with an
Elgato Ring Light and four Elgato
Lights.
- Efficiency is boosted with two
Stream Deck Xls.

DOOBOAK.AI – THE TIME MACHINE

- For seamless multitasking, I've
got an Android mirror along with a
Galaxy M.
- High-quality streaming is made
possible with an Elgato Facecam
and a Logitech C922.
- My trusty Galaxy Fold 5 with 8/1tb
is always at hand with Galaxy
Watch 6.
- The Lenovo Legion Go laptop
provides powerful mobility.