Developer Sql

Name: Vipin Vinesh

Contact No: +91-989*******

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

Assistant Manager – IT

Professional Summary.

Over 2 years of programming experience as an Oracle PL/SQL Developer at HDFC BANK in Analysis, Design and Implementation of Business Logic using Oracle Relational Database Management (RDBMS).

Involved in all Phases of Database Development from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Expertise in Client – Server application development using Oracle 11g/10g, PL/SQL, SQL*PLUS and SQL*LOADER.

Effectively made use of Indexes, Table Partitioning, Analytical Function, Materialized Views.

Experience in ETL (Extract, Transform and Load).

Created Tables, Views, Constraints, Index (B-Tree, Bitmap and Function bases).

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

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded data into Oracle table using SQL Loader.

Partitioned large table using Range Partition technique.

Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.

Created a Stored Procedure that automatically drop table indexes and create table indexes.

Worked on Ref Cursor, External Tables, Collections, DBMS_SCHEDULAR and Exception Handling.

Knowledge of key Oracle performance related feature such as Query Optimizer, Execution Plans, Indexes and Parallelism.

Experience in ETL technique and Analysis and Reporting including hands on experience with the reporting tools Tableau and Jasper Soft ETL.

Created Shell Scripts for invoking SQL Script and scheduled then in crontab.

Excellent communication, technical and analytical skill and strong ability to perform as part of a team.

Technical Skills.

Databases: Oracle 10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000, MY SQL, SAS and IBM Netezza.

ETL Tool: Jasper Soft ETL, MAX IQ (Hadoop based tool), SQL*Loader.

Reporting Tools: Developer Suite, Tableau, and Jasper soft ETL.

Operating System: Windows 7, UNIX (LINUX, AIX).

Languages/Utilities: SQL, PL/SQL, UNIX shell scripts and sas language.

Other Tools: SQL Developer, Aginity Workbench for Netezza, AutoSys, Max IQ.

Educational Qualifications:

Bachelor’s in Computer Science.

Diploma in Computer Engineering.

Professional Experience.

Project Name: BASEL 2 Internal Rating Based (IRB) Approach.

Company: HDBC Bank.

Role: Oracle Pl/SQL Developer.

Duration: June’14 –Present

Description:

The IRB (Internal Rating Based) approaches for calculation of Capital Charge for Credit Risk. It is an end to end application fetching required input data from various sources and front end is provided for running stored procedures, uploading all master tables and input files.

Responsibility:

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

Creation of database object like tables, views, materialized views,procedures and packages using oracle tools like PL/SQL Developer and SQL*PLUS.

Extensively use of bulk collection in PL/SQL objects for improving performance.

Created records, tables, collections (nested tables and arrays) for improving Query Performance by reducing context switching.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Worked on SQL*Loader to load data from flat files obtained from various facility every day.

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

Extensively used the advanced feature of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE packages.

Environment: Oracle 11g, SQL*Plus, SQL*Loader, SQL Developer, Visual Studio 2010(VB.NET), Shell Scripts, WINDOWS 7, UNIX.

Professional Experience.

Project Name: Project 360 (P360) income computations.

Company: HDBC Bank.

Role: Oracle Pl/SQL Developer.

Duration: Mar’15 – Oct’15

Description:

The P360 (Project 360) income source is a project which earn around bimonthly 250cr ($45 million) for bank by offering loan to the customer. It is used to derive income of customer from various sources i.e. through neft, imps, tax etc. These are customers where they do not provide their income .The different business and policy logic their average income, loan cap and criteria are generated. Based on their criteria loan amount has been offered to the customer

Responsibility:

Developed Stored Procedure, Functions, Triggers, Indexes and Collections to implement business logic.

Wrote complex SQL queries using joins, subqueries to retrieve data from database.

Used Jasper ETL to load data into staging tables.

Involved in coding conversion from sas language to PL/SQL.

Improved the performance of the application by rewriting the SQL queries.

Extensive use of Analytical Function in PL/SQL such as LAG, LEAD etc for implementing business logic.

Worked in Production Support Environment as well as QA/TEST environment for projects, work orders, maintenance requests, bug fixes, enhancements, data changes etc.

Wrote SQL, PL/SQL, SQL*Plus program required to retrieve data using cursors and exception handling.

Developed and modify triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically bases on user inputs.

Perform DML, DDL Operations as per the Business requirement.

Creating views and prepares the Business Reports.

Environment: Oracle 11g, SQL*PLUS, PL/SQL, SAS Enterprise guide, SQL Developer, Windows7.

Professional Experience.

Project Name: KGC AGRICULTURE SCORE CARD

Company: HDBC Bank.

Role: Oracle Pl/SQL Developer.

Duration: Nov’15 –Present

Description:

The project is based on KGC (Kissan Gold card) which is used to develop a score card based on the source data. This scorecard is used to check the eligibility of the customer for a loan offer.

Responsibility:

Involved in database development cycle of Planning, Analysis, Design, Development, testing and Implementation.

Created and modified SQL*PLUS,PL/SQL and SQL*Loader script for data conversions .

Fine –tuned procedures /SQL queries for maximum efficiency in various databases .

Extensive use of Analytical Functions in Oracle .

Wrote complex SQL queries like joins,sub queries to retrieve data from databases.

Used jasper ETL to retrieve data from different databases.

Extensive use of Analytics function, Aggregate function in queries

Environment: Oracle 11g, SQL*PLUS, Jasper ETL,PL/SQL, SAS Enterprise guide, SQL Developer, Windows7.

Personal Particulars:

Date of Birth: 21 June, 1990.

Gender: Male.

Nationality: Indian.

Language: English, Malayalam, Hindi.

Phone: +91-989*******(mob).

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

Notice Period: 3 Months.

Declaration:

I hereby certify that the foregoing information is correct to the best of my knowledge and belief. I have not suppressed any material fact or factual information in the above statement.

(Vipin. Vinesh)

Contact this candidate