Jonathan is currently unavailable
Jonathan Camenzind
Verified Expert in Engineering
Software Developer
Dierikon, Switzerland
Toptal member since November 16, 2022
Bio
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
BlackTide Capital Group LC
Process Design, Process Flow Design, Process Flows, Websites, English...
ProLean GmbH
Python, Process Simulation, C#.NET, Data Visualization, Embedded Systems...
Ringier AG
Python, Foundry, Data Lakes, Data Pipelines, Data Visualization...
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
Work Experience
Back-end Developer
2022 - PRESENT
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.
Technologies: Process Design, Process Flow Design, Process Flows, Websites, English, Client-server Model, Server-side, Server-side Programming, Debugging, Runtime Debugging, Web Applications, Data Integration, Data Source Types, Data Integrity Testing, Data Validation, Business to Business (B2B), Business, Business Ideas, Automation, Task Automation, Automation Tools, Automation Software, Software, Browser Automation, Web App Automation, Test Automation, Failover Solutions, Scrapy, Data Scraping, Web Scraping, Architecture, Software Design, Software Design Patterns, Code Architecture, Technical Architecture, Technical Requirements, Software Architecture, Back-end, Back-end Development, Data Cleaning, Data, Functional Programming, DevOps, Startups, Early-stage Startups, Communication, Scraping, Back-end Architecture, Back-end Performance, Algorithms, Data Organization, Consulting, Software Consulting, Technical Leadership, Artificial Intelligence (AI), OpenAI GPT-3 API, OpenAI GPT-4 API, ETL, CTO, Leadership, Scripting, Generative Pre-trained Transformer 3 (GPT-3)
Simulation Developer
2021 - PRESENT
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.
Technologies: Python, Process Simulation, C#.NET, Data Visualization, Embedded Systems, Data Analysis, Windows Presentation Foundation (WPF), Virtualenv, Software Consulting, Desktop App Design, Desktop App Development, Cloud, Licensing, Product Licensing, Licensing Systems, Documentation, UML, UML Diagrams, Technical Documentation, SQL, Databases, Robotics, Robot, Robotic Process Automation (RPA), Visual Studio, Windows, Python 3, Python 2, C#, Software Development, Agile Software Development, Data, Simulations, Process Optimization, Discrete Event Simulations (DES), Visual Components, Process Design, Process Flow Design, Google Cloud, WordPress, Websites, Website CMS, Cloud Security, Cloud Services, Data Protection, English, Debugging, Runtime Debugging, Debugging Tools, CAD, Modeling, 3D Modeling, Models, FreeCAD, Microsoft Word, Excel 365, Microsoft Excel, Microsoft Office, Office 365, Microsoft PowerPoint, Industry, Industry 4.0, Animation, 3D Animation, Evaluation, Videos, Web Applications, 3D, Web App UI, Web App UX, Web App Design, Web App Deployment, Web App Development, Google Cloud SQL, Google Cloud Functions, Autodesk Fusion 360, AutoHotkey, Microsoft Teams, Agile, Web App Security, Business to Business (B2B), Business, Business Ideas, MySQL, MySQL DBA, MySQL Server, SQL Server Administration, User Interface (UI), Software Testing, Manual QA, Manual Testing, Manual Software Testing, .NET, Testing, Software, Browsers, F12 Developer Tools, Chrome Developer Tools, Software Interfaces, Socket Communication, Batch, Automation, Task Automation, Automation Tools, Automation Software, Remote Support, Product Support, APIs, Front-end, Front-end Design, Front-end Development, Front-end Architecture, TypeScript, Full-stack, Full-stack Development, Architecture, Software Design, Software Design Patterns, Code Architecture, API Gateways, CSS3, HTML5, Cross-browser Testing, Cross-browser Compatibility, Cross-platform, Client-server Model, Server-side, Server-side Programming, Web Security, Web Services, JavaScript, jQuery, CSS, HTML, Web, Web Development, Chrome, Google Chrome, Relational Databases, Relational Database Design, Entity Relationships, ERD, Entity-relationship Diagrams, User Experience (UX), JSON, Technical Requirements, Technical Architecture, Business Analysis, IT Business Analysis, Technical Accounting, Data Cleaning, Data Organization, Third-party Management, Third-party Integration, Functional Programming, Single Sign-on (SSO), Identity, Google Analytics, Web Design, SSL Certificates, Responsive Web Apps, Adaptive Design, Software Architecture, Early-stage Startups, Startups, Windows Desktop Software, Pandas, Microsoft SQL Server, IT Project Management, Project Management, Google Cloud Platform (GCP), Firebase, Communication, Algorithms, HubSpot, HubSpot CRM, Webhooks, Consulting, CRM Systems, Lead Generation, Technical Leadership, Artificial Intelligence (AI), OpenAI GPT-3 API, OpenAI GPT-4 API, ETL, Graphical User Interface (GUI), CTO, Leadership, Scripting, Generative Pre-trained Transformer 3 (GPT-3), Product Management
Data Engineer
2021 - 2022
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.
Technologies: Python, Foundry, Data Lakes, Data Pipelines, Data Visualization, Embedded Systems, Data Engineering, Data, Big Data, Databases, Data Analysis, Data Analytics, SaaS, SaaS Design, Enterprise SaaS, Software as a Service (SaaS), Scrum, Jira, Back-end, Back-end Performance, Back-end Development, Back-end Architecture, Server-side Programming, Server-side, Business Requirements, Cloud, Google Cloud, Remote Work, Remote Desktop, Documentation, UX Documentation, Technical Documentation, SQL, PySpark, Spark, Windows, Python 3, Cloud Services, Software Development, Agile Software Development, Agile, Data Migration, Database Migration, Google Cloud API, Cloud Security, Facebook API, Data Protection, English, Debugging, Debugging Tools, Web Applications, Web App UI, Web App UX, Web App Design, Web App Deployment, Web App Development, Web App Security, Data Integration, Data Source Types, Data Validation, Data Integrity Testing, Business to Business (B2B), Amazon Web Services (AWS), Amazon S3 (AWS S3), User Interface (UI), Software Interfaces, High-availability Systems, Software, APIs, REST, REST APIs, HTTP REST, Front-end, Front-end Design, Front-end Architecture, Front-end Development, Full-stack, Full-stack Development, Architecture, Code Architecture, Software Design, Software Design Patterns, API Gateways, Client-server Model, JavaScript, RESTful Development, Relational Databases, Relational Database Design, ERD, Entity Relationships, Entity-relationship Diagrams, User Experience (UX), JSON, Technical Requirements, Technical Architecture, Business Analysis, IT Business Analysis, Data Cleaning, Data Organization, DevOps, Functional Programming, Single Sign-on (SSO), Identity, Okta, API Integration, Google Analytics, Google BigQuery, Web Design, Software Architecture, Elasticsearch, Google Cloud Platform (GCP), Communication, Algorithms, Webhooks, ETL, Graphical User Interface (GUI), Scripting, Product Management
Simulation and Material Flow Controller Developer
2017 - 2020
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.
Technologies: Python, C#.NET WinForms, Windows Forms (WinForms), Windows Presentation Foundation (WPF), Object-oriented Programming (OOP), OOP Designs, Class-based OOP, Virtual Machines, Virtualenv, Network Programming, UI Development, Desktop App Design, Desktop App Development, Remote Desktop Protocol (RDP), Remote Desktop, Citrix, Client-server Model, Remote Work, Documentation, UX Documentation, Technical Documentation, Server-side Programming, Back-end, Back-end Performance, Back-end Development, Back-end Architecture, SQL, Oracle, Oracle 12c, PL/SQL, PL/SQL Tuning, Oracle PL/SQL, PL/SQL Developer, Oracle DBA, Databases, Data, Robotics, Robot, Robotic Process Automation (RPA), Visual Studio, Windows, Windows Server, Python 3, Python 2, Embedded Systems, Data Analysis, Remote Control, Oracle Database, Oracle Database Architecture, IT Project Management, C#, C#.NET, Software Development, Agile Software Development, Agile, Data Visualization, Simulations, Process Simulation, Process Optimization, Discrete Event Simulations (DES), Visual Components, Process Design, Process Flows, Process Flow Design, VM, VirtualBox, Oracle VM VirtualBox, English, Debugging, Runtime Debugging, Debugging Tools, Microsoft Word, Microsoft Excel, Microsoft Office, Digital Twin, Virtual Commissioning, Industry, Industry 4.0, Animation, 3D Animation, 3D, Evaluation, Videos, Telegram Bots, Telegram Bot API, Telegram Bot Platform, Microsoft Teams, Data Integration, Data Source Types, Data Validation, Data Integrity Testing, SQL Server Administration, Cross-platform Testing, Compatibility Testing, Server-side, User Interface (UI), Software, Software Testing, Testing, Manual QA, Manual Testing, Manual Software Testing, .NET, Software Interfaces, Socket Communication, Windows Services, Batch, Automation, Task Automation, Automation Tools, Automation Software, High-availability Systems, Real-time Data, Real-time Systems, Real-time Computing, Remote Support, Product Support, IT Automation, Desktop Automation, UI Automation, Front-end, Front-end Design, Front-end Architecture, Front-end Development, Full-stack, Full-stack Development, Code Architecture, Architecture, Software Design, Software Design Patterns, Relational Databases, Relational Database Design, ERD, Entity Relationships, Entity-relationship Diagrams, User Experience (UX), Technical Requirements, Technical Architecture, Data Cleaning, Data Organization, Third-party Management, Third-party Integration, DevOps, Functional Programming, Identity, Software Architecture, Windows Desktop Software, Object-relational Mapping (ORM), Project Management, Communication, Algorithms, Technical Leadership, Graphical User Interface (GUI), Scripting, Product Management
QA Engineer
2015 - 2017
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.
Technologies: Embedded Systems, SaaS, SaaS Design, Enterprise SaaS, Software as a Service (SaaS), Scrum, Jira, Subversion (SVN), Web Services, Remote Desktop, Remote Desktop Protocol (RDP), Remote Control, Citrix, Documentation, UML, UML Diagrams, Technical Documentation, Quality Assurance (QA), Software QA, QA Automation, Website QA, Test Documentation, Windows, Windows Server, Server Administration, Server Maintenance, Data, Virtual Machines, VM, VMware, Web Security, English, Microsoft Word, Microsoft Excel, Microsoft Office, Web Applications, Testing, Cross-platform Testing, Compatibility Testing, Manual Testing, Manual Software Testing, Test Management, Cross-browser Testing, Cross-browser Compatibility, Software Testing, Manual QA, Browsers, F12 Developer Tools, Chrome Developer Tools, Windows Services, Cross-platform, Batch, Automation, Task Automation, Automation Tools, Automation Software, Software, Browser Automation, Web App Automation, Test Automation, Failover Solutions, Cisco, Cisco Jabber, Cisco UCCE, Chrome, Google Chrome, SSL Certificates, Microsoft SQL Server, Selenium, CRM Systems
Software Developer
2013 - 2015
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.
Technologies: Embedded Systems, JavaScript, jQuery, CSS, HTML, SaaS, SaaS Design, Enterprise SaaS, Software as a Service (SaaS), Scrum, Jira, Subversion (SVN), Web Services, Object-oriented Programming (OOP), OOP Designs, Class-based OOP, Network Programming, UI Development, Remote Desktop, Remote Desktop Protocol (RDP), Remote Control, Back-end, Back-end Performance, Back-end Development, Back-end Architecture, Documentation, UML, UML Diagrams, Technical Documentation, Visual Studio, Windows, C#, C#.NET, Software Development, Agile Software Development, Agile, Data, Virtual Machines, VM, VMware, Web Security, English, Client-server Model, Server-side, Server-side Programming, Debugging, Debugging Tools, Runtime Debugging, Microsoft Word, Microsoft Excel, Microsoft Office, Web Applications, Web App UX, Web App UI, Web App Design, Web App Development, Web App Deployment, Web App Security, User Interface (UI), .NET, Browsers, F12 Developer Tools, Chrome Developer Tools, Software Interfaces, Socket Communication, Windows Services, Cross-platform, Batch, Automation, Task Automation, Automation Tools, Automation Software, High-availability Systems, Real-time Data, Real-time Systems, Real-time Computing, Software, APIs, REST, REST APIs, HTTP REST, SOAP, Salesforce SOAP API, Salesforce, Salesforce Apex, Salesforce API, Microsoft Dynamics, Dynamics CRM Plugins, Microsoft Dynamics CRM, IT Automation, Desktop Automation, UI Automation, Failover Solutions, Cisco, Cisco Jabber, Cisco UCCE, Front-end, Front-end Design, Front-end Architecture, Front-end Development, CSS3, HTML5, WebSockets, Full-stack, Full-stack Development, Architecture, Code Architecture, Software Design, Software Design Patterns, API Gateways, Web, Web Development, Chrome, Google Chrome, RESTful Development, User Experience (UX), JSON, Technical Requirements, Technical Architecture, Data Cleaning, Data Organization, Third-party Integration, DevOps, Identity, API Integration, Web Design, SSL Certificates, Software Architecture, Microsoft SQL Server, C++, Selenium, Communication, Algorithms, Webhooks, CRM Systems, Graphical User Interface (GUI), Scripting
Software Developer
2011 - 2013
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.
Technologies: JavaScript, jQuery, CSS, HTML, UI Development, Visual Studio, Windows, Software Development, Agile Software Development, Agile, Data, Data Migration, Database Migration, Websites, Website CMS, C, Debugging, Runtime Debugging, Debugging Tools, Microsoft Word, Microsoft Excel, Cross-platform Testing, Cross-browser Testing, Compatibility Testing, Cross-browser Compatibility, Web Services, Back-end, Back-end Development, Back-end Performance, Back-end Architecture, Business Requirements, Documentation, Technical Documentation, UML, UML Diagrams, UX Documentation, Software QA, Website QA, Quality Assurance (QA), Web Security, Microsoft PowerPoint, Web Applications, Web App UI, Web App UX, Web App Design, Web App Deployment, Web App Development, Web App Security, Data Integration, Data Integrity Testing, Data Source Types, Data Validation, User Interface (UI), Testing, Software, Software Testing, Manual QA, Manual Testing, Manual Software Testing, Browsers, F12 Developer Tools, Chrome Developer Tools, Cross-platform, Automation, Task Automation, Automation Tools, Automation Software, IT Automation, Desktop Automation, UI Automation, Front-end, Front-end Design, Front-end Architecture, Front-end Development, CSS3, HTML5, Full-stack, Full-stack Development, Architecture, Code Architecture, Software Design, Software Design Patterns, Web, Web Development, Chrome, Google Chrome, Relational Databases, Relational Database Design, ERD, Entity Relationships, Entity-relationship Diagrams, User Experience (UX), Technical Requirements, Technical Architecture, Data Cleaning, Data Organization, Functional Programming, Software Architecture, C++, Communication, Algorithms, Graphical User Interface (GUI), Scripting
Experience
GLogWare | Material Flow Controller
Developed and commissioned GLogWare, a material flow controller orchestrating the flow of products within a production plant.
The 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.
The 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
Developed an automated system for a dropshipping website to keep track of prices and availabilities for relevant AliExpress products.
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.
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
With the portal Bauer sucht Koch, farmers can sell their goods directly to restaurants, giving the farmers more revenue while the restaurants have the freshest food ingredients they can get.
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.
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
Built an employee planning tool based on JavaScript, jQuery, HTML, CSS, and PHP, which was used for over 100 employees and over 200 customers.
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)
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
Developed a web-based calculator using JavaScript, jQuery, CSS, and HTML. The app allowed the customer to enter multiple parameters regarding their machine and field. The app then calculates the optimal configuration for the machine.
Parameters, calculations, and results can all be downloaded as a PDF file.
Parameters, calculations, and results can all be downloaded as a PDF file.
REST API for a Quiz Platform
Developed a REST API for a quiz platform using Python, handling up to 100,000 quizzes. The technologies used were FastAPI, Pydantic, and OAuth2. Logged-in users can participate in quizzes made by others and create, edit, and evaluate their quizzes.
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.
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
Built a licensing server from scratch using Python and MySQL. The server is used to handle the licensing of various company-developed products.
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.
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
Developed an OCR-Service based on Google's Vision API.
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.
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
2011 - 2015
Vocational Diploma in Computer Science
Gewerblich Industrielle Berufsschule Bern - Bern, Switzerland
Certifications
JULY 2022 - JULY 2023
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), .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 (DES), 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, Test 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)
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring