Suryanarayanan I

Having 9+ years of experience 5+ years of experience as PLSQL Developer & 3+ years of experience in Application Support. Expertise in Client-Server application development using Oracle 11g/12c

PLUS, PLSQL Developer and ServiceNow. Involved in all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Development, Testing, Implementation and Maintenance with timely delivery against aggressive deadlines. Excellent skills in Functions, Stored Procedures and Packages. Experience in Oracle creating packages, Records and PL/SQL Tables. Creation/modification of schema objects like Packages, Procedures, Functions, Triggers, Views, Materialized Views, and Sequences. Strong Proficient in SQL and creation/modification of database objects like Synonyms, Group Functions, Views, Index. Experience in using DDL, DML, DCL, TCL commands. Familiar in writing Joins, Sub-queries, Single Row Functions.

Experience in Collections and Exception Handling. Excellent skills in Production support activities. Have experience in handling Change request and Incident request, Problem Tasks, User Requests. Experienced in handling Major Incident Management (MIM) like Coordinating the bridge, hosting, outage communications, updating issue status. Experiences in Creating Incidents, Requests, Problem tasks and CR.

Meticulous Technical Lead strictly adheres to both client-provided technical requirements and internal business goals. Balances project prioritization to fulfill both contractual obligations and internal revenue requirements. Provides foresight and management designed to grow satisfied customer bases and revenue figures.

Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Preparation of Logical and Physical design documents for the source code impact., Creating Procedures, Functions, Packages, Views and Mviews as per given requirements., Extensively used Bulk collect, Bulk Bind & PL/SQL Collections., Debugging the code using tools and prepared the root cause analysis for fix., Understanding the client Project requirements and prepared Detailed Design Document and Impact Analysis Document., Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data., Developed PL/SQL Packages, Procedures, Functions, Indexes and Collections to implement business logic., Conduct research and find solutions for complex technical problems., Implementing several triggers to maintain Database Security by auditing log table to track information about users., Writing complex SQL queries including sub queries for faster data retrieval from multiple tables., Involved in the continuous enhancements and fixing of production problems., Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines., Used Pragma Autonomous Transaction to avoid mutating problem in database trigger., Extensively used the advanced features of PL/SQL like Records, Tables and Dynamic SQL., Handling errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application., Having good knowledge in Performance Tuning concept for improve the application performance., Raising tickets in Service Now according to the issue., Providing second level support in troubleshooting issue., Updating project requirements by participating in meetings and studying existing System., Issues raised by chat/mail/phone calls from retail clients or institutional clients., Supporting Developers by involving in their production., Provided hot fixes for various production issues and monitored end of day process after market close to generate transact file on a daily basis., Monitoring the application like CPU usage, memory capacity, performance of the application etc., Environment: ITIL, ServiceNow, L1.

• Father's Name: Iyappan.CP
• Date of Birth: 01/09/1993
• Gender: Male
• Nationality: Indian
• Marital Status: Single

• Health Net, Process Executive, Insurance
• Citi Bank, Technology Support Specialist, Banking
• BOFA, Technology Support Specialist, Banking
• Ford, Senior software engineer, Logistics