Alena Tskhondiya

DATA ANALYST

Skills & Tools

Advanced knowledge of Microsoft Word, Excel (VBA,

Data Modelling, Data Transformation, Pivot table,

V/X/H -Look up, charts etc.), SSIS/SSAS/SSRS, MS Project,

Power BI, PowerPoint, Outlook, Visio, OneNote, SharePoint,

Tableau, Salesforce, MySQL, SQL, PostgreSQL, MSVS, HTML,

Python, R, Web Scraping, Alteryx, Jupiter, Spyder, Gretl.

Experience

Email

adjmt7@r.postjobfree.com

Phone

+1-571-***-****

Portfolio

www.alenatskhondiya.com

Jul 2019 - The Data Science Bootcamp

Present Projects

•Excel. Managed the data for Mortgage company, built reports and calculated metrics using Advanced Excel Transformation functions and Data Modeling.

•SQL. Utilized SQL language to discover sales insights for the USA music store.

•Power BI. Created Business Intelligence Report for UK bank and determined insights to increase sale in each region.

•Tableau. Identified better-performing sales region for a laundry service and determined which of the 10 new locations were best to invest more funds into marketing.

•Python. Cleaned and manipulated data, analyzed sales and built tabular and visualization reports, using Pandas & Matplotlib methods.

Aug 2018 - Microsoft (Compass Group)

Jun 2019 Event Planner/ Analytic

•Automated counting process of metrics by developing an Excel model, that resulted in a time savings of 30 times.

•Worked collaboratively with cross-functional teams: 8 internal teams and 10 external vendors.

•Utilized excel functionality to gather, compile and analyze data from pivot tables and created. graphs and charts. Provided analysis on any claims data discrepancies in reports or dashboards.

• Created charts and graphs Microsoft excel to report findings, performed all the analysis required to submit the manager.

•Used data to create models that depict trends in the customer base to outline the specific data needs for each customer.

Oct 2015 - Digital Marketing and Business Analytics Associate

Jun 2018 Sofronia

•Analyze diverse campaigns ranging from email, paid search, display, social, to video campaigns using multiple internal and external data sources and business intelligence tools.

•Worked on the development and implementation of a new online marketing strategy to increase sales and brand awareness – increased sales by %15 within one year.

•Led E-Commerce business including management 10 platforms.

• Oversaw expenses sales and other aspects of business budgeting that led to 15% increase in profits.

• Created engaging e-mail marketing campaigns for clients.

Certifications

The Data Science Bootcamp

Python for Data Science

The SQL Course

Power BI Course

Tableau Course

Education

2012

Moscow Banking Institute

M.A. Data Finance Analyst

2013

Russian State Social University

M.A. Safety Occupational Engineer

Contact this candidate