RAMU JANNALI

Email ID: acg1bh@r.postjobfree.com Cell# 201-779-

**** ****: 515-***-****

PROFESSIONAL SUMMARY

* Over 13 years of experience in Software Development with AS400

Applications .In-depth knowledge of all phases of Software Development

Life Cycle (SDLC).

* Knowledge of Relational Database Management System (RDBMS). DB2/400,

Oracle, SQL server

* Experience in analyzing Business Requirement Document and System

Requirement Document to derive Functional and technical design

documents.

* Strong unit and system testing skills

* Strong interpersonal skills and excellent problem solving skills.

Ability to work independently.

* Excellent time management skills

ACADEMIC QUALIFICATIONS

* Masters in Computer Science (M.Tech), J.N.T. University, Hyderabad,

India

CERTIFICATIONS:

INS21 - PROPERTY AND LIABILITY INSURANCE PRINCIPLES

INS22 - PERSONAL INSURANCE

TECHNICAL SKILLS

Databases DB2/400, Oracle 11g, SQL Server 6.0

Languages I Series CLP, COBOL, ILE RPG,SQL/400, JCL, CICS, VSAM,

MVS,C, C++, SQL, PL/SQL, V.B5

Environment Windows95/98/2000/XP, Windows NT,OS400,UNIX

CAREER RECITAL:

I. MEMIC INSURANCE Company, Portland, ME,USA

Project: Claim Notes on the Web -Aug 25th, 2014 - till date

Technology:

AS400 I series,RPG 400, COBOL 400, SQL/ 400, CL/400, DB2/400

Description of the Project: Add functionality to its web claim inquiry to

allow designated policy holders and their agents to have access to claim

notes. In order to provide this facility, we need to store the notes data

and control access to it the As400.

Project requires display file, subfile file program,creation of Prompt

window for the fields to setting up acces to notes whether that can be

viewd by designated policy holder/Agent.

Responsibilities:

* Sr. AS400 Consultant.

* Analyzing the requests from the client and Produces appropriate

research and analysis. Translate business needs into technical system

solutions

* Develop programs for existing Software enhancements using COBOL 400,

SQL/400, CL/400, Sub-file programming

* Troubleshoots and debugs existing code. Resolve production related

issues.

* Tests code and fixes to ensure quality. Program analysis and create

detailed process flow and documentation.

* Adhere to quality process for assigned project deliverable.

* Involve in Systems Testing, Integration and Regression testing.

* Handles special projects as assigned by Manager. Maintains

responsibility for applications dealing with the overall application

system.

II. MAPFRE - Commerce Insurance Company, Webster, MA, USA

Project: ISO Medicare Project (ACIC - Premium & Claim Application Process)

- June17th 2013 - 30 June 2014

Technology:

AS400 I series, RPGLE, RPG 400, RPG FREE, SQL/400,CLILE

Responsibilities:

* Sr. AS400 Consultant

* Analyzing the requests from the client and Produces appropriate

research and analysis. Translate business needs into technical system

solutions

* Develop programs for existing Software enhancements using RPGLE, RPG

Free, RPG SQL, CLILE,SQL/400, Sub-file programming

* Create programs with imbedded SQL, stored procedures and triggers

* Troubleshoots and debugs existing code. Resolve production related

issues.

* Tests code and fixes to ensure quality. Read programs and create

detailed process flow and documentation.

* Adhere to quality process for assigned project deliverable.

* Provide effective technical guidance to the team during coding,

testing phase and in resolving complex logics, and acts as mentor to

other analysts in the team.

* Involve in Systems Testing, Integration and Regression testing.

* Provides programming support for various interfaces.

* Handles special projects as assigned by Manager. Maintains

responsibility for applications dealing with the overall application

system.

III. MMC- Marsh & McLennan Companies

Project: UBS - Universal Billing System & GUL - Group Universal life

insurance - Sept'2010 to June14th, 2013

Technology:

Oracle 11G, AS400 I Series, RPG ILE, CL/400, DB2/400, SQL/400, QUERY/400,

COBOL/400

Responsibilities:

* Lead Technical

* Analyzing Business requirement documents and System requirement

documents and prepare Impact analysis and Technical specifications.

Prepare test scenarios and estimations.

* Develop programs for existing Software enhancements using RPGLE, RPG

Free, RPG SQL, CLILE,SQL/400, Sub-file programming, Create programs

with imbedded SQL

* Troubleshoots and debugs existing code. Resolve production related

issues.

* Provide technical guidance to the team during coding, testing phase

and in resolve complex logics

* Performing User Acceptance Testing (UAT), unit and Integrated System

Testing.

* Co-ordinate offshore team, assigning tasks to resources and sharing

business and technical knowledge.

IV . MMC- Marsh & McLennan Companies

Project: UBS (Universal Billing System) - May'2008 to Aug'2010

Technology:

AS400 I series, COBOL 400, ILE RPG, CL/400, DB2/400, SQL/400, QUERY/400,

DB2/400

Responsibilities:

* Team Leader

* Analyzing Business requirement documents and System requirement

documents and prepare Impact analysis and Technical specifications.

Prepare test scenarios and estimations.

* Provide technical guidance to the team during coding, testing phase

and in resolve complex logics

* Develop programs for existing Software enhancements using RPGLE, RPG

Free, RPG SQL, CLILE,SQL/400, Sub-file programming, Create programs

with imbedded SQL

* Troubleshoots and debugs existing code. Resolve production related

issues.

* Write Zen Tran scripts to place or retrieve files from CDE Server.

* Handles special projects as assigned by Manager-Claims Development.

* Carried out Functionality, Integration and Regression test

* Coordinate with the developers on Defects Status on a regular basis.

* Perform Acceptance Testing (AUT), Performed backend testing by

executing SQL queries.

V. MMC - Marsh & McLennan Companies

Project: UBS (Universal Billing System) - Sept'2006 to May'2008

Technology:

AS400, JCL, ILE RPG, CL/400, DB2/400, SQL/400, QUERY/400, COBOL 400

Responsibilities:

* On-site Co-coordinator, Primary activity is to provide 24 X 7

Production Support.

* Translate business needs into technical system solutions. Develop

programs for existing Software enhancements

* Provide technical guidance to the team during coding, testing phase

and in resolve complex logics

* Troubleshoots and debugs existing code. Resolve production related

issues.

* Writing Zen Tran scripts to place or retrieve files from CDE Server.

Control record set ups for Automation FTP - files

Eligibility/Remit/Pay roll files. Involving in internal training and

team meetings. Allocation of work to the resources.

* Involve User Acceptance testing (UAT), Create test environments, Help

testing applications and receiving appropriate signoff for code

promotion to production.

* Handles special projects as assigned by Manager.

VI. MMC- Marsh & McLennan Companies

Project: UBS (Universal Billing System) - June'2004 to Aug'2006

Technology:

AS400, JCL, ILE RPG, CL/400, DB2/400, SQL/400, QUERY/400, COBOL/400

Responsibilities:

* Sr. Software Engineer

* Prepare understanding documents, impact analysis, and technical

specification and unit test cases.

* Develop programs for existing Software enhancements using Cobol 400,

RPGLE, RPG SQL, CL 400,SQL/400, Sub-file programming

* Create programs with imbedded SQL, stored procedures and triggers

* Troubleshoots and debugs existing code. Resolve production related

issues.

* Tests code and fixes to ensure quality. Read programs and create

detailed process flow and documentation.

* Adhere to quality process for assigned project deliverable.

VII. THE INDIA CEMENTS LIMITED, HYDERABAD, INDIA.

Project: ERIS - ENTERPRISE RAASI INFORMATION SYSTEMS - April 2000-

May'2004

Technology:

AS400, CL/400, DB2/400, SQL/400, QUERY/400, VB 5.0

Responsibilities:

* Systems Analyst

* Gathering information from various functional areas. Develop the

Design to integrate the system across the functional areas. Prepare

estimations.

* Develop programs for existing Software enhancements using Cobol 400,

CL 400,SQL/400, VB 5.0

* Adhere to quality process for assigned project deliverable.

[pic][pic]

Contact this candidate