Oracle PL/SQL Performance & Data Architecture

Mark E. Caramanica

Everett, MA ***** • 617-***-**** • ********@*******.*** • linkedin.com/in/mark-e-caramanica

Principal Data Engineer & Database Architect Oracle Specialist

Senior Data Engineer and Database Architect with 28 years of experience scaling and optimizing high volume database systems across financial, operational, and regulated corporate environments. Expert in Oracle Financials and Oracle Project Accounting data architectures, advanced SQL performance tuning, ETL/ELT pipelines, and data modeling. Proven track record modernizing legacy database logic, optimizing complex execution plans, and delivering stable, scalable workflows. Strong background supporting audit driven environments, SDLC governance, and cross functional team leadership.

Core Professional Strengths

Database Architecture & Engineering • Advanced SQL Tuning • High Volume Batch Processing • Data Modeling (Conceptual/Logical/Physical) • ETL/ELT Pipeline Design • Schema & Metadata Documentation • Scripting & Process Automation • System Integration • Team Leadership

Selected Achievements

Performance Optimization: Reduced batch ETL runtimes by 99% for underwriting data warehouses through advanced SQL tuning, pipeline optimization, and workflow redesign.

Architecture Modernization: Improved custom enterprise architecture performance by 80% using execution plan analysis and database object redesign.

Enterprise Scale: Engineered core data pipeline for global automated invoicing system, processing massive datasets to calculate billing for 16% of worldwide internet traffic.

Technical Skills

Databases & Tuning: Oracle (11g–19c), IBM DB2, SQL, PL/SQL, SQL PL, Pro*C, Stored Procedures & Functions, PL/SQL Packages, Advanced SQL Tuning, Execution Plan Analysis, Indexing, Optimizer Hints, Access Paths, Database Performance Diagnostics & Optimization (TKPROF, Explain Plan), SQL Developer, PL/SQL Developer, TOAD

Architecture & ETL: Data Modeling (Conceptual/Logical/Physical), Relational Design, Metadata Repositories, Data Warehouse Concepts & Structures, ERwin, Schema Updates, Oracle Financials, Oracle Project Accounting, SCT Banner ERP, High-Volume Data Ingestion (SQL*Loader, Bulk Utilities), Batch Processing, Staging/ODS, Demand Driven Data Processes & Forecasting Exposure

Scripting & Governance: Unix Shell Scripting, PowerShell, Shell Based ETL Automation, Enterprise Job Orchestration (JAMs, Cron), Agile/Scrum, Waterfall, SDLC Governance, Requirements Gathering, UAT Leadership, Audit Compliance (SOX/ITGC)

Professional Experience

Specialty Commerce Corporation – West Bridgewater, MA

Applications Developer / Applications Manager Feb 2013 – Apr 2025

Environment: Relational Databases (Oracle 11g/12c/19c), PL/SQL, SQL*Loader, SQL Developer, PL/SQL Developer, TOAD, Direct Commerce, JAMs, PowerShell, UNIX.

Led a 3-person engineering team managing database reliability, custom application development, and cross-functional enterprise integrations for core enterprise ERP/CRM applications, business intelligence, and Unified Communications (UCaaS) data streams.

Managed end to end ERP/CRM/WMS database operations including configurations, workflows, user access, data integrity, metadata repositories, and demand driven inventory data processes.

Architected and optimized PL/SQL packages, stored procedures, conceptual/logical/physical data models, and high volume ETL/ELT pipelines using execution plan analysis, optimizer hints, and access path tuning.

Implemented revenue-generating integrations, including external membership programs ($2M/year) and third-party dropship systems ($1M/year), and cross system data reconciliation.

Directed migrations, release readiness, stakeholder expectations, and UAT for major software, database, and business intelligence platform upgrades to execute banking certifications while minimizing operational downtime.

Engineered robust batch orchestration workflows and shell based ETL automation to streamline high volume month end data delivery, saving 24 hours of manual processing for finance and operations teams.

Graduate Studies & Family Care Coordination — Greater Boston Area Mar 2006 – Jan 2013

Pursued advanced graduate-level Computer Science coursework while managing long-term logistics for a family health matter.

Akamai Technologies – Cambridge, MA

Lead Applications Developer / Principal Applications Developer / Consultant Jun 2000 – Mar 2006

Environment: Oracle, IBM DB2, PL/SQL, SQL PL, UNIX, Cron, Siebel Systems, Oracle Financials, XML.

Architected and scaled backend database logic for a global automated invoicing system, processing complex billing calculations for massive volumes of internet traffic (16% of global traffic).

Owned the end-to-end Accounts Receivable (AR) Interface, designing the data pipeline logic that seamlessly mapped high-volume invoiced line items down to precise General Ledger (GL) account breakdowns.

Managed annual external audits for global billable usage calculations and customer invoices; successfully defended database architecture, functional code paths, and data lineage to ensure regulatory compliance.

Re-architected the core usage calculation pipeline into a highly distributed database topology, executing a cross-platform data migration that significantly reduced infrastructure overhead.

Developed scalable XML invoicing logic to meet strict compliance mandates required for global reseller workflows.

Engineered multi-platform ETL workflows to seamlessly integrate usage metrics across CRM systems, internal accounting layers, and corporate data warehouses, supporting data warehouse concepts and structures.

Retained as an independent contractor to author audit-ready engineering documentation mapping critical billing data interfaces to Enterprise Financials and Data Warehouse layers.

Prior Professional History

Senior Database Engineer / Senior Programmer Analyst

Stone & Webster • Delta Dental • Fax International • Bentley University.

Core Scope: Progressed from Junior to Senior Analyst roles. Refactored legacy database logic, executed complex data conversions, optimized Oracle Centric ETL/ELT performance, supported and enhanced Oracle Financials, Oracle Project Accounting, and SCT Banner ERP systems, and established foundational business SDLC standards across engineering, telecommunications, healthcare, and higher education sectors.

Education

Master of Science, Computer Science — Suffolk University

Bachelor of Science, Computer Science (Minor: Mathematics) — Suffolk University

Certifications

Agile & Project Management: Agile Professional, Scrum Master, Project Management, Lean Practitioner (SSGI)

Cloud & Development Platforms: Oracle Cloud Infrastructure (OCI) Foundations Associate (Expected Q4 2026), Oracle APEX Developer Professional (Expected Q4 2026)

Contact this candidate