Position: Data analyst
Category: Data Science
English level: upper
Years of experience: 3


Creating customer profile researches. Gathering all data available for certain bank product users. Making statistic report containing demographic, income, service period, cross-sales, card transactions in different channels etc. Merging results in PowerPoint presentation for bank CEO, heads of Retail and Marketing units for selecting future sales strategies.
Creating customer aggregates in data warehouse. Preparing data structures, writing SQL queries, queries optimization, testing, putting calculations on scheduler.
Application for updating user’s references in data warehouse. Creating references data structures. Writing application using Borland Delphi with direct connection to data base that help to search not actualized data in source system and match it with reference.
Application for reporting automation. Writing application using Borland Delphi that execute defined SQL queries with given parameters and input results in html template to visualize interactive charts and tables.
Launching direct marketing campaigns. Defining target group. Writing SQL queries, estimating sample size. Choosing communication channel (SMS, ATM, Internet banking, Call center or PM) in dependence of sample size, customer value and budget available. Gathering feedbacks. Estimating response rate. 
Customer classification. Gathering data from warehouse: demographic, income, service period, cross-sales, card transactions in different channels, etc. Data preprocessing – filtering anomalies, standardization, correlation analysis. Defining customers groups using cluster analysis in SAS Miner. Building contact strategies for different groups. Launching direct marketing campaigns for certain groups to increase customer value. Analyzing feedbacks.
Analyzing customer lifecycle. Researching acquisition and attrition channels and products, service period and cross-sales in dependence of acquisition product. Defining life cycle stages. Scoring probability that customer will buy certain product.