Sergei Troinykh - Резюме Data analyst

Brand Factory (Indonesia) Industry: Retail, Online Store Position: Data Analyst Duration: October 2024 – Present Responsibilities: Participated in launching an online store on the Shopee marketplace in Indonesia, closely collaborating with the company's founder. Conducted niche market research and analyzed local demand using statistical tools. Calculated unit economics and identified high-margin products for the store's assortment. Compared procurement costs on platforms like Alibaba and 1688 with market prices in Indonesia to optimize product cost. Negotiated with Chinese suppliers to secure favorable terms and detailed product information. Systematized analytics and calculations using Google Sheets for effective planning. Achievements: Successfully laid the foundation for a store with a unique product range, achieving TOP-10 ranking in its category within 3 months after launch. Developed a product strategy that ensured profitability with margins exceeding 30%. Reduced procurement costs by 15% through supplier negotiations. CMD-Service (CDEK franchisee) (Russia) Industry: Logistics, Warehousing, International Trade Position: Data Analyst Duration: February 2024 – September 2024 Responsibilities: Contributed to the development of pricing strategies for international shipping. Created cost-reference guides for colleagues in Excel, reducing the need for time-consuming PDF searches. Analyzed profitability and other metrics for international logistics to aid decision-making for market expansion. Utilized Apache Superset for advanced data analysis and worked with OLAP cubes. Extracted and aggregated data using SQL. Designed interim visualizations in Power BI and recommended a transition to DataLens for enhanced visualization. Automated weekly and monthly reporting through dashboards in DataLens, saving over 30 man-hours per month. Skyeng/Skypro (Moscow, Russia) Industry: Online Education Position: Data Analyst Duration: September 2023 – July 2024 Key Competencies and Skills: Advanced Excel: Pivot Tables, Power Query, Power Pivot, charts, statistical analysis. Proficient in SQL: PostgreSQL, MySQL, Metabase; writing complex queries, window functions, CTEs. Python: Data analysis with Pandas, NumPy, Matplotlib, Seaborn. Strong theoretical knowledge of probability, statistics, and data analysis. Experienced in sales and profit analysis, cohort and vintage analysis, and KPI evaluation (e.g., Retention, ARPU, ARPPU). Key Projects: Detected anomalies in data sets. Calculated user retention and LTV for an online cinema. Analyzed the impact of betting odds adjustments on a bookmaker's profitability. Developed a bond profitability calculator in Excel. Achievements: Ranked in the TOP-3 students during the course. Completed 6 major cases and 20+ assignments with excellent ratings. Provided additional peer support during the course. Joom (Russia) Industry: E-commerce Position: Website Moderator Duration: April 2020 – July 2023 Responsibilities and Achievements: Moderated and created product cards following internal guidelines. Worked with large data sets for product categorization. Improved product catalog structure, enhancing navigation and user experience. Provided guidance to colleagues on complex cases.

SkyPro – Data Analyst (2024) Russian New University (RosNOU) – Bachelor’s in Economics, Management & Finance (2015) Russian New University (RosNOU) – Economics and Accounting (2012) Certifications: DataLens: Data Analysis and Visualization (2024) AI Trainer Course (2023)

Skills Data Analysis Advanced MS Excel SQL (PostgreSQL, MySQL) Python (Pandas, NumPy, Matplotlib, Seaborn) E-commerce analytics Retention, MAU/WAU/DAU metrics Data Visualization (Power BI, DataLens) Languages: Russian: Native English: B1

-

For over five years, I have been working remotely and excel at self-organization. I transform any informational chaos into a clear, understandable, and accessible format. Skilled in logically validating hypotheses and assumptions, as well as creating scenarios and strategic plans. Passionate about data analysis and uncovering patterns, with the ability to develop solutions and strategies based on thorough evaluations. Proficient in tools such as MS Excel, SQL, and Google Sheets, using them extensively for data analysis. Constantly improving my skills: currently intensively studying Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, and another SQL dialect (MySQL). Quick to adopt new tools, programs, and technologies; I enjoy automating workflows, enabling me to efficiently solve complex tasks. Committed to continuous development and enhancing professional skills, allowing me to stay ahead of changes and tackle the most challenging cases. Open to adopting new methods and technologies to improve processes and boost efficiency. Experienced in sourcing information from diverse platforms — I can extract valuable insights from Google and ChatGPT, leveraging over two years of hands-on experience with GPT-based neural networks.