Prabakaran Kothandan

Experienced developer seeking dynamic work environment to utilize skills in SQL, PL/SQL, MySQL, and ETL. Committed to upholding professional standards and contributing to company's growth and personal development. With 5 years of expertise in web-based software application full life cycle analysis, design, development, and deployment. Strong knowledge of Oracle 10g/11g tools and MySQL, SQL, and PL/SQL with dbeaver. Successfully worked in all phases of Software Development Life Cycle (SDLC) from analysis to maintenance, consistently delivering projects on time against aggressive deadlines. Proficient in optimizing multilevel MySQL queries using JOINS and implementing effective ARCHIVE methodologies in latest versions of MySQL Server. Skilled in ETL operations to retrieve and upload data from various databases in required file formats. Experienced in migrating data between databases using primary database tools like SQL Developer and dbeaver. Proficient in developing complex database objects such as STORED PROCEDURES, FUNCTIONS, COLLECTIONS, PACKAGES, and TRIGGERS using MySQL, SQL & PL/SQL. Familiar with developing MySQL SCHEDULED EVENTS for data archival in distributed environments. Strong ability to handle large volumes of data using MySQL. Excellent communication and interpersonal skills enable excel both individually and as team player.

Projects Name: Telsim, eSIM Australia, Crown Mobiles.

Domain: Telecommunication

Technology: MySQL 8.0

Since: 03/2023 to Present

Responsibilities Handled:

• Create Business Requirement Document as per request.
• Highly experienced in MySQL DDL,DML,DCL and TCL operations.
• Monitor DATABASES AND ITS FUNCTIONALITIES on a regular basis.
• Optimize MYSQL QUERIES used for reports in the admin portals.
• Proficiently perform ETL operation to extract data from various sources.
• Data transform from one database to another as part of ETL operations, Load huge data into databases from given files of different formats using tool features.
• Archive logs using MySQL EVENT SCHEDULER, Retrieve ARCHIVED DATA as per request, Perform loading and downloading bulk data using tools
• Create and optimize queries using JOINS as per requirements, Identify and use correct OPTIMIZATION TECHNIQUES to load and retrieve data effectively from databases
• Handle multiple project DATABASES at a time and ensure smooth running of the system, Critical change requests handling as per client requests

Project Name: Capital one.

Domain: Banking.

Technology: PL/SQL

Since: 09/2020 to 03/2023

Responsibilities Handled:

• Interact with onshore counter part and understand BRD(Business Requirement Document), Understand the WR(Work Request) or CR(Change Request) assigned as per the client requirement.
• Create STORED PROCEDURES, FUNCTIONS, PACKAGES based on the requirement
• Expertise in error handling using EXCEPTIONS
• Provide extended hand to handle Application Support
• Used different types of PL/SQL DATA TYPES and CONSTRAINTS to restrict data entries into various tables.
• Experience in handling PERFORMANCE TUNING techniques like generating Explain Plan for, Checking for INDEXES, PERFORMANCE TUNING by checking AWR Report, Extended knowledge in DBMS_Profiler.
• Experienced in Batch Monitoring using AUTO SYS tool.

Project Name: Northern Trust.

Domain: Investment Banking.

Technology: SQL

Since:  08/2018 to 09/2020

Responsibilities Handled:

• Interact with business analyst and understand the Business Requirement Document.
• Write complex queries and execute based on client requirements
• Create and manage tables using DDL Operations in SQL Engine.
• Performed in multiple table manipulation activities using operators like INSERT, DELETE, UPDATE.
• Experienced in using GROUP FUNCTIONS.
• Worked NUMBER FUNCTIONS to manage with decimal numbers and integers.
• Used PSEUDO COLUMNS as predefined columns to produce table date effectively.
• Expert in JOINS to handle multiple columns of multiple tables at a single time.
• Used SUBQUERIES and their TYPES to handle numerous SQL queries in a single query.
• Change or give alias name for tables and restrict access using SYNONYMS
• Change or give alias name for tables and restrict access using SYNONYMS.
• Performed COMMIT, ROLLBACK and SAVEPOINT using TRANSACTION CONTROL LANGUAGE(TCL), Increase performance by decreasing number of validations of a query by using INDEX.