SUMMARY

• Around 8 years of total IT industry Experience in AS/400 midrange system.
• Adroit at analysis, design, development, testing, implementation, maintenance and support of different applications.
• Excellent knowledge in the usage of RPGIII, RPG IV, RPG ILE, RPG Free, CL400, DB400, Embedded SQL and SUBFILES.
• Expertise in Tools like SEU, SDA, PDM, DBU, DFU, RLU, QUERY/400.
• Good working knowledge in writing SQL queries, Work queries and able to understand the database, database relation, DSPF's, PRTF's and IFS.
• Have strong knowledge in HTML, FTP, iSeries navigator, Service programs, Trigger programs, Journals, Modules, Binder Language, Sub procedures, XML and Stored procedure concepts.
• Familiar with tools such tools such as Rev Scheduler, Turnover, HAWKEYE, Aldon and CMS.
• Entry level Knowledge in Web services and CGI Programming.
• Expert in ERP systems INFOR MAPICS/XA programming, as well as user interface design (Using Enterprise Integrator, Power Link) and implementation.
• Good knowledge on ERP COM (Customer Order Management) and Procurement Modules.
• Experience with business operations and how the business uses the software must be possessed.
• Develop and enhance programs ACCORDING to Business Requirement Definition (BRD).
• Having good exposure to Software Development Life Cycle (SDLC), Ability to handle the entire life cycle of a project from requirements gathering to development, unit testing, assisting users with QA testing, deployment and follow - up support.
• Excellent Communicator with the ability to deal the issues with precision & accuracy.
• Possess good structured programming technique and have strong analytical and problem solving abilities, understand and conceptualize applications from both a technical/programming perspective and a business point of view.
• Have excellent analytical, communication and organizational skills.
• Have excellent experience in Production Support and Analyzing Help Desk tickets.
• Delivers projects/tasks on a timely basis, with efficient processing, increased productivity, data integrity, and user satisfaction.
• Reviews, analyzes, and modifies programming systems including coding, testing, debugging and installing to support an organization's application systems.
• Collaborate with business analysts, other developers and architects/team leads to discuss complex business requirements, efficiency, maintainability, and scalability.
• Develop unit test plans, ensure software coding standards and quality are achieved, and validate that business goals are accomplished.
• Dedicated and highly motivated; a quick study who takes ownership of projects.
• Self-disciplined with attention to detail; able to prioritize and handle multiple responsibilities.
• Well-structured and comfortable functioning in a virtual environment, both independently and in teams.

TECHNICAL SKILLS

Languages: CL400, RPG III, RPG IV, RPG Free and ILE techniques.

Database: DB2/400, SQL/400, Embedded SQL

Tools: SEU, PDM, SDA, DFU, RLU, QUERY/400, Rev Scheduler, Turnover, HAWKEYE, Aldon and CMS.

Query Programming: Query/400 and Open Query File (OPNQRYF).

Interfaces: File Transfer Protocol (FTP), Stored Procedures and Integrated File Systems (IFS).

Security Administration: User Profiles, Authorization Lists, Object Authority.

ERP: Infor MAPICS/XA.

ERP User Interface: Integrator Business objects, Power Link and System Link programing.

ERP Modules: COM (Customer Order Management), PM(Procurement Modules), IM (Inventory Management) and Warehouse Management.

PROFESSIONAL EXPERIENCE

Confidential, Green Bay, WI

Sr.AS/400 Developer

Responsibilities:

• Responsible for the entire Requirement Analysis, Preparation of High Level and solution and estimates, Detailed Design Document, Unit Testing and Team Coordination.
• Analyzing upgrades for all AS400 applications and deciding whether or not these updates are necessary for the organization.
• Evaluating complex reports and queries based on inputs received from users.
• Responsible for Bug Fixing and Analyzing Help Desk tickets (Analyzing the cause for unexpected results).
• Responsible to Map AS400 spool files to Elite Forms to meet business requirements.
• Involved in client meeting and suggesting technical Solution for challenges to meet business requirement.
• Responsible of creating Stored procedures accessing service layer between .NET Java and System --I
• Design and programming of new business application module add-ons. design & programming of new order costing report. design and programming of new Vendor/Item Pricing module.
• Design and programming Automate process of Inventory management allocations through PRE ALLOCATION process without any manual work.
• Design and programming PICK/PACK/SHIP Label printing programs.
• Responsible for implementing encryption/decryption of sensitive customer information Credit Card details in various files for billing process.
• Manage and Customize the Customer order Invoices using Progress billing(PB) Application.
• The Progress Billing Application bridges the gap in the Infor XA ERP system for allowing the companies to invoice their customers progressively, typically on large project or for prepayment credit terms, based on pre-defined terms and conditions set at the order level before the actual shipment happens.
• The application helps to manage entering, maintaining and invoicing the PB Terms at order level. The user can also manage receiving and applying the cash against each of the PB invoice.
• Application allows partial shipment between the line items or at the quantity at the line item.
• The application allows post shipment billing steps if required. The full revenue is recognized at the time of shipment regardless of the status of the progress billing steps that may not have been invoiced at the time of shipment.
• Automate process to send Email Notifications to users for every quotation/order creations and on Order Acknowledgements and for every Invoice payments.
• Automate process of Estimate creation by loading part information from BOM.
• Responsible for Client upgrades and PCM release updates and fix the patches by applying PTF’s.
• Responsible for in deploying the deliverables to production environment.
• Responsible for Production Support.
• Root Cause Analysis for long standing issues and fixing them.
• Responsible for applications on the AS400 platform ~ include MAPICS/XA /custom (Sales, Order Entry, Purchasing, Billing, AR, AP, Job Costing, Sales Rep Commissioning).
• Monitoring jobs running under AS/400 server and system performance.
• Coordinating with client to get queries clarified.
• Analyzing RPG/CL code written on AS/400 environment and to come up with analysis document.
• Involved in testing of regular patches, and developed and executed test cases.
• Responsible for preparing Test cases (Both Unit and System test cases)
• Updating SODs to sync with latest requirements implemented.
• Actively participated in project planning, estimation and resource allocation.
• Progress Billing Application to manage invoices.

Environment: RPG IV, RPG Free, Embedded SQL, CLLE, DB2/400, SQL400, Rev Scheduler, Power Link, System Link, Stored procedures, File Triggers, Journals, I-Series Navigator and ILE techniques using Sub-Procedures, Activation Groups, Modules Service Programs, Binder Language.

Confidential, Minneapolis

Sr.AS/400 Developer

Responsibilities:

• Worked with functional and technical project leads, insurance and other business groups to identify, analyze, and document Business requirements.
• Responsible for XA Migration support from Rel. 7.7 to Rel. 9.1.
• Maintain and upgrade AS/400 systems (hardware/software/operating systems) to industry standards.
• Develop RPG and CLP custom software applications per client's specifications.
• Application Software Development utilizing interactive sub files and batch processing methods.
• Implement and manage appropriate AS/400 security for system and applications at object and user level.
• Post implementation support.
• Involved in Business meetings/discussions and gathering requirements from users.
• Provided analysis and documentation of all user reports & interfaces related to the AS400 systems.
• Developed and enhanced financial, manufacturing and distribution programs using RPG/400.
• Support and maintenance of AS400 Legacy Systems written in CLP, COBOL & RPG.
• Develop custom software applications for International Dealers using CLP, RPG, ILE, DDM File and FTP communications.
• Designed and coded a set of Triggers programs to update Cost, sending Notification Emails to Users and other mapics related custom files.
• Monitored AS400 messages and took initiative to resolve errors.
• Programmed the Bar code program to generate bar codes labels.
• Implemented a hand-held scanner interface to automate warehouse and inventory processes
• Created queries, reports, updates, and batch programs to accommodate management objectives.
• Responsible for the scheduling, and monitoring the progress of all data processing projects.
• Resolving incidents and fixing the Bugs
• Ensure quality standards of the organization to meet the customer needs.
• Prepare & providing technical documents, Test cases and Test Results.
• Effective coordination between on-site and off-site teams.

Environment: RPG IV, RPG Free, Embedded SQL, CLLE, DB2/400, SQL400, CMS, ALDON, HAWKEYE, Power Link, System Link, Stored procedures and ILE techniques using Sub-Procedures, Activation Groups, Modules Service Programs, Binder Language.

Confidential

AS/400 Developer

Responsibilities:

• Analysis, Design, Coding and Testing of the Warehouse management module tailored to the specific need of the customer.
• Developing reports on GPS Analytics to measure the Sales Performance.
• Development and support on custom application YER which details the rebate calculation and information of sales.
• Monitoring of the scheduled jobs which includes the backups, running of Business Intelligence tool, planning run etc.
• Preparing Technical design, Test cases and Work instructions.
• Impact Analysis, Design, Coding and testing on the new enhancements.
• Defect fixing and Code review.
• Preparing RCAs for critical incidents.
• Implementing bug fixes and Reviewing the solution
• Educating the users if incident logged is not actually an issue.
• Being a member of data migration team, migrated data from SAP to Infor XA.
• Designed different reports and Forms using Inter Form tool.
• Analyze, design, program and implement electronic mail system for use by 200 plus users at 26 remote sites.
• Responsible for Project Management.
• Preparing action plans for future hardware/software, staff selection, motivation and evaluation; elaborating, implementing and monitoring the effectiveness and design of systems
• Responsible for system resource management, security and database design.
• Responsible for technical support to operations and users.
• Effect upgrade of AS/400 OS to New version or release.
• RPG/400, RPGIV, ILE Application Software Development utilizing interactive sub files and batch processing methods.

Environment: RPG III, RPG IV, RPG Free, Embedded SQL, CLLE, DB2/400, SQL400, Sub Files, and ILE techniques using Sub-Procedures, Activation Groups, Modules Service Programs, Binder Language.

Confidential, Houston

AS/400 Developer (Internship Project)

Responsibilities:

• Responsible for the entire Analysis, Estimates, Design, Coding and Testing
• Responsible for in deploying the deliverables to production environment
• Responsible for Production Support (Offshore - 5 x 10).
• Responsible for Bug Fixing and Analyzing Help Desk tickets (Analyzing the cause for unexpected results).
• Analyzing RPG/CL code written on AS/400 environment and to come up with analysis document
• Responsible for preparing Test cases (Both Unit and System test cases).
• Responsible for design QI and Code QI done by the client along with Onsite.
• Weekly status meetings with the team and understanding where on deliverables.
• Monitoring of the scheduled jobs which includes backup for BOD and EOD.
• Understanding the changes to be made for programs and to carry out the changes and coding required programs.
• Working with BSA to understand businesses requirements.

Environment: RPG III, RPG IV, SQL, CLLE, DB2/400, and Triggers.