Playing Chess/boardgames
YINHLA SHIKWENI
Pretoria
Summary
Results driven Production Systems Analyst and a Masters (IS) candidate with hands-on experience in production control, enterprise systems and data analysis operations within BMW Group SA. Leveraging advanced SQL, business intelligence and data analytics to enhance production efficiency and reliability.
Recognized for critical problem-solving skills and delivering actionable insights through interactive dashboards, driving continuous improvement in production performance and ensuring on-time delivery of quality vehicles. Strong leadership ability with experience working in collaborative team-based environments.
Overview
3
3
years of professional experience
6
6
Languages
Work History
Production Systems Analyst
BMW Group SA
11.2024 - Current
- Directed production planning and control for high-volume manufacturing, ensuring KPI alignment and operational efficiency
- Developed and optimized SQL queries supporting Next Generation BMW X3 (G45) production, enabling accurate real-time data insights and improved decision-making
- Built and maintained interactive dashboards using AWS, Power BI, QlikSense and APEX, enhancing visibility of production performance and KPI tracking
- Designed and enhanced production and enterprise systems, improving reliability and performance
- Monitored system constraints (including PLCs) in real time, minimizing disruptions and ensuring continuous production flow
- Conducted COS simulations and F2 prognoses to identify risks and maintain production stability
- Managed critical production incidents independently, preventing assembly and painted-body stoppages
- Analyzed production KPIs to detect issues early and improve operational performance
- Maintained IPS system data integrity and network availability for reliable data access
- Coordinated Special Build Vehicles (NSG), ensuring on-time delivery and quality compliance
Graduate - Process Analyst
BMW Group SA
02.2024 - 10.2024
- Enhanced team collaboration by providing clear communication of complex findings through visualizations and reports.
- Collaborated with cross-functional teams to identify opportunities for process improvement and increased efficiency.
- Improved internal knowledge sharing by developing comprehensive documentation outlining standard operating procedures for various tasks.
- Increased efficiency by streamlining data analysis processes and implementing automation tools.
- Delivered data-driven insights to support enterprise systems and operational decision-making
Student Intern
BMW Group SA
05.2023 - 01.2024
- Provided system support, reporting and data analysis to assist production operations
- Documented and maintained production systems, improving system reliability and consistency
Education
Masters in IT - Information Systems
University of Pretoria
Pretoria, South Africa 04.2001 -
Higher Certificate - Management Practice
Henley Business School
Pretoria, South Africa 04.2001 -
Bachelor of IT Honours - Information Systems
University of Pretoria
Pretoria, South Africa 04.2001 -
Bachelor of IT - Business Systems
IIE Rosebank College
Pretoria, South Africa 04.2001 -
National Senior Certificate - Science
Nghonyama High School
Giyani, South Africa 04.2001 -
Skills
Programming & Querying
SQL
Python
JavaScript
HTML5,
SCSS/CSS
Pseudocode
ETL
Data & Analytics
SQL (Advanced)
Power BI (Advanced)
QlikSense (Advanced)
AWS (Data & Analytics)
Oracle SQL Developer
APEX
SQL Server Management Studio
Enterprise & Systems
SAP
PLC Systems
IPS Systems
OpenText HostExplorer
Tools & Platforms
Microsoft Office 365
Confluence
Jira
Notepad
Windows OS
PowerApps
Soft Skills
Attention to Detail
Critical Thinker
Effective Communication
Resilient
Computer Literacy
Results Focused
High Learning Agility
Adaptability
Accomplishments
Business Intelligence Migration to AWS
- Supported migration of BI and reporting solutions to AWS, improving scalability, performance and data accessibility
- Optimized data workflows and reporting processes to enable more efficient and reliable analytics
SQL Query Optimization for Production Systems
- Developed and optimized SQL queries to support production data processing, improving data accuracy and retrieval efficiency
- Enhanced reporting performance by streamlining queries used in operational dashboards
Production Documentation System (PowerApps)
- Developed a PowerApps solution to digitize and standardize production documentation processes
- Reduced manual documentation time and improved data accuracy, enabling more efficient and reliable record-keeping
RFID-Based Livestock Management System (Master's Research)
- Designed and evaluated an RFID-based system to improve livestock tracking and management in small-scale cattle farming
- Applied data-driven Technology Acceptance Model (TAM) to enhance efficiency and support decision-making in agricultural operations
Interests
Roadrunning/Marathons
Hiking
Fishing
Listening to Music
Timeline
Production Systems Analyst
BMW Group SA
11.2024 - Current
Graduate - Process Analyst
BMW Group SA
02.2024 - 10.2024
Student Intern
BMW Group SA
05.2023 - 01.2024
Masters in IT - Information Systems
University of Pretoria
04.2001 -
Higher Certificate - Management Practice
Henley Business School
04.2001 -
Bachelor of IT Honours - Information Systems
University of Pretoria
04.2001 -
Bachelor of IT - Business Systems
IIE Rosebank College
04.2001 -
National Senior Certificate - Science
Nghonyama High School
04.2001 -