Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Timeline
AccountManager

Prasanth V

Oracle Plsql Developer
Chennai

Summary

Having 11.7 years of experience in Oracle SQL, PL/SQL, Application Development. Worked in Finance, Healthcare, Banking Domains and created various applications and structured datamart using Plsql. Having 1yr of relevant work experience in HDFS concepts and handled tools like Sqoop for data import and export to Hadoop system & Handled Data frames using Scala. Currently associated with Abudhabi Commercial Bank as Oracle PLSQL Developer. Proficient in Writing & Executing SQL & PL/SQL queries to interact with DB for Data validations. Expertise in SQL, PL/SQL code Development Having experienced knowledge in writing, testing and implementation of the SQL queries and PL/SQL Stored Procedures, Cursors, Functions and packages. Having experience in fine-tuning & optimizing SQL queries to test for performance improvement and developing PLSQL applications. Having experience in all aspects of SDLC including Analysis, Design and Development, Implementation and Operational support for IT applications. Proficient Knowledge in handling Tools like Toad for Oracle, SQL Developer, PL/SQL developer, TOAD. Recent Acheivements :- 1. Designed and Developed UAE's Highly used Cobrand Credit Card Talabat & Cashback 365 Loyalty System and made it successful within the agreed timeframe without any hassle. Launch, Planning and Development was highly appreciated and turned out to be a big Profitable Product for the Bank 2. Worked as a team in creating in House Health Insurance Product for UAE National's Government Health Insurance DAMAN. Amidst the hectic deadline, Completed the Project successfully with a greater team effort of pulling a huge work.

Overview

12
12
years of professional experience
4
4
years of post-secondary education
2
2
Certifications

Work History

Senior System Analyst

Abudhabi Commercial Bank
12.2024 - Current
  • Requirement Understanding in automating the manual financial consolidation process directly with the business team
  • Develop and Design entire customer base for each of the consolidation modules
  • Phase Wise automation of modules and giving constant updates to the business
  • Creating structured plsql packages, tables, procedures and perform optimization of huge data while developing
  • Coordinate with different stakeholders, ETL team, Dot Net Team to ensure the smooth development of the project
  • Perform Unit Testing and Proper Code Movement to Production

Oracle Technology Lead Analyst

Techcarrot FZ LLC
01.2024 - 12.2024
  • Requirement Understanding and Gap analysis
  • Involved in various in-House product development of UAE National Health Insurance DAMAN
  • Work in Agile Environment and take part in the Scrum
  • Enhanced PLSQL Code Development after understanding the user stories
  • Involved in Quality cycle to support Development, QA, UAT and Production Release
  • Taking ownership and supporting team members
  • Ensuring Performance of the code and adhering company standards
  • Involved in creating high complex Pipelined Reports using PLSQL models

Software Consultant

Abudhabi Commercial Bank
04.2022 - 01.2024
  • Requirement Understanding and Gap analysis
  • Develop and enhance the existing loyalty system PLSQL code based on the SER
  • Design and Create tables, procedures, packages, adhoc scripts
  • Perform Sqoop import and export into HDFS system
  • Coordinate closely with business team to ensure the quality of the enhancement and ensure it is successfully tested and moved to production
  • Provide code fixes for the issues raised by the production support team
  • Ensuring Performance of queries while development and address any issues identified in Production due to slowness or crash
  • Ensuring the EOD process is successful without any issues

Associate, Senior Application Developer

Cognizant Technology Solutions
04.2019 - 04.2022
  • Requirement Understanding and Gap analysis
  • Create standalone Packages, Procedures, Functions and various PLSQL Scripts for DataMart report requirements
  • Generate client specific screen reports with oracle forms and reports
  • Coordinate with ETL team to setup the mapping for all the extract requirements
  • Requirement walkthrough with Client and BA
  • Design functional mapping document, error handling and walkthrough with client
  • Coordinate with QA Team to ensure the user stories are smoothly processed
  • Deployment - Participate and provide inputs to plan the release
  • Ensuring Performance of queries while development and also address any issues said by client in Production
  • Provide support in terms of impact analysis in case of any new requirements

Associate Technical Analyst

Oracle Financial Services Software
07.2017 - 03.2019
  • Learn Core banking functionality to address issue and test the issues in priority
  • Analyzing the Business Requirements provided by the Business Analysts
  • Analyze the given logs and trace out the code, modify it and test to fix the bug
  • Writing test cases and preparation of test data and testing
  • Prepared test plan, test cases, SQL queries
  • Follow the company standards in communication with the client by using the official tools and services
  • Worked on PL/SQL Packages Procedures and Functions for Back End Processes to load data in different stages
  • Understanding and Testing PL/SQL scripts
  • Reported Defects and tracked them in Jira
  • Expertise in analyzing data Quality checks using SQL, PL/SQL scripts
  • Reviewed the test cases and their coverage
  • Create PL/SQL Code according to the requirement or add patches to the same in company standards, test and release the source without any issues

System Analyst

Indus Software
12.2016 - 07.2017
  • Development of SQL queries and generating the same as stored procedures
  • Testing the same for the required output
  • Addressing the Functional Test Execution and Action Report (FTEAR) cases from the Business during UAT
  • Analyze and fix and test the critical issues to reduce showstoppers
  • Responsible for Deployment preparation and unit test cases preparation
  • Responsible for Unit testing the developed packages and validating for business logics
  • Responsible for deployment support in QA/Staging and Production Environment
  • Ensuring the success of automated EOD batch to avoid problems in interface data

Software Engineer

SundaramInfotechSolution
09.2013 - 12.2016
  • Developed and tested several PLSQL Functions, Procedures and Packages for complicated Business Logics especially for mobile applications
  • Created several scheduler jobs for automatic transaction of data from the users
  • Preparing LLD for the new requirements based on FRS
  • Addressing the Functional Test Execution and Action Report cases
  • Performed Maintenance activities like monitoring month end jobs and data generations
  • Involved in table designs and fine tuning of queries to avoid website load and delays
  • Made changes in the design of the main window of CER based on client requirements
  • Coordinating with the Clients for status updates and issue handling

Education

B.E - Computer Science

Anand Institute Of Higher Technology
01.2009 - 01.2013

Skills

Oracle PL/SQL

Certification

Baselevel Microsoft Azure 104 Certification

Accomplishments

  • Designed and Developed UAE's Highly used Cobrand Credit Card Talabat & Cashback 365 Loyalty System and made it successful within the agreed timeframe without any hassle. Launch, Planning and Development was highly appreciated and turned out to be a big Profitable Product for the Bank.
  • Worked as a team in creating in House Health Insurance Product for UAE National's Government Health Insurance DAMAN. Amidst the hectic deadline, Completed the Project successfully with a greater team effort of pulling a huge work.

Timeline

Senior System Analyst

Abudhabi Commercial Bank
12.2024 - Current

Oracle Technology Lead Analyst

Techcarrot FZ LLC
01.2024 - 12.2024

Software Consultant

Abudhabi Commercial Bank
04.2022 - 01.2024

Associate, Senior Application Developer

Cognizant Technology Solutions
04.2019 - 04.2022

Associate Technical Analyst

Oracle Financial Services Software
07.2017 - 03.2019

System Analyst

Indus Software
12.2016 - 07.2017

Software Engineer

SundaramInfotechSolution
09.2013 - 12.2016

B.E - Computer Science

Anand Institute Of Higher Technology
01.2009 - 01.2013
Prasanth VOracle Plsql Developer