Experience

Manzana Group - CRM&Loyalty provider

• Russian Federation
• IT Services and IT Consulting
• 1 - 100 Employee

• Database Developer

  • May 2019 - Present

  • ETL, SSIS, OLTP ETL: • Migrations data (hundreds of millions records with multiple levels of relation) by SSIS packages from other system • I have performed data migrations for a couple new company customers from their old systems to the Manzana Group loyalty program. OLTP high-load system: • Functional development on the RDBMS core MS SQL: stored procedure ,functions ,triggers • Query optimization: execution plan, hints, indexes, changing the query code • I have developed a database interaction module for loyalty data within mobile applications, which includes generating responses to application queries, inserting new data, and updating existing records. • I have enhanced and optimized a significant portion of the functionality for calculating and providing discounts through the core database system in response to requests from the cash register. • I have developed several monitoring systems that use stored procedures to send email notifications about the current status of specific data segments. TEAM DEVELOPMENT: • Development of a single project with several specialists • Working with a db project with Visual Studio • Working with a version control system (git) Show less