Educational Courseware

Charles Portfolio

Database Techincal Consultant

Techincal Portfolio

Core Competencies & Skills

  • Oracle SQL, PL/SQL Development
  • Performance Tuning & Query Optimization
  • Data Modeling & ETL Expertise
  • Oracle Cloud Infrastructure Implementation
  • Docker
  • Advanced Reporting with Tableau & BI Publisher
  • Python, R, and Data Analysis
  • UNIX Shell Scripting & Automation
  • Database Design & Administration

Professional Experience

Senior DBA / SQL Developer

Tomorrow Now Corp — March 2015 to Present

  • Designed and optimized Oracle Databases, creating stored procedures and packages.
  • Developed ETL interfaces to streamline data flows across applications.
  • Tuned SQL queries to enhance system performance using advanced tools like EXPLAIN PLAN.
  • Collaborated with cross-functional teams for product and system improvements.

Key Projects

  • Optimized database performance, reducing query runtime by 30%.
  • Developed a secure ETL pipeline for third-party data integration.
  • Automated daily data imports using SQL*Loader and Shell Scripts.

Education

DeVry Institute of Technology, Chicago — Bachelor Degree in Technology

Technologies & Tools

  • Oracle Enterprise Edition, APEX, RMAN
  • SQL PLUS, TOAD, Spotlight, Embarcadero
  • Tableau, Python, R, Java, WordPress

/