Ivan Semenov Email & Phone Number

Charlotte, North Carolina, United States

Charlotte, North Carolina, United States

● Assessed sales of consoles' games for a retail store. Reported insights on perspective game genres and age categories for purchase in 2024● Analyzed advertising campaigns of the website. Conducted users' segmentation, visualized (Python) CAC, LTV, ROI, Conversion Rate, Retention Rate by promotion channels for six months. Identified one with negative ROI, which consumed more than 30% of the total advertising budget● Assembled raw data into a complex dataset and evaluated the 2023 real estate sales in Chicago for the agency. Qualified critical characteristics of the most promising objects for resale● Utilized the RICE framework and A/B testing to sort and test hypotheses for an online store. Discovered a 2% decrease in the average check and a 17% increase in the average order amount per user for the new version of the website● Designed a Dashboard (Tableau) for online store management with key performance indicators: categories, subcategories, revenue by state/ per order/customer, profit ratio and others● Regularly leveraged SQL queries (PostgreSQL) to retrieve, filter, sort, aggregate data, performed joins across multiple tables, manipulated data (insert, update, delete), operated subqueries, and managed table structures, including creating and modifying tables.

Huntersville, North Carolina, United States

● Undertook comprehensive market analysis of the transportation industry, determined vital competitors, potential risks and possible competitive advantages of the company; built Customer Journey Map (CJM) ● Using SQL (MySQL) and Python data manipulation and analysis tools, formed a pricing and margin strategy that expressed the balance between market conditions and company owner’s requirements. Collaborated with Operations, Sales and Marketing to implement it. ● Lifted website conversion rate to an application by 15%, diagnosing critical drop-off point of the sales funnel ● Established a cohesive go-to-market (GTM) strategy for new business direction that includes step by step detailed plan over a year ● Formulated standards for employees on shipments’ loading and unloading based on 20+ experts’ interviews and customers’ negative feedback that simplified the onboarding process for new employees and increased attention to common mistakes

Moscow, Russia

● Maintained ETL (extract, transform, and load) processes for the International Department using SQL (Microsoft SQL Server), investigated the most profitable industries, niches and countries to sell on export (covering more than 800 companies), planned and administrated more than 40 foreign events for 2023-2024 in CIS countries, Asia, Africa, Latin America, and the Middle East ● Contributed to informed decision-making by producing regular and ad hoc data visualizations (Python, Tableau) on the International Department performance: KPI metrics, budgeting and the events’ payback● Organized from scratch and managed the only offline foreign business conference for 15 capital's small and medium enterprises in 2021. The event was held within the framework of EXPO 2020, UAE, Dubai. (payback $1+ million in export contracts) ● During the data mining process, interacted with representative offices and embassies worldwide and with foreign industry associations, unions, government agencies, international organizations

St Petersburg City, Russia

● Executed regular Statistical Data Analysis of goods' quality metrics using Advanced MS Excel Tools and reported to producers in case of significant deviation● Developed and maintained a positive relationship with nationwide and regional retailers that increased supply volume and our company revenue by $ 520,000 over two years● Performed ad hoc business analysis at management's request. Increased efficiency of warehouse operations by implementing new business processes for handling defective goods● Communicated written and verbally in a professional manner with partners and colleagues from the European and Ecuadorian offices of Fyffes ● During operational control of supply (35-50 containers/week), handled multiple tasks, solved and prioritized problems with an awareness of the importance and deadlines

Master'S Degree, Economics, 4,9

Bachelor'S Degree, International Relations, 4.8