Johan D.

I help businesses automate repetitive tasks, organize their data, and turn spreadsheets into reliable reporting tools. I’m a Systems Engineer with hands-on experience in data management, inventory operations, and business processes. Much of my work has involved keeping information organized, checking data for inconsistencies, and making sure business records are accurate and useful. I’ve worked with inventory systems and operational data, so I understand that a spreadsheet is more than just a table — people rely on it to make decisions and keep work moving. Here's how I can help: Data Analysis & Reporting - Clean, validate, and consolidate data from multiple sources. - Build Excel reports, KPI trackers, and business dashboards. - Turn raw data into clear, useful information. Excel, Google Sheets & Workflow Automation - Automate repetitive spreadsheet tasks using VBA and Google Apps Script. - Build structured spreadsheets for inventory tracking and operational reporting. - Use Power Query to streamline data preparation and recurring reports. - Improve existing workbooks by simplifying formulas, organizing data, and adding validation. Business Operations & Inventory - Organize inventory and operational data. - Support reporting, data quality checks, and workflow improvements. - Test business applications and review CRM/ERP processes. - Help maintain records and improve day-to-day operational workflows. AI-Assisted Development & Data Extraction - Extract structured data from PDFs and other documents. - Use AI tools to help develop and troubleshoot scripts in VBA and Google Apps Script, then review and test the output. - Build and refine software prototypes using tools like Lovable. - Use AI tools to investigate technical problems and explore practical solutions. I’ve also worked with business systems and CRM/ERP platforms used in automotive operations, including vAuto, RapidRecon, DealerTrack, DriveCentric, VinSolutions, and TrueSpot. That experience has helped me understand how data moves between systems and why keeping records consistent matters. I like to understand the actual problem before jumping into a solution. Sometimes a better spreadsheet structure is enough; other times, a report or a small automation can make a process much easier to manage. I use AI tools when they genuinely help, but I still review the output and check that the solution makes sense for the task. I value clear communication, attention to detail, and solutions that are practical to maintain — not just something that works once. If you're spending too much time updating spreadsheets, dealing with inconsistent data, or preparing reports manually, tell me what you're working with and what you'd like to improve. I'll help you work out a practical way forward. Thank you for taking the time to visit my profile, 𝐉𝐨𝐡𝐚𝐧 𝐃𝐢𝐚𝐳