 Handled performance related issues/new changes among 5 application in CITI bank account. Develop many automated process to do data purging and oracle JOB automations. Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables. Creating Oracle packages, stored procedures, and functions using Oracle SQL and PL/SQL for various project modules and generating business reports. Utilize Dynamic SQL and executing immediate functionality to perform DDL in PL/SQL blocks and procedures. Enhancing mobile communication applications to be more flexible and versatile through advanced programming technique using Dynamic SQL in PL/SQL. Design and create entity relationship diagrams (ERD) for Oracle based applications and interfaces, and prepare case study document for migration process through self-learning. Monitoring and analyzing performance of database objects for deploying Indexes, schema gathering, partitioning, Explain Plan, TKPROF.

Project : Maxis (Kuala Lumpur, Malaysia) – WIPRO Technology:Duration : July-2016 to July 2017Role : Technical Lead- Oracle DB (Onsite).Discription: Maxis Communications Berhad is a holding company which through its subsidiaries provides mobile, fixed line, and international telecommunications services in Malaysia. It also provides Internet and broadband services; and wireless multimedia related services, and owns, maintains, builds, and operates radio facilities and associated switches.The company was formerly known as Binariang Berhad and changed the name to Maxis Communications Berhad in 1999.The company was founded in 1993 and is based in Kuala Lumpur, Malaysia. Maxis Communications Berhad is a subsidiary of Binariang GSM Sdn. Bhd.Responsibility :• Responsible for systems analysis, development enhancement, maintenance and support of Oracle based application• Manage User Acceptance Testing of new applications and new versions of existing applications.• Provide technical and functional direction to our customers in matters of implementing technology within their business processes.• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.• Used Packages and Stored Procedures in different types of modules• Studying current application and preparing the case study document for migration part• Responsible for using dynamic SQL in PL/SQL, which is an advanced programming technique that makes the applications more flexible and versatile.