Oracle PL/SQL Developer

DVRAO

Cell: 312-***-**** *******@*****.***

Senior Oracle Developer and Database Architect with 15 Plus years of experience in modeling, designing, and developing enterprise-scale database applications across financial services, healthcare, and risk systems. Proven expertise in Oracle technologies, data warehousing, ETL, Exadata, and big data ecosystems, with strong analytical, performance-tuning, and system optimization skills. Adept at Agile delivery, cross-functional collaboration, and production support in mission-critical environments.

As a Senior Database Architect and PL/SQL Developer at Citi for over three years, I have focused on developing and enhancing automation frameworks to validate ETL transformations and business rules. My contributions include designing automation components for the CITI Drift application, streamlining ETL processes, and optimizing SQL and PL/SQL performance to ensure efficient data handling.

My core competencies lie in automation, database architecture, and advanced PL/SQL development, supported by a strong emphasis on performance tuning and collaboration within Agile environments. I am committed to delivering scalable and reliable solutions that enhance system efficiency and support critical business processes.

Core Competencies

Oracle Database Architecture & Development (8i–12c, EBS, R12, Exadata)

Oracle Data Integrator (ODI) 11g & 12c

Logical & Physical Data Modeling (ERwin, ER Studio)

Advanced SQL & PL/SQL Performance Tuning

Data Warehousing & ETL Processes

Financial Services, Market & Risk Data Systems

Agile / Scrum Methodologies

UNIX & Windows Environments

Professional Experience Highlights

Designed and implemented logical and physical database models using ERwin and ER Studio for large-scale enterprise applications.

Led system study, analysis, design, and development in complex client-server environments.

Analyzed business requirements and translated them into functional and technical design documents.

Worked extensively with Oracle Packages, Procedures, Functions, Triggers, External Tables, and Advanced PL/SQL constructs (Ref Cursors, Collections, Bulk Bind, Object & Record Types, XML functions).

Designed and implemented partitioned tables using Range, List, and Hash partitioning strategies.

Built and optimized batch processing frameworks using PL/SQL; developed unit tests using UTPLSQL.

Performed SQL and PL/SQL tuning using Explain Plan and TKPROF, significantly reducing query execution times.

Supported and enhanced ETL processes for data movement across source and target systems in data warehouse projects.

Executed large-scale data migrations using SQL*Loader and SQL Server migration tools.

Worked on migration projects involving SQL Server platforms.

Developed shell scripts, Perl scripts, and Python programs to support automation and data processing.

Delivered solutions on Oracle Exadata and OFSAA, supporting risk data aggregation, regulatory reporting, and batch processing.

Managed and monitored batch jobs using ESP, Autosys, and Control-M.

Troubleshot and optimized Oracle Advanced Queuing (AQ) systems; re-engineered applications to reduce load and response times.

Authored test cases, unit test plans, and conducted exploratory testing.

Strong experience with version control systems: Git, SVN, PVCS, Bitbucket

Actively participated in Agile/Scrum ceremonies including sprint planning, daily stand-ups, and retrospectives.

TECHNICAL SKILLS

Technical Skills: Oracle 12c/19c/20c, SQL, PL/SQL, Performance Tuning, UTPLSQL, Java, Informatica, Shell/Perl/Python scripting, SQL Loader, External Tables, Jenkins, AWS, Ansible Tower, GitHub, SVN, Bitbucket, UDM/Automation Framework.

Data & Reporting: Data modeling (Erwin, ER-Studio), DB GUI tools (Toad, SQL Developer), AxiomSL CV reporting, ETL development

Databases & ERP: Oracle, Vertica, PostgreSQL, SQL Server, EBS R12, Oracle Forms & Reports 9, Azure SQL, Scheduler,MongoDB

Cloud & CRM: Salesforce.com, Cloud integrations

Methodologies & Certifications: Agile, Waterfall; Oracle Certified Associate (OCA).

PROFESSIONAL EXPERIENCE:

Client - Citibank Inc, Dallas,TX 12/22 – Till Date

Sr.Data Base Archtecture and PL/SQL Developer

Extensively worked automation framework project for validating drift application and ETL transformations and Business usecases, duplication usecases,data truncation use cases, record level validation and generate reports for reducing errors, delivering quality product to customers.

Design and development of automation frame work project.

Re-design drift application ETL process and automated development of DB components required for drift application on going development.

Analysis and design and implement CITI Drift application changes using Oracle,PL/SQL.

PL/SQL - Writing Oracle Packages, procedure and functions for Drift application.

Creating new tables and adding new columns to existing tables and defining PK.

Attending scrum meeting, sprint planning, Grooming sessions and release planning in the Agile working environment.

Participating in design reviews and code reviews.

Participating Pre productions and Production deployments and fixing issues.

Query tuning and PL/SQL tuning.

Environment: Oracle 19c, SQL, PL/SQL,SQL Developer,Bitbucket,Unix,Automation Framework

Apple Inc, Austin,TX 02/22 – 11/22

Sr.PL/SQL Developer

Analysis and design and implement Radar application changes using Oracle,PL/SQL.

PL/SQL - Writing Oracle Packages, procedure and functions for Radar application.

Creating new tables and adding new columns to existing tables and defining PK.

Attending scrum meeting, sprint planning, Grooming sessions and release planning in the Agile working environment.

Participating in Design reviews and code reviews.

Participating Pre productions and Production deployments and fixing issues.

Query tuning and PL/SQL tuning.

Analysis, design and implementation of the business solution.

Involved in gathering user requirements along with Business Analysts.

Environment: Oracle 19c, SQL, PL/SQL,SQL Developer,GIT,Unix,RADAR

BNY Mellon, Pittsburgh, PA 9/14 – 01/22

Sr.PL/SQL Developer

• Prepared design documents and system flow diagrams based on Agile user stories in JIRA.

• Developed Oracle PL/SQL packages, procedures, and functions for Intraday Risk Measure processes.

• Worked with Snowflake: SnowSQL, SnowPipe, view redesigns for performance, continuous data loads, and cross-account data sharing.

• Developed batch frameworks, ESP jobs, shell scripts, and batch metadata setups; handled pre-production and production deployments.

• Created SQL queries, views for OBIEE reports, and performed query/PLSQL tuning.

• Gathered requirements with BAs, analyzed source systems, and created logical/physical data models using Erwin; designed dimensional data models with ETL/DB teams.

• Automated data modeling workflows (UDM) to reduce development time, generate DDLs, scripts, playbooks, and provide data lineage for business and development.

• Designed and implemented UTPLSQL processes for Oracle projects.

• Participated in Agile ceremonies: scrum meetings, sprint planning, grooming, design/code reviews, and release planning.

Environment: AWS,AZURE,Oracle 11g, SQL, PL/SQL, Java,TOAD, JIRA,SVN, Unix, ESP, Batch frame work, Batch Process, Pentaho, OFSAA,OBIEE, Erwin, Vertica, UTPLSQL,Microstrategy,ODI

Paypal, Hunt Valley MD 9/13 – 8/14

Sr. Database Lead Developer – Analyst

Developed a scalable, consolidated platform supporting domestic and international credit collections and integrated ROCA for legacy data overhaul.

•Supported PayPal wallet integration by shifting servicing philosophy from account-based to customer-centric.

•Prepared design documents, system flow diagrams (Gliffy), and ERDs (ER Studio) based on Agile user stories in Confluence.

•Developed Oracle PL/SQL packages, procedures, functions, triggers, and external table processes for ROCA batch jobs.

•Implemented UTPLSQL test packages for automated batch import/export testing and unit testing.

•Managed batch job execution using Control-M and version control with GitHub and SVN.

•Participated in Agile ceremonies, design/code reviews, and guided the team on best practices and processes.

Environment: Oracle 11g, SQL, PL/SQL, Java,TOAD, UTPLSQL, Rally(Agile),GIT,SVN, Work Space, Unix, Control M, Batch frame work, Batch Process, ER Studio.

Allscripts Healthcare, Atlanta. GA 06/12 –8/13

Sr. Database Lead Developer – Analyst

Worked on EBS 11i to R12 upgrade projects, preparing functional and technical documentation.

Developed PL/SQL packages, procedures, triggers, constraints, and SQL scripts for development and production environments.

Implemented MDRX CDH Master Synchronization and Business Event purge programs in Oracle PL/SQL.

Served as Migration Lead: consolidated code bundles, prepared migration patches, tested in QA, and coordinated production deployments with DBAs.

Created reusable SQL*Loader scripts and used FNDLOAD for migrating concurrent programs, request groups, menus, and responsibilities.

Conducted patch analysis, regression testing, and production migration planning.

Prepared mapping documents for data conversion objects, capturing translations and business rules.

Developed data conversion processes using UNIX scripts, and PL/SQL packages, procedures, and functions.

Loaded data from CRMOD to mapping databases and extracted converted data into CSV for Salesforce.com.

Managed data loads from SFDC to staging environments to identify relational information.

Performed unit testing on ETL loads and assisted in migrations.

Environment: Oracle Applications r12 12.1.3 (GL,FA,AR,AP,AOL), Oracle 10g, Reports 10g, TOAD, PL/SQL, FTP, SQL LOADER, SFDC, CDH, CRMOD, SOA, Oracle11g, SQL, PL/SQL, Windows-XP, Toad, SQL Loader, Salesforce.com

MTRS (Massachusetts-Teachers-Retirement-systems)Boston.MA 08/11 – 6/12

Database Consultant – Analyst

Designed and developed applications, prepared detailed design documents and technical specifications, and performed debugging and testing.

Prepared mapping documents for each data conversion module and developed data conversion processes using batch scripts, packages, functions, and procedures.

Conducted data validation and resolved QA issues.

Performed V3 GUI validation for data loaded into the V3 system.

Environment: Oracle11g, SQL, PL/SQL, Windows-XP, PLSQL Developer Tool, V3 Benefits Administration

Blue Cross Blue Shield, Boston., MA 04/10 – 08/2011

Senior Oracle Developer – Analyst

Designed and developed applications, including detailed design documents, technical specifications, debugging, and testing.

Performed data analysis and mapping using IDSPLUS and ADRM models; supported RTMS, COB, Huron, and Claims data.

Created databases, tables, indexes, sequences, partition/summary tables, and developed PL/SQL packages, procedures, and functions.

Wrote SQL for services, supported QA and database requests, and conducted ETL unit testing and performance tuning.

Environment: Oracle11g, SQL, PL/SQL, Windows-XP, UNIX, Shell Scripting, Toad, RTC, Work Site, QC.

Education:

M.C.A (Master of Computer Applications)

Languages: English, Telugu,Tamil, Hindi

Hobbies/Interests: Coding, Exploring Emerging Technologies, Data Analytics, Reading Tech Blogs, Chess, Traveling, Music, Social Service (Helping Humanity & Combating Hunger)

Contact this candidate