Ilya B. Email & Phone Number

Ukraine

• Designed and maintained dashboards for the largest jewelry retail company in the world with complex data infrastructure using various data sources: Databricks, Synapse, on-premises MS SQL Server, Azure Analysis Services • Supported, contributed, maintained, developed, and improved 20+ dashboards across retail, e-commerce, marketing, and fraud prevention domains as part of the E-Com team, then the GTM & Loyalty team• Independently supported and monitored the dashboard for the loyalty program during the launch of the company's biggest markets. Swiftly resolved issues and closely collaborated with data engineers to solve data source problems.• Ensured the provision of accurate dashboard data on loyalty program launch efficiency used by analysts, market managers, and the loyalty director and reported to the CEO and the stock market.• Quickly took ownership of unfamiliar projects after other developers went on a vacation/parental leave and successfully finished their work and deployed polished dashboards• Presented dashboards for small to large audiences (100+), tailored for non-technical audiences in simple terms.• Developed dashboard for A/B testing of email marketing campaigns with sales performance uplift analysis• Built Email Performance dashboard that combines data from multiple sources: Adobe Analytics, Bloomreach, and web interactions, and condenses reports from those platforms into a single page overview. • Worked in close collaboration with a data engineer to resolve performance optimization problems by implementing optimal dimension modeling, aggregation level, incremental refresh

• Significantly increased productivity of financial fraud prevention team by creating dashboard for monitoring messages with potential fraud trigger words for messages in chats between customers and freelancers using SQL regexp.• Conducted customer segmentation analysis using SQL queries to BigQuery datawarehouse to provide insights on customer segments for personalized email marketing• Automated repeated monthly excel reports on customer reviews and feedback using Power BI• Developed dashboard for sales team performance tracking conversion rate from leads to buyers • Built dashboard analyzing if freelances read description and download attached files

• Learned visualization tools basics in 6 days to transition from python dev role to data analyst and immediately started delivering value by writing SQL queries and building dashboards• Selected among 12 out of 220 applicants from a company training program for internship leading to a full-time position based on outstanding performance