Маргарита

MARHARYTA BILYK
DATA ANALYST

CONTACT EXPERIENCE
[відкрити контакти](див. вище в блоці «контактна інформація») Trimble - Data & Process Analyst 08.2025 - present
Data validation & analysis: Reviewed shipment, invoice, and rate data from international clients,
[відкрити контакти](див. вище в блоці «контактна інформація») ensuring consistency with contractual and tax rules.
Issue resolution: Identified and corrected VAT and total cost mismatches through detailed audit
GitHub checks and collaboration with carriers and internal teams.
Process improvement: Partnered with IT to optimize converter logic, automate validation flows,
and enhance system accuracy.
LinkedIn Specification & reporting: Updated functional documentation, verified business rule
configurations, and supported audit reporting.
SKILLS Cross-team communication: Collaborated with global teams via JIRA and internal systems,
maintaining clarity and efficiency across regions.
Programming & Analytics Tools & competencies: Advanced Excel, JIRA, Power Query, Power BI, Databricks, SQL; strong
analytical mindset and precision under deadlines.
Python: pandas, NumPy, statsmodels, scikit-
learn, matplotlib, seaborn – data cleaning, UCU - Global Factors Behind CO₂ Emissions 01.2025 - 05.2025
analysis, and modeling Analyzed CO₂ emissions across 69 countries (2000–2023) using Python, quantifying the impact
SQL: PostgreSQL, MySQL – complex queries, of energy policies, industrial structure, and economic growth.
joins, aggregations, CTEs, and A/B test metric Applied OLS and Fixed Effects regression to test the Environmental Kuznets Curve and
tracking evaluate drivers of emission intensity.
Built data pipelines integrating World Bank and IEA datasets to ensure accuracy and
R: ggplot2, dplyr – statistical analysis and
reproducibility.
visualization Created interactive dashboards and visual reports to present results and policy insights.
Git & GitHub: version control, collaborative Delivered data-driven recommendations supporting low-carbon transition strategies.
workflow management
LVIV CITY COUNCIL - Edu4Civic 01.2025 - 05.2025
Data Tools & Visualization
Led the data analysis and system design of the Edu4Civic civic-engagement platform, managing
Excel: Power Query, Pivot Tables, Advanced
the full project lifecycle from initial requirements to prototype evaluation.
Formulas for quick analysis and automation Collected and analyzed user feedback and interaction data to identify engagement patterns and
Power BI & Tableau: data modeling, DAX optimize platform usability.
formulas, dashboard creation, and Utilized SQL and Excel analytics to monitor project metrics, assess performance indicators, and
performance drilldowns improve workflow efficiency.
Coordinated multi-stakeholder collaboration (NGOs, municipal teams, and student groups) to
Databricks & Jupyter: exploratory data
align data insights with civic goals.
analysis (EDA), feature engineering,
Delivered evidence-based reports and visual dashboards, driving data-informed decisions in
visualization pipelines digital transformation and urban innovation initiatives.
Product & Business Analytics Genesis Analytics Hackathon – Payment Analysis 03.2025
Product metric tracking (activation, retention,
Processed and analyzed 550,000+ subscription payment records using Python (Pandas,
conversion, churn) NumPy) and SQL to uncover performance trends and outliers across global markets.
Experimentation & A/B testing with statistical Applied data aggregation, correlation, and anomaly-detection techniques to identify key drivers
validation of payment failure and conversion drop-offs.
Funnel, cohort, and user-segmentation Detected a success-rate decline tied to SUTTON Bank dominance and Visa processing errors in
the U.S., verified through statistical validation.
analysis
Found a correlation between Indian traffic and recurring-payment failures, suggesting gateway
Defining and monitoring KPIs and success latency and acquirer routing inefficiencies.
metrics Delivered data-backed optimization strategies for gateway routing and acquiring-bank
Data-driven feature evaluation and product distribution, visualized through Power BI dashboards for management review.
impact assessment
UCU - Loan Approval Prediction 09.2024 - 12.2024
Stakeholder communication & presentation of
actionable insights Analyzed financial and demographic predictors of loan approval using Python
Built and tuned logistic regression models to quantify predictor importance and forecast
approval outcomes.
CERTIFICATIONS Applied feature engineering and hypothesis testing to validate statistical significance.
Assessed model performance with accuracy, precision, recall, and ROC-AUC metrics.
Delivered visual reports and insights supporting risk assessment and decision optimization.
SKELAR IT Analytics Intensive

EDUCATION
LANGUAGES
Bachelor of IT & Business Analytics
09.2023-06.2027
Ukrainian Catholic University
Ukrainian (Fluent)
Relevant courses: Business Analysis in IT, Econometrics, Economic Analysis, Organization of
English (Advanced) Databases, Programming (Python, Java, R), Probability & Statistics, Linear Algebra, Artificial
Intelligence, Machine Learning, Big Data Analytics