SQL
James Engelbrecht
Pretoria
Summary
I have a strong background in VBA development and SQL database management , specializing in automation tools and system enhancements . My experience includes building custom VBA solutions to extend the capabilities of large-scale software, particularly in stock management, automated calculations, and report generation . I have developed auto Min/Max stock calculators, settlement report generators, and inventory tracking tools , integrating them with SQL databases for seamless data processing. Additionally, I have worked on system integrations, data validation, and workflow automation , optimizing efficiency and reducing manual workload. My expertise also includes debugging, troubleshooting, and user training to ensure smooth implementation and adoption.
Overview
3
3
years of professional experience
Work History
Technical Solutions Developer
Co3 Technologies
12.2021 - Current
- Developed Advanced VBA Tools – Designed and implemented custom VBA companion tools to enhance the functionality of a large-scale software system, addressing gaps and improving automation.
- Automated Stock Management & Calculations – Created auto Min/Max stock calculators and custom stock management tools to optimize inventory control, reducing manual tracking efforts.
- Settlement Report Generators – Built automated settlement report generators with integrated financial calculations, ensuring accuracy and efficiency in reporting.
- System Integrations & Data Processing – Developed custom integrations between the main system and Excel/Access-based VBA solutions, enabling seamless data exchange and enhanced functionality.
- Process Automation & Optimization – Automated repetitive workflows, including data validation, report generation, and operational analytics , reducing processing time and minimizing errors.
- User-Centric Customization & Support – Designed tools tailored to end-user needs, providing technical documentation, training, and troubleshooting to ensure smooth adoption and usability.
Education
Bachelor of Engineering - Mechanical Engineering
University of Pretoria
Hatfield, Pretoria, GT, South Africa12-2027
High School Diploma -
Kearsney College
Botha's Hill, Hillcrest, KZN, South Africa12-2023
Skills
- VBA Automation & Macros
- SQL Queries & Database Management
- Stock & Inventory Systems
- Report Generation & Data Processing
- System Integration & APIs
- Debugging & Optimization
Hobbies
I enjoy learning about engines, modifying cars, and exploring automotive engineering. I'm passionate about motorsport, including performance tuning, racing dynamics, and vehicle optimization, constantly improving my technical knowledge and hands-on skills. I also love designing and creating crazy good light setups for cars, combining aesthetics with functionality to enhance visibility and style.
Accomplishments
- South African Mathematics Olympiad (SAMO) Finalist (2022) – Ranked in the Top 100 nationwide.
- Self-taught VBA Developer – Learned VBA at an advanced level independently in Grade 11, applying it to automation, database management, and system enhancements.
Software
VBA
Visual Basic
Python
Java
C#
Timeline
Technical Solutions Developer
Co3 Technologies
12.2021 - Current
Bachelor of Engineering - Mechanical Engineering
University of Pretoria
High School Diploma -
Kearsney College
Similar Profiles
Venkata Nagaraju InakolluVenkata Nagaraju Inakollu
Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)
Sachin HatoleSachin Hatole
Quality Analyst at Mindpool Technologies Pune, Mindpool TechnologiesQuality Analyst at Mindpool Technologies Pune, Mindpool Technologies
Keith LawrenceKeith Lawrence
Material Handler at Casting Technologies TechnologiesMaterial Handler at Casting Technologies Technologies
Wernich BotesWernich Botes
Financial Accountant at Feenstra Group Property Developers and ManagersFinancial Accountant at Feenstra Group Property Developers and Managers
Murangi NetshisauluMurangi Netshisaulu
Intern: Financial Management Grant at City Of Tshwane MunicipalityIntern: Financial Management Grant at City Of Tshwane Municipality