Project Java
Resume:
Ravi Purohit
Res. Address: - B ***
Galaxy Orchid Park
Bangalore 560073
Mobile: - +966*********/+918*********
Current location: - KSA (Kingdom Saudi Arabia)
Email :- *********@*****.***
Professional Summary:
IT experience
Years in OFSS
148 months
12 years
Having overall IT experience of 12 years and 4 months.
Accomplished problem solver with the ability to focus on a single task for long periods of time.
Excellent reading comprehension skills with the ability to quickly learn new software languages.
Skilled in using SQL, PL/SQL, JAVA SCRIPT, XML
Familiarity with Java J2EE, EJB, WEBLOGIC
Competent with analyzing the possible outcomes of different actions and choosing the best one.
Able to explain complex problems to non-software engineers and assist in troubleshooting.
Person of great integrity with experience keeping internal practices confidential.
Qualifications:
Degree Institute
B.E. MIT Manipal MAHE University
Technical Skills:
Languages
Oracle SQL, PL/SQL, Core Java
Application Server
WebLogic 12c,10.3.6, SOA 11.1.1.6, Oracle Application 10gAs and 9iAs
Key skills
Core banking data migration, Performance tuning,Java,PL/SQL, System integration, Interfaces,Webservices,HTML,XML
Database
Oracle 12c,Oracle 11g, Oracle 10G
Scripting Languages Java Script, HTML, XML, JSP
OS
UNIX, Windows 2000, XP, 2007 server
Career Profile:
Professional Experience:-
Created technical design for the back end PL/SQL based on business requirement documents and the functional system design.
Creation of database objects like tables, views, synonyms, materialized views, stored procedures, packages using Oracle tools like PL/SQL developer.
Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Involved in updating procedures, functions, triggers, and packages based on the change request.
Built complex queries using SQL and wrote stored procedures using PL/SQL.
Used ref cursors and collections for accessing complex data resulted from joining of a large number of tables.
Involved in moving the data from flat files to staging area tables using SQL loader.
Extensively used for all and bulk collect to fetch large volumes of data from the table.
Performed SQL and PL/SQL tuning and application tuning using various tools like tkprof, auto trace and dbms_SQLtune.
Executed Quality Control checks of source code created by other developers.
Monitored incoming/outgoing data. Troubleshoot errors as they occur.
Project Details :-
1
Project
:
Middle east consulting / GIB Production Support
Client
:
Gulf International Bank
Duration
:
Oct 2018 – till date
Technology
:
Oracle 11g database, Oracle 11g Application Server, Unix, Java, XML,PL/SQL
Role
:
Production Support/Project coordination
Description (in brief):
Production support and Project Support
Responsibilities (in brief):
Production support Flexcube UBS 11.4 version
Flexcube enhancement deployment and coordination with offshore
Production End of day support
Worked on following
(i)FT,CL,Islamic finance & Accounts, ELCM Production Bug fixes
(a)ELCM utilization mismatch correction and fixing
(b)Loans Provision related base issue fixing
(c)Funds transfer STP requirements analysis and fixing
(d)IC PDM fixes and correction accounting entries
(e)CL Track Receivable fixes
(f)Commodity and FCY Term Deposits – Fixing on Rollover and Close on Maturity cases
(g)Population of intermediaries as part of Payments module
(h)ATM Retry batch implementation
(i)Saudi credit Bureau handoff changes
(j)Account closure status handoff to cortex
(k)SAR international payments requirement analysis
(ii)FT project support for UAEFTS BIC & SWIFT 2018 changes
(a)UAE funds transfer BIC codes are issued by the central bank which are non-compliant to SWIFT BIC code standards
(b)SWIFT 2018 UETR changes
(iii)VAT Bahrain, VAT Invoice & Statement changes
(a)VAT Bahrain is a complicated setup at GIB as the charge currency is USD whereas VAT is to be charged in BHD and also VAT is to be excluded for some branches which are running in the same instance
(b)GIB is using commitments in Bahrain instance, VAT charge setup done for commitments
(iv)Blanket OD, Customer benefit transfer project support
(a)Handling of account overdraw cases for transactions initiated by customer and transactions initiated by system
(b)Customer benefit transfer project is to support subsidy balance provided by the government to the people which is to be utilized by bank only for customer initiated transactions
(v)Payment enhancement
Key changes part of the enhancement
(a)Standing instructions SWIFT message value date change based on currency spot days
(b)Standing instructions to consider value dated balance
(c)1 AED charges for payment messages routed through central bank
(vi)SAMA Retail Collections
Key changes part of the enhancement
(a)As per SAMA regulations for salaried customers system should deduct up to one EMI only in an EMI cycle
(b)A new screen is provided to delete the track receivable records
(vii)Unclaimed freeze and control over sanction
Key changes part of the enhancement
(a)There should be a provision in the system to sanction a customer to restrict any transactions to the accounts belonging to the sanctioned customer
(b)When an account reaches unclaimed freeze status due to document expiry, the customization is to close such accounts if the account is less than or equal to 100SAR and move the balance to an unclaimed GL. If the balance of the unclaimed freeze account is more than 100SAR system should open a suspense account and move the balance from main to suspense account
2
Project
:
Middle east consulting offshore development
Client
:
Mashreq bank & Ithmaar bank Bahrain
Duration
:
Aug 2017 – Sep 2018
Technology
:
Oracle 11g database, Oracle 11g Application Server, Unix, Java, XML,PL/SQL
Role
:
Lead development
Description (in brief):
Lead development for Ithmaar and Mashreq bank customization items
3
Project
:
National bank of Egypt & Credit Agricole Egypt
Client
:
National bank of Egypt & Credit Agricole Egypt
Duration
:
Jan 2016 – May 2017
Technology
:
Oracle 10g database, Oracle 10g Application Server, Unix, Java, XML
Role
:
On site consultant
Description (in brief):
Implementation of FCUBS 12.02, legacy system was IBM mainframe/FCC + FCR
4
Project
:
Diamond bank Nigeria post live
Client
:
Diamond bank Nigeria
Duration
:
Nov 2014– Jan 2015
Technology
:
Oracle 10g database, Oracle 10g Application Server, Unix, Java, XML
Role
:
Onsite consultant
Description (in brief):
The scope of this project was to implement new customization and functionality, also to resolve the pending implementation issues in CL & ELCM
5
Project
:
GCB FCUBS 12.0.1 Upgrade from FCC + FCR
Client
:
Ghana commercial bank Accra Ghana
Duration
:
Aug 2014– Oct 2014
Technology
:
Oracle 10g database, Oracle 10g Application Server, Unix, Java, XML
Role
:
Onsite consultant
Description (in brief):
The scope of this project was to upgrade the core banking system FCC + FCR to FLEXCUBE universal banking solution version 12.0.1
6
Project
:
AFRASIA Upgrade
Client
:
AFRASIA Port Louis Mauritius
Duration
:
Nov 2013– Apr 2014
Technology
:
Oracle 10g database, Oracle 10g Application Server, Unix, Java, XML
Role
:
Tech Lead
Description (in brief):
AFRASIA bank Mauritius is upgrading its core banking system Flexcube from the existing version of 7.3 Flexcube Corporate to 12.0.1 Flexcube UBS
7
Project
:
DTB Kenya Go live and Post live
Client
:
Diamond trust bank Kenya
Duration
:
Sep 2013– Oct 2013
Technology
:
Oracle 10g database, Oracle 10g Application Server, Unix, Java, XML
Role
:
Onsite consultant
Description (in brief):
The scope of this project was to upgrade the core banking solution from FCR 6.6 + FCC7.3 Version to FCUBS 12.0.1.
8
Project
:
Alpha Bank Greece Offshore
Client
:
Alpha Bank, Greece
Duration
:
May 2013 – Aug 2013
Technology
:
Oracle10g, RAD tool, Java Script, Java
Role
:
Developer
Description (in brief):
The project involved
Pl/Sql code tuning for AML extraction AB Serbia
Design and Development for Flexcube Interface QCS extraction of the following 4 countries, Albania, Bulgaria, Fyrom and Serbia.
9
Project
:
Family Bank (formerly Family Finance Building Society)
Client
:
Family bank Kenya
Duration
:
May 2012 – May 2013
Technology
:
Oracle 10g, Java Script, Java and RAD Tool
Role
:
Onsite consultant
Description (in brief): Production support
10
Project
:
SICOM Offshore Reports Development and EMS Setup for Swift Messaging
Client
:
SICOM Mauritius
Duration
:
Dec 2011 – May 2012
Technology
:
PL SQL, RTF, XDO, XML, HTML, Core Java
Role
:
Technical Consultant
Description (in brief):
Flexcube Offshore setup and reports creation
11
Project
:
Project India Consulting FC Retail
Client
:
FCR DLB and Yes bank
Duration
:
Jun 2011 – Nov 2011
Technology
:
PL SQL, Java Script
Role
:
Technical Consultant
Description (in brief):
Enhancement for Dhanlaxmi and Yes Bank
a.GEFU Upload SCH and SCH Reports
Developed bank side detailed and summary Reports for Service Charge hold.
b.Gross TD and TDS TD reports.
c. Sweep in threshold
12
Project
:
UBS Bank Mumbai
Client
:
UBS AG Mumbai
Duration
:
Jan 2011 – Jun 2011
Technology
:
Oracle 10g, Oracle BIP reports, java script, Java
Role
:
Technical Consultant
Description (in brief):
Implementation and Support FCUBS version 10.3
13
Project
:
Siddhartha Bank Limited Kathmandu Nepal, Onsite and Offshore Production Support
Client
:
Siddhartha Bank Nepal
Duration
:
Apr 2010 – Dec 2010
Technology
:
PL SQL, XML, JavaScript
Role
:
Technical Consultant
Description (in brief):
Siddhartha bank Kathmandu Nepal decided to replace its legacy core banking system with FLEXCUBE 10.2 Core banking application
Goal of this project is provide post live support to the bank
14
Project
:
FCUBS 10.5 Support Activity
Client
:
Internal
Duration
:
Nov 2009 – Mar 2010
Technology
:
Oracle 10g, Oracle BIP reports, java script, Java
Role
:
Technical Consultant
Description (in brief):
The scope of the project was to develop the FCUBS version 10.5, the basic idea behind coming up with this version is to stabilize the product as a whole and value addition by incorporating new features
Contact this candidate