SUMMARY

• Around eight years of IT experience in software analysis, design and development for various software applications in client - server environment in providing ERP customization. Currently working as lead developer for Confidential .
• Extensively used RPG/400 and RPGLE for supporting several ERP application customization, maintenance and support solution using AS/400 Technology.
• Knowledge of different Tools (EZeDocs/400, ARCAD, HAWKEYE, ALDON) to perform analysis, design and reporting business analysis requirements.
• Extensively worked on PDM, SEU, SDA, DFU, RLU and, DBU for database maintenance and development to meet the business requirements.
• Worked on MAPICS XA Enterprise Resource Planning application on commercial, inventory, manufacturing and financial modules.
• Worked on MMS (Merchandise Management System) to provide innovative supply chain management methodologies, merchandising and pricing excellence solutions.
• Extensive experience in writing SQL queries and Triggers in ILE CL to perform the interfacing with DB2/400.
• Generated Business reports using Report Layout Utility as a reporting tool as and when required for the warehouse management system for inbound and outbound related reports.
• Experience in providing the domain training of the application for the new resources in team and organizations.
• Coordinating with offshore resource and the client technical lead for business solutions.
• Strong exposure to the entire Software Development Life Cycle viz, requirements gatherings and other project management activities.
• Excellent inter-personal and communication skills and ability to work individually as well as in a team.
• Highly motivated self-starter with ability to handle multiple projects and meet tight deadlines.

TECHNICAL SKILLS

AS/400 Tools: PDM, SEU, SDA, DFU, RLU, DBU, EZeDocs/400, ARCAD, HAWKEYE, ALDON, SYNON, Query Manager.

ERP Packages: MAPICS XA 6.0 on i-Series, MMS 7.4 and BPCS

Database: DB2/400, Oracle 8i/9i/10g/11g, MS-Access, SQL-Server 2000.

Other tools: TOAD 7.X, SQL *Plus, PL-SQL Developer, SQL-Navigator, SQL-Loader.

Languages: RPG/400, RPGLE, CL/400, ILE CL, SQL/400, SQL RPGLE, Query/400, COBOL/400, C, C++, SQL, PL/SQL, Shell Scripting, VB 6.0

Testing tools: Quality Center

Operating Systems: Unix, OS/400, Windows 2000 server/professional, XP, NT

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Lead Developer

Environment: RPGLE, ILE CL, DB2/400, OS/400, SQL/400, HAWKEYE, ARCAD, IBM Tivoli Maestro Scheduler

Responsibilities:

• Developed the programs related to inbound/outbound shipment reports.
• Developed the programs related inventory management within the WMS and MIS Reports.
• Created the Sub files for the User in the Areas of Receivables of the Trailers in the WMS.
• Modified the application to perform the customization and to update files as per the technical specifications.
• Involved in the inbound and outbound jobs processing for the labor management within the RDC.
• Involved in the programs related HAZMAT within the WMS.
• Coordinated with offshore resources to meet the deliverables within the budget and timeline.
• Coordinated with other teams to receive the ASNs and POs from different Vendors.
• Coordinated with QA team in the areas of functional, non-functional, regression and integration testing and fixing the defects.
• Design and development of actual codes, unit testing & integrated testing, Code review, System Documentation.

Confidential, Minneapolis, MN

Sr. Developer

Environment: AS/400, RPGLE, ILE CL, DB2/400, OS/400, SQL/400, HAWKEYE, ARCAD, MAPICS, ALDON, SYNON.

Responsibilities:

• Developed the programs for order creation and maintenance of the order.
• Developed the report program for the distributors for whom the commission is given.
• Analyzing and eliminating errors after updating the programs/files.
• Develop customized application to upload data for commission from different applications into COM files.
• Modified the application to perform the customization and to update files as per the technical specifications.
• Involved in the implementation of Sales & Distribution module. Job involves mapping of current process to the application.
• Performed the requirement Analysis, Pre and Post implementation support and extensive customization of the system that involved maintenance of various programs like invoice generation(Foreign and local), entity ledger, GRN, Balance sheet etc. which were developed according to the environment needs.
• Was actively involved in analyzing the requirements specifications.
• Design and development of actual codes, unit testing & integrated testing, Code review, System Documentation.
• Documentation & Unit Testing.

Confidential

Sr. Developer

Environment: AS/400, RPG/400, RPGLE, ILE CL, DB2/400, SQL RPGLE, OS/400, SQL/400, HAWKEYE, ARCAD, MMS.

Responsibilities:

• Developed the programs for Warehouse and stock replenishment.
• Modified the MMS automated replenishment applications.
• Developed reports and Inquiry functions as per the user requirement.
• Responsible for identifying the changes in database and related customised programs for all Modules.
• Analyzing and eliminating errors after updating the programs / files in the Live Environment.
• Performed the requirement Analysis, Pre and Post implementation support and extensive customization of the system that involved development of various programs like invoice generation(Foreign and local), entity ledger, GRN, Balance sheet etc. which were developed according to the environment needs.
• Was actively involved in analyzing the requirements specifications sent by the client.
• Design and development of actual codes, unit testing & integrated testing, Code review, System Documentation.

Confidential

Responsibilities:

• Creation of Interface programs, RLU design and, report generation.
• Inventory enhancement has been done and obtained the requirements specifications and prepared the design documents, create test plans, and reviewing.
• Customized the Interface programs
• Developed a single page sub file program which provides a user interface to maintain Inventory for each item that has to be shipped.
• Providing the domain training of the application for the new resources in team and organizations.
• Design and development of actual codes, unit testing & integrated testing, Code review, System Documentation.

Confidential

System Analyst

Environment: AS/400, RPG/400, RPGLE, ILE CL, DB2/400, OS/400, SQL/400, HAWKEYE, ARCAD, SYNON, MAPICS, ALDON, JOB SCHEDULER, SYNON.

Responsibilities:

• Modified the MAPICS programs of pick list.
• Prepared the Impact Analysis and Test Plan
• Developed IFM reports like General Ledger, Entity Ledger and Entity Aging.
• Responsible for changing most of the EXMAP programs such as Goods Receipt Note (GRN) to receive material against Purchase Orders and Issue to Subcontractor and Receipt from Subcontractor programs to match the customer requirement.
• Analyzing and eliminating errors after updating the programs / files in the Live Environment.
• Prepared Test Cases, Done the testing for all the programs, developed the test results and Bug reports.

Confidential

Responsibilities:

• Prepared the Technical Specifications and Test Plan.
• Customized the MAPICS Interface programs.
• Developed a screen to maintain the different levels and combination in the version.
• Identifying the Programs to be modified at the Price Book level, Receipt level and at the Invoicing level.
• A screen to be designed which allows user to enter the sequence to calculate the 3 levels of taxes, Inclusive or exclusive of Discounts and Freight charges.
• Purchase Order format to be redesigned to in corporate the Price Book changes at tax level printing.
• Carried out testing for the entire application by putting/getting the messages to/from the local and remote queues.
• Developed the test cases, test results and bug reports.

Confidential

System Analyst

Environment: AS/400, RPG/400, RPGLE, ILE CL, DB2/400, OS/400, SQL/400, HAWKEYE, ARCAD, EZeDocs/400, SYNON, MAPICS, SYNON.

Responsibilities:

• Developed the programs for order creation and maintenance of the order.
• Developed the report program for the distributors for whom the commission is given.
• Develop customized application to upload data for commission from different applications into COM files.
• Developed customized batch applications to update files as per the technical specifications.
• Involved in the implementation of Sales & Distribution module. Job involves mapping of current process to the application.