MAGESH J

> Collaborated with business users to identify requirements and develop business logic using SQL and PL/SQL. Actively involved in all the different phases of Agile methodology Requirement Analysis, Development, Design, Unit Testing and Maintenance.

> 7 + years of Hands-on experience in Tables, Views, Materialized views,Joins, Aggregate Functions, windows Functions, Operators, Set Operators, Sub Queries,Partitions and worked on Performance Tuning Process.

> Developed and optimized PL/SQL code, including Procedures, Functions, Packages, Cursors, Exceptions, Triggers, Collections, Exceptions, Dynamic SQL.

> Implemented bulk data processing techniques using Bulk Collect and Bulk Bind to improve performance.

> Implemented Expdp/Impdp process for DB refresh ,DBMS_PARALLEL_EXECUTE process inorder to improve the data migration speed for huge volume tables.

> Implemented Performance tuning using AWR report generation ,Explain plan,reordering existing Query interms of performance improvement.

> Involved in root cause analysis, debugging, and fixing PL/SQL code for front end Applications interms of data retrieval speed.

> Designed and executed unit testing for scripts and documented test results.

> Have used UNIX commands (find, sed, awk, grep, top, ps-ef, du, df, etc.) and shell scripting.

>Managed version control using Bitbucket/Git, created RLM builds in Jenkins(CI/CD pipelines), Udeploy and deployed changes in DEV,SIT,UAT & Production environments.

Cloud Experiences :

>I have a good experience in AWS services such as (Dms,lambda,step_function,cloud_watch,EC's,redshift DB).

>Good knowledge on ETL process using IICS ( informatica cloud).

Project Name – Change health care

Duration  : Nov 2017 to Jun 2019. 

Project Name – NYU Langone Health

Duration  : Jun 2019 to Nov 2022.

Project Name – ECDP(electronic data capture)

Duration : Nov 2022 to May 2024

Project Name - CITI BANK - KYC

Duration:  May 2024 - Till_date

Domains Worked : Healthcare,Insurance,BFS(Banking and financial Services)

Certified [PLSQL Developer], [Iris software]

> Employee of the Month  from Cognizant Technology solutions (Sep-2023).

> Employee of the Month  From Iris Software Technology pvt ltd (April-2024).