|

Software Developer & Systems Administrator

Full-stack developer specializing in enterprise solutions. Bridge software and hardware systems with proven expertise in SAP Business One integration, real-time dashboards, and IoT security systems.

PythonDjangoFastAPIReactNext.jsTypeScriptSAP B1MySQLPostgreSQLWindows ServerIISPowerShellCrystal ReportsOpenCV
Proven
Enterprise Dev
6+
Live Systems
SAP
Integration
BS IT
Graduate
Edrian James Dela Cruz
Valenzuela, PH

Featured Projects

Enterprise applications and systems built with modern technologies

MICS (Management Information Control System) Portal

MICS (Management Information Control System) Portal

5+ branches consolidatedReal-time SAP syncExecutive dashboardsCentralized operations
DjangoPythonSAP Business OneMySQLJavaScript
  • >Built centralized web platform consolidating operations, reporting, and company metrics across 5+ branches
  • >Integrated with SAP Business One database for real-time data synchronization eliminating manual reporting
LPR / NVR Security Dashboard

LPR / NVR Security Dashboard

Real-time alertsVehicle trackingDwell time analysisSecurity optimization
FastAPIReactMySQLOpenCVWebSockets
  • >Designed real-time NVR and License Plate Recognition (LPR) monitoring dashboard with instant WebSocket alerts
  • >Track vehicle entry, exit, and dwell times to optimize site transport logistics and reduce wait times
iSEE Mobile App

iSEE Mobile App

Secure APIReal-time syncIncident trackingCentral database
FastAPIReactMySQLMobile APIsEnvironment Security
  • >Built minimalist, list-based mobile application for turnstile bypass reporting with enterprise-grade security
  • >Implemented environment variable security and API validation preventing unauthorized access
SAP B1 & Crystal Reports
DUMMY DATA

SAP B1 & Crystal Reports

Barcode automationWarehouse efficiencyCustom layoutsScan verification
SAP Business OneCrystal ReportsBarcode IntegrationSQL
  • >Designed customized print layouts in SAP Business One using Crystal Reports for enterprise workflows
  • >Embedded automated barcode generation into Delivery Receipts reducing manual entry errors by 90%
Horilla HRMS Customization & Multi-Site Deployment
DUMMY DATA

Horilla HRMS Customization & Multi-Site Deployment

5 sites deployedData segregationRole-based accessMulti-company
PythonDjangoJavaScriptPostgreSQLRole-Based Access Control
  • >Implemented Horilla HRMS platform with multi-company/site data segregation across 5 branches
  • >Configured role-based access control for HR administrators ensuring data security and compliance
Turnstile Dashboard & Reports

Turnstile Dashboard & Reports

Attendance trackingReal-time monitoringAccess analyticsBiometric integration
DjangoPythonMySQLData VisualizationAccess Control
  • >Built comprehensive dashboard for turnstile operations monitoring with real-time data visualization
  • >Implemented attendance tracking with real-time analytics reducing payroll processing time by 50%
OSTICKET Open Source Management

OSTICKET Open Source Management

Windows ServerIIS deploymentTicket managementSystem administration
PHPMySQLWindows Server 2019IIS
  • >Managed OSTICKET open source ticketing system on Windows Server 2019 for IT support operations
  • >Successfully deployed and configured the platform on IIS with zero downtime migration
ERP2026 - Enterprise Resource Planning System
IN DEVELOPMENT
LIVE

ERP2026 - Enterprise Resource Planning System

16 integrated modules80+ database modelsRBAC securityMonorepo architecture
Next.js 14TypeScriptPostgreSQLPrismaNextAuth.jsTailwind CSSshadcn/uiZodRecharts
  • >Building comprehensive ERP system with 16 integrated modules covering Financial Management, HRM, CRM, Inventory, Manufacturing, and more
  • >Architected monorepo structure with Turborepo for efficient builds and shared packages (UI, auth, types, database)

Work Experience

December 2025 – September 2026

Software Developer

Liberty Paper Inc.

Full-stack development and systems administration for enterprise operations

PythonDjangoFastAPIReactNext.jsTypeScriptPostgreSQLPrismaMySQLSAP Business OneCrystal ReportsOpenCVWebSocketsPHPIISWindows Server 2019T-SQLZKEMKeeper SDKVB.NETPowerShell
  • >Building ERP2026 - comprehensive ERP system with 16 integrated modules using Next.js 14, TypeScript, PostgreSQL, and Prisma
  • >Built MICS (Management Information Control System) Portal for centralized operations and company metrics consolidation
  • >Developed iSEE Mobile App with environment variable security and API validation for turnstile bypass tracking
  • >Implemented Horilla HRMS with multi-site deployment (LPI, B5, LAG, VAL, A1) and role-based access control
  • >Integrated ZKTeco MB160 Plus hardware using ZKEMKeeper SDK, VB.NET, and PowerShell for turnstile facial recognition
  • >Developed complex T-SQL queries across multiple SAP Business One databases for financial reporting
  • >Designed Crystal Reports layouts with conditional suppression and parameter linking for SAP Business One
  • >Created network architecture mapping using Mermaid diagrams for multi-building layouts
  • >Configured server recovery setups for business continuity
  • >Created turnstile dashboard and reporting system for attendance tracking and access control analytics
  • >Managed OSTICKET open source ticketing system on Windows Server 2019
  • >Configured OpenVPN and site-to-site VPN across three branches for unified network connectivity
  • >Maintained IIS web servers, RDP environments, SDK servers, and legacy VB.NET applications
2021 – 2025

Technical Support Intern

Schools Division Office QC (SDO QC)

IT support, hardware maintenance, and Google Workspace administration

Google Admin ConsoleExcel AutomationNetwork Troubleshooting
  • >Provided comprehensive IT support and hardware maintenance across department workstations
  • >Managed user accounts and organizational policies using Google Admin console
  • >Developed automated K-12 health tracking worksheets in Excel for student growth metrics

Technical Skills

Core Competencies

Python85%
Django80%
FastAPI75%
React80%
Next.js80%
TypeScript75%
JavaScript85%
MySQL80%
PostgreSQL75%
Prisma70%
SQL Server75%
SAP Business One75%
Windows Server80%
IIS75%
Git80%
PowerShell75%
Crystal Reports70%
OpenCV65%
NextAuth.js70%
Tailwind CSS80%

Languages & Frameworks

PythonJavaScriptTypeScriptPHPT-SQLVB.NETPowerShellHTML5CSS3DjangoFastAPIReactNext.jsViteNode.jsTailwind CSS

Databases & Platforms

MySQLPostgreSQLPrismaSQL ServerSAP Business One

Systems & Networking

Windows Server 2019Active DirectoryIISSite-to-Site OpenVPNDNSRDPGoogle Workspace Admin

Hardware & IoT

OpenCVZKEMKeeper SDKZKTeco MB160 PlusNVR/LPR CamerasTurnstile Access Controllers

Tools & Enterprise

GitGitHubosTicketHorilla HRMSCrystal ReportsExcel VBANextAuth.jsshadcn/ui

Education

Pamantasan ng Lungsod ng Valenzuela

Bachelor of Science in Information Technology

2021 – 2025

Comprehensive education in software development, database management, network administration, and information systems with focus on practical applications in enterprise environments.

Certifications

The IT Thing called Multimedia

Pamantasan ng Lungsod ng Valenzuela

April 2024

The Impact of AI to the Future of Web Development

Pamantasan ng Lungsod ng Valenzuela

April 2024

Scrum 101: The Introduction

Pamantasan ng Lungsod ng Valenzuela

April 2024

Data Privacy Essentials: A User's Manual

Pamantasan ng Lungsod ng Valenzuela

April 2024

What I Can Do For You

🏢

Enterprise Integration

Integrate your existing systems (SAP Business One, databases, ERPs) with custom web applications for real-time data synchronization and business intelligence.

🔧

Full-Stack Development

Build scalable web applications from backend APIs to frontend interfaces using Python, Django, FastAPI, React, and Next.js with modern best practices.

🔐

IoT & Security Systems

Develop real-time monitoring dashboards for LPR systems, NVR cameras, turnstile access control, and biometric integrations with instant alert systems.

📊

Data & Reporting

Create executive dashboards, custom reports (Crystal Reports), and data visualization tools to help leadership make informed business decisions.

🌐

Network Infrastructure

Configure and maintain Windows Server environments, VPN networks, Active Directory, IIS web servers, and ensure system reliability across multiple sites.

Process Automation

Automate repetitive tasks with PowerShell scripts, Excel VBA, and custom integrations to reduce manual work and improve operational efficiency.

Get In Touch

Send a Message