MARCUS OKAFOR
Columbus, OH · marcus.okafor@email.com · (555) 010-7002 · linkedin.com/in/marcusokafor

SUMMARY
SQL developer with 2+ years owning SQL Server and PostgreSQL logic for a payments product. Tunes queries by execution plan, ships stored procedures with tests, and keeps ETL loads inside their windows.

SKILLS
SQL (T-SQL, PL/SQL, PL/pgSQL) · SQL Server · PostgreSQL · Oracle · Query optimization & execution plans · Indexing · Stored procedures & functions · ETL (SSIS, dbt) · Data modeling · Git

EXPERIENCE
SQL Developer · Scioto Payments · 2023-Present
• Tuned the 25 slowest production queries by rewriting plans and adding filtered indexes; cut p95 query latency 62% on a 180M-row transactions table.
• Built and tested 30+ stored procedures and functions for settlement logic; zero rollback incidents in one year.
• Redesigned the nightly SSIS load into incremental merges; brought the ETL window from 4.2 h to 55 min.
• Modeled a reporting schema (star schema, 9 dimensions) that let finance retire 3 manual reconciliation workbooks.
• Wrote row-count and checksum validation for every load; caught 4 upstream schema changes before they reached reports.
• Key project — Settlement procedure rewrite: replaced a cursor-based batch with set-based T-SQL, removing a recurring month-end overrun.

SQL Developer · Queen City Logistics · 2021-2023
• Wrote T-SQL reporting queries with CTEs and window functions for an operations dashboard.
• Added covering indexes after execution-plan review; cut a daily report from minutes to seconds.
• Built stored procedures for order-status lookups with validation and error handling.
• Migrated ad-hoc analyst queries into a documented views layer.
• Wrote post-load data-quality checks.
• Key project — Operations dashboard SQL layer: designed the views and procedures behind a dispatch dashboard.

EDUCATION
BS Information Systems · Ohio State University · 2021