Андрій

Andrii Dubok
VISIONARY ENGINEER
Business Analyst | Project Manager | Web/AI
Data Analyst | Automation Developer

🚀 Crafting custom automation solutions since 2010 Time is the most valuable resource.
🧠 Optimizing and automating business processes I don't waste it.

🔗 Integrating seamless digital workflows
ACADEMIC BACKGROUND ADVANTAGES
🚀 Tech & Automation Expertise
Krakow University of Economics AI/ML & Low-Code/No-Code Enthusiast
Erasmus+ English MA in Poland
Ultra-fast typing (top 1%, >100 WPM)
Financial Management | 2016-2017
100% Googling skills, Deep Research
Kyiv National University of Trade Advanced LLM dev, CRM & bot builder
and Economics
Pro Coder: Python, JavaScript, PHP, SQL
English MA (with Honours)
Financial Management | 2016-2018
– BA: Corporate Finance | 2012-2016
🗣️ Communication & Language Proficiency
Fluent English | IELTS C1
Kyiv National University of Trade BA – English Translation | English Tutor
and Economics
Native Ukrainian
Bachelor's degree
Professional Negotiator
English Translation | 2013-2017
Confident Public Speaker
Scrum 4 Teams Training
Kyiv, 2017
📊Strong Financial Background
NTUU KPI Excel & Google Sheets God
Physics and Mathematics Lyceum Data Wizard (Power BI, Tableau, Looker Studio)

CONTACT INFO
🏆Top Rated Plus Upwork Freelancer
Worked in six international companies
doobOak.ai
More than 50 successful long-term projects
Over 2500 clients (US, Canada, UK, Australia)
Kyiv, Ukraine
I worked with:
[відкрити контакти](див. вище в блоці «контактна інформація»)
Crypto Traders | Investors | Stockbrokers
[відкрити контакти](див. вище в блоці «контактна інформація») CEOs | CFOs | Senior Management | Startups
[відкрити контакти](див. вище в блоці «контактна інформація»)
@AndreDeBonk Finance • Marketing • Sales • Insurance
Manufacturing • Construction • Real Estate
@doob_Oak
Government • Healthcare • Education
upwork.com/fl/andredebonk
Agriculture • Media • ... • And many more
 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 2025
upwork.com/fl/andredebonk
Professional Microsoft Excel & Google Sheets Development
Formula Nativity | Advanced VBA / Google Apps Script (JavaScript) Portfolio:
Full Automation | Workflow Optimization | Digital Integrations doobOak.com
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 doobOak.ai
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

TECH STACK

Python: NumPy, Pandas, TensorFlow, Keras, Flask, PyTorch, OpenCV
JavaScript: TypeScript, React/Redux, Vue/Vuex, Angular 9, Node.js
SQL, NoSQL, MongoDB, Redis, GraphQL, PostgreSQL, MySQL, SQLite
HTML5 • CSS3 • PHP • WordPress • Shopify • WooCommerce
Power BI (DAX) • Looker Studio (Google Data Studio) • Tableau
Power Query (M) • Power Pivot
Databox • Alteryx • R Studio
Airtable • Power Apps • App Sheet • bubble.io • Webflow • Telegram Bots
E-commerce, ERP, CRM, ERM, Data Management, AdTech
GPT4o • CoPilot • Claude • Gemini • Perplexity • Relevance.ai • Cursor • Vercel v0
Microsoft Flow • Zapier • IFTTT • Make • Automate.io • Parabola • Clay • n8n.io
Alteryx • R Studio
Power Automate • Automatic Mouse & Keyboard • FileMaker Pro
Java • Delphi • PascalABC.NET • VBS • Batch Scripts
 PREVOIUS WORK EXPERIENCE

Head of Automation and CRM/ERMS Development Services

Deep Knowledge Group, Remote • United Kingdom | 2024

Led a comprehensive workflow analysis across multiple departments (BI, Front-End,
Data Aggregation, Data Science, Admintech) to identify inefficiencies, streamline
processes, and enhance overall company operations.
Developed and implemented advanced automation solutions using HubSpot, Zapier,
Google Apps Script, and Google Sheets, automating reporting processes and
integrating data seamlessly with Google Slides for more efficient presentations.
Researched, evaluated, and deployed cutting-edge AI tools (GPT-4o, Claude, Gemini,
CoPilot, Perplexity, Relevance.ai, Cursor, Vercel v0) to optimize task automation and
significantly boost productivity across all departments.
Spearheaded the transition to Trello, coordinating workflow improvements to create
a more cohesive and effective task management system across departments.
Authored comprehensive departmental workflow guides, standardizing processes
and ensuring alignment across teams to improve operational efficiency.
Led innovation in 3D tool visualization for enhanced data analysis, providing
departments with more dynamic, insightful ways to interpret data.
Established and managed the DKG AI Hub, overseeing the integration and utilization
of AI tools, gathering feedback from stakeholders, and reallocating software
licenses to maximize productivity and resource utilization.
 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

Client 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, Power BI 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 (Scrum) 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
Managing game clan “Hello World” with 70 members | Tournament winner
 My course Google Sheets: from zero to Hero in 2 months
Watch it
 Portfolio of
Business
Automation

doobOak.com
Google Docs Portfolio

doobOak.ai
The Time Machine
Website

Upwork.com/fl/
andredebonk
 Innovative workspace at
doobOak.ai – The Time Machine

Designed for both health and
productivity

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

DOOBOAK.AI – THE TIME MACHINE

High-quality video meetings are
possible with an Elgato Facecam,
Logitech C922, Blue Microphone
Yeti, two Elgato Green Screens
My trusty Galaxy Fold 5 with 8/1tb
is always at hand with Galaxy
Watch 6
8 monitors setup
 Darius Askaripour Lana Kerr
Managing Partner CEO
Varys Capital Lumisque Skincare

WHAT PEOPLE SAY ABOUT
ANDRII

«seeks the best-supported and most logical solution to
problems»
«high tolerance for ambiguity. He can quickly discern logical
consistencies and inconsistencies within a set of facts»
«effective at processing information and making decisions
that are a good fit for the existing circumstances»
«enjoys solving complex problems»
«seeks optimal solutions based on the facts»
«creative and has a big-picture perspective»
«seeks something larger than the best solution; he seeks
universal truth, preferably one that has not been seen before»
«can quickly recognize patterns across seemingly unrelated
elements»
«scans the horizon for opportunities and threats and can see
possibilities that are often not apparent to others»
«creative in finding answers to problems and can easily
visualize future alternatives and consequences»
«identifies and has confidence in relevant options that are not
widely recognized as being valid or worthwhile»
«tends to excel at creative and innovative decision making»

Vlad Trach
Jeffrey Hansen
Business Development Manager Research Director
MedRX Infusion CPM Investing LLC
CLIENT FEEDBACK upwork.com/fl/andredebonk

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
High-tech and innovative products
Kickstarter & IndieGoGo
Gaming (Hardcore Lineage II 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
Freedom Fighter, Rebellion Philosopher
MUSIC
Alternative Rock
Metal
Classic Music
Electronic Music
 MY SOCIALS & RESOURCES

All my resources on one page: 666.adult

Twitch
X
Instagram
FB
Reddit
Telegram
YouTube
Pinterest

Portfolio:
doobOak.com

CONTACT INFO
420.bible

doobOak.ai – The Time Machine

Kyiv, Ukraine

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

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

@doob_Oak

upwork.com/fl/andredebonk