Alexander Stepanov Email and Phone Number

As a Business Analyst at a leading Russian metallurgy company, I played a pivotal role in bridging the gap between stakeholders and technical teams, ensuring the successful implementation of web software and cultivating critical thinking and strong analytical skills.Key Responsibilities:• Developed user stories and use cases by actively engaging with stakeholders, translating their requirements into actionable insights for the development team.• Designed AS-IS and TO-BE processes using BPMN methodology, streamlining operations and identifying areas for improvement.• Gathered, analyzed, documented, and prioritized stakeholders' requirements in Confluence utilizing the SCRUM framework, ensuring alignment with project goals and objectives.• Found needed data from Apache KAFKA topics using Kafkadrop, Offset Explorer, Notepad++ to document necessary data for integration into designing web software.• Organized and facilitated meetings with stakeholders, including engineers, architects, and product owners to validate and approve required logic for web service development.• Created and assigned tasks and bug fixes for frontend, QA, design and backend teams in JIRA, ensuring efficient development of web service development..• Analyzed technical logs of web services using OpenSearch and PG admin, identifying and addressing failures and business logic errors.• Provided technical support for dashboards in Grafana, ensuring their functionality and usability for stakeholders.Achievements:• Successfully conducted the full cycle of project integration: from gathering stakeholder requirements to documenting and training staff on the operation of the designed web service.• Designed robust ER diagrams and web service algorithms, ensuring their scalability and reliability.• Quickly identified and resolved business logic errors in web services, minimizing stakeholder frustration and boosting overall system performance.

As a Junior Analyst at a leading Russian metallurgy company, I specialized in data analysis and project support to drive operational efficiency and strategic decision-making.Responsibilities:• Conducted comprehensive analysis of customer requirements, optimizing PostgreSQL code, and developing multiple Grafana dashboards.• Supported tender submissions by conducting in-depth research on customer topics, crafting compelling PowerPoint presentations, and preparing project implementation plans using Gantt charts.• Leveraged advanced MS Excel techniques, including Pivot Tables, xlookup, and Power Query, to analyze industry data and extract valuable insights, facilitating further utilization of data science methodologies.• Facilitated efficient communication with clients by creating detailed follow-up reports after meetings, ensuring that all action items were tracked and addressed promptly.• Assisted in determining database sizing requirements, ensuring growth rate and scalability to support resource planning of the projects.• Played a vital role in resource planning for customer projects, prioritizing vendors based on their capabilities, scientific background, and alignment with project objectives.Achievements:• Implemented data visualization solutions in Grafana, leading to improved understanding of scrap order metrics and tangible process enhancements at the scrap facility.• Received commendation for analytical and communication skills, contributing for better understanding of steel production processes.

Для студенческой организации разрабатывал дашборды. Чуть подробнее:- делал дашборды на Apache Superset, Microsoft Power BI- по CSV выгрузкам анализировал данные через Power Query, проводил статистический анализ sample size- по ETL: в Power BI создавал data tables по схеме «snowflake» для вывода Data Mart

Основал рабочую группу по аналитике данных. За год проект должен был достичь несколько целей, чтобы группа переросла в полноценный департамент по аналитике данных и бизнес анализу. В конце года успешно защитил проект на локальной студенческой европейской конференции.Я набрал международную команду из 10 волонтеров: 1 менеджер, 3 бизнес аналитика, 1 fullstack developer, 5 аналитиков данных. Чуть подробнее по задачам:- планировал работу проекта, ставил цели, декомпозировал и распределял задачи, управлял рисками, выступал на митапах - лидировал внедрение KPIs для внутренних департаментов, разрабатывал процесс онбординга и методов работы потенциального департамента, анализировал бизнес-процесс ETL внутри организации, создал правила использования данных согласно GDPR - разрабатывал дашборды для внутренних департаментов на Microsoft PowerBI (MS SQL, Excel)

-Succeeded in presiding over a group of 20 people by rising their involvement in the organization 65%.-Increased volunteers' communication 80% by holding 11 meetings and rising chatting 70% while ensuring their inspiration and motivation.-Signed 28 partnership agreements with international corporations, automotive manufacturer, oil and gas services provider, consulting firm, and professional services firms, among others by supervising the communication and negotiation flow between management and stakeholders.-Accomplished in tutoring 25 people at negotiation, networking, writing and effective communication by organizing 20% more trainings to be delivered by experienced alumnies and increased participation rate by 40%.-Acquired knowledge in auditing and accounting by writing 8 month reports and 1 annual report, assessing financial sustainability, making financial forecasts and reporting quality management.