Ravi Purohit

Res. Address: - B ***

Galaxy Orchid Park

Bangalore 560073

Mobile: - +966*********/+918*********

Current location: - KSA (Kingdom Saudi Arabia)

Email :- adeno1@r.postjobfree.com

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