Oracle plsql

*****.***@*****.***

NAZIR AHAMMED +*** - ******101

EXPERIENCE SUMMARY:

Over 12 years of experience in Information technology industry as a senior software engineer, developer and in the development and maintenance of various Insurance and banking applications using Oracle 9i,10g, 11g,12c

Working in Banque Saudi Fransi over 3 years as a OFSAA (Oracle Financial Services Analytical Applications) Consultant

Have 8 months onsite experience in United Kingdom

Have 1 month onsite experience in Genworth, Australia

Experience in OFSAA application in 3 years in Banque Saudi Fransi, Riyadh, and over 8 years’ experience in various financial sectors like, banking, mortgage insurance, vehicle insurance and derivatives.

Experience in working with Bulk Collections, Bulk binds, PL/SQL VArrays, and Nested tables.

Very good experience in dealing with the Oracle Database applications by writing queries and stored procedures. Smart enough to work efficiently with emerging technologies.

Experienced in developing database applications using Oracle 9i,10g,11g as back-end and java based technologies for front-end web access.

Built a complex Enterprise Java ecosystem in collaboration with development team.

Java/J2EE, Messaging framework, Multi-threaded programming, JavaScript, JSP, AJAX, CSS

Design, analyze, develop, code, test, debug and document in solving business problems for one or more business areas

Ability to work individually and in teams and understanding the work culture and work ethics.

Experience in communicating with customers, business & technical groups and quality analysts during various stages of SDLC.

Experience:

Company Name

Designation

Start date

End date

Kanoo Elite Pvt Ltd, (Riyadh)

Senior Software engineer

01-Jan-19

Till date

Al-Saedeya (Riyadh)

Senior Software engineer

30-Oct-15

31-Dec-18

Tata Consultancy Services

IT analyst

25-Aug-13

15-Oct-15

HCL Technologies

Senior Software engineer

11-Feb-10

19-Aug-13

Helious & Matheson Technologies

Software engineer

25-Jun-09

5-Feb-10

Thirdware technologies

Software engineer

10-Dec-07

31-Jan-09

Enrich Outsourcing

Software developer

10-May-06

7-Dec-07

TECHNICAL SKILLS:

Programming Languages

SQL, Advanced PL/SQL

Databases

Oracle 9i, 10g,11g,12c

ETL

Datastage(Intermediate level)

Database Tools

Sql editor, TOAD

Applications

OFSAA (Oracle Financial Services Analytical Applications), Tia, Guidewire(PC,BC,CC), Jasper reports

Domains

Banking, Insurance, Derivative markets

Operating systems

Unix, Windows 98, Windows xp, 2007

Education

College/School name

University

Degree

Major

Year of passing

Jamal mohamed college

Bharatidasan University

M.Sc

Information technology

2006

Jamal mohamed college

Bharatidasan University

B.Sc

Chemistry

2003

KAPV Hr sec school

Hsc

2000

SMSV Hr Sec school

SSLC

1998

CERTIFICATION

Oracle Database Cloud Service Certified – IZO - 160

Acquired Oracle Certified Associate from Oracle Corporation in Oracle 9i

Introduction to Oracle 9i-SQL 007 : 84%

Program with Oracle 9i- PLSQL 147 : 92%

PROFESSIONAL EXPERIENCE:

Organization: Al - Saedeya(Jan 2019 – Present)

Client : Banque Saudi Fransi, Riyadh

Senior PL/SQL Developer Jan 2019 – Present

Project Name: Corporate Resource Management (CRM)

OFSA (Oracle Financial Services Applications)

CRM introduce set of new validation to fetch the data from Source into staging database, Web services is used to transfer the staging data’s to various application.

In organizational studies, corporate resource management is the efficient and effective development of an organization's resources when they are needed. Such resources may include financial resources, inventory, human skills, production resources, or information technology (IT).

Responsibilities:

Creating Oracle stored procedures.

Written various complex SQL queries

Organization: Al - Saedeya(Oct 2015 – Dec 2019)

Client : Banque Saudi Fransi, Riyadh

Senior PL/SQL Developer Dec 2017 – Present

Project Name: ALM

ALM conventions on liabilities data (NCBDs and CBDs) upstream at the data delivery level. The final set of data will directly feed the ALM system (SUNGARD Ambit Focus).

To define the period for the moving average, we have to look at the file “ALM Conventions Feed Table.xlsx“ which describes the parameter table ALM_FEED_CONVENTION. We will use the value of the field “PARAMETER_VALUE” where the “PARAMETER_LABEL” field is equal to value “NCBD_AVG_MTHS”. We take the parameter values for the given as of date (“ select max(AS_OF_DATE) where AS_OF_DATE<= [Given As Of Date of the run]”). This parameter value corresponds then to the number of months of the observation period. So if it is equal to 3, then it means that we will take the average of all daily snapshots from the last 3 months starting from the given as of date of the data run (creation date).

Responsibilities:

Written various complex SQL queries

Writing PLSQL procedures

Move the required data using datastage(ETL)

Project Name: BASEL Feb 2016 – Dec 2016

Reconciliation between Balance Sheet and Risk Watch Output figures is the most integral and first step in the SAMA – Basel Reporting process – Q 17 reports production. The reconciliation between the General Ledger known as “Balrpt2” and Risk watch output known as “Aggregation by Acct Type” is currently being done manually by RMPD and is required to be automated as part of the regulatory requirement.

There are approximately 389 account types (GL codes) and 187 transaction types (please refer to Annexure I and II for the details) covering On - Balance Sheet, Off - Balance sheet and Derivatives in the Balance Sheet that is required to be reconciled manually with the risk data for the process of SAMA Q-17 production. In addition to the manual reconciliation of balances at account type (GL code) level, there is a need to handle new account codes added (by accounting) and Transaction Types (in RiskWatch) in the previous quarter that creates inconsistency between risk and finance data.

Responsibilities:

Creating Oracle stored procedures.

Developed PL/SQL packages, to enrich, load & reconcile feed data into the database and data manipulations

Written various complex SQL queries

Project Name: FATCA Nov 2015 – Oct 2016

FATCA takes a non-cooperative approach to foreign financial institutions (FFIs) to ensure that Americans don’t hide money from the IRS. FATCA introduce set of new validation to fetch the data from Source into staging database, Web services is used to transfer the staging data’s to various application.

Responsibilities:

Creating Oracle stored procedures.

Written various complex SQL queries

Organization: TCS(Sep 2013 – Oct 2015)

Client : Standard Charted bank, Chennai

Team Lead. Sep 2013 – Oct 2015

SCI is the designated core client static system for WB and is used by many downstream reporting application(Internal and external regulatory) at Group level. SCI revokes a detailed view of the process / system interim changes required on the SCI side to enable the straight through publishing core client static data from CDD to SCI for creation and maintenance process.

Responsibilities:

Analyzing SQL server Stored procedures and migrate Oracle stored procedures.

Java, Oracle PL/SQL, JSP, JDBC, Weblogic

Involved in writing the database SQL queries, Views, Functions and Procedures Environment: Java, JSP, Mysql Database, jQuery, HTML, CSS, Ajax, Json, Apache Tomcat Server, Netbeans IDE, SVN Tortoise.

Environment: Oracle 10g, Oracle 11g

Organization: HCL Technologies(Feb 2010 – Aug 2013)

Client : eSure, UK

Software engineer. Feb 2011 – Aug 2013

Esure is one of the largest personal insurance providers in the UK; it offers a variety of Insurance products including Motor Insurance, Home Insurance, Pet insurance and Travel Insurance. The company uses TIA (The Insurance Application) an application tailored with Oracle forms 10g and oracle Database 11g. The application is designed emulating an N Tired Architecture and has a Service Oriented Architecture involving numerous third party applications, databases. The application mainly comprises of Policy Admin, Renewals, Claims, Referrals, Print and the Batch processing modules. The majority of the modules are built with the SQL and Pl/Sql coding. The Print part deals with the Adobe jet Form Template and the batch dealing with UNIX shell scripting.

Responsibilities:

Involved in writing JSP’s SQL scripts

Portal, Weblogic Server and Windows-7.

Experience in writing SQL Queries, PL/SQL Stored Procedures.

Environment: Oracle 9i, 10g,

Organization: HCL Technologies (Feb 2010 – Present)

Client: MeM PC & BC Implementation, USA

Software engineer. Sep 2010 – Jan 2011

Missouri Employers Mutual Insurance (MEM), Missouri’s largest workers’ compensation insurer, and Guidewire Software®, a leading provider of flexible core systems to property/casualty insurers, today announced that MEM has selected Guidewire PolicyCenter® as its new policy administration and underwriting solution and Guidewire BillingCenter® as its new billing system. MEM has already successfully deployed Guidewire ClaimCenter®. Together these Guidewire Insurance Suite™ applications will fully replace functionality currently performed by the carrier’s legacy policy, billing, and claims system.

Responsibilities:

Involved in acquiring Knowledge about the Guidewire PolicyCenter and Guidewire BillingCenter System from the Subject Matter Expert

Providing the reverse KT and also involved in Secondary and Primary Support which involves new enhancement.

Developed PL/SQL packages, to enrich, load & reconcile feed data into the database and data manipulations

Environment: Oracle 9i, 10g,

Organization: HCL Technologies (Feb 2010 – Present)

Client: Genworth, Australia

Software engineer. Feb 2010 – Sep 2010

Genworth Financial (Genworth), a leading provider of Lenders Mortgage Insurance (LMI) in Australia and New Zealand, and Guidewire Software®, a leading global provider of solutions to general insurance companies, today announced that Genworth has successfully deployed the first release of its Loss Mitigation management Platform which includes Guidewire’s industry-leading ClaimCenter system. As a result of this release, Genworth now has improved automation and more streamlined processes to help with its loss mitigation management program.

Responsibilities:

Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL and Handled Exceptions.

Experience in writing SQL Queries, PL/SQL Stored Procedures, Functions, Exception Handlers.

Creating and using some Shell scripts.

Environment: Oracle 9i, 10g, unix,

Organization: Helios and Matheson (June 2009 – Jan 2010)

Client: Merrill Lynch, Chennai

Oracle Programmer. June 2009- Jan 2010

AwardChoice is an equity compensation program combined with advice and guidance for key

employees. It offers clients a combination of convenient service delivery channels: financial advisors,

an interactive voice response system, Internet access, and customer service representatives at Merrill

Lynch's award-winning call centers. It also offers services for "Section 16 Insiders," senior corporate

executives and directors who must follow certain U.S. federal restrictions and disclosure

requirements. The platform includes tools for reporting to the Securities and Exchange Commission,

and "Rule 10b5-1" trading plans for corporate insiders who wish to use a formalized systematic selling

or purchase plan for trading during company-imposed blackout periods.

Responsibilities:

Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL and Handled Exceptions.

Creating and using some Shell scripts.

Experience in working with Bulk Collections, Bulk binds, PL/SQL VArrays, and Nested tables.

Created database partitions on the tables/indexes to improve the performance.

Environment: Oracle 9i, 10g, PL/SQL, Windows XP, Toad.

Organization: Thirdware Business Solutions (Dec 2007 –Jan 2009)

Rockwell Automation, Korea

Role: Oracle Programmer. Dec 2007- January 2009

RA Korea is using an eCommerce Solution to receive orders and related information from their distributors. This eCommerce solution along with MFG Pro-eB, serves the current needs of the Sales Department. Due to technical issues with the current eCommerce solution, it was decided to implement the e-Portal-NZL application in Korea, replacing the eCommerce Korea. For this purpose an exploratory phase of the project was conducted to see the feasibility of e-Portal-NZL in Korea.

Responsibilities:

Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL*Loader and Handled Exceptions.

Extensive Experience in back end development including complex stored procedure, Database triggers, functions, packages, views, indexes, Synonyms, Dynamic SQL using SQL and PL/SQL

Creating and using Shell scripts.

Created database partitions on the tables/indexes to improve the performance.

Environment: Oracle 9i, PL/SQL, MS-Access, Windows XP, Sql *Loader, Toad.

Organization: Enrich Outsourcing, Chennai (May 2006 – Dec 2007)

ENRICH OUTSOURCING, Chennai May 2006 – Dec 2007

Client: TEXTILE ORDER PROCESSING SYSTEM, Sangam Industries, Rajasthan

Role: Oracle Developer

This project was an implementation of the Order Management Application across the manufacturing units of Sangam Industries, Bhilwara. Fast order entry options are designed to deal quickly and efficiently with repetitive order entry. Templates and duplicate functions are priceless in saving time and resources, as are price list look-ups and automatic margin calculation..

Responsibilities:

Creation of database objects like tables, views, Materialized views, procedures, packages using Oracle tools like PL/SQL, and Handled Exceptions.

Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions / enhancement on Oracle 9i.

Environment: Oracle 9i,8i, PL/SQL, SQL, PL/SQL, Toad,

Personal Details

Date of Birth 27.04.1982

Marital Status Married

Present Address Deira,

Dubai.

Permanent Address 3b, Sai Nirupama, Jayachandran nagar,

Medavakkam, Chennai.

Passport Details

Nationality Indian

Passport No N6149854

Date of issue 25-01-2016

Date of expiry 24-01-2026

Place of issue Chennai

Place: Riyadh (NAZIR AHAMMED.M)

Contact this candidate