AS400 Technology Lead
Resume:
Ravikumar Arani Perumal
OBJECTIVE
To secure a position as a technical lead that utilizes my 6 years technical experience, business analysis capabilities, designing optimized software, refactoring and re-engineering. Looking for more challenging environment that will leads to more learning.
PROFESSIONAL SUMMARY
• Over 4 years of onsite experience in IT industry specialized in Retail and Supply Chain Management involving the areas of Analysis, Design, Development, Testing and Implementation.
• Have extensive experience in working with RPG/400, RPGILE, CL/400, CLLE, Embedded SQL, Free Format RPG, SQL/400, Query/400 and well versed with RDBMS like DB2/400 etc.
• Current responsibilities include understanding Client’s expectations, requirements and develop solutions.
• Experienced in Sub file programming.
• Have excellent experience with the ILE features like Procedures, Modules, Bind Directories, Service programs , Binder Language etc.,
• Developed numerous reports using WEBSMART, SQL queries and WRKQRY.
• Proficient in the application of EDI ANSI X12 standard in Gentran Server (Windows & Unix).
• Experienced in implementing EDI Transactions for Order fulfillment activities such as 810, 850, 852, 855, 856 and 997.
• Experienced in implementing EDI Transactions for Carrier Logistics activities such as 204, 214 and 990.
• Translated EDI to Flat Files
• Established new trading partners to increases EDI activity
• Experienced in setting up AS2 Communication between trading partners and VAN.
• Worked on high-profile projects in a very dynamic environment, with the ability to multitask, good knowledge of SDLC and software development methodologies.
• Software development is done following different phases of Waterfall model.
• Technical support was done through Incident, Problem and change management in service support of ITIL framework.
• Acquired good communication (verbal and written), Analytical Skills, Multi tasking, Interpersonal Abilities, Management Skills, Multicultural Awareness, Planning/Organizing, Problem-Solving/Reasoning/Creativity and Teamwork.
• Acquired good people management skill and manage people at offshore in transitioning functional design, providing technical solution and resolving issues or challenges.
SPECIALIZATION
Programming Languages RPG-Free, RPGLE, RPG/400, ILE CL, CL/400, SQLRPGLE, COBOL/400
Database tool/language SQL/400, DB2 and Query/400.
Operating System OS/400, Unix, Mac and Windows.
Project management tool MPP, HP Quality Center, Remedy and VSS.
As400 tool RLU, SDA, SEU, FTP, IFS, APLUS ,Hawkeye, Somplus and Implementer
Reporting tool Websmart, BI publisher and Work Query/400
IT Compliance Sarbanes–Oxley, Defect prevention analysis using Pareto chart and fish bone diagram
EDI Subsystems Gentran Server: UNIX , Windows
EDI Documents 204, 214, 810, 850, 852, 855, 856, 860, 990 and 997
EDI Standards ANSI X12
CERTIFICATIONS
• IQ Foundation Certification
• AS400 Foundation Certification
• AS400 Basic Programming Certification
• AS400 Advanced Programming Certification
• AS400 RPG, Cobol, CLLE concepts
• RETL Basics of CPG Retailing
• RETL Introduction to Retailing
• RETL Merchandise Management Module
• RETL Basics of Transportation and Logistics
ROLES & RESPONSIBILITIES
Role Responsibilities From To Client Place of Work
Systems Engineer Understand functional design,
Prepare technical design,
Build and unit testing. 06/01/2005 05/01/2007 Toys R Us Chennai,
India
Senior Systems Engineer Review functional design,
Guide developer to prepare technical design,
Participated in build estimation
Review technical design,
Code Review,
Unit testing,
Integration testing
Prepare documents related to deployment. 05/01/2007 08/31/2009 Toys R Us Wayne,
New Jersey
Technical Analyst Involved in Business requirements gathering,
Brain storm for best approach through group discussion
Design functional design
Transition FD to Offshore and clarify questions
Participated in creating high level effort estimate
Review TD
Get approval on TD from client,
Clarify issues and questions from Offshore,
Review build,
Integration testing
Deployment. 09/01/2009 09/30/2010 STARBUCKS Seattle, Washington
Technical lead Involved in Business requirements gathering,
Brain storm for best approach through group discussion
Transition FD to Offshore and clarify questions
Review TD
Get approval on TD from client,
Clarify issues and questions from Offshore,
Review build,
Integration testing
Deployment. 10/01/2010 Till date STARBUCKS Seattle, Washington
PROJECT EXPERIENCE
Project & Description WMS Outbound rationalization - The purpose of this project is to revisit the warehouse outbound process like creating delivery for orders, create transfers for delivery, create pick document for transfer, create letdown if inventory is unavailable for and item, pick approval, ship confirmation of transfer, use pFastship package decide the rate of shipping, print bill of lading and manifest report for the delivery.
Role Onsite coordinator & Business analyst. Type of Project Extension – Development
Technology RPGLE and SQLRPGLE
Period & Duration 01-Nov-2010 to till date Duration In progress
Responsibilities • Get the requirement from client and create functional design out of it.
• Transition the functional design to offshore team
• Publish development plan in the format agreed with client and using MPP.
• Schedule meeting with client/ functional analyst to resolve the issue or questions from offshore.
• Review technical design from offshore and get approval from client.
• Review the build done by offshore, test the modification to make business requirements are met and deliver to client on-time.
• Revisit the development plan if there is any CR - Change request.
• Unit testing and integration testing will be done for the components delivered at onsite.
• Categorize the review comments from client as defect, Cosmetic, Logic error and change request.
PROJECT EXPERIENCE
Project & Description Inventory adjustment Publish from JDA(As400) to Oracle – The inventory adjustment interface is a technical component of a business process to ensure the inventory reflected in Oracle for Starbucks inventory is as accurate as possible in relation to what is reflected in AS400 WMS.
Role Onsite coordinator & Business analyst. Type of Project Interface – Publish
Technology RPGLE and SQLRPGLE
Period & Duration 01-Apr-2010 to 30-Sep-2010 Duration 5 months
Responsibilities • Get the requirement from client and create functional design out of it.
• Transition the functional design to offshore team
• Publish development plan in the format agreed with client and using MPP.
• Schedule meeting with client/ functional analyst to resolve the issue or questions from offshore.
• Review technical design from offshore and get approval from client.
• Review the build done by offshore, test the modification to make business requirements are met and deliver to client on-time.
• Revisit the development plan if there is any CR - Change request.
• Unit testing and integration testing will be done for the components delivered at onsite.
• Categorize the review comments from client as defect, Cosmetic, Logic error and change request.
Project & Description Expected receipt subscribe from Oracle to JDA (AS400) – The purpose of this interface is to publish the expected receipt from EBS (Oracle) to JDA (AS400). Based on expected receipts, items will be received in WMS.
Role Onsite coordinator & Business analyst. Type of Project Interface – Subscribe
Technology RPGLE and SQLRPGLE
Period & Duration 01-May-2010 to 31-Oct-2010 Duration 5 Months
Responsibilities • Get the requirement from client and create functional design out of it.
• Transition the functional design to offshore team
• Publish development plan in the format agreed with client and using MPP.
• Schedule meeting with client/ functional analyst to resolve the issue or questions from offshore.
• Review technical design from offshore and get approval from client.
• Review the build done by offshore, test the modification to make business requirements are met and deliver to client on-time.
• Revisit the development plan if there is any CR - Change request.
• Unit testing and integration testing will be done for the components delivered at onsite.
• Categorize the review comments from client as defect, suggestion, Cosmetic, Logic error and change request.
Project & Description Like item setup in average order history item – When a new item is setup in the system, in order to generate purchase order, a item of same kind that has purchase order history will be setup as Like Item.
Role Onsite coordinator & Business analyst. Type of Project Extension
Technology RPGLE and SQLRPGLE
Period & Duration 01-Feb-2010 to 31-Mar-2010 Duration 2 Months
Responsibilities • Get the requirement from client and create functional design out of it.
• Transition the functional design to offshore team
• Publish development plan in the format agreed with client and using MPP.
• Schedule meeting with client/ functional analyst to resolve the issue or questions from offshore.
• Review technical design from offshore and get approval from client.
• Review the build done by offshore, test the modification to make business requirements are met and deliver to client on-time.
• Revisit the development plan if there is any CR - Change request.
• Unit testing and integration testing will be done for the components delivered at onsite.
• Categorize the review comments from client as defect, suggestion, Cosmetic, Logic error and change request.
Project & Description Credit request report – This report will give the information of items that are delivered as damaged, short and over received in the stores from DC.
Role Onsite coordinator Type of Project Reports
Technology RPGLE and CLLE
Period & Duration 01-Jan-2010 to 28-Feb-2010 Duration 2 Months
Responsibilities • Get functional design signoff from functional analyst.
• Transition the functional design to offshore team
• Publish development plan in the format agreed with client and using MPP.
• Schedule meeting with client/ functional analyst to resolve the issue or questions from offshore.
• Review technical design from offshore and get approval from client.
• Review the build done by offshore, test the modification to make business requirements are met and deliver to client on-time.
• Revisit the development plan if there is any CR - Change request.
• Unit testing and integration testing will be done for the components delivered at onsite.
• Categorize the review comments from client as defect, suggestion, Cosmetic, Logic error and
Project & Description Report on Merchandizing management system generated ASN – This report will give the information of alternate ASN created by the system when the actually ASN is not arrived from vendor.
Role Onsite coordinator & Business analyst. Type of Project Reports
Technology RPGLE, CLLE and Websmart
Period & Duration 01-Jan-2010 to 31-Mar-2010 Duration 3 Months
Responsibilities • Get the requirement from client and create functional design out of it.
• Transition the functional design to offshore team
• Publish development plan in the format agreed with client and using MPP.
• Schedule meeting with client/ functional analyst to resolve the issue or questions from offshore.
• Review technical design from offshore and get approval from client.
• Review the build done by offshore, test the modification to make business requirements are met and deliver to client on-time.
• Revisit the development plan if there is any CR - Change request.
• Unit testing and integration testing will be done for the components delivered at onsite.
• Categorize the review comments from client as defect, suggestion, Cosmetic, Logic error and change request.
Project & Description Stock Count application - The inventory is said to be the main backbone of retail business. Physical counted quantity are captured in stock count application and adjustment will be made, if there is any variance between counted quantity and system onhand. The counting will be done in different mode like cycle – Count certain items, Department – Count items present in particular department and Full physical – Count all the item present in the store.
Role Onsite coordinator Type of Project New development
Technology RPGLE and SQLRPGLE
Period & Duration 01-Sep-2009 to 31-Dec-2009 Duration 4 Months
Responsibilities • Get functional design signoff from functional analyst.
• Transition the functional design to offshore team
• Publish development plan in the format agreed with client or using MPP.
• Schedule meeting with client/ functional analyst to resolve the issue or questions from offshore.
• Review technical design from offshore and get approval from client.
• Review the build done by offshore, test the modification to make business requirements are met and deliver to client on-time.
• Revisit the development plan if there is any CR - Change request.
• Unit testing and integration testing will be done for the components delivered at onsite.
• Categorize the review comments from client as defect, suggestion, Cosmetic, Logic error and publish to client. Based on defect action plan will be derived and tracked to closure.
Project & Description Cost based system – Initially company reporting are done using retail called Retail Inventory Report. However this has been modified to provide inventory movement at cost. Hence WAC – Weighted average cost is calculated. In order to calculate WAC, the transactions like receipt and inventory adjustment are used. The calculated WAC is used as the cost of item in Sales, Reverse inventory flow, Promotional funding, Warehouse to Warehouse transfer, store to store to transfer, Etc.
Role Technical analyst & Onsite coordinator. Type of Project New development
Technology COBOL400 and CL400
Period & Duration 01-Sep-2007 to 31-Aug-2008 Duration 1 years
Responsibilities • Get the requirement from client and create functional design.
• Transition the functional design to offshore team
• Publish development plan in the format agreed with client or using MPP.
• Schedule meeting with client to resolve the issue or questions from offshore and communicate back VIA issue tracker and email.
• Review technical design from offshore and get approval from client.
• Review the build done by offshore, test the modification to make business requirements are met and deliver to client on-time.
• Revisit the development plan if there is any CR - Change request.
• Unit testing and integration testing will be done for each components delivered to onsite.
• Categorize the review comments from client as defect, suggestion, Cosmetic, Logic error and change request, and publish to client.
Project & Description Finance maintenance support - Application under the radar of maintenance are,
• Invoice creation, matching invoice with Receipt or keyrec and posting into accounting payable
• Account payable adjustment and Print check to vendor based on account payable.
• Reverse inventory flow like Return to vendor incase of damaged, return to warehouse incase of space constraint, Return goods damaged incase it cannot be returned neither to vendor nor to warehouse
• Price change process.
Role Onsite coordinator Type of Project Maintenance
Technology COBOL, COBOLLE, RPG, RPGLE, CLLE and CL400
Period & Duration 01-Aug-2007 to 31-Aug-2009 Duration 2 Years
Responsibilities • Provide 24/7 support
• Provide resolution with in SLA.
• Handle minor and major bug fix, data fix and analysis
• Update issue repository and knowledge base for future reference
Project & Description Merchandizing maintenance support - Application under the radar of maintenance are,
• Item creation, maintenance and purge
• Purchase order creation, maintenance, printing, transmission and purge
• Creation of store, closing the store, transferring the inventory in a store to another and Creation of warehouse in the system.
• Transmission of purchase order to vendor.
Role Onsite coordinator Type of Project Maintenance
Technology COBOL, COBOLLE, RPG, RPGLE, CLLE and CL400
Period & Duration 01-Jun-2005 to 31-Aug-2007 Duration 2 Years
Responsibilities • Provide 24/7 support
• Provide resolution with in SLA.
• Handle minor and major bug fix, data fix and analysis
• Update issue repository and knowledge base for future reference
Project & Description Transmission of purchase order to APLL - The purchase order created in different machine in different time zone are gathered in EDI machine, converted into EDI 850 and 860 formats and transmitted to APL logistics.
Role Developer Type of Project New development
Technology CL400 and Free format RPG in OS400.
Period 01-Jan-06 to 31-July-06 Duration 6 months
Responsibilities • Review functional design to make sure the details necessary for a developer are present.
• Walk through the functional design to developer, guide in building technical design.
• Review to crosscheck functional design is in sync with technical design.
• Provide technical guidance to developer during build for optimal coding, standards and structure.
• Test the modification, capture defect in all phases to do defect prevention analysis and deliver.
• Prepare ITP – Integration test plan.
Project & Description LOGNET - The purchase orders created to vendor in far eastern countries like Hongkong, Singapore, Thailand, and China etc. are consolidated. The consolidated data will sent to consolidator through FTP. This is done in daily nightly batch job and also in ad-hoc manner.
Role Developer Type of Project New development
Technology CL400 and COBOL400 in OS400.
Period 01-Jun-05 to 31-Dec-05 Duration 6 months
Responsibilities • Understand the functional design prepared by functional analyst.
• Create technical design and unit test plan based on the business requirement mentioned in functional design.
• Review to crosscheck functional design is in sync technical in technical design
• After TD approval, build according to technical design with optimal coding, following standards and structure for easy maintainability.
• Self testing and regression testing to make business requirement, negative conditions and boundary conditions are handled.
Contact this candidate