Денис

Denys Farafonov
AI & Automation Specialist | API Integrations | SQL | Business Process Automation

Spain (open to remote)
[відкрити контакти](див. вище в блоці «контактна інформація»)
Mobile phone: [відкрити контакти](див. вище в блоці «контактна інформація»)

SUMMARY

Automation Specialist with 10+ years of experience working with business systems, relational databases,
backend logic, API integrations, data processing and process automation.

Strong background in MS SQL Server and Oracle, including complex SQL, stored procedures, data
validation, reconciliation, business logic and large-scale data processing.

Hands-on experience automating business processes using SQL, PowerShell, REST APIs, webhooks and
database-driven solutions. Experienced in investigating business processes, identifying repetitive
operations and implementing reliable automated workflows.

Extensive practical use of AI tools including ChatGPT, Claude / Claude Code and Gemini for development,
debugging, SQL optimization, technical analysis and solution design.

CORE SKILLS

Business Automation

Business process analysis
Process automation
Data validation and reconciliation
Reporting automation
Business rules and workflow logic
Production troubleshooting

API & Integrations

REST APIs
Webhooks
JSON / XML
API authentication and tokens
System-to-system integrations
Automated data exchange
API troubleshooting and monitoring

Databases & Data

MS SQL Server
Oracle
MySQL — practical SQL experience
Complex SQL
Stored procedures
Query optimization
Indexing and execution plans
Data processing and validation

Automation & Scripting

PowerShell
SQL automation
Scheduled jobs
File and data processing

Programming

C++
C#
PHP — basic practical / maintenance experience
JavaScript — basic practical / maintenance experience
Python — basic

AI-Assisted Development

ChatGPT
Claude / Claude Code
Gemini
AI-assisted coding and debugging
Reviewing and validating AI-generated code
Using AI for SQL, technical analysis and solution design

Tools

Git
SVN
Linux / Unix

PROFESSIONAL EXPERIENCE

Backend / Integration Engineer (MS SQL Server)

SMARTY UA

Feb 2025 – Present

Develop and maintain backend business logic and database-driven processes using MS SQL
Server.
Build and maintain REST API integrations with external services.
Work with JSON-based data exchange and API authentication.
Automate repetitive operational and data-processing tasks.
Develop integrations with Nova Poshta, Prom and other external services.
Automated processing of Nova Poshta return-related operations.
Restored a broken Prom API integration after an external API change within one day.
Implemented automated monitoring of API credentials and service-related conditions.
Developed Telegram-based notifications and automated operational alerts.
Implement business rules, validation and reconciliation logic in SQL procedures.
Investigate production issues across APIs, databases and business processes.
Use AI tools extensively for development, debugging, refactoring and technical problem solving.

Selected automation work

Nova Poshta

Automated return-related operational processing.
Integrated external API data with internal business processes.
Implemented automated notifications and monitoring.

Prom

Maintained REST API integration.
Adapted integration logic to external API changes.
Implemented JSON data exchange and processing.

Payment / Order Reconciliation

Developed SQL-based matching and validation between payment data and internal orders/invoices.
Automated identification of unmatched transactions.

ISD / SCC Soft Computer

Oracle Database / Backend Engineer

2020 – Present

Develop and maintain Oracle database logic for a large production healthcare software platform.
Develop complex SQL, PL/SQL procedures and functions.
Investigate production issues and identify root causes across application and database layers.
Optimize SQL queries and database operations.
Develop data validation, reporting and business logic.
Support integrations between application components and database systems.
Work with large datasets and production business-critical data.
Translate business requirements and rules into reliable database solutions.

Software / Database Developer

2018 – 2020

Worked with C++, PL/SQL, Unix/AIX and multithreaded application components.
Developed and maintained software interacting with Oracle databases.
Investigated and debugged production issues.
Worked with SVN and Linux/Unix environments.

Space Systems Engineering, Ukraine

Software Engineer

2016 – 2017

Developed C/C++ software for Linux-based and embedded environments.
Worked with Raspberry Pi and hardware/software integration.
Used Git for source control.
Investigated and debugged software issues across system components.

БаДМ

Database / Integration Developer

2012 – 2016

Worked with Oracle databases and business applications.
Developed complex SQL, PL/SQL procedures, functions and database logic.
Developed and maintained database-driven business functionality.
Worked with REST/API-related functionality and system integrations.
Modified an existing PHP/JavaScript web application to implement required business functionality.
Developed database logic supporting operational business processes.

IT Business Analyst

2011 – 2012

Analyzed business requirements and translated them into technical specifications.
Worked with developers to define and clarify system requirements.
Analyzed operational processes and business data.
Participated in optimization of inventory-related processes.

Sales / Inventory Analyst

2008 – 2010

Analyzed sales and inventory data for a regional branch.
Prepared monthly analytical reports for management.
Analyzed product turnover, stock levels and operational bottlenecks.
Identified inefficient inventory allocation and slow-moving products.
Worked directly with warehouse and delivery operations to understand business processes.
Analyzed large datasets containing thousands of products and sales records.

SELECTED AUTOMATION & INTEGRATION EXPERIENCE

REST API Integrations

Integration with Prom, Nova Poshta and other external services, including authentication, JSON
processing, validation, error investigation and automated data exchange.

Operational Automation

Automation of repetitive processes involving orders, returns, notifications, monitoring and data
reconciliation using SQL, PowerShell, APIs and database procedures.

Payment / Order Reconciliation

Automated matching and validation of payment, order and invoice data using SQL-based reconciliation
logic.

AI-Assisted Development

Regular use of ChatGPT, Claude / Claude Code and Gemini for:

code generation and review;
debugging and refactoring;
SQL optimization;
technical research;
solution design;
analysis of unfamiliar technologies.

EDUCATION

Master’s Degree in Computer Science
National University of Dnepropetrovsk

LANGUAGES

English: B2 - Upper-Intermediate
Ukrainian: Fluent
Russian: Fluent
Spanish: Basic