Oracle Developer
Current• Responsible for writing PL/SQL procedures, Triggers, and other database objects like Table, Constraints, etc.• Involve in creating screen using Oracle Apex and Oracle Forms 6i• Involve in the support, maintenance and development of ERP integrated systems.• Involve in the development and maintenance of printing Module based on Oracle Forms & Report 6i• Involve in the creation of Case Management system from the scratch based on Oracle Apex 19.1 & 11g DB.• Developing different types of document print based on Oracle reports 6i &11g.• Involve in UAT testing for the new development or new feature in the life system• Involve to develop MIS report using Oracle Apex (19.1)• Involve to create Tables, constraints views, Procedures, Functions, Views, Triggers, Synonyms ,Sequences and other SQL scripts based on Development requirement• Involve to create SQL scripts to update/correct data based on user requirements• Involve to create new screen /reports as per Health Claim department using D2K and Oracle Apex.• Involve in Create users, grant access/rights in ERPs (Life system as well AMAN and Apex) post approval from the • management• Writing scripts to share claim and production data based on user and auditor requirement• Involve to download data from TATSH system and pulling to core system• Involve to providing daily support to departments using (AMAN Insurance Management System)• Involve to creating user manual for the newly developed screen and circulate to concerned departments• Involve to creating MIS reports based on Oracle Apex 19.1• Providing daily support via phone call & emails • Involved in Financial year-end closing process – Accounting and Medical dept.• Involved in Month end closing process - confirmation, posting and reconciliation support• Based on requirement working on NEXtCARE and NAS TPA portal / ssytems
