Senior Software Engineer with 5 years in IT industry with experience handling full life cycle of software projects from inception to post-implementation.
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 creating SQL objects like Tables, Views, Sequence, Synonyms and Indexes.
Expertise in DDL, DML, DCL and TCL statements.
Extensive experiencein writing complex queries using Joins, Sub Queries and various AnalyticalFunctions.
SQL Loader for using transfer data from flat file to oracle database.
Fine-tuned SQL Queries using hints for maximum efficiency and performance.
Developed Complex database objects like Stored Procedures, Functions,Packages and Triggers using SQL and PL/SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Experience in Oracle supplied package UTL_File and XML_Gen.
Extensively used Bulk Collection in PL/SQL objects for improving the performing.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Good knowledge about UNIX Commands.
May 2017 - Present
Application, delivers trade by trade visibility into interactions, involving users to communicate with the share market trading, to buy and sell shares, transfer cash from bank to our financial services trading application. We can check the trading limit, we can track the orders and the trades that has been done so far, the amount that is available in our wallet viewing the day’s trade history in the view digital transactions and withdrawing the cash from account to our bank account. It monitors mutual funds trading, employee trading, and investment advisor compliance.
December 2015 - April 2017
This project is designed and developed for Telecom Company called AT&T Telecom which is a telephony and broad band internet service provider and this project is in the production. Purpose of this application is to support their Employees for their Day to day Release, Delivery Order processing requirements, Customer Payment Details. We are using two modules one is OSS and another one is BSS. Here OSS to analyze which service providers suitable for their customer locations. I am currently working in Operational Support System here customer care maintains all the details about customers and their records.
2010 - 2014
sql loader PL/SQL SQL Linux UTL_File
Tamil — Native or Bilingual English — Professional
Senior Software Engineer with 5 years in IT industry with experience handling full life cycle of software projects from inception to post-implementation.
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 creating SQL objects like Tables, Views, Sequence, Synonyms and Indexes.
Expertise in DDL, DML, DCL and TCL statements.
Extensive experiencein writing complex queries using Joins, Sub Queries and various AnalyticalFunctions.
SQL Loader for using transfer data from flat file to oracle database.
Fine-tuned SQL Queries using hints for maximum efficiency and performance.
Developed Complex database objects like Stored Procedures, Functions,Packages and Triggers using SQL and PL/SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Experience in Oracle supplied package UTL_File and XML_Gen.
Extensively used Bulk Collection in PL/SQL objects for improving the performing.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Good knowledge about UNIX Commands.
May 2017 - Present
Application, delivers trade by trade visibility into interactions, involving users to communicate with the share market trading, to buy and sell shares, transfer cash from bank to our financial services trading application. We can check the trading limit, we can track the orders and the trades that has been done so far, the amount that is available in our wallet viewing the day’s trade history in the view digital transactions and withdrawing the cash from account to our bank account. It monitors mutual funds trading, employee trading, and investment advisor compliance.
December 2015 - April 2017
This project is designed and developed for Telecom Company called AT&T Telecom which is a telephony and broad band internet service provider and this project is in the production. Purpose of this application is to support their Employees for their Day to day Release, Delivery Order processing requirements, Customer Payment Details. We are using two modules one is OSS and another one is BSS. Here OSS to analyze which service providers suitable for their customer locations. I am currently working in Operational Support System here customer care maintains all the details about customers and their records.
2010 - 2014
sql loader PL/SQL SQL Linux UTL_File
Tamil — Native or Bilingual English — Professional