Andrej Štefánik
Praha
Summary
Experienced professional business analyst with a strong background in data analysis and business intelligence, adept at driving significant value. Skilled in using data to inform strategic decisions and improve operational processes. Recognized for collaborative approach and adaptability, consistently achieving results through teamwork and creative problem-solving. Proficient in SQL and data visualization tools, enhancing ability to deliver impactful solutions.
Overview
10
10
years of professional experience
Work History
Digitalization Specialist
Zentiva
08.2025 - Current
- Architected and led the execution of a comprehensive data strategy, building a scalable and secure framework that optimized data flow and enhanced reporting capabilities.
- Automated a critical data collection process, reducing manual data entry time by 20 hours per week and increasing data accuracy by over 95%.
- Streamlined cross-departmental workflows by identifying bottlenecks and implementing digital solutions that accelerated project turnaround times.
- Developed and implemented operational dashboards that provided real-time visibility into process performance, allowing management to quickly identify and address inefficiencies.
- Engineered a scalable data management solution using Dataverse as a centralized database, serving as a single source of truth for all project-related information.
- Built and deployed a series of Power Automate flows that automated routine tasks like document approvals and report distribution, saving departments valuable time and resources.
- Developed custom applications in Power Apps to replace outdated manual systems, digitalizing form submissions and providing a user-friendly interface for data input.
- Designed and implemented data capture solutions using MS Forms to efficiently collect stakeholder feedback and project data, which was then seamlessly integrated into downstream analysis and reporting.
Business Data Analyst
Zentiva
04.2024 - 08.2026
- Guided stakeholders by transforming raw data into powerful, easy-to-understand narratives, enabling more informed and timely decision-making.
- Partnered with Process Engineers and IT teams to architect and implement seamless system integrations, significantly improving data flow and operational efficiency.
- Oversaw end-to-end data pipeline workflows, from ingestion to delivery, to guarantee the timely provision of clean and reliable data for reporting and insights.
- Drove significant KPI improvements by conducting in-depth process analysis and providing actionable insights from distribution and production data.
- Developed and maintained a suite of efficient Power BI dashboards, effectively visualizing key performance indicators and enabling data-driven decision-making across the organization.
- Optimized complex SQL queries and Power BI data models, dramatically reducing report generation time and improving data loading efficiency.
- Ensured high data integrity through rigorous validation, cleansing, and auditing, which established a reliable foundation for all integrated reporting and analysis.
- Leveraged Python to analyze data discrepancies, accurately quantifying their business impact and leading to a significant improvement in data accuracy.
- Led the digitalization of key reporting processes, including monthly and inventory reporting, by collaborating with a third-party partner to implement a new digital planning system.
Senior transport Planning For UK and Ireland
B&M Retail
11.2023 - 04.2024
- Developing potential solutions to problems such as congestion
- Worked effectively in fast-paced environments.
- Modelling traffic flows using mathematical techniques and specialist computer applications
- Analyzing and interpreting data
- Preparing reports and publications
- Acting as an expert witness during public inquiries
- Staying knowledgeable about government transport and planning policy.
- Making sure plans are hitting desired KPI's and cost per mile targets.
Reporting and Sourcing Analyst
Allyn International
01.2023 - 12.2023
- Utilize data analysis tools and software to gather, analyze, and interpret sourcing data. Generate comprehensive reports, dashboards, and visualizations to provide insights into sourcing performance, supplier trends, and cost analysis.
- Collaborate with cross-functional teams to assess supplier performance based on key metrics, including quality, delivery, cost, and responsiveness. Identify opportunities for improvement and recommend action plans.
- Analyze cost structures, pricing models, and total cost of ownership to support informed sourcing decisions. Work with suppliers to negotiate favorable terms and pricing.
- Evaluate supply chain risks related to sourcing decisions and propose mitigation strategies to ensure continuity of supply and minimize disruptions.
- Demonstrate an exceptional command of SQL and VBA programming languages, utilizing them extensively to extract, manipulate, and analyze complex data sets for sourcing insights and reporting purposes. Your deep understanding of database querying and automation through VBA scripting has significantly enhanced data-driven decision-making processes.
- Possess a working knowledge of Power BI, occasionally employing its capabilities to visualize and present data-driven findings. While Power BI was utilized infrequently, your mastery of SQL and VBA remained the primary drivers of data analysis and reporting tasks, showcasing your versatility with diverse technical tools.
4th Party Logistics (4PL) Specialist - Vendor-to-Vendor
Allyn International
01.2022 - 01.2023
- Working as part of a team providing support for GE Oil & Gas with all logistic operation with specialization on Vendor to Vendor shipments.
- Foster strong partnerships with vendors, suppliers, and manufacturers to align logistics strategies, streamline processes, and enhance overall supply chain performance.
- Manage the entire logistics process from one vendor to another, ensuring efficient flow of materials, accurate documentation, and timely deliveries.
- Preparing Custom documentation, Invoicing and managing cost of transportation if needed.
- Close communication with Air/Sea/Land transport provider and ensuring dead lines are met.
- Develop and monitor key performance indicators (KPIs) to measure vendor performance, transportation efficiency, and cost-effectiveness of logistics solutions.
- Collaborate with vendors to forecast demand accurately and manage inventory levels to avoid shortages or overstock situations.
Transport Network Planner For UK and Ireland
B&M Retail
08.2020 - 04.2022
- Developing potential solutions to problems such as congestion
- Designing research methods and survey techniques
- Modelling traffic flows using mathematical techniques and specialist computer applications
- Analyzing and interpreting data
- Preparing reports and publications
- Giving presentations about proposed transportation options
- Acting as an expert witness during public inquiries
- Staying knowledgeable about government transport and planning policy.
- Making sure plans are hitting desired KPI's and cost per mile targets.
Auditor
B&M Retail
03.2019 - 08.2020
- Preparing and executing operational and monetary audits
- Developing references and reports centred on audits and offering these concepts to the management
- Ascertaining business process threats
- Developing professional development procedures for the low-ranking staff of the organisation
- Organising and distributing resources and manpower in harmony with abilities and schedules
- Produce reports underlining problems and providing prospective ways out
- To guarantee obedience with external and internal requirements
Warehouse Planner
B&M Retail
01.2017 - 03.2019
- Ensured accurate lead times through ERP systems and Torex.
- Collaborated with cross-functional teams to align goals and ensure project success.
- Prepared and managed budget costs for planning applications, constantly verifying expenditure was within agreed budget.
- Communicating with senior team and customers.
- Optimized inventory control, reducing waste and improving costefficiency.
Education
A-Levels - Public Construction / Statics
SPŠ Stavebná Emila Belluša
06.2015
Skills
- Supply Chain
- Power Platform
- MS Excel
- Data Governance
- Report Architecture
- Python/R
- Analytical thinking
- Expert problem solving
- SQL
Languages
English
Bilingual or Proficient (C2)
Slovak
Bilingual or Proficient (C2)
Timeline
Digitalization Specialist
Zentiva
08.2025 - Current
Business Data Analyst
Zentiva
04.2024 - 08.2026
Senior transport Planning For UK and Ireland
B&M Retail
11.2023 - 04.2024
Reporting and Sourcing Analyst
Allyn International
01.2023 - 12.2023
4th Party Logistics (4PL) Specialist - Vendor-to-Vendor
Allyn International
01.2022 - 01.2023
Transport Network Planner For UK and Ireland
B&M Retail
08.2020 - 04.2022
Auditor
B&M Retail
03.2019 - 08.2020
Warehouse Planner
B&M Retail
01.2017 - 03.2019
A-Levels - Public Construction / Statics
SPŠ Stavebná Emila Belluša
Similar Profiles
Natalia NikolovaNatalia Nikolova
Invoice to Cash Collection Specialist at ZentivaInvoice to Cash Collection Specialist at Zentiva
Gianluca PiemonteseGianluca Piemontese
Chief Financial Officer at ZentivaChief Financial Officer at Zentiva
Darsh ShuklaDarsh Shukla
Mechanical Engineer at ZentivaMechanical Engineer at Zentiva
Joyce MatsosoJoyce Matsoso
Chemical Fellows (CHEMFELLS) V Research Scientist at University of Chemistry and Technology PragueChemical Fellows (CHEMFELLS) V Research Scientist at University of Chemistry and Technology Prague
Tenneal WardTenneal Ward
Elementary Teacher at ZS StrossElementary Teacher at ZS Stross