POORNIMA S

• Around 4 years of experience as an Oracle PL/SQL Developer, ensuring high availability and optimal performance of critical database systems. Proficient in SQL and PL/SQL, with a deep understanding of DDL, DML, DCL, and TCL statements for efficient database management. Expertise in writing complex queries involving Joins, Subqueries, Group Functions, Set Operators, Analytical Functions, Hierarchical Queries, and Pseudo Columns to handle diverse data requirements. Extensive experience in creating and maintaining database objects such as Tables, Views, Synonyms, Materialized Views, Sequences, and Indexes to ensure data integrity and accessibility. Skilled in developing advanced database components including Stored Procedures, Functions, Packages, and Triggers, and implementing features like Collections, Autonomous Transactions, and Exception Handling. Specialized in data migration using PL/SQL Procedures, Functions, and SQL
• Loader, ensuring smooth and efficient data transfer while maintaining system integrity. Strong working knowledge of Oracle-supplied packages, including UTL_FILE for file operations and DBMS_MVIEW for materialized view management, ensuring optimized data processing. Expertise in performance tuning through tools like Explain Plan, SQL Trace, and Hints, along with advanced techniques like Table Partitioning and Query Optimization to enhance query execution and database performance. Proficient in Bulk Collection, minimizing context switching and significantly improving performance for large data sets.

PL/SQL: CREDIT CARD MANAGEMENT

• Designed and developed a comprehensive Credit Card Management module in PL/SQL, enabling efficient transaction processing, account management, and fraud detection.
• Optimized database queries, reducing processing time by 30%, and improved system performance through effective indexing and partitioning strategies.
• Integrated real-time transaction validation and automated reporting features, ensuring seamless and accurate financial operations.

PL/SQL: TRADE APPICATION

• Developed and optimized a Trade Application module in PL/SQL, enabling seamless execution of buy/sell transactions and portfolio management.
• Implemented complex financial calculations and real-time data updates, improving trade execution speed and accuracy by 25%.
• Enhanced data integrity by designing efficient stored procedures for trade validation, reconciliation, and reporting.