JUAN JUCA
BROOKLYN
Summary
Dynamic IT professional with over 10 years of experience delivering innovative technology solutions and driving operational efficiency. Proven track record in leveraging technical skills to enhance system performance and support organizational goals. Results-driven management professional with proven ability to lead teams to success. Eager to expand expertise in emerging technologies and contribute to impactful projects that shape the future of IT. Committed to continuous learning and professional growth within a collaborative environment.
Overview
18
18
years of professional experience
Work History
Manager Applications & Database Development
SAFEHORIZON
03.2023 - Current
- Ability to gather project requirements for Application Module Design and offer solutions to project stakeholders.
- Work with our Infrastructure and Application Development Team to assist with tasks that include: SQL Server Migration, OS Upgrades, SQL Server Upgrades, application upgrades, Backup/Restore tasks, etc.
- Install, upgrade, and manage database applications.
- Lead a small team of developers to perform day-to-day tasks, application development projects, and periodic status meetings to go over complex requests, Pending issues, Self-Care planning and more.
- Ensure data integrity, quality and safety, including assigning permissions to users and implementing access controls.
- Establish best practices for database development, design and activities.
Passenger Service Agent – NZ-
HALLMARK AVIATION SERVICES
07.2024 - 11.2025
- Assist passengers with check-in process, including support for passengers with special needs such as unaccompanied minors, and passengers needing wheelchair assistance.
- Handle all aspects of check-in by operating a computerized system.
- Direct passengers through Customs and Immigration.
- Assist ramp agents to ensure wheelchair, strollers and gate-checked bags are made available for loading upon departure and delivery to passengers upon arrival.
- Assist gate in charge with passenger boarding process.
Applications Developer / SQL Developer Manager
SAFEHORIZON
06.2015 - 03.2023
- Knowledge of SQL reporting, business analytics, and intelligence.
- Diagnose and troubleshoot database errors.
- Created Stored Procedures, User Defined functions & Triggers.
- Practical experience in build logical conditions to script actions and producing SQL queries.
- Form and Workflow Design using Client Track Platform.
- Provide training to Program Managers and End Users in using the organization’s client case management system.
- Create a technical solution to meet mandated COVID-19 guidelines using MS Forms/Power Automate.
- Automation: Creating automation for repeating database tasks.
- Database reports: Creating and managing database reports, and visualizations.
- SQL Agent Jobs: Backups, Maintenance Plans, Table updates, SSIS, Alerts, etc.
- Worked with SSIS packages to perform automated tasks which includes Data Transfer, Conversions, DB Data Import, Maintenance procedures in accordance to retention policy.
- Worked with Tableau to develop comprehensive dashboards for Executive Staff and Project stakeholders.
Computer Support Specialist
SAFEHORIZON
06.2010 - 06.2015
- Document all user support calls and emails in the IT helpdesk tracking system.
- Use Active Directory to support user accounts, OUs, security and distribution groups.
- Lead Tech: MS Office 2013 Suite and Office 365 Services Deployment, Scheduling.
- Lead Tech: Windows 7 Deployment/PC Replacement, Imaging, Scheduling.
- Inventory Management of all network/computer equipment using Lansweeper.
- Create and Modify Asset Management Reports using Lansweeper SQL Reporting Tool.
- Work closely with external parties to resolve internet, telephony and software issues.
- Manage and Troubleshoot DVR Camera System onsite and remotely.
- Troubleshoot computer hardware, software and network issues.
- Setup and maintain Audio/Video equipment of Conference Rooms at remote sites.
- Support of Virtualized Systems/Applications such as VMware, Citrix XenApps, VDIs.
- ISP Circuit Activation: IP Cutover, Routing, Porting, SIP, t1, Fiber.
- Upgrade of old Telecom Infrastructure to Cisco IP Telephony Based Systems: CME/CUE.
- Setup/Manage WAAS on all Remote Routers for network optimization.
IT Department/Helpdesk
DEVRY COLLEGE OF NEW YORK
03.2008 - 03.2011
- Use Active Directory to maintain and configure accounts for students, staff, and faculty.
- Managed equipment inventory on all devices and software on required PCs.
- Perform hardware and software rollouts on local school campus.
- Projector setup: audio and video equipment support for classrooms.
- Trained students in computer-system setup and operations.
- Perform regular room inspections of equipment.
- Created Ghost sessions for imaging multiple PCs.
Electronics Maintenance Division/Network Support (Internship)
METROPOLITAN TRANSIT AUTHORITY, MTA/NYCT
02.2010 - 06.2010
- Assist NOS field technical staff in the areas of data communications site infrastructure maintenance.
- Ensure that WAN documentation is complete and accurate.
- Work with NOS in house technical staff during projects that require following detailed connectivity.
- Equipment/rack layout, hardware labeling and upgrades/configure various communication network.
- Assist NOS control center staff on computer based management systems.
PC Technician/Consultant/Contractor
ROBERT HALF TECHNOLOGY
03.2009 - 06.2009
- PC unit and equipment deployment.
- Troubleshoot and repair computer, hardware and software issues.
- Home Network Installation/repair. Ex Routers, DSL Modems, Dialup, etc.
Education
Course Certificate - Administering a SQL Database Infrastructure
New Horizons
New York, NY03-2020
Course Certificate - Cisco Certified Network Associate (CCNA)
Technical Institution OF America (TIA)
New York, NY01-2016
Bachelor’s Degree - Computer Engineering Technology
DEVRY COLLEGE OF NEW YORK
New York, NY06-2011
Associates of Applied Science - Electronics and Computer Technology
DEVRY COLLEGE OF NEW YORK
Long Island City, NY10-2008
Skills
- MS SQL Server 2008, 2012, 2016, 2017, 2019, 2022
- Windows Server 2003/2008/2012/2016/2019
- Windows 7/10/11 Implementation & Support
- MS Apps: Word, Excel, Access, Sharepoint, MS Forms/Power Automate
- System & Database Maintenance
- Report Builder, Visual Studio, SSRS, SSIS
- Active Directory Administration
- Network/System Support: Cisco ISRs, Switches, VLANS, Access lists, EIGRP, OSPF, TCP/IP, DNS, DHCP, Printers, SFTP Data Transfer
- Telecom Support: Avaya Partner, CCME, Unity Express, VOIP
- Customer service
- Time management
- Data analysis
Languages
Spanish
Native or Bilingual
English
Native or Bilingual
Timeline
Passenger Service Agent – NZ-
HALLMARK AVIATION SERVICES
07.2024 - 11.2025
Manager Applications & Database Development
SAFEHORIZON
03.2023 - Current
Applications Developer / SQL Developer Manager
SAFEHORIZON
06.2015 - 03.2023
Computer Support Specialist
SAFEHORIZON
06.2010 - 06.2015
Electronics Maintenance Division/Network Support (Internship)
METROPOLITAN TRANSIT AUTHORITY, MTA/NYCT
02.2010 - 06.2010
PC Technician/Consultant/Contractor
ROBERT HALF TECHNOLOGY
03.2009 - 06.2009
IT Department/Helpdesk
DEVRY COLLEGE OF NEW YORK
03.2008 - 03.2011
Course Certificate - Cisco Certified Network Associate (CCNA)
Technical Institution OF America (TIA)
Bachelor’s Degree - Computer Engineering Technology
DEVRY COLLEGE OF NEW YORK
Associates of Applied Science - Electronics and Computer Technology
DEVRY COLLEGE OF NEW YORK
Course Certificate - Administering a SQL Database Infrastructure
New Horizons