Vladimir Afanasev

Leading 7 DB specialists on Credit Risk project: • Improve input validation controls by ~50% • Set up performance controls and reduce DB issues by ~30% • Speed up user bathes, procedures, housekeeping by ~20%. • Migration to MS SQL 2017, 2022. Additional responsibilities: • People management. Supervision of 7 Middle/Senior DB team members. Created personalized goals, book of work, Q1:1, YE reviews. Motivated team. Knowledge sharing. Delegation. Values and Mindset • Created SQL strategy to support business, DB metadata framework architecture. Decided on tasks distribution. Worked with other teams (DevOps, Release Management, BA). • Managed 2 GitHub repositories. Developing production standard code within the team’s agile development process (code review, monitoring metrics, finding vulnerabilities, brainstorming) • Interviewed 10+ and hired 4 DB employees

I worked on DB refactoring on Credit Risk project: • Created basic performance controls, introduced Graphana for analytics and monitoring. • Designed and conducted DB metadata framework unification, tagging functionality for business users. • Apply columnstore approach to reduce the storage (~200%) and speed up the queries (~50%) • Interviewed 5+ and hired 2 DB employees

I worked in DB team on Credit Risk project: • Refactored sub-optimal queries, speed up procedures ~20% • Developed 15+ upstreams/downstreams for Credit Risk batch calculation.

Working in small team as consulting SQL engineer. My everyday activites include developing SQL pocedures and scripts, working with .NET Projects I participated: - Tax reporting. Developing business applications on T-SQL, C# - Financial reporting. Developing, supporting ant testing SQL code on T-SQL, PL/SQL