Summary

Experience

Senior PL/SQL Developer|GlobalTech Solutions

Austin, TXJun 2021Present

• Optimized complex PL/SQL packages and procedures, reducing query execution times by an average of 30% for critical business reports.
• Led the migration of legacy data from Oracle 12c to 19c, ensuring seamless data integrity and zero downtime for over 50 production applications.
• Developed and maintained over 20 ETL processes using Oracle Data Integrator (ODI), improving data loading efficiency by 25% and supporting daily data warehouse updates.
• Collaborated with cross-functional teams to design and implement new database schemas and stored procedures, supporting the launch of 3 major product features within tight deadlines.
• Mentored junior developers on best practices for SQL and PL/SQL coding, contributing to a 15% increase in team code quality metrics.

PL/SQL Developer|DataWorks Inc.

Austin, TXAug 2017May 2021

• Developed and maintained robust PL/SQL code for backend database systems, handling over 10TB of financial transaction data.
• Implemented performance tuning strategies on SQL queries and indexes, improving system response times for user-facing applications by 20%.
• Automated daily data reconciliation processes using SQL and shell scripting, reducing manual effort by 15 hours per week.
• Created and managed stored procedures, functions, and triggers to enforce data integrity and business rules across multiple applications.
• Assisted in the design and deployment of new data models, ensuring scalability and compliance with industry standards.

Projects

Automated Data Validation Tool

Mar 2022Jun 2022

• Developed a PL/SQL-based tool to automate validation of incoming data feeds against predefined business rules, significantly reducing manual data quality checks by 70%.
• Implemented dynamic rule configuration allowing business users to define new validation criteria without code changes, enhancing operational flexibility.

Inventory Management System Backend

Oct 2019Mar 2020

• Designed and implemented the Oracle database backend for an inventory management system, supporting over 10,000 product SKUs and millions of daily transactions.
• Created a suite of PL/SQL procedures and functions to manage inventory levels, order processing, and supplier data, improving data consistency by 99.5%.

Oracle Performance Monitor Script

Jan 2023Present

• Developed a set of SQL and PL/SQL scripts to monitor key Oracle database performance metrics (e.g., AWR, ASH, wait events), providing real-time insights.
• Created an automated reporting mechanism to alert administrators of potential bottlenecks, leading to proactive issue resolution and a 10% reduction in critical downtime.

Education

The University of Texas at Austin|Bachelor of Science in Computer Science

Austin, TXSep 2013May 2017

• Graduated Magna Cum Laude with a GPA of 3.8/4.0
• Recipient of the Dean's List for six semesters
• Relevant coursework included Database Management Systems, Data Structures, and Algorithms

Skills

Database Technologies

Oracle Database 19c/12cSQLPL/SQLSQL*PlusTOADSQL Developer

ETL & Data Warehousing

Oracle Data Integrator (ODI)Informatica PowerCenterData ModelingData MigrationETL DevelopmentData Warehousing

Programming & Scripting

Bash ScriptingPython (basic)XMLJSONGit

Tools & Methodologies

JIRAConfluenceAgile/ScrumVersion ControlPerformance TuningUnit Testing