Mohammed Ali Adnan

Phone No: +974-********

adiigk@r.postjobfree.com

OBJECTIVE:

To Acquire A Challenging Position In An Environment Where I Can Best Utilize My Skills And Education.

Experience:

12 Years and 2 months of Banking Software Industry experience. Skills Summary:

Oracle SQL

9i/10g/11g

Core java

Islamic banking

Oracle pl/sql

Unix

Oracle Forms

Developer 6i

and 10g

Flexcube

HTML,CSS

Python

Core banking

C language

Java script

Flexcube:

Oracle FLEXCUBE Universal Banking, a SWIFT-certified application, is a comprehensive solution to support the needs of retail, corporate, and investment banking. The application offers comprehensive transaction banking capabilities that help you stay ahead of competition. Oracle FLEXCUBE Universal Banking delivers proven success in supporting both conventional and Islamic banking customers globally.

SKILLS:

Good hands on in creating Stored Procedures, Functions,packages, Tables, Cursors,dynamic SQL and handling large data types(CLOB) and xml data types

Worked on the following tools: Winscp,Serena dimensions,IBM Rational Clear Case Microsoft VSS clear case,Putty,Pl-sql developer tool,SQL plus,Oracle forms builder,VERCON,RAD tool,Tectia SSH client,Tectia SSH client,Toad,IBM Tivoli Workload Scheduler,Autosys

Software development, experience in providing solutions core modules in flexcube.

Designing, performance tuning,Optimizing and debugging Oracle objects, batch program and Sql queries towards betterment of adherence to SLAs.

Expertise in core financial modules and core banking.

Expert knowledge on Oracle SQL & PLSQL, Oracle forms.

Knowledge of Core java,JavaScript,python,C, HTML,CSS & UNIX and SDLC.

Excellent communication, team building and interpersonal skills.

Requirements gathering, preparation of functional specification, design specification(program documentation) document and operational instructions, business analysis.

Unit testing (program testing), integration testing and regression testing.

Provide support to SIT and UAT and production.

Communicate effectively with technology partners and clients.

Gap analysis for system applications.

PROJECT DETAILS/ CAREER HIGHLIGHTS:

QNB(Qatar national bank) (July 2018 – till date)

Organization : ARITA Solutions W.L.L.

Designation : Senior Oracle developer

Duration : July 2018 – till date

Client : Qatar national bank

Work location : Doha, Qatar

Database : Oracle 11g

Operating system : Unix, Windows 7

Tools used : Oracle 11g,12c,SQL,Pl/Sql, ASP.net,Core java,Toad,Autosys

Team Size : 10

Role : Team member

Tenure : July 2018 onwards

Roles and Responsibilities:

Develop and provide support to In-house applications and coordinate with all project managers to provide specifications of the In-house applications.

Query tuning of long running queries in production, provide SQL query for data extracts.

Develop SQL objects to generate regulatory banking data for central banks of the respective country.

Investigate, analyze and fix SIT,UAT and production bugs.

Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.

Provide the technical design document about back end objects and provide the same to front end developer and project manager

Implement maker-checker process across various applications Value adds:

Good Exposure to Customer Interaction

Good exposure to ref cursors, dynamic sql, SQL loader,ASP.net and Core java, query tuning, working with sql xml types

Good exposure to query tuning

Good exposure to live banking scenario.

Good exposure to card transactions and reward point application

Good exposure to payments card generation process

Good exposure to QNB raffle draw campaign

ASPAC Flexcube (November 2015 – July 2018)

Organization : Oracle Financial Services Software Ltd. Designation : Senior consultant

Duration : November 2015 – July 2018

Client : Citi Bank ASPAC region

Work location : Singapore

Database : Oracle 11g

Operating system : Unix, Windows 7

Tools used : Oracle 11g, Pl/Sql, Oracle Forms 11g,java,Winscp, putty Serena dimensions, Toad,Autosys

Team Size : 10

Role : Team member

Tenure : November 2015 onwards

Roles and Responsibilities:

Assist all customers and provide production support for all issues related to Flexcube.

Query tuning, analyzing AWR report, bug fixing, SIT, UAT support, requirement gathering, gap analysis

Coordinate with IT groups and external vendors and ensure effective application services to ensure reliability of all applications.

Analyze all business processes and ensure compliance to all controlled processes according to business requirement.

Coordinate with various teams and analyze root cause and assist in efficient resolution of all production processes.

Maintain logs of all issues and ensure resolutions according to quality assurance tests for all production processes.

Unit testing and system integration testing of production issues fixed.

To comply with policies & procedures of IT Dept & the Bank Value adds:

Good Exposure to Customer Interaction.

Good exposure to live banking scenario.

Good exposure to modules such as LD, GL,IC and Limits. Flexcube EMEA,MENA,USA,Poland (September 2008 to November 2015) Organization : Oracle Financial Services Software Ltd. Designation : Senior consultant

Duration : September 2008 to November 2015

Client : Citi Bank MENA,EMEA,USA and Poland

Work location : Bangalore

Database : Oracle 11g

Operating system : Unix, Windows 7

Tools used : Oracle 11g, Pl/Sql, Oracle Forms 11g,java,Winscp,putty Serena dimensions,IBM rationale clear case,Microsoft VSS clear case

Team Size : 10

Role : Team member

Roles and Responsibilities:

Translating Functional requirements into technical solutions

Developing key features of QLM system which replaced FLEXCUBE as product processor for treasury modules like FX and MM and other client projects.

Preparation of functional documents and flow charts of key projects.

Support unit testing and System Integration testing of the projects developed.

Handover of the projects to implementation support team for UAT.

Interacting with clients for gathering information, gap analysis and providing quality solution to their requests.

Requirements gathering and preparation of test plans.

Supporting UAT and initial testing for the given solutions.

Preparation of Technical design from Functional design documents.

Implementing the PW modules for Citi bank UAE and Citi bank Jordan.

Implementation support and Post live support for Citi bank MENA cluster

(Middle east and North Africa) and Poland.

Interacting with clients for gathering information, gap analysis and providing quality solution to their requests.

Designed and developed certain key features of the EBS, ACH(Automated clearing house) and Dodd Frank regulatory changes projects.

Migrated the entire Flexcube from Oracle 10g to Oracle 11g environment for Citi bank(MENA cluster).

Tuning of queries which were consuming more time.

Co-ordinate with the onsite team to provide timely solutions and ensure successful implementation of the projects after go live.

Decommissioning of PC(Payments and collection) and DE(Data entry) module from internet based version of flexcube and inclusion of these modules to Oracle forms version of flexcube.

Tuning critical queries which were consuming high system time.

Modified the PC file dispatch functionality to include the exclude functionality which helps the users to exclude contracts which are not required.

Migrated the entire Flexcube from Oracle 9i to Oracle 10g environment for Citi bank Poland.

Implementing application level tactical solution for reducing the response time of the batch programs run during EOD.

Developed quality solutions for Loans and deposits module.

Developed quality solutions for inclusion of Over payment and refund of interest.

Value adds:

Good exposure to requirements gathering.

Good exposure to unit testing and integration testing.

Good exposure to Payment and workflow(PW),Payment and collections

,Funds transfer (FT), data entry, Loans and deposits(LD) module, SWIFT payment messages and Pro-C technology.

Good Exposure to Customer Interaction, trace file and AWR report analysis and SQL query tuning.

Good exposure to batch optimization and requirements gathering.

Good exposure to preparation of design specification document. Rewards and Recognition:

Received the award We-Applaud a token of appreciation from Oracle financial services for the successful implementation of the periodic release for MENA (Middle east and North Africa) cluster.

Received the award We-Applaud a token of appreciation from Oracle financial services for the successful implementation of FII Code for Securities project for Citi bank Poland.

Received the award We-Applaud a token of appreciation from Oracle financial services for the successful implementation of the I-Cube decommissioning project for Citi bank Poland.

PERSONAL DETAILS:

Name : Mohammed Ali Adnan

Present Address : Doha,Qatar

Telephone No : +974-********,+974-********,+91-80-266***** Date of Birth : 04-MAR-1986

Marital Status : Married

Nationality : Indian

Languages : Urdu, English, Hindi, Kannada

Passport : Yes(Valid till March 2025)

Email : adiigk@r.postjobfree.com, adiigk@r.postjobfree.com Skype user name : adnan041986

Linkedin URL : www.linkedin.com/in/mohammed-adnan-6475ba64 EDUCATION:

Bachelors of Engineering: Electricals and Electronics at DBIT, VTU, Bangalore with a percentage of 71.20% in 2008.

P.U College(12th) : with 63% in 2004 from Surana College, Bangalore.

High School : with 72% in 2002 from Bangalore higher secondary school, Bangalore

HOBBIES:

Stamp collection, Reading books and Playing cricket DECLARATION:

I hereby declare that the information furnished above is true to the best of my knowledge.

Place: Doha,Qatar Warm regards

Date: 21-NOV-2020 Mohammed Ali Adnan

Contact this candidate