RESUME
SURYA BASKAR
************@*****.***
**, ********* ******* ********,
Tamilnadu (dist) - 600014
Objective:
Aspirant for a position in an organization where I can contribute my skills for organization’s success and synchronize with new technologies while being resourceful, innovative and flexible.
PROFESSIOINAL SUMMARY:
Nearly 1 years of experience in the Oracle PL/SQL Developer/Production Support experience in software analysis, design, development, testing and implementation of full life cycle web based software applications.
Created Tables, Views, Constraints, Index
Work experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.
Expert in query optimization and exposure using Hints, GTT.
Expertise in loading data using SQL*Loader.
Export and Import Database level or Schema level by using SQL Loader.
Expertise in Client-Server application development using Oracle 11g/10g, PL/SQL, SQL *PLUS,TOAD and SQL DEVELOPER.
PROFFESSIONAL EXPERIENCE:
Working as a PLSQL DEVELOPER for “VIRTUSA POLARIS” from Oct ‘18 to April ‘19
Working as a APPLICATION SUPPORT for “CITI BANK” from MAY ’18 to Oct ‘ 18
EDUCATIONAL QUALIFICATION:
Completed B.E (Computer Sceince) from S.R.R Engineering College with 65%.
Completed HSC from S.V.M Higher Secondary School with 77%.
Completed SSLC from S.V.M Higher Secondary School with 77%.
TECHNICAL SKILLS:
Languages
: SQL,PLSQL,UNIX,
Database
: Oracle 10G,11G
Tools
: SQL Developer, Toad, SQL*Plus
Operating System
: Windows, Linux
Professional Experience
Employer: Polaris, Chennai
May 2018 – April 2019
Role: Software Engineer
Applications: ITRS, Reconciliation Services, Service now, Global Support for CITI.
Project #1:
Client Name
: Citi Bank
Project Name
: GRU
Role
: Application Support
Duration
: May 2018 to Oct 2018.
Responsibilities :
Monitor the metric alerts, performance related issues like high CPU utilization, Application performance, high Memory utilization, Application tuning and Query tuning
Monitor the event alerts and notify to the concerned team and process the requests from the end users to level 2 and level 3 support engineers.
Monitor the availability of the Database events like DB availability, Instance availability and the space availability of disk drives and file systems.
Monitor the Oracle Alert logs files, transaction logs and backup logs.
Monitor the database related activities, respond calls from the Application support and developments teams.
Monitor the backups, recovery errors, respond to the request regarding the restoration of the DB
Record and classify received Incidents and undertake an immediate effort in order to restore a failed IT Service as quickly as possible.
Assign unresolved Incidents to appropriate Tier 3 Support Group.
Log all Incident/Service Request details, allocating categorization and prioritization codes.
Calculating baseline thresholds from historical network performance data
Determine if changes in end-user experience are caused by the application or the network.
Customizing Web-based Banking performance dashboards, views, and charts
Real-time ITRS performance analysis with interactive charts and graphs from global devices.
Verify resolution with users and resolve Incidents in ITSM tool.
Escalate Incidents at risk of breaching Service Level Agreement to the Incident Process Coordinator
Determines if an incident needs to be escalated according to priority and severity of issue.
Escalate Major Incidents to the Incident and/or Problem Manager
Good Experience with the routine server health checks by using performance and analysis tool.
Hands on experience in the server monitoring tools and checks the server health
Project #2:
Client Name : Cover –All (AIG group of insurance US)
Project Name : Insurance Application Development and Maintanence
Role : Software Engineer
Duration : Oct 2018- April 2019
DESCRIPTION
This project involves development and testing of web-based insurance application. It includes all P&C lines of ISO and Non ISO insurance product like Commercial Auto, General Liability, Commercial Property, Umbrella etc. All the products are configured through Proprietary tool Dev Studio. It involves developing UI, Premium calculation through rating functions, workflow management, configuring underwriting rules, Validations, mapping of policy documents and managing different policy life cycles.
Responsibilities:
Responsible for developing UI, Premium calculation through rating functions and procedures, workflow management, configuring underwriting rules, Validations, mapping of policy documents and managing different policy life cycles.
Responsible to Write PLSQL procedures/Functions.
Responsible to write complex queries to import customer expected reports.
Responsible for Defect Analysis.
Responsible for Impact Analysis .
Responsible for doing unit testing of code after each deployment.
Responsible for providing support to customers which are live.
Responsible for the designing the advance SQL queries, procedure, function, package, cursor, triggers, scripts.
Developed SQL*loader scripts to load data in the custom tables
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the applications
Certifications
•Certified on Oracle Certified Junior Associate(OCA), NIIT Chennai
PERSONAL PROFILE:
Father’s name : P.Baskar
Gender
:
Male
Marital Status
:
Single
Date of Birth
:
15/04/1993.
Languages Known : English, Tamil.
DECLARATION:
I hereby declare that all the details furnished above are true to the best of my knowledge.
DATE :
PLACE :
(SURYA BASKAR)