Jonathan Camenzind
Verified Expert in Engineering
Software Developer
Dierikon, Switzerland
Toptal member since November 16, 2022
Jonathan is a software developer with over 10 years of experience in development and a passion for Python. He's collaborated with leading global corporations, including Google and Bridgestone, whether developing high-available contact center solutions or material flow systems for large-scale production plants—handling up to 100,000 products at a time. Keen on automation and optimization, Jonathan is willing to embrace new challenges and bring his clients' projects to the next level.
Portfolio
Experience
- Back-end Development - 11 years
- SQL - 7 years
- Python - 7 years
- C# - 6 years
- Process Simulation - 6 years
- PL/SQL - 3 years
- MySQL - 3 years
- Data Engineering - 2 years
Availability
Preferred Environment
Python, C#.NET, SQL, Data Engineering, Back-end
The most amazing...
...thing I've developed is a modular 3D simulation used to calculate the specific throughput of wooden elements in an automated production.
Work Experience
Back-end Developer
BlackTide Capital Group LC
- Discussed business requirements with the customer and mentored on web scraping development.
- Developed a web scraper using Python to get content from company websites. After being processed by an AI, the content was used to generate personalized emails for customer acquisition.
- Analyzed web scraping performance and showed the potential and improvements to the customer using charts. Identified the source of data inconsistencies and discussed solutions with the team.
Simulation Developer
ProLean GmbH
- Determined the most efficient production layout for clients using the power of process simulations. These Python-based 3D simulations have a high level of detail within them. Some of them involved assembly lines of well-known European vehicle brands.
- Found the fastest way to manufacture batches of products using an AI-driven scheduler written in Python. The system supports up to 5,000 different product types and multiple work centers with a varying number of machines.
- Trained and supported customers using Visual Components software to develop 3D manufacturing simulations. One of the customers is a well-known Swiss defense manufacturer.
- Constructed the company's website based on WordPress. The site's modern design includes an interactive 3D viewer, allowing visitors to experience simulations hands-on. Prolean.ch has, since its launch, over 10,000 views.
- Built a solution that builds 3D production simulations using Python. Data is fed in through an Excel file. The solution can handle thousands of products, machines, and workers. It is mainly used to calculate the performance of large-scale job shops.
- Developed add-ons for the simulation software, Visual Components, using C#.NET and WPF. One of them is an interactive Python console with complete debugging capabilities at simulation runtime, dramatically improving development efficiency.
Data Engineer
Ringier AG
- Revised existing data pipelines using PySpark to ensure maximum data freshness and minimal issues. The pipelines handled over 100 terabytes of data for a leading Swiss media company.
- Connected new data sources from AWS, GCP, and social media networks like Facebook and Instagram. Sources were fetched with intervals as short as 10 minutes to ensure maximum data freshness.
- Created interactive dashboards for stakeholders to consume. These dashboards were continuously fed with the most recent data. The stakeholders ranged from team leaders to executives, enabling them to make decisions based on a solid foundation.
- Developed custom apps using JavaScript, allowing stakeholders to interact with the data and set goals and thresholds for important KPIs. Discussed requirements regularly to ensure the apps met their expectations.
Simulation and Material Flow Controller Developer
Güdel AG
- Developed a material flow controller using C#.NET and PL/SQL. The server side handles the flow of up to 100,000 products while communicating with robots and conveyors. Leading tire manufacturers use this software.
- Commissioned the material flow controller on customer sites in different countries and collaborated with their IT departments and Güdel's HQ in Switzerland.
- Developed 3D simulations for upcoming projects using Python and Visual Components, a simulation software. Simulations were used to analyze complex processes in multimillion-dollar projects like warehouses or dynamic production lines.
QA Engineer
Bucher + Suter AG
- Maintained and observed automated tests in Atlassian Bamboo. The tests often included automated handling of multiple server components, browsers, and phones to simulate calls being made to a contact center—ensuring a flawless solution.
- Planned, executed, and documented manual tests in Spira. Each software had hundreds of test cases to ensure a flawless solution for the high demand of global corporations.
- Commissioned and maintained lab environments for QA purposes. These labs contained service routing calls and other information. Every service was developed to be redundant to support the high-availability expectations of global corporations.
Software Developer
Bucher + Suter AG
- Developed real-time web apps for Salesforce, SAP, and other CRMs using JavaScript. These gadgets allow contact centers with up to hundreds of agents to communicate with customers via phones, chat, or email and look up customer-related information.
- Created back-end services using C#, handling the communication between web apps and call queues. All services were built to support high availability. If any service fails to respond, a redundant one takes over within a matter of seconds.
- Documented web app behavior and use cases in word documents and UML diagrams. Other employees and customers, including global corporations, consumed these documents.
Software Developer
Noser Young Professionals AG
- Developed websites based on CMS, Joomla, TYPO3, and Drupal. One of the largest customers is a well-known Swiss political party with more than 1,000 individual website instances for most of Switzerland's municipalities.
- Migrated over 1,000 Joomla-based website instances to a new major version for a well-known Swiss political party. The procedure was automated using content migration software. The individual steps were programmed using Java.
- Designed the architecture and layout for a web portal used by young enterprises—enabling them to network. Possible variants were evaluated in tight collaboration with the customer. The final portal was running on a TYPO3 CMS instance.
Experience
GLogWare | Material Flow Controller
https://vimeo.com/295150144The solution can handle up to 100,000 products simultaneously while giving orders to conveyors and robots. The logic was developed using C#.NET and PL/SQL and comprised multiple Windows services communicating with each other. Staff can observe and interact with the system using a rich client-side application based on WinForms.
I developed this whole solution together with my teammate. The requirements differed for each plant, meaning parts of the application were project-specific. For a leading tire manufacturer, I took the lead in developing and commissioning the solution for a plant in Thailand. The commissioning onsite was done in close collaboration with the customer's IT department and the plant's staff.
The solution enabled them to efficiently manage the handling of over 250 different kinds of tires.
Automated AliExpress Product Price and Availability Tracking
The system kept track of every individual price and availability for each combination of product options, e.g., a USB cable might have different lengths and color options, each with individual availability and prices.
The final product consists of the following:
• A regularly executed Python script implementing the Scrapy framework to fetch all the necessary information from all products being tracked.
• A MySQL server to store the current and historical prices and track product availabilities.
• A JavaScript scriptlet for admins to easily add new AliExpress products to the tracking pool.
The product was running as a service on a Linux server, and the whole package was deployed on a LAMP server using Docker.
Bauer sucht Koch | Portal to Connect Farmers and Restaurants
The website was programmed using the Laravel framework, featured user registration and login, and the possibility to shop for ingredients or sell them. Farmers can also dynamically add new products or remove them from the shop.
Employee Planning Tool
FEATURES
• Login mask
• Manageable customers
• Manageable employees
• Ability to plan customer projects
• PDF generation (containing information about spent customer/employee hours on a weekly, monthly, or yearly level)
Tiller Configuration Calculator
Parameters, calculations, and results can all be downloaded as a PDF file.
REST API for a Quiz Platform
API FEATURES
• Registration/log in using an email and password.
• User login state is verified using OAuth 2.0 with a JWT Web Token.
• Every user can create up to 10 quizzes and add, edit, or delete questions and their possible answers.
• Users can publish their quizzes and make them available for other users to be filled out. After publication, they can't be edited anymore, only deleted.
• Other users can search for quizzes in a list of available quizzes.
• Queries would return a high number of rows and have pagination enabled to ensure the system's performance. A start offset and the number of returned rows must be specified for each request.
• Deleted quizzes are only flagged as deleted to enable recovery.
• Quiz owners can calculate the average correctness of all submissions.
The framework can easily be tested using Uvicorn and Swagger UI, which is built into FastAPI by a default API.
Licensing Server
It was deployed on Google Cloud and made accessible through Google Cloud Functions using Google's SSO. The framework used to access the MySQL server was SQLAlchemy.
A lot of effort went into security, ensuring all connections are encrypted using state-of-the-art technologies and encrypting the data stored on the MySQL server.
OCR Service to Recognize Current Prices at Gas Stations
The service takes pictures uploaded by the community to recognize current gas prices at gas stations. The service was made for an app that guides users to the closest and cheapest gas stations. In order for the gas prices to stay up-to-date, the community can upload pictures of the gas prices and earn points.
The OCR-Service had a recognition rate above 95%, which is quite high considering the wide variety of ways how gas prices are displayed.
If the prices are not recognized by the OCR-Service, users can enter them manually.
Education
Vocational Diploma in Computer Science
Gewerblich Industrielle Berufsschule Bern - Bern, Switzerland
Certifications
Foundry Certification Exam for Data Engineers 2022
Palantir Technologies
Skills
Libraries/APIs
PySpark, jQuery, Windows Forms (WinForms), REST APIs, jsPDF, Facebook API, Telegram Bot API, Google Cloud API, Salesforce SOAP API, Salesforce API, SQLAlchemy, Pandas, Google Maps API
Tools
Jira, C#.NET WinForms, Virtualenv, Visual Studio, Microsoft Word, Microsoft Excel, Microsoft Teams, F12 Developer Tools, Chrome Developer Tools, Subversion (SVN), VMware, VirtualBox, CAD, Microsoft PowerPoint, Autodesk Fusion 360, FreeCAD, AutoHotkey, PhpMyAdmin, Microsoft Dynamics, Microsoft Dynamics CRM, Cisco Jabber, Cisco UCCE, Git, GitHub, Bitbucket, TFS, Microsoft Team Foundation Server, Google Analytics
Languages
Python, Python 3, Python 2, C#.NET, SQL, JavaScript, CSS, HTML, UML, C#, CSS3, HTML5, Java, PHP, C, C++, Visual Basic, Visual Basic .NET (VB.NET), Batch, TypeScript
Paradigms
Object-oriented Programming (OOP), Class-based OOP, Agile Software Development, Agile, Automation, Scrum, Desktop App Development, Server-side Programming, Back-end Architecture, Testing, Manual Testing, Real-time Systems, Software Testing, REST, Entity-relationship Diagrams, DevOps, Functional Programming, Object-relational Mapping (ORM), ETL, Oracle Database Architecture, Web App Design, Cross-platform, Test Automation, RESTful Development
Platforms
Software Design Patterns, Windows, Web, Google Chrome, Google Cloud Platform (GCP), Windows Server, WordPress, Citrix, Oracle, Oracle Database, Telegram Bot Platform, Amazon Web Services (AWS), Salesforce, Docker, Linux, LAMP, XAMPP, Raspberry Pi, Firebase, HubSpot
Frameworks
Spark, Windows Presentation Foundation (WPF), Realtime, .NET, Scrapy, Chrome, Robot, Laravel, Bootstrap, OAuth 2, Swagger, Selenium
Storage
Databases, Data Lakes, Data Pipelines, PL/SQL, Google Cloud, Oracle PL/SQL, PL/SQL Developer, Database Migration, Data Integration, Data Source Types, Data Validation, MySQL, MySQL Server, Relational Databases, JSON, Oracle 12c, Oracle DBA, Google Cloud SQL, Amazon S3 (AWS S3), LAMP Server, Elasticsearch, Microsoft SQL Server
Industry Expertise
Project Management, Web Design
Other
Software Development, Simulations, OOP Designs, Back-end, Back-end Development, Process Optimization, Discrete Event Simulations, Debugging, Runtime Debugging, Visual Components, Process Simulation, Task Automation, Automation Tools, Automation Software, Software, Full-stack, Full-stack Development, Data Scraping, Web Scraping, Architecture, Software Design, Code Architecture, Technical Requirements, Technical Architecture, Data Cleaning, Data Organization, Software Architecture, Scripting, IT Project Management, Foundry, Data Visualization, Data Engineering, Embedded Systems, Data Analytics, Data Analysis, SaaS, Websites, Web Services, Big Data, English, Virtual Machines, Network Programming, Software Consulting, UI Development, Business Requirements, Cloud, Remote Work, Technical Documentation, UML Diagrams, Desktop App Design, Remote Desktop, Remote Desktop Protocol (RDP), Documentation, Client-server Model, Back-end Performance, PL/SQL Tuning, Data, Robotic Process Automation (RPA), SaaS Design, Software as a Service (SaaS), Enterprise SaaS, Server-side, Process Design, Software QA, QA Automation, Website QA, Compatibility Testing, Cross-platform Testing, Data Migration, Manual Software Testing, VM, Debugging Tools, Excel 365, Microsoft Office, Digital Twin, Virtual Commissioning, Industry, Industry 4.0, Animation, 3D Animation, Evaluation, Office 365, Process Flow Design, Cloud Services, 3D, Remote Control, Process Flows, Data Integrity Testing, Business to Business (B2B), MySQL DBA, SQL Server Administration, Browsers, Software Interfaces, Socket Communication, User Interface (UI), Windows Services, UI Automation, IT Automation, Desktop Automation, High-availability Systems, Failover Solutions, Real-time Data, Real-time Computing, Remote Support, Product Support, Front-end, Front-end Design, Front-end Architecture, Front-end Development, APIs, HTTP REST, Manual QA, Scraping, Store Scraping, API Gateways, Web Development, Relational Database Design, Entity Relationships, ERD, User Experience (UX), Third-party Integration, Identity, API Integration, Startups, Early-stage Startups, Windows Desktop Software, Communication, Algorithms, Webhooks, Consulting, OpenAI GPT-3 API, OpenAI GPT-4 API, Graphical User Interface (GUI), CTO, Leadership, Generative Pre-trained Transformer 3 (GPT-3), Product Management, Server Administration, Quality Assurance (QA), Server Maintenance, Website CMS, Web Security, Cloud Security, Data Protection, Licensing, Product Licensing, Licensing Systems, UX Documentation, Robotics, Test Documentation, Cross-browser Testing, Oracle VM VirtualBox, Modeling, 3D Modeling, Videos, Telegram Bots, Web Applications, Web App UX, Web App UI, Web App Development, Web App Deployment, Google Cloud Functions, Models, Web App Security, Business, Business Ideas, QA Test Plan Management, Cross-browser Compatibility, Browser Automation, Web App Automation, SOAP, Salesforce Apex, Dynamics CRM Plugins, Cisco, WebSockets, XAMPP Stack, SMTP, Business Analysis, IT Business Analysis, Technical Accounting, OAuth, FastAPI, Third-party Management, Single Sign-on (SSO), Okta, Google BigQuery, Responsive Web Apps, SSL Certificates, Adaptive Design, HubSpot CRM, CRM Systems, Lead Generation, Technical Leadership, Artificial Intelligence (AI), Optical Character Recognition (OCR), Computer Vision, Natural Language Processing (NLP)
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring