Brian Goncalves Email & Phone Number

New York, New York, United States

• Contributed to the transition from an outdated Postgres data warehouse to a modern ETL stack using dbt, Snowflake, and Fivetran, improving data accessibility and scalability across the organization.
• Designed complex data transformations in dbt using SQL, ensuring accurate processing of over 4 million call, chat, text, and routing interactions annually.
• Streamlined data integration by configuring Snowpipes and Fivetran to automatically ingest raw data from 20+ sources into Snowflake.
• Managed version control with GitHub, overseeing repository organization, creating branches, and resolving conflicts, improving collaboration and code stability.
• Utilized Python in AWS CDK to manage infrastructure and Lambda functions, optimizing cloud architecture for performance and cost-efficiency.
• Utilized Linux for user account management, file organization, and automation of tasks using simple shell scripts to enhance system efficiency (Ubuntu)

New York, New York, United States

• Applied a systematic approach to problem-solving, utilizing knowledge of operating systems, applications, and network protocols.
• Delivered IT support (remote and in-person), resolving hardware and software issues via phone, email, and remote desktop tools for over 900 users.
• Managed and maintained Windows Active Directory infrastructure, including user accounts, groups, and organizational units.
• Managed Office 365 administration, including user account management, Exchange Online, SharePoint, and OneDrive.
• Provided technical support for security applications such as Okta, DUO, Microsoft Authenticator, and Cisco Anyconnect VPN.
• Streamlined IT onboarding for new hires, provisioning hardware, setting up accounts, and providing technology training.

Union, New Jersey, United States

• Provided technical consultations to customers ensuring tailored solutions to meet individual preferences.
• Drove sales success by utilizing technical expertise to engage customers, identify needs, and recommend tailored Geek Squad solutions.
• Conducted diagnostics and troubleshooting of hardware and software issues.
• Communicated complex technical concepts to non-technical audiences.
• Follow strict SOP regarding data privacy and documentation.

Jersey City, New Jersey

• Troubleshot Windows, Mac, and Chromebook devices for teachers, staff, and students, ensuring timely issue resolution.
• Utilized Active Directory to manage staff devices, handling account creation and password resets.
• Assisted with procuring IT hardware for the school by working with vendors.
• Administered the school's network, assisting with configuring, optimizing, and resolving technical issues.
• Utilized Google Admin to oversee student Chromebooks, implementing content filtering to ensure a secure online environment.
• Set up conference rooms with AV equipment and Zoom for remote meetings.

United States

• Diagnosed and resolved software and hardware incidents, including operating systems (Windows and Mac) and across a range of software applications.
• Accurately recorded, updated and documented requests using the IT service desk system.

Bachelor'S Degree, Information Technology

Associate Of Science - As, Computer Science

Python Fundamentals, Data Structures, Algorithms

Html/Css/Javascript

Nucamp Sql And Data Modeling With Python