Алла

ALLA LYKOVA
DATA ANALYST
CONTACTS PROFILE SUMMARY
lykovaalla Aspiring Data Analyst with hands-on self-practice in SQL, Excel, and BI
tools. Although I am just starting my professional journey in data
[открыть контакты](см. выше в блоке «контактная информация»)
analytics, my previous experience in sales performance analysis and
Tbilisi, Georgia training has strengthened my analytical thinking, attention to detail,
LinkedIn and reporting skills. Eager to gain practical experience and contribute
to data-driven decision-making.

HARD SKILLS PROJECT EXPERIENCE
SQL
Data visualization Project: SaaS Revenue and Growth Dynamics
Basic statistics Technical Stack: SQL (PostgreSQL), Tableau Desktop, Excel/CSV.
A/B testing and hypothesis Description: Processed raw data using SQL to track the monthly
testing subscription journey of every user.
Reporting & dashboard creation Designed a Tableau dashboard to monitor key metrics like MRR, LTV,
Data cleaning & preprocessing and Churn Rate.
KPI analysis & business metrics Enabled deep-dive analysis by adding filters for user demographics
tracking (age, language).
Funnel analysis and cohort Identified business risks, such as high revenue drop-offs, and
analysis suggested ways to improve retention.
Link: https://shorturl.at/Rp9Wk
TOOLS
Excel / Google Sheets
SQL (PostgreSQL/MySQL) Project: Digital Marketing & E-commerce Analytics
Python Technologies: SQL (PostgreSQL, BigQuery), Google Analytics
Looker Studio Description: Performed a comprehensive analysis of online advertising
Tableau performance and user behavior data. Used advanced SQL to aggregate
Amplitude marketing data from Facebook and Google, calculate key metrics like
ROMI and month-over-month growth, and build conversion funnels in
BigQuery to evaluate user journeys.
SOFT SKILLS Link: https://github.com/lykovaalla/SQL-Marketing-Analytics-Project
Analytical thinking &
problem-solving
Attention to detail Project: Retail Operations and Profitability Dashboard
Strong communication & Technologies: Tableau
presentation skills Description: Analyzed Superstore sales data to drive operational
Stakeholder management improvements by focusing on efficiency and profitability. Created a
Time management & comprehensive dashboard suite including Time-Series analysis,
multitasking Geographic Profitability Maps, and a Logistics Dashboard. Developed
key metrics (Profit Ratio, Delivery Days, Profit Per Order) using
Calculated Fields and implemented global filters (Order Date, Segment)
EDUCATION for interactive data exploration.
2025 IT School GOIT Link: https://shorturl.at/q8qvX
Data Analysis
https://shorturl.at/cD3nU WORK EXPERIENCE
2014-2019 Kyiv national
TeamLead Recruiting Jun 2024 - Jun 2025
university of trade and
economics JustTech, online education
Master’s of Marketing On this position I managed to:
- identify and introduce additional key metrics, performing
LANGUAGES comprehensive analysis to uncover trends and optimization
opportunities;
English: Upper-Intermediate
- increase the number of hired candidates by 15% in a quarter;
Ukrainian: Native
- automated routine processes using Google Sheets formulas and App
Script, saving about 1 hour per day for 3 team members, which equals 15
hours a week for the department.

Feb 2024 - Jun 2024
Trainer Sales
JustTech, online education

- conducted sales workshops and training sessions resulting in improved
closing rates and higher customer satisfaction scores;
- reduced new hire onboarding time by 20% by redesigning and
optimizing training materials, ensuring faster adaptation and quicker
first deals;
- had a stable candidate success rate of 70%

Sales Manager Oct 2023 - Feb 2024
JustTech, online education
Conducted online courses sales through video-based trial lessons,
effectively communicating with prospective clients and guiding them
through the decision-making process. Managed leads and workflows in
CRM and consistently achieved a 30% conversion rate.

Aug 2021 - Sep 2023
Outreach Linkbuilder
Online education

Communicated with web-masters to arrange publication of articles
linking to our product, negotiated placements and coordinated
content delivery. Generated ideas for link-building strategies and
prepared briefs for copywriters. Managed content production,
ensured timely delivery and met link-acquisition plans. Maintained
outreach pipelines and tracked performance to fulfil monthly targets.