Ananth Arivazhagan

Email: adcvmv@r.postjobfree.com Mobile: +1-614-***-****

LinkedIn: https://www.linkedin.com/in/ananth-arivazhagan/

Professional Summary:

·8+ years of progressive and dynamic experience in Software Development.

·Experienced in RPG and AS/400 (i-Series O/S), code development using RPGIII, RPGIV, RPG/ILE and RPG/Free, DB2/400, CL, CLLE, SQL, RLU, Embedded SQL, Open Query ILE,VRPG and LANSA.

·Knowledge on creating functions, stored procedures, procedural coding, web services, FTP process, LANSA Ramping, aXes LANSA framework, ASNA, SEQUEL reports and tools like SEU, SDA, PDM, DBU, DFU, RLU, QUERY/400, SEQUEL/400

·Rational Developer along with knowledge of modern database design, understanding of normalized tables, constraints, multithreading, distributed system architectures and concepts of views.

·Strong technical expertise along with vision for how technology can be leveraged to accomplish business mission of the organization.

·An accomplished software engineer specializing in object-oriented Design and analysis with extensive experience in the full cycle of the software design process including requirements definition, proof of concept, design and maintenance.

·Having work experience in all phases of the Software Development Life Cycle (SDLC) from analysis through maintenance, AGILE development methodology, system design and how it supports Company business, in addition to a strong understanding of core business processes such as Warehouse Management Systems (WMS)NUTECH&JBA enterprise resource planning application.

·Possess good structured programming technique, Debugging techniques, Unit Testing, Integration Testing and Testing of application programs.

·Able to work in enhancement, maintenance and production support projects.

·I can work and have worked in researching, answering technical questions and debugging skills and Knowledge of IBM System I operating system and programming languages.

Experience in Tools

Programming Languages - RPG/400, ILE/400, VRPG, SQL/400, CL/400 andCLLE/400.

Tools - SEU, SDA, DBU, DFU, RLU, QUERY/400, LANSA, ASNA and SEQUEL/400.

Databases - DB2/400.

Operating System - OS/400, Windows 10 & Linux.

Embedded tools - JBA(ERP), NUTECH(ERP), ACOM(Embedded Software) &

HAWKEYE(Embedded Software)

Others - C,C++,MySQL, JAVA, C#, Oracle, HTML, PHP, MS Office 365 applications,

Adobe animation & scripting tools, COBOL/400 &aXes.net Framework.

Professional Experience:

N. Wasserstrom & Sons, INC. Columbus, Ohio November 2014 – On Going

Programmer Analyst

Responsibilities:

Developing, testing, maintaining, modifying and implementing new or existing programs and for supporting JBA ERP software application systems on IBM iSeries environment.

Quality and Analysis for the pre-UAT projects.

Performed Systems Analysis on projects assigned by the Project Manager.

Assigned projects utilized RPG III / IV / ILE / 400 / FREE / embedded SQL, CL / CLLE, Open Query, SEU, DFU, SDA, PDM, DDS, RLU, DBU, NUTECH, SEQUEL, HAWKEYE, ACOM, LANSA, VRPG, and AS400 system tools.

Project: Ariba – Automation

SAP Ariba offers an end-to-end automated system that removes complexity and allows buyers and suppliers to manage Orders, Invoices, Status & Tracking. Orders from buyers (Kroger, Target) received and updated through bi-directional synchronization between JBA ERP & SAP Ariba. Orders and Quotes creation in DB2/400 will be automated once the files are placed in FTP location, after that each customer order status will be updated simultaneously between JBA and SAP Ariba.

Responsibilities:

Developed a RPGLE program to process order/quote/job creations along with email attachment notifications.

Created a stored procedure to interface with front-end JAVA GUI.

Implemented dynamic description setup to use order/quote/job creation process.

Participated in all phases of the software development life cycle including design, development, integration, testing and implementation.

Tools: SQLRPGLE, CLLE, SEQUEL, MODULES, SERVEICE PROGRAMS &Embedded SQL.

Project: LANSA IDE Migration

Visual LANSA’s low-code development platform enables companies to digitally transform their business and increase IT efficiency while reducing risk and technical debt—enabling RAMP’s modernization process is nonintrusive, is easy to deploy, and modernize the existing 5250 applications.

Responsibilities:

Create second version of current production software of LANSA 12 on IBM iSeries.

Move the LANSA 12 IDE software to new windows machine

Export and import all the objects, frameworks & and newlook designs

Upgrade LANSA 12 to LANSA 14 on both iSeries & windows

Deploy the application package and push the application update to all the client machines.

Tools: LANSA 12, LANSA 13, LANSA 14, newlook& SQL Database.

Project: UltiPro-Automation

Ulti-Pro is a cloud based human capital management solution designed to help organizations manage payroll. Posting general ledger to employer's wages, supplier payments, commissions and other expenses will be automated by using GUI application.

Responsibilities:

Created GUI application to automate GL posting.

Created processes to upload financial GL posting from server and posted uploaded data to DB2/400 general ledger.

Set up the user administration and security on system application access.

Tools: LANSA, ASNA Visual RPG, C#, .NET Framework& RPGLE

Project: Estimation & Drawing Request

Manufacturing new products is based on requisition which need to be estimated by estimation team by cost, time, labour hours & stock and then approval of requisition, then only products will be manufactured. Estimation team can update all the product details any time of active product life by through this project using quick base.

Responsibilities:

Developed programs to maintain parts & sub-parts and its supplier pricing profile.

Created DB2/400 files to maintain parts, components, labour hours, drawing information, construction information, refrigeration, electrical & engineering.

Implemented dynamic description profile setup to select components and its pricing percentages along with user authority.

Created a SEQEUELscript and viewpoints to get the estimation & drawing requests.

Tools: RPGLE, SQLRPGLE, CLLE, SEQUEL Script, SEQUEL Viewpoint.

Project: Sneeze Guard

Sneeze guard item to be considered one of the components under the main part number as well it should work as separate part number. Even though sneeze guard item as a component, it should contain its own components too.

Responsibilities:

Modified a cost splitting program to include sneeze guard items as components.

Implemented dynamic components changing concept on description setup.

Created generic programs to created parts and its pricing split components with sneeze guard items.

Tools: RPGLE, Modules, Procedures, Service programs & DB2.

Srinsoft Technologies Pvt. Ltd. Chennai, India.

Jr. Programmer Analyst – Information Technology November 2011 – November 2014

Client – N.Wasserstrom& Sons, Inc.

Responsibilities:

Design and programming with:

CLP, CLLE, DDS, RPGIII, RPGILE, RPG Free, RLU, SQLRPGLE & QUERY/400.

DB2, SQL, and MS SQL Server.

SEQUEL& NUTECH

Involved in project change management systems like AGILE & Waterfall project lifecycle methodologies.

Productionsupport–Fixing the live issues, releasing the locks, Analyzing the issues and prepare technical document to development team, generating quick and simple reports, and reverting new production programs which are moved with issues.

QuA -work with the other developers and business team members to develop test scenarios and build out test cases to provide a quality deliverable, both unit and system testing levels.

Productionrollout- releasing the projects to production environment with proper backup of previous versions,object record lock checkups, enabling object accessing authorities to the end-users, source code comparing and combining.

Trainer – training the business flow, JBA ERP functions, NUTECH warehouse management process and AS/400 programming(DB2, SQL, RPG, ILE, RLU, Modules, Store procedures & SEQUEL reports) to the trainees.

Project: Pack Slip Merging (Shipping Ticker)

Nutech (Warehouse management system) provides essential functionality without the huge price tag and ongoing maintenance demands of bulkier WMS with integrating to System21 and Aurora ensures that successful solution and gains the benefits of barcode data collection. From ViewpointWarehouse printing a merged multiple pack slips for a single order/quote/item will save wastage of papers and environment.

Responsibilities:

Modified the program to merge existing pack slips and preventing to create new pack slips for ready to be shipped products.

Performed system analysis on merging pack slips and modified change required programs.

Modified barcode printing programs appropriate to the merged pack slips

Tools: RPG III / IV / FREE, Service programs, modules, procedures & sub-systems.

Projects: Quick Base

Quick Base to easily manage assets and information, automate manual processes, improve reporting, and connect solid systems. Implementing the same concept of Quick Based in JBA ERPenvironment by using RPG & DB2, only for maintaining engineering request and customer information.

Responsibilities:

Developed RPGILE program to maintain customer and projects for engineeringrequests.

Implemented multi-subfile overlay concept to access data in row wise within single screen.

Created database DB2/400 physical and logical files to maintain customer, projects & requests.

Tools: RPGLE, FREE, Modules, Service programs & CLLE.

Projects: One Company

Implementing new company profile which should merge 4 company profiles. All pervious data history should be merged in new company and further all user should access same application menus as like previous in new company as well.

Responsibilities:

Performed system analysis on one company implementing impacts and prepared reports to utilize company standards & naming conversions.

New company profile havebeen setup in JBA ERP (DB2/400) along with existing companies stockrooms, lot locations, account receivable (Customers), account payable (Vendors), general ledger accounts, journals, calendar, reports, parts, address profiles, group codes, description setups & email notification setup.

Merged user authority hierarchy and email notifications setups and part pricing supplier profiles.

Tools: RPG, RPGLE, CL, CLLE, RLU, Hawkeye, SEQUEL & WRKQRY.

Project: Auto-Quotes

Auto quotes application will create quotations by uploading a data sheet from customer & customer portals along with futures of data manipulating, quote splitting & status notifications. Before creating quotations, data should be validated with suspension (Credit limit hold, margin percentage, item split hold, customer account hold, outdate item cost & item not priced) check.

Responsibilities:

Developed a program to validate suspensions for creating quotations.

Created a SEQUEL report to send order suspension email attachment notification.

Tools: RPG III, IV, FREE, VRPG& SEQUEL.

Project: Cost split

Splitting the main part number cost by using manufacturing components and its percentages. Components are to be priced by estimation team how much and kind of raw materials are going to be used for manufacturing an item. Components and the usage percentages will be varied based on the product group major and drawing request.

Responsibilities:

Developed a program to split the cost based on components with its effective and expiry date.

Created a menu to approve and reject for cost changes with HTML email attachment notification.

Created a DB2/400 physical and logical files, flat file and stream file directory to maintain cost split.

Tools: RPG III/ IV / FREE, CLLE, HTML & WRKLNK.

Project: Order Ticker

Order Ticker provides summarized view of created order and jobs for credit analyst, purchase offers & sales department. They can perform rolling quote to job, releasing suspensions, creating purchase orders, job/order acknowledgementsprinting & emailing, staging code change request & pro-forma invoice emailing.

Responsibilities:

Coded to amend the existing jobs and orders.

Created program to emailing & printing.

Tools: RPG III, CL, Modules, procedures & service programs.

Academic Profile

Particulars

Stream

Year of completion

Aggregate

MCA

Anna University Coimbatore

2008-2011

82.00%

BCA

Madurai Kamaraj University

April - 2008

67.94 %

H.S.C

State Board

March -2005

77.91%

S.S.L.C

State Board

March –2003

74.80%

Achievements

·Received Merit Certificate for attending “PATROL LEADER’S TRAINING COURSE” in NCC.

·Captain of College NCC.

·Organized the Three tracking camps at 2007 and 2008.

·Received Merit Certificates (7) in NCC national level.

·Presented Science project (Planetarium) in KSR College and won first prize.

·Got team appreciation to moved production bug free projects.

·Got appreciation for perfect analysis on financial account projects.

Contact this candidate