Денис

Denys Farafonov
Data / Business Analyst — SQL | Sales & Inventory Analytics | E-commerce
Spain (open to remote)
[open contact info](look above in the "contact info" section)
Mobile phone: [open contact info](look above in the "contact info" section)
SUMMARY
Data / Business Analyst with 10+ years of experience working with business data, relational databases, sales analytics, reporting, data processing, and automation.
Strong background in MS SQL Server and Oracle, with extensive experience analyzing large datasets, identifying anomalies and business issues, validating data, developing analytical logic, and translating business requirements into automated solutions.
Hands-on experience in distribution and physical goods, including sales analysis, inventory turnover, customer and sales-performance analysis, returns, order processing, and operational data.
Earlier experience in pharmaceutical distribution included inventory turnover analysis and identification of excessive and slow-moving stock. Later participated from the IT side in defining requirements for an automated inventory optimization function based on daily sales history and demand patterns.
Experienced in working directly with business users, operations, and developers to turn analytical findings into practical process improvements and automation.

KEY ACHIEVEMENTS
• Analyzed sales and inventory turnover in pharmaceutical distribution, identifying slow-moving and excessive stock and investigating the operational reasons behind inventory problems.
• Participated in the development of an automated inventory optimization function based on daily sales data accumulated over several months and designed to reduce the influence of occasional demand spikes.
• Built a Prom / LiqPay / Navision data reconciliation workflow, matching marketplace orders and payments with accounting documents and identifying ambiguous matches for manual review.
• Designed and implemented an automated returns-processing system integrating with Nova Poshta API, reducing manual processing.
• Reduced execution time of a high-load pricing distribution query by 70–80% by refactoring SQL logic using CTEs (Oracle).
• Built a monitoring system for background services, detecting repeated failures and triggering alerts.
• Restored system functionality within one day after breaking changes in an external Prom API by adapting MS SQL procedures.

PROFESSIONAL EXPERIENCE
Backend / Integration Engineer (MS SQL Server)
SMARTY UA — Ukrainian distributor of children's products
Feb 2025 – Present
• Analyze and validate business data supporting sales, orders, returns, logistics, and other operational processes.
• Design SQL Server solutions for business-critical data processing and automation.
• Develop complex SQL queries, stored procedures, and business logic.
• Investigate inconsistencies, anomalies, and data-quality issues in operational data.
• Develop and maintain integrations with external APIs, including Nova Poshta and Prom.
• Work with structured and semi-structured data, including JSON and external API responses.
• Translate business requirements into database logic and automated workflows.
Key Contributions:
• Designed and implemented an automated returns-processing system integrating with Nova Poshta API, reducing manual processing and improving operational efficiency.
• Developed a Prom / LiqPay / Navision reconciliation workflow, matching marketplace orders and payments with accounting documents and identifying ambiguous matches for manual review.
• Developed backend logic for business processes involving orders, customers, payments, and product-related data.
• Built a monitoring system for background services, detecting repeated failures and triggering automated alerts.
• Rapidly adapted SQL procedures to breaking changes in the external Prom API, restoring system functionality within one day.
• Implemented backend logic for a B2B bonus system, processing JSON payloads and applying business rules to order data.
• Designed API key lifecycle monitoring for Nova Poshta, including expiration tracking and automated notifications.

Database Engineer / Backend Developer (Oracle)
ISD Information Systems — partner of SCC Soft Computer
2020 – Present
• Design and optimize complex SQL queries, stored procedures, and packages in Oracle Database.
• Analyze execution plans and implement SQL and indexing optimizations.
• Work with large datasets containing millions of transactions.
• Develop backend data-processing logic for business-critical systems.
• Investigate data inconsistencies and support data-quality troubleshooting.
• Work with business and engineering teams to improve data workflows and reporting.
• Translate business requirements into reliable database solutions.
Software Developer
ISD Information Systems — partner of SCC Soft Computer
2018 – 2020
• Maintained and enhanced legacy systems using C++, PL/SQL, and enterprise tooling.
• Supported backend components and data-processing pipelines.
• Worked with multithreading and system-level logic.
• Used SVN and Unix/AIX environments.
Embedded Software Engineer
Space Systems Engineering Ukraine
2016 – 2017
• Developed onboard control software using C/C++ on Linux-based systems.
• Worked with embedded systems and resource management.
• Used Git for version control.
Backend Developer / Integration Engineer
BaDM Ltd — large pharmaceutical distributor
2012 – 2016
• Developed and maintained backend systems using Oracle Database, PHP, and REST APIs.
• Implemented business logic through stored procedures and backend services.
• Optimized database queries and internal system performance.
• Supported internal web applications and backend integrations.
• Worked with business users and operational teams to translate business requirements into IT solutions.

Business Analyst (IT Department)
BaDM Ltd
2011 – 2012
• Collected and formalized business and technical requirements.
• Participated in software validation and quality control.
• Worked with business users to clarify requirements and translate them into development tasks.
• Participated in defining requirements for business analytics and operational automation.
Analyst (Sales Department)
BaDM Ltd
2008 – 2010
• Analyzed sales and inventory data for a pharmaceutical distribution branch.
• Worked with thousands of SKUs and large monthly datasets covering the branch's product assortment.
• Prepared Excel reports for the Head of Sales / Branch Director on sales, inventory turnover, customers, and sales personnel.
• Investigated slow-moving and excessive inventory and identified operational reasons behind inefficient stock allocation.
• Analyzed inventory turnover and discussed identified issues and possible solutions with business and logistics teams.
• Conducted field observations, including warehouse visits and accompanying delivery drivers, to understand operational processes behind the data.
• Identified cases where expensive products remained inactive at a branch warehouse despite the availability of a regional distribution center in the same city.
• Later participated from the IT side in defining requirements for an automated inventory optimization function.
• The resulting solution used daily sales data accumulated over several months and accounted for demand patterns while reducing the influence of occasional sales spikes.
• Worked with large Excel datasets; some product reports exceeded the row limits of Excel versions used at the time.

TECHNICAL SKILLS
Data & Business Analysis
• Sales analysis
• Inventory turnover analysis
• Slow-moving and excessive stock analysis
• Demand analysis
• ABC / XYZ analysis
• Customer and sales-performance analysis
• Data validation and reconciliation
• Anomaly and inconsistency investigation
• Business reporting
• Process analysis and optimization
• Requirements analysis
Databases & SQL
• MS SQL Server
• Oracle / PL/SQL
• Complex SQL queries
• CTEs and analytical/window functions
• Stored procedures and packages
• Query optimization
• Indexing and execution plans
• Large dataset processing
• Data transformation
Integration & Automation
• REST APIs
• Webhooks
• API integration
• JSON data processing
• Process automation
• System integration
Tools & Programming
• Excel
• C++
• C#
• PHP
• JavaScript
• Git
• SVN
• Linux / Unix / AIX
LANGUAGES
• English — B2
• Spanish — basic, in progress
• Russian — fluent
• Ukrainian — fluent
EDUCATION
Master’s Degree in Computer Science
National University of Dnepropetrovsk