Irina Chebotar Email & Phone Number

Sydney, New South Wales, Australia

Moscow, Russia

- Gathered data from disparate sources using SQL queries and Python.- Cleaned and transformed data sets for analysis, ensuring accuracy and consistency (including ETL processes)- Collaborated with cross-functional teams in order to provide insightful PowerBI reports (customer support, consulting, marketing, sales teams and reports for company’s investors).- Provided prompt responses to Ad-hoc requests to support financial and strategic decision-making (mainly commercial ad-hoc’s from company’s CEO).- Identified and addressed data quality issues while working closely with the IT infrastructure department.- Developed revenue accrual methodology and calculation script while working closely with the company’s financial department and external auditors.

Moscow, Russia

- Wrote complex SQL queries on a daily basis.and created ETL processes using Python.- Developed dashboards in PowerBI.- Prepared segments of clients for marketing communication.- Prepared End of campaign reports for FMCG companies (Purina, Unilever).- Prepared fraud reports on the loyalty program (retail company).- Prepared demo-dashboards that were subsequently used to showcase company’s analytical services to potential clients.- Took part in the set-up process of several new projects, including: a. presenting demo-reports to potential new clients and discussing relevant criterias of each report. b. discussing and preparing criterias for data models in the database (relations, indexes, data types). c. taking part in data migration for a client.

Moscow, Russia

- Conducted financial audits for clients in the mining, oil, and gas industry, ensuring compliance with industry regulations and accounting standards.- Executed audit procedures, including substantive testing, analytical review, and sampling methods to gather sufficient and appropriate evidence.- Analyzed financial statements, identified anomalies, and communicated findings and recommendations to project managers and client’s representatives in a clear and concise manner.- Led teams of junior auditors, providing guidance, coaching, and reviewing their work to ensure quality and adherence to audit standards.