Resume

Sign in

Oracle plsql and sql

Location:
Chennai, Tamil Nadu, India
Posted:
May 14, 2020

Contact this candidate

Resume:

SAKTHIMURUGAN S

E-mail: adc745@r.postjobfree.com Mobile: +91-805*******

Address: No.748 EWS B TYPE TNHB Colony,Velachery, Chennai-42

PROFESSIONAL SUMMARY

Over 3.8 years experienced Oracle PL/SQL Developer and Production Support looking for challenging and immediate job opportunities in Oracle Database Technologies.

Extensively created and worked with Procedures,Functions,Packages,Triggers,

Cursors,Ref cursors and Materialized Views.

Good working knowledge on creating and maintaining the DB objects like indexes, Sequences, Views and DB links etc.

Strong team player, quick learner and capable of working independently.

EDUCATION

COURSE

INSTITUTE

YEAR

%

B.E (ECE)

Tagore Engineering College,

2014

67.2

Chennai.

Class XII

S.R.V Matric Higher Secondary School,

2010

87.5

Trichy.

Class X

Thanthai Roever Matriculation School,

2008

70

Perambalur

WORK EXPERIENCE

Aug 2016 – Till Date

Mar 2015 – Jul 2016

Plsql Programmer

Aiocd Pharmasofttech Awacs Pvt.Ltd.

Executive Campaign Analytics

Matrimony.com

Jun 2015 – Till Date

Software Engineer

Enspire TechnologiesPvt Ltd

Jun 2015 – Till Date

Software Engineer

Enspire TechnologiesPvt Ltd

TECHNICAL SKILLS

Oracle 11g, 12c-Sql & Plsql, Dynamic sql.

Performance Tuning.

Sql server 2016.

IBM Unica Campaign Tool

PROJECT #1

Company : Aiocd Pharmasofttech Awacs Pvt Ltd.

Project name : PharmaTrac & Client Servicing Report.

Role : Plsql Production support & Developer

Duration : Aug 2016 to till date

DESCRIPTION :

Pharmaceutical market researching and processing related to pharmaceutical industry in India which including pharmaceutical products, providing assurance of genuine products at a competitive price and provide sound market intelligence to Pharmaceutical manufacturing companies. Manufacturers can get wide information about future market needs and play a significant role in shaping the future of domestic pharmaceutical market of total IPM (Indian Pharmacy Market) and MAT (Moving Annual Trend) values.

RESPONSIBILITIES:

Understanding and Collecting requirements from Business user side or Business Analyst and try to convert that requirement to SQL queries or PLSQL.

Wrote complex sql queries using joins and sub queries to retrieve data from database. Also made use of set operators like union, union all, intersect and minus.

Involved in creation and modification of stored procedures, functions, cursor and packages as per the business requirements.

Involved in performance Tuning using Explain Plan and oracle hints .Used table partitioning in huge table to increase database performance.

Handled errors using system defined exception and user defined exception.

Can assist in developing and implementing new technologies.

Technical documentation preparation for developing code.

Environment: Oracle 12c, PL/SQL, Toad.

PROJECT #2

Company : Matrimony.com

Role : Executive Campaign Analytics

Duration : March 2015 to July 2016

DESCRIPTION :

MATRIMONY PRODUCTS [NRI RETAIL RENEWAL CAMPAIGNS]

This campaign was developed to distribute the NRI customers who had paid once in the past to the telecallers so as target for them for renewing the product. One time paid customers were divided into 4 buckets.1.DTE-Going to expiry in next 15 days,2.Expired-expired in last 15 days, 3.Growth-Expired 90 days ago, 4.Follow up bucket-The response of called customer should be called on next day.Based on rotational logic customers will be distributed to telecallers for calling every day. The design logic was done using UNICA tool.

RESPONSIBILITIES:

Create the flowchart based on the requirements and conditions.

Created database objects like tables, views, Index, stored procedure, function, packages, Cursor and Triggers.

Involved in design and analysing the flowchart.

Involved in modifying various existing procedures, functions and triggers according to the new business needs.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Environment: IBM Unica Campaign Tool and DB2.

CERTIFICATION

Oracle Certified Expert (OCE) for SQL Fundamentals is given by Oracle.

PERSONAL INFORMATION

Father’s Name : Subramaniyan.K

Marital Status : Single

DOB : 07-Oct-1992

Current Location : Chennai

DECLARATION

I hereby declare that the above mentioned information is true to the best of my knowledge.

PLACE: CHENNAI

DATE: (S.SAKTHIMURUGAN)



Contact this candidate