Dmitrii Shestakov Email & Phone Number

Moscow, Russia

Moscow, Russia

1. Creation of reporting from scratch, development and implementation of reporting for the Car Loans Department:- Analyzed the existing automated systems and reporting in the bank- Collected business requirements- Organized storage for data collection- Built a sales funnel with segmentation by partners and sales channels based on data from several automated banking systems: Credit Conveyor, Contact Center System, Courier Service System- Created reports for interaction with partners: application and loan register reports, reward reports- Developed a report for working with the bank branches- Data preparation and provision for car loan market research- Set up a schedule for reports update and distribution- Created a technical specification for DWH department reports development2. Development reports for the Key Partnerships Department:- Built a sales funnel for a joint project with a mobile operator on issuing a personal loan on mobile phone balance- Created sales funnels for interaction with financial marketplaces: banki.ru, sravni.ru and bankiros.ru- Developed reports for interaction with partners: lead generation reports, loan register reports and reward reports- Organized distribution of partner project funnels3. Enhancement of existing personal loan reporting:- Developed and implemented a technique for determination of application acquisition channel- Organized a loading of data sent by partners into the storage

Moscow, Russia

Creation of reporting from scratch, development and implementation of reporting for the SME Department:1. Analyzed the existing automated systems and reporting in the bank2. Collected business requirements3. Organized storage for data collection4. Initiated the allocation of IT resources to develop and maintain the ETL process5. Recruited a team to develop and maintain reporting6. Established a process for developing and improving reporting:- Built a sales funnel for cash and settlement services, segmented by branches and channels- Created reports for risk products: loans, overdrafts, bank guarantees- Automated the calculation of rewards for partners and direct sales agents- Organized automated file exchange with partners by FTP server- Organized the loading of data from automated systems into the data warehouse (CRM, e-banking system, automated banking system, website, customer portals, SAS AML, 1C).- Created reports for customer notification- Created data models for reporting (clients, accounts, website applications, account reservations, balances, actual transactions, loans, acquiring, partners, customer activity, product penetration, revenue)- Data preparation and provision for market research7. Organized calculation of network employee rewards:- Quarterly rewards (client managers, credit experts)- Monthly rewards (operations staff)8. Organized the process of calculating and updating financial models:- Launch partner channel- Adding fee for transfers to the personal accounts- Waiver of account opening fees- Launch tariff solution for tender clients- Launch of SMS notifications- Launch product for self-employed individuals- Launch Tariff for foreign trade clients- Launch bank guarantees- Launch cash and settlement service programs9. Organized KPI monitoring process:- Budget plan adjustments- KPI forecasts considering planned activities- Prepared presentations for department leaders- Reconciliation of Financial department reports

Moscow, Russia

- Launched incentive programs for sales specialists, partner program managers and their supervisors. Developed remuneration reporting and organized the payment process- Developed and implemented reporting for POS lending, allowing for real-time tracking of key performance indicators- Created a sales volume and KPI planning system for POS lending that considers sales seasonality, partner activities and business objectives. The system enabled planning at all levels: sales outlets, sales specialists and regions- Led the customer-oriented analytics direction, organizing and coordinating the team's work- Conducted research on mass segment customers throughout their lifecycle, analyzing the customer base, conducting clustering and customer segmentation- Identified patterns in customer behavior, analyzed causes and predictors of customer churn- Proposed hypotheses for attracting, retaining, developing customer relationships and increasing customer profitability. Built models to test these hypotheses- Analyzed customer reactions to banking products for the purpose of successful customer retention- Analyzed the effectiveness of activities to attract, retain, develop customer relationships and increase customer profitability- Developed customer-oriented reporting. Implemented metrics: Monthly Active Users (MAU), Retention, Churn Rate, ARPU, LTV, CAC- Generated technical specifications and business requirements- Prepared presentations and analytical reports for bank management- Created sales and key performance indicators reports

Master Of Technology - Mtech, Materials Science

Bachelor'S Degree, Management

Bachelor Of Technology - Btech, Materials Science