AS400/RPG Developer

Mahesh B Tel: +1-920-***-****

Email: ******@*****.***

Professional summary:

Around 6 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 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, Modules, Bindings, Sub procedures, XML and Stored procedure concepts.

Familiar with tools such tools such as Rev Scheduler, Turnover, HAWKEYE, Aldon, MKS 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.

Education:

Bachelor of Engineering in Computer Science.

Jawaharlal Nehru Institute of Technological University (JNTU), Kakinada, India

Technical Training and Certifications:

Certified AS/400 Developer from PMS Training Academy, Chennai.

Received “Shine the light” award in 2012 for the Polaris project, India.

Attended corporate classroom trainings on C#, ASP.NET, ADO.NET and SQL Server.

Technical Summary:

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, MKS 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:

Paper Converting Machine Company, Green Bay, WI May ‘2013 – Till Date 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.

Environment: RPGLE, RPG/400, RPG Free Format, SQLRPGLE, CLLE, DB2/400, Rev Scheduler, Power Link, System Link, Web services, ILE techniques, Stored procedures, File Triggers and IFS.

Polaris Industries, Minneapolis, US Nov ’2011 – May ‘2013

Off-Shore Support, 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: RPGLE, RPG/400, RPG FreeFormat, SQLRPGLE, CLLE, DB2/400, CMS, ALDON, HAWKEYE, Rev Scheduler, ILE techniques, stored procedures, Triggers and IFS.

Havells - Sylvania, Belgium Mar ’2010 – Nov ‘2011 Off-Shore Support, 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: RPGLE, RPG/400, RPG ILE, SQL, CLLE, DB2/400, Subfiles, Triggers and IFS, MKS and Turnover tools.

Contact this candidate