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
8
8
years of professional experience
Work History
Business Data Analyst
Zentiva
04.2024 - Current
- Increased data accuracy by implementing thorough data validation and cleansing processes.
- Developed and improved integrated reporting and analysis capabilities.
- Deep-Dive analysis of process to improve KPI's
- Reduced report generation time significantly by optimizing SQL queries cooperating on improving already existing database.
- Utilized data visualization techniques to present and explain complex data sets.
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 Management
- Report generation
- Analytical Thinking
- Project Management
- Machine learning
- Business intelligence
References
Available upon request.
References
Available upon request.
Languages
English
Bilingual or Proficient (C2)
Slovak
Bilingual or Proficient (C2)
Timeline
Business Data Analyst
Zentiva
04.2024 - Current
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
Darsh ShuklaDarsh Shukla
Mechanical Engineer at ZentivaMechanical Engineer at Zentiva
Rutikumari RajputRutikumari Rajput
Human Resources Generalist at ZentivaHuman Resources Generalist at Zentiva
Nadia PetkovaNadia Petkova
Cash Collection Specialist + Cash Application at Alvogen Pharma (Zentiva)Cash Collection Specialist + Cash Application at Alvogen Pharma (Zentiva)
Huy NguyenHuy Nguyen
Data Reporting Analyst at Tamda Foods Ltd.Data Reporting Analyst at Tamda Foods Ltd.
Kateřina UtěšenáKateřina Utěšená
Compliance Services Monitoring Officer at Deutsche Börse GroupCompliance Services Monitoring Officer at Deutsche Börse Group