Tamilarasan P

Results-driven professional with expertise in Oracle PL/SQL developer, showcasing a proven track record and recognized for Backend Integration and Analysis. Eager to contribute skills and drive success in a dynamic work environment. Strategic Software Engineer skilled in application development, testing and optimization. Excels at coordinating ground-up planning, programming, and implementation for core modules. Maintains strong object-oriented and software architecture fundamentals. Proactive and versatile professional with a dedication to quickly adapting to new challenges. Strong problem-solving abilities and a proven track record of fostering strong relationships with clients and team members. Focused on supporting team success and achieving positive results.

• Tamil, Native
• English, Professional

Oracle 11g (SQL and PLSQL), 

Oracle PLSQL Developer,

ClearCase Version, 

• Over 2.5 years of programming experience as an Oracle PL/SQL developer.
• In-depth knowledge of SQL statements such as DDL, DML, TCL, and DCL.
• Proficient in utilizing tables, views, indexes, constraints, and sequences
effectively.
• Strong understanding of joins, subqueries, and writing complex queries.
• Good knowledge in stored procedures, functions, packages, exception
handling, and triggers using SQL and PL/SQL.
• Skilled in utilizing cursors, loops, and bulk collect in PL/SQL
subprograms.
• Microsoft SQL Server Expert: Proficient in database design and
optimization.
• Query Optimization Experience: Skilled in improving database
performance.
• Generated reports using utl_file based on client requirements.
• Excellent communication, interpersonal, and analytical skills with a
strong ability to work as part of a team.

• Involved in the entire project life cycle.
• Interacted with clients to understand their requirements.
• Conducted thorough reinsurance validation check points to ensure accuracy and compliance with established guidelines.
• Reviewed and analyzed reinsurance contracts and associated documentation to validate terms, conditions, and calculations.
• Monitored and reported on reinsurance data and calculations, identifying potential issues and recommending corrective actions.
• Calculated LOB-wise BRDW (Business Revenue Data Warehouse) and performed businesswise checkpoint validation monthly, submitting results to the finance team.
• Analyzed SQL statements and designed indexes to improve query response.