SUMMARY

• 9+ years Exp in IT Sound knowledge on IBM iSeries/ AS400 and experience in development and production support of AS400 applications.
• Good knowledge in Banking, Insurance, Manufacturing, and HR domains.
• During my experience I have created and modified RPG/ILE, CL programs and SQL stored procedures.
• Used iSeries change management tools like Turnover and Aldon extensively.
• Improved the performance of critical batch jobs that are part of night batch process as part of iSeries stability activity.
• Used analysis tools like APLUS, Hawkeye and job scheduling tools Sleeper, RBO, IBM job scheduler and regular AS400 tools like STRISDB, QUERY/400, DBU, SEU, SDA, RLU, PDM, DFU, SQL/400 and RLU to develop/ modify client applications, monitor databases and performance tuning of the system.
• Highly proficient in IBM iSeries / AS/400 with RPG (III/IV/ILE), RPG Free, JD Edwards World, COBOL, SQL Stored Procedures, SQL COBOL ILE, Sub file Processing, DB2/400, CLLE, FTP, SEQUEL VIEW, Embedded SQL, SVR and Data dictionaries.
• Experience in analysis, design and coding, testing, implementation, and production support of software systems.
• Strong Knowledge of SUB - FILES.
• Strong knowledge of Software Development Life Cycle, Testing Methodologies and Techniques.
• Ability to work independently and as a team player as well.

TECHNICAL SKILLS

Operating Systems: OS/400, Windows NT/2000/98/95, MS-DOS 6. 0

Programming Languages: RPG/400, RPG/ILE, COBOL, Free format RPG, CL/400, PL/SQL, SQL/400, Embedded SQL, HTML/XML, C and Java.

Tools: PDM, SDA, SEU, RLU, DFU, DBU, DDS, QUERY/400, SQL/400, ISDB, STRDBG, I Series Navigator, ALDON, Overlays, ACMS, Turnover, MKS Implementer, Sleeper, ROBOT, APLUS

Database: DB2/400, Oracle 9i.

OLTP: DSPF

ERP: JD Edwards HR Module.

PROFESSIONAL EXPERIENCE

Confidential, MI

Programmer Analyst

Responsibilities:

• Design FIXING the live issues in production environment as part of the production support within the SLA time limits.
• Highly proficient in IBM I series AS/400 with RPG(III/IV/ILE), RPG Free, JD Edwards world, SQL Stored procedures, SQL COBOL ILE, Sub file processing, DB2/400, COBOL, CLLE, FTP, Embedded SQL, SVR, UDC, Dream writer, world writer, Vocabulary overrides, data dictionaries.
• Developed new HTML/XML script, WEB SERVICE programs to maintain Portal.
• Developed Java script to design HTML script and maintain CGI programs worked RPG/ILE.
• COBOL is a standard and Business oriented language that can be compiled and executed on machines such as IBM AS/400,
• The INITIALIZE statement sets selected categories of data fields to predetermined values. It is functionally equivalent to one or more MOVE statements.
• Developed new trigger programs and views in Sequel view point.
• Experience in analysis, design and coding, testing, implementation, and production support of software systems.
• Modified Batch jobs to reduce the execution time.
• Preparing technical specifications and performing code modifications for change requests as per the requirements.
• Developed new RPG/ILE programs, CL programs, and SQL stored procedures as part of this project.

Environment: IBM AS/400, OS/400, ILE RPG, COBOL ILE, RPG Free, SQL/400, Lansa, Embedded SQL, Query/400, DB2/400, ALDON, SYNON, DBU, HTML, XML, and PDM, JAVASCRIPT.

Confidential, Addison, TX

Programmer Analyst

Responsibilities:

• Interacting with BAs during data mapping.
• Analysing the requirements, giving estimates, and preparing technical specifications.
• Facilitating design walkthroughs and getting approvals.
• Developed new RPG/ILE procedures, SQL stored procedures.
• Coding and testing the developed code.
• Fixing the issues raised by the QA team during SIT and UAT.
• Preparing implementation plans and supporting production implementation.
• Providing weekly updates to the management and the time devoted to each individual task.
• Also providing the tasks to be done in coming weeks.
• Reviewing the code developed/modified by other team members.

Environment: IBM AS/400, OS/400, ILE RPG, RPG Free, SQL/400, Embedded SQL, Query/400, ALDON, DB2/400, Turnover, DBU, and PDM.

Confidential, Tomball, TX

JDEdwards Technical Support Analyst

Responsibilities:

• Interacting with users for understanding the issues/requirements.
• Fixing the live issues in production environment as part of the production support within the SLA time limits.
• Providing weekly status reports with detailed descriptions of the current projects progress and the time devoted to each individual task.
• Also providing the tasks to be done in coming weeks.
• Modified and wrote various reports and inquiries.
• Used SYNON to modify objects that were developed by SYNON.
• Reviewing the code developed/modified by other team members.
• Modified batch jobs to reduce the execution time.
• Preparing technical specifications and performing code modifications for change requests as per the requirements.
• Developed new RPG/ILE programs, CL programs and SQL stored procedures as part of this project.
• Reviewing the code modified by other team members.
• Attending monthly CAB meetings to prioritise the user requests.

Environment: IBM AS/400, OS/400, ILE RPG, RPG Free, SQL/400, Embedded SQL, Query/400, DB2/400, DBU, ACMS, PDM, SVR.

Confidential

Programmer Analyst

Responsibilities:

• Requirement analysis from the client
• Involved in the designing the architecture of the application
• Preparing Feasibility study.
• Studying the Impact Analysis on the existing system and preparing the report on impacted areas
• Representing the functional specification in flow diagram format
• Converting the Design documents for the project into low level design documents
• Preparing the test cases and involve in testing
• Integrating all the modules for Unit testing and involving in integration testing.
• Code Reviews and ensure that coding standards are followed.

Environment: RPG/ILE, CL/ILE, RPG/400, CL/400, SQL/400, MQ-Series, SEU, PDM, DFU, RLU, SDA