Principal Oracle PL/SQL Developer

Jagan Mohan Reddy Ureniki

212-***-**** ******@*****.***

PRINCIPAL ORACLE PL/SQL DEVELOPER

Professional Summary

** ***** ** ** ********** hands-on expertise in Oracle Database Development, PL/SQL programming, ETL design, Data Migration, and Data Warehousing solutions.

Extensive experience designing and developing stored procedures, packages, triggers, functions, views, dynamic SQL, SQL*Loader utilities, and metadata-driven data migration for processing large and highly sensitive datasets.

Strong expertise in SQL performance tuning, execution plan analysis, indexing strategies, query optimization, bulk processing techniques (Bulk Collect, FORALL), and Oracle database performance improvement.

Designed and implemented PL/SQL solutions for logistics, transportation, and high-technology domain applications.

Experienced in database design activities including logical and physical data modeling, ER diagrams, schema design, normalization, and database administration support activities.

Proficient in Linux/Unix environments with strong shell scripting capabilities and experience working with SQL*Loader, scheduling, and Agile/Scrum methodologies.

Developed innovative PL/SQL-based solutions including implementation of Dijkstra's shortest path algorithm for Oracle Spatial objects.

Possess domain knowledge in Property & Casualty Insurance through CIRMA implementation

Demonstrated ability to quickly understand and adapt to new business domains including Healthcare, Utilities, Retail, Logistics, Oil & Gas, and E-Commerce.

Exposure to AWS cloud services and Python scripting for automation, data validation, and operational efficiency improvements.

Excellent analytical, problem-solving, and communication skills with proven ability to collaborate effectively with business stakeholders, architects, and cross-functional technical teams to deliver end-to-end solutions.

Technical Skills

Database Technologies: Oracle 11g/12c/19c, SQL Server, PostgreSQL, Snowflake, SAP HANA, MySQL

Programming Languages: PL/SQL, SQL, Python, Core Java, Shell Scripting, VB.NET, ASP.NET

Oracle Technologies: Stored Procedures, Packages, Functions, Triggers, Views, Dynamic SQL, Bulk Collect, FORALL, Materialized Views, SQL*Loader, Query Optimization, Explain Plans, Performance Tuning, Partitioning

ETL Technologies: SQL*Loader, SSIS, Informatica, Talend, DBT, Metadata Driven ETL Frameworks

Database Design: ER Modeling, Logical and Physical Data Modeling, Database Normalization, Schema Design

Operating Systems: Linux, Unix, Windows

Scheduling Tools: ActiveBatch, Control-M Scheduling Concepts

Cloud Technologies: AWS (Exposure), Azure, Google Cloud

Methodologies: Agile, Scrum, Waterfall

Tools: SQL Developer, TOAD, SQL Navigator, JIRA, Confluence, Rally, Git

Education

Master of Computer Applications Osmania University India Oct 1998

Bachelor of Science Osmania University India Apr 1995

Jagan Ureniki ******@*****.*** Page Two

Professional experience

Senior PLSQL Developer

Waste Management Windsor, Connecticut Mar 2025 - Present

Project Scope: Oracle 19c, PL/SQL, SQL*Loader, SAP HANA, Snowflake, Python, Linux, Shell Scripting, Agile, JIRA

Developed and optimized Oracle PL/SQL packages, stored procedures, functions, triggers, and views supporting enterprise-scale data migration initiatives

Worked extensively with Oracle SQL Developer, TOAD, and SQL*Plus for database development, debugging, and performance optimization.

Performed query optimization and performance tuning using explain plans, indexing strategies, and execution statistics.

Developed high-performance SQL and PL/SQL code, optimizing queries through indexing strategies, execution plan analysis, bulk processing (BULK COLLECT, FORALL), and performance tuning techniques.

Developed reusable PL/SQL utilities for data cleansing, reconciliation, and validation activities.

Utilized SQL*Loader utilities for bulk loading operational data into Oracle staging environments.

Worked within Agile sprint cycles - backlog refinement, sprint planning, daily standups, and retrospectives.

Performed SQL and PL/SQL performance tuning using EXPLAIN PLAN, execution plans, indexing strategies, SQL Trace, TKPROF, and Oracle Optimizer recommendations.

Collaborated with architects and business stakeholders in defining database structures and logical data models.

Utilized Python scripts to automate validation processes and improve testing efficiency.

Supported production ETL workflows, monitored jobs, and resolved failures proactively.

Oracle PLSQL Developer / Data Migration Specialist

Levi’s USA Jan 2023-Feb 2025

Project Scope: Oracle 12c, PL/SQL, SQL*Loader, Linux, SQL Developer, TOAD, Agile

Designed and developed Oracle database applications using PL/SQL packages, procedures, triggers, and functions supporting logistics and transportation systems.

Performed database performance tuning and query optimization for high-volume transaction processing systems.

Developed reusable metadata-driven PL/SQL utilities for data cleansing, reconciliation and validation.

Worked extensively with Oracle development tools including SQL Developer, TOAD and SQL Navigator.

Developed SQL*Loader control files and batch scripts for loading large datasets into Oracle databases.

Developed batch data processing solutions in Linux/Unix environments.

Collaborated with business stakeholders to translate requirements into effective data model designs.

Collaborated closely with product, and business teams to understand intricate project scope, gather detailed requirements and facilitate timely and quality deliverables.

Supported release activities, defect triage, production deployments, and post-production validation.

Senior Oracle PL/SQL Developer

Spurtree Technologies India March 2021 - Jan 2023

Involved in the development and customization of web & mobile e-commerce applications using Spurtree’s proprietary platform (MartJack). Managed product design, capability definition, and client-focused customization efforts, delivering tailored solutions to global brands such as Pizza Hut, KFC, Herfy, and SPAR.

Part of development of web applications with strong backend data integration and transformation layers.

Utilized SQL*Loader utilities for loading large volumes of data efficiently.

Designed strong backend data integration layers using PL/SQL programming to handle rapid, high-volume transactions.

Participated in legacy system data analysis and Designed source-to-target mapping documents.

Collaborated with teams to define data flow, transformation rules, and system integrations.

Ensured proper data handling, storage, and retrieval strategies for scalable web platforms.

Delivered solutions integrating multi-source data into centralized systems.

Jagan Ureniki ******@*****.*** Page Three

Senior PL/SQL Developer

CIRMA – USA (Property & Casualty Insurance Implementation – Guidewire DataHub) Oct 2019 – Feb 2021

Developed SQL scripts and migration utilities for insurance data conversion, validation and reconciliation.

Worked with policy administration, claims, and customer-related datasets.

Worked extensively with Policy, Claims, Premium, Coverage, Insured, and Renewal and Loss History datasets.

Participated in discussions with business users to understand insurance terminologies and business rules.

Automated SQL scripts and migration utilities for insurance data conversion and validation.

Assisted in analysis of policy transactions, claim processing and renewal activities.

Collaborated with development teams in Agile environments for enhancements and production support activities.

Quickly acquired domain knowledge related to insurance business processes and data structures.

Senior Database Developer

GSK USA Mar 2018 – Oct 2019

Managed clinical research data collection and migration, and ensured HIPAA compliance for studies evaluating treatment efficacy, supporting FDA approval processes for GlaxoSmithKline (GSK).

Managed clinical and healthcare data systems, ensuring compliance with HIPAA regulations.

Designed and implemented data collection, transformation, and validation processes.

Worked with large datasets to ensure data integrity, accuracy, and reporting readiness.

Supported data migration, ETL workflows, and analytics pipelines.

Collaborated with stakeholders to ensure high-quality reporting data for regulatory submissions.

Infotech Enterprises Limited (Cyient Limited) – India USA UK Germany Australia

Software Developer / Senior Oracle PL/SQL Developer Feb 2011 – Feb 2018

Developed enterprise database applications using Oracle PL/SQL, including Packages, Stored Procedures, Functions, Triggers, Views, Collections, Dynamic SQL, and Exception Handling.

Implemented complex PL/SQL solutions for logistics, transportation, and high-technology domain applications.

Built metadata-driven ETL frameworks entirely in Oracle PL/SQL using configurable mapping tables to automate data extraction, transformation, validation, and loading processes.

Developed high-performance SQL and PL/SQL code, optimizing queries through indexing strategies, execution plan analysis, bulk processing (BULK COLLECT, FORALL), and performance tuning techniques.

Created and maintained logical and physical data models, including ER diagrams, schema design, normalization, denormalization, and referential integrity constraints.

Designed dimensional database structures and implemented data mapping solutions to support reporting and analytical applications.

Developed Oracle database objects to support enterprise apps handling high-volume transactional and spatial data.

Implemented Dijkstra's shortest path algorithm using Oracle PLSQL and Spatial to optimize transportation routes.

Developed PL/SQL programs to analyze transportation and traffic data, generating optimized routing recommendations for logistics applications.

Designed and implemented batch processing solutions using Oracle Scheduler and Linux shell scripting for automated data processing.

Used SQL*Loader extensively to load, validate, and reconcile large volumes of data from flat files into Oracle databases.

Developed Linux shell scripts to automate database deployment, batch execution, monitoring, and operational support.

Worked extensively with Oracle SQL Developer, TOAD, and SQL*Plus for database development, debugging, and performance optimization.

Developed enterprise applications using C#, VB.NET, ASP.NET, VC++, Visual Basic, MapInfo, and Oracle PL/SQL, integrating application logic with Oracle databases.

Delivered onsite Oracle database development and support for customers in the United Kingdom, collaborating directly with client teams to implement and optimize database solutions.

***

Contact this candidate