Most AI-powered WhatsApp bots look great in a demo and quietly break in week two. This article walks through six production patterns — webhook verification, idempotent handling, LLM fallbacks, dual logging, human escalation, and conversation history — applied to a real WhatsApp A...
Business Automation Developer
Turning manual business work into reliable automation
תל אביב-יפו, ישראל
פרילנסר
לרוב מגיב תוך יום
-->
פרסום מאמר
אודותינו
I help small and medium businesses reduce manual work by automating reports, Excel files, SQL data, APIs, documents, CRM workflows, WhatsApp messages and internal business processes.
I build practical tools such as PDF / invoice extraction systems, CRM automations, WhatsApp auto-responders, Excel / SQL reports, Python scripts, API integrations and AI assistants over business data.
I can help with document automation, Excel / Google Sheets automation, SQL reports, Python scripts, API integrations, CRM workflows, WhatsApp / Telegram automation, ASP.NET / C# internal tools and practical AI data tools.
Typical problems I solve: manual reports, repeated data entry, messy Excel files, slow lead handling, manual PDF processing, repetitive WhatsApp messages and disconnected systems.
I am a Senior .NET / Python developer with 20+ years of software development experience, including 11 years building and supporting internal enterprise systems for an aerospace manufacturing company.
My deeper engineering background includes analytical problem solving, performance-sensitive logic, data extraction workflows, React-based dashboards and internal mobile reporting tools for enterprise systems.
Before writing code, I clarify the data, the desired result, the users, the workflow and what should happen if something goes wrong.
For a first step, I usually recommend a small milestone: process review, automation plan or working prototype for one recurring task.
I build practical tools such as PDF / invoice extraction systems, CRM automations, WhatsApp auto-responders, Excel / SQL reports, Python scripts, API integrations and AI assistants over business data.
I can help with document automation, Excel / Google Sheets automation, SQL reports, Python scripts, API integrations, CRM workflows, WhatsApp / Telegram automation, ASP.NET / C# internal tools and practical AI data tools.
Typical problems I solve: manual reports, repeated data entry, messy Excel files, slow lead handling, manual PDF processing, repetitive WhatsApp messages and disconnected systems.
I am a Senior .NET / Python developer with 20+ years of software development experience, including 11 years building and supporting internal enterprise systems for an aerospace manufacturing company.
My deeper engineering background includes analytical problem solving, performance-sensitive logic, data extraction workflows, React-based dashboards and internal mobile reporting tools for enterprise systems.
Before writing code, I clarify the data, the desired result, the users, the workflow and what should happen if something goes wrong.
For a first step, I usually recommend a small milestone: process review, automation plan or working prototype for one recurring task.
שפות
רוסית
שפת אם
עברית
שליטה קרובה לשפת אם
אנגלית
שליטה טובה
תחומי התמחות
טכנולוגיה
ניתוח מערכות
Analysis of business processes, data flows, system boundaries, integration points and risks before implementation. Useful for turning unclear operational problems into a clear automation plan.
CRM ו- ERP
CRM and ERP workflow automation: forms, leads, alerts, Google Sheets, WhatsApp/Telegram messages, audit logs, reports and SAP-connected enterprise integrations.
פיתוח אינטגרציה
Business system integrations that connect data, APIs, CRM, Excel, databases and internal tools so teams do not need to copy information manually.
פיתוח באמצעות AI
Practical AI features inside real business workflows: LLM API integration, RAG, NL-to-SQL, structured outputs, document extraction, classification, summaries and validated AI-assisted tools.
תכנות ופיתוח תוכנה
.NET, C#, Dot Net, VB
Production C# / .NET / ASP.NET development for internal business systems, APIs, SQL Server workflows, Windows Services, reporting tools and SAP-connected enterprise processes.
ASP.NET
ASP.NET backend and internal portals with role-based access, admin tools, REST APIs, complex forms, SQL Server integration and long-term maintainable architecture.
HTML5, CSS3, JavaScript
Front-end work for internal portals, dashboards and business web apps connected to backend systems. Bootstrap, jQuery / DataTables, TypeScript. Used as the UI layer for the systems I build, rather than as a standalone front-end specialty.
Scripting
Automation scripts and workflows using Python, n8n and Google Apps Script for files, APIs, CRM updates, alerts, scheduled jobs, audit logs and error-handled business processes.
מתכנת, פיתוח תוכנה כללי
free skills:
Business Process Automation
Document Automation
Invoice / PDF Extraction
OCR
FastAPI
n8n
Google Sheets Automation
Google Apps Script
Zoho CRM Integration
WhatsApp Business API
Telegram Bot Automation
LLM Integration
RAG
Structured AI Output
NL-to-SQL
ETL Automation
SQL Reporting
API Integration
Business Process Automation
Document Automation
Invoice / PDF Extraction
OCR
FastAPI
n8n
Google Sheets Automation
Google Apps Script
Zoho CRM Integration
WhatsApp Business API
Telegram Bot Automation
LLM Integration
RAG
Structured AI Output
NL-to-SQL
ETL Automation
SQL Reporting
API Integration
DB - PostgreSQL
PostgreSQL for application backends, structured data, analytics, FastAPI systems, document extraction pipelines and AI/RAG-related data workflows.
DB - MSSQL, SQL Server
SQL Server for operational systems, reports, stored procedures, data validation, performance tuning, SAP-connected workflows and business data automation.
VBA, Office, Excel Programming
Excel / VBA automation for existing business processes: reports, controlled data entry, validation, SQL exports, dashboards, forms and tools for non-technical users.
Python
Python for business automation, data processing, API integrations, scheduled jobs, file transformation, document workflows, FastAPI backends, Telegram/WhatsApp automation and AI-assisted tools.
אפיון מפרט טכני
Clear technical specifications for automation and integration projects: scope, data flow, acceptance criteria, risks, implementation stages and a practical first milestone.
פיתוח אלגוריתמים
Algorithm Development
Performance-critical algorithms where brute force isn't viable: scheduling,
routing, resource allocation, matching, retrieval. The core skill is fitting
the algorithm to the problem structure. Strong analytical foundation
(M.Sc. Mathematics).
Performance-critical algorithms where brute force isn't viable: scheduling,
routing, resource allocation, matching, retrieval. The core skill is fitting
the algorithm to the problem structure. Strong analytical foundation
(M.Sc. Mathematics).
API, REST, SOAP
REST / SOAP APIs, webhooks and system-to-system integrations between CRMs, databases, Google Sheets, internal tools, SAP-connected workflows and external services.
קצירת מידע, Data Scraping
Data extraction / ETL automation from websites, files, spreadsheets and APIs into Excel, databases, CRM records or dashboards.
מפתחי Back-end
Backend systems, APIs, background jobs, data-processing workflows and integration layers built with C#/.NET, ASP.NET, SQL Server and Python.
נסיון תעסוקתי
אוגוסט
2025
-
היום
Freelance Business Automation Developer
Freelance, Tel Aviv- Independent development focused on business automation, data workflows, API integrations and practical AI-assisted tools.
- Selected portfolio project:
- AI-assisted financial data research platform for Israeli investment products. Users can ask questions in Hebrew or English; a validated NL-to-SQL workflow generates controlled SQL queries; results are displayed in React dashboards.
- The system is designed for professional research and comparison support, not personal investment advice.
- Main work areas:
- Python / FastAPI backends, PostgreSQL data workflows, React dashboards for data-heavy applications, Excel/VBA automation, Google Apps Script, n8n / Zapier workflows, CRM and Google Sheets integrations, LLM API integration, RAG, structured AI output and data extraction / ETL automation.
- Current focus:
- small and medium business automation — reducing manual work, connecting systems, improving reporting workflows and building practical AI tools over real business data.
מאי
2014
-
יוני
2025
Senior Software Developer / Internal Systems Developer
Mechano-Deen Ltd- Aerospace parts manufacturer with 80+ employees.
- Senior developer responsible for major internal software systems across manufacturing, operations, finance and management workflows.
- Worked end-to-end across the full software lifecycle:
- requirements, system analysis, architecture, development, QA, production rollout and long-term support.
- Built and maintained:
- - ASP.NET internal portals with role-based workflows
- - C# / .NET backend systems
- - MS SQL Server operational and reporting workflows
- - bidirectional .NET ↔ SAP integration for PP and MM modules
- - Windows Services for scheduled and overnight multi-threaded processing
- - Excel/VBA add-ins and tools for operational staff
- - internal mobile reporting tools using .NET MAUI / Xamarin
- - financial management system for a subsidiary company
- Additional technical work included analytical and algorithmic problem solving for operational workflows, scheduling, matching, data retrieval and performance-sensitive logic.
- Impact:
- approximately 40% reduction in data-processing errors, significant reduction in document-handling time across SAP-connected workflows, and production systems used by 80+ employees.
- Stack:
- C# · .NET · ASP.NET · MS SQL Server · SAP PP/MM · Windows Services · Excel/VBA · .NET MAUI / Xamarin · REST/SOAP integrations
יוני
2006
-
מאי
2010
Senior C++ Software Developer
| Controp Ltd , Hod Hasharon- Developed performance-sensitive C++ software for electro-optical systems in defense and aerospace environments.
- Work included multithreaded Win32 / MFC development, DLL modules, image and video processing, and real-time hardware communication over TCP/IP, RS-232 and RS-422.
- This role strengthened my background in complex codebases, hardware/software integration, performance-sensitive logic and reliable production software.
פברואר
2004
-
פברואר
2006
Software Developer
Project-Based Roles, Tel Aviv- Developed client-server and database-based software tools using C# / .NET, MySQL and C++.
- Projects included an exam-bank client-server system, accounting and finance database utilities, automation tools and algorithmic engines.
- This period strengthened my analytical background, including algorithmic problem solving, graph-based logic, search, classification and decision engines.
ינואר
2002
-
ינואר
2004
C/C++ Software Developer
Roseman Engineering , Tel Aviv- Developed C/C++ software for gas-station management systems.
- Work included POS integration, FTP-based data synchronization between local terminals and central servers, and Windows desktop tooling for operational environments.
ינואר
1999
-
ינואר
2001
C/C++ Software Developer — CAD/CAM Modules
PTC (Parametric Technology Corp.) , Haifa- Developed CAD/CAM modules for Pro/ENGINEER used in aerospace, automotive and industrial engineering environments.
- Worked with C/C++ on Windows and Solaris UNIX, including GUI development, legacy codebases and performance optimization.
קורסים, הסמכות, לימודי תעודה
ינואר
1999
Professional programming course
Ashrot- (600h) – C/C++, VC++, VB, MFC, Access, SQL/Oracle (1999).
תארים אקדמיים
אוגוסט
1980
-
יולי
1986
M.Sc. Mathematics
Tashkent State University- M.Sc. Mathematics
פעילות התנדבותית
אפריל
2006
-
מאי
2010
מתנדב/ת ליווי אישי
סיוע לבעלי מוגבלויות ולמשפחותיהם- Accompanying a resident or person with a disability to community activities, day centers or family support.
שירות צבאי
אוקטובר
1996
-
אפריל
2004
Reserve duty — Security Battalion
Security Battalion- Reserve duty: security and operational assignments, periodic deployments. Total ~7.5 years of part-time service alongside civilian software career.
פורסם על-ידי Business Automation Developer
קישורים
github.com/refaelcodes-blip
refaelcodes-blip - Overview
refaelcodes-blip has 5 repositories available. Follow their code on GitHub.
18 תחומי התמחות
מבקרים גם צפו ב...
מכירים בניית עיצוב ופיתוח אתרים
מכירים , מומחה לפתרונות אינטרנט PHP MYSQL CSS JAVASCRIPT React Angular NextJS Flutter React Native
יאיר ל.
מומחה תוכנה ו-AI
Natan Rubinstein
מתכנת מנוסה
מזי נפשי- מומחית ייבוא גלובלי ופתרונות ניהול משרד
ניהול ייבוא וניהול משרד על כל היבטיו שיצעיד את העסק שלך קדימה
Shibumi-AI
Data Science Solutions