Ken Alarcos~/full-stack-devLet's Work Together
Back to Home
Experience

Professional experience

Building and maintaining systems that operations teams rely on — from spreadsheet automation to full web applications.

  1. IT Assistant Manager (Systems and Web Developer)

    QyuzenCURRENT

    – Present

    I build and maintain the web-based business systems the company runs on — HR, payroll and employee dashboards — including their databases and sign-in.

    • Develop and maintain custom web-based business systems, including HRIS and payroll applications.
    • Manage database setup and user authentication for company applications.
    • Build employee management dashboards with real-time data tracking and reporting.
    • Optimize system performance and maintain data integrity across platforms.

    Focus areas

    • HRIS
    • Payroll
    • Databases
    • Authentication
    • Dashboards

    Technologies used

    • PHP
    • MySQL
    • JavaScript
    • HTML5
    • CSS3

  2. IT Staff

    Synovatic Inc.

    –

    I turned manual spreadsheet work into automated Google Sheets systems for data management, inventory tracking and reporting.

    • Engineered Google Sheets automation solutions for data management and inventory tracking.
    • Developed custom Apps Script functions and automated triggers.
    • Created dynamic reporting dashboards and data synchronization systems.
    • Streamlined manual processes through spreadsheet automation.

    Focus areas

    • Google Sheets
    • Apps Script
    • Triggers
    • Reporting

    Technologies used

    • Google Sheets
    • Google Apps Script
    • Google Sheets API