MANIMARAN V R

• ➢ Project : Ageas federal life insurance.
• ➢ Role : Oracle Database Developer.
• ➢ Project Name : Ageas federal life insurance.
• ➢ Organization : Majesco software and solutions.
• Project Description:
• • Ageas federal joint venture is for Bancassurance between India’s youngest new generation public sector bank IDBI Ltd with Fortis, an international financial services provider engaged in banking and insurance in over 50 countries of the world and Federal Bank
• • Ageas federal life insurance can be easily integrated with external systems such as Customer Portal through Web service interface to accept and process online policy servicing requests as well as processing of renewal premiums paid online.
• Responsibilities Managed :
• • Involved in Data Migration Process and Data Extraction.
• • Worked on New requirement of Development and End to end process.
• • Developed on new procedure and packages development as per the requirement.
• • Involved in complex query implementation and setup preparation.
• • Explore the functional flow of the project and involved in preparation of setup.
• • Preparing the ITP results based on unit testing.
• • Involved in CR Development process.
• • Interaction with Client based on the business Requirement.
• • Explore the new business flow for proposal to policy.
• • Involved in creation of different formulas based on the Products.
• • Involved in preparing the rates setup defined for the products.
• • Developing and optimizing stored procedures and functions to encapsulate complex business logic and improve database performance.
• • Code Review and Documentation: Reviewing and providing feedback on code written by other developers, as well as documenting code, processes, and system changes.
• • Application Support: Collaborating with cross-functional teams to troubleshoot and resolve issues related to PL/SQL code, database functionality, and application performance.
• • Debugging and Troubleshooting: Identifying and resolving issues related to Oracle databases, SQL queries, PL/SQL code, or application functionality. Utilizing debugging tools, error logs, and diagnostic techniques to diagnose and fix problems.
• Designed and implemented scalable applications for data extraction and analysis.
• Developed conversion and system implementation plans.
• Key Achievements:
• • Successfully Implemented and executed the data migration process, ensuring a seamless transition and minimal disruption to business operations
• • Played a key role in the development of new procedures and packages, contributing to enhanced system functionality and efficiency.
• • Implemented complex queries, resulting in improved data retrieval speed and overall database performance.
• • Received positive feedback from clients for effectively managing and delivering on new development requirements.

➢ Project : Bank Melli Iran.
➢ Role : Production Support & PL / SQL Developer.
➢ Project Name : Bank Melli Iran.
➢ Organization : Itrust Soft Solutions.

Responsibilities Managed :
• Developed various PL/SQL objects like procedures, functions, packages, and triggers in accordance with the business needs.
• Loaded the data into database tables using SQL loader from text and excel files.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Implemented SQL and PL/SQL stored procedures. Designed and developed Oracle PL/SQL batch and real-time processes for loading data from internal and external systems using SQL Loader and External tables.
• Developed Procedures for an efficient error handling process by capturing errors into user-managed tables.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.

Key Achievements:
• Streamlined the error handling process by developing procedures, leading to a significant reduction in system downtime and improved data accuracy.
• Achieved successful data loading using SQL Loader, enhancing the efficiency of database updates and ensuring data integrity.
• Implemented SQL and PL/SQL stored procedures, contributing to improved system stability and reliability.

• Optimized database structures for efficient data storage and retrieval.
• Optimized dust, temperature and humidity controls for installed systems.