Developer Engineer

KUPPUSAMY V

PL/SQL Developer

Phone: 967-***-**** & 733-***-****

Email: ****************@*****.*** Address: 3/230, Vijayalakshmi flats,

Nanmangalam,Chennai-600129

CAREER OBJECTIVE

To Obtain a Challenging Position in a reputable Organization as an Oracle PL/SQL Developer where I can implement my learning’s, knowledge and skills to grow along the company.

SUMMARY

Around 4 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Developed database objects like Tables with constraints, Views, Indexes, Synonyms and Sequences

Involved in Creation of Join conditions, sub queries, Set operators, materialized views for the business application development also good Knowledge on Table Backup, Merge, Purge

Data loads are been performed by using the SQL loader, External organization table, Imports & UTL files based on file formats.

Experience and Excellent Exposure in Query tuning using Analytical functions, Aggregate functions & Single Row Function.

Developed Complex database objects like Stored Procedures, Functions, Pipelined table function, Packages including overloading concept and Triggers using SQL and PL/SQL.

Partitioned large Tables using List & range partition technique.

Experience with Oracle Supplied Packages such as DBMS_Profile & DBMS_JOB,

Experience in Dynamic SQL, Records, Collections and Exception Handling.

Strong knowledge in Oracle cursor management, Bulk collect & Bulk binder with save exception.

Good knowledge on Ref Cursor, Parameterized Cursor & Pragma Autonomous Transaction.

Used Pragma Exception_INIT and RAISE_APPLICATION_ERROR to handle exceptions.

Proficient knowledge in performance tuning and knowledge to work according to the Work Request and Change Request.

Good knowledge on logical and physical Data Modeling using normalizing Techniques.

Good knowledge on DBA concept like Data pump, Flashback, Table Fragmentation,

AWR Report & TKPROF

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables

Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Able to explain technical concepts and communicate with users and system administrators at all levels.

TECHNICAL SKILLS

Languages : Oracle SQL, PLSQL

Database : Oracle 10G,11G,12C

Tools : SQL Developer, Toad, SQL*Plus

Operating System : Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

ASSOCIATE SOFTWARE ENGINEER Aug-2016 To Present Date

Ramco Systems, Chennai

Project Details:

Client Name: Aldermore Bank Plc

Project Name: Aldermore

Role: Oracle PL/Sql Developer

Duration: July-17 To Present Date.

Responsibilities:

Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE, SYSTEM TIMESTAMP, USER etc and a variety of analytical functions, RANK, DENSE_RANK, LAG, LEAD, and PARTITION OVER.

Created DDL scripts, database objects like Tables, Views, Sequences and Synonyms.

Created the indexes and analyzed the table for better performance.

Used the inner join, outer join, cross join while writing the complex SQL Queries.

Used partitioning and sub partitioning of tables to improve performance

Developed Shell scripts and SQL control files to load data through SQL Loader.

Developed PL/SQL Procedures, triggers, Functions and Packages

Developed triggers and PL/SQL procedures for automation of jobs scheduling

Test case/data preparation, execution and verification of the test results.

Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.

Worked extensively on Exception handling to error handling and tracking.

Experience in using packages like DBMS JOBS to schedule background processes.

Worked on UTL FILE package for reading the text files and extracting data into tables.

Extensively used Dynamic SQL, REF Cursors, Bulk binding/Bulk Collection, Nested tables, Analytical functions, Regular expressions while developing complex procedures.

Involved in logical and physical Data Modeling using normalizing Techniques

Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN

Analyzed and computed statistics to improve response time for queries.

Involved in Performance tuning of complex queries

Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts

Conducted Knowledge sharing sessions with the team members.

Environment: Oracle Database 10g/11g, TOAD, PL/SQL, Microsoft Excel and MS Office

Client Name: SCOTIABANK EUROPE PLC

Project Name: Scotiaitrade

Role: L2 - Production Support Engineer

Duration: Aug-16 To June-17.

Responsibilities:

Involved in analyst team to solve the client request at technical level.

Experienced in data analysis for solving customer issues.

Identifying the critical issues and taking prompt and effective actions spontaneously.

Conduct technical training for Service Desk resulting in a more efficient triage and support of issues

Experienced working with Service Now for Ticket Tracking and experienced in CRONTAB for job scheduling.

Communicate workarounds to be followed to L1 and L2 till the issue order gets resolved.

Raising issues to development team and working with them closely for permanent fixes through calls.

Modified Reports to suit client requirements.

Verify there is agreement between the line of business and testers that all items are ready to deploy.

Collect, validate and publish deployment tasks for my area prior to deployment activity.

Used UNIX shell scripts to automate and systemize the load process at nightly cycles.

CERTIFICATION

Completed OCA (ORACLE Certified Associate) in Program with PL/SQL

ACHIEVEMENTS

Organized seven day NSS camp at Illupaikudi village.

Organized WATER ROCKETARY event in our college symposium

EDUCATION

B.E. Graduation (2009 – 2013)

Discipline :Mechanical Engineering

College : AlagappaChettiarGovt.College of Engg& Tech.

Board : Anna University

Grade : 8.527

Higher Secondary(2007-2009)

School : SigaHr.Sec.School, Kappiyampuliyur.

Board : Tamil Nadu State Board.

Percentage : 91.25 %

SSLC(2006-2007)

School : Government High School, Thenpair.

Board : Tamil Nadu State Board.

Percentage : 89.8 %

PERSONAL DETAILS

Name : Kuppusamy V

Father Name : Venkatesan M

DOB : 06-04-1992

Nationality : Indian

Language known: English, Tamil

Permanent Address: 1/85, MariyammanKovil Street, Thenpair, Villupuram - 605652

DECLARATION

The above mentioned details are true to the best of my knowledge and belief.

DATE:

PLACE: Chennai YOURS SINCERELY

(KUPPUSAMY V)

Contact this candidate