- analysis (Excel, PowerQuery, PowerBI, VBA forms) - working in Lexoffice, Addisson (accounting, charts of accounts) - data processing with Python (pandas, requests, simplejson,pyodbc) - SQL queries (join, union, cte, window functions) - BPMN (ELMA, simple typescript scripts) - 1C database SQL and odata (api) requests for data analysis - data warehouse in Sharepoint - processes in PowerAutomate

- translations of audit reports and other documentation (agreements, articles of association, minutes, balance sheets, income statements, statements of cash flow, changes in equity) (English 90-95%, German 5-10%) - participation in skype, phone calls as an interpreter

- communication with employees - errors analysis - communication with developers on on the system's limits and deficiencies material management: - purchasing(ME51N, ME31K, ME21, E23N etc.) - inventory management(MIGO, MIRO etc.) personnel administration: - organizational structure (PPOSE) - processing applications (SWIA, SWI5) - looking through ABAP code in SE80 by error from SE91 - monitoring applications in ABAP editor program (SE38) - SM34 - Calling maintenance of a cluster of views - se16n working with tables - personal data analysis (PA20 --2006 vacation limits, 0007 - working schedule, 0001) - HRPADRU_LN - checking the status of sick leave transaction (error analysis, request to the HR department, referral for manual parsing) - SE11 looking for ABAP applications themselves, send an error - PPOSE - view section, subsection personnel (S - staff position, O - organizational unit, C - positions, T1 - typical workplace)

- working with application (data analysis, uploading data, searching for errors) - checking various data from web and Excel (simple python scripts for scarping web-sites, VBA macroses for processing data in Excel (adding images, linking them to SKUs) https://github.com/Elisenochka/.vscode/tree/master/.vscode - communicating with the client on the issues arise during working with tool, preparing certain reports on OSA, SOS

- analysing of the business activity formalization in Excel - moving excisting structure to Optimacros implementing dimensions, lists, olap cubes - formalization of linear optimization models (variables, target, constraints)

- reports on sales volume (Excel with the help of powerquery (merge -left,right, full inner-outer, append, if then), powerpivot - DAX (sum, sumx, filter, calculate etc.) - analysis of effectiveness of work of consultants (pivot tables with calculation fields, charts, ppt presentations) - communication with supervisors when gathering information on POS status

-translation of articles from German into Russian

- reports on different project phases (graphs, charts, pivots, diagrams in Excel (VBA macroses - searching, replacing, formatting), PowerPoint) - analysis of project fulfillment per areas (FIN, SCO, SCI, BUY, MFG), per phases (Feasibility, Development, BIT, Cutover) - supporting of SharePoint for accurate data keeping and work collaboration (creating libraries, discussion boards, workflows, views, alerts, creating workflows in SharePoint Designer, creating forms in InfoPath) - assistance in the consolidation of the expenses in IT segment with its further validation with planned budget (data performance with a breakdown by managers, analysts, segments, countries, using Excel formulas) - working in international team (managers from France, England) - constant report improvements for their better visualization (time, amount calculation formulas, conditional coloring of numbers, gantt charts)%

- working with big amount of information, concerning its consolidation in Microsoft Excel - writing of simple macroses for its faster handling - communicating with English speaking partners in verifying data - working in tight time limits - working with big time difference

- day-to-day reports: analysis of sales, percentage of markup (based on information from 1C8 Trading); - looking for discrepancies in the data entered in the data base and primary documentation (GL, invoices) - consolidation of data, concerning profit and price mark-up of the subsidiaries with the help of Excel (formulas VLOOKUP, INDEX, MATCH, FIND, XNPV, pivot tables, VBA); - price building, including import/export calculation (transportation expenses, insurance expenses, custom duty); - communication with logistic and sales departments; - calculation of the costs of the goods produced in the factories of the company (based on information from 1C8 Production and reports from shift supervisors) - checking the correspondence of the costs and prices - day-to-day monitoring of the cash flow in subsidiaries (communication with chief accountants) - reports on the results of the financial year (comparison tables, diagrams)

- compiling agreements; - seeking new auctions on govermental electronic trading platforms - preparing bids for auctions (tenders) in accordance with 94 federal law; - communication with wholesalers and state institutions;

working in the sphere of management accounts of the company: - consolidation of expenses (travel, telecommunication); - managing the data base of employees; - allocating of expenses (travel, medical, research) on different legal entities of the company - performing of information in graphs and tables with the help of Excel (pivot tables, graphs)

- communication with potential partners for show room (in English, Spanish)

- communication with potential clients (German) (product, collaboration terms description)

Innovation and High Technologies, Combinatorics

Philosophy of communication, post-graduate student

economics and law, world economy (english and german)

IBM, certificate (100 hours)

Google, Data Analytics

IESE Business School, certificate (100 hours)

Moscow Institute of Physics and Technology, certificate (100 hours)

Moscow Institute of Physics and Technology, certificate (100 hours)

University of California, San Diego, certificate (100 hours)

GeekBrains, https://github.com/Elisenochka

Specialist, MSTU (Bauman)

Specialist, MSTU (Bauman)

Instituto Cervantes de Moscu, B1

Specialist, MSTU (Bauman), sertificate (100 hours)

MSLU (courses), 2 years