Post Job Free

Resume

Sign in

oracle plsql

Location:
New Delhi, DL, India
Posted:
April 19, 2014

Contact this candidate

Resume:

Divya Kumar

Mobile: +919*********

acdrdj@r.postjobfree.com

Career Objective

Driven by the thought of proving my capabilities, I am looking forward for an opportunity that would stimulate me into realizing my true potential and in the process contribute effectively in leveraging Computer Science and Information Systems in business

Skill Sets

Operating Systems : MS DOS, Windows 9X, Windows 2000

RDBMS: : Oracle 8i,9i,10g,Sql server 2000

Work Experience

Worked in Nucleus Software Exports Limited since July 2004–Jan 2012 [pursued my Training from Nucleus only.]

Experience 7 year 6 month (Onsite : 7 Months(Tokyo))

Professional Summary

• Seven years of total experience on Banking domain.

• Over 5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System

• 2 years of experience in Microsoft technologies (VB,ASP).

• Strong development skills in application development and developing Database Packages, Stored Procedures/Function using PL/SQL.

• Expertise in Client-Server application development using Oracle 10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER

• Proficient in Oracle Tools and Utilities such as TOAD,Sql developer.

• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

• Vast Experience in using SQL Loader for loading data into Oracle Tables.

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

• Vast experience in directly working with onshore clients and providing system and client support.

• Experience in working onsite in Japan performing knowledge transfer and coordinating with clients.

• Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.

• Experience in working in an Agile Team.

• Good analytical, problem solving, communication and interpersonal skills,with ability to interact with individuals at all levels.

• Ability to work in teams and independently with minimal supervision to meet deadlines.

• Strong management, administrative and leadership skills to work in team.

Project Summary

1) CIC (Credit Information Centre)

Automation of the report generation that Shinsei bank needs to submit to the CIC authority in Japan. This report is generated from FinnOne Lending (a product of Nucleus Software, for BMW portfolio, implemented in Shinsei Bank in Japan) This report summarizes the loan details including the applicant as well as guarantor details of BMW. It is a critical

report for the bank as it contains Customer demographics as well as the applicant financial details. The report is generated in fixed format provided by CIC authority. And Involves complex conditions and logics to attain the required information in the required format. Report is generated parrallely from two source systems [FINNONE and Mainframe] in similar format and then Reconciliation of both the reports is done for the verification. And after the analysis and verification, the report is sent to the CIC authority in encrypted format.The report is generated through batch processes scheduled monthly. This batch process extracts the data from the Finnone Lending system and generates the final report in the desired format.

Technologies used

(Pl/Sql) Oracle 10g, VB6

Role:

1. Held an active role throughout lifecycle of the multiple components required for processing of data.

2. Handled the reconciliation module and Report generator module from Mainframe single handedly including requirement analysis, Functional specification, code implementation and integration testing.

3. Provide support to the system after the system goes to production.

4. Got award recognition and customer appreciation for the completing the System before time span provided by the customer

2. FinnOne™ Lending system

Client : SHINSEI BANK, JAPAN (Nucleus Software Exports Limited)

The FinnOne™ Lending system is the automation of loan processing. It caters to the requirements of any installment-based loan. The product covers the entire life cycle of a loan transaction right from product definition, application processing and documentation, billing and accruals to rescheduling, foreclosures and terminations.

Technologies used

Front end: D2K

Backend: Oracle 10G Rel 2

Role

1. Handling of Production Related Issues.

2. Client Interaction for Enhancement deliveries.

3. Did the enhancement or the client specific changes in the system.

3) FinnOne™ Collection system

The FinnOne™ collection system is the automation of tracking and management of delinquent customers and help the organizations to minimize delinquencies through series of proactive actions and tighter supervision. The system manages the entire collections lifecycle from soft calling to delinquent customers to tackling hard bucket collections,including followups on legal cases till the final closure.

Technologies used

Front end: JAVA

Backend: Oracle 10G Rel 2

Role

1. Understanding of the product.

2. Enhancement to incorporate the client specific changes.

3. Supported the implementation of the product.

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

5. Did the performance tuning of various queries used in the old product

4) MRT (Master Reporting Tool)

Client : Shinsei Bank, Japan (Nucleus Software Exports Limited)

This System automates the reports that Shinsei bank submits to the Legal Compliances like Bank of Japan.

Technologies used

Front end: VB..Net /Oracle 10 G

Backend: Oracle 10g

Role:

1. Involved in the production support for this project.

2. Understanding of all modules.

3. Involved in the continuous enhancements and fixing of production problems

4. Knowledge sharing with other team for upgradation of the system as per the latest technology

5. Involved in UAT Testing and SIT testing for the upgraded system.

PROFESSIONAL QUALIFICATION

Qualification : MCA(Masters of Computers)

University : Banasthali Vidyapeeth

Division : Ist

Year of Passing : 2004

PERSONAL DETAILS

Date of Birth : 26 Sept., 1980

Husband’s Name Mr. Rakesh Kumar

Permanent Address : C- 1107, Mukherjee Nagar, Delhi-110009



Contact this candidate