Position: Data analyst
Category: Data Analyst
English level: fluent
Years of experience: 6

I implemented RFM analysis for customers' database which helped to personalize email campaigns, identified customers who are about to churn and improve retention campaign

I automatized method of checking users' permissions in a company, 
automatized data downloading process in Cognos TM1;

I improved accuracy of predictions for 0.5% yearly.
Looking for a data analyst position 

SKILLS
Tools and Technologies
Word Basic, Microsoft Excel, Excel Macros, MS Excel VBA, MS Power Query, Microsoft SQL Server, SQL, Tableau, ETL, Jira, Confluence, IBM TM1, Access Basic, QlikView, SPSS, Autocad, Microsoft Visio, Copywriting, WordPress, Cascading Style Sheets (CSS), HTML, Corel Draw Suite, Adobe Photoshop, MathCAD

WORK EXPERIENCE
IT
CRM Data analyst in BI Team
Ukraine | Remote
Responsibilities:
Creating lists for marketing mailing campaigns. Analyzing results and preparing reports in Excel, Tableau. Automatization of preparing reports via using ETL, VBA. Creating and implementing new approach of customer segmentation by using RFM model
Technology and Skills: 
MS Excel, Power Query, Microsoft SQL Server, MS VBA, ETL, Tableau, Jira, Confluence

IT Support Specialist
Ukraine | Dnipro
IT Support Specialist in TM1 Cognos Team. Support clients, Cognos' technical maintenances
Responsibilities:
Technology and Skills: 
Confluence, Excel Macros, IBM TM1, Microsoft Excel, Microsoft SQL Server, MS Excel VBA, SQL

RETAIL
Leading forecasting specialist
Ukraine | Dnipro
Planning sector
Responsibilities:
Calculation forecast sales; long-term, medium-term, short-term forecasting based on historical data of sales in the context of items, groups.
Calculating the impact of seasonal factors, price, discounts, trend, CPI (inflation), type of marketing support.
Analysis of historical sales, data validation.
Using methods of forecasting: Moving average, Holt-Winters model, Linear regression
Development and support templates for calculation in Excel for discount sales and long term sales using Power Query, SQL and VBA
Finding the reason of forecast sales deviation from fact. Making weekly, monthly, annual reports KPI.
Technology and Skills: 
Access Basic, Analytical Skills, Excel Macros, Microsoft Excel, Microsoft SQL Server, MS Excel VBA, MS Power Query, QlikView, SPSS
Looking for Middle or Lead Data Analyst position,
no place for any contacts with russians