● Full Stack development in the largest bank in Russia. ● Creating a functional system for the work of the heads of large territorial divisions and the central office of Sberbank. ● Develop an analytics system for the work of sales managers with corporate clients. ● Reporting systems for analytics for territories, bank products and sectors of the economy. ● Oracle APEX interface with server-side Oracle DWH (SQL, PL/SQL). ● Development ETL processes using Informatica Powercenter. ● Additionally using JS, AJAX, CSS, Java technologies. ● Improving UX according to user requirements. ● Completed Java, Hadoop, Python courses. Results ● Project "Sales Funnel" to track the conversion of leads on products for large businesses. ● Reporting system "Sales Management Center" for large business analytics for territories. ● Reporting on contact policy, internalization, client strategies. ● Data marts for transferring indicators to related systems and data models.

● Development of Internet banking functionality (Full Stack) for legal entities and individuals. ● Interfaces and logic in Java EE (J2EE, JSF, EJB, JAX-RS). ● Development of the server-side of OLTP applications on Oracle DBMS (PL/SQL). ● System analytics, designing models and data streams. ● Interaction with an internal customer to solve business problems. Results ● Rest API for integration with SKB Kontur (Software for accounting in small business). ● Integration with 1C services DirectBank (Most popular software for accounting in Russia). ● Interfaces with the use Java J2EE.

● Designing data marts for the work of marketing companies of Sberbank. ● Development and support of data marts for SAS MA (Marketing Automation), SAS RTDM (Real-Time Decision Manager) systems and internal use by bank analysts. ● Adjustment of automatic data uploading from the bank's storage and individual systems (Teradata, Oracle, SAS, ETL). Results ● Data marts for systems SAS MA, SAS RTDM and for other departments of the bank.

● Development of a bank data warehouse with Oracle PL/SQL. ● ETL processes with SAS DI (Data integration studio). Results ● Data mart of CRM system "Babel" for the UniCredit international group. ● "Spider" data mart for CRM analytics on Hadoop in a bank group. ● DWH extension for data quality analysis as a part of the reconciliation project.

● Software for Gazprombank (The third largest bank in Russia), VTB24 (The second largest bank in Russia) and Central Bank of Russia (Government regulator like FRS). ● Interface on Oracle APEX with the use of plug-ins, JS, AJAX, CSS. ● ETL processes on SAS Base and SAS DI to download data from DWH. ● Backend on Oracle DWH (SQL, PL/SQL) and Teradata. ● Presentation of developed software with foreign partners for the several Russian banks. ● Participation in the preparation of tender documents for the Central Bank of Russia. ● Mentored team of developers. Results ● Gazprombank reporting system in 321P format CBR (Central Bank of Russia). ● Designed a system for replacing SAS AML (Anti-Money Laundering) in Gazprombank. ● Software for analyzing data from different rating agencies (Fitch, Moody's, S&P, Rus-Rating, Expert RA, AK&M, NRA) as well as the bank's internal system for Gazprombank. ● ICAAP (Capital Adequacy Assessment) system for reporting to the Central Bank of Russia. ● NSI system (Standard-reference information) for Bank VTB24.

● Developing Internet applications with the use of a database Oracle DB, SQL, PL/SQL. ● User interface on Oracle APEX with a variety of plug-ins for APEX, browser JS, CSS. Results ● Extension of online application www.it4church.com and application for delivery services