With more than 10+ years in the information technology industry, has a wide range of experience providing project and account management experience and is seasoned in developing, documenting, coding, modifying, testing and implementing business technology solutions.
Overview
11
11
years of professional experience
6
6
years of post-secondary education
2
2
Languages
Work History
Senior Software Engineer
Deutsche Bank Ltd
Chennai
08.2022 - Current
Wring the queries as per business requirement and work on query performance tuning.
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
Created database objects like tables, sequences, views, materialized views, Triggers etc.
Loaded the data into database tables using SQL loader from text and excel files.
Carried out performance tuning on queries and Plsql blocks in order to improve the performance.
Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in the database.
Experience in PL/SQL Collections, Bulk Collect and Pragma Autonomous Transaction.
Expertise in Cursors, Exception handling and Oracle Supplied Packages.
Senior Software Engineer
Telefonica UK Ltd, Tech Mahindra Ltd
Chennai
03.2021 - 08.2022
Wring the queries as per business requirement and work on query performance tuning.
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
Created database objects like tables, sequences, views, materialized views, Triggers etc.
Loaded the data into database tables using SQL loader from text and excel files.
Carried out performance tuning on queries and Plsql blocks in order to improve the performance.
Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in the database.
Involved in implementing the data integrity validation checks through constraints and triggers.
Created SQL Loader control files for moving the data from flat files to staging area tables.
Worked on performance issues and used the EXPLAIN PLAN for tuning the queries.
Developed code with discussion from Front end users.
Senior Software Engineer
State Street, Atos Syntel Pvt Ltd
Chennai
12.2018 - 12.2020
Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
Created database objects like tables, sequences, views, materialized views, Triggers etc.
Loaded the data into database tables using SQL loader from text and excel files.
Carried out performance tuning on queries and Plsql blocks in order to improve the performance.
Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in the database.
Involved in implementing the data integrity validation checks through constraints and triggers.
Created SQL Loader control files for moving the data from flat files to staging area tables.
Worked on performance issues and used the EXPLAIN PLAN for tuning the queries.
Developed code with discussion from Front end users.
Senior Software Engineer
Wire Card Bank, Geetham Software Pvt Ltd
Chennai
11.2014 - 11.2018
Created database objects like tables, sequences, views, materialized views, Triggers etc.
Experience working in 24/7 IT Production Support Projects.
Loaded the data into database tables using SQL loader from text and excel files.
Carried out performance tuning on queries and plsql blocks in order to improve the performance.
Created SQL Loader control files for moving the data from flat files to staging area tables.
Developed code with discussion from Front end users.
Worked on performance issues and used the EXPLAIN PLAN for tuning the queries.
Education
M.Tech - Mechatronics
VIT University
Vellore
05.2012 - 05.2014
Bachelor of Engineering - Electrical And Electronics Engineering
Panimalar Engineering College Anna University
Chennai
05.2007 - 05.2011
Skills
Oracle Sql
undefined
Skills Summary - Skills
Oracle Sql, 6, 4
Plsql, 6, 4
Unix, 5, 3
Performance Tuning, 4, 3
Experience Years
10
Technical Specializations
Oracle Sql
PlSql
Unix
Languages
English
Bilingual or Proficient (C2)
Tamil
Bilingual or Proficient (C2)
Timeline
Senior Software Engineer
Deutsche Bank Ltd
08.2022 - Current
Senior Software Engineer
Telefonica UK Ltd, Tech Mahindra Ltd
03.2021 - 08.2022
Senior Software Engineer
State Street, Atos Syntel Pvt Ltd
12.2018 - 12.2020
Senior Software Engineer
Wire Card Bank, Geetham Software Pvt Ltd
11.2014 - 11.2018
M.Tech - Mechatronics
VIT University
05.2012 - 05.2014
Bachelor of Engineering - Electrical And Electronics Engineering
Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)Assistant Vice President at Deutsche India Private Limited (Deutsche Bank Group)
Business Process Lead | AML Investigations & Compliance at Tata Consultancy ServicesBusiness Process Lead | AML Investigations & Compliance at Tata Consultancy Services