Automation Tòol For As400 And SQL, Trainer, Software Development
Resume:
Name: N Krishnan
Role: Technical Specialist
Total Experience:23 years & Relevant 17 years
SUMMARY
AS400 Application Developer with 17 years of extensive experience.
Experience in analyzing and preparing the application design based on the client's requirements.
Skilled in using the design, I had developed the applications independently, performing unit testing, deploying the application into production, and monitoring the same for smooth transition.
I had developed my own automation tool for L1 and L2 activiites without command line.
Alert from AS400 Server for critical messages to operators for proactive work.
Extensive knowledge of SYNON programming
Knowledgeable in functional commands, loops, validation, and 5250 commands on iSeries.
Skilled in iSeries development, with the ability to code in CL command
Skilled in IBM ISAM, IBM MAXIMO
Skilled in SAP, particularly in Material Management and System dept.
Skilled in IBM Infor SA
Working as Db2 & As400 Corporate Trainer RPG,RPGLE,CLLE,Db2, QSH TECHNICALPROFICIENCIES
Experienced in CL, CLLE, RPG400, RPGLE, RPGILE Programming Language
Experienced in DB2, SQL, XML, EDI and Macro
Trouble shooting, debugging Technical Systems
Jira, Service Now, BMC Remedy (for Incident management, change management, report, macro)
Java, shell script (for IFS link purpose IAS400) PROFESSIONALEXPERIENCE
HCL Technologies as Technical Specialist
No 602/3,
138 Elcot Economic Zone
Shollinganallu
Medavakkam High Road
Shollinganallur
Chennai 600 119
Technology: AS400, Infor XA, Infor OS, Infor WHM,, Mapics, Feb 2007 - May 2024
Client: Cummins (USA,UK,Australia,Singapore,Japan,Korea,Newzeland and China) Exxon, BD, Landmann, Radial, CTC
Description Cteated PGM for automation
Training to co-employee for AS400, SQL and DB2
.
Roles and Responsibilities:
Worked as a part of both development and support team
Led the team in the absence of Senior Associates since i had been treated as a Secondary SLA owner role.
Mentored the team by providing technical inputs and imparting business knowledge to new team members and involved in support handover Knowledge Transition to facilitate transition.
Worked as part of Release Management team and involved in numerous release activities.
Maintained the ticket closure within Service Level Agreement for each category tickets to avoid its breach in order to maintain a good relationship with the Client.
Monitored the production load to prevent the system from rapid increase in ASP %.
Most of l1 and L2 activities by my own automation tool
Created a CL PGM for doer and checker activities for Backup and Restore
Created own automation tool for instead of NIMSOFT and Saipience tool.
For AS400 Server security, created menu screen for L1 nnd L2 actvities.
Automate CL PGM for SOX Audit and MIS report
Created macro for ticketing status from BMC Remedy and ServiceNow.
Npt allowing operators to mix any SLA at any level.
For Infor XA,(MAPICS) maintaining accounts package of Clients and sent report to them
Configuration for Infor OS, Infor XA, Infor WMS
.
For example, if raw materials are not received properly or parts are misplaced in a warehouse, the supply chain may be slowed or disrupted. WMSes are critical in ensuring that these processes work smoothly by tracking inventory and making sure that goods are stored and sorted properly, as well as shipped and tracked accurately. Email /messaging management system offers a simplified way to manage all incoming and outgoing messages to customers. Because it is fully integrated it offers features unavailable in any other system. o Consolidates all customer messages and emails into one work queue. It also ties those messages to the customer history available throughout the system for reference later during shipping, sales inquiries, etc. o ™ Also has a fully integrated email marketing campaign component, allowing you to use customer information to customize emails and target specific demographics. Improved Customer Service
o Because all messages are consolidated into a single work queue multiple staff members can work messages simultaneously to respond more quickly, while at the same time eliminating duplication of efforts. Messages remain in the queue until answered ensuring completion.
o All previous customer correspondence are threaded together minimizing research time o Eliminates the need to log into multiple sites or manage an email client o Information is available for review throughout so the need to forward information to other departments is minimized, i.e. shipping is required to review notes before processing can be completed o Responses are sent via email, through channel messaging and ebay messages automatically updating the response on each selling channel
Created own tool for alerts and MIS reports
o Send HTML or plain text emails
o Include customer name, company, etc.
o Select based on a variety of customer criteria
Enhancements of coding from RPGIII to RPGIV .all the legacy data are going to be converted into catalog format to make it more user-friendly to the customers.
RDI integrated eclipsed environment for generate the code.
RPGII III source are converted into RPGIV, ilewith meets the time frame more convenient to the clients.
All the green screen data are migrate into the web source which have a separated dashboard to make it more easy interaction with the customers.
Instant Report generation from RLU to web source.Enhancements is done by using presto applications which give a great quality product for the customers.
AS400 POWER system V7R1MO.
DB2/400: Extensive used of SQL query with stored procedures along with different files structures in both interactive as well as batch environments.
Extensive use of service program, binder language, procedures $& sub procedures with different calls prototype. With the Oracle Access Manager for AS/400, you don't need to code to a proprietary API. Instead, AS/400 applications can interface seamlessly to Oracle using ANSI standard SQL as well as Oracle extensions. PL/SQL is also supported, allowing you to call remote Oracle stored procedures from your AS/400 applications. AAIL basically has a maintenance project for their daily customers’ retail transactions.
• HLL used: RPG/400, CL/400. Daily reports were going to be handled like simple reports, complex report, Adhoc report for both Domestic and International passengers. Every day the records were going to be updated by means of DB2/400.
• Issuing the tickets as per clients' demand.
• Enhance the legacy source to modernization RPG 3 RPG 4.
• Designing the DDS for tranfeting the text data to its upgrade version.
• Transforming the green screen data into modernization by web interface using PHP applications. Maintaining huge customer master files through our Sub-file single page.loadall techniques.
• Problem-solving, testing the new codes, fixing up the bugs.
• Backup &recovery of entire data on weekly basis &report generated based on that.
• We using a dashboard to enables this application s more user friendly to the customer side (end-user).
• Databases: files are used for this project like PF, LF, JLF, MLF, Query/400.
• Interactive & Batch query by using SQL.
• For Batch OPNQRY.Runqry, wrkqry .DFU for entering any data.
• RLU is mainly used for report generation. Enhancements of Report.
• Daily report, weekly report monthly report as per client’s requirements. EDUCATIONANDCREDENTIALS
Bachelor of Computer Science
Unfortunately, I lost all my certification while Chennao SUNAMI during 2015 at Chennai I got lot oof outstanding certification from Clients and HCL Other Credentials:
ORACLE 9I/10g - NIIT
MAPICS, MIMIX, MOVEX
AS/400 I series DB2/400 - IBM MITMI, SQL
DB2 UDB Ver9.0 WINDOWS - IBMACE
SYBASE, SAP, SYNON, UC4, DATABASE, UNIX
Contact this candidate