PROFILE SUMMARY:

• A result - driven, customer-focused, articulate and analytical professional in development and maintenance of software projects Have extensive experience of 5+ years and strong knowledge in AS400.
• Expertise in all stages of Application maintenance and development (under scope of AM).
• Extensive experience in RPG/400, ILE RPG, CL/400, SQL/400, Query/400.
• Experienced in Databases - DB2/400, SQL.
• Experience in Disaster Recovery strategy, Mitigation and Contingency plan.
• Ability to understand various technologies and technical architecture and demonstrated it by owning applications with multiple technologies involved.
• Had suggested and implemented many value addition ideas which created significant business value for clients and brought work for HCL.
• Played a role of key member in suggesting/evaluating/proposing/implementing various Problem Management initiatives.
• Played the role of Onsite coordinator from Southampton, UK.
• Took over few applications where there was no knowledge and built the knowledge base and made the team competent handle issues in that.
• Handled the most critical applications e.g. Investments, Thunderhead/DOCARCHIVE letter generation and archival system, Iseries part of data warehouse.
• Proactively found out many underlying issues within the system and fixed it.
• Have solved the issues within the expected time, owned high priority issues and provided defect free deliverables to customers.
• Have involved in enhancement projects with good requirement analysis, design, review, coding and testing.
• Have cooperated well with the customers to meet their needs and for timely and quality deliverables.
• Have good planning and analyzing skills and end-to-end knowledge of the applications.
• Have trained new joiners and have presented many sessions to them.
• Dynamic and Assertive team player with strong commitment and management skills.
• Capable of performing under minimal supervision, multi-tasking, meets deadlines as an individual contributor and also a good team player.

TECHNICAL SKILLS:

Languages: RPG/400, RPG ILE, CL/400, SQL RPGSQL/400, Query/400

Tools: SEU, SDA, PDM, X-Analysis, Assyst, MKS, Synon model, TIBCO BW, DB2 content manager

RDBMS: DB2/400, SQL

Operating System: OS/400, Windows 98/XP

Domain Area: Insurance

PROFESSIONAL EXPERIENCE

Confidential

SQL Developer

Environments: IBM AS/400 V5R3 (RPGILE, RPG, CL/400, DB2/400), MKS

Responsibilities:

• Involved in Requirement analysis.
• Discussion of requirements and design with clients.
• Involved in Coding on RPG, RPGLE, CLP.
• Created physical files and logical files.
• Created new RPGLE programs and modules.
• Created new CL programs.
• Used X-Analysis for the Understanding system and doing impact analysis.
• Used MKS tool for change management.
• Involved in preparation of unit test cases and performing unit testing.
• Coordinating with business for the UAT
• Preparation of System test cases and System testing.
• Handling support issues.

Confidential

Environments: IBM AS/400 V5R3 (RPGILE, RPG, CL/400, DB2/400, SDA), MKS

Responsibilities:

• Preparation of the proposal.
• Discussion of design with business.
• Interaction with client business team to get the go ahead.
• Involved in Coding on RPG, RPGLE, CLP to create and amend new/existing programs.
• Created new physical file, logical file and display file.
• UAT, Preparation of Unit test cases and execute Unit testing
• Used X-Analysis for the Understanding system and doing impact analysis.
• Extensively used DB2/400 for testing and test data setup in test environment.
• Used MKS tool for change management.
• Handling the RFC and support.

Confidential

Performance improvement

Environments: IBM AS/400 V5R3 (RPGILE, RPG, CL/400, DB2/400), MKS, TIBCO

Responsibilities:

• Preparation of the proposal.
• Interaction with client business team to get the go ahead.
• Discussions with client architecture team to explain the impact on the other ongoing projects/or the one’s in pipeline.
• Involved in Coding on RPG, RPGLE, CLP.
• Design, Coding, UAT, Preparation of Unit test cases and execute Unit testing
• Used X-Analysis for the Understanding system and doing impact analysis.
• Also analyzed TIBCO BW code part of the entire letter processing.
• Extensively used DB2/400 for testing and test data setup in test environment.
• Used MKS tool for change management.
• Handling the RFC and support.
• Used Assyst tool.

Confidential

Paper suppression

Environments: IBM AS/400 V5R3 (RPGILE, CL/400, DB2/400), MKS, TIBCO

Responsibilities:

• Involvement with the I series (RPGLE, CLP) design and implementation.
• Handled the post deployment issues and support.
• Used X-Analysis for the Understanding system and doing impact analysis.
• Coordinated with TIBCO team, PC team and got all the backlog of letters reprocessed.
• Coordinated with the business users.

Confidential

Application Maintenance

Environments: IBM AS/400 V5R3 (RPG/400, RPGILE, CL/400, DB2/400, QUERY/400), MKS

Responsibilities:

• Interaction with Clients/Users
• Review and analysis of the repetitive tasks.
• Created an utility to RPG/400, RPGLE, CLP, Query/400 to automate these.
• Preparation of Requirement specification.
• Involved in Coding on RPG/400, RPGLE, CLP, Query/400.
• Used X-Analysis for the Understanding system and doing impact analysis.
• Monitoring and reviewing the task of team members.
• Review of deliverables.

Confidential

Environments: IBM AS/400 V5R3 (RPGILE, CL/400, DB2/400, QUERY/400), TIBCO

Responsibilities:

• Interaction with the Clients/Users.
• Have been AM spoc for systems Investments, Thunderhead/Docarchive, UKDW.
• Getting involved in developments related to my applications.
• Handling and resolving tickets, Coordination with Offshore team.
• Handling and mentoring a team for Investments and Thunderhead/Docarchive.
• Preparation of Requirement specification
• Working on enhancements and code/data fixes on RPG, RPGLE, CLP, DB2/400, Query/400.
• Used X-Analysis for the Understanding system and doing impact analysis.
• Review of deliverables.
• Handling production support.