MUNUSAMY

Chennai Phone: 893-***-**** acy84m@r.postjobfree.com

Oracle PL/SQL Developer

Professional Experience

Capgemini India Pvt Ltd, Mumbai, 15Dec2014 to 18 May2016

Oracle PL/SQL Developer, Consultant

Photon info Tech, Chennai, 17 Jan2011 to 31 Oct 2014

Software Engineer

Around 5+ years of extensive experience in the complete Software Development Life Cycle (SDLC) covering Requirements Management, System Analysis and Design, Development, Testing and Deployment of business applications.

Roles and Responsibilities:

Extensive experience Writing Stored Procedures, Functions, Packages, PL/SQL routines,Database triggers, Shell-Scripting, unit testing integrity.

Extensive Experience Controlling user Access, Privileges, System Privileges, Creating Users, Granting System Privileges, and Object privileges, Database links, Revoke Object Privileges.

Created multiple customized PL/SQL Procedures & Packages for various businesses needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.

Well experienced in Query Optimization and Tuning using bulk collections, Hints, Explain Plan, SQLTRACE. Experienced in creating External tables, Uploading/Downloading data using SQL*Loader control files

24/7 Production support and involved in implementation of coding standards security, attending audits at various levels by using coded security module, database change requests

Worked on implementing data movement strategy Oracle 10 g,11 g 12 c Oracle Export/Import process and Invisible columns, Multiple indexes on the same column Regular, Temporary Undo, Expressions,Virtual columns, pivot and unpivot, collect enhancements,Table partition maintenance enhancements in plsql

Developed Stored Procedures, Packages, and Functions, oracle Forms &Reports using PL/SQL for the batch framework

Generated DDL Queries for creation of new database objects like tables, views, sequences, functions, synonyms, triggers, packages, stored procedures, roles and granting privileges.

Wrote UNIX Shell Scripts to run database jobs on server side.

Involved in Unit Testing and data validation

Coordinated with onsite team in resolving the issues in live environment

Domain Experience In BANKING.

MUNUSAMY KUMARASAMY

Page 2 Phone: 893-***-****

Project-1

Application

Wm6

Client

cargill

Location

Us

Role

Consultant

Roles and Responsibilities:

Wrote QL scripts to create objects like tables, views and sequences

Designed nd developed PL/SQL functions / stored procedures / cursors / packages / triggers

Used SQL loader to convert/load the data from the files to oracle tables.

Involved in writing complex queries to generate reports as per client request as a part of production support

Involved in Optimization of SQL queries

Involved in the continuous enhancements and fixing of production problems

Resolved errors reported during system test and user acceptance test

Project-2

Application

VCC

Client

Volvo

Location

Sweden

Role

Senior Software Engineer

Roles and Responsibilities:

Developed Unix Shell Scripts to automate back end jobs, loading data into the Database using SQL* Loader

Wrote QL scripts to create objects like tables, views and sequences

Designed and developed PL/SQL functions / stored procedures / cursors / packages / triggers

Used SQL loader to convert/load the data from the files to oracle tables and vice versa

Involved in writing complex queries to generate reports as per client request as a part of production support

Involved in Optimization of SQL queries

Involved in the continuous enhancements and fixing of production problems

Resolved errors reported during system test and user acceptance test

Coordinated with onsite team in resolving the issues in live environment

Coordinated various levels of teams to resolve the critical issues of the application

Involved in Implementation of change requests in live environment after successful migrations

Involved in Understand existing business model and client requirements.

Project-3

Application

R-Track Management Systems

Client

UCB Bank Ltd,

Location

UK

Role

Software Engineer

Roles and Responsibilities:

Created Procedures, Functions and packages using PL/SQL

Wrote SQL scripts to objects like tables, views and sequences

Involved in the continuous enhancements and fixing of production problems

Involved in writing complex queries to generate reports as per client request as a part of production support.

Involved with the various levels of Leads for gathering requirements and analysis

Involved in Unit testing of the application and user requirement documents.

Involved in Query optimization for the SQL queries those are executed by business users

Developed complex pl/sql packages like scheduling the sales orders automatically on the daily basis.

Technology

Operating Systems

Windows (all versions, WM)

Database

Oracle RDBMS (10g, 11g,12c)

Database Administration Tools

TOAD, SQL PLUS

Performance Tuning

SQL tuning, Explain plan and Index Analysis

Education

ANNA UNIVERSITY,COIMBATORE

ME(CSE),2010.

Personal Details:

Name :Munusamy .K

Father Name :Komarasamy.S

Languages Know :English,

Material Status :Married

Present Address : New no 19, old No 121/98,

F1-Venkatesh Housing, Kamalam First Cross Street,Veeramani Nagar,

Nanmangalam, Kovilambakkam, Chennai-117.

Contact this candidate