MOHAN.T Contact: +918*********
PL/SQL Developer E-Mail: email@example.com
PROFILE SUMMARY AND RELATIVE SKILLS
* ***** ** ***** ** experience in designing, customizing and developing enhanced functionality to Oracle like SQL, PL/SQL, stored procedures, SHELL SCRIPTING, PERFORMANCE TUNING packages on Oracle 10g/11g and SQL* loader Database as backend. Mainly in software analysis, design, implementation and development of Oracle .
Experienced in programming as an oracle PL/ SQL developer and involved on all the phases of the SDLC (Software Development Life Cycle) from development, implementation and maintenance with timely delivery against aggressive deadlines.
Experience in handling AGILE methodologies.
Good experience in production support (L1,L2 and L3) and worked using ITT and TOAD.
Experience in handling severity tickets within SLA and prepared Root Cause Analysis document.
Basic Knowledge in UNIX Commands and Shell Scripting.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Willingness and ability to quickly adapt to new cutting edge technologies and mastering sought-after skills.
Extensive experience in SQL, PL/SQL Programming concepts.
Has an extensive experience in data migration process from various data sources to Oracle 10g/11g and SQL* loader.
Good experience in creating PL/SQL Procedures.
Good experience in creating PL/SQL Functions, Packages.
Has an Extensive experience in writing Materialized views.
Having knowledge in writing complex stored procedures involving in-depth data analysis, triggers and views as per business requirements.
Good experience PL/SQL queries like DML, DDL, Views and Triggers etc.
Having knowledge in writing Complex Queries.
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Knowledge in Table Partition using Range and List Partition Technique.
PLINTRON GLOBAL TECHNOLOGY SOLUTIONS PRIVATE LIMITED, CHENNAI
JUNE 2017 to Till date
Languages : SQL, PL/SQL.
Databases : Oracle 10g, 11g, 12C
Utilities : SQL * Loader.
Operating Systems : WINDOWS (All Version), LINUX.
Other Tools : SQL PLUS, TOAD, SQL DEVELOPER, CVS, ITT
VISIO, PUTTY, AUTOSYS
Title : E-trade.
Client : E-Trade Financial Corporation.
Duration : July 2017 to till date.
Team Size : 23.
Environment : Oracle 10g, 11g, 12C, PL/SQL, Sql*Loader,
E-Trade Financial Corporation is a financial services company headquartered in New York City, United States. It is an online discount stockbrokerage firm for self-directed investors. Investors can buy and sell such securities as stocks, bonds, options, mutual funds, and exchange-traded funds via electronic trading platforms or by phone. E-Trade Financial also provides banking services to retail investors, such as sweep deposits and savings products.
Role and Responsibilities:
Developed SQL Queries for checking data transaction and database integrity.
Involved in coding part of all respective module.
Involved in writing stored procedures.
Creating PL/SQL Packages, Procedures, Functions for data population and updating as per project requirements.
Writing queries based on specifications.
Analysis of requirements.
Writing cursors according to specifications.
Creating Database Triggers to Maintain USER Integrity.
B.E in Electronics and Communication Engineering from Sri Krishna College Of Engineering and Technology, Coimbatore
Languages Known : English, Tamil, Kannada and Telugu.
Gender : Male.
Date of Birth : 15.07.1993
PLACE: Chennai Yours truly