Responsibilities:Maintaining financial data processing platformMain Tools: Python 3+, Apache Spark, Apache Airflow, Git, HTML, CSS, JavaScript, ReactTasks:1. New feature implementation- Backend 90%- Frontend 10%2. Bug fixingAchievements:- Pipeline scheduler implementation- Data source choosing strategy introduction

Responsibilities:A compound of BA, BI, and developer tasks, data management and processingMain Tools: Azure databricks, SQL, Apache Airflow, PySpark, PythonAchievements:- Pipeline scheduler proof of concept implementation- Brand new requirements to data transformation implementation

Responsibilities:Overall company support on Data and Data AnalyticsMain Tools:1. SQL (PostgreSQL)2. Looker3. HTML + CSS4. Python + ML and DS libraries5. JavaTasks:1. Writing SQL queries:- for data extraction- for Looker (LookML) view creation2. Data presentation and visualisation in Looker:- creating dashboards for all the departments to monitor company performance- creating navigation and information dashboards for company ERP system3. Different Adhoc task such as:- RFM analysis for Marketing team- Margin analysis for Finance team- Partner network analysis for Operation teametc.Achievements:1. Looker introduction as company main analytics and data integration system2. Transfer all the dashboards from QuickSight to Looker

Various tasks concerning Data Engineering, Data Analysis and Programming:1. Creating of small business applications:- to get any kind of data from open or external sources like web site or similar via API or parsing.- to process data for analysis (normalization, standardization. etc.)2. Overall data analysis via Machine Learning & Data Science tools.Main Tools:1. Java with frameworks Maven, Spring, Selenium. developing in IntelliJ IDEA.2. Database - PostgreSQL3. SQL4. GitHub5. Python with libraries for:- data handling: Pandas- ML + DS: NumPy, SciPy, Scikit-Learn- visualization: Plotly, folium, Matplotlib,- developing: PyCharm, Jupyter-Notebook6. BI tools: Qlik View / Sense, Tableau7. HTML + CSS + JavaScriptTasks:1. Data handling and preparation- Data extraction from PostrgeSQL via SQL queries- Dealing with heavy csv / txt files (>50Mb, >100 milion rows)- External Data collection (web-site parsing)- Data preprocessing2. Data Analysis:- General statistics and trends identifying- Searching for insights- Machine Learning tools usage (clustering, data modeling, etc.)- Visualization (with e.g. Plotly, folium (https://python-visualization.github.io/folium/))3. Making of conclusion:- Report / Presentation preparation- Making a presentation (if necessary)- Other activities concerned (e.g., project archiving, reflecting, etc.)Achievements:- Realized Project for Government of Moscow with recommendations concerning city infrastructure

Sberbank Legal Department, Project OfficeResponsibilities:Various Tasks Concerning Data Analysis, Business-processes Efficiency Analysis, Machine Learning / Data Science Tools UsageMain tools: Python (PyCharm, Jupyter-Notebook, Pandas, Matplotlib, NumPy, SciPy, Scikit-Learn), Qlikview BI System, Regular Expressions, MS Office (Word, Excel, PowerPoint)Tasks:1. Data handling and preparation for Data Scientists and Modelling:- Data extraction from SAP BO- Requests creating for Data extraction from Bank's information systems (IS)- External Data collection (web-site parsing)- Data preprocesssing (standardiozation, clustering)2. Data Science activity- Legal department staff amount analysis and prediction (In fact time-series analysis via ARIMA model)- Working on model "Claims to Bank" (Classifier to define potential clients (based on their profile) who may go to court)- Working on classifier for Legal requests routing3. Business-processes KPIs monitoring- Daily / Weekly quality reports- Log-analysis- Problem zone discovering- Proposals for improving4. Dealing with System Administrators- Interaction on new software version (jurisdiction model) installation- New software version testing- Requests for Log5. Additional activity- Creation/editing of templates for documents autogeneration in xPression systemAchievements:- Creation of automatic reporting system for Jurisdiction* process- Jurisdiction model enriching by 10%. It improved model accuracy by 5%- Historical Data (addresses) cleaning via geo coordinates.It gave +5% to Jurisdiction model accuracy* - the process allows to find district court via client address ----- * ----- * ----- * -----08.2016 - 11.2017, AnalystOutstaff employee at Sberbank from HumanFactorLabs company https://hflabs.ru/en/Please see HumanFactorLabs section

(outstaff employee at Sberbank from HumanFactorLabs company)Responsibilities:- Big data analysis for Sberbank, work in mixed agile-teams at customer placeMain Tools:Python, Qlik View, Awk, RegEx, SVN, IntelliJ IDEA, TalendTasks:1. Raw data analysis:- Analysis of extracts from different Bank's IS- Software fine tuning for data cleaning / standartization2. Data analysis after processing:- Creating client cards for duplicates searching- Searching for duplicates- Quality codes analysis- Discovering of problem data quality zones- Discovering of problem software zones with feedback for developers- Creating presentation on data processing and analysis results for customer, keeping all information about software performance in Confluence- Result presentation to customer3. Software support:- Changing, correction and upgrading in accordance with business logics or on customer request- Mappings (CSV) and configs (XML) correction without dealing with main Java-code- Test-cases enriching and their launch in IntelliJ IDEA- Dealing with SVN version control system4. Dealing with external data (additional project):- External source data parsing and processing/standardization- External and Internal data matching- Enriching of clients' profilesAchievements:- Statistics on clients' profile quality for all bank's IS (in fact all population of Russia)

Responsibilities:Providing with reliable data concerning tire performance (MICHELIN group and competitors) on the market of Customs Union for internal clients (Commerce, Marketing, Quality, R&D (France))Tasks:1. Work with raw information, databases:- Gathering of working Excel files by activity (pressure and load checking, tire tread depth, mileage etc.) from Field Engineers. Data consolidation in unified data base, correction of mistakes- Gathering of information on tire mileage from Salespeople. Data consolidation in unified data base, correction of mistakes- Work with sales data (SKU, Regions, Dealers)- Work with extracts from CRM for acquiring of additional information- Preparing of tire test data2. Data analysis (working tools: MS Excel, VBA, SPSS):- Processing of all the data, prepartion of regular reports, presentations in MS PowerPoint- Support of the salespeople operating in the field- Execution of occasional requests from internal clients for different kind of analysis- Analitical support of the Salespeople operating in the field3. Administration and organization:- Fild Engineers' and Salespeople's KPI calculation- Organization of the tests of brand new products- Designing, updating and optimization of the working files and tools (based on Excel)- Competitors' tires database maintenance and update- Technical Information materials for salespeople maintenance and update- Taking part in the meetings of Commercial departmentAchivements:- Implementation of the "Milage from CRM" process. It gave salespeople 5% of additional time for dealing with customers and it gave 20% of additional amount of information about tire performance- Automation of data consolidation to the unified database. It helped to reduce time for this job by 50%- Creation of brochure for R&D (France) in which all the conditions of tire usage and tire market of Customs Union are described

Responsibilities:Company's commercial activity support by meeting the requirements of russian technical legislationTasks:- Request processing (evident and implicit) for aquiring of certificates of conformity for the tires of specific product line (truck, agro, passenger)- Interaction with company's departments (Commerce, Marketing, Customs, Quality, Client service) regarding questions of certification and technical regulation- Monitoring of changing in legislation, risk analysis, action plan preparation, informing of all persons concerned- Certification data base updating (internal and external)- Dealing with internal and external customers, consulting, help in deciding the issues concerning technical regulation, acquiring of certificates of conformityAchievements:- Implementation of business process "From request to acquisition" for certificates of conformity- Creation of the certificate data base in Access- Creation of resource for external customers to facilitate acquiring of certificates of conformity and upload them from MICHELIN website- Reduction of people involved in the process from 7 to 1 person- Reduction of cost on the process maintenance in 10 times

Responsibilities, tasks:1. Leading the projects of business-process organization and improving in the commercial department and in the service-groups (marketing, credit, client service, logistics, supply-chain):- Building of working team, assigning of responsible persons- Interviews with process owners and department team members- Drawing of "As is" and "To be" process map in Visio- Validation of new processe- Writing of requirements specification for the process IT support- Help in process implementation during trasition period2. Leading the meeting to settle unusual questions- Preparing, conducting, documenting and animation of the meetings aimed at settling the questions which are beyond standard instructions and processes.Achievements:- Achieving the pilot phase of “The new claim process” project

Responsibilities:- Sales management in the entrusted area (dealing with dealers (push) and end-users (pull))- Market share keeping and increasing- Tire and trucking market monitoring- Collection, processing and dispatching of marketing information to the head office- Analysis of competitors' prices and price policy.Tasks:1. Handling dealers - determination of commercial condition, motivation programs presentation; setting up an annual sales plan and its monitoring on monthly basis; accounts receivable controlling; audit of points of sales (POS) on compliance with network standards, providing with a report to a company's management; technical and commercial support, teaching; joint visits to end-users; dealer network development (searching of potential candidates, assessment, overall accompaniment); gathering all the data in the CRM-system.2. Dealing with end-users (fleets) - searching for new clients, supporting and development relationship with existing ones; regular visits, inspection of tires installed on a vehicle, identification of needs, providing with a report to a company's management, evaluation of economic efficiency from product usage, sales implementation; tire department organization help, product consulting, providing with the service, work with claims; gathering all the data in the CRM-system.Achievements:- Expanded end-user client base by 80%- Contracted new partners (three dealers), increased qualitative and quantitative indicators of dealers' sales- Created financial part of POS business model

Responsibilities, tasks:Conducting business negotiations with customers, equipment model matching, drawing up of contracts, placing of orders for equipment at German companies, supply control, custom clearance documents preparation, some logistic functions.

Responsibilities, tasks:Client base maintenance and expansion, active sales, sales plan execution, technical support, commodity presentation, taking part in fairs, primary book-keeping.