Alexander Shauklis

• Teaching activities. Course “Data Analytics in Excel” at the Master's program “Business Analytics in Economics and Management”.
• Taught students how to work in MS Excel, explained Power Query, data analysis, conducted lectures and seminars on data analysis.

Started as a Senior Analyst, further promoted to Team Lead.

Responsibilities

• Analyzed and forecasted traffic ROI
• Development and support of services for automatic data collection from the web - API, Selenium, html parsing
• Analyzed user behavior
• Conducted A/B testing
• Developed and automated analytical reporting (Excel, Power BI, Python, Superset)
• Performed various analytical Ad-Hoc tasks
• Developed telegram bots for process automation, alerting, reporting
• Supported the operation and development of the developed services
• Managed a team of 5 analysts, managed long- and short-term goals of the group, department
• Project management of the group and the group's department: maintaining documentation, managing requirements, deadlines, realization, leading projects from start to completion

One of the leading companies in consumer microfinance in Russia.

Responsibilities

• Employed statistical methods to analyze data and generate useful business reports.
• Analyzed, improved and expanded business processes
• Formulated, planned, conducted and analyzed A/B tests
• Developed a reporting system, migrating from Excel files to automated reports in Apache Superset
• Created tens of data marts collaborating with Data Engineering department
• Analyzed the lending portfolio, generated ideas to improve decision making and collection operations
• Conducted various analyses of user behavior
• Worked with the marketing department: analyzed traffic, generated and implemented ideas to increase revenue from good and bad segments, analyzed trends.
• Collaborated with stakeholders to establish a regular operational and management reporting system
• Led changes to the user flow to enhance the customer experience