Ilia Petrov Email & Phone Number

Berlin, De

Berlin, Germany

Warsaw, Mazowieckie, Poland

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

Warsaw, Mazowieckie, Poland

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

Munich, Germany

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

Moscow, Russian Federation

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

Moscow, Russian Federation

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

Moscow, Russia

(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)

Moscow

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

Moscow

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

Moscow

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

Saint-Petersburg

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

Saint-Petersburg

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.

Saint-Petersburg

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

Bachelor’S Degree, Mathematics

Fachbereich Mechanik und Mathematik

Master Of Engineering - Meng, Aeronautics/Aviation/Aerospace Science And Technology, General, 4,5

Activities and Societies: Took part in a competition on Kettlebell for University team twiceAircraft and -Rocket Systems Technologies

Business Administration And Management, General, 4,5

Mini MBA

Bachelor'S Degree, Economics, 4,5

Activities and Societies: Course leaderEconomics and management at engineering enterprise