➢Total IT experience of 9 years as Oracle PL/SQL development with extensive experience in Insurance, Banking and Finance, Aviation and Telecom domains in the field of Software Development.
➢ Excellent conceptual knowledge of Exadata/12c/11g/10g/9i, PL/SQL, SQL *PLUS, SQL Developer, TOAD, PL/SQL Developer.
➢ Extensive experience in developing, troubleshooting, Implementing and performance tuning of Oracle Procedures, Materialized View, Functions, Triggers, Packages, Cursors and complex and hierarchical queries.
➢ Hands on experience in data warehouse concepts, data modeling and schema design techniques such as Star, Snow Flake and multi-dimensional analysis using OLAP.
➢ Experience in query optimization, performance and tuning using Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning.
➢ Experience in SQL and PL/SQL programming, oracle architecture and database design. The projects that I have worked on uses various other technologies & tools such as ETL Informatica, Shell Scripting, Unix,
Autosys.
➢ Experience in designing business requirements and modeling using Erwin.
➢ Experience in developing Joins, Indexes and sequences.
➢ Significant experience in Tableau, Unix shell scripting, Informatica and Autosys.
➢ Worked on data migration of legacy system from Sybase to Oracle.
➢ Has complete knowledge of SDLC and worked in Onsite-Offshore model.
➢ Significant knowledge on database administration.
➢ Managing timely delivery of highly qualitative deliverables
➢ Involved in production support activities like batch handling and monitoring.