William Abiko
South Lake Tahoe,CA
Summary
Adept at driving significant system enhancements, I leveraged SQL expertise and project management acumen at Lake Tahoe Community College to streamline data integration processes, enhancing system efficiency. My background in software integration and API integration, coupled with a knack for solving complex problems, positions me as a valuable asset to any tech-driven team.
Overview
31
31
years of professional experience
Work History
Programmer/System Administrator
Lake Tahoe Community College
South Lake Tahoe, CA
02.2018 - Current
- Administration of the college's Student Information System, Ellucian Colleague. Configuration, updates, and resolving user issues.
- Develop processes to integrate data from Colleague with external data sources, and vice versa.
- User account management of Active Directory, including account creation, security, maintenance, and updates. Develop processes to sync with Colleague.
- Administration of the college's Single Sign-On system.
- Administration of the college's email system. Syncing Active Directory accounts with Microsoft 365 Email.
- Administration of services provided by the California Community Colleges Technology Center, including CCCApply, California Virtual Campus/Online Education Initiative, and SuperGlue, eTranscript.
- Administration of the college's SQL Service databases. Utilize queries to provide ad hoc reporting, and maintain the SQL Job Agent to coordinate scheduled tasks.
- Develop processes for various systems utilizing SQL Server Integration Services (SSIS), PowerShell, Power Automate.
Computer Support Specialist
Lake Tahoe Community College
South Lake Tahoe, USA
09.2001 - 02.2010
Information Systems Technician
California Tahoe Conservancy
01.1998 - 01.2001
- Support for the CTC’s PC’s, backup support for the UNIX network
- Installing, configuring and troubleshooting software and hardware
- Created and maintained the Conservancy web site
Programmer/Support Technician
Breeze Reservations
01.1994 - 01.2001
- Provided support and training to clients for the Breeze Reservation System, an outdoor recreation reservation system (originally written for river rafting outfitters)
- Provided custom programming support in Foxpro for clients to assist with data migration, reports, additional features
- Developed solutions for Y2K, duplicate client records and guide scheduling
Education
B.A. - Economics
University of California, Berkeley
Berkeley01.1976
Some College (No Degree) - C, C++, Fortran, Pascal, Assembly, Java, System Analysis, Accounting
Lake Tahoe Community College
South Lake TahoeSkills
- Application debugging
- API integration
- Coding
- Programming documentation
- Business intelligence analysis
- Project management
- Software integration
- XML and JSON handling
- SQL expert
- Integration testing
- System design
- Debugging techniques
Computer Skills
Microsoft SQL Server Database Management, SQL Server Integration Services, PowerShell, HTML, Javascript, Visual Basic, SAML
Timeline
Programmer/System Administrator
Lake Tahoe Community College
02.2018 - Current
Computer Support Specialist
Lake Tahoe Community College
09.2001 - 02.2010
Information Systems Technician
California Tahoe Conservancy
01.1998 - 01.2001
Programmer/Support Technician
Breeze Reservations
01.1994 - 01.2001
B.A. - Economics
University of California, Berkeley
Some College (No Degree) - C, C++, Fortran, Pascal, Assembly, Java, System Analysis, Accounting
Lake Tahoe Community College
Similar Profiles
Alejandro ZamudioAlejandro Zamudio
Office Clerk (Seasonal) at Lake Tahoe Community CollegeOffice Clerk (Seasonal) at Lake Tahoe Community College
Guy PrzytakoskiGuy Przytakoski
Groundskeeper & Custodian at Lake Tahoe Community CollegeGroundskeeper & Custodian at Lake Tahoe Community College
Andrea MulatoAndrea Mulato
IT Office Clerk at Lake Tahoe Community CollegeIT Office Clerk at Lake Tahoe Community College