Sergei Troinykh - Резюме Data analyst

Work Experience — 5 years 6 months March 2025 — present 7 months Profimonsters Moscow, profimonsters.ru/ Data Analyst Data Analyst with a focus on data visualization and building reports for strategic decisions. Specialize in Power BI, SQL, DataLens, and product analytics. Experienced in logistics, e-commerce, and outsourcing. Connect data with business goals: increase revenue, SLA, conversion, reduce costs and reporting time. Develop interactive dashboards in Power BI for owners and top management, based on which strategic decisions are made. Connect directly to databases (PostgreSQL) and Google Sheets, ensuring automatic data loading and updates. Collect and process data on key business metrics: hiring costs, personnel payback, LTV, vacancy closure conversion. Analyze tariff structures and financial metrics, identify growth points. Optimized reporting process: reduced preparation time from 2 days to 2 hours. February 2024 — March 2025 1 year 2 months CMD-Service (CDEK franchisee) www.cdek.ru/ Transportation, logistics, warehouse, foreign trade activities • Foreign trade activities, customs clearance • Automobile transportation • Warehouse services Information technologies, system integration, internet • System integration, automation of technological and business processes of the enterprise, IT consulting Data Analyst Increased international transportation profit by 8% by identifying loss points using SQL (PostgreSQL) and adjusting tariffs. Automated regular reporting in Power BI, saving 30+ man-hours monthly. Migrated reports from Excel and DataLens to Power BI: improved data accessibility and update speed. Built dashboards for monitoring SLA and logistics KPIs. Collaborated with marketing and development: visualized funnels and KPIs, reducing report preparation time by 40%. August 2023 — February 2024 7 months Brand Factory Indonesia Retail trade • Online store Marketplace Analyst Launched an online store on Shopee, Wildberries, and OZON: conducted market analysis, compiled unit economics, formed assortment. Achieved margin >30% through accurate calculation and optimization of the product matrix. Revised procurement strategy, reducing product cost by 15%. Ensured the store entered the TOP-10 category on Shopee within 3 months. Set up data collection via API from all three platforms, built regular reporting in Excel and Power BI. Led a team of 12 people in product selection on platforms like 1688, Alibaba, etc. April 2020 — July 2023 3 years 4 months Joom Moscow, Joom.com Data Moderator / Content Analyst Optimized product catalog structure, increasing card CTR by 9%. Implemented improvements to product placement rules, reducing content complaints. Conducted categorization and cleaning of product data, ensuring high classification accuracy and speeding up product search for users. Key skills: processing large data volumes, optimizing user experience, developing content quality standards.

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 7 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.