Solid experience in translating business requirements into creation of Database Objects.
Strong exposure in writing simple and complex SQLs, PL/SQL functions and procedures, Packages and creation of oracle objects- Tables, Synonyms, Triggers, Views etc.
Extensive experience on using SQL, PL/SQL, Oracle Database, and many other oracle facilities like SQL * Loader and SQL*PLUS.
Have sound knowledge on Financial Markets/Banking Domain.
Proficient in writing complex SQL Queries, Stored procedures, database design, creating indexes, functions, triggers, sub queries
Highly skilled in Performance tuning – analyzing query plans and query tuning using tools such as EXPLAIN PLAN and use hints wherever required.
Experience in advanced PL/SQL concepts like Bulk collect and forall.
Strong experience in Data Modeling using Toad Data Modeler/Erwin.
Good experience in ETL using PL/SQL.
Extensive experience in Data Synchronization between Multiple High Volume systems using Oracle PLSQL
Experience in development/tuning of highly responsive banking system
Expertise in optimizing SQL statements