AJAY KUMAR PAREEK

Contact No: +91-955*-****** (M) .

Current Company: RBS - Royal Bank of Scotland

http://www.rbs.in/

E-mail: accrws@r.postjobfree.com

Profile

> 5+ years of experience in the IT Industry as Oracle PL/SQL Developer

in Banking & Financial Domain.

> Knowledge of database architecture and best practices for Oracle SQL

and PL/SQL coding style and application tuning.

> Experience in Creating procedures, API, Packages, Functions, Triggers

and other Database objects using SQL and PL/SQL, UTL file, SQL *

Loader, TOAD.

> Experience in performance tuning, application monitoring and support

of production applications.

> Experience in data Migration, Mapping, and Validation from legacy

system to Oracle RDBMS and applications

> Development experience in Java (Struts Java Framework).

> 2+ Years working experience in Japan with global client Tokyo Star

Bank and Shinsei Bank.

Behavior and General Skills:

> Ability to work with business users/vendors to define potential

business/technology solutions that leverage the consulting, technology

and functional knowledge.

> Clear understanding of Systems Development Life Cycle (SDLC)

methodology and respective experience with its application in design

and development phases with agile methodologies.

> Ability to work within tight deadlines and effectively prioritize and

execute tasks in a high-pressure environment.

> Excellent impact-analysis skills and discipline. Carefully analyzes

the existing code base as part of each design effort, to avoid

redundancy and inconsistency and maximize code reuse.

> Proven analytical and problem-solving abilities. Ability to quickly

discern the most relevant facts and recommend the quickest, most

practical and safest approach to resolving an issue with a program or

database.

Professional Certifications

Training of 3 Months

Company: CMC Limited. (A TATA

Enterprise)

Training in: Corporate Software

Training which contains SQL, PL/SQL and

Specialization on Java technology

Training of 45 days

Institute: Oracle University

(Training Centre)

Training in: Oracle (OCA) which

contains introduction to SQL and PL/SQL

Technical Skills

Languages: SQL, PL/SQL, Java (Struts Java Framework).

Platforms: MS Windows 9x/XP/NT

Databases: Oracle 9i/10g/11G

IDE: Eclipse, JDeveloper

Source Control Tool: IBM Rational Clearcase

Application Servers: Web Sphere, Oracle WebLogic 11G Server

Education

BE (Bachelor of Engineering in Computer Science)

Rajasthan University, Jaipur, Rajasthan

2004 - 2008

Average grade is 8 out of 10 (10 is the highest)

Professional Experience - Full Time Employee

Nov 2013 - present

Employer: RBS - Royal Bank of Scotland (http://www.rbs.in/)

My Positions: Associate Software Designer

1. Client : RBS It Self

Project: GRDW

Database: Oracle 11G

Language: Oracle SQL, PL/SQL

I've been involved into:

* Understand the business requirements from the users / business

analyst and document the technical specifications.

* Develop code that conforms to the design, addresses non-

functional requirements, and complies with the coding standards

and conventions.

* Work closely with Project Managers and other members of the

development team to establish clear project deliverables and

timelines, and to ensure timely completion of the deliverables.

* Ensure high quality delivery during all phases of the SDLC.

* Assume full ownership of the enhancements and take

accountability for timely implementation of the enhancements.

* Closely track change requests / ad hoc activities and

communicate the impact on a timely basis.

* Ensure that best practices are followed throughout the

development lifecycle.

* Analyze current programs and troubleshoot production issues.

* Identify potential performance tuning improvement areas and

implement tuning measures.

* Possess a good understanding of change management and release

processes.

* Participate in peer code reviews.

* Provide assistance to testers and support personnel, where

needed, to determine application issues.

July 2010 - Oct 3013

Employer: Nucleus Software Export Ltd (http://www.nucleussoftware.com/)

My Positions: Senior Software Engineer

1. Client: Shinsei Bank, Tokyo, Japan

Product: FinnOne LMS (Financial Product)

Technology: Database 11G, Websphere Application Server, Struts

Framework

Language: Oracle SQL, PL/SQL, Java

I've been involved into:

* Develop, design, unit test, debug multi tier banking

applications in oracle SQL,PL/SQL and Java

* Conduct program code reviews

* Generate program specifications

* Analyze requirements & design documents

* Resolve & trouble shoot User queries within predefined Service

Level Agreements

* Build and execute unit test and unit test plans.

* Review integration and regression test plans created by QA

* Interact with QA and porting engineering about problems in the

code.

* Performance Tuning

1. Client: ING Vysya Bank, India

Product: FinnOne LMS (Financial Product)

Technology: Database 11G, WebLogic 11G Server, Struts Framework

Language: Oracle SQL, PL/SQL, Java

I've been involved into:

* Implementation of FinnOne LMS (Lending Software) and data

migration.

* Development/Modification of Stored Procedure, functions Packages

using PL/SQL.

* Involved in analysis, design and development of modules and

testing the components (CR)

* Involved in Unit Testing, Functionality testing

* Resolve & trouble shoot User queries within predefined Service

Level Agreements

* Work closely with Project Managers and other members of the

development team to establish clear project deliverables and

timelines, and to ensure timely completion of the deliverables.

* Ensure high quality delivery during all phases of the SDLC.

* Work with business users to analyze and recommend business

process flow improvements.

* Lead a small team of developers through the development process.

* Performance Tuning

July 2009 - July 2010

Employer: PK4 Software Technology Pvt. Ltd (http http://www.impelcrm.in,

http://zerocode.com)

My Positions: Software Engineer

Product: Impel CRM (Customer Relationship Management): Java & Oracle PL/SQL

Impel CRM helps companies increase revenues and maximize profits by

increasing sales productivity, marketing efficiency and service operations.

The web based CRM is used by sales, marketing and customer service teams

across a variety of industries ranging from SMBs to large enterprises.

I've been involved into:

* Developing new functionality in oracle SQL,PL/SQL and Java.

* Designing of web pages using Html, CSS, Java script.

* Interaction with client for requirements.

* Development of Stored Procedure, functions Packages using PL/SQL

* Involved in analysis, design and development of modules and testing

the components

* Involved in Unit Testing, Functionality testing

November 2008 - July 2009

Employer: CMC Limited, Bangalore (http://www.cmcltd.com)

My Positions: Software Engineer

Project: CAG (Comptroller and Auditor General)

Client: AG Office Bangalore, Karnataka.

Technology: Oracle 10G, (SQL, PL/SQL)

To enhance accountability of the executive to the Parliament and State

Legislatures by carrying out audits in the public sector and providing

accounting services in the states in accordance with the Constitution of

India and laws as well as best international practices.

Where entrusted, to provide Technical guidance and Support to local bodies

including Panchayati Raj institutions to enhance their accountability.

I've been involved into:

* Debugging of Forms, Reports and backend Procedures and Packages

* Development/Modification of Stored Procedure, functions Packages using

PL/SQL.

* Involved in analysis, design and development of modules and testing

the components

* Involved in Unit Testing, Functionality testing

* Involved in the User Training and giving Implementation support to the

module

* Performance Tuning

* Technical Flow, Business flow, Code review.

Passport Details

Name as on Pa Passport Date of Is Expiry Dat Place of Issu Country

ssport No. sue e e Visited

Ajay Kumar G6538707 21/04/2008 20/04/2018 Jaipur Japan, China

Pareek

Contact this candidate