Olga Likhenko Email & Phone Number

Professional skills:• SQL (different types of joins, creating new tables in databases on different servers, window functions, groupings, subqueries, creating and editing existing views and procedures, working with Job, as well as the SQL Server Import and Export Wizard, and more) • Python (pandas, matplotlib, seaborn, numpy libraries, working with data - searching for gaps and explicit and implicit duplicates, changing formats, calculating basic statistical metrics for analysis, building various graphs with feature distribution, defining and creating a slice by characteristics, various groupings and joins, building pivot tables, conducting statistical checks Student's t-test to compare samples, clustering) • Qlik Sense (development of dashboards, writing scripts for ad-hoc uploads and visualization, automation of regular reporting)• Rstudio (writing scripts to automate reports)• Visual Studio (working with existing process automation packages, checking Job, working with OLAP cubes) • SAP, Accenture (work with master data, adjustment and verification) • Microsoft Office (Excel - pivot tables, macros, VLOOKUP and other functions, VBA, charts and graphs) • Power BI, Tableau (create boards, provide access to colleagues, update data for boards)• 1C (work with documents, commodity items and orders) - daily use at previous places of work• Atlassin Confluence, Jira (writing and editing informative articles, working with requests and tickets) - daily use at the last place of work

• 

  Moscow State University

  Sociology