PLSQL Developer

*******************@*****.**

m

099********

WORK EXPERIENCE

Software Engineer

Oramate technology solutions private limited

Achievements/Tasks

Chennai

Chennai, India

linkedin.com/in/Prakash/linked/in

SKILLS

A logical, analytical thinker with exceptional database skills possesses rich experience of 3+ year as Oracle PL/SQL developer.

Proficient in PL/SQL and creation and modification of Schema Objects like Tables, Views, Constraints, Indexes, Sequences and Synonyms.

Hands on Experience in writing Joins, Sub-Queries, Analytical Functions. Experience includes in Anonymous blocks, Cursors, Exception handling, Packages, Procedures, Functions.

Good Analytical skills in Oracle 11g Databases.

Knowledge in Ref Cursor, Data Conversion of flat files to Oracle using SQL* Loader, triggers. Exposure in PL/SQL Collections, Record, Bulk Collect. Have knowledge in granting privilege and role to users, dynamic sql, triggers, materialized view.

LANGUAGES

MS office

Limited Professional Proficiency

SQL

Full Professional Proficiency

PLSQL

Full Professional Proficiency

INTERESTS

PROJECTS

Healthcare

This Project is designed and developed to manage and maintain medical equipment along with Stock, Sales and Delivery management based on service request.

Involved in the creation of various Schema Objects. Written complex SQL queries using Sub-Queries, Joins, and Functions. Used Anonymous Block in PL/SQL.

Used Bulk Collect and Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Tuning of the SQL queries, which takes long time to process the request using creating Indexes, Explain Plan, Hints to reduce the response time.

Enhanced, developed and deployed reports based on new requirements for a separate module maintaining the standard of the layouts, data model. Coordinated with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.

Insurance

Insurance In this Project generally a company or the state undertakes to provide a guarantee of compensation for specified loss, damage, illness, or death in return for payment of a specified premium. EDUCATION

BCA

St.thomas College, Madras University with

73%

2013 – 2016

Chennai

HSC

SMDPVC higher secondary school with 76%

2012 –

2013

Chess

• Quick learner

• Client requirements

• Advanced critical

thinking

Ability to handle the

pressure situation.

• Performance tuning

• Programming

Prakash.R

Oracle PL/SQL Developer

To explore my skills, where I can utilize potential for the growth of an organization and willing to work in a challenging and creative environment.

Chennai

Contact this candidate