About - Pavlov Analytics

ABOUT PAVLOV ANALYTICS

Pavlov Analytics emerged in 2019 with a single goal: to maximize the potential of New Zealand businesses through data.

We’re your data journey companions, guiding you from strategy to execution. With our top-tier team, we make data the compass for your decisions.

Our Team

Valery Pavlov

Over 10 Years of Managerial Experience: Skilled in leading teams and driving results in data-driven environments.
Technical Proficiency: Advanced capabilities in MS Excel (VBA expert since 1992), SQL, Python, R (including Shiny), Tableau, Power BI, and optimization tools like Cplex/Gurobi/Xpress.
Cloud Platforms: Experienced AWS user and ongoing learner of Azure, bringing flexibility in cloud-based analytics solutions.
Industry Projects: Hands-on experience delivering impactful data analytics and process improvement solutions for industries such as retail, distribution, and manufacturing. Collaborated with notable organizations, including:
- Ministry of Health, NSW Australia: Developed spinal cord injury patient pathway redesign and capacity planning tool.
- Fonterra: Optimized supply chain processes.
- United Steel: Inventory turnover improvement.
- Douglas Pharmaceuticals: Optimised production scheduling.
- Foodstuffs North Island: Demand forecasting for new products.
- Red Cross: Optimised pricing strategy.
- T&G: Warehouse optimisation.
- Toll Group (NZ Branch): Network design and capacity planning analytics solutions.

Ivan Pavlov

Data & Systems Analyst: Expert in ETL, automation, and visualization to streamline processes and unlock insights.
Background: Operations Research, optimization modeling (AMPL, Python API for Cplex/Gurobi), and advanced dashboard creation with Excel and Tableau.
Key Projects:
- Fonterra: Automated workflows, optimized operations, and delivered data-driven insights for sales and planning teams.
- Air New Zealand: Built a single-source Tableau dashboard, automated reporting, and enhanced forecasting accuracy.
Technical Skills: Power BI, Tableau, VBA, Python, SQL, PHP, JavaScript, Objective-C, Snowflake, SAP ERP, AWS.
Impact Highlights:
- Cut manual SAP tasks by 90% and errors by 99% with VBA automation.
- Enabled real-time analytics with Snowflake and Power BI.
- Developed tools to provide users 1,000x more data via API integration.

Ivan and Valery focus on the solution co-creation process with key stakeholders to optimize your business practices and workflows. To implement the stakeholder-driven solutions, we rely on our other talented team members, who are engaged on an on-demand basis to handle repetitive tasks and heavy workloads for our clients.

Tools of the trade

Our aim is to get your business the most value out of your data – enabling you to make the most informed business decisions; maximizing profit and minimizing losses. We can work with any of the top industry data and optimisation tools.