Ramesh Jajula

E-Mail: acs068@r.postjobfree.com Mobile No: +91-988*******

PROFESSIONAL SUMMARY

5+ years of IT Experience as Oracle PL/SQL Developer.

Having an experience in UNIX shell script.

Having an experience in Java.

Good experience in Insurance, Banking (Credit Risk),telecom domain.

Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.

Good experience in client-engagement around 1.5 years at on-site.

Experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.

Documentation of projects for System Use cases (SUC), Functional Spec (FS) and Test Cases.

Assisted QA Teams for bug testing, System Integration Testing (SIT) & User Acceptance Testing (UAT) .

Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

Strong interpersonal and communication skills in dealing with customers.

HONORS AND AWARDS

Awarded 3 times “Fire in the Belly” award at Mastek Ltd.

Awarded 5 times “Spot awards” at Mastek Ltd.

Awarded Prism Club membership at Mastek Ltd.

Awarded the “Individual Excellence Award” and was rated “Best Performer” at Reliance Tech Services, DAKC, Mumbai.

EXPERIENCE PROFILE

Organization Name

Designation

Duration

BNP PARIBAS

Senior Software Engineer

Aug-2015 - Till date

MASTEK LTD, CHENNAI.

Senior Software Engineer

Nov-2011- Aug-2015

RELIANCE TECH SERVICES, DAKC, MUMBAI.

Software Engineer

June 2010 – Nov-2011

WORK EXPERIENCE

Elixir – Insurance domain – Mastek Ltd. (Nov 2011 – Till Date)

Client : Ocean Life Insurance (Thailand)

Project : OLI IL insurance

Team Size : 30

Duration : July 2012 to till date.

Technologies : JSP, Servlets, Oracle, SQL Developer, Eclipse

Description :

Elixir covers all aspects of the insurance process distribution, New Business, Underwriting, Policy servicing, Billing and Claims. It manages the complete financial aspect of insurance Policy administration and also interfaces with reinsurance companies. It has Channel Management system to manage different individual products with effective security. This project having total 12 modules those are 1) Security 2) Point of sales 3) Products 4) Claims 5) Common 6) New Business 7) Channel Management 8) Policy Servicing 9) Finance 10) Reinsurance 11) Administration 12) Batch Process.

Products Module used to create different insurance products like Annuity, MRTA, Traditional etc. And Product verification & authorization will be done here. Once product is verified that product should be launched and ready for New Business. It is having sub modules like Product Basic Definition, Premium, Event Benefit, Special features, Product launch, product copy, Masters

New business module used to create proposals and mapping of the agent to the proposal, after mapping the client is attached to this proposal, after all the steps to be done policy will be generated. It is having sub modules like Proposal, Policy, and Masters.

Claims Module used to create different type of claims like Death, Hospitalization, TPD etc after creating claim it goes for assessment and after that claim will be approved and payment initiated to beneficiary.

Responsibilities:

Multi-lingual development.

Created the PL/SQL packages, procedures, functions applying the business logic.

Developed Database Triggers for audit and business validation purpose.

Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve Performance.

Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables.

Developed Installation scripts for all the deliverables.

Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan.

Making structural changes to the database objects.

Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP).

Documentation of projects for System Use Cases (SUC), Functional Spec (FS) and Test Cases.

Conducting code reviews.

Implementing query’s for reports development.

Secure GUI development – Telecom domain – Reliance Tech Services (Jan’ 2010 – Nov-2011)

The existing GUI using TOAD allowed queries to be executed on critical backend databases without checks or restrictions. Project involved building a wrapper around this functionality to prevent unchecked execution of queries and featured a) login based access; b) IP binding to track users and c) non-editable standard set of queries to restrict functionality / avoid data integrity issues / reduce load on the databases

Responsibilities:

Requirements collection

Requirements analysis

Architecture design

Implementation

Technologies used:

C#, .NET, PL/SQL, MS Visual Studio, TOAD, SQL Developer

Rewards & recognition:

Was awarded the Individual Excellence Award for my work.

CDR Reports– Telecom domain – Reliance Tech Services (June-2010 –Jan-2011)

Project involved extending the existing CDR based reporting system to monitor FCC locations in addition to RCOM locations. The system needed to a) use a single CDR source for all historical reports; b) provide single-portal visibility and c) minimize manual intervention in report generation.

Responsibilities:

Requirements collection

Requirements analysis

Architecture design

Implementation

Technologies used:

C#, .NET, PL/SQL, TOAD, SQL Developer and MS Visual Studio

Technical Skills:

Operating Systems : Windows XP

Programming Languages : SQL, PL/SQL, Java, HTML, JavaScript,C#

DBMS packages : Oracle 10g,

Others : TOAD,SQL Developer.

EDUCATIONAL QUALIFICATIONS

Qualification

Institute

University/Board

Year of passing

Aggregate

MCA

Vignan’s Engineering College

Jawaharlal Nehru Technological University

2010

77%

B.Sc

Geetham Degree College

Acharya Nagarjuna University

2007

81.3%

Intermediate

Venus Junior College

Board of Intermediate Education

2004

74%

10th Std.

Vikram School

SSC

2002

66.3%

CERTIFICATIONS

Oracle Certified Database Associate (OCA) PLSQL Developer Exam.

IBM Certified Database Associate Exam (DB2 9 Fundamentals).

IBM Certified RAD Exam (RAD).

PERSONAL PROFILE

Name : Ramesh Jajula

Father’s Name : Venkata Prasad

Nationality : Indian

Date of Birth : 5th August, 1987.

Declaration:

I hereby declare that the above-mentioned information is true and apt up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.

(J Ramesh)

Contact this candidate