Full Stack Developer, Climber, Runner Marek Schir
Skills
Programming Languages
Python
C#
PHP
JS
Frameworks and Libraries
Django
HTMX
VUE
Nuxt3
Flask
Front-End Technologies
HTML
Bootstrap
CSS
Figma
Tailwind
Vuetify
Databases
MSSQL
MySQL
SQLite
Postgres
GraphQL
Other
Windows
AWS
Digital Ocean
Github
Linux
REST
Projects
Customer Quoting Application
2024
Developed a customer-facing quoting application used for collecting customer information and generating quotes with conditional logic. The backend was built using Django and Django Rest Framework with PostgreSQL for data storage. The frontend was created using Nuxt3 and Vuetify.
Skills
Lead Analyzer Reporting Platform
2023
Developed a platform to extract data from XRF Lead Analyzers, parse CSV files, and generate reports. Implemented multi-step data import wizards for validation and processing. Generated reports in Excel and PDF formats, submitted to a NYC government agency. Built with Django, HTML, HTMX, and JavaScript, using PostgreSQL for storage and running on a Windows server.
Skills
Vehicle GPS Alerting System for Field Service Workers
2022
Developed a comprehensive system to track field service workers' locations relative to their assigned jobs, start times, and end times. Integrated Vehicle GPS data via REST API with Field Service Management Software, utilizing Microsoft SQL Server and MySQL for data storage. Implemented a real-time dashboard map hosted with PHP, using JavaScript and Google Maps API for asynchronous location updates. Automated the system with Python scripts and Linux-based cron jobs.
Skills
Visual Lead Inspection Job Tracking System
2021
Developed a mobile web application for scheduling and tracking lead inspection jobs. The system managed job assignments, tracked completion, and calculated bonuses based on job completion. It also identified duplication errors from vendors to ensure correct payments. Integrated with QuickBooks Online via REST API. Hosted on DigitalOcean droplets using a Linux server with Nginx, the application was built with Django, PostgreSQL, Python, and HTMX for asynchronous interactions and HTML.
Skills
Field Service Management API
2021
Developed an API for the field service management application running on Microsoft SQL Server. Utilized Python with Django and Django Rest Framework to expose API endpoints, enabling Vue and React applications to access the server.
Skills
Field Service Management System Extension
2017
Developed an extension to the existing field service management system, integrating various software applications including the current field service management software and FreePBX for phone calls. This extension provided easier access to data, improved speed of access, and generated custom reports. The application was built with Django and Python, utilizing multiple databases (Microsoft SQL, MySQL). It was run on an Apache web server with HTML, HTMX, and JavaScript for the front end.
Skills
Automated User Lookup and Reporting System
2009
Developed a web scraping system to parse emails, look up users on a popular review site, and report findings via email alerts and MySQL database entries. Initially built a real-time dashboard with PHP, MySQL, later transitioned to Python Django. Automated with Python scripts and cron jobs on a remote Linux machine, using the Gmail API for email parsing and alerts. Significantly improved business ratings with timely user information.
Skills