Oracle-PLSQL Developer

`

HARJINDER.SINGH JASWAL

B.E(IT)

Mobile:-****-773-***-****

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

USA VISA STATUS: - B1 VISA (Valid till 2023).

Work Experience

* ***** ** ********** ** Oracle PL/SQL Programmer.

Currently working with HARJAI Computers PVT LTD, Mumbai as

Senior Software Engineer (ORACLE-PL/SQL) from 6th Apr 2018 till date.

Creating Packages, Procedure, Function, Triggers, Writing complex Queries

Organization: HARJAI Computers PVT LTD.

PROJECT Name

Reliance Home Finance / Reliance Commercial Finance(ONSITE)

Software

Operating System

Windows 2000/XP Professional

Database

Oracle 11g

Role Played

PLSQL Developer (Development and Support).

Duration

06-Apr-2018 till present

Team Size

5

Self-reliant/Staff Portal:-

8 sites on this portal for RHF and RCF 4 sites each

All sites and organizations managed on LifeRay platform.

Developed portal is used as self service for registered Customers

Customer can manage Loan engagement with RCF/RHF

Customer can pay EMI dues / charges through agency payment gateways - TPSL

Staff portal is developed for both RCF and RHF as a first contact team – Call centre

Staff users can view customer personal details and loan details

Responsibilities:

Development participation involves SQL queries, PL/SQL programming and extract data from

DWH – Oracle Exadata

Development of data sources and maintenance of Functions, Joins, Cursors and Views

Involved in writing complex Procedures, Packages and implementing the concept of PL/SQL to perform complex operations.

Tuning of Complex Queries using Oracle Hints and writing views, Complex Queries.

Major Highlights of the project:

Fetching of customer details and customer loan details on the fly w.r.t. customer id / Loan Id / KYC Id on website

Integration with WhatsApp for customer communication assistance

Major involvement in development of DLP – Digital Lending Platform

Integration with Core system – FinnOne LOS / LMS / CMS

Integration with POSEIDEX for fetching customer profile details

Integration with NSDL for fetching CIBIL details

Integration with Customer verification system – In House developed process

Organization: Creative Express Services LLC,UAE

PROJECT Name

OHFC (Orient Housing Finance Corporation)

Software

Operating System

Windows 2000/XP Professional

Back End

Oracle 11g

Role Played

PLSQL Developer (Development, Crystal reports).

Duration

15-OCT-2014 to 28-FEB-2018

Team Size

8

Brief Detail

Project Description

Deals with financing the lower income group customers for purchasing mortgages

System saves KYC details i.e. personal, income, expense and other important details.

Next work step involves approval mechanism of Credit committee.

System involves 4 modules

Project Setup Module:

Module has Builder details, Project details, Project Phase details, Building Phase Schedule, Approval details. etc.

Pre Loan Sanction Module:

In this module processing of login applications from Loan Applicants directly, will process data into different types of forms based on the instructions of MHFC.

Post Loan Sanction Module:

Verification of the Loans taken and reviews against the same, main purpose is checking whether the documents were submitted or not. Checking of documents from the Applicant.

Accounting Module:

Starts with Receipt Page travels till Auto PayinSlip.This module also contain Excess Adjustment, where user can adjust / manage amount paid.

Organization: CLOVER INFOTECH Mumbai.

PROJECT Name

Management Information System(MIS)

(SBILIFE INSURANCE).

Software

Operating System

Windows 2000/XP Professional

Back End

Oracle 11g

Role Played

PLSQL Developer (Development, Deployment & SSRS, Crystal reports).

Duration

20-JUL-2012 to 01-Sep-2014

Team Size

10

About MIS:-

The SBI Life Insurance Company maintains different Data Bases based on the data which flows through several

operations like Marketing, Sales and Policy Servicing ect. The MIS Team maintains De-Normalized data base

(Data Warehouse) which includes data from several operational sources.

SBI Life Business Analysts from Different Departments like Operations, Finance, and Marketing find difficult

to analyze data scattered into different roots so they raise request to IT group to provide them with reports for

their Analysis called MIS which is part of Data Warehouse. MIS team generates reports using Crystal Reports

And SSRS.

These reports are then sent to the users for User Acceptance Testing and once they are approved they are deployed in production serves, the reports which are developed through Crystal Reports are deployed on Business Objects Enterprise and reports which are developed using SSRS are deployed on SQL Server SharePoint Server in which the user can run the reports globally.

Responsibilities:

Active participation in Data Warehousing environment to extract data for different operations

Like Policy Serving, IRDA data operations, Policy Claims, Policy Underwriting and for Financial and Budgetary Controls using SSIS (SQL Server Integration Services) Technology and Crystal reports XI.

Involved in creating Hierarchy Tree ids to provide access control to the reports.

Work experience in creating Database links between two different databases.

Loading data from flat files into database tables using SQL* Loader.

Hands on experience in modifying existing Reports by adding new fields or modifications to the existing field's functionality.

Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming, and extract data from large database

Involved in development, maintenance of Functions, Joins, Cursors and Views

Involved in writing complex Procedures, Packages and implementing the concept of PL/SQL to perform complex operations.

Generating custom reports using Crystal Reports XI and SSRS.

Tuning of Complex Queries using Oracle Hints and writing views, Complex Queries.

Involved in providing access to the reports deployed in the Share Point Server for the requests comes from SBI Life employees across India.

Involved in deploying reports on Business Object Enterprise and SQL Server

Share Point Server.

Development Environment:

Oracle 11g, Windows XP, TOAD, SQL Developer, Crystal Reports XI, MSBI, Business Objects, and SSRS, Win CVS.

Organization Creative Express.

Project Name

TMS(Transport Management System)

Software

Operating System

Windows 2000/XP Professional

Front End

ASP.NET

Back End

ORACLE 10g

Role Played

PL/SQL Developer

Duration

MAR 2012 to 10 JUNE 2012

Team Size

05

ABOUT TMS:

Transport Management System is an application which allows for the execution of the transportation plan such as carrier rate acceptance, carrier dispatching, editing of reception, custom clearance, invoicing and booking documents, sending of transport alerts (delay, accident, non-forecast stops…) etc.

Organization: Osource India Pvt. Ltd Mumbai.

Project Name

Cachet Pharmaceuticals Pvt. Ltd

(A pharmaceutical sector by manufacturing of pharmaceutical formulations.)

Software

Operating System

Windows 2000/XP Professional

Front End

ASP.NET

Back End

Oracle 11g (Using XML)

Role Played

PL/SQL Developer (Development& Deployment).

Duration

Sept 2010 to Mar 2012

Team Size

06

Cachet is a Pharmaceuticals application which is also an ERP system that integrates

Internal and external management information across an entire organization,

Manages finance/accounting, manufacturing, sales and service etc.

Development Environment:

Oracle 11g, Windows XP, TOAD, and Crystal Reports.

Organization Opus Software Systems Mumbai.

Project Name

DCMS (Debit Card Management System)

Software

Operating System

Windows 2000/XP Professional

Front End

ASP.NET

Back End

Oracle 10g,Unix

Role Played

PL/SQL Developer

Duration

April 2010 to Sept 2010

Team Size

06

ABOUT DCMS:

Creation Of pin for Debit cards at database level.

Creation of testing environment for testing, creation of master data files and batch programs

Hot listing, linking and delinking of Debit cards at database level and

Forward the batch for embossing to DEI.

technical skills:

OPERATING SYSTEM: Windows98/2000/2003/XP, Ms DOS,

LANGUAGES: SQL, PL/SQL (ORACLE), SQL*Loader, SQL*PLUS

TOOL: Toad, Oracle-SQLDeveloper, Basic Oracle Forms,

Crystal and SSRS Reports, WinCVS.

CONCEPTS: OOPS, DBMS.

DATABASES: Oracle 11g, Oracle 10g, Oracle 9i & 8i

SCRIPTING LANGUAGES: BASIC HTML,XML

educational profiles:

Examination

University/ Board

Year of passing

Percentage of marks

Remarks

S.S.C

Maharashtra Board

2000

53.33%

Second

Class

H.S.C

Maharashtra Board

2002

57.17%

Second

Class

Diploma in Information Technology

Mumbai University

2005

63.83%

First Class

B.E in IT

Mumbai University

2009

64.53%

First Class

professional qualification:

O.C.A. (Oracle Certified Associate):-in Developer Track.

INTERESTS AND HOBBIES:

Learning new Technologies & Books, Listening to music,Playing Cricket

Talking to people and learning new things.

Very Much interested in PL/SQL Programming, Database Administration

Highly inspired individual with strong team orientation and CAN-DO attitude.

personal information:

Father's Name : AVTAR.SINGH JASWAL

Date of Birth : 16th JAN 1985

Language Known : English, Marathi, Hindi

Address : Someshwari Bldg Flat-003, Plot-12, Sector-18

Kopar Khairane Navi Mumbai-400709

I hereby declare that all information is mentioned above are correct to the best of my knowledge and belief.

[HARJINDER.SINGH]

Contact this candidate