Supply Chain Human Resources
Resume:
Name: N Krishnan Mail: ***********@*****.*** Cell: 994*******
Role: Technical Specialist
Total Experience:23 years & Relevant 10 years
SUMMARY
Worked at W.S. Industries (India) Ltd from 1989 to 2007 as Developing System for Material management, IS Dept and Stores dept, coordinating with PPC (Production and Planning Control) by using Oracle, SAP and Sybase. SAP Modules
• SAP Financial Accounting (FI)
• SAP Financial Supply Chain Management (FSCM)
• SAP Controlling (CO)
• SAP Material Management (MM)
SAP Sales and Distribution (SD)
SAP Logistics Execution (LE)
SAP Production Planning (PP)
SAP Quality Management (QM)
SAP Supplier Relationship Management (SRM)
SAP Customer Relationship Management (CRM)
SAP Plant Maintenance (PM)
SAP Project System (PS)
SAP Human Resources (HR)
SAP Integration Solution (IT4)
For the above modules, I was coordinated with respective team members and developed lot of PGMS and automated tools for Clients requirements.’
After that, I joined HCL during 2007 .
AS400 Application Developer & Administration at HCL Technologies during 2007 to 2024
Disaster activity: At HCL Technologies during 2008 to 2024 for Cummins and GASS (Global AS400 Shared Project)
Migration: At HCL Technologies during 2010 to 2024 for Cummins and GASS (Global AS400 Shared Project)
Customs application: At HCL Technologies during 2010 to 2024 for Cummins and GASS (Global AS400 Shared Project)
Automation tester in AS400: At HCL Technologies during 2007 to 2024 for Cummins and GASS (Global AS400 Shared Project)
RPG/RPGLE, SQLRPGLE, CL, DB2/400, IFS, FTP, SFTP, QSH: At HCL Technologies during 2007 to 2024 for Cummins and GASS (Global AS400 Shared Project)
Aldon change management: At HCL Technologies during 2012 to 2024 for GASS Project
JOBQs, Batch debugging, replying MSGW: : At HCL Technologies during 2007 to 2024 for Cummins and GASS (Global AS400 Shared Project)
Experience in analyzing and preparing the application design based on the client's requirements.
Experience working on integration projects: At HCL Technologies during 2007 to 2024 for Cummins and GASS
(Global AS400 Shared Project)
Development experience in AS/400 environment with very strong API Programming: : At HCL Technologies during 2007 to 2024 for Cummins and GASS (Global AS400 Shared Project)
JSONs in RPGLE programs: At HCL Technologies during 2007 to 2024 for Cummins and GASS (Global AS400 Shared Project)
Experience in interfacing with other systems in the landscape: Yes, with Oracle, Database & Unix
Preparing functional requirements and technical design document: Yes, for creating Automation & menu screen development for L1 and L2 day to day operations at HCL from 2007 to 2024
Experience with XML programming: Yes, more than 7 years
Nice to have Warehousing, Retail domain experience: Yes, AS400 Infor XA, WHM etc during 2007 to 2020 at HCL
Nice to have JAVA knowledge: Yes, only at the time of worked with IFS and authority concepts
• BPCS (BUSINESS PLANNING & CONTROL SYSTEM0 - Experience with BPCS for Cummins & Landmann Project during 2007 to 2022
System Administration and Maintenance
Analysing and report System problems
Security Management
Incident reporting
Auditing and reporting
Streamlining processes
Analysing data
Resupply order management
Billing
Promotions and Deals
Financial reporting
Integration with other systems
Data Integrity
Modernizing BPCS functionality
Negotiating planning and managing ad-hoc releases
Expanding EDI capabilities
Technical support to Users
Resuming business processes after on unplanned incident Apart from this well experienced in the following topics
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 AppSense Citrix - User workspace manager, Application Control, Environment Manager, Install and Configuration
Skilled in IBM Infor SA, Mapics, Mimix, Movex
Working as Db2 & As400 Corporate Trainer RPG,RPGLE,CL,SQL etc 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.
I got lot oof outstanding certification from Clients and 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, Mainframe
.
Contact this candidate