Project Manager
Resume:
RAMU JANNALI
Email ID: *******@*****.*** Cell# 201-779-
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