Oleksandr Pukas

Senior Business/Data Analyst

• Led the development and delivery of data engineering solutions for the TAX stream, aligning with business goals and ensuring regulatory compliance.
• Collaborated with senior leadership and Product Managers to define requirements, manage expectations, and translate tax requirements into actionable data strategies.
• Acted as the primary liaison between product development teams and stakeholders, ensuring seamless communication and alignment.
• Designed and implemented data pipelines to support tax planning, compliance, and reporting initiatives.
• Delivered comprehensive tax reports and presentations to senior leadership, highlighting key findings and strategic recommendations.
• Led cross-functional initiatives to optimize tax data processes and drive operational efficiency.
• Utilized DBT, Airbyte, and Airflow to build and deploy data pipelines, ETL processes, and data integration strategies.

Scrum Master

• Facilitated Agile ceremonies (stand-ups, sprint planning, retrospectives), ensuring continuous improvement and alignment with sprint goals.
• Prioritized and managed the product backlog, ensuring timely delivery of features, bugs, and improvements based on business priorities.
• Worked with stakeholders to resolve external dependencies and obstacles affecting team progress.
• Implemented a daily bot for stand-up meetings, improving efficiency and reducing meeting time for a team of 15.

Product Delivery Manager

• Served as the primary liaison between the product development and TAX teams, ensuring clear communication and alignment on project goals.
• Provided regular updates and reports to leadership on product delivery progress, risks, and outcomes.
• Led the migration of TAX data to cloud platforms (GCP), improving scalability and performance.
• Managed task creation and backlog prioritization, ensuring the timely delivery of TAX project milestones.

• Conduct exploratory data analysis (EDA) in Jupyter notebooks and summarize findings.
• Develop and implement data pipelines for metric calculation and processing.
• Analyze HDFS and DWH data, providing insights and system enhancement guidelines.
• Use PySpark for real-time data processing and BI tools for trend analysis.
• Design data pipelines for acquisition, cleaning, and processing.
• Create customized reports and dashboards for stakeholders.

• Updated SQL and T-SQL stored procedures for Development and Production teams.
• Created and modified database objects (tables, functions) in SQL Server Management Studio.
• Developed and executed unit tests to ensure database functionality and integrity.
• Collaborated on database design, delivering demos to stakeholders.
• Provided actionable insights and communicated data requirements to align with business goals.
• Gathered and refined database requirements to support project delivery.

• Improved sales team efficiency by providing data on their performance. Came up with the idea to create a promotional video in replacement of brochure. This video attracted more clients to sign up and participate in program.
• Created “return bonus” – each time customer logins to the platform – receives points. That lead to idea to create a daily quiz about PepsiCo and its’ products where correct answers add to your balance additional bonus.
• Supported leadership team with reporting, analysis, and business presentations
• Analyzed performance metrics to identify opportunities to increase sales.

• Conduct data analysis using Python to identify opportunities for improvement and business insights.
• Develop and execute queries in Hive, Presto, and PostgreSQL; design and manage data tables/pipelines.
• Perform data quality checks and ensure data integrity.
• Prepare detailed weekly reports for the EMEA Leadership team.
• Create high-performance reports and visual analytics using Data Studio and Tableau.
• Develop and maintain interactive dashboards to support decision-making.
• Provide actionable business insights and develop action plans for improvement.
• Analyze complex data sets to identify trends, root causes, and corrective actions.
• Collaborate with business leaders to prioritize and address business problems.
• Participate in requirements meetings to align data solutions with business needs.
• Test and validate data prediction algorithms using historical data.

• Ensure smooth EMEA operations, coordinating with 50+ remote stakeholders.
• Manage and deliver projects from initiation to completion, identifying and mitigating risks.
• Design and optimize strategies to enhance process efficiency and automation.
• Create and improve processes for Regional Operations, supporting reporting needs with SQL and CRM tools.
• Develop and enhance reports/dashboards to support decision-making and process monitoring.
• Demonstrate strong adaptability to new tools and environments while meeting tight deadlines.