Post Job Free

Resume

Sign in

Sql Developer Oracle Pl

Location:
Pune, Maharashtra, India
Posted:
July 06, 2021

Contact this candidate

Resume:

Moinuddin Sayyed

Mobile: +91-888*******

Email-id: adnkt1@r.postjobfree.com

Objective:

To become a technically sophisticated and top notch professional in the field of Software Developing and work for an organization that helps me to achieve position to utilize my skills and abilities that helps in reaching pinnacles.

Professional Summary:

Having 5.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).

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Expertise in Client-Server application development using Oracle 11g/10g.

Effectively made use of Indexes, Analytical Functions, Materialized Views, Query Re-Write and Refresh on Commit.

Created Tables, Views, Constraints, and worked on Joins.

Developed database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Having partitioned large Tables using range partition technique.

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

Having Knowledge of ASP.

Quality conscious, Good Team player, hardworking and enthusiastic in learning new things with target oriented approach following timelines.

Quick learner and learn new technologies and ability to deliver quality work.

Technical Skills:

Database : Oracle 10g, 11g

Programming Language : PL/SQL

Query Language : SQL

Tools : PL/SQL Developer, Toad, SQL Developer

Operating System : Windows Family

Work Experience:

Working as Technical support in Mphasis Pune.

Worked as Software Engineer in Clover InfoTech Pvt ltd Pune.

Educational Qualification:

B.Sc.(SE) in SE (2013, Nanded UNIVERSITY (India))

Project Undertaken:

Title: Insurance of Health, Motor and Travel

Client: Bajaj Allianz General Insurance (Pune)

Environment: Oracle

Description:

Bajaj Allianz General Insurance is a private general insurance company in India. The company is a joint venture between Bajaj Finserv Limited owned by the Bajaj Group of India and Allianz SE, a German financial services company.

Responsibilities:

Created Oracle Tables, Views, Constraints, Synonyms, Sequences.

Used Analytical functions, Decode, case statement while writing complex SQL queries.

Developing packages, procedures, functions for the application.

Developed complex SQL queries including Sub queries, correlated queries, and Nested queries.

Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

Involved in working with EXPLICIT CURSORS, and REF CURSORS.

Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.

Involved in generating numbers for PRIMARY KEY VALUES using Oracle SEQUENCE objects.

Involved in creation of various indexes on relational tables, which are BTREE, BITMAP and FUNCTION BASED INDEX.

Involved in working on Oracle Pseudo columns like ROWID, ROWNUM, SYSDATE and USER etc.

Client: Ziggo client (Netherlands)

Environment: Oracle

Description:

Mphasis is an IT services company based in Bangalore, India. The company provides infrastructure technology and applications outsourcing services, as well as architecture guidance, application development and integration, and application management services. It serves financial services, telecom, logistics, and technology industries.

Responsibilities:

Worked as technical support

Executing created script on production

Worked on EOD and BOD scripts

Resolves the client issue using script.

Personal Details:

Date of Birth : 30 OCT 1991

Passport : Yes

Sex : Male

Nationality : Indian

Marital Status : Unmarried

Languages : English, Hindi and Marathi

Address : Infront of Hamdiya Masjid, Khori Galli

City : Latur, Maharashtra, India

Pincode : 413512



Contact this candidate