Nelson Aparecido Andre Junior
Sydney,Australia
Summary
Highly versatile IT professional with strong expertise across Artificial Intelligence, full-stack development, systems administration, and enterprise automation. With a hybrid background as an ICT Support Engineer and Full-Stack Developer, I design, build, and maintain end-to-end digital solutions that streamline business operations and empower teams.
I specialise in AI-driven applications, including OpenAI API integrations, prompt engineering, LangChain workflows, chatbot development, LLM fine-tuning, anomaly detection, and automated model pipelines. My work combines advanced AI architecture with practical systems engineering to deliver secure, scalable, and intelligent solutions.
On the development side, I have deep experience in PHP, JavaScript, Laravel, Blade, MySQL, REST APIs, jQuery, Bootstrap, ArchitectUI, Vue, and responsive UI/UX design. I have built complete internal systems, such as a fully automated Staff Portal, a Timesheet and Job Tracking System, dynamic dashboards, ETL pipelines (SQL → Excel → Portal), and payment workflows integrating Tyro/Mastercard Hosted Checkout and Eway.
I also manage complex infrastructure environments, including GoDaddy VPS, WHM, cPanel, DNS, MultiPHP, Let’s Encrypt, Wordfence, WatchGuard firewall, server logs, cronjobs, and secure SFTP deployments. In the Microsoft ecosystem, I handle Azure AD Connect syncs, ImmutableID conflicts, Microsoft Entra ID management, Exchange Online configuration, and M365 administration across multiple warehouses.
With strong analytical, troubleshooting, and automation skills, I deliver solutions that reduce manual workload and increase operational accuracy. My background includes advanced data processing with Power Query, Excel formulas for award compliance, Google Sheets integrations, PDF generation automation, and dashboard visualisation.
Known for being highly proactive, adaptable, and fast-learning, I thrive in environments where I can combine AI innovation, technical problem solving, and full-stack engineering to build systems that deliver real business impact.
Overview
11
11
years of professional experience
Work History
Systems Analyst / Full Stack Developer /
Exhibit Systems Pty Ltd
Sydney, Australia
03.2024 - Current
- WooCommerce storefront and corporate WordPress site.
- Implemented plugin patching, Wordfence-based firewall rules, performance improvements, and accessibility enhancements.
- Created custom JavaScript-enhanced landing pages (e.g., 25th anniversary) from Figma designs with responsive layout tuning.
Microsoft Ecosystem Administration & IAM Activities
- Managed Entra ID and Azure AD Connect syncing, resolving object conflicts (ImmutableId) and user attribute mismatches.
- Automated email group routing for shared inboxes (e.g., sales@, office2@) and handled user provisioning.
- Actively maintained synchronized access across hybrid environments (local AD ↔ Microsoft cloud).
Incident Response & IT Support Coordination
- Resolved major technical incidents:
File server corruption involving data recovery and failover
WatchGuard firewall outage remediation
Office 365 / Entra ID group sync and SSO policy errors - Documented post-incident RCA reports and implemented long-term fixes with escalation procedures.
Data Engineering & Custom Pipelines
- Built SQL and Excel Power Query ETL pipelines for job/event timesheet data.
- Designed structured MySQL databases for job cost tracking, linked to Xero for accounting automation.
- Created XLSX → MySQL pipelines to auto-feed live dashboards for operations and HR.
Infrastructure, Network Support & Field Tech
- Supported user environments across multiple warehouses: AD policies, printers, server access, VPNs, WatchGuard rules.
- Delivered hands-on support for internal showroom reconfiguration and event preparation.
Documentation, Training & Tech Advisory
- Authored detailed SOPs and staff-facing training materials on internal tools and IT practices.
- Collaborated with directors to evaluate legacy software like inspHire, comparing cost-benefit and ERP feature alignment.
- Recommended and tested modern replacements aligned with staff needs and infrastructure compatibility.
ICT Support Officer
DAEE - Departamento de Águas e Energia Elétrica / SP-Águas
, Brazil
11.2014 - 01.2023
Worked as an ICT Support Officer at DAEE (Department of Water and Electric Energy of the State of São Paulo), where I was responsible for delivering comprehensive technical support and managing local IT infrastructure across multiple internal departments. My role covered a wide range of responsibilities, including:
- Administration of local area networks (LAN) and support for network connectivity issues;
- Hands-on technical support for hardware and software, including system troubleshooting, maintenance, and user training;
- Installation and maintenance of computers, printers, scanners, and other peripherals;
- Logging and resolving helpdesk tickets via the internal IT support platform;
- Basic Windows Server and Active Directory support: user creation, group policies, folder permission controls;
- Support in file server configuration and local backup strategies;
- Participated in IT infrastructure upgrades, system migration projects, and standardization of hardware assets;
- Technical documentation, equipment tracking, and audit reporting.
- Operating Systems: Windows 7, Windows 10, Windows Server 2012
- Networking: TCP/IP, DNS, DHCP, router and switch configuration
- User Management: Active Directory, local domain configuration, shared folders
- Office Tools: Microsoft Office Suite (Word, Excel, Outlook), LibreOffice
- Remote Support Tools: TeamViewer, AnyDesk
- Antivirus & Security: Avast Business, ESET Endpoint Security
- Hardware Maintenance: HDD/SSD replacement, RAM upgrades, network card and GPU swaps
- Printers: Epson and HP LaserJet setup and troubleshooting
- Internal Systems: Public-sector ERP platforms, helpdesk protocols, asset control spreadsheets
Education
ICT50220 - Diploma of Information Technology - Front End & Back End Development
Kent Institute Australia
Sydney01.2024
Bachelor of Computer Science -
Universidade Anhembi Morumbi
Brazil01.2021
Technical Certificate in Information Technology -
SENAC Santana
Brazil01.2016
Cisco Networking Academy - IT Essentials -
01.2015
AI & Machine Learning (Independent Studies) -
Prompt Engineering for Developers -
OpenAI
AI Programming with Python -
Udacity
Practical AI Applications -
FastAI/PapersWithCode
Skills
🔹 Artificial Intelligence & Machine Learning
- OpenAI API integrations
- Prompt engineering
- Prompt design strategies
- LangChain for AI applications
- AI chatbot development
- Machine learning deployment
- Model deployment techniques
- Anomaly detection
- Fine-tuning LLMs
- LLM optimisation processes
- AI-driven chatbot solutions
- Architecture design for AI workflows
- Automation with AI-powered tools
- Data processing for model pipelines
- PHP and JavaScript
- Full-stack development (PHP, JavaScript)
- HTML5 and CSS3
- SQL and Python
- Modern web technologies (HTML5, CSS3, SQL, Python)
- REST API development and integration
- JSON structures and API parsing
- Debugging and performance optimisation
- Responsive UI/UX implementation
- Laravel framework
- Blade templating
- jQuery and Bootstrap
- ArchitectUI design
- Dynamic UI components (jQuery, Bootstrap, ArchitectUI)
- Vuejs fundamentals
- Figma UI/UX layout creation
- Frontend optimisation and component design
- MySQL database management
- MySQL optimisation and administration
- Database schema design (Jobs, Events, Timesheet tables)
- SQL query optimisation
- Data imports (XLSX → MySQL)
- Power Query transformations
- ETL workflows for dashboards
- VS Code
- Postman
- Git version control
- GitHub workflow
- Composer dependency management
- NPM build tools
- Browser developer tools for debugging
- cPanel hosting management
- GoDaddy VPS management
- WHM server administration
- MultiPHP configuration
- DNS zone management
- Let’s Encrypt SSL setup
- Wordfence security
- Firewall configuration (WatchGuard)
- Server log analysis
- Cron jobs and scheduled tasks
- Email server configuration (MX, SPF, DKIM, DMARC)
- FileZilla FTP
- SFTP secure file transfer
- SSH server management
- Remote environment debugging
- SFTP JSON deployment (VS Code)
- Microsoft Graph API
- Google Sheets API
- Tyro/Mastercard Hosted Checkout integration
- Eway payment gateway processing
- Tokenisation & callback flow handling
- End-to-end API integration expertise
- Webhooks and live data sync
- JSON & HTTPS secure communication
- Azure AD Connect sync troubleshooting
- ImmutableID conflict resolution
- Microsoft Entra ID user & group management
- Exchange Online (aliases, shared mailboxes, groups)
- M365 admin centre configurations
- SharePoint/OneDrive access troubleshooting
- AD Local user and group provisioning
- Password policies and identity management
- Windows Server & local domain management
- Local network troubleshooting
- Printer server configuration (Exsys Office)
- Hardware diagnostics & repairs
- Dell Precision troubleshooting (LED codes, power issues)
- VPN & remote access configuration
- Multi-site IT support across warehouses
- Software deployment & updates
- Backup and recovery routines
- Power Query automation (Timesheet & JobList pipelines)
- Excel advanced formulas (dynamic validation, overtime rules 56, 77-100h)
- Google Sheets advanced filters & dynamic dropdowns
- PDF generation automations (html2pdfjs)
- Timesheet logic automation (week ending, OT categories, totals)
- SQL → Excel → Portal pipeline integration
- Dashboard creation using ArchitectUI
- Data transformation and cleansing processes
- Figma wireframes and UI components
- ArchitectUI theming
- Branding and layout structuring
- HTML email templates
- User-friendly UX for staff systems
- Workflow diagrams and process documentation
- Full development lifecycle (planning → execution → deployment)
- Requirements analysis and documentation
- Cross-department communication
- Timesheet and HR workflow digitisation
- Integration between inspHire, Xero and internal tools
- Vendor coordination (hosting, software demos, payment providers)
- Migration planning (systems, servers, workflows)
- WHMCS billing integrations (baseline knowledge)
- AWS fundamentals (S3, EC2, IAM basics)
- SMTP troubleshooting
- Multi-environment deployment (staging/production)
- SSL migration and domain redirection
- Full stack development
Projects
Staff Portal – Full-Stack System Architecture & AI Integration (Laravel + MySQL + Microsoft 365 + OpenAI)
Led the full development lifecycle of a robust Staff Portal, transforming a previously manual, Excel‑based workflow into a fully automated, web‑based system. This included back-end logic, database design, real-time interactivity, and advanced AI integration.
Key Features & Technologies:
- Framework & Stack: Laravel (PHP), MySQL, JavaScript (Awesomplete, html2pdf.js), ArchitectUI, and secure Azure AD integration (Microsoft Entra ID).
- Timesheet System:
Developed a real-time dynamic timesheet with embedded award logic based on Fair Work/EBA (56+ hrs, 77–100 hrs, overtime breaks, rest periods).
Built shift validation rules using conditional logic, including live error feedback when second shift times conflicted with first shift entries.
Allowed mobile-friendly entry, PDF export, and job data autocompletion synced via Google Sheets and XLSX imports. - Job Dashboard:
Created a live dashboard reflecting all scheduled events by job code (e.g., 2504/15‑02), connected to a structured MySQL event database with automatic XLSX → MySQL ingestion.
Provided real-time updates, filter/search functionality, and role-based views for admins and regular staff.
AI-Driven Enhancements:
- Integrated OpenAI’s GPT models to:
Automate leave suggestion prompts based on workload and previous entries.
Identify anomalies or potential errors in shift patterns, such as misaligned breaks or missing end times.
Generate pre-written email requests or HR summaries based on natural language inputs.
Payment Gateway System (Eway + Tyro Mastercard Hosted Checkout):
- Developed a dual-gateway payment architecture with flexible, toggleable logic between Eway and Tyro Hosted Checkout (Mastercard):
Designed and implemented a Laravel session-driven controller system that routes payment flow dynamically based on admin-defined active gateway.
Built secure transaction handling and callback validation logic, storing token responses, error codes, and receipt metadata for auditability.
Implemented fee calculations (Cartage Fee, Damage Waiver, Late Fee, GST) based on job type, order date, and portal rules.
Ensured PCI compliance, with SSL/TLS managed via WHM + Let’s Encrypt across both staging and production environments.
Infrastructure & DevOps:
- Deployed the entire platform under a GoDaddy WHM/cPanel VPS, organizing a multi‑environment setup with:
Separate .env files, domain routing (e.g., staff.exhibitsystems.com.au),
Backup rotation strategies and server monitoring.
Version control and deployment automation via VSCode SFTP for safe updates without downtime.
Languages
- Portuguese, Native
- English, Fluent - PTE Equivalent
Skills
OpenAI API integrations (ChatGPT, GPT-4, embeddings), Prompt engineering for AI-powered automation, Machine learning model deployment (usage of Python-based models for anomaly detection), Applied AI to business process automation within timesheet validations, staff workload prediction, and HR approvals., Development of custom AI-driven chatbot using GPT API to assist internal staff, Exploratory work in fine-tuning LLMs with internal job data (RAG architecture), PHP, JavaScript, HTML5, CSS3, SQL, Python (basic AI/ML usage), Laravel, Blade, jQuery, Bootstrap, ArchitectUI, MySQL, VS Code, Postman, Git, cPanel, Wordfence, FileZilla, SFTP, GoDaddy VPS, WHM, Let's Encrypt SSL, DNS Zone Management, MultiPHP, Microsoft Graph API (Teams/Outlook), Google Sheets API, OpenAI API, Tyro/Mastercard Hosted Checkout, Eway, ChatGPT, GPT-4, LangChain (experimentation), Python Notebooks
References
Available upon request or via: Nelson_Exhibit_Reference_Signed.pdf, Nelson_SPAguas_Reference_Translated.pdf
Timeline
Systems Analyst / Full Stack Developer /
Exhibit Systems Pty Ltd
03.2024 - Current
ICT Support Officer
DAEE - Departamento de Águas e Energia Elétrica / SP-Águas
11.2014 - 01.2023
ICT50220 - Diploma of Information Technology - Front End & Back End Development
Kent Institute Australia
Bachelor of Computer Science -
Universidade Anhembi Morumbi
Technical Certificate in Information Technology -
SENAC Santana
Cisco Networking Academy - IT Essentials -
AI & Machine Learning (Independent Studies) -
Prompt Engineering for Developers -
OpenAI
AI Programming with Python -
Udacity
Practical AI Applications -
FastAI/PapersWithCode