Software Engineer Sql Developer

RESUME

ANSHUL. K. BHISIKAR

ORACLE (SQL, PLSQL,

OracleReport, Unix, Linux, AWS )

Mobile: 820-***-****

Email: ***************@*****.***

OBJECTIVE:

Oracle PL/SQL Developer with 3+ Years of experience in software development testing and production support, Expertise in PL/SQL programming, performance tuning, and complex query optimization. Adept at developing and maintaining robust database solutions with a proven track record of delivering quality work in fast-paced environments. PROFESSIONAL SUMMARY:

Having more than 3 + years of experience in Oracle Applications and Database programming using Oracle PL/SQL and Oracle BI Report and

Involved in writing PLSQL queries, Cursors, Subprograms like Procedures, Functions, and Triggers in PL/SQL blocks.

Familiar with SQL sub queries, joins, applying constraints. SQL Programming Using Analytical functions, indexes and set Operators.

Ability to customizing existing logic to add new functionalities, using procedures and functions to validate and to process the business data.

Ability to understand the business requirements and Data models. JOB PROFILE:

• Company : Harjai Computers Pvt Ltd

• Designation : Software Engineer

• Department : IT (Development)

• Duration : April 2023 - present

• Company : D-insights Pvt. ltd.

• Designation : Software Engineer

• Department : IT (Development)

• Duration : Sept 2022 - Jan 2023

• Company : CTPL (Cleric Technology Pvt. Ltd)

• Designation : Software Engineer

• Department : IT (Development)

• Duration : August2021 - August 2022

• B.tech (Bachelor of technology)

• Diploma in Mechanical Eng. from MSBTE

• HSC from Maharashtra State Board.

• SSC from Maharashtra State Board.

TECHNICAL SKILLS:

Databases : Oracle 11g Database for SQL AND PLSQL, Oracle 10g Database for Application and reports.

Tools : PL/SQL Developer, SQL Developer, Oracle BI Report Operating Systems : Windows 7 & Windows 10

Programming Languages : SQL, PL/SQL, Oracle BI Report, Unix, Linux, AWS Cloud PROJECT DESCRIPTION:

1) Project Name: Payment Gateways, Customer portal Client: Bajaj Allianz Life Insurance, Pune

Working Modules:

Payment Gateways: This is payment gateway web module used by all policy holders to pay the premium of policy, frequency change payment payments transactions details we generate receipt number and payment Receipt

Customer portal: This is generalized web application used by all policy holders to perform various policy

Servicing activities like showing policy Dashboard, pay policy premiums, fund dashboard, fund switch, frequency change account statements etc…

Development and Enhancement of new policy servicing feature. Tools: PL/SQL Developer, SQL Developer, Oracle BI Report Environment: Oracle 10g/11g, PL/SQL, Oracle BI Report Roles & Responsibilities:

• Creating sub-queries, procedures, function, views, index

• Merge sequence index based on project requirement

• To join constraint SQL function

• Exception Handling

• Analyzed the slow running queries.

• Managing subprogram like procedure, function, triggers, cursor, views and exceptions. 2) Project Name: Lead Management

System Client: HDFC Home Loan

Bank, Mumbai

Working Modules: Lead generation, Lead creation, Lead contact information, Lead assign history, EDUCATIONAL DETAILS:

Lead status history, Lead action.

Tools: PL/SQL Developer, SQL Developer, Oracle BI Report Environment: Oracle 10g/11g, PL/SQL, Oracle BI Report Roles & Responsibilities:

• Handling PLSQL Procedure, Cursor in Program units & PLSQL Library.

• Involved in creating indexes on tables for faster retrieval of the data to enhance data performance.

• Involved in writing complex SQL queries using sub-queries to retrieve data from the database.

• Extensively used Joints writing views in the database.

• Analyzed the slow running queries.

• Managing subprogram like procedure, function, triggers, cursor, views and exceptions.

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

• Built and maintain Reports using Oracle BI Reports.

• Exceptions using Oracle tools like SQL developer, PL/SQL developer. 3) Project Name: Landholding Business Management

system Client: Nagpur

Working Modules: Customer Enquiry, Customer Plot Booking., Customer Booking Cancellation. Tools: PL/SQL Developer, SQL Developer, Forms and Reports D2K (6i) &10g Environment: Oracle 10g/11g, PL/SQL, D2K

Roles & Responsibilities:

• Handling PLSQL Procedure, Cursor in Program units & PLSQL Library.

• Managing subprogram like procedure, function, triggers, cursor, views and exceptions.

• Built and maintain Forms using oracle Forms.

• Built and maintain Reports using oracle Reports.

• Exceptions using Oracle tools like SQL developer, PL/SQL developer.

• Extensively used Joints writing views in the database

• Implement some methodologies like indexing, bulk binding, etc. PERSONAL DETAILS:

Name : Anshul. K. Bhisikar

Date of Birth : 04-jan-1989

Gender : Male

Marital Status : Single

Language Known : English, Marathi, Hindi.

Address : Wakad, Pune, 411057.

Contact this candidate