Invest products DWH

• Singlehandedly designed and developed brokerage DataMart in Cloudera Hadoop. DataMart is used by both mobile application and managerial reporting: - Found relations and business logics in unstructured front system replica - Documented data model and data connections in replica - Designed, tested and implemented data model for the final datamart with business logics applied - Optimized data queries and tables architecture to run effectively on Hadoop framework• Led effort… Show more • Singlehandedly designed and developed brokerage DataMart in Cloudera Hadoop. DataMart is used by both mobile application and managerial reporting: - Found relations and business logics in unstructured front system replica - Documented data model and data connections in replica - Designed, tested and implemented data model for the final datamart with business logics applied - Optimized data queries and tables architecture to run effectively on Hadoop framework• Led effort to redesign invest insurance ad-hoc reports in Teradata achieving 100% customer satisfaction in 3 months’ time.• As team scrum-master introduced and implemented lacking agile events and story points system to the team development process. Show less

• Led datamart migration project from MS SQL Server to Greenplum. Results achieved in a year: - In partnership with corporate architects designed solution architecture 2020-2022; - Formed and led agile team of 6; - Documented all data flows from multiple systems and subsidiary companies; - Developed new infrastructure in Greenplum; - Signed off al the needed documentation and corporate approvals• In association with outsourced BCG analysts prepared data and presentation… Show more • Led datamart migration project from MS SQL Server to Greenplum. Results achieved in a year: - In partnership with corporate architects designed solution architecture 2020-2022; - Formed and led agile team of 6; - Documented all data flows from multiple systems and subsidiary companies; - Developed new infrastructure in Greenplum; - Signed off al the needed documentation and corporate approvals• In association with outsourced BCG analysts prepared data and presentation of Sberbank Private Banking business development strategy 2021 for bank CEO and senior management.• Participated in two major business development projects: - Advisory solution in partnership with Refinitiv (ex Thompson Reuters F&R) – development of user-friendly portfolio management tool for financial advisors in order to make portfolio management more efficient and diminish manual labor. - Pilot implementation of Wealth Arc Wealth management cloud solution in order to provide client with portfolio information across different banks in one place in consolidated form.• Responsible for ongoing preparation of ad-hoc analytics for CEO, head of sales, product development team. Analytics include financial information; sales performance indicators; client base monitoring; identification of key product drivers for business generation and business profitability, and resource allocation; senior management presentations on Private Banking business performance in Sberbank group. Show less

• Led RAD project of Private Banking ongoing developments to improve systems and provide new client services for 5 months.• Successfully developed and implemented aggregated client portfolio report using SAP Business Objects. Analyzed data from 5 different front-office systems, participated in creation and implementation of algorithms needed to match and interpret the data and calculate performance of aggregated portfolio. Trained and managed a group of three outsourced IT specialists to… Show more • Led RAD project of Private Banking ongoing developments to improve systems and provide new client services for 5 months.• Successfully developed and implemented aggregated client portfolio report using SAP Business Objects. Analyzed data from 5 different front-office systems, participated in creation and implementation of algorithms needed to match and interpret the data and calculate performance of aggregated portfolio. Trained and managed a group of three outsourced IT specialists to help with implementation and analysis.• Singlehandedly developed weekly managerial reporting in accordance with senior management requirements using Excel and Power BI. Presented sufficient analysis and recommendations to senior management on weekly basis.• Responsible for monthly verification of business financial metrics with Finance department. Show less