Ірина

Iryna Lihai
Data analyst
[відкрити контакти](див. вище в блоці «контактна інформація») [відкрити контакти](див. вище в блоці «контактна інформація») [відкрити контакти](див. вище в блоці «контактна інформація»)

Data Analyst with 2.5 years of work experience as a lawyer and experienced in SQL (JOINs, views, stored
procedures, triggers, windows function), Python (Pandas, NumPy), relational database concepts and
normalization, principles, writing complex SQL queries for retrieval, manipulation, and analysis

Experience
Lawyer specialised in contract, corporate law, and procedural documents 2017-2020
Executed ad-hoc requests for analyzing legal issues and meeting stakeholder demands using
analytical methods and tools.
Analysed a wide range of contractual documents to identify legal risks and ensure compliance
with legislation.
Conducted documentary research and prepared materials for legal proceedings using analytical
methods and tools.
Implemented effective document management systems and information structuring to support
decision-making processes.
Collaborated with a team of lawyers and stakeholders to develop strategies for avoiding legal
conflicts and minimising risks.

Data analysis projects
Database tracks KPIs and case stats for lawyers, including tables for each lawyer's cases,
automatic data updates upon case completion, and a consolidated table for overall analysis,
facilitating efficient case management and performance evaluation for managerial decisions.
Project to manage contract information within the company, which involved creating an Excel-
based system to track contract details such as end dates and the responsible manager.
Additionally, I incorporated a feature to automatically highlight contracts that were within one
month of expiration, aiding in timely decision-making and contract management.

Education
EPAM university Program 2023-2024
Data analytics engineering (Basic course)
Python developer study 2023

Yaroslav Mudryi National Law University 2013 - 2019
Master of Law

Skills
SQL Functional and Object-oriented
Python Programming
Git Databases
Excel HTML/CSS
Languages
Ukrainian - Native
English - Upper-intermediate (B2)
Italian - Beginner (A1)