Sql Developer Professional Experience

Ayaskant Das

Karnataka,Bangalore-******

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

Contact No :- +91-988*******

Having 3+ Years’ Experience to Work as a PL/SQL Developer in a self-disciplined environment where effective inter-personal skills, hard work coupled with successful work experience contributes to the achievement of organizational and personal goals.

Having database experience using Oracle 10g/11g/12c, SQL, PL/SQL, SQL*PLUS.

Created Tables, Constraints, Sequences, Indexes, Views, Mviews.

Involved writing Complex queries using Join and Subquery.

Writing Anonymous Blocks, Procedures, Functions, Cursors, Ref Cursors, Triggers, Packages.

Used the concept of PL/SQL collections, Bulk collect and Bulk binding, Bulk exceptions.

Worked on extensively SQL * Loader .

Having good knowledge in Exception Handling.

Used Pragma Autonomous_Transaction, Compound Trigger to avoid mutating problem in database triggers.

Experience with oracle supplied packages such as UTL File package.

Having good knowledge in Dynamic SQL.

Having good Analytical and Programming capabilities.

Good Team player with a synergistic approach and effective Communication Skills.

Ability to work in 24x7 environments, preparing root cause analysis and ensuring the action points

Experience:-

Working as a Pl/Sql developer in HCL Technologies Limited from August 2014 to Present.

Professional Qualification:-

B.tech in Electronics & telecommunication from Padmanava college of Engineering, Rourkela in the year of 2014 from B.P.U.T Odisha.

Professional Experience:-

Project : 1

Title : Ahold USA

Client : Ahold USA

Domain : Retail

Software : Oracle 10g, 11g

Role : pl/sql Developer

Team Size : 8

Duration : September 2014 –February 2016

Description:

This Project describes the infrastructure, operations and processes involved in the Store ISP Perishable inventory systems. The Perishable Inventory system (System 18p) is designed as a flexible system that allows the merchandisers to decide how the stores. Perishable item inventories (items that are meat, deli, bakery etc) should be taken, calculated, and valued at the stores. The system resides on the store ISP and the headquarters ISP .Planogram is a space management system that enable store to utilize the store space more efficiently. This system that consider store layout, item details and special recommendation and prepare a plan that help the store to arrange the items in very systematic and effective way.

Responsibilities:

Created Oracle Tables, Views, Constrains, Sequences.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Used joins and subquery to retrieve data from database.

Used PL/SQL to create Packages, Functions, and Procedure, trigger.

Involved in the whole life cycle of the project.

Used pragma autonomous transaction to avoid mutating problem in database trigger.

Project : 2

Title : Credit Mate

Client : Bank of Hawaii

Domain : Banking

Software : Oracle 11g, 10g

Role : PL/SQL Developer

Team Size : 12

Duration : March 2016-tilldate

Description:

Credit Mate is a credit workflow application tool in BH. It automates the credit initiation process and approval process in the bank. In these credit process first customers spread is calculated. Based on these spread scorecard is generated. Then according to the scorecard information BCA is created. BCA is the heart of Credit Mate used for credit preparation. Credit Mate helps the users in BCA preparation, limit allocation, scorecard generation, early alert reporting, customer static data management and credit risk management etc. Credit Mate is accessed in all branches of Bank of Hawaii across the globe.

Responsibilities:

Involved in the whole life cycle of the project.

Interacted with clients to understand their requirements.

Involved in Creating Tables, Views, Constraints, Clusters.

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

Involved in creation of Packages,Function,Procedures, Triggers, etc.

Written the Queries, Joins to access the data.

Created Indexes to improve the Performance.

Improving the performance using performance tuning concepts.

Used Compound Trigger to avoid mutating problem in database trigger.

Worked on SQL*Loader to load data from flat files obtained from various facilities .

Extract data from operational database to flat file using Utl File package.

Technical Skills:-

Operating Systems :Windows, Linux, UNIX Languages

SQL and PL/SQLTools : Sql*Plus, Sql developer, Sql * Loader, Utl_Files, oracle 11g/10g.

Contact this candidate