Management Engineer

Vamsi Pamula

I-Series Consultant

*********@*****.***

SUMMARY:

More than Seven Years of IT experience as I Series Consultant in development, enhancement and support environments.Around Three Years of Non- IT experience as Production Planning engineer using RAMCO ERP.Proven professional career progression as Lead consultant.Exposed to analyzing, designing, developing, testing and implementing system solutions to meet the business unit requirements.High proficiency in problem solving, logical and analytical abilities.Excellent communication skills, leadership qualities, systematic approach and ability to work effectively in a fast paced environment.Skilled in management of full project life cycle; concept through implementation.Worked on configurations and execution of Supply Chain Modules such as Warehouse Management, Central Order Management and Freight Forwarding.Self-disciplined with attention to detail; able to prioritize and handle multiple responsibilities.Skilled in RPG III, RPG IV, RPG Free Format and Modular programming.Extensively used File Transfer Protocol (FTP).Skilled in Screen Design Aid (SDA) and Report Layout Utility (RLU).Worked on Lansa for I-series and Lansa for Web.Skilled in Sub file programming.Well organized job and change control.Skilled Embedded SQL RPG ProgrammingUsed ACOM for few reports in Finance module.Worked on SYNON/2e data models and programs.Skilled in different EDI types, i.e., Flat file, EDIFACT and X12.Exposed to MQ Series while interfacing between Sales module and PkMSSkilled in Sales Software (Order Entry, Invoicing)Exposed to SAP R/3 and SAP Advance Planning and Optimizer.Experienced working on web GUI for I-series programs by using tools like CGIDEV or PCML concepts.

TECHNICAL SKILL:

ERP

LIMS, SAP

Specialization

Supply Chain Management

Change Management

Change Master, Aldon

Operating Systems

Windows 98/NT/2000/XP, OS/400 & UNIX

Languages

RPG Free Format, RPG IV, RPG III, CL, SYNON2/e, LANSA, C, C++, HTML

Tools

I-Series Navigator, Hawk Eye, CGIDEV, PkMS, MQ Series, ACOM

Database

DB2/400 and Oracle

PROJECT DETAILS:

Client: Confidential Jul 2010 – Present

Title: I-Series Consultant

Environment: OS/400, LANSA, RPG ILE, CL

Skills: LANSA, RPG Free Format, RPGIV, CL, SQLRPGLE, ILE, DB2/400

Roles & Responsibilities:Reporting the deviations in resolving the issue and taking corrective actions in order to satisfy client and the same time updating the client on the developments.Sending a meeting invitation to client and weekly discussions up on the developments and the ticket status, Work hrs booked, average tickets and other related issues and coordinating the team.Defined and specified technical specifications & Preparation of Test Scripts for Integration Testing.Worked on integration between People soft and I-Series.Worked on the different functionalities related to Order management, Sales, Finance and Order fulfillment.Conducted user training and prepared end user manuals and documenting the support issues in the team site.Monitoring the daily/weekly/monthly data loads from 3rd party to I-Series. Used RPG Free Format to improve the efficiency and readability of the programming in few application modules.Worked on LANSA, RPG ILE and SQL Procedures in developing / maintaining the applications.Extensively used File Transfer Protocol (FTP) to transfer data / files from one AS/400 system to other.Exposed to PKMS ware house modules.Worked on Job control and CL programming.Created Web Application Modules and Weblets.Used SQL embedded RPG programming in Order Interface application.Exposed to MQ Series to interface between PKMS and Order interface.Worked on sub file programming in Order entry and fulfillment application.Provided reports using LANSA and RPG.Used SQL/400 and Query/400 while analyzing the production issues.Integrated AS/400 application and other 3rd party software using Flat files.ACOM forms used in creating Invoices and dunning letters for Account Receivables team.Coordinating with the team while providing solutions for the reported issues and new features.

Client: Manheim Auto Auctions, Atlanta Mar 2009 – June 2010

Title: RPG Consultant

Environment: I series

Skills: RPGIV, RPG Free Format, CL, SQLRPGLE, ILE, DB2/400, Crystal Reports & SYNON2/e

Roles & Responsibilities

Served as a liaison between the client, consumer and the company by answering routine questions and resolving problems to ensure client satisfaction.Investigated clients’ inquiries regarding the status of an assigned specialized service.Responsible to understand the business process and provide feedback on the same to the technical team for development of reports and layout sets.Examined various records such as statements, print outs and correspondence with researching problems.Developed, tested and implemented transport planning.Responsible for participating in a continuous improvement process plan.Understanding the degree of complexity of customizing done in all the sub modules including information systems.Listing of issues arising out of users day to day transactions and loading them along with resolutions.Detailed product training to the core team member.Developed maintenance screens and process routines using RPG ILE concepts.Extensively worked on sub file programming in Transaction module.Exposed to Crystal Reports in Finance module.File Transfer Protocol (FTP) was used to transfer data/ files across two different AS/400 machines.Worked on Job control and CL programming.Implemented finance module using SQL embedded RPG programming.Used SQL/400 & Query/400 in researching of production issues.Effectively used Arrays and tables for validation errors and single page sub file programming.Data transmission and configuration set up done using data area and data queues.Used Socket jobs to interface data between two different I-series machines.Worked on CGIDEV to enhance features to make availability through HTML.Modularized the code using Modules, Service Programs & Binding Directories.

Client: DHL Logistics, The Netherlands Dec 2005 – Feb 2009

Title: RPG and SYNON Application Developer

Environment: I Series, SAP R/3 & UNIX

Skills: RPG III, RPGIV, CL, SYNON/2e, SQLRPGLE and DB2/400

Roles & Responsibilities

Served as a liaison between the client and the business users by answering routine questions and resolving problems to ensure client satisfaction.Investigated client’s inquiries regarding the status of an assigned specialized service.Responsible to understand the business process and provide feedback on the same to the technical team for development of reports and layout sets.Creation/Checking of functional specifications in logistics module.Examined various records such as statements, print outs and correspondence with researching problems.Developed, tested and implemented transport planning.Responsible for participating in a continuous improvement process plan.Understanding the degree of complexity of customizing done in all the sub modules including information systems.Listing of issues arising out of users day to day transactions and loading them along with resolutions.Trouble shooting accessing software and equipment problems as needed.Developed process routines and screens using RPG IV Programming.Used sub file programming in modules like Order entry, Central order management and Freight forwarding.File Transfer Protocol (FTP) was used extensively to transfer data between two different AS/400 machines.Worked on Job control and CL programming.Extensively used SQL/400 and Query/400 in the analysis of production issues.Used SQL embedded RPG programming to develop maintenance screens in Warehouse management module.Arrays and tables used in logging the validation errors and in transaction details maintenance screens.SYNON 2/e Data modeling and programming concepts used in various modules.Used PL/SQL Procedures to do logging related to our sorting application on Oracle database.Worked on data base concepts like Multi member physical files and join logical files.X12 EDI interface used to integrate SAP R/3 and I-Series for one ware house management location.Used EDIFACT and Flat file EDI format to communicate to the 3rd party vendor application from i-series application.

Client: Fireman Fund Corporation, Novato, CA Jul 2005 – Oct 2005

Title: I Series Programmer

Environment: I-Series

Skills: RPG III, RPGIV, CL and DB2/400

Roles & Responsibilities

Extensively worked on Preparing AID (Application Information Document)Carried over the Peer code reviews and Test Results Review across the teams.Monitoring the scheduled tasks on weekly basis. Developed applications as per the technical specifications.Used RPGIII, RPG IV Programming techniques to develop the applications.Extensively used sub file programming in claims module to show transactions at detail and header level.File Transfer Protocol (FTP) used to assist in the change management procedure.Worked on Job control and CL programming.

Client: Amara Raja Batteries – India July 2002 – Apr 2005

Title: Production Planning Engineer

Environment: RAMCO ERP

Roles & Responsibilities

Involved in production planning of manufacturing of batteriesWorked on creating daily planning schedule.Worked as production floor in charge.Managed the resources to meet the daily production targets.

Contact this candidate