Andrey Dmitriev Email and Phone Number

Covalo is a European start-up which provides an open B2B data platform for consumer goods industry (beauty, healthcare, etc.).I am part of the small development team which maintains the system, adds new features and increases value provided by the platform to the users.Tech stack: event driven (Spring/AWS SQS) paltform with data layer (jOOQ / PostgreSQL/ ElasticSearch), API (Java/Spring Boot), Security (Spring Security, Keycloak)Achievements:Data enrichment and consistency - development support of legacy crawlers and gradual migration to the crawler based on a latest version of Norconex web crawler. Became the main expert and go to person for all changes in CovaloApp project to adapt and develop consumption and proper parsing of crawled data.Searchability (ElasticSearch) - developed a set of new features (including bookmarks), filters and mapping/template changes in Elastic Search. Improvement to existing indices (tokenizers and dictionaries).Stability - attention to details in finding critical issues, their root causes and fixing them. Logic design and implementation of new features and workflows - configurable email campaigns to all (or selected) platform users. Refactoring of company's contacts model, user signups, e.t.c.

During my tenure, I was working on new features and bug fixing for the HBase/MapR Enterprise Data Warehouse project.The project is used for processing extraction data to AWS S3 using asynchronous events (RabbitMQ).Then data is normalized and enriched with ML models and geocoding. Noteworthy contributions encompassed REST API development (Spring MVC/Swagger), AWS service management, and schema changes for MySQL and HBase/MapR. Leveraging Dockerized containers.

In this dynamic role, I immersed myself in Java development (Git/GitHub, IntelliJ IDEA, Crucible, Selenium, Cucumber), CI/CD (Jenkins, Maven, AWS, RabbitMQ, Docker). My expertise extended to test automation for SPAs for ETL (Hadoop/Spark) and Warehouse (HBase) projects, focusing on data gathering, merging, and processing.Accomplishments:- Proposed and implemented an ETL automation pipeline, orchestrating EC2 instances and parallel extractions, significantly enhancing efficiency.- Conducted a successful POC for API and UI automation using Java with the Cucumber BDD framework.- Transformed manual API regression tests into automated PostMan collections, reducing testing time from days to hours while minimizing manual efforts.Skills and tools: Java Core, Git/GitHub, IntelliJ IDEA, Selenium, Cucumber, CI/CD, Jenkins, Maven, AWS, RabbitMQ, Docker, H2O, Ontology/Protege, Apache Avro.

ETL and reporting project for a large multi-national bank.My project was an ETL system that feeds into a data mart for generating a variety of financial and risk reports. The ETL system is based on Oracle data warehouse (DWH) and was built for consecutive extraction, transformation, enrichment and validation of data collected from thousands of bank’s offices as well as dozens of external sources. Technically this is an interesting and challenging project. Its sub-systems are constantly evolving and growing in number through an iterative agile development model to fit the client’s needs. When I joined the project, I inherited an existing, relatively large, collection of test cases for different systems of the project. In many instances the test cases came with automated PL/SQL test scripts. They provided good regression coverage but also assumed deep understanding on the tester’s part of the domain of dozens of project’s modules to be used effectively. Part of the challenge was learning the DWH’s internals and the business domain. As a member of the System Integration Testing (SIT) team, one of my biggest achievements on this project was improving the test scripts themselves, especially their documentation, so it is easier for everyone to figure out what’s going on when things do break. I have also created and documented many new test cases for new processes and new functionality that is continuously being added by the developers. Additionally, I had to refactor, re-write and, occasionally, remove some of the legacy test scripts. By now I have become a point of contact for testing of several ETL processes (including business rules validation of transformed data) as well as for functional validation of the environment’s tables and its attributes (using SQL scripts and test comparators).

Several startup projects primarily in the area of Business Intelligence and reporting. In early 2013 I decided to change my career and switch to IT. Important projects:1. BI Dashboard with the data presented by client in Excel (up to hundred thousand rows). To facilitate and quicken data processing I used Excel add-in (PowerPivot). Summary information displayed according to client specifications (3 Pivot tables one with the sales summary and KPIs, other 2 for checking stock items availability and reorder).The best reward for my efforts was the CEO’s words: “The quality of work is outstanding.”2. BI Dashboard using MS Access 2013 (up to hundred thousand records) for business data cleaning. Project scope included:1) Access DB redesign and cleaning of ambiguous and erroneous data.2) Creating complex forms, queries and tables for Access based reports3) Creating complex queries and tables needed for the Excel Dashboard4) Excel Dashboard (VBA facilitated)The project was a total success. What was also important to me is that this project taught me a great deal about working with “dirty” data, and that an IT specialist should be ready for any surprise when working with legacy databases.My other freelance projects included custom lottery system (Excel/VBA), Data Filtering and Classification (Excel/VBA), Tool for removing permutations in an extensive list of words (Excel/VBA), etc.

Technical assistant:- processing technical data using MS Excel and proprietary software- internet research- EN-RU translation of leaflets, manuals and converting them into PDF)- presenting technical information on products (verbally and/or Power Point)- etcAs part of team, I was responsible for technical and commercial communications with HQ and customers (e.g. lead and chief engineers in area of ammonia and petrochemical industry), Contract preparations and contract administration (incl. informational support for facilitation of customs clearance, products certification when needed), keeping in touch with the customers and maintaining corresponding statistical data, product presentation (incl. making or translating necessary PowerPoint and other docs), technical supervision and support.

Marketing and product presentation

Reaseach.