SELECT efficiency
FROM operations
WHERE automation = true
Available for opportunities

Lourensius Yudha Kristianto

Building Smart Systems That
Improve Daily Business Operations
System Developer · SQL Specialist · Retail Data Analyst
Download CV WhatsApp View Projects ↓
Yudha
IT Operation & Systems Developer
2+Years Exp.
8+Projects
50+Issues
Scroll
// 01 — About

About Me

I'm an IT professional with a deep focus on SQL database systems, operational system development, and retail technology solutions. I don't just write code — I build tools that solve real business problems.

My experience spans from crafting complex SQL queries for business intelligence, to developing full internal web systems, to automating reporting workflows that save hours of manual work every week.

Working inside retail environments has given me a practical understanding of how technology decisions impact day-to-day operations — from store openings to inventory tracking to executive reporting.

SQL Architecture Internal Systems Retail Operations Process Automation Data Analysis Web Development
profile.json
"name": "Lourensius Yudha K."
"role": "IT Specialist"
"focus": [
"System Dev",
"SQL",
"Data Analysis"
]
"status": available
"exp": "2+ years"
// 02 — Skills

Technology & Skills

⌨
Programming
HTML5
CSS3
JavaScript
PHP
🗄
Database
SQL
Oracle Database
PostgreSQL
⚙
Professional
Data Analysis
System Development
Process Automation
Retail System Support
// 03 — Work

Featured Projects

Real systems built for real business impact

Branch Operations System
Retail Ops

Grand Opening — Gorontalo Branch

Led IT system preparation and operational support for new retail branch launch. Coordinated infrastructure, system testing, and ensured zero downtime on opening day.

SQL Oracle DB System Integration
Supported full system readiness for branch launch
Ensured operational stability on opening day
Maintained system uptime throughout event
View Details →
Internal Operations Portal
Web Dev

Internal Operational Website

Full-stack internal web application providing operations teams with real-time access to workflows, inventory data, and reporting dashboards.

PHP JavaScript SQL HTML/CSS
Improved operational workflow efficiency
Reduced manual data processing
View Details →
PGA Request System
System Dev

PGA Request System

Web-based request management system for PGA teams to digitally submit, track, and approve item requests — replacing error-prone manual paperwork.

PHP PostgreSQL JavaScript
Streamlined request submission process
Improved cross-team coordination
View Details →
Sales Monitoring Bot
📊 Daily Sales Report
Revenue: Rp 48.2M ↑12%
Top SKU: Item #A094
Automation

WhatsApp Sales Monitoring Bot

Automated bot system that delivers real-time sales data, inventory alerts, and daily business reports directly to stakeholder WhatsApp groups.

PHP SQL WhatsApp API Automation
Real-time sales monitoring, 24/7
Eliminated manual daily reporting
View Details →
// 04 — History

Work Experience

2022
Present
IT System & Data Specialist
Retail Operations Division
Full-time
  • Advanced SQL data analysis and business intelligence reporting
  • Internal system development and maintenance
  • Operational reporting automation and workflow optimization
  • Automation tool development for monitoring and alerts
  • IT support for retail branch expansion projects
  • System preparation for new store grand openings
SQLPHPOracle DBPostgreSQLJavaScript
2020
2022
Junior Web Developer
IT Department
Full-time
  • Developed and maintained internal web applications
  • Assisted in database schema design and query optimization
  • Participated in testing cycles and technical documentation
HTML/CSSJavaScriptPHPSQL
// 05 — Contact

Let's Connect

Open to full-time opportunities, projects, or just a conversation.

✉
Email
lourensius.yudha@gmail.com
WhatsApp
+62 852-5985-5468
📍
Location
Surabaya - Indonesia
Chat on WhatsApp Send Email
New Message
Let's chat!