Alyona Sachyova

Business & BI Analyst focused on CRM, reporting and workflow automation. I translate business needs into structured processes, system logic and practical solutions. Experience includes Bitrix24 CRM architecture, lead and deal workflows, roles, access rights, assignment and escalation rules, Power BI, DAX, SQL, ClickHouse, GitHub Actions and API-based automation. I also develop AS-IS/TO-BE models, requirements, UAT scenarios and documentation, and coordinate implementation with business, IT and developers.

Developed and automated Power BI dashboards for sales, calls, requests, bonuses, payments, and profit tracking. Consolidated data from SQL (ClickHouse), Excel, CRM, Forms, and APIs into a unified model. Built DAX KPIs, implemented RLS by roles, and scheduled data refreshes. Visualized SLA performance, commissions, and employee efficiency. Identified bottlenecks through deviation analysis and optimized request processing flows accordingly.

Led full-scale automation of analytics with 90% of project reports built from scratch in Power BI. Created dashboards for sales, field staff KPIs, and forecasting. Optimized DAX and Power Query M. Formalized project goals with stakeholders and mapped business processes. Introduced a Helpdesk system for analytics requests. Trained employees on new BI tools and maintained project documentation. Provided insights to improve field team efficiency and budget planning.

I supported financial and operational control for an education business and transformed manual schedules, payment records and attendance data into structured working reports. - Built a financial model and custom management reports in Excel and Google Sheets. - Managed training-center schedules and teaching-hour calculations and improved operational planning. - Documented coordinator workflows and prepared procedures and user instructions.

Managed executive scheduling, organized meetings, and handled documentation. Translated and edited legal, media, and commercial content. Participated in client-facing projects—conducted research, prepared presentations, and drafted reports. Developed three SOPs for logistics aligned with ISO 9001. Took part in company rebranding, created templates for business communications. Improved internal coordination and optimized workflows in cross-functional teams.