Page * of *

Praphull Raut Email: ade62u@r.postjobfree.com

Mobile: +91-959*******

Professional Summary:

3.10 years of professional experience in Oracle SQL and PL/SQL under Windows environment.

Having database experience using oracle 12c/11g in SQL, PLSQL, stored procedures, functions, Packages, exception handling, constraints, Triggers, Indexes, and Views.

Worked on Exception handling in order to create our own exception names.

Extensively worked with DDL, DML and TCL statements.

Worked on Bulk collect, PL/SQL tables and Dynamic SQL for DML and DDL operations.

Extensively used Views, Inline Views, Sequences, Synonyms and Global Temporary Tables.

Strong experience in Collections and Oracle objects.

Experience in SQL * LOADER, External Table for loading the data.

Experience in scheduling jobs, creating partitioned tables, indexes and Materialized Views.

Having exposure in Performance tuning and query optimization using explain plan & Hints and debugging using manual and backtrace functionalities.

Experience in Extraction, Transformation and Loading of data directly from different heterogeneous source systems like Flat File, Oracle, and MSSQL.

Analyzing and designing of the Physical and Logical Database Data Models.

Hands on experience in technologies like Oracle, SQL and PL/SQL.

Proficient in writing SQL queries, Cursors, Sub programs like Procedures, Functions, Packages and Triggers in PL/SQL blocks.

Strong skills include Oracle 10g SQL, PL/SQL.

Well acquainted in SQL sub queries, applying constraints, creating views and indexes.

Vast experiences using PL/SQL Collections, Ref Cursor, Bulk collect, Pragma Autonomous Transaction and Oracle Supplied Packages.

Experience History:

Working as Oracle PL/SQL Developer in Zensar Technologies since Feb 2018 to till date.

Worked as Oracle Consultant in BNY Mellon since Sep 2016 to Feb 2018.

Educational Qualifications:

Master of Computer Science (MCS) from SRTM University in the year of 2014.

Bachelor of Computer Science (BCS) from SRTM University in the year of 2012.

Technical Skills:

RDBMS : Oracle 12c/11g

Languages : SQL, PL/SQL

Tools : Toad, PL/SQL Developer, SQL Developer, SQL * Loader. Working Environments : Windows and UNIX

Page 2 of 3

PROJECT #1:

Project Name: ISF General Insurance

Organization: Zensar Technologies Pune

Role: Oracle PL/SQL Developer

Environment: Oracle SQL Developer/Oracle 11g/12c/Toad. Project Description:

Zensar Technologies Limited. On 31 December 2010 Zensar Technologies acquired US-based infrastructure management company PSI Holding, which operates under the name Akibia. In Aug 2014, Zensar Technologies acquired US-based e-commerce firm Professional Access, an Oracle platinum partner with presence in the US, the UK, Latin America, West Asia and Africa. ISF GENERAL covers all major insurance classes of General Insurance. It is easy to use, customizable, comprehensive and easy to implement. ISF GENERAL is designed to meet today's business challenges of General Insurance Organizations. It incorporates the functionalities of a futuristic insurance processing solution.

Project Responsibilities:

Implemented Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Involved in development Application Support, testing and implementation of Oracle database tables/indexes/sequences.

Implemented Business Logic using PL/SQL Scripts (Oracle 10g), by creating necessary objects like Sequence,Functions and SQL*Loader

Writing PL/SQL stored procedures and triggers for automation as per requirement.

Implemented cursors, exceptions and collection in some of stored procedures.

Writing complex SQL queries and sub queries.

Applying Triggers based on business requirements.

SQL loader is used to transfer data from Flat files to DataBase.

Coordinated physical changes to codes, tested and implemented Oracle and SQL database, applying knowledge of data base management system.

Established physical data base parameters and created stored PROCEDURES, FUNCTIONS, PACKAGES, TRIGGERS and SYNONYMS as per the functional requirements.

Writing triggers to track changes done in the database.

Tested and corrected errors and refined changes to database. Page 3 of 3

PROJECT #2:

Project Name: Core Banking

Organization: BNY Mellon

Role: Oracle PL/SQL Developer

Period : Sep 2016 to Feb 2018.

Project Description:

Bank of New York is the leading financial institution in USA. Customer information systems hold customer, account, address, offer, service, statement related details in IMS and DB2 databases. CIS systems passes customer information to ATM, call centers, online banking, mobile banking systems in online and batch mode.

Responsibilities:

● Creating packages, procedures, functions using advanced Pl/sql coding to implement the complex business logic.

● Writing complex queries using multiple tables.

● Analyzed, developed Packages, Procedures and Functions as per the requirement.

● Optimizing SQLs using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.

● Analysis, design, develop, coding and documentation for the requirements.

● Involved in writing Use cases, Unit testing the forms and reports.

● Hands on experience using Database Tools like TOAD, SQL Developer and Other tools like WINSCP, Putty Tools for working between windows and unix.

● Writing PL/SQL stored procedures and triggers for automation as per requirement.

● Extensively used bulk collect and forall to insert and update lakhs of records.

●

Personal Information

Name Praphull Raut

Gender Male

Date of Birth 03 July 1992

Nationality Indian

Address Flat no. 201A, Anand Complex, Somnath Nagar, Vadgaonsheri, Pune- 411014

Declaration

I hereby declare that the information furnished above is true and correct to the best of my knowledge.

Praphull Raut.

Contact this candidate