dooboak.ai – Business Automation Development | Excel, Google Sheets

doobOak — The Time Machine

Automation Brings Time Back to You

Andrii Dubok @ Business Automation Developer | Business/Data Analyst
Visionary Engineer | Process Architect | Innovation Advisor

Features

Automation Expertise & Wide Skill Range

Creating automated solutions starting from 2010
Spreadsheet & any software automation, automated in-game bots, Telegram bots, various tools.

Fluent English

IELTS C1, BA degree in English Translation, worked in three international companies, US clients

Tech Innovator

Deeply engaged with modern IT technology, with a passion for exploring and leveraging the latest trends.

Speed Typing Prodigy

Exceptional typing skills, ranking in the top 1% with a speed of over 100 words per minute.

Research & AI Savvy

Proficient in efficient online research, including advanced usage of Chat GPT 4 and other AI tools.

Financial Specialist

Strong financial background with a Master’s in Financial Management and a Bachelor’s in Corporate Finance.

Diverse Clientele Experience

Worked with over 2500 clients globally, including the US, Canada, UK, Australia, demonstrating adaptability and global market understanding.

Global Freelance Achiever

Top Rated Plus freelancer on Upwork, with extensive experience in international settings and over 50 long-term projects.

Low-Code/No-Code Advocate

Skilled in simplifying complex processes, advocating for accessible, efficient low-code/no-code solutions.

Portfolio
Check doobOak.com

Google Sheets Premium Design

Advanced Commission Calculator: Database Architecture, Automation Dev

Google Sheets KPI System: Visuals, Dashboards, Data Entry & Management

Google Sheets Expense Tracker

Comprehensive P&L Template in Google Sheets

Automated Workflow: Gmail > Sheets > new sheet + pdf > Drive

Marketing Planner

Advanced Automation Solution

Pharmacy Google Sheets Formula Automation | Google Apps Script | CRM, Database, JavaScript, GAS, VBA

Pharmacy Google Sheets Formula Automation | Google Apps Script | CRM, Database, JavaScript, GAS, VBA

Client Testimonials

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!

Andrii was very responsive, fast, a team player, and always went the distance. He’s someone we’ve worked with for years and has played an important role in various tasks and builds

What I do

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

About Me

My name is Andrii – Business Analyst, professional Microsoft Excel & Google Sheets Developer, PC Automation Expert, Project Manager, and Process Architect.

I am a big fan of automation and the number one enemy for any routine process. If I have to do anything twice on my PC – it gets automated.

I have been creating custom automation tools and solutions since 2010. Spreadsheets had become my lifestyle when I started working with the data. They gave me the ability to process the information quickly, make a useful analysis, and automate the whole process.

Every sphere and activity of my life has its separate Excel or Google Sheets projects. It allows me to get more value from the data, organize the thinking, make data-driven decisions and relieve my life from the routine. What is most important, it supplies me with Time – the most valuable resource. I don’t waste it.

I used to work in big international companies like Philip Morris and Samsung. Due to my skills and enthusiasm, I was known as the local Excel Guru – I have created numerous business tools for most company departments. My automation allowed me to substitute the work of many people, the long time-consuming tasks have turned into few seconds for reliable scripts, and even the whole processes have been automated.

My contribution to each project is not limited to automation development. I am a master of analyzing and optimizing the processes, finding the most effective approaches, asking the right questions, and sharing my recommendations.

Besides the Spreadsheets Development, I am good and experienced in process management and optimization:

+ IT Project Manager of ThinkWider App (application for submitting ideas and their full processing from reviewing and discussing till implementation and rewarding).

+ Manager and Developer of IShare Educational Platform

++ I am an active top-rated Excel & Google Sheets Expert and Mentor for other experts. I solve around ten different automation cases daily, which are used by the sales staff, managers, HRs, investment agents, and others. Sometimes it seems that I worked with people from every possible sphere. I even helped the employees from the United Nations.

I worked with

Crypto Traders | Investors | Stockbrokers

CEOs | CFOs | Senior Management | Startups

All kinds of industries

Finance • Marketing • Sales • Insurance
Manufacturing • Construction • Real Estate
Government • Healthcare • Education
Agriculture • Media • … • And many more

How other people characterize me:

«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»

Contact me:
https://www.upwork.com/fl/andredebonk

https://www.linkedin.com/in/andredebonk/
andredebonk@gmail.com | andre@dooboak.com — email
Telegram: @doob_Oak