SAURABH PATHAK

Project: FastTrack Application (ICICILOMBARD)
PLSQL Developer
Project Details:

• Basically, FastTrack application is used from intimation of claim to till final payment done for claim.
• It is web-based application that uses Dot Net technology and also uses Oracle as database.
• It has n-numbers of procedures that are used in this application.

Role and responsibilities:

• To create or modify or check procedures, triggers, functions, and jobs for APIs.
• We are also responsible for creating or maintaining database components of FastTrack application that uses the Oracle technology stack.
• Developed or customized Oracle reports and forms to meet functional business requirements.
• Customized or developed Oracle workflows to meet company business processes.
• Implementing the data model required by the FastTrack application.
• Providing reports (mostly CSV format) from the backend as per user request.
• Solving unexpected error which occurs at user-end here we check the error through error log or string log file and provide a solution or RCA on the it.
• At every month-end, we have a task to provide control scripts that are used to remove all the stuck cases.
• And also to provide queries to the support team for modification at the database level.

About Company:
Basically Teknikforce is creating paid and free plugins which are used on WordPress websites.
Role and responsibilities:

• As per given we need to create plugin as per business requirement.
• We start from scratch using core PHP and for database we use MySQL.