Activities
• Designed and developed more than 5 complex PL/SQL packages from scratch with more than
20K line of code using all the advanced concepts like records, collections, bulk collect, cursors,
triggers, ref cursors etc in the Business Intelligence project environment.
• Designed and developed various ETL processes as per the business requirements.
• Carried out performance tuning activities to reduce the time by more than 50% of various SQL
scripts using indexes, oracle hints.
• Developed various SQL scripts and PL/SQL blocks to generate complex and huge XML files of
up to 4GB from Oracle RDBMS.
• Designed various new ETL processes t