DERI PERNANDI

Full-stack Developer | Apps Script Developer | Excel Developer | VBA Programming | AI Automation

Bandar Lampung, Indonesia

deripernandi99@gmail.com GitHub Dashboard +62 823 7595 8716 LinkedIn Profile

Ringkasan Profesional

Seorang pendidik profesional dengan ketertarikan mendalam dan keahlian teruji di dunia teknologi informasi. Memiliki spesialisasi dalam Excel Development, pemrograman VBA, dan Google Apps Script Automation, serta sedang aktif mendalami pengembangan web modern berbasis Full-stack Python (Flask & SQLite). Terbiasa memecahkan masalah logika bisnis yang kompleks dan menerjemahkannya ke dalam program automasi yang andal, transparan, dan efisien. Memiliki kemampuan komunikasi, edukasi, dan manajemen proyek yang kuat berkat latar belakang sebagai pengajar profesional.

Keahlian Teknis

Bahasa Pemrograman:

Python JavaScript VBA SQL Apps Script

Web & Database:

Flask Tailwind CSS SQLite HTML5 / CSS3

Automasi & Tools:

MS Excel Advanced Macros REST API Git / GitHub

Pendidikan

Universitas Islam Negeri Raden Intan Lampung

Sarjana Pendidikan Agama Islam (S.Pd.)

Studi Mandiri (Autodidact)

Full-stack Web Development

Database Relasional, Otomasi Cloud & Pemrograman VBA

Pengalaman Kerja

Guru Profesional

Aktif — Sekarang

Sekolah Swasta, Bandar Lampung

Mendidik dan memandu siswa dengan metode pembelajaran interaktif yang meningkatkan pemahaman logika dasar.
Mengembangkan keterampilan komunikasi verbal, presentasi, dan pengelolaan kelompok untuk kolaborasi teknis.
Mengotomatisasi rekapitulasi penilaian kelas menggunakan fungsi makro Excel untuk menghemat waktu administrasi harian.

Freelance Automation Specialist

Project-Based — Sekarang

Remote / Project-Based

Merancang, membangun, dan memelihara sistem automasi bisnis skala kecil hingga menengah untuk meningkatkan efisiensi operasional klien hingga 40%.
Menerjemahkan kebutuhan bisnis klien ke dalam arsitektur database relasional (SQLite) dan program asinkron berbasis web.

Portal Proyek Unggulan

1. SPMB Perintis

Python, Flask, SQLite, Tailwind

Sistem Penerimaan Murid Baru dengan integrasi 2FA keamanan tinggi menggunakan algoritma TOTP via Google Authenticator.

2. Tabungan & Audit

Google Apps Script, HTML, JS

Platform otomasi pembukuan tabungan siswa SDN 2 Cijemit terintegrasi real-time cloud spreadsheet.

3. Payroll Terpadu

MS Excel, VBA Macro

Aplikasi desktop untuk mengelola penggajian karyawan, formula logika rumit, dan cetak slip instan otomatis.

DERI PERNANDI

Full-stack Python Developer | VBA & Automation Specialist

Bandar Lampung, Indonesia

deripernandi99@gmail.com GitHub Dashboard +62 823 7595 8716 LinkedIn Profile

Professional Summary

A professional educator with a deep interest and proven expertise in information technology. Specializes in Excel Development, VBA programming, and Google Apps Script Automation, and is actively developing modern web applications based on Full-stack Python (Flask & SQLite). Experienced in solving complex business logic problems and translating them into reliable, transparent, and efficient automation programs. Possesses strong communication, education, and project management skills derived from a professional teaching background.

Technical Skills

Programming Languages:

Python JavaScript VBA SQL Apps Script

Web & Database:

Flask Tailwind CSS SQLite HTML5 / CSS3

Automation & Tools:

MS Excel Advanced Macros REST API Git / GitHub

Education

State Islamic University of Raden Intan Lampung

Bachelor of Islamic Education (S.Pd.)

Self-Directed Study (Autodidact)

Full-stack Web Development

Relational Database, Cloud Automation & VBA Programming

Work Experience

Professional Teacher

Active — Present

Private School, Bandar Lampung

Educating and guiding students with interactive learning methods that enhance foundational logic understanding.
Developed strong verbal communication, presentation, and group management skills useful for technical team collaboration.
Automated classroom grade calculations using Excel macros to save daily administrative time.

Freelance Automation Specialist

Project-Based — Present

Remote / Project-Based

Designing, building, and maintaining business automation systems for small to medium scale enterprises to improve operational efficiency by up to 40%.
Translating client business needs into relational database architectures (SQLite) and web-based asynchronous programs.

Featured Portfolio Projects

1. SPMB Perintis

Python, Flask, SQLite, Tailwind

New Student Admission System with integrated high-security 2FA using TOTP via Google Authenticator.

2. Tabungan & Audit

Google Apps Script, HTML, JS

SDN 2 Cijemit student savings bookkeeping and audit platform integrated with real-time cloud spreadsheet.

3. Payroll Terpadu

MS Excel, VBA Macro

Desktop application to manage employee payroll, complex logical formulas, and instant automatic payslip printing.