Kate Zinchenko Email & Phone Number

Limassol, Cyprus

In my current role, I focus on investment portfolios analytics using using Microsoft products and participate in IT solutions development, specifically in prototyping and documentation.- Developing and maintaining comprehensive, interactive, and user-friendly Power BI reports (MS Power BI, Power BI Report Builder, DAX, Power Query - M language, Figma, UI/UX).- Building ETL processes (SQL, Power Query, API data source integrations, PySpark).- Designing and implementing Data Warehouses (DWH) for projects, covering the full cycle from extracting data from various sources to creating final dashboards based on the DWH (Microsoft Fabric, Azure Synapse Analytics, MS Excel, MS Power BI).- As a part of a team, participating in the customization and implementation of CRM systems based on Power Platform.- Preparing scope documentation for IT projects (web/mobile apps) as well as for Power BI reports.- Designing web-application prototypes (Bubble, Figma).

Moscow, Moscow City, Russia

As an Operations Analyst, I was developing a business model to calculate the efficiency of base station construction and provided analytical reports aligned with business needs.- Created and maintained the "As is - To be" investment model (MS Excel: Power Query, PivotTable, VLOOKUP, SUMIFS, INDEX(MATCH)).- Built reports based on data marts for management (SAP OLAP cubes, MS Excel).- Maintained existing reports in terms of updates, data analysis, and optimization (MS Power BI, DAX).- Participated in transferring management reports from one BI platform to another (MS Power BI, Fine BI).Key achievements:- Analyzed and improved efficiency drivers in the investment model, enhancing the calculation model.- Improved analytical reports for the business, which helped quickly address constraints and identify potential areas for optimization in operational processes.Quit the job due to relocation

Moscow, Moscow City, Russia

As an Analyst, I led a project for implementing Power BI reporting in the company, and provided assistance to the Controlling Department and Top Management.- Developed and maintained reports and dashboard (MS Power BI, DAX, Azure Data Studio, MS SQL Server - T-SQL, MS Excel).- Negotiated with the report customer (leasing managers), developed and delivered the project, and handled further administration (MS Power BI, Trello).- Prepared and analyzed regular reports and ad-hoc requests (1C ERP, MS Excel).- Presented company performance results to the management (MS PowerPoint, MS Power BI).Key achievements:- Initiated and led the negotiation process with the customer for report development.- Standardized regular reports increased managers' efficiency.- Developed a Power BI report that reduced the time to obtain key business information from 1-2 days to a few minutes, and helped to decreased the workload of the analytics department.- During the difficult economic situation (Feb-Mar 2022), analyzed the tenant database and proposed possible development scenarios, which helped achieve commercially beneficial conditions.

Moscow, Moscow City, Russia

As a Financial Analyst, I contributed to analyzing financial data, budgeting/forecasting, creating reports, and providing insights to support strategic decision-making.- Prepared and analyzed regular reports, and provided performance reviews to management (1C ERP, MS PowerPoint, MS Excel, MS Power BI).- Actively participated in the budgeting process of divisions and expense optimization in collaboration with management (1C ERP, Excel, MS PowerPoint, Project Manager system).- Prepared analytical overview based on plan-fact analysis of P&L, CF, Forecast (short/long-term), and analysis of key performance indicators: Margin, EBITDA, expenses by division (1C ERP, MS PowerPoint, MS Excel).- Created and optimized Excel models for the budgeting process, investment business plans, revenue and expense forecasting models (1C ERP, MS Excel - Power Query, PivotTable, VLOOKUP, SUMIFS, INDEX(MATCH)).- Mentored a junior analyst in the Finance Department.Key achievements:- Helped to optimize budgets (~150 divisions) and to increase EBITDA.- In collaboration with IT department, developed a solution for distributing logistics expenses in 1C ERP, reducing task completion time from 2-3 days (in Excel) to 2-3 hours (in 1C ERP).- Calculated employee KPIs during the economic instability (Covid-19), which helped to keep profit at the planned level (NDA).- Corrected allocation of expenses and revenues in P&L during the financial closing period, ensuring accuracy of financial reporting.

Moscow, Moscow City, Russia

- Prepared a database of indirect costs in logistics for the last few years to see dynamics and problem areas (MS Excel).- Worked with large datasets in MS Excel using tools and formulas such as Power Query, PivotTable, VLOOKUP, SUMIFS, INDEX(MATCH) and etc.- Analyzed key performance indicators based on collected data and presented to management of Financial department.