Gainpromo Team
Our team includes specialists in analytics, IT integration, and consulting with hard skills and big experience. We've been working on different projects in such fields as Affiliate Analytics, Marketing analytics, Broker risks analytics, Prediction analytics for CFD Brokers, and much more. Let`s get to know us better.

Andrew
Technology consultant
Andrew- seasoned technology consultant (15 years+ in IT) with extensive knowledge of product delivery and product management for more than 5 years. Had experience with Microsoft Consulting Services and selling solutions to Microsoft clients as Microsoft Solution Sales Professional to the enterprise. Well-established communication and presentation skills. Experience in the international multicultural IT projects. Prefers to lead product team through deep technical stack analysis, architecture planning and key features architecture envisioning. Technically savvy, thus working shoulder to shoulder with engineers to build reliable, scalable, and affordable technical solution based on structured to the tiny detail’s user stories and feature requirements. When it comes to BI related projects prefers to assist engineers, use Microsoft Power BI and contribute to reports delivery at the same time has very detailed understanding of ETL, DWH, MDM, Data Modeling and reporting techniques to manage complex BI solution. For the last 5 years delivers own consulting practice and currently building new product for crypto domain. Recent projects: ▪ Deposit prediction, churn prediction, next trade prediction ▪ Customer segmentation and RFM analysis ▪ Marketing analytics including real-time affiliate cost analysis based on a complex set of deal types ▪ Trading analytics for dealing and risk management teams including multi-cascaded liquidity provider analytics ▪ Management analytics with real-time top-down and bottom-up P&L analysis ▪ Sales analytics for call centers ▪ Real-time sales bonus calculations based on a sophisticated set of rules and conditions like trading activity of the clients ▪ Customer Support analytics

Ievgenii
Expert in data
Ievgenii – an expert in data and data engineering domain with a full-stack BI skills. Proved to have profound knowledge in architecture of data solution and eager to apply new technologies to tackle any sophisticated business challenges. Constantly pushing own professional boundaries through professional certification. The most recent on “Developing Python Apps with Docker” (Pluralsight) and “Microservices Fundamentals” (Pluralsight). Focused to deliver fully automated CI/CD and constantly assist DevOps Team to make it happen. Constantly defining new architecture approaches to split monolith data flows into independent microservices with an aim to optimize cost of ownership and operations. Has extensive experience integrating new data sources (PostgreSQL, AWS SQS, AWS S3, variety of REST API), thus striving to focus on internal frameworks delivery for Python based ETL approach with proper logging and alerting. Recent projects: ▪ Migration of DWH from SQL Server to AWS Redshift, SSIS to Python/Prefect ▪ Customer segmentation and profiling in real-time ▪ Voip analytics in real-time (millions of CDR records and 100+ data sources) ▪ Risks analytics for financial markets including real-time P&L analysis ▪ In-Memory reporting system for international investment bank

Oleksii
Power BI and DAX expert
Oleksii – Power BI and DAX guru, has profound knowledge in Analysis Service (Tabular) and able to provide creating solutions on data modeling with RLS (row level security), partitioning and big volume of data. In addition, has good level of Python development and writing sophisticated SQL backend logic. Has deep economic background thus able to contribute to complex financial calculation. Took part in the biggest Microsoft Dynamics deployment in top Ukrainian bank as data integration and reporting expert. Recent projects: ▪ Trading analytics for financial markets with multi-regulation RLS capabilities by regulation, geo, org structure ▪ Trading risks analytics ▪ Advanced Power BI marketing reporting ▪ Marketing Automation analytics including integration with 10Tb+ 3d party data sources based on Snowflake ▪ CRM integrations and operational reporting for the top Bank in Ukraine

Dmytro
Data engineer
Dmytro – hard working engineer with unique skill of data engineering and predictive analytics. Has extensive experience in Python development and ready to support product management with any bold ideas that my need POC or processing big volumes of data to find some patterns and insights. Have experience as QA Engineer in data and BI projects, thus highly skilled in test automation. Prefers highly iterative Kanban development approach thus feeling “ok” in a very dynamic business environment. Recent projects: ▪ Deposit prediction, Next Trade Prediction ▪ Liquidity Provider chain analysis, risk analytics ▪ Facebook Ads, Google Ads integrations and real-time analytics of affiliate traffic ▪ Machine learning for recognition car license plate ▪ Neural networks for image segmentation and object detection

Anna
QA specialist
Anna – prominent QA with deep knowledge data analysis, Python development and background in Data Science. Contributes to the team development as a Python coach. Able to grasp complex business issues very fast and propose actionable solution. Advanced skills in data quality validation using SQL and Python, automation of data validation processes, data integrity checks for REST API data sources and Data Warehouse (DWH), validation of new metrics in tabular model, providing test with BI Data Model to find gaps and issues. Recent projects: ▪ Trading Analytics with clustering behavioral patterns in trading strategies ▪ Conversion prediction model ▪ Marketing Automation analytics ▪ Sales Bonus Engine

Sergei
Data Integration Architect
Sergei – Data Integration guru and Azure architect with a proven worldwide recognition by BizTalk community. Delivered series of BizTalk books as co-author. He is a professional with a proven success in architecting and delivering complex mission critical integration solutions. He’s been working in several domains including Government, Utility/Energy and Oil&Gas. Since 2005 his primary tool for delivering EAI solutions has been BizTalk Server. Recent proliferation of the cloud technologies added a stack of the Azure-based services for delivering scalable, secure and cost-efficient integrations. His experience includes, but not limited to: •Architecting and developing large scale Azure Cloud, hybrid and on-premises integration solutions using Microsoft Integration Technologies •Helping corporations to establish sustainable and efficient Enterprise Application Integration (EAI) practice – setting up relevant processes, hiring, and training resources. •Managing geographically distributed development teams. •Migrating on-premises workloads to Azure – readiness assessment, cost and time analysis, planning, execution. •Establishing DevOps processes and procedures – one of the key elements of any successful EAI implementation. •Supporting mission critical applications in production environment on 24/7 basis. This experience to significant degree formed his views on how integrations should be designed and built Some of his technical solutions were recognized by Microsoft as the best practices of using BizTalk Server and included in the product technical documentation and knowledge base. Recent projects: •Enterprise Central Logging and Alerting system for logging business and technical events via exposed APIM endpoints (CosmosDB + Logic Apps + Azure Functions + API Management). •Established DevOps processes and procedures based on the Azure DevOps/Pipelines for deploying Logic Apps and Terraform for provisioning Azure services and artifacts. •Energy Trade Risk Management system. Designing and delivering integrations between SAP, Dynamics 365, SharePoint, Bloomberg, Maximo, EcoSys and a variety of industry specific applications (Endur, Tieto, Bourque, Vertex, etc.). •BizTalk Server 2013 interfaces from on-premises Azure hosted VMs. •Re-platforming integrations from BizTalk Server to Azure Cloud platform. Existing BizTalk applications integration: SAP, Maximo, Workday, Dynamics AX, SharePoint and industry specific applications. Certifications: •TOGAF 9 certified •Microsoft Certified Solutions Developer

Illya
Data Integration Specialist
Illya – prominent BizTalk and .Net/Python engineer with extensive experience of delivery Enterprise Service Bus integrations for highly scaled and mission critical infrastructure (1000+ retail stores) with Microsoft BizTalk and Azure Logic Apps. Has extensive knowledge in infrastructure administration Microsoft SQL 2000-2020, Sybase IQ 15-16, Oracle 11g, IBM Lotus Domino/Notes, Exchange server 2010, Baracuda, Microsoft Hyper-V, WMware. Has an experience of BizTalk Architect and Team Lead. Extensive knowledge in creating / modifying / supporting / repairing of BizTalk schemas, BizTalk orchestrations, BizTalk pipeline components and .NET assemblies for real time, near real time and batch processing. Recent projects: •ESB toolkit adoption and maintenance: •Managed a ESB development team of 5 people. Who developed and maintained a service bus with a daily message volume of more than 4 million per day and integrated more than 1500 nodes and more than 10 systems (Oracle ERP OEBS, Oracle ERP RPAS, Sybase IQ, MS SQL 2000-2020, etc) •Successfully migrated the Microsoft BizTalk 2010 ESB infrastructure to the BizTalk 2020 version. Refactoring and adoption of BizTalk 2010 applications to be BizTalk 2020 compatible. •Set up a unique system for automatic testing of the ESB of all flows and transformations using TeamCity. •Data scrapping of social media monitoring using Python •Web and ecommerce apps development and support using ASP.NET Certifications: •Developing ASP.NET MVC 4 Web Applications •Enterprise Architecture based on TOGAF •Modeling in ArchiMate •Oracle 11g Database Administration •Administration Microsoft SQL Server

Yevgenii
Data Engineer
Yevgenii – hard working engineer with high focus to details and non-standard thinking, striving for perfection of delivered solution. Has a full stack competence in ETL, DWH, Modeling including Python development, eager to deliver end-to-end solution from data source to report. Has a high interest in advanced Power BI reports delivery and practical experience with Microsoft Dynamics reporting. Recent projects: •Customer Profiling and segmentation •Liquidity Providers analytics •CEO Dashboard that aggregates key insights from 20+ data source •Sales Analytics with sophisticated data model and Row Level Security •Migration of 100+ reports within Microsoft Dynamics CRM to new versions •Reports automation for SAP Business Object

Andrey
Data Engineer
Andrey – engineer focused on extremely complex SQL backend logic with extensive knowledge in SQL Server based Master Data Management. Has good understanding of database performance tuning and constantly striving to run database or data model as smooth as possible. Managed to maintain big scale BI system with SSRS (600 reports), SSIS (80 packages) and SSAS (10+ OLAP cubes) according to SOX compliance and capable to profile, identify and tackle a tricky performance issues. Recent projects: •Marketing campaigns scoring and client scoring •Customer Profiling and segmentation •Payment Service Provider analytics with payment flow cost calculation •Sales Bonus engine for 1K+ of sales hunters with 10+ compensation schemas •Operational reporting for automotive and aircraft construction