Lars Pietrowski
Web- und Software Developer (Fullstack) / EDI-Schnittstellenentwickler
Erfahrungen
Interface development
Development of a robust interface for querying ERP data from an SQL database and transferring it to a REST API in JSON format. The interface enables seamless integration of customer order data and ensures efficient data communication between the systems. • Technologies: C#, NET, JSON, MS SQL Server, REST.
EDI Interface development
• Development and further development of EDI components in standards such as ANSI X. 12, XML, JSON and EDIFACT. • Further development and troubleshooting of an Excel add-on that was developed for the company by another service provider using .net Framework 4.8 • Technologies: Lobster_data, C#, Salesforce
Fullstack development Single page application
Development of a Single Page Application (SPA) for the dynamic display and management of employee positions from the CargoSoft database. Based on predefined rules, visual signals (texts and colors) are provided to indicate missing information or the need for action. The data automatically updated as soon as new data is available and rules are processed using a Lobster_data profile and stored in the database. Clients are Technologies: C#, NET Core, SignalR, Microsoft SQL Server, Lobster_data.
Interface development
• Development of a dynamic interface for the automated management of Teams structures based on templates. The interface provides multiple endpoints for creating, updating and deleting Teams information using the Microsoft Graph API for seamless integration with Microsoft 365. • Technologies: C#, NET, Microsoft Graph API, Microsoft 365.
Fullstack developer Single page application
Development and optimization of internal systems to support operational processes: • Ticket system: Development of a system for the efficient processing of support requests. • Order and regulation management: Creation of a tool for the management and documentation of • Chemicals management: further development of a system for inventory monitoring and management of chemical substances. work orders and regulations in electroplating. • Component monitoring: Implementation of a system for recording and monitoring components in need of preservation. • Technologies: C#, NET, Blazor, JavaScript, CSS, Microsoft SQL Server.
Fullstack developer Single page applications
As part of an extensive project, I have now developed the fourth version of a single-page application that serves as a cross-platform solution for end users, retailers and manufacturers. The aim of the application to enable user-friendly and efficient error analysis. Special attention was paid to a modern, scalable architecture and intuitive usability. • Technologies: Frontend (Angular, lonic, Next.js / React) and backend (C#, NET, Azure SQL), cloud solutions (Azure Webservice Azure Factory, Azure Frontdoor, Azure Sqldatabase, Vercel-Hosting), Al chatbots (OpenAl, Azure Cognitive Search), data communication (JSON, REST APIs)
Interface development
Development of a tool for processing data from the Microsoft Graph API. The tool extracts shift plan data from Microsoft Teams and generates automated Excel reports for individual employees. The data is compared using an SQLite database and calculated according to the specifications. Technologies: C#, NET Core, SQLite, Microsoft Graph API, ClosedXML.
Fullstack developer Single page application
Development of a Single Page Application (SPA) for the visualization and processing of proposals. proposals are color-coded and displayed on an interactive map to clearly visualize the processing Citizens can submit new proposals, which are then processed by the parliamentary group. The status. All data is stored and managed in an SQL database
annual maintenance
• Technologies: Angular, C#, ASP.Net Core, Leaflet.js, Microsoft Azure, Strato hosting and MS SQL database
Server and client development
• Development of a server and client application to visually display and manage the occupancy of consulting rooms. The server application controls the status of the rooms using an SQLite database and informs the connected clients of changes in real time. The client application allows transmitted to the server. users to view the status of all rooms and update the status of their own room, which is then • Technologies: C#, NET Core, XAML, SQLite, SignalR.
Web design and development
• Development of a modern website for a general practitioner's practice that provides patients with important information and offers a direct link to online appointment booking. The website was designed to be user-friendly and allows intuitive navigation for different user groups. Technologies: Angular, Bootstrap, HTML, CSS
Clickdummy single page application
Development of an interactive click dummy based on the Angular framework to provide an with a modern design and serves to visualize and evaluate concepts. overview and progress review of technologies, use cases and studies. The prototype was created • Technologies: Angular, Bootstrap, Material-Angular
Single page application
Development of a Blazor web application for the efficient management of orders, goods receipts and quality assurance decisions. The application enables the generation of QA reports as PDFs as well as the capture and creation of shipping orders and associated shipping bills in PDF format. All data is stored in a mySQL database to ensure reliable and scalable data management. Technologies: C#, NET Core, MySQL, Blazorise.Material, iTextSharp.
EDI interface development
• Supporting the EDI team in the development and implementation of new interfaces using Lobster Data. Focus on the processing and transformation of data in CSV formats and via REST APls (JSON). In addition, implementation of data access and operations on an MS SQL database. • Technologies: Lobster Data, CSV, JSON, REST-API, MS SQL
EDI interface development
Development of new interface connections for the mware system, with data exchange in the formats VDA4933, VDA4945 and VDA4987. • Technologies: Lobster Data
EDI interface development
Development and implementation of various EDI integration components for standard interfaces in XML and Fixrecord format for connection to the mware system. • Technologies: Lobster Data
Fullstack Developer Single page application
• Takeover and further development of an existing program for recording and managing measurement data, including analysis of the source code, documentation and expansion of the functionalities according to the customer's requirements. • I Development of a new web application (frontend and backend) that accesses the existing database to display data according to customer requirements and to store and manage new data. In addition, an editor was implemented that imports data from OpenStreetMap and, with the help of Leaflet, allows objects from these imports to be displayed, edited and stored interpolated in the database. • Technologies: Microsoft Visual Studio, C#, NET Framework, NET Core, Prism, Unity, Entity Framework, Angular, TypeScript
Software development
• Support in the development of a database with a WPF frontend in C#. Implementation of a print function to prepare and display data from the database in Word documents according to customer specifications.
Technology: Microsoft Visual Studio, Microsoft SQL Server, Microsoft Word
EDI interface development
Design, implementation and continuous further development of EDI integration components to connect the operational forwarding system CargoWise One via web services and to transmit data back to customers via web services. • Technology: Lobster Data, Notepad++, Webservice SOAP 1.2, SoapUl
EDI interface development
• Design, implementation and further development of EDI integration components in the standard interface formats ANSI X.12, XML, CSV and EDIFACT. Ensuring data exchange via communication protocols such as (S)FTP, IMAP/SMTP and SOAP 1.2. Technology: Lobster data, Notepad++, Total Commander, SoapUl, Postman
Front-end development
Takeover of an existing PHP project for further development. • Technology: PHP, HTML, Javascript, jQuery, MSSQL
Front-end development
Takeover of an existing website for error correction and further development.
• Technology: Wordpress, Woocommerce, PHP, HTML, Javascript, jQuery, mySQL
Fullstack development
• Creation of an audit questionnaire (frontend and backend)
• Technology: HTML, PHP, Javascript, jQuery, mySQL
Development and programming
Hanseatische Krankenkasse
Programming and customization of document templates in the G.Docs and winEFW systems from Germo. Analysis of .csv and .xml files, including data from the SAP system "OSCARE", for use in the specified programming templates.
• Technology: C#, VBA, VB, MS Word, MS Visual Studio, Germo G.Docs, winEFW
Software Developer
a. hartrodt (GmbH & Co.) KG
Highlights from my time as an employee in the IT area:
- Carrying out failover tests with detailed documentation of measures for the application ediEnterprise, including the production and backup databases.
- Development of a new form concept for the ediEnterprise software.
- Participation in the introduction and implementation of ITIL processes.
- Planning an interface to UPS for the transmission of dispatch data, including the return of a barcode and provision as a barcode and provision as PDF by e-mail.
- Conducting sprint planning meetings and progress reviews.
- New creation and maintenance of log shipping for 110 databases, with synchronisation from Sydney (AU) to Hamburg (DE).
- Conception and co-design of a central database for data exchange between different between different forwarding systems.
- Planning and implementation of a data migration from an Oracle database to a MySQL database. database.
- Technical support for the introduction of CargoSoft software in Poland, Denmark, Belgium, India, Germany, England and Chile.
- On-site implementation of the ediEnterprise software in Australia (Sydney) with the following focal points:
- System setup and customisation of business processes
- Development of an interface (MS Access, VBA, XML) for the integration of ediEnterprise into the Exact accounting system
- Form development (MS Excel templates) in accordance with corporate identity
- Development of an interface (XML) for the transfer of consignment data from ediEnterprise to the track-and-trace system TTSecure
- Development of an interface (XML) for transferring address data from the CRM system WICE to the new software
- Migration of customs data from the predecessor system Procars using MS Access and VBA into the new system ediEnterprise new ediEnterprise system
- Creation of a catalogue of questions with approx. 250 questions to determine the requirements for a new new haulage software.
o Technology: MSSQL, MSSQL Mirror, MSSQL Log Shipping, SSIS, Lobster Data, .csv, .xml, CargoSoft, CargoWise One (ediEnterprise), MySQL, MS Access, VBA, TT Secure, OTRS, Crystal Reports 2008, MS SharePoint 2003