Darren Guzman

Experience

• 

  Dominican College of Blauvelt

  May 2017 - May 2018

  Configured and installed card readers throughout the campusCreated IDs for students and staff Helped incoming freshmen move into the dormsLed groups for incoming freshmen; informed and motivated students to participate in orientation sessions, planned activities, and other eventsAcquainted new students with campus services, activities, building, and meal locations

  • Work Study Student

    Sept 2017 - May 2018

  • Orientation Leader

    May 2017 - Aug 2017
• 

  KPMG US

  May 2018 - Aug 2018

  Partnership Tax Matters Technology Intern

  Developed and reviewed Schedule K-1 models based on Section 965 for over 3,500 past and present KPMG PartnersFormulated and regularly updated Excel workbooks with VBA, Access queries and reports along with SQL in order to generate several partner deliverables for the 2017 State Tax PackageActively engaged in weekly team status meetings to broaden the knowledge base

• 

  Technical Traffic Consultants Corporation

  Oct 2018 - Apr 2019

  Created client reports using Microsoft SQL Server Management StudioAssisted CEO with coordination of the company auditManaged IT Department equipment/task logs and DoneDone ticketing queueMaintained company logs for failed client reportsCommunicated with clients concerning changes needed for future reportsFormulated freight billing reports for clients weeklyModified freight billing applications in accordance with the requirements for auditors Analyzed and modified client reports using Microsoft SQL Management Studio and Excel for transportation billing preauditGenerated carrier remittances for clientsGenerated return reports for auditors and clients regarding transportation billingConfigured and installed PCs, printers and phones on the company network

  • Information Technology Support and Data Analyst

    Dec 2018 - Apr 2019

  • Information Technology Intern

    Oct 2018 - Dec 2018
• 

  NCSA Next College Student Athlete

  May 2019 - Oct 2021

  Application Support Specialist

  Oversaw Zendesk ticketing queue for the Application Support teamMonitored application servers in order to troubleshoot internal application issuesRefined records in the database regarding client, coach and college information using SQL and PostgreSQL via Microsoft SQL Server Management Studio and DBeaverBuilt and maintained Tableau reports and dashboards for managers and executives to provide company trends and analysesWorked alongside the development team to determine bugs and issues within our applications Show less

• 

  Fiserv

  Jan 2022 - now

  Client Technical Support Engineer