Oracle PL/SQL Developer

• Dec 2017 - Present

• Developed System using PL/SQL packages, procedures, triggers, functions, Indexes and Collections to Implement business logic using Oracle Developer and toad. • Designed, developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems. • Investigated data quality issues and implemented appropriate solutions. • Helped to improve the performance, scalability and stability of database systems. • Identified and implemented programming enhancements. • Developed technical system documentation. • Understanding and Collecting requirements from Business user side or Business Analyst and to Convert that requirement to SQL queries or PL/SQL. • Convert the business need in to Technical complex queries. • Use different strategies of database development to meet the client functional requirement. • Work with SQL and PL/SQL programming, developing complex code. • Creating Pl/SQL packages, procedures, Functions, Triggers, Views and Exception handling For retrieving, manipulation, checking and migration complex data sets in Oracle. • Creating the indexes on tables and partitioning the table for SQL tuning purpose. • Writing procedures, functions, views, materialized views as required. • Writing complex SQL queries for reporting purpose. • Support the users of application with using multiple SQL and PL/SQL techniques • Support all day to day activities related to database like data consolidation, data Migration scripting. • Creating complex views, materialized views on multiple table as per customer Requirement. • Used PL/SQL Tables, Cursors to process huge volumes of data and used bulk Collect for mass update as performance improvement process. • Migrated data from flat files to tables using SQL*Loader. • Work with Data migration using import and export user excepting • Manage unit testing for UAT Show less

PL/SQL DEVELOPER

• Aug 2016 - Nov 2017