Andrey Torchilo

The project involved creating the regulatory affairs project management solution based on Azure with numerous source systems from scratch and integrating the third-party application via DB, API, and CSV.

ROLE
• Coordinated activities of the DB team, including prioritizing and distributing the tasks, reviewing code, organizing meetings, gathering requirements, implementing and enhancing the software process, and creating and maintaining the knowledge base.
• Designed the architecture of a data movement solution based on Azure Data Factory, with its own change data capture mechanism.
• Architected the database structure, both operational and integration layers.

I participated in a few streams—creating the ETL solution for exporting and importing the data from or to the master data management tool, creating an interface for aligning address information from different sources, and enhancing and maintaining the existing solution of anonymization data.

ROLE
• Led the anonymization team, prioritized and distributed tasks, organized meetings, gathered requirements, implemented and improved the software process following Kanban methodology, and created and maintained the knowledge base.
• Designed a data anonymization framework's architecture and created and implemented data obfuscation processes, resulting in a solution with its user interface written in Oracle APEX and over 50 unique anonymization functions.
• Designed and implemented interfaces for two big telecommunication operators.

Within the project scope, it was necessary to migrate bank data.

My activities included cooperation with a multicultural team to take all knowledge regarding this solution in short terms of two weeks, replace a key developer for further development, and implement a half-created solution in the production environment. I also generated the XML files via XSLT transformation, imported them by Way4, and designed and implemented the ETL for the population data warehouse using Talend EDI and migration approach via Swisscom suit.