Senior Oracle PL/SQL Developer
Resume:
KATE KUJAWSKI
SENIOR ORACLE DEVELOPER
CONTACT
PROFILE
South Bend, IN
****.********@*****.***
www.linkedin.com/in/kate-kujawski-8b2596403
Oracle Developer specializing in database support for web and application functionality, as well as enduser reporting and analytics across OLTP and OLAP environments in financial and educational domains. Ensured highperformance PL/SQL processing for 500K+ daily transactions, 7 million accounts.
SKILLS
WORK EXPERIENCE
PL/SQL
Oracle 19c
Database objects
Performance tuning
Query optimization
AWR, ADDM, ASH
Explain plans
SQL Trace
Database design
ETL
Git
Agile/Scrum environment
Toad
Database Engineer III – Incomm Payments
Apr/2018 – Apr/2026
Incomm purchased the American Express division which was my previous employer so much of my job description carried over from Amex.
Migration - PL/SQL developer in the migration of the Serve application from American Express to InComm Payments, implementing database logic and components essential to a successful transition.
Maintenance and new functionality - Engineered and maintained highperformance Oracle code for a highvolume prepaid debit card platform, optimizing analysis and tuning to support largescale transaction workloads. Built and enhanced PL/SQL code including packages, procedures, functions, and triggers for application and batch processing. Designed, built and administered Oracle database objects—including tables, views, indexes, sequences, synonyms, constraints and partitions—across Oracle 19c and Exadata environments. Utilized bulk collects, cursors, collections, CTE’s and subqueries as well as analytical functions. On call for production issues and solutions.
Data warehouse - Designed new data warehouse structures and collaborated with crossfunctional and ETL teams to deliver new features, resolve data discrepancies, and align database logic with business requirements.
Data feeds to Partners – Developed automated data feeds and daily operational workflows, including scheduled Oracle jobs, ensuring reliable and consistent data movement. Also worked with partners to reconcile discrepancies.
Reporting - Provided advanced reporting and analytics support by writing ad hoc queries, producing scheduled extracts, and resolving data issues directly with business users.
Data Analyst (Contractor) – Raymond James
Jul/2017 – Apr/2018
Analysis - Investigated data issues related to ETL process.
Data Modeling - Created data modeling for new proprietary application to store institutional account information.
Documentation - Created business requirements and data mapping document for data points required in meeting federal requirements for CDD (Customer Due Diligence).
Lead Database Developer – American Express
Nov/2012 – Jul/2017
Migration – Converted SAS code to PL/SQL for scheduled compliance reports.
Maintenance and new functionality - Engineered and maintained highperformance Oracle code for a highvolume prepaid debit card platform, optimizing analysis and tuning to support largescale transaction workloads. Built and enhanced PL/SQL code including packages, procedures, functions, triggers for application and batch processing. Designed, built and administered Oracle database objects—including tables, editioned and standard views, indexes, triggers, sequences, synonyms, and partitioned structures.
Data warehouse – Maintained previously designed data warehouse and added required enhancements.
Reporting - Provided advanced reporting and analytics support by writing ad hoc queries, producing scheduled extracts, and resolving data issues directly with business users.
EDUCATION
Master of Science in Management Information Systems
Florida State University
Advanced courses in technology and management.
Bachelor of Arts in Physical Education
Trine University
Physical Education major, Business minor, accounting specialization
SOFT SKILLS
Communication skills
Problem Solving
Collaboration
Documentation
Adaptability
Detail oriented
Contact this candidate