Martin Zdražil

Experience

• 

  Foxconn Czech Republic

  Jan 2011 - Jan 2015

  In my dynamic role, I was entrusted with the critical responsibility of administratively managing the material influx into our warehouse. I streamlined the process of creating urgent orders, ensuring a seamless alignment between physical stock and system records to achieve 100% inventory accuracy. My passion for simplifying work life led me to develop sophisticated Excel formulas and scripts that automated SAP transactions, directly interfacing with Excel.I took great pride in utilizing my expertise in HTML, CSS, JavaScript, VBS, and advanced Excel functions and macros to enhance operational efficiency. My hobby of making work life easier translated into tangible benefits for the company, as I continuously sought ways to refine processes and empower my colleagues with user-friendly solutions. Zobrazit méně In a leadership capacity at Foxconn, I managed a team of 40, effectively:- Cultivating leadership and problem-solving skills to guide my team toward operational excellence.- Providing technical support, leveraging my expertise to enhance our operational processes with automated solutions.- Overseeing the warehouse operations, ensuring the timely and accurate fulfillment of inventory plans and order processing.- Implementing innovative Excel VBA scripts and automations to streamline SAP transactions, boosting productivity and accuracy.- Developing and employing tools using HTML, CSS, JavaScript, and VBScript to improve data management and reporting processes.Skills: Team Leadership • SAP ERP • Process Automation • Excel VBA • Problem-Solving • Data Analytics • HTML • CSS • JavaScript • VBScript---**Orders Coordinator, SAP Operator**Foxconn Technology Kutná Hora • Apr 2011 – Nov 2012During my tenure as an Orders Coordinator:- I was responsible for creating urgent orders and maintaining real-time inventory accuracy.- I utilized my skills in Excel to develop formulas and scripts, automating routine tasks and enhancing efficiency.- I ensured a balance between physical inventory and system records, achieving 100% inventory accuracy.- My passion for technology and efficiency drove me to automate SAP transactions, simplifying workflows and improving operational processes. Zobrazit méně

  • Receiving administrator

    Jan 2014 - Jan 2015

  • Group Lead, Orders Coordinator

    Jan 2012 - Jan 2014

  • Orders Coordinator, SAP operator

    Jan 2011 - Jan 2012
• 

  JUSDA Europe

  Jan 2015 - Jan 2022

  Coordinator & Warehouse Leader, Orders Coordinator

  - Directed and developed a team of up to 20 members, focusing on cultivating leadership and supervisory skills.- Enhanced work processes using a variety of programming and scripting languages including Excel VBA, HTML, PHP, Python, and VBScript.- Provided consistent and reliable tech support for the team.- Managed the operations of the warehouse, ensuring efficient fulfillment of plans and order processing.- Addressed logistics, production, and warehouse challenges with effective problem-solving.- Gained proficiency with SAP ERP, Visual Studio, and SQL Developer, applying these tools in practical scenarios. Zobrazit méně

• 

  Thermo King

  Jan 2022 - Jan 2022

  Production Planner

  During my tenure as a Production Planner at Thermo King, I contributed significantly to:- The creation and scheduling of intricate production plans, aligning manufacturing capabilities with business forecasts.- Development of VBA macros for Excel to enhance integration with enterprise systems, improving data management and reporting accuracy.- Streamlining of workflow processes, optimizing the efficiency of production planning and monitoring.- Implementation of visualization tools and setting analytical views to meet customer requirements and support decision-making.- Providing technical support to the team, ensuring the smooth operation of production activities.- Leveraging my skills in Oracle R12, Alteryx Designer, Tableau, Power BI, Visual Studio, and SQL Developer to enhance productivity and reporting precision. Zobrazit méně

• 

  NTT DATA, Inc.

  Jan 2022 - now

  Data Informatics Analyst

  In my current role at NTT Ltd., my key responsibilities include:- Crafting and maintaining Power BI reports for various business divisions, ensuring accurate and actionable data visualization.- Streamlining processes by automating tasks with Microsoft Power Automate, enhancing efficiency across the board.- Employing my strong analytical skills to interpret complex datasets and translate them into strategic insights.- Writing and optimizing SQL queries for data extraction, demonstrating my proficiency in database management and data modeling.- Developing solutions using Microsoft Power Query and Python to address bespoke data analysis requirements.- Innovating in the space of AI to drive forward-looking initiatives and improve decision-making processes.- Maintaining clear and effective communication with team members and stakeholders in English.- Engaging in web development activities to support the company's online presence and reporting capabilities. I love that job! Zobrazit méně