SUMMARY:

• IBM AS/400 Programmer analyst with 13 years of IT experience in I - series, AS/400, RPGIV/III/II, RPGLE, ILE Concepts.
• Very well versed in all releases of the midrange System 38 (S38), AS/400, iSeries, I5 with RPGLE, Free Form RPG, SQL and all utilities. Extensive knowledge in service programs, Modules, Binding Directories, debugging & Production control etc.
• Worked on Development as well as enhancement and production support on call 24/7 rotation basis for environment and application related issues.
• Comprehensive background in various Finance, Insurance, Logistics, Distribution, Retail, Healthcare software development, Migration and manufacturing environments.
• Skilled in analyzing and documenting business work flow processes and integrating new and enhancing system functionality.
• Experience in Robot/Schedule, Robot/Alert, Robot/Console, TURNOVER, NUTIL and HAWKEYE.
• Knoweldge in application tools Knowledge in HP quality center, QTP, Load Runner
• Worked on ERP MOVEX (LAWSON), MAPICS(INFOR),SXC and others.
• Performed testing on various environments i.e. Unit, Integration, UAT by creating data and test Scripts using automated testing tool and manual testing.
• Extremely experience in integration and customization of existing and new applications.
• Worked with Client like Confidential, GE, General Motors, and Cummins Power, Cvs Health

TECHNICAL SKILLS:

Operating Systems: S36, S38, OS/400, Windows 9x, Windows NT, XP, Vista. I-Series, I5/OS.

Languages: RPGII, RPG III, RPGIV, RPGILE, RPG Free Form SQL/400, RPG Embedded SQL, CL/400, COBOL/400, SYNON C, C++, FoxBASE

Database: DB2/400, SQL Server, Microsoft Access. FoxPro

Web Technologies: IBM Websphere Application Server, Java script

ERP Package: Movex (Lawson), Mapics (Infor), SXC

Tools: OVSD, PRIMUS, EARS, CLARITY, FootprintClient Side Programming

.Net, JavaScript, VBScriptTesting Tools: Rational Rose Suite, QTP, Load Runner, HPQC, HP ALM Version 11.00

Version Control: PVCS, Implementer, Turnover, Nutil

Reverse Engineering Tools: Hawkeye, X-Analysis, Visio

Application Support/Development Tools: Remedy, HP Quality Center, ROBOT, PDM, SEU, SDA, DFU, DBG, RLU, SQL/400, ibm filesystem, Docagent Formserver, IFS

PROFESSIONAL EXPERIENCE:

Confidential, CA

Programmer Analyst

Environment: AS/400, I-Series, RPGIII, RPGIV, ILE RPG, CLLE, Embedded SQL, FTP,IFS,ROBOT, Synon, CWdirect, xml, IFS,Aldon

Responsibilities:

• Involved in analysis, reviewing, coding and testing.
• Solved and provided business logic for tickets requested by user.
• Worked on customization of CWDirect BOM offer price calculation on demand detail feed data.
• The price for the components/ items on the order form calculated based on the discount percentage available based on user input.
• Generated technical reports based on business user request using SQL.
• Reverse engineering application to find out the root cause of issues.

Confidential, Dallas

Programmer Analyst

Responsibilities:

• Assisting in Data mapping and creating business rules to master tables based on existing conversion program.
• Write conversion program to update the master table for CABS application using RPG, RPGLE, SQL, Procedures and Service programs.
• Supporting customer bill run and looking into job failures, data discrepancy and any other application or server related issues.
• Written SQL queries to generate technical reports.

Environment: AS/400, I-Series, RPGIV, ILE RPG, CLLE, Embedded SQL, FTP,IFS, Turnover, CABS application.

Confidential, Richardson, TX

Programmer Analyst

Environment: AS/400, I-Series, Synon, RPGIII, RPGIV, ILE RPG, CLLE, Embedded SQL, FTP,IFS,ROBOT, Aldon, RxClaim etc

Responsibilities:

• Tier-1 on call production support of RX claim applications and server related issues.
• Provided root cause analysis of back log tickets, job failures refer to Rxclaim and external application.
• Reverse engineering of application to find out the business rule and prepared the program flow documents.
• Created ad hoc reports based on business user request on daily basis

Confidential, Addison, TX

Computer programmer Analyst

Environment: AS/400, I-Series, RPGIV, RPGIII, ILE RPG, CLLE, RPG Free, HP Quality center( HP ALM Version 11.00), Stored Procedures, Turnover, FTP,DBU. Docagent Formserver,IFS, IBM MQ

Responsibilities:

• Coded and enhanced more that 50 RPG programs in all versions, and 20 CL programs. Designed modified screens using SDA and generated various complex reports.
• Worked on production support, maintenance and development of applications.
• Involved in analysis, creating and reviewing HLD, LLD documents and Test scripts,
• Created and Reviewed detailed Test plan, Test cases, Test scenarios for Manual Testing using HP Quality Center for defect reporting and analyzing test results.
• Created procedures for data retrieval from tables to populate values based on parameters passed from frontend applications.
• Wrote programs which generates specific format file at IFS and transmits through EDI.
• Production support 24/7 for application to find out root cause of environment related issues.
• Worked on Turnover code promotion, administration related tasks to coordinate with QA and deployment team for production releases.
• Analyzed and provided production data fixes.
• Application and environment testing coordinate with QA for production release.

Confidential, Rockville, MD

Programmer Analyst

Environment: AS/400, I-Series, Cobol, RPGIII, RPGIV, ILE RPG, CLLE, Embedded SQL, FTP,IFS,ROBOT, Synon, RxClaim etc

Responsibilities:

• Understanding requirement from Business.
• Development using RPG, Embedded SQL, Procedures and Service programs.
• Involved in analysis, reviewing, coding and testing.
• Importing CSV files thru FTP into the I-Series System.
• Coded 3 complex reports which sent to user mail box everyday and provided the same functionality interactively via user menu with basic validation.
• Written utility programs to generate auto mails for failed ROBOT jobs.
• Production Support for application and environment related issues.

Confidential, Simi Valley, CA

Programmer Analyst

Environment: AS/400, I-Series, RPGIV, RPGIII, ILE RPG, CLLE, RPG Free, HP Quality center, Store Procedures, Service programs, Turnover, Migration Extraction and Conversion.

Responsibilities:

• Involved in analysis, reviewing, coding and testing
• Unit and Integration Testing, defect tracking using HP Quality center. Used various tools and utility to indentify code level fixes. Involved in three phases of testing and Defect tracking using HP Quality center.
• Interaction with the offshore team to check in deliverables.

Confidential

Programmer Analyst

Environment: AS/400, I-Series, RPGIV, RPGIII, ILE RPG, COBOL, CLLE, RPG Free, IBM Web Sphere, Store Procedures, Service programs, NUTIL SQL Server, IFS,Synon,PDF Conversion, EDI transactions, interfaces and mapping.

Responsibilities:

• Impact analysis on Programs and Files to eliminate redundancy in data and undesired program output prior to the design phase.
• Analysis of application with Hawkeye and created system and DB design documents, to be converted in to functional code.
• Coded and enhanced more that 100 RPG programs in all versions, and 50 CL programs and 30 reports using SDA, RLU for the In-House Applications.
• Designing and created procedures for better performance and reusability and business rule components.
• Unit Integration and UAT Testing support, Using Lotus Defect reporting.
• Elimination of Bugs and undesired results using debugging using STRDBG and STRISDB.
• Trouble shooting night run jobs and resolving issues after detail analysis.
• Provided production support.
• Created stored procedures, service programs, ILE RPG Programs with embedded SQL, CLLE programs Screen designs and Printer files. Application acquisition document and created standard template.
• AOD(Application Overview Document)
• ADRP(Application Disaster Recovery Plan)
• IM Checklist (Infrastructure Management)
• ACL (Access Control List)
• Run book(How to Run the application)

Confidential

Programmer Analyst

Environment: AS/400, i-Series, RPGIII, RPGIV, RPGLE, CLLE, SQL400, HAWKEYE, MQ Series, HP Vista application

Responsibilities:

• Involved in analysis, Design and coding.
• Peer reviews of Design documents with business analysts for design compliance.
• Coded and modified approximately 25 programs in RPG, COBOL and CL.
• Designed and enhanced existing screens.
• Modified existing reports to include newly added fields in files.
• Designed and coded concurrently to achieve deadlines due to tight project schedules.
• Worked as a QA to meet business standard and to deliver as per SLA’s. Unit, Integration and System Testing as well as support.
• Bug resolution sighted during all testing phases using debugging and code analysis.
• Code review to check code compliance as per programming standards.
• Flat file creation for EDI interface transmission as per the purchase order message using embedded SQL.
• FTP across multiple systems and platforms.
• Created new programs, Enhanced existing programs.
• Developed new screens, reports and Service programs.
• Documentation of user manuals.

Confidential

Programmer

Environment: i-Series, RPG III, ILE RPG, COBOL, CLLE, DBU, HAWKEYE,Turnover, EDI- Interface, Mapics (Infor)

Responsibilities:

• Root causes Analysis for the ticket raised during production support.
• Study the issues log from the historic archive to find previous occurrence and create a permanent fix in the occurrence is frequent.
• Discussed intended solution in business with explanation.
• Analysis of existing program and creation of design documents.
• Coded new programs and enhanced existing programs with extensive use of old and latest RPG and COBOL programming techniques.
• Test and integrated newly developed enhanced programs to systems environment.
• Created test scripts and test cases for every new development or enhancements.
• Peer Reviews at all phases.
• Created user documentation to indicate the incorporated new validations and for distribution to CSR’s peers.

Confidential

Consultant

Environment: i-Series, RPG II, RPG III, ILE RPG, Free Format RPG, COBOL, CLLE, Embedded SQL, MAPICS XA, Turnover, Robot.

Responsibilities:

• Study the Business Requirement Documents.
• Session initiation with MIS and user.
• Creation of Data Base Design based on various parameters.
• System Analysis and creation of BRD for Development.
• Peer Reviews for Design documents.
• Coding in RPG and CL and Testing of existing and enhanced applications.
• Report modification and enhancements using RLU as per requirement document.
• Screen designing and enhancement using SDA.
• Peer Reviews, Code reviews creation and co-ordination.
• Test Environment Setup for Integration and UAT Testing.
• Reverse engineering for migration of certain modules into alternate technologies.
• Security testing the complete application as per User security levels.

Confidential

Junior Programmer

Environment: AS/400, RPG II, RPG III, RPGIV, CLP, COBOL, MOVEX, MQ Series, DBU.

Responsibilities:

• Analysis of root cause of issue with Hawkeye.
• Find a fix as Quick time or sustained solution.
• Coding in all versions RPG, CL, used embedded SQL during coding, created service programs for data retrieval.
• Modified Existing COBOL Programs.
• Created Knowledge Transfer documentation for future .
• Testing in Unit, Integration and System test environment.
• Promote the Fix into UAT and Production with Turnover.
• After sign off from user and business head promotion to production.

Confidential

Consultant

Environment: Windows NT/XP (Microsoft Visual Studio, FoxPro, C++, PL/SQL, Oracle 8i, MS SQL Server

Responsibilities:

• Installation of ERP (Int-E-View) Software at clients place.
• Business User .
• Report designing, bug fixing etc.
• Preparation of the To-Be Process Documentation.
• Identification and analysis of the Gaps.
• Preparation of Technical Specifications and Test Cases.
• Coordinating with business user for customization of newly developed processes.
• Reverse engineering of their existing system.
• Analysis, designing and coding.
• Status reporting to Project Manager.
• Implemented application at user end.
• Unit, system and integration testing and UAT.
• After sign off from user and business head promotion to production.