Upwork home
Sign up
Secondary
Marcel P.
Oakville, Canada

Full-Stack Developer | Data Extraction and Automation Expert

Are you overwhelmed with manual data processing, repetitive tasks, or inefficient systems? I specialize in creating tailored solutions that can save you countless hours and significantly reduce operational costs. Imagine transforming complex, unstructured data into actionable insights with the click of a button, or having a web application that provides the perfectly tailored interface and features for your specific needs. That's what I deliver. Whether you need a robust ETL pipeline, web scraping system, or a full-stack application, I can help your business optimize operations and unlock new opportunities. Full-Stack Tech Stack 💻 Frontend: React.js, Next.js, HTML, CSS 🔧 Backend: Django, Flask 🗄️ Databases: SQL, NoSQL 🚀 DevOps: GitHub Actions, Docker, DigitalOcean, AWS Data Extraction & Automation Tech Stack 🐍 Programming: Python 🔍 Web Scraping: Selenium, BeautifulSoup 🤖 Automation: Python, AWS Lambda 🧠 AI & Machine Learning: OpenAI, ElevenLabs, MidJourney 📊 Data Handling: SQL, Pandas, MySQL Full-Stack Development Track Record ✅ Background Check Software Developer: I built both backend and frontend components of a massive data-extraction system managing complex workflows based on user inputs. This role involved significant full-stack development, utilizing Jinja and Django Templates for the frontend and Django/Flask for the backend, ensuring the system was robust, scalable, and user-friendly. ✅ Airbnb Browser: Enhanced the Airbnb browsing experience with a custom web app built using React.js, Django, and a Selenium Grid. This project involved advanced sorting, filtering, and price tracking, significantly improving user engagement and providing valuable market insights. ✅ Personal Blog and Portfolio: Created a dynamic personal website using Next.js, Django, OpenAI, and Midjourney. The site includes an AI-driven blogging system that generates SEO-enhancing content, demonstrating my ability to combine cutting-edge technologies to build engaging and efficient web applications. This project also highlights my expertise in building scalable and maintainable web solutions. ✅ Meeting Scheduler: Developed a meeting scheduler with React.js and Django, featuring time zone awareness and Google Calendar integration. This project showcased my ability to create user-centric applications that simplify complex scheduling processes, offering clients a smooth and intuitive experience. ✅ Financial Data Python Package: While primarily a data project, the development of this Python package involved full-stack considerations, including automated testing and continuous integration using GitHub Actions. Data Extraction & Automation Track Record ✅ ETL Pipeline for the Healthcare Industry: Implemented an ETL pipeline to extract, transform, and load data on 10,000 physicians into a CRM system. This project reduced manual entry time by 90% and improved data accuracy significantly, showcasing my expertise in automating complex data workflows and integrating them into existing systems. ✅ Web Scraping System for the Background Check Industry: Built a sophisticated web scraping system that handled thousands of websites with dynamic content and non-standard structures. The project utilized Python, Selenium, Django, Flask, SQL, and AI-based OCR techniques to automate data extraction and storage, saving the client hundreds of hours in manual data collection and ensuring high data quality. ✅ Live Data Monitoring: Developed a system to continuously monitor a highly dynamic website, ensuring real-time data integrity and reliability. This solution involved careful error handling, regular data exports, and integration with tools like Google Sheets and Looker Studio, providing the client with timely and accurate insights without manual intervention. ✅ Automated Instagram Account: Launched an automation project that creates and posts Instagram content using ChatGPT, Elevenlabs, and AWS Lambda. This project demonstrates my ability to automate content creation and social media management, allowing clients to maintain an active online presence with minimal effort. ✅ Open Source Financial Data Contributions: Contributed to an open-source financial data project, improving its efficiency and accuracy in data handling. This work showcases my ability to enhance existing systems and contribute to the broader community, offering clients access to high-quality and reliable financial data tools.
Work history
Marcel P. has more jobs. Create an account to review them
Skills

Skills

  • Python
  • SQL
  • Selenium
  • NumPy
  • pandas
  • CI/CD
  • Next.js

Testimonials

Endorsements from past clients

"Marcel is a great developer. He communicates well, meets deadlines, and writes good code. He was able to quickly understand our existing codebase and add the requested features while adding tests and refactoring key parts of the code to make them more efficient and easier to maintain. Marcel was able to work with requirements that were not fully developed. He asked good questions and make invaluable suggestions along the way. "

Alan R.
Apr 2024

Verified

Browse similar freelancers