SUMMARY

• 10+ years of IT Experience in IBM AS400 technologies in Application Development, Technical Analysis, Maintenance and QA Activities with Retail & Supply chain domain experience
• Involved in End - to-End Implementation (SDLC Life cycle) of AS400 Applications from requirements, analysis, design, development, testing to Go-Live Phases and support activities
• IBMCertifiedSpecialist - eServer i5 iSeries RPG ILE Programmer
• Developed codes on RPG, SQLRPGLE, Synon2E, CLP, CLLE and DB2/400 for building user friendly applications
• EDI Standards and Transaction types - EDIFACT, ANSII 4010, 810 (Invoicing), 832 (Order Catalogs and Items), 850 (Orders), 855 (Acknowledgement), 856 (Shipment Notices and Commercial Invoices), 214 & 315 (Statuses)
• 4 years of experience in JDA MMS (4R4) system
• Hands on experience in data migration & modernization of Legacy to ERP systems (SAP CRM & Sterling OMS)
• Expertise of file transfer using multiple techniques between the iSeries and various platforms
• Strong collaboration skills with ability to collect business requirements and interface with the internal and external user community including various levels of management
• Proficient in analyzing and translating business requirements (BRD) to technical requirements and architecture
• Plenty of experience in conducting project reviews, involved in requirements break-up reviews, design reviews, code reviews, test plan reviews, test case reviews and Quality audits
• Involved in GAP Analysis and Enhancements of the existing codes to meet business process requirements
• Adequate experience as a Support Analyst handling critical issues, root cause analysis for the repeated incidents and provide permanent solutions through problem tickets, investigate batch job failure and fix data issues
• Experience in defining, capturing and reporting Project Metrics
• Supported test data management and test execution for Unit testing, Integration testing, System testing, Regression testing, and User Acceptance Testing (UAT)
• Black box Testing and Exposure to RQM, QC & HP ALM Testing Tools
• Good Knowledge on web environment and web/client-server based application architecture
• Experience with Microsoft office products, including MS-Visio and MS-Project
• Proven analytical and problem solving skills with across Geo Teams work experience

TECHNICAL SKILLS

Language: RPG/400, ILE RPG, Synon 2E, CL/400, CLLE, SQLRPGLE & Core Java

RDBMS: SQL/400, DB2/400

Change Management: Aldon & Turnover

Job Scheduler: ROBOT, UC4

Java Technologies: Servlet, JSP, RMI, JDBC, Jscript

Utilities: PDM, SDA, SEU, RLU, SQL/400, QUERY/400

Other Tools: LANSA, HAWKEYE, TOTAL, QC, RQM, X-Analysis, Cool 2E (Synon), EZView, Win

SCP: FTP control maintenance, Remedy & HP-ALM

Application Servers: Java Web Server, Web Sphere

Operating Systems: IBM OS/ 400, Windows & Unix

ERP’s Used: JDA - MMS 4R4, SAP CRM, Sterling OMS

PROFESSIONAL EXPERIENCE

Confidential, Issaquah, WA

Responsibilities:

• Managing Requirements, which involves the analysis of project requirements with a view to understanding the same and to identify the gray areas in the requirements
• Analyzing the current ‘OrderPower’ system and provide inputs to Sterling OMS business team & OMS DEV team
• Worked closely with legacy SME’s & project architect and provided inputs to design interfaces between Legacy, Sterling OMS & PKMS WMS systems
• Lead analysis sessions, gather requirements and create functional design document & data mapping documents for different interfaces
• Prepare & Review the Technical design documents, get it approved from client
• Experience deriving test scenarios based on the projects requirements (Functional and non-functional) and reviewing of the test cases.
• Coordinating and ensuring that the team has the required technical expertise & business knowledge to develop the required interfaces. This involves the identification of key technical areas related to the project and conducting training sessions to plug any gaps. Also responsible for providing technical assistance over the course of the project
• Coordinate with DBA team and get approval for newly created tables & log files
• Review & update the free format SQLRPGLE code to make sure all the Costco’s code standards are adhered
• Extensively involved in creation of Integration test plans that covers the definition of the scope of testing, Types of testing to be done based on the requirement, Testing strategy to be followed, Execution methodology, Metrics capturing and reporting needs
• Coordinating with Functional/business teams in getting the test plans and test cases reviewed
• Execute final end-to-end testing and make sure the end product & XML format output files are working as expected
• Well versed in analyzing and presenting the issues found in testing phases for the teams and management
• Preparation of traceability matrix for the project covering requirements traceability step by step through design and testing phases of the project
• Conversant in Documentation of Test results during the different testing phases (like Unit Testing / System Testing / Integration Testing and User Acceptance Testing
• Create forms in Turnover, get approval & promote the code from ADT to QAT environment
• Acting as a point of contact for environment maintenance and issue resolutions for Sterling OMS team, QA team, Middleware(MQ Series), PKMS WMS, Ecom and TDM team
• Ensure new member gets all the system access and take approvals from respective stake holders for user profile creation and other environment access
• Work with QA team and triage the issues, defects & fix the same
• Update, verify & validate project documents like AID’s and RUNBOOK

Confidential

Responsibilities:

• Work closely with Legacy SME’s, Business & Testing teams throughout the requirement, design, development, testing & implementation phases of SAP R1 CRM Loyalty system
• Analyzing the current Legacy system and provide inputs to SAP business & DEV team
• Lead analysis sessions, gather requirements and create functional design document & data mapping documents for different interfaces
• Design and Developed multiple interfaces using SQLRPGLE & IBM Parser that send and receive XML format data between AS400 and SAP R1 CRM system through Middleware (MQ series)
• Developed multiple AS400 Programs in free format RPGLE, embedded SQL (SQLRPGLE) to pull Legacy Data and build Master Data Management (MDM) Staging Files
• Worked with conversion team to convert the master data from legacy to SAP during system integration and go live
• Coordinating & ensuring that the team has the required technical expertise & business knowledge, this involves the identification of key technical areas related to the project and conducting training sessions to plug any gaps. Also responsible for providing technical assistance over the course of the project
• Coordinate with DBA team and get approval for newly created tables & log files
• Review & update the code to make sure all the Costco’s code standards are adhered
• Extensively involved in creation of test plans that covers the definition of the scope of testing, Types of testing to be done based on the requirement, Testing strategy to be followed, Execution methodology, Metrics capturing and reporting needs
• Create forms in Turnover, get approval & promote the code from ADT to QAT environment
• Coordinating with Functional/business teams in getting the test plans and test cases reviewed
• Point of contact for environment maintenance and issue resolutions for the AS400 related issues for R1A test QA team, MQ and TDM team
• Handling POS to iSeries transaction log processing issues
• Preparation of traceability matrix for the project covering requirements traceability step by step thro design and testing phases of the project
• Well versed in analyzing and presenting the issues found in testing phases for the teams and mgmt
• Coordinate with IT groups and external vendors and ensure effective application services to ensure reliability of all applications
• Involved in preparing KT plan & document for the end business users

Confidential, Memphis, TN

Application Maintenance & QA

Responsibilities:

• Primarily responsible for Gathering business requirements from the users and stakeholders by face to face questionnaire interviews, prioritize those requirements, and translate them into functional requirement document and detailed design document
• Lead analysis sessions, gather requirements and create functional design document for enhancements & customization
• Present and defend design with Business/Customer and signoff
• Thorough Experience as a Support Analyst handling critical issues and responsible for installing patch updates
• Monitor Issue log and Solve the incidents
• Provide initial problem determination, error recovery and notification whenever necessary
• Involved in the preparation of Root cause analysis for the repeated incidents and fix the same permanently
• Participated in Cab meeting with Business users and stakeholders to give explanation about the RCA findings and importance of the change to the system
• Engage with development team and help them to understand the RCA prepared and code changes required
• Monitor ROBOT Scheduled jobs and attend the failures
• Developed Detail Technical / Functional Design for small Cap projects (including NIM)
• Enhancements in the major modules of the project batch programs using ILE concepts
• Worked extensively on batch processing using ROBOT and IBM job scheduler to run the daily, weekly and monthly jobs. Good knowledge on ETL and optimization Techniques
• Have good understanding of the Organizational Metrics processes and implementation of the same in the project life cycles by defining and capturing them thro the QA / Test plans

Confidential, Westlake Village, CA

Maintenance, Enhancement, Development & Testing

Responsibilities:

• Impact Analysis / technical Design Documentation for the requirements
• Development and integration of required modules
• Writing Unit Test cases for the modules developed
• Test cases preparation for the modules developed by Peers
• Validation of test cases created by the teams
• Execution of Test cases on the code developed by Peers
• Enhancements of the existing code to implement the changes in the business requirements
• Final go-live support, documentation and technical support
• Coordinate with various teams and raise support ticket for all issues, analyze root cause and assist in efficient resolution of all production processes

Confidential

Maintenance, Enhancement, Development & Testing

Responsibilities:

• Worked as the senior developer at the client location right from the scratch developments & enhancements
• The main responsibilities include analyzing the requirements provided by the technical analyst (client), developing and delivering the code, creating test documents and implementing the changes.
• Worked on outbound interface programs to send the data via FTP and inbound interface programs to extract the data from flat files, XML & CSV format and update the production files
• Worked as one of the support analyst at the client location handling issues related to the Synon based domestic Freight Forwarding Application and testing data flow between external interfaces
• Develop Test Plans, Test cases, Traceability matrix and to setup the testing environment for the changes
• Providing version control migration for the required modules & on-call support to Operations and end-users
• Co-ordinate with different Team and execute System, Integration and Regression testing
• Data migration and validation Reconciliation
• Monitor Issue logs and Solving them, GAP Analysis and Modification/Enhancements of the existing codes to meet business process requirements
• Final go-live support, documentation and technical support