John Drab

Built ETL scripts in Python and SQL to automate gathering 4TB+ of required data from vendor systems and our internal database for a business consultant, eliminating the need for a vendor-performed data extraction costing ~$5,000. Diagnosed overnight batch processing failures and modified SQL queries across multi-million-row tables, applying indexing and query optimization to cut average job runtime 52% (5.5 to 2.6 min) and meet nightly business deadlines. Conducted impact assessments across interconnected Oracle CC&B, GIS, and Power BI systems as part of a major platform upgrade (v2.6 to v2.9), mapping data flows and dependencies while porting scripts and billing UIs, then validated production batch execution post-upgrade.

Information Technology Intern (Database / Enterprise Application Development) - City of Sacramento IT Department

(2023-06 - 2026-07)

• Built ETL scripts in Python and SQL to automate gathering 4TB+ of required data from vendor systems and our internal database for a business consultant, eliminating the need for a vendor-performed data extraction costing ~$5,000.
• Diagnosed overnight batch processing failures and modified SQL queries across multi-million-row tables, applying indexing and query optimization to cut average job runtime 52% (5.5 to 2.6 min) and meet nightly business deadlines.
• Conducted impact assessments across interconnected Oracle CC&B, GIS, and Power BI systems as part of a major platform upgrade (v2.6 to v2.9), mapping data flows and dependencies while porting scripts and billing UIs, then validated production batch execution post-upgrade.
• Authored technical design documentation with source-to-target mappings, business rules, and transformation logic for a custom data validation algorithm enforcing format and range rules on geographic data entry, resolving recurring downstream reporting failures in Power BI and geocoding errors in GIS.
• Designed and maintained relational database tables and schemas supporting core billing and customer data workflows, applying indexing and optimized joins to ensure data integrity, query efficiency, and alignment with downstream reporting and integration systems.
• Integrated the billing platform with GIS and SOAP web services via Python automation, collaborating with business analysts and technical stakeholders to align data flows between systems and auto-create customer records in the Oracle CCB system from business-provided data.
• Led knowledge-gathering sessions and trained the technical team on a new integration testing framework added in version 2.9, building and running 43+ test flows with business analysts and QA to support traceability from requirements through implementation to testing.

Verilog Logic Design Tutor - University of California – Santa Cruz

(2022-09 - 2024-01)

• Translated complex technical hardware design concepts into clear, accessible instruction for 300+ students, debugging RTL simulations and guiding students from design through implementation. Presented regular weekly lab lessons.

M.S. - Computer Science - University of California, Davis (2026-03)

B.S. - Computer Engineering, Minor CS - University of California, Santa Cruz (2024-03)