Summary
Overview
Work History
Education
Skills
Certification
Projects
Volunteer Experience
Professional Interests
Competitions
Websites
Timeline
Generic

Jaskaran Sawhney

Levittown,USA

Summary

Results-driven Systems Engineer with expertise in SQL, Python, and data visualization. Proven track record of improving operational efficiency and database management through innovative solutions. Skilled in data cleansing, transformation, and integration across systems, including data mapping, index key creation, and table optimization. Experienced in using SQL and Excel for data cleanup and preparation prior to system imports.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Systems Engineer

Garan Inc.
New York, NY
06.2024 - Current
  • Contributed to the company-wide implementation of Oracle Planning Solution, improving data management and streamlining operations across departments.
  • Led the development of Power BI dashboards for tracking weekly sales and generating insights for the Fall 24 and Spring 25 retail seasons.
  • Managed UPC and Style Number creation for major customers (Fred Meyer, Burlington, Ross, Target, Walmart, and Direct to Consumer), ensuring consistency across systems.
  • Reduced garment SKU and UPC creation timeline from 3-4 weeks to 1-2 days, significantly improving operational efficiency.
  • Authored comprehensive technical manuals to ensure consistent system application across the company.

Senior Design

ParkingSystems.com
New York, NY
09.2023 - 03.2024
  • Engineered an application that autonomously generates employee schedules, enhancing operational efficiency.
  • Managed password protocols, implemented access control measures, and ensured security for sensitive data.
  • Utilized JavaScript, Python, Node.js, and AWS for hosting, ensuring a scalable application.

Project Manager (Co-Op Program)

ASR International Corporation
Hauppauge, NY
10.2022 - 09.2023
  • Contributed to managing eight federal engineering projects with budgets ranging from $500K to $5M, gaining experience in project oversight, resource allocation, and budget management.
  • Collaborated with various teams to streamline operations and assist with project delivery timelines.
  • Developed strong problem-solving and leadership skills, furthering expertise in team coordination and task management.

Teaching Assistant - Computer Science

New York Institute of Technology
Long Island, NY
01.2022 - 05.2022
  • Collaborated with instructors to deliver the cybersecurity curriculum and facilitated hands-on exercises to help students grasp key concepts.
  • Provided individual guidance on various types of firewalls (packet-filtering, stateful inspection, and application-layer firewalls).

Education

Bachelor of Engineering - Computer Science

The New York Institute of Technology
Old Westbury, NY
05.2024

Skills

  • SQL and Python
  • JavaScript and automation
  • Database management and data processing
  • Data analysis and visualization
  • Power BI and Excel
  • Cloud computing and AWS
  • Project management and leadership development
  • Troubleshooting and diagnosis
  • Project management
  • Technical documentation
  • System testing

Certification

  • Google Cyber Security Certificate, 03/24, Mastered essential skills in network security, cryptography, and incident response, Gained proficiency in implementing security best practices across cloud-based and hybrid environments
  • Amazon Web Service Cloud Practitioner Course, 04/22, Configured and managed Linux servers on Amazon EC2, including creating AWS instances, Established and managed Virtual Private Cloud (VPC) and subnets, facilitating connections between different zones

Projects

Pathfinder – Full Scale Web Application, 01/21, 10/21, Led the development of Pathfinder, a web application designed for career path guidance. Utilized HTML, CSS, Python, JavaScript (jQuery), and MySQL for frontend design, data scraping, and backend functionality. Applied advanced web scraping techniques to extract relevant data, demonstrating expertise in data processing.

Volunteer Experience

  • Conducted community tech workshops on programming fundamentals
  • Active member of the Red Cross Organization
  • Served as President of the Sikh Club at New York Institute of Technology
  • Teaching Assistant at New York Institute of Technology

Professional Interests

  • Automation
  • Data Science
  • Cloud Computing
  • Machine Learning
  • Cybersecurity

Competitions

Long Island’s Annual Capture the Flag (CTF) Competition by ISC2, 03/24, Participated in a challenging cybersecurity competition involving real-world scenarios focused on cryptography, ethical hacking, and network security. Used Wireshark for network traffic analysis and identifying vulnerabilities in real-time data flows. Utilized John the Ripper to crack password hashes, demonstrating proficiency in cryptography and encryption techniques. Conducted penetration testing using Metasploit to exploit system vulnerabilities in a controlled environment. Tackled cryptography challenges and ethical hacking tasks to recover encrypted messages and gain access to secure systems.

Timeline

Systems Engineer

Garan Inc.
06.2024 - Current

Senior Design

ParkingSystems.com
09.2023 - 03.2024

Project Manager (Co-Op Program)

ASR International Corporation
10.2022 - 09.2023

Teaching Assistant - Computer Science

New York Institute of Technology
01.2022 - 05.2022

Bachelor of Engineering - Computer Science

The New York Institute of Technology