pasam vijay

software engineer

• Job Details:reviewed, developed and optimized pl/sql stored procedures, functions, triggers, and packages for insurance applications. designed and maintained insurance domain-related modules, including policy management, claims processing, and underwriting systems. experience in writing and optimizing complex pl/sql queries, joins, views, and indexes to enhance database performance. collaborated with business analysts, qa teams, and application developers to enhance system functionality. implemented data migration, backup, and recovery strategies to ensure system reliability. validated data from abacus and generated policy/endorsement-level reports. provided production support, troubleshooting issues, and conducted root cause analysis. worked on performance tuning and query optimization of database-related issues. provided production support for critical insurance applications and resolved database performance issues. performed and verified post deployment activities. generated premium and commission reports, integrating with sap for accounting. provided constant support to l1 team in closing all interactions on time. developed data migration and transformation scripts for system upgrades and integrations. provided complete analysis on issues identified to the application team with logs. created multiple batches which helped in reducing the time for time consuming activities. creating indexes on tables to improve the performance with db team support. handled month closing activities and successfully done re-conciliation for every month. performed audit trail and successfully completed in doing 1year accounts auditing. constantly provided support for business team during board meetings. scheduled db jobs which helped in optimizing production issues. performed post database server version upgrade activities and monitored application functionality. deploying fix for production issue, resolved tickets on time, monitored disk space, identified missing indexes. created sop’s on corporate products. performed root cause analysis(rca) of data-related issues and delivered timely solutions. performed policy syncing activities and analyzed issues during syncing. identified xml issues and helped data team in optimizing xml issues. created documents on multiple corporate process which helped user in understanding the flow.