Rpg Iseries

VEDESWARY VEDARETHINAM – SENIOR TECHNICAL CONSULTANT

PROFESSIONAL SUMMARY:

Over 16+ years of AS/400 experience in Production Support, architecting, implementing enterprise applications, portals and system integration solutions.

Played key roles in Maintenance, Production Support, Troubleshooting the application and resolving issues.

Prepared capacity planning, estimations, technical solutions, POC systems and product demos using industry standard tools and techniques in Agile/SCRUM and Waterfalls environments.

Strong technical and functional capabilities in supporting multi-location enterprise software products for various markets such as Retail (Supply Chain and Warehouse Management system), Healthcare and Manufacturing industries.

Design, develop, and re-engineer complex iSeries application components with continuous focus on enhancing and transforming the applications.

Excellent programming abilities using AS-400 Technologies such as RPG, RPG ILE, RPG Free.

Strong database and embedded SQL programming experience in RDBMS databases like DB2, SQL Server, MS-Access.

Replaced manual/recurring tasks with automated scripts and jobs using Eyehu Eyeshare automation tools.

Designed and developed normalized databases, stored procedures, and triggers for high availability systems.

Extensive experience in troubleshooting, peer review, configuration management, unit testing, system integration and user acceptance testing, writing test cases and SEI-CMM level 5/ CMM-I quality processes.

Hands on in developing complex operational & management reports, dashboards using Crystal Reports.

Having strong knowledge in ITSM process and workflow.

Ability to develop detailed system landscapes and technical solutions including, data accessibility and system monitoring.

Ability to support and mentor technical teams, developers, peers and provide inputs based on past experiences/expertise.

Engaged in 24/7 Production support of globally deployed solutions with on-site and offshore teams to help resolve business issues quickly and efficiently.

Closely worked with both technical and non-technical teams including business leads, developers, business users, product owners, business analysts and database administrators.

TECHNICAL SKILLS:

AS/400: RPG IV/ILE, DDS, RPG Free Format, CL/400, CLLE, Query 400, SQLRPGLE, COBOL 400/ILE

Databases: DB2/400, SQL Server, MS-Access, Oracle

Web Technologies: Java, JavaScript, XML, SQL, OData, API and Restful Web Services

Tools: ALDON, ROBOT, Pathfinder, IBM Exeter Legacy system, IBM Island Pacific Legacy system, SDA, SEU, PDM, RLU, DFU

Other Utilities: MQ Series, IBM Message broker(ESB), FTP/SFTP, Turnover, Gentran, Crystal Reports, SQL Viewpoint, Azure DevOps, XML, Soap-UI, ORM, MS-Visio, MS-Project, MS-Office, JIRA

Operating System: OS/400, Windows Server, Linux

EMPLOYMENT HISTORY:

Aug 2020 – Till Date: As “Technology Lead” with Infosys Inc

Oct 2006–Feb 2020: As “Service Delivery Lead” with Cognizant Technology Solutions

April 2004–Oct 2006: As “Systems Analyst” with Hyundai Motor India Ltd

EXPERIENCE:

Technology Lead/Support 08/2020 to Till Date

Client: Sysco Corporation - Houston, TX

Project: Scope of the project includes Production support, Enhancement, Bug Fixes and Projects for various business functional areas in Agile Methodology.

(24*7) L2/L3 AS/400 Production Support

Handling tickets, Critical root causes Analysis, Status meetings, SLA ownership, Data fixes, Bug fixing and Unit testing of this project.

Part of Sprint planning, refinement, Review and Retro.

Identify and prioritize business requirements and supporting the business.

Highlight gaps in existing functionality and provide viable solutions.

Enhancement and bug fixing as per customer requirements.

Provide technical support to resolve issues in the production and staging environments. Troubleshoot integration related issues between multiple systems.

Worked on OS Upgrade and Testing activities.

Developed scripts to clean up master data and archival of historical transactions.

Identify long running jobs/queries and provide solutions to optimize the performance.

Knowledge in ServiceNow ITSM tool for incident, Problem, Service Request, Change and SLA tracking.

Assist in design and technical specification of custom software components, enhancements/customizations.

Collaboration with internal and external teams including various levels of management teams and govern all the client calls from offshore by which have built a strong relation with client.

Interacting with various Business teams and Application teams for requirement gathering.

Provide guidance for business decisions from a technical perspective on issues such as: performance, scalability and reliability.

Worked on Decommission and Modernization Projects.

Develop comprehensive requirement specifications for the estimation of cost, time and resources to successfully deploy solutions.

Environment: RPGILE, CL/400, DB2/400, MDCMS Change Management, ROBOT, ODBC, MQ Series, FTP, SFTP, SQL, AS/400 Legacy System

Service Delivery Lead/Support 10/2015 to 02/2020

Client: Academy Sports & Outdoors - Houston, TX

Project: Scope of the project includes Production support and enhancement for various business functional areas of retail applications (Supply Chain and Warehouse Management system). The major subsystems are Firearm acquisition and disposition, Account Receivables, Receiving and Put away, Stock order Management, Storage Management, Warehouse control Maintenance, Shipment Planning, Picking & RF work Management, Physical Inventory, Sorting, Shipping,Productivity Tracking, Ecommerce application Interface and Oracle Retail management system Interface.

(24*7) L2/L3 AS/400 Production Support

Handling tickets, Critical root causes Analysis, Status meetings, SLA ownership, Data fixes, Bug fixing and Unit testing of this project.

Identify and prioritize business requirements and supporting the business.

Provide technical support to resolve issues in the production and staging environments. Troubleshoot integration related issues in IBM Middleware.

Automate daily system monitoring activities, Core Checks and Manual Reports.

Upgraded systems from previous versions pSeries to iSeries

Develop scripts to clean up master data and archival of historical transactions.

Identify long running jobs/queries and provide solutions to optimize the performance.

Knowledge in ServiceNow ITSM tool for incident tracking.

Assist in design and technical specification of custom software components, enhancements/customizations.

Collaboration with internal and external teams including various levels of management teams and govern all the client calls from offshore by which have built a strong relation with client.

Highlight gaps in existing functionality and provide viable solutions.

Enhancement and bug fixing as per customer requirements.

Preparing Change Impact Analysis documentation, Analysis, Design and Development.

Interacting with various Business teams and Application teams for requirement gathering.

Engage users and third party vendors to evaluate software applications and resolve problems in non-standard processing.

Provide guidance for business decisions from a technical perspective on issues such as: performance, scalability and reliability.

Develop programs in IBM RPG and embedded SQL and deploy system solution(s) to production environments.

Develop comprehensive requirement specifications for the estimation of cost, time and resources to successfully deploy solutions.

Environment: RPGILE, CL/400, COBOL/400, DB2/400, Aldon, ROBOT, ViewPoint, ODBC, MQ Series, FTP, IBM Middleware, ETL, ORMS, SQL, AS/400 Legacy System

Technical Lead - Onsite Support 08/2012 to 10/2015

Client: Academy Sports & Outdoors – Houston TX

Project: Scope of the project includes Production support and enhancement for various business functional areas of retail applications (Supply Chain and Warehouse Management system). The major subsystems are Supplier and Vendor management, Item Management, Inventory Management, Order Management, Purchase planning, Firearm acquisition and disposition and Point of Sales, Kronos iSeries, Receiving, Stock order Management, Cycle Count, Warehouse Inventory Management, Shipment Planning, Picking & RF Management, Sorting, Shipping and Ecommerce application Interface.

Handling tickets, project estimation, critical root cause resolutions, status meetings, bug fixing and system testing

Handle multiple projects, define project scope and objectives, assist with project schedules, and work with cross functional project team.

Adhere to project deadlines, while staying within the approved budgeted parameters

Develop new applications, upgrade existing systems and provide 24/7 production support.

Work with cross functional teams to integrate with web and windows-based applications

Work directly with business leads to gather requirements, provide technical solutions, UI design, testing and provide technical solutions to business require.

Knowledge in Landesk ITSM tool for incident tracking.

Fine tuning their database queries / application program to extract data and load to Data ware house

Preparing Change Impact Analysis documentation, Analysis, Design and Development.

Enhancement & Bug fixing as per customer requirements.

Take responsibilities to Resource management, Interaction with clients, handle issues and escalations.

Participate in business meetings to gather requirements.

Responsible for quality, metrics and SLA process.

Support to Client, Deployment Setup, and Testing & UAT of the application.

Provide guidance for business decisions from a technical perspective on issues such as: performance, scalability, reliability, and security.

Automate import and export of master and transaction data and posting general entries in real-time.

Coordinate with business users to thoroughly test the new system to make sure the existing and new features are working properly.

Develop scripts to clean up master data and archival of historical transactions.

Environment: RPGILE, CL/400, COBOL/400, DB2/400, Aldon, ROBOT, Viewpoint, ODBC, MQ Series, FTP, IBM Middleware, ETL, ORMS, AS/400 Legacy system.

Technical Project Lead - Onsite 08/2009 to 07/2012

Clients: United Health Care-Vision – Columbia, MD

Projects: Scope of the project includes development, Maintenance and production support for various business functional areas of vision. As a part of this project I was involved in various automation projects and as the release manager for the vision projects.

Understanding business requirements and provide suggestions to client on the functional requirements that makes their business process highly productive with documentations.

Review Technical design specifications sent by offshore to make sure Design meets specific functional requirements.

Provide accurate estimations on the projects based on functional requirement using complexity point estimation. We use Cognizant proprietary tool named to E-tracker to achieve accurate Order of Magnitude estimations.

Prepare System Integration Test cases and execute the test cases. Support QA testing UAT testing. And use Cognizant proprietary tool named to E-tracker to log any defects on design.

Review implementation notice received from offshore and support in the deploy activities. And also perform post deployment monitoring until system stabilizes in production.

Provide production support on the business areas like case install, Eligibility, claims processing, and accounting.

As the Release Coordinator, my roles include Turnover Administration, Configuration, Access control, Upgrading, Training (new users both IT and business), Reporting.

Develop and run migration scripts to load data from source to target systems

Map source to target schema and compare the reference data and master data count before and after migration.

Perform code upgrades, merge and resolve conflicts. Create and maintain functional requirements and technical specification documentation. Conduct code reviews and works closely with the frontend to identify and resolve performance issues

Quickly perform editing and customizing to fit needs of various business units. Build custom reports and dashboards specific to job functions and look for way to make sure that they are used correctly and efficiently.

Environment: RPGILE, CL/400, DB2/400, Turnover, Crystal Reports, ODBC, Gentran, FTP, Soup-UI

Senior Systems Support Analyst 10/2006 to 07/2009

Client: DFS Group Limited

Project: Develop/Support Merchandising/Supply Chain system

(24 * 7) Production Support

Handling tickets, Critical root causes, Status meetings, SLA ownership and data fixes. Bug fixing, Unit testing of this project.

Involved in Legacy to SAP migration project and prepared AS-IS documents for DMS.

Upgraded systems from previous versions V5R4 to V6R.

Develop reusable code, unit test and work with the testing team towards resolving the bugs.

Identify the risks in the projects and keep the stakeholders informed with details in requirement risks, environmental risks, data risks, design risk etc.

Integrated multiple AS400 boxes to share the real-time via MQ Series

Provided support for data conversion, installation of the applications.

Performed system design and architecture diagrams with appropriate tools such as Visio also setup application mockups, reverse engineering and forward engineering concepts to visualize the entire system before moving to construction phase.

Environment: DB2/400, MQ Series, RPG/400, RPGLE, CL/400, CLLE, ALDON, SAP

System Analyst 04/2004 to 10/2006

Client: Hyundai Motor India Ltd

Project: Develop/Support Supply Chain, Payroll & Production system

Played the role of developer for the major AS/400 projects to carry our major developments and enhancements in complex AS/400 system

Handled user queries, Incident management and Problem Management.

Assisted other IT staff members with problem resolution and installations, prepared and reviewed training guides and systems change notices, updates, and training programs for systems operations per established standards and requirements.

Developed interfaces between applications, both in-house developed and vendor supplied.

Interact with business to gather requirements and to convert them into AS/400 technical solutions.

Requirements gathering, Design, Analysis, Development, and Testing, implementation and Application maintenance and database management functions.

Involved in design aspects like preparation of Program Specification documents, EBRs, Unit Test checklist, Test procedure, Test Logs and Unit Test cases.

Code Optimization, Review, Walk-through and Debugging and Post production Maintenance/Support

Environment: AS400, OS/400, RPGLE, CL/400,DB2400, MQ Series, SQL, ISeries and MS Office suite

EDUCATION:

Bachelor of Engineering in Computer Science from Madras University

CERTIFICATIONS:

Certified in AS/400 technologies

Contact this candidate