Cesar Rodriguez - Portfolio

$ whoami

Cesar Rodriguez

Senior Data Analyst · USAF Aircraft Systems Specialist · Network Engineer

A technically diverse and slightly eccentric professional of 10+ years spanning enterprise data systems, military aircraft electrical and environmental systems, and network infrastructure — with a passion for drinking concerning amounts of caffeine and building software projects.

View Experience GitHub → LinkedIn →
10+
Years Experience
2.6M
Units/Month
500+
Clients Supported
5
Certifications

// EXPERIENCE

Aircraft E&E Systems Specialist (2A656)

military

United States Air Force Reserves · McGuire AFB, NJ

  • Performs aircraft electrical and environmental functions on active USAF aircraft
  • Troubleshoots, inspects, and operates integrated E&E systems: Oxygen, Pressurization, Power Distribution, Fire Detection, Countermeasures, and Electrical Wiring

Aug 2019 – Present

McGuire AFB, NJ

Senior Data Analyst

data

ClickPay (A Subsidiary of RealPage, Inc.) · Hackensack, NJ

  • Manages database operations for a proprietary web portal processing rental payments for 2.6 million units per month
  • Uses Microsoft Excel and T-SQL for data manipulation, trend reporting, and troubleshooting across 500+ clients
  • Collaborates with Sales, Executive, Implementation, and Accounting teams to produce custom KPI financial and PCI compliance reports
  • Partners with QA and Development teams to document and test new features and bug fixes prior to system releases

Sep 2016 – Present

Hackensack, NJ

On-Site Network Administrator

networking

PCS Revenue Control Systems · Englewood Cliffs, NJ

  • Managed 50+ virtual machines across a 7-host VMware vCenter cluster
  • Provisioned iSCSI LUNs on an EMC VNX storage array and mounted them as VMware datastores
  • Administered inbound/outbound network security using CheckPoint appliances (SmartView Tracker, Smart Dashboard)

Sep 2014 – Sep 2016

Englewood Cliffs, NJ

Networking Intern

internship

NorthReal, Inc. · Rochelle Park, NJ

  • Assisted a senior network technician with the deployment and verification of an AlienVault Network Intrusion Detection System

Apr 2014 – Jun 2014

Rochelle Park, NJ

// CERTIFICATIONS

Cisco CCNA

Cisco · June 2015

Routing & Switching — Multi-Area OSPF, EIGRP, VRRP/GLBP, Rapid PVST+, IPv6, LACP/PAgP EtherChannel

Cisco CCENT

Cisco · April 2015

Small enterprise branch networking — 802.1q trunking, ACLs, Link State vs Distance Vector routing protocols

CompTIA Network+

CompTIA · December 2014

Vendor-neutral certification covering local network build and management skills

CompTIA Security+

CompTIA · September 2014

Network security foundations and risk management principles

CompTIA A+

CompTIA · March 2014

Core hardware and IT support fundamentals — the foundation of the CompTIA certification path

// EDUCATION

364th Training Squadron — USAF Technical School

Electrical & Environmental Apprentice Course · Sheppard AFB, TX

  • Overview of electrical engineering principles
  • Hands-on instruction in aircraft electrical systems, landing gear, fire suppression, oxygen, and pressurization

Lincoln Technical Institute

Network Administration and Support · Paramus, NJ

  • Lab-based preparation for CompTIA and Cisco certification exams

// PERSONAL PROJECTS

FNaF-1-PSP-Optimized

C / Lua

Performance-optimized PSP game port with stability improvements for real hardware playability.

game port github →

Git-Quest

Shell

A terminal game that teaches common git commands through interactive play. ★1

edu tool github →

PSP-MMW

Python

Write custom metadata (title, episode number, thumbnail) to PSP video files before syncing.

psp tool github →

ICNS-Converter

Shell

Convert .png logos to .icns from the terminal on macOS — quick and dependency-light.

macOS util github →

PSP-Photo-Organizer

Shell

Organizes image folders for sequential PSP viewing — perfect for comic books on the go.

psp tool github →

The-Judge

Python

A Death Note–inspired text-based strategy game. Make decisions, pass judgment, face consequences.

text game github →

// SKILLS & TOOLS

Microsoft T-SQL
Microsoft Excel
Python
Shell / Bash
C / Lua
VMware vCenter
EMC VNX Storage
CheckPoint Firewalls
Cisco Routing & Switching
Network Security
Aircraft E&E Systems
PCI Compliance Reporting