Application Specialist - Information Technology - Mumbai - Lodha (I-Think Techno Campus) - JM

Expertise in the areas of PL/SQL.

• Having ability to manage Production / Application Support to various Live Application.
• Good knowledge about financial /Lending domain.
• Good knowledge of FinnOne backend and frontend.
• Having good knowledge of Pennant Lending Platform.
• Proficient in Sequences and Synonyms.
• Having good knowledge of Predefined SQL Functions.
• Expertise in development of PL/SQL Stored Functions, Packages, Procedures, cursors, Collections.
• Good knowledge of Referential integrity - Primary Key, Foreign Key, Constraints etc.
• Creating database users and assigning roles, privileges and profiles to users.
• Good Hand on creating database objects Like Views, Indexes, Sequences, Tables.
• Good knowledge about Sub queries.
• Having good knowledge of PL/SQL Cursors, Triggers.
• Good knowledge of implementing DML, DDL, Instead of, Compound Triggers.
• Hands on data base table Partitioning.
• Good knowledge of Optimization and tuning.