Mikhail Sereda Email & Phone Number

Астана, Казахстан

• Provided analytics for a project focused on reducing product losses (~0.4% of annual GMV effect on PL)• Enhanced the financial closing process related to product losses, reducing data preparation time from 5 to 2 working days, mitigated error risks for other teams (~260 min annual effect on PL).• Led the migration of team reports from Power BI to Superset• Established and managed a weekly process for monitoring the current business situation, devising specific actions to enhance performance and achieve key KPIsI have extensive experience in PBI (incl. DAX), SQL, Excel (incl. Power Pivot and Power Query), SuperSet (incl. CSS customization), and have basic skills in Python, worked with SAP (General ledger) and SBFC. I prefer employing the Kanban approach in management.

Moscow, Moscow City, Russia

• Led project feasibility assessment by assortment, +7.45 p.p. FMCG category margins due to analysis results.• Led the development of analytics covering SL, Lead Time, inventory and turnover, stock availability, GMV, FM, average product price, marketplace commission volume and structure• Established and managed a weekly process for monitoring the current business situation, devising specific actions to enhance performance and achieve key KPIs• Designed a sales forecasting model with customizable forecasting periods• Calculated KPIs for GMV, Front margin, Back margin, checked and approved KPIs for Cash flow, NWC, turnover

Омская Область, Россия

As SOX auditor:• Organized the internal audit process in accordance with the client's requirements• Organized the work of the internal audit department, implemented tools for controlling the work of the department, created a communication system between the team and the client• Created documentation for the audit process.• Achieved 8.26% reduction in annual client service costs• Improved the process of testing controls by developing a unified algorithm• Initiated changes in executing 4 controls on client side• Led discussions on improving audited processes with process owners and the audit team, preparing for upcoming testingAs Financial reporting specialist:• Automated the process of preparing documents for uploading to the SAP (Macros)• Automated the preparation process for various financial reports using Power Query and macros• Developed a tracking system for monitoring employees' KPI performance during the financial closing period using Power Query• Participated in the process of Material Ledger implementation in SAP in the role of General Ledger expert• Conducted training sessions (Excel and Power BI usage)

Master'S Degree, Business/Managerial Economics

Bachelor'S Degree, Finance, General