Резюме: Аналітик даних (Запоріжжя)

Досвід роботи

• Sales Data Analyst LIGA ZAKON <p>WORK EXPERIENCE</p>
  <p>Power BI &amp; Data Visualization: Designed and maintained interactive dashboards and</p>
  <p>reports using Power BI; advanced use of DAX for custom calculations and measures; data</p>
  <p>preparation via Power Query. Data Modeling: Created and optimized tabular data models; managed large datasets and</p>
  <p>complex relationships between tables to ensure accuracy and performance. Data Integration: Connected and transformed data from multiple sources including MS</p>
  <p>SQL Server, Excel, and APIs; ensured consistent and reliable refresh of data pipelines. SQL Development: Built and optimized complex SQL queries for ETL, aggregations, and</p>
  <p>performance improvement; worked with relational databases to support analytical needs. ETL &amp; Data Processing: Implemented ETL workflows with SQL, Python, and Power Query;</p>
  <p>experience with SSIS for data transformation and automation. Business Analytics: Collaborated with stakeholders to translate business needs into</p>
  <p>technical requirements and analytical insights; supported financial (P&amp;L, Cash Flow), sales,</p>
  <p>and product reporting. Key Achievements</p>
  <p>Automated sales and financial reporting, reducing manual effort by 50% and improving</p>
  <p>accuracy. Built customer retention and cohort analysis models, enhancing decision-making on</p>
  <p>acquisition and churn strategies. Streamlined sales funnel reporting with Power BI, enabling faster detection of</p>
  <p>bottlenecks and more effective sales performance tracking. Developed ETL processes (SQL, Python, Power Query) ensuring clean and reliable data</p>
  <p>pipelines. Delivered Power BI dashboards used across departments for real-time insights.</p>
• Expert Analyst LIGA ZAKON <p>Analyze financial, accounting and tax data</p>
  <p>Creating publications on accounting and tax topics</p>
  <p>Providing consultations on the specified topics</p>
  <p>Implemented own ideas for improving the company's product line and services</p>