• Designed a 15-module curriculum covering formulas, automation workflows & AI-powered integrations
• Authored video lessons, detailed study guides, hands-on assignments, and evaluation criteria
• Led live cohort sessions, provided personalized feedback, and evaluated student performance
• Taught 300+ students to build CRM dashboards, trigger-based flows, Telegram bots & data visualizations

• My full CV is available at https://cv.doobOak.ai

TOOLS & TECH:

• Python • JavaScript • SQL • API • JSON • XML • REST • GraphQL • SOAP
• Custom GPT agents • AI Studio (Gemini) • Claude • Grok • CoPilot • Perplexity • Vercel v0
• Zapier • Make • n8n • IFTTT • Automate.io • Parabola • Clay • Relevance.ai
• Airtable • Telegram & Slack Bots • Chat Automation • Power Apps • App Sheet
• Looker Studio • Tableau • Power BI (DAX) & Power Query (M) • Databox • R Studio
• BPMN 2.0, UML: Lucidchart • Miro • Draw.io • Microsoft Visio • SmartDraw
• WordPress • PHP • HTML • CSS • WooCommerce • Shopify • bubble • Webflow
• Power Automate • UI.Vision • AutoMouseKey • FileMaker Pro • AutoHotkey
• HubSpot • ServiceNow • Zoho • Github • Trello • Jira • Confluence
• E-commerce, ERP, CRM, ERM, Data Management, AdTech

CORE COMPETENCIES & DOMAIN Skills:

• Intelligent Automation & System Design
• Data Engineering • Ecosystem Integration • Business Process Optimization • AI Integrations
• ETL • Complex Dataset Processing • Real-time Data Transformation • Multi-format Reporting
• Data Backups (scheduled/event-driven) • DB sync (MySQL, MS Access, Airtable) • Snapshots
• Data Scraping & Interactive Web Automation (forms, auth, dynamic elements, DOM parsing)
• Web APIs, Webhooks, Webapps, Cross-Platform Endpoints, Custom API Bridges, Async Logic, Callbacks
• OS?level automation (Windows): PowerShell • WinAPI • ADO/OLE DB • VBScript/WSH • Batch Scripts

• End-to-end Email Automation:
• Customer Relationship Management & Lead Gen Integration • Regex Validation • Smart Segmentation
• Trigger-based Dispatching (SMTP, Gmail API) • Dynamic Templates • Personalized Workflows

• Professional Microsoft Excel & Google Sheets Development | Advanced VBA & Google Apps Script
• Sheets-as-apps Architecture: GUI development • modular logic • UX-first interfaces • Interactive UI forms
• Formula Nativity (FILTER, QUERY, ARRAYFORMULA, REGEX, LAMBDA) • User-defined & Named Functions
• Power Pivot Tables & Charts: Multi-level Grouping • Calculated Fields • Slicers • Drill-downs
• Interactive Dashboards: KPI • CRM • 3D Graphs • Visual Layers
• Financial Modeling • Planning • Forecasting • Automated Data Analysis & Business Intelligence
• End-to-end Reporting Pipelines with BI Integration (Power BI, Looker, Tableau)

• Business Operations Stack: Task & Resource Tracking • Data Flow Monitoring • Invoice Generation
• Calculators, Solvers & Parametric Input Models — Business, Financial, Insurance, Fitness, Custom types
• Smart Decision Frameworks: Triggers • Alerts • Notifications • Event-driven Logic

• Workflow & Data Integration: Microsoft Office — SharePoint, InfoPath, Outlook, PowerPoint, Word
• Google Workspace Integration — Admin Console (user provisioning, access control, aliasing)
• Drive, Docs, Forms | Cross-app sync flows: Sheets - Slides - Sites, Gmail - Calendar

• Led a deep department's workflow analysis: BI, Front-End, Data Aggregation, Data Science, Admintech
• Identified inefficiencies, streamlined processes, enhanced operations and task management system
• Researched, evaluated, and deployed AI tools (Claude, Gemini, Perplexity, Relevance.ai, Cursor, Vercel v0)
• Authored departmental workflow guides: standardizing processes and ensuring alignment across teams
• Enhanced data analysis with more dynamic & insightful ways to interpret data using 3D visualization tools
• Developed and implemented custom automations: HubSpot Workflows, Slack bot, Custom GPTs, ZapierAutomated reporting processes and data flows from Drive & Sheets to Google Sites & Google Slides
• Established and managed DKG AI Hub: an ecosystem for AI research, tools, and cross-departmental work

• Lead Analyst on a high-volume AI-driven platform – delivered 2500+ business consulting sessions
• Advised C-level executives, founders, traders, product managers, and analysts across 20+ industries
• Identified core business needs, architected scalable automation systems, and cross-functional data flows
• Designed decision frameworks, predictive models, real-time data pipelines, and actionable visualizations
• Produced technical documentation, workflow blueprints, branching logic, and modular support flows
• Mentored experts, designed recruitment assessments, ran stress scenarios & built a vetted expert network
• Led QA audits of expert sessions: reviewing diagnostic flow, solution design, empathy & communication
• Created KPI dashboards and monitoring systems to evaluate performance and expose capability gaps
• Contributed to building a dataset for AI/LLM training, platform UX/UI refinement, and feature testing
• Authored structured knowledge base articles with guided tutorials, visuals & reusable workflow templates

• Queried, structured & analyzed multi-dimensional sales and marketing data via GSSM/SAP BI systems
• Built interactive dashboards, adaptive visualizations, forecasting models & VBA-powered data pipelines
• Replaced legacy reporting with dynamic, button-triggered UI systems for weekly/monthly operations
• Delivered data-driven presentations & strategic briefs to Samsung C-level, including SEUC President
• Designed the innovation concept, growth strategy & marketing roadmap for Samsung Innovation Center

• Led a Scrum project to design & deploy an Ideation Web Platform for factory efficiency improvement
  – Defined scalable system architecture, user flows & role-based UI logic for workers, moderators & experts
  – Coordinated dev & analyst teams, led weekly QA of deliverables, authored release briefs, reported to C-lvls
  – Full project & technical documentation: user stories, business requirements, test plans, SLAs, flowcharts
• Designed, developed, and managed iShare – a learning platform connecting niche experts with employees
  – Built workflow automation with SharePoint, InfoPath, Excel VBA, Outlook scheduling & digital signatures
  – Delivered internal trainings on Excel, Outlook & VBA, provided ongoing tech support via ServiceNow
  – Organized cross-department teambuilding events for IT and BI units

• Developed dynamic websites and online platforms using WordPress (HTML, CSS, JavaScript, PHP), including landing pages, blogs, e-shops, and community forums.
• Engineered custom plugins for niche trading communities, delivering tailored functionality and front-end enhancements.
• Provided professional translation and localization services (English ? Ukrainian/Russian), covering technical, marketing, and UI/UX content.
• Built a proprietary VBA-powered market analyzer for MMORPG economy: auto-parsing item prices, applying custom ROI filters, and generating actionable signals.
• Monetized in-game arbitrage insights to self-sustain 9 premium accounts and grow virtual capital — applying real-world economic logic to simulated ecosystems.
  
• Skills: Wordpress Development · JavaScript · PHP · MySQL · Custom Plugins · Excel VBA · Data Parsing · System Automation · Process Automation · Web Scraping · Market Analysis · Game Data Analytics · Translation · Low-Code / No-Code Development

• Built a large-scale knowledge base (15K+ expert posts) analyzing complex MOBA mechanics
• Created Excel-based dashboards with VBA & automated calculators for hero optimization
• Led a 70-member guild “Hello World” (1000+ applicants), achieved top tournament rankings
• Launched weekly meta-analysis series using data scraping, trend modeling & automated visuals
• Provided private consultations, balancing strategies & build recommendations
• Beta-tested new game patches on private servers, identified exploits and optimization flaws
• Produced YouTube videos, Twitch streams & promotional content; managed official live shows
• Moderated large game forum & social channels: user support, feedback routing, community growth
  
• Skills: Data Analysis · Data Analytics · Data Modeling · Data Parsing · Data Reporting · Data Visualization · Game Data Analytics · Excel VBA · VBA · Visual Basic for Applications (VBA) · KPI Dashboards · Dashboard Builder · Market Analysis · Scripting · Game Mechanics · Customer Service Management · Online Community Management · Content Creation · Team Leadership