Oracle PL/SQL Database Developer : Resume

[Guest]

Shubham Agrahari
shubham.agrahari.380 AT gmail.com

Professional Summary :
- Around 2 Years of professional experience in the field of Software Industry in development & maintenance with Oracle (10g) as database.
- Fluent on Database Programming Technology (Oracle 10g).
- Around 2 years of rich functional experience in IT (Information Technology) in
Retail Banking domain.
- Around 2 years of rich functional experience in MIS Reports in Banking Domain.
- Experience in Oracle database objects development using SQL & PL/SQL.
- Exposure in Core Banking Solutions.

Experience Summary :
- Working as a Senior Software Engineer for IGATE GLOBAL SOLUTIONS from DEC-2010 to till date.
- Total Experience 2 years.

Academic Qualification :
Qualification Name of the institution Year of Passing Percentage/Grade Points :
Master in Computer Application Sri Ram Institute of Technology Jabalpur(M.P.) 2010 68.55%
B.sc(Computer Science) Govt. Model Science College Jabalpur(M.P.) 2006 68.22%
12th (XII) Bardsley EnglishMedium Senior Secondry School
Katni(M.P) 2003 63.60%
10th (X) Bardsley English Medium Senior Secondry School
(Katni-Madhya Pradesh) 2001 63.00 %

Technical skill set :
Languages : SQL,PL/SQL.
RDBMS : Oracle 10g & 9i.
Database Tools : TOAD

Major assignments :
April2011-Till DATE
Project : Report Server
Client :ING Vysya Bank Ltd., Data center, India
Industry Banking
Role :Requirements gathering, Design, Development, Document.
Team size : 2
INGVYSMIS – ING VYSya bank Management Information System
Description :
INGVYSMIS is a web based Management Information System serving more than 5000 users. Allows many MIS reports to be centrally generated. The data from PROFILE(Core banking system), FMS (Financial Management System),ATM Switches and other Department data will flow to report server on daily and monthly basis. With this data more than 100 reports are generating on corporate, Regional & Branchlevel.
- RBI Reports, Cibil(Credit Information Beuro India Limited), SLMG(Special Loan Management group),NPA(Non-performing Assets) are the few major reports in INGVYSYA Bank handling by Report server.
- Email & Physical statement of accounts(All type of accounts) for INGVYSYA bank customers will be generates at the corporate end on the basis of Report server data.

Contribution :
- As a Developer involved in Requirements gathering, Design, Development and Document
- As the entire branches are depending on report server for lot of report huge amount of data handeled(nearly 500 GB).
- Total of my IT experience I worked in client location. As I worked entirely in client location, interaction with the client was more.Use to attend meetings with client.

Module (1) : RBI(Reserve bank of India)
Technology: oracle (10g)
Right from the establishment of INGVYSYA few reports are submitting to RBI by manually filling in the form of excel files. As per the RBI rule from 2010 these reports are to be automated.With the help of classic ASP and oracle data base reports are automated and manully filling logic implemented into technical logic which saved lot of time and accuracy.

Module (2) :Cibil(Credit Information Buero India Limited)
Technology : oracle (10g)
This module is second most significant module in ingvysya. As the data flows from core banking profile team to Report server, a separate set of team is there in ingvysya corporate office to handle the cibil reports where data to be extracted as per the cibil document. Once the cibil team sends the latest version of cibil document, as per the latest version necessary reports has to be generated from Report server. Cibil needs loan section data alone. Normally cibil data files are classified in to three sections (Consumer, Commercial & Mortgage).

Module (3): NPA(Non Performing Assets)
Technology : oracle (10g)
RBI came up with a new set of Non-performing Assets classification which has to perform in all banks. For new version of Non-performing Assets classification, Ingvysya corporate made Report server as the centralized unit in order to generate reports. As the NPA data from all the systems flowing to report server, this module focus mainly on the customers who are NPA in one system but not NPA in other systems that means once the Customer is NPA in one system because of this particular customer how much balance is going to come under NPA in other systems. These details must submit to RBI.

Achievements :
- RBI reports automation done in INGVYSYA which were submitting manually to RBI from the day bank established.
- Cibil reports generation done from report server data which decreases the manual work.
- Along with the above nearly 15 modules handled and as part of enhancement & support nearly 50 plus tickets and Client requests has been done independently.

Certification :
- Oracle Certified Associate with ORACLE TEST ID – Oc1187267.

Personal Details :
Date of birth : 19-DEC-1985
Nationality : Indian
Gender : Male
Linguistic Proficiency : English, Hindi.
Marital Status : Single

Declaration:
I hereby declare that the above written particulars are true to best of my knowledge and belief.

Place :
Date :

Shubham Agrahari.

[Guest]

I want to work in your company with honesty.