Oracle Developer

Manivasu S

No.* P Block A.M Garden Mandaveli Chennai-28 +91-967******* * *********.*******@*****.***

CAREER OBJECTIVE

To contribute effectively as a team lead in a vibrant, progressive and specialized organization and also like to handle the work in challenging atmosphere. Seeking a position to apply all my skills and talents, where my knowledge can be shared and enriched ultimately to meet the professional goals.

PROFILE SUMMARY

Having overall 3+ years of experience in programming as an Oracle PL/SQL Production Support along with C Language and UNIX basics by developing in Retail application to deliver the jobs on time with Customer requirements and satisfactions.

Skilled in Service Management ticketing tools like ServiceNow & Remedy with End to End Support. Also have an exposure in writing Complex SQL Queries like Joins, Sub Queries, Group Functions and Analytical Functions.

Strong Proficient in creation/modification of database objects like Synonyms, Single Row Functions, Procedures, Functions, Packages, Triggers, Joins and Set Operator and also develop Views, Materialized views, External Tables, Indexes and sequences, Hints, Bulk Binds, Bulk Collect, Creation of global temporary tables and table partitioning. Moreover, having a practice of using Cursor Ref Cursor, Collections, Exception handling and SQL Loader.

ACADEMIC QUALIFICATIONS

•Graduate in Bachelor of Engineering (B.E.) Computer Science and Engineering at Meenakshi Sundararajan Engineering College, Affiliated to Anna University, Chennai with 67% marks (2014)

•Diploma in Computer Engineering, at S A Polytechnic College, Chennai with 82% marks (2011)

•SSLC Course (10th), at Santhome Higher Secondary School, Chennai with 73% marks (2008)

TECHNICAL SKILLS

Operating Systems: Windows 7 and 10

Programming Language: C, UNIX, SQL & PL/SQL

Databases: Oracle 10g/11g

Tools: TOAD (12.12), SQL DEVELOPER, SQLPLUS

WORKING EXPERIENCE

•Worked as an Administrator in NEBULA COMPUTERS PVT.LTD from Nov 2014 to May 2016.

•Currently working as Software Engineer in OBJECTFRONTIER SOFTWARE, Chennai from July 2016 to till date.

Project #1: Client: PIAS (Property Insurance Application System)

Environment: Oracle PL/SQL, SQL Duration: Sep 2016 to Nov 2017

Domain: Insurance Role: PL/SQL Developer

Job Responsibilities:

•Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

•Enabling the users to capture Dwelling applications beyond creation of Reference no. through PIAS.

•Created scripts to make new tables, views, queries for new enhancement in the application, TOAD.

•Involved in the continuous developments and fixing of production problems on a daily basis.

•Set-up and Design of Backup and Recovery Strategy for various databases.

•Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

•Drive the client call meeting effectively on a regular basis.

Project #2: Client: WOORI BANK

Environment: Oracle PL/SQL, SQL, UNIX, Toad Duration: Dec 2017 to Till Date

Domain: Banking Sector Role: PL/SQL Developer

Job Responsibilities:

•Created PL/SQL stored procedures, functions and packages for manipulating the data.

•Involved in the whole life cycle of the project and resolve the issues to meet the customer needs.

•Generated tables, views, indexes, and constraints to implement business rules and also created Triggers to enforce data by utilizing SQL*Loader to load flat files into database tables.

•Building indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.

•Query tuning for better performance and Interacted with clients to understand their requirements.

•Extensively used Cursors, Ref Cursor for returning the query results in short period of time.

•Prepared for problems occurred and maintain Up/Down time and the SLA Reports.

•Work with customer on Business Continuity plan and performed restore / rebuild during disaster.

#Previous Organization: NEBULA COMPUTERS LTD. Duration: Nov 2014 to May 2016

Job Responsibilities as System Admin:

•Troubleshoot, diagnose and problems in desktop, workstation equipment, peripherals on daily basis.

•Controlled all desktop level issues, including installing and upgrading software, troubleshooting and implementing file backups, and also configuring systems and applications via telephone and e-mail.

•Provide networking/desktop support and perform mainframe & account maintenance tasks by earning commendations for team, flexibility by providing IT support to students and faculty.

•Handled technical troubleshooting including system crashes, slow-downs and data recoveries. Also, organized 30+ technical/mission-critical calls daily and consistently met high service standards.

•Engaged and tracked Priority 1 issues, with responsibility for the timely documentation, escalation (if appropriate), resolution and closure of trouble tickets.

HOBBIES

•Reading Books and interested in Photography

•Playing Cricket & Basket Ball

PERSONAL DETAILS

Name : Manivasu S

Date of Birth : 9th October, 1991

Father Name : Selvam M

Gender : Male

Blood Group : A +ve

Marital status : Single

Languages Known : Tamil and English (Read, Write and Speak)

PAN Card Number : DDKPM4822E

References : Available Upon Request.

DECLARATION

I hereby declare that all the above mentioned information’s are true to best of my knowledge and I assure you that I would work sincerely for the betterment of the company.

Place: Chennai, Signature,

Date: Manivasu S

Contact this candidate