# Allan Boi Bias Punzalan — Curriculum Vitae

## Summary

Full-stack developer and automation engineer with ~10 years of professional experience across Python web scraping, Django/Flask backends, React frontends, and AI-driven workflow automation. Comfortable owning a pipeline end-to-end: scraping the source, modeling the data, exposing an API, and shipping the UI. Currently focused on OpenAI-assisted automation and data engineering work delivered through Upwork engagements.

## Skills

- **Languages:** Python, JavaScript / TypeScript, SQL, PHP
- **Web scraping:** Beautiful Soup, Scrapy, Selenium, Requests, proxy rotation, anti-captcha, rate-limit handling
- **Data engineering:** Pandas, NumPy, ETL pipelines, CSV/JSON pipelines, MS SQL, PostgreSQL, MySQL
- **Backend:** Django, Flask, REST API design, Celery + Redis background jobs
- **Frontend:** React, Next.js, Tailwind CSS, framer-motion
- **AI / Automation:** OpenAI API, prompt-driven document analysis, n8n workflow automation
- **Cloud / Infra:** Google Cloud Storage, Google Drive API, Ubuntu Server, Docker, GitHub Actions, Vercel
- **Low-code / Other:** OutSystems, ArcMap (GIS), Tkinter desktop GUIs

## Experience

### Python Developer — Shooju Global (May 2024 – May 2026, remote)

Specialized in web scraping and data extraction for a data-analytics platform. Built robust Python scrapers using Beautiful Soup, Scrapy, and Selenium against both static and dynamic sites. Owned the full pipeline from extraction through cleaning, structuring, and exporting to CSV / database. Routinely handled scraping challenges including proxy rotation, CAPTCHA bypassing, and rate limiting.

### Data Scraper / Full Stack Developer — Freelance via Upwork (ongoing)

Independent engagements covering legal, financial, and automotive datasets, plus full-stack web applications. Notable work:

- **Legal scraper:** Selenium pipeline that extracts case PDFs and uploads them to Google Cloud Storage, where they feed OpenAI-driven document analysis.
- **BarChart.com automation:** Daily stock-market scraping into CSV, scheduled via Windows Scheduler.
- **VIN recall scraper:** Parses VIN-specific recall data from automotive sites.
- **Shopee scraper (POC):** Selenium-based product-listing extraction into MySQL.
- **Recall Campaign Site (Flask):** Web app with Celery + Redis background scraping, anti-captcha solving, CSV export, and an admin dashboard.
- **Loan Management System:** Full-stack React + Django + PostgreSQL platform deployed on Ubuntu.
- **Zdigitech Engineers LMS:** Multi-role learning platform connecting students, parents, and instructors.
- **CI/CD pipeline:** Docker + GitHub Actions deployment workflow set up for a client.
- **Till Payments integration:** PayPal + credit-card module wired into a Flask app.

### Developer — SM Supermalls (June 2023 – May 2024)

Debugged and built internal enterprise applications on the OutSystems low-code platform. Collaborated cross-functionally to deliver new features and maintain existing systems on tight release cycles.

### Computer Services Programmer A — National Electrification Administration (May 2021 – May 2023)

Built internal tools and proof-of-concept systems supporting NEA's digital transformation. Key projects:

- **Electronic Budget Utilization System (POC):** Django + MS SQL prototype to digitize the manual budget tracking and approval process.
- **Training / Learning Management System:** Django-based platform for managing training schedules and quizzes for electric cooperatives.
- **Raffle App:** Python desktop GUI backed by MS SQL for automated raffle draws at NEA events.

### Information Systems Analyst I — PAGASA (July 2018 – April 2021, hybrid)

Led development of the PAGASA Data Monitoring Tool for real-time weather data visualization, plus the wind profile application for tropical cyclone analysis. Automated CSV generation and FTP transfers in Python, integrated external API data into social-media weather updates, and built the ICT Management System (Django + PostgreSQL) for tracking IT assets and incidents. Assisted with ArcMap GIS data integration and general website maintenance.

### Science Research Specialist I — PAGASA (June 2017 – May 2018)

Co-developed the wind profile application — a Tkinter + ArcMap desktop tool that processed tropical cyclone bulletins, estimated typhoon damage per household, and visualized impact predictions. Automated CSV generation and FTP transfers and supported GIS-related work.

### Technical Support Representative — Teletech (November 2015 – November 2016)

Provided front-line technical support for Verizon customers — internet, cable, and phone troubleshooting and device configuration — while maintaining high CSAT.

## Selected Projects

- **PAGASA Wind Profile App** — Python + Tkinter + ArcMap tool for typhoon impact estimation.
- **PAGASA Daily Weather Automation** — Auto-posted weather updates to the official Facebook page at 4 AM / 4 PM via API + FTP.
- **NEA Electronic Budget Utilization System** — Django/MS SQL POC replacing a manual budget workflow.
- **Recall Campaign Site** — Flask + Celery + Redis scraping app with anti-captcha and admin dashboard.
- **Zdigitech LMS** — React + Django + PostgreSQL learning platform.

## Education

- **Master in Information Technology** — Philippine Christian University, Manila
- **B.S. in Information Technology** — AMA Computer College, Fairview

## Contact

- Email: allanboiebiaspunzalan@gmail.com
- LinkedIn: https://www.linkedin.com/in/allan-boi-punzalan-083654158/
- Upwork: https://www.upwork.com/freelancers/allanp12
- WhatsApp: +63 976 030 4099