Professional Summary

 Over 10 years of experience as a Senior Oracle Developer, designing, developing, and maintaining Oracle-based applications
and databases with strong expertise in Oracle SQL, PL/SQL, Oracle 12c, and Oracle Exadata.
 Experienced in full SDLC and Agile environments, participating in sprint planning, backlog grooming, daily stand-ups, and
retrospectives.
 Experienced in developing and supporting Oracle Forms and Reports to meet functional requirements and enhance user
workflows.
 Proficient in troubleshooting and resolving database-related issues including performance bottlenecks, data inconsistencies,
and deployment challenges.
 Skilled in deployment and release activities, ensuring smooth migration of changes across environments while maintaining data
integrity.
 Knowledge of data integrity, security, and compliance best practices to meet organizational and regulatory requirements.
 Strong problem-solving and time management skills with a track record of delivering complex Oracle solutions within deadlines.
 Experienced in participating in code reviews, contributing to development best practices, and mentoring team members.
 Expert in creating and maintaining stored procedures, functions, packages, triggers, and database objects including partitioning,
indexes, and materialized views, ensuring optimal performance.
 Experienced in using Azure DevOps and Git for code management, setting up pipelines, tracking work, and handling releases.
 Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and
implementation Experience in complete System Development Lifecycle.
 Proficient in performance tuning using techniques such as table partitioning, query optimization, and Oracle indexing strategies
to enhance application responsiveness.
 Collaborated with cross-functional QA teams to ensure complete unit testing and functional validation of Oracle-based
solutions.
 Passionate about developing consumer-focused, high-quality solutions and driving continuous improvement across
development lifecycles.

Technical Skills

 Programming & Scripting: Oracle SQL, PL/SQL, Python

 Oracle Tools: Oracle Forms, Oracle Reports, Oracle SQL Developer, TOAD, PL/SQL Developer.

 Database Platforms: Oracle 12c, Oracle Exadata, Oracle RDBMS

 Development Tools: Oracle SQL Developer, TOAD, PL/SQL Developer

 Version Control & CI/CD: Azure DevOps & Github

 Performance & Debugging: SQL/PLSQL Performance Tuning, Query Optimization, Debugging, Data Analysis

 Software Development Methodology: Agile Scrum – Sprint Planning, Standups, Retrospectives, Story Refinement

 Testing & Quality Assurance: Unit Testing, Functional Validation, QA Collaboration

 Documentation & Knowledge Sharing: Technical Documentation, Code Reviews, Team Collaboration

 Operating Systems: Windows, Linux, UNIX

Professional History
Denbury Resources, Plano, TX Nov 2022 – Present
Oracle Developer
Responsibilities:
 Utilized Oracle Exadata Storage Indexes to accelerate query performance for partitioned tables.
 Contributed story points, testable deliverables, and sprint demos to enhance product quality.
 Developed and optimized PL/SQL packages, procedures, and triggers to automate backend logic, aligned with agile user stories.
 Conducted root cause analysis and debugging of performance bottlenecks in packages and views.
 Developed custom Oracle Forms with integrated validation and triggers to support high-volume data entry and ensure
consistent transactional accuracy across applications.
 Enhanced Oracle Reports by embedding dynamic SQL and performance-tuned queries, delivering faster report generation and
improved end-user experience.
 Implemented fine-grained access controls and role-based privileges in Oracle database to maintain data security and meet
compliance requirements.
 Implemented complex form-level and block-level triggers within Oracle Forms to enforce business rules in real time
 Configured auditing policies to track critical DML operations, ensuring accountability and alignment with organizational data
governance standards.
 Developed complex Oracle PL/SQL packages, procedures, and triggers to automate core business logic and improve database
performance.
 Enhanced Oracle Forms to include dynamic list-of-values (LOVs) and user-specific validations, significantly improving data
accuracy and user efficiency during high-volume transactions.
 Performed deep-dive SQL performance analysis using execution plans, TKPROF, and SQL Trace to optimize high-volume
transactional queries.
 Developed advanced Oracle Reports with parameterized layouts and drill-down functionality
 Used Azure DevOps pipelines to automate database deployment and track feature delivery through sprints.
 Performed PL/SQL performance tuning and SQL optimization using execution plans, ensuring application responsiveness and
stability.
 Wrote unit test cases in PL/SQL to validate procedure output and edge cases.
 Used Git repositories in Azure DevOps for version control of PL/SQL codebase with branching and merge strategies.
 Tuned SQL statements for high-volume transactional tables using indexes and execution plans.
 Extensively used Bulk collect, Bulk Binds temp tables and external tables for DML operations.
 Maintained work items, tasks, and commits in Azure Boards for cross-team visibility.
 Worked on fixing defects and improving performance for existing data base objects by using PLSQL, where performance has
increased.
 Developed stored procedures and triggers to facilitate consistent data entry into the database.
 Used SQL loader to load the data from the files provided by the interfacing applications.
Environment: Oracle, PL/SQL, Oracle Exadata, SQL Loader, Agile, Azure DevOps, Oracle Forms, Git, Azure Boards, SQL Developer,
TOAD, Agile/Scrum.

Apache Corporation, Houston, TX July 2020 – Sep 2022

Oracle Developer
Responsibilities
 Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
 Created .bat scripts to automate ETL kicks and status logging in the local Windows environment.
 Designed interactive Oracle Forms to streamline transactional workflows, incorporating validation logic and exception handling
for enhanced reliability.
 Modified existing Oracle Reports to improve data presentation, incorporating parameterized queries for flexible reporting
requirements.
 Debugged PL/SQL and SQL code for defect resolution and performance issues, collaborating with QA for test validation.
 Used Oracle’s TKPROF and SQL*Trace to identify bottlenecks in packages and long-running reports.
 Integrated Oracle Forms with Oracle Reports using parameterized triggers and runtime configuration to enable seamless drill-
down from forms to detailed report outputs
 Established secure database roles and profiles to restrict access and protect sensitive information from unauthorized access.
 Configured database auditing for high-risk tables, enabling monitoring of changes and ensuring compliance with internal
controls.
 Conducted code reviews and resolved merge conflicts collaboratively with Git.
 Executed controlled deployments of Oracle database objects across environments, validating performance metrics before
production cutover.
 Optimized SQL logic within PL/SQL packages using indexing, partitioning, and cost-based optimizer hints to maximize efficiency.
 Maintained CI/CD scripts in Azure DevOps for nightly package deployments and hotfix releases.
 Participated in change and code reviews to understand the testing needs of the change components.
 Extracted data from the XML file and loaded it into the database.
 Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
 Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database
procedures, functions and packages for Front End Module.
 Used principles of Normalization to improve the performance.
 Tuned materialized views for optimized refresh intervals and query responsiveness.
 Participated in joint testing efforts to reduce UAT cycle time.
 Maintained module-level design specs for reuse and knowledge transfer.
Environment: Oracle, Agile, PL/SQL, SQL*Loader, Oracle Froms, Oracle Reports, Windows, Linux, Git, Azure DevOps, SQL Developer,
TKPROF, XML.

Devon Energy, Oklahoma City, Oklahoma Sep 2017 – July 2020

Oracle Developer
Responsibilities
 Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the
necessary insight into the data.
 Developed Oracle Forms for operational data management, implementing data validation logic to reduce entry errors.
 Created Oracle Reports delivering key operational metrics, leveraging optimized SQL queries for faster execution.
 Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools.
 Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
 Checked in code using Git via Azure Repos and contributed to merge reviews.
 Utilized Oracle Exadata Storage Cells to offload processing and improve performance.
 Created unit test scripts in PL/SQL for new procedures and logged defects in QA cycles.
 Applied Oracle database privileges and grants to enforce least-privilege access principles for all users.
 Involved in the continuous enhancements and fixing of production problems.
 Conducted peer reviews to ensure test coverage and logic accuracy.
 Optimized SQL performance through indexing, query hints, and execution plan analysis.
 Developed PL/SQL triggers and master tables for automatic creation of primary keys.
 Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
 Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and
AUTOTRACE.
 Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL
engines.
 Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Environment: Oracle 12c, PL/SQL, Oracle Forms, Oracle Reports, SQL*Loader, TOAD, Git, Azure Repos, Exadata, SQL Developer,
UTL_FILE, TKPROF, AUTOTRACE, EXPLAIN PLAN.

Citibank, Tampa, Florida May 2016 – Sep 2017

PL/SQL Developer
Responsibilities
 Gathering requirements and performing analysis.
 Provided technical assistance/support to analysts, business community, QAs for errors, problems or questions with
programs/interfaces.
 Performed PL/SQL unit testing and collaborated with QA team for issue replication and fixes.
 Used Git to commit PL/SQL changes and review peers’ changes for feedback and correctness during sprints.
 Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
 Created scripts to create new tables, views and queries for new enhancement in the applications.
 Participated in Agile Scrum ceremonies, tracking story progress and updating task boards.
 Created indexes on the tables for faster retrieval of the data to enhance database
 Used Bulk Collections for better performance and easy retrieval of data by reducing context switching between SQL and PL/SQL
engines.
 Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the
application.
 Experienced in fast paced Agile Development Environment and methodologies including Scrum.
 Coordinating with client and offshore coordinator for day to day activities.

Environment: Oracle , PL/SQL, SQL Developer, Git, Agile Scrum, TOAD, Bulk Collections, Exception Handling, Windows.