shanmugapriyan Ponnadai

Berufserfahrung von shanmugapriyan Ponnadai

• Bis heute 7 Jahre und 10 Monate, seit Sep. 2016

  Senior Software Engineer

  DCUBS Technologies Private ltd

• 1 Jahr und 2 Monate, Okt. 2021 - Nov. 2022

  Senior Software Engineer

  CREDIT SUISSE

  - Analysed the business requirements of the project by studying the Business Requirement Specification document. - Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules. - Created database objects like packages, procedures, and functions according to the client requirement. - Experience in retrieving data from external data Files and loaded into oracle tables using tools like UTL_FILE, SQL*Loader and External Tables.

• 3 Jahre und 9 Monate, Jan. 2018 - Sep. 2021

  Senior PL/SQL Developer

  Alerus Financial Corporation ( Banking Application)

  - Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, DPA, SQL TRACE and DBMS_SQLTUNE. - Worked with Bulk Collect to improve the performance of multi-row queries by reducing the context switching. - Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan. - Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

• 1 Jahr und 4 Monate, Sep. 2016 - Dez. 2017

  PL/SQL Developer

  Deutsche BahnMar

  - Collaborated with the application developers in data modeling and E-R design of the systems. - Also created, modified, maintained and optimized SQL database. - Maintained the documents and create reports for the business analysts and end-users. - Created Materialized views & views where business requirements needed. - Developed scripts for checking oracle errors in alert log and trace files.