We provide IT Staff Augmentation Services!

Ibm Iseries As/400 Software Consultant Resume

Jersey City, NJ

SUMMARY:

  • Over 11 years of experience in System Analysis, Design, Development, Enhancement and Implementation of Application Software Development in AS/400.
  • Experienced in Application Development under AS/400 using RPG III, RPG IV, RPG/400, COBOL/400, RPGILE, CL/400, CLILE, SQLRPGLE, Subfiles, SYNON and DB2/400 and Requirement gathering, business analysis, implementation of business centric software applications.
  • Experience in IBM Navigator and Rational Developer for the iSeries
  • Experience in design data base, SQL tables and stored procedures
  • In depth knowledge of Software Development Life Cycle Waterfall, Agile methodologies and Standard Operating Procedures.
  • Involved in business analysis to prepare functional specification, technical design and requirement documents as per the client specifications.
  • Experienced in ANSI X12 transaction sets like 834, Lockbox 823, 835, 837, 276, 277 and 278 and EDItransactionslike 810,850,855,856 and 820.
  • Experienced in designing job batches and job sequences for scheduling jobs usingjob scheduler.
  • Experienced in troubleshooting ofbatch/interactive jobs and addressing production issues like performance tuning on long running SQL statements and programming logic.
  • Experienced in unit testing, quality analysis testing and system testing of thejobs.
  • Experience in production support 24X7 and worked on high severity tickets and keep monitoring issue tracker and provide updates till the issues get resolved
  • Experience in reviewing the team members code verified with project requirement, test results to make sure for the quality of the deliverables
  • Experience with FTP, SFTP and NDM transfer protocols
  • Extensive experience in Health care projects like Provider, Payer, AR and Claims process
  • Experience in handling team members as well as Onshore - Offshore model
  • Experience in estimation of the project, resource handling, team management
  • Ability to interact with end-users, managers and technical persons and Good co-ordination and co-operation with the team.
  • Excellent communication and interpersonal skills with a keen understanding of business applications, their Integration and a proven ability to adapt to new areas.

PROFESSIONAL EXPERIENCE

IBM iSeries AS/400 Software Consultant

Confidential, Jersey City, NJ

Responsibilities:

  • Maintenance and support of AS/400 applications including GMI and other custom software at Confidential Merrill Lynch
  • Worked on self identified issues and automated solutions to operations which reducing day to day work with manual intervention
  • Worked on On-Call support and monitor nightly batch jobs and troubleshooting, fixing them if any issues
  • Worked on Change management objects migration project ALDON to TURNOVER
  • Analyzed the object attribute information and prepared internal utilities using RPGIV, RPGLE, SQLRPGLE, CLLE, DB2 files and iSerries navigator
  • Ran the Object description information for the program objects to evaluate the attribute information
  • Ran the Display file description for the data base file objects to evaluate the attribute information
  • Designed utility /write programs to compare the objects information of Aldon and Turnover which is corporate change management tools
  • Unit test the utility and verify the test results with actual and expected to make sure the tool is working perfect
  • Performing code changes for ML, F&O, OTC clearing using Aldon/Turnover change management
  • Working collaborate with existing Turnover team, FOOTC, OTC clearing teams
  • Extract the data of object information for the Production, QA and DEV environment to compare
  • FTP the data of object information into .XLS format with all matching and not matching data between PROD, QA and DEV
  • Analyze the object information for not matching data and find out which objects are need in either environments like Prod and DEV.
  • Analyze and decide decommission of object information/restore object into the environments based on the usage or need of the particular object.
  • List out all the object data and migrate the object data from Aldon to Turnover an approval from the respect authority manager

IBM iSeries AS/400 Developer Lead

Confidentia, Framingham, MA

Responsibilities:

  • Worked on technical design document for the Supply Chain Management project
  • Worked on Development for the programs using ISeries-AS400 using RPG, RPG-ILE language to write programs as per the requirement
  • Write RPG, RPGLE and Module to bind program object to execute where as the module code reusable in different programs
  • Write CL and CLP programs for the job submission to execute the RPG, RPGLE, COBOL400 programs
  • Modified data base files to carrier codes for the base configuration files for DB2 universal data base for iSeries
  • Build RPG program to populate data in different physical files as per requirement as well as into flat files
  • In some programs API’s (QRCVDTAQ/QSNDDTQ) are used to send/receive the data files to other system
  • User entered front Data files are send to IFS (Integrated File System) in iSeries and other remote systems in iSeries-AS/400 using FTP or SFTP
  • Prepared unit test cases and captured test results in all the stages
  • Performed unit testing, supporting to QA and UAT
  • Turnover is used to promote the objects to the QA, SIT, PROD, backup’s, project creation, monitor/maintain project documents and reports
  • Tracked all incomplete work lists and all work variances from plans and specifications by using Turnover
  • Backup taken of the original existed production version programs, data base files before new code changes promotion
  • Promoted the programs and database files to production once sign-off received from the Client
  • Involved in reviewing the team work and provided technical support/troubleshoot to the team members
  • Mentoring team members Onsite and Offshore and send project status to the management/Client
  • Working on to supporting jobs of new programs once moved it to production to make sure every functionality working as expected
  • Working the ROBOT scheduler to monitor the jobs and maintain
  • Used Service now defect tracking tool for monitor the tickets and update the ticket based on severity till the issue get resolved

IBM iSeries AS/400 Software Consultant

Confidential, Philadelphia, PA

Responsibilities:

  • Wrote programs using RPG, CL, RPG ILE, SQLRPGLE, COBOL400, subfiles and DB2 procedures for the Individual insurance customers
  • Prepared functional and technical design for AR Medicare process and Claims process flow
  • Performed impact analysis using Hawkeye, DSPPGMREF and utilities to find out files used in the programs and references
  • Prepared unit test cases and captured test results in all the stages
  • AR Medicare outstanding balances for the Individual members output generated files data populated using the programs
  • Convert the data of output files into .xml file using CL program
  • The report files .xml are send to Highmark system through FTP or SFTP process
  • Provided support LiaisonExchange to transfer the volume of data files
  • Performed unit testing and CIT and uploaded test results in Quality center tool and provided Support to QA team for SIT
  • Promoted the programs and database files to production once sign-off received from the Client
  • TURNOVER used as change management tool to determine project scope, analyzing financial data for the project and vendor data
  • TURNOVER is used to tracking history of the objects, new/modify objects promotions, project status, compliance and quality control
  • Provided Production support 24X7 for some period and used HP quality control for ticket monitoring tool and technical support to the application
  • Experience in modernizing an AS400 server and normalization
  • Mentoring two team members Onsite and Offshore, involved in reviewing programming code, test results of the team member to make sure quality deliverables.
  • Experience in estimation, resource handling and provided the project status on daily/weekly status to the Client

IBM iSeries AS/400 Software Consultant Lead

Confidential

Responsibilities:

  • Wrote programs using RPG, CL, RPG ILE, SQLRPGLE and DB2 procedures
  • Followed in depth knowledge of Software Development Life Cycle and Standard Operating Procedures
  • Troubleshooting ofbatch jobs and addressing production issues like performance tuning on long running SQL statements and programming logic
  • Worked on programs maintenance and enhancement projects includes GMI, OTC clearing process
  • Customer Relationship Manager project received the customer data via QRCVDTAQ and sends the data through QSNDDTAQ to other systems customer with encrypted files
  • Worked on Cyber security for the customer data based on modify/add rules or policies as per the business requirement
  • Experienced in designing job batches and job sequences for scheduling jobs usingjob scheduler ROBOT.
  • Supported admin activities like user security and access to the iSeries, modify and control user profiles based on changes and maintain application software and data access and also verify security and authority of external access through VPN, FTP
  • Wrote multithread program to improve the performance of the job as job running on long time and customer needed the reports
  • Wrote stored procedures to apply the logic based on what we receiving the data and send the data to remote system to perform the business logic
  • Performed unit testing and CIT and uploaded test results in Quality center tool and provided Support to QA team for SIT
  • TRUNOVER is used as change management tool to keep history of the objects, monitoring the project status, tracking, quality control for project and reports
  • Promoted the programs and database files to production once sign-off received from the Client
  • Involved in reviewing the team work and provided technical support/troubleshoot to the team members
  • Provided production support 24X7 and handled and resolved high priority tickets by monitoring the HP quality ticket management tool
  • Mentoring team members and send project status to the management/Client
  • Provided application support experience BM Client Access(iSeries Navigator)

IBM AS400 ISeries Senior Software Engineer

Confidential

Responsibilities:

  • Analysis and understanding of the Application and the processes
  • Developed the Coding on IBM AS400 using RPG III, RPG/400, ILE, CL/400, CLILE, DB2/400, COBOL/400, SYNON
  • Preparing Unit test cases and tests the code as per unit test cases and verifies the test results and loaded in QC with captured test results
  • Provided technical support to the application all stages including production
  • Batch and Interactive debug (STRDBG and STRISDB) the applications whenever defect fix required to execute the logic worked as per requirement
  • Performed fix or bug fix and develop code using RPG III, RPG/400, ILE, CL/400, CLILE, DB2/400, COBOL/400, SYNON
  • Wrote printer programs and sub files to display the user data on the screens to reports
  • Wrote and maintenance the existing programs to send the flat files data and reports to the Clients via FTP or SFTP on demand
  • Prepared Reverse Engineering (RE) document for the modules where ever required in application as per the client requests
  • Performed unit testing and CIT and uploaded test results in Quality center tool and provided Support to QA team for SIT and ALDON has used as change management tool
  • Promoted the programs and database files to production once sign-off received from the Client
  • Involved in Reviewing Reverse Engineering (RE) documents and delivering quality of RE documents
  • Provided application support experience BM Client Access(iSeries Navigator)
  • Provided support with PTF installation, update security software
  • Experience in modernizing an AS400 server and normalization

IBM AS/400 - Software Engineer

Confidential

Responsibilities:

  • Wrote/modified programs using RPGIII, RPG400, PL/SQL, DB2, UNIX
  • Analyzing and understanding the requirement received from Client
  • Developed various bulk load and update procedures and processes using SQL Loader and PL/SQL
  • Troubleshooting performance issues with SQL tuning
  • Working in a team with other associate product & component developers
  • Prepared unit test cases and captured the results and stored in QC tool
  • Performed in Unit testing and Integration testing to test jobs and also the flow
  • Preparing Lesson Learnt documents from the previous project development and testing experience
  • Knowledge shared to team on Health care domain basics and project requirement information

IBM AS/400 - Analyst Programmer

Confidential

Responsibilities:

  • Analysis and understanding of the Application and the processes
  • Developed the Coding on IBM AS400 using RPG III, RPG/400, ILE, CL/400, CLILE, DB2/400, COBOL/400, SYNON
  • Preparing Unit test cases and tests the code as per unit test cases and verifies the test results and loaded in QC with captured test results
  • Provided technical support to the application all stages including production
  • Performed fix or bug fix and develop code using RPG III, RPG/400, ILE, CL/400, CLILE, DB2/400, COBOL/400, SYNON
  • Wrote printer programs and sub files to display the user data on the screens to reports
  • Write and maintenance the existing programs to send the flat files data and reports to the Clients via FTP or SFTP on demand
  • Prepared Reverse Engineering (RE) document for the modules where ever required in application as per the client requests
  • Performed unit testing and CIT and uploaded test results in Quality center tool and provided Support to QA team for SIT and ALDON has used as change management tool
  • Promoted the programs and database files to production once sign-off received from the Client
  • Involved in Reviewing Reverse Engineering (RE) documents and delivering quality of RE documents
  • Provided application support experience BM Client Access(iSeries Navigator)
  • Provided support with PTF installation, update security software

IBM AS/400 - Analyst Programmer

Confidential

Responsibilities:

  • Analyzing the project requirements and understanding the Application and the processes.
  • Develop the code as per the requirement on IBM AS400 using RPG/400, RPG IV, RPGILE, CL/400, CLILE, subfiles and DB2/400
  • Maintained Patient account/Patient registration modules using IBM AS400 and iSeries
  • Performed impact analysis using Hawkeye and X-Analysis on the file fields where patient number increased from 7 numeric to 9 numeric
  • Worked on ANSI X12 transaction sets like 834, Lockbox 823, 835, 837, 276, 277 and 278
  • Worked on EDI with various transaction sets like 810,850,855,856 and 820
  • Knowledge on trusted link tool to map the EDI data into DB2 files
  • Wrote RPG and CLP programs to automate the process to send the 835 remittance reports to the Clients via FTP
  • Wrote report printing programs and sub files to display the user data on the screens to maintain
  • Participating in preparing Test Plans, Preparing Test Scenarios, Preparing Test Cases for module and integration testing
  • Preparing Test Data’s for the test cases and Preparing Test Environment to execute the test cases
  • Created forms in TURNOVER and promote the code to the production level
  • Provided technical support to the application till the application get stabilized and run as per the requirement
  • Analyzing the Test Cases prepared by other team members and executing the Test cases
  • Defect Tracking and giving mandatory information of a defect to developers in order to fix it
  • Performed unit testing and CIT and uploaded test results in Quality center tool and provided Support to QA
  • Promoted the programs and database files to production once sign-off received from the Client

Software Engineer

Confidential

Responsibilities:

  • Analyzing the Functional and technical Specification document and wrote programs using RPGIII, RPG400, CLP, CL400, DB2
  • Prepared test cases and test results as per the requirement
  • Develop the code as per the requirement and print the reports for outstanding claim balances to the Client
  • Support the production system and monitoring the jobs using ROBOT scheduler
  • Compare the test results and stored in documents and placed in repository
  • Involved in fixing many bugs in the existing application system
  • Involved in the preparation of fix summary for the Bugs

IBM AS/400 - Software Engineer

Confidential

Responsibilities:

  • Wrote programs using RPG400, CLP, Display files, Sub files, Printer programs
  • Analysis and understanding of the Application and the processes.
  • Analysis, debugging the code using STRDBG, STRISDB and Unit Testing. Involved Enhancement developments using RPG400
  • Participating in preparing Test Plans, Preparing Test Scenarios, Preparing Test Cases for module and integration testing
  • Preparing Test Data’s for the test cases and Preparing Test Environment to execute the test cases
  • Analyzing the Test Cases prepared by other team members and executing the Test cases
  • Defect Tracking and giving mandatory information of a defect to developers in order to fix it
  • Support to the production application system and troubleshooting
  • Daily transactions reports are generated, maintained and send reports the Client partner systems
  • Report data is encrypted and send data to the clients

TECHNICAL SKILLS

Platforms: IBM iSeries (AS400), Windows Server 2003 R2, Window 2000/XP/NT/Vista and UNIX

Languages: RPG II/III, RPG IV/ILE (procedures, modules, binding, service program), SQL/400, COBOL/400, RPG Free,CLP, Stored Procedures, SQL, IBM DB2, MySQL, MS SQL Server 2005 and 2008 (Transact SQLstored procedures)

Tools: MS Visual Studio … MS SQL Server Business Intelligence, Visual Web Developer 2008, SSIS,SSRS,MS Office Suite, Microsoft Outlook, PowerPoint, Access, Lotus Notes, IBM Data Studio 3.1.1, SunGard GMI, Hawkeye, Implementer, Aldon Change Management System, Turnover, Mercury Test Director, IBM Utilities including PDM, SEU, SDA,RLU, DFU, IBM Client Access, SYNON, IFS, Visio, iNavigator, Query, MQ Series, Robot Scheduler, QM Query, X-Analysis, SQL Plus, Liaison, Turning point (TPS), Datastage, Cognos and BI Reporting

Hire Now