Edvard Stepančuk Email & Phone Number

Spain

Madrid, Community Of Madrid, Spain

• Building new and editing existing dashboards as requested by various stakeholders (PowerBI, Databricks)• Creating new and editing existing reports in Salesforce (Salesforce)• Analyzing data and providing insights for QBR

Seoul, South Korea

Seoul, South Korea

Mobile-Ad Targeting Project at 'K' Telecommunications Company:Day-to-day tasks• Extracting the list of potential customers according to targeting criterias, such as mobile browsing, call or TV viewing histories (SQL, Excel)• Analyzing and visualizing marketing campaign results to generate business insights (SQL, Excel)• Design, build and maintain ETL pipelines (SQL)Additional tasks• Scrapping websites and utilizing acquired information together with existing mobile browsing history data to build customer profiles (Python, SQL)• Maintaining code used to accumulate historical targeting criterias (Python)Relationship Prediction Project at 'U' Telecommunications Company:• Researching Social Network Analysis (SNA), Community Detection Algorithms (Louvain, Leiden, Connected Components, PLM etc.) and briefing other project members• Applying Community Detection Algorithms to detect families and households by constructing network based on call data and demographics; building measures to estimate prediction accuracy (Python, BigQuery)• Predicting the age of other company customers using XGBoost (BigQuery)

Seoul, South Korea

• Web scraping and analyzing competitors' product reviews to identify best keywords and to provide insight about the market and consumer pain points• Planning, setting up, managing, and analyzing advertisements on Facebook Ads platform• Participating and representing the company in global events such as Alibaba GDT Challenge (Advanced to global top 10); building company's pitch deck• Assisting in crowdfunding page and marketing strategies creation; examining crowdfunding results• Translating webpage and app from Korean to English

Vilnius, Lithuania

• Assisting the creation of a personal inflation calculator • Analyzing the influence of monetary policy conducted by the European Central Bank on economic indicators

Dennis Port, Ma, United States

• Greeting customers and assisting with check-ins • Taking care of facilities like cleaning pool or mowing lawn • Managing laundry • Assisting customers when inconveniences occur

Dennis Port, Ma, United States

• Operating hydraulic bailer • Making bails • Stocking shelves • Assisting manager • Cleaning facilities

Vilnius, Lithuania

• Setting up the rooms and ensuring all props are in proper working order • Greeting participants and instructing them on the rules of the game • Tidying and cleaning the rooms, lobby and office • Keeping track of the inventory • Keeping track of online and phone bookings

Master'S Degree, International Business/Trade

GPA 4.45 / 4.5

Korean Language

Bachelor'S Degree, Economics

Cum Laude in Economics

Korean Language

Exchange Programme, Economics

High School