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 The Home Depot.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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 incorporate 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.