Rpg Analyst

DEBASHIS BHATTACHARYA

**** ******* *****

Indianapolis, IN 46228

317-***-****(Home)

765-***-****(Cell)

*********@*******.***

OBJECTIVE: To seek a challenging and professional position with an organization that has potential growth and a great working environment with great IT staff and also potential departmental growth,

EXPERIENCE:

Lear Corporation; Southfield, Michigan

3/10/21 – Present(Contract)

Senior Software Developer

•Developed screens and programs in Free Format RPGLE for on-site users and other locations thru tickets system of projects as well as users off site using BPCS 4.3

•Wrote programs and screens for processes related to Warehouse Management Systems

•Wrote programs/screens for RF guns used in WMS processing within BPCS 4.3

•Modified programs for WMS processes including Labels created via TL Ashford

•Setup of EDI trading partners using Trusted Link Software, doing mappings and writing programs to edit the EDI data into AS/400

•Modified programs written in RPGIV and free and embedded SQL for enhancements to the system.

•Wrote documentation via Visio for WMS processes that was lacking in the organization.

•Wrote Program flows via Visio to outline menu flows which was not existing in organization.

•Created new labels thru TLAshford with printing of labels and software glitches and errors.

OIA Global Logistics; Hebron, KY

10/19/2020 – 02/26/21(Contract)

Senior Software Developer

•Developed screens and programs in Free Format RPGLE for on-site users and Bark Box users off site.

•Troubleshooting as well as installed mappings for several terminals in the office and plant for FEDEX shipper and ENDICIA software and also UPS WORLDSHIP software for daily uses and made sure software was working properly. Installed mappings for the Desktop Shipper software as well.

•Modified programs written in RPGIII code for enhancements to the system.

•Wrote documentation via Visio for WMS processes that was lacking in the organization.

•Wrote Program flows via Visio to outline menu flows which was no existing in organization.

•Helped users daily with printing of labels and software glitches and errors.

•Wrote programs/screens for RF guns used in WMS processing.

Claires/Icing, Inc.;Hoffman Estates, IL 01/2018 - 06/29/20

Senior Software Developer

•Retail Business with internal home grown system.

•Modifying Programs for PTL(Pick - To - Light) for the DC(Distribution Center) in WMS infrastructure. Daily WMS interaction with users fixining any issues or new development

•Wrote Applications for WMS infrastructure in RPG Free format using SQL

•Creating new Labels for shipping and modifying existing labels by modifying RPG III programs as well as maintaining RPGLE and writing RPG Free on a constant basis for new projects.

•Fixed Lane Issue in warehouse processing by providing logic solution and fixing the program to properly doing the calculation which was currently incorrect.

•Backup for Payroll and learning the current Delphi payroll processing. Ultimately going to be writing C# programs to produce reports.

•Backup for Polling of the i-series in Hoffman estates and Itasca

•Backup for current director of development for the I-series.

•Writing enhancements for current applications. Ex: screens, free format rpgle programs

•Writing Wage Guide Lines Application from scratch in C# for Payroll Department to reduce many hours of manual entry

•Using Change Management daily using TURNOVER to move programs from test environments to production environments.

•Writing ECOM applications for the finance and payroll departments using Free format RPGLE and also multiple subfile concepts for the DC warehouse.

Delta Dental 03/2016 – 12/2017

Senior Software Developer

•Wrote EDI Application Automation Process of claims for numerous groups to replace current manual download of claims. Process currently being used today in LIVE production.

•Devloped whole application process via flowcharts and written documentation.

•Most programs currently written in RPG III.

•Retail Claims Business – Most programs are addressed to various letters. For example, termination letters, overdue payment letters, ACA Initiation letters, all letters use PAGE SEGMENT method template

•Home Grown Software Claims Menu Driven Package.

•Modifications to programs which include PAGE SEGMENT letters, also modifications of screens for quick reports or creation of new letters.

•Writing a “TRAFFIC COP” Automation Process for the claims data (ANSI X12) 834 for everyday uploads. This process includes the Parsing Program, which handles all the data and parses the data into 4 major files and then compares the data parsed with the current data in the prod. Files and prints out any differences and ends with error reports at the tail end for Claims adjustments.

Celadon Manufacturing 03/2015 – 02/2016

Senior System Analyst

•Modifications to programs that are existing tickets submitted by daily user problems or issues.

•Writing Programs to Modifying programs to meet user needs

•Home Grown ERP Package for Celadon

•Training for XML coding techniques to help the short staffed Web Development area

The Guitar Center, Brownsburg, Indiana 10/2014 – 03/2015

System Analyst III (Contract – to Hire)

•Modifications to existing Programs in RPG III or ILE or Writing new Programs in Free Format in PKMS.

•Creating new or modifying existing Crystal Reports

•Daily Troubleshooting of Daily XB Record Warning Messages coming thru JDA interfaces

•Monitoring of PKMS Warehouse Management System and Yard Management Systems.

Von Duprin/Allegion., Indianapolis, Indiana 09/2013 – 08/2014

Senior Programmer/Analyst (Contract)

•Modifications of RPG, CL, programs in the KBM ERP System

•Maintaining EDI programs and modifying existing programs for transmission of ANSI X12 documents

•Daily troubleshooting maintenance of Vendor problems at their existing site over phone.

•Providing Documentation for all system enhancements and new developments within Sarbanes Oxley standards

•Was part of Peregrine Project to implement Fast Track Falcon Closer Process which included implementation of FTP Programs that changed the locations of where orders will go to from LCN to Schlage (Oracle 11i)

•Oracle 11i Falcon Interface Support – Wrote and implemented Pre-Validation and Post-Validation Processes

•Resolve Help Desk Tickets – User Requests for program modifications, new development

Horwitz & Associates, Indianapolis, Indiana 04/2013-8/2013

Senior Programmer/Analyst(Contract)

•Modifications of RPG, CL, Screen programs in various Vendor type environments

•Modifications of programs that involve HTML source and Web Development

•Maintaining EDI programs and modifying existing programs for transmission of ANSI X12 documents

•Daily troubleshooting maintenance of Vendor problems at their existing site over phone.

One Solutions Logistics, Greensburg, Indiana 05/2012 – 03/2013

Senior Programmer/Analyst

•Manhattan & Associates : WMS (Warehouse Management System) & DMS (Data Management System)

•Designing and writing User Requests reports, using ILE RPG, Embedded SQL, and CL driven programs.

•Involvement in the Modifications of all programs in the I-series.

•Involvement in the Printing of all Warehouse Labels. Designed in-house Labels Menu for all associates to be able to print specific labels.

•Designed and programmed Shipping Bar Code Labels and Shipping Quick Receive Labels, Finished Goods Shelf Labels, Shipping Master Labels.

•Implemented and Maintained EDI Package to improve company’s process time and profitability margin. Harbinger Package.

•Designing and writing User Requests reports, using SQL and SEU, DFU, database DDS, screen DDS, and printing support.

•Modifying WMS and DMS using ILE RPG, Embedded SQL, and CL driven programs.

•Work with internal team of developers IT team, and vendors.

•Designed and Developed and tested code on Daily Basis. Troubleshooting of applications.

Aurora Parts & Accessories, Lebanon, Indiana 01/2012 – 03/2012

Senior Systems/Analyst (Contract)

•Designing and writing User Requests reports, using ILE RPG, Embedded SQL, and CL driven programs.

•Involvement in the Modifications of all programs in the I-series. Writing Java applications for the “WOW” (Windows Operations Wizard) Intranet.

•Maintain Daily Helpdesk issues related to MAPICS XA ERP.

AmeriWood Industries, Dowagiac, Michigan 07/2011 – 10/2011

Senior EDI Programmer/Analyst (Contract)

•Fixing current EDI on EC (Electronic Commerce) Module of MAPICS XA Release 9.0 Work Orders, which involves setting up Customer Trading Partner Profiles, fixing mapping documents in Trusted Link, maintenance of Trusted Link Software, setup Trading Partner Profiles, documents in Trusted Link.

•Involvement in the Modifications of all programs in MAPICS XA for purchase of 2 newly acquired companies. Responsible for the conversion of all the new data of the companies to migrate into MAPICS XA.

•Maintain Daily Helpdesk issues related to MAPICS XA ERP.

Stant Manufacturing, Connersville, Indiana 03/2010 - 06/2011

Senior Programmer/Analyst

•Modifying and Maintaining RPG, ILE RPG, Free Format, SQLRPG programs in MAPICS XA ERP Manufacturing Package.

•Involvement in the Modifications of all programs in MAPICS XA for purchase of 2 newly acquired companies. Responsible for the conversion of all the new data of the companies to migrate into MAPICS XA.

Great Dane Limited Partnership Corporation, Chicago, IL 11/2006 – 11/2009

Senior Programmer/Analyst

•Wrote new modules for Production Control System in ILE RPG on JDEdwards.

•Involvement in Consolidation of both JDEdwards AS/400 Systems between Chicago Office and office in Savannah, Georgia. Responsible for writing conversion programs between both systems and integrate into one system.

•Maintain EDI Maintenance between customers. Upgrade EDI Software on the AS/400, and installed the mapping for all trading partners. Experience with Harbinger, Gentran.

•Responsible for rewriting Trailer Tracking System on the AS/400 based upon one system.

Packaging Dynamics Corporation, Chicago, IL 3/2005 - 09/2006

Senior Programmer/Analyst

•Write new reports for Vanilla Production System in ILE RPG

•Involvement in PaperCon Conversion for Atlanta, Dallas, Los Angeles Plants to PRMS, Writing PRMS reports for all plants after conversion to PRMS, helped write conversion programs to import data from Bohn system to PRMS.

•Maintain Formtastic Software and output queues for various users. Modify Formtastic user authority, security, addition of users.

•Modify Programs in RPG, ILE RPG in PRMS for invoicing, pack list, pick list, Sales History

•Maintain Peregrine EDI Package, including import and export of data. Documents supported: 820,824, 830, 856, 862,997

ATF, Inc., Lincolnwood, IL 2/2004 - 11/2004

Systems Analyst (Contract)

•Daily Maintenance, Monitoring, and Modifications on Trusted Link for Windows (TLW) EDI Creating, Modifying, and updating existing trading partner profiles, and new trading partners. Creating, Modifying, and updating of trading partner profiles on Canadian Manufacturing ERP System, creating, modifying, and updating trading partner overlay mappings, downloading newer versions of overlay mappings and implementing on Trusted Link Software and CMS.

•Maintenance of Label-Vision Bar code Software for existing barcode labels, creating and designing new bar code labels for trading partners, importing and compiling bar code labels from Label-Vision software to CMS ERP system.

•Updating documentation for Bar Code Label manuals, EDI manuals. Writing simple queries for department needs.

•Daily troubleshooting of user needs and problems. Helping users with their needs within ERP System.

•Maintaining daily morning procedures for EDI and corresponding trading partners. Archiving daily EDI transactions. Fixing any problems that exist from night before EDI transactions including failed ASN(Advanced Ship Notice) to customers.

Schwab Corporation, Lafayette, IN 7/2003 - 11/2003

Senior Programmer/Analyst (Contract)

•Programming and modifying PACS Software on the AS/400. Writing reports and new development in the PACS application using RPG IV. General Ledger Application, Purchasing, Accounts Payable, Accounts Receivable, Payroll, MRP.

•Written an Inventory Tracking System to track all orders, shipments, and the serial #s associated to those orders and shipments for our plant in Cannelton, Indiana.

•Daily maintenance of the Microsoft Exchange Server on the Network. Troubleshooting any problems that develop. Maintain Network users, passwords, and any need of security issues.

•Installed, configured Network PCs on the network at the Lafayette Location and at our plant.

•Maintenance of Harbinger EDI Software. Troubleshooting, modifications to all EDI programs and maintenance of all necessary EDI transactions as well as modifications of EDI transaction sets.

•Installation, and testing of all PCs including of network cards, motherboards, software, and upgrades of all hardware installed on PCs.

Fansteel/Intercast Corporation, Addison, IL 9/1998 - 12/2002

Senior Programmer/Analyst

•Converted company’s internal computer system using AS/400 system from MAPICS on System/36 to BLIS, a manufacturing software package designed for Foundries using ILE RPG.

•Modified new releases of BLIS package using embedded SQL and ILE RPG.

•Redesigned production control system on AS/400 that was originally on System/36 in ILE RPG.

•Developed menus within existing in-house internal menus. Programmed all necessary shipping reports needed from original System/36 in ILE RPG.

•Designed and programmed Shipping Bar Code Labels and Shipping Quick Receive Labels, Finished Goods Shelf Labels, Shipping Master Labels.

•Implemented and Maintained Electronic Data Interchange (EDI) package on company’s computer system, AS/400, to improve company’s process time and profitability margin. Harbinger Package using ILE RPG.

•Responsible for system backups, system upgrades, installed all program temporary fixes (PTF).

•Installed internal TCP/IP network for company 35-40 personal computers.

•Continually provided support to company’s 30 computer system users using AS/400 and provided daily trouble shooting of user experienced problems with company’s system.

•Setup & responsible for daily maintenance of users on the system, responsible for full maintenance of AS/400 System Security.

Hardware: IBM System/36, IBM System/38, IBM AS/400, IBM 3180 terminal, Decision Data 3791 terminal, Decision Data 3781 terminal, Decision Data 3761 terminal, IBM 5224 printer, Microsoft NT Network, Windows Networking, TCP/IP, WMS(5 Year experience) Health/Claims industry homegrown software- Delta Dental Retail Business(Claire’s)

Software: MAPICS, MAPICS XA, BPCS, BLIS, JD EDWARDS, PRMS, T.L. ASHFORD, SOFTWARE PLUS, SDA, Data Description Specifications, CL/400, DBU7.0, DBU 6.0, DBU5.0, Data File Utility, Hawkeye, RPG I, II, III& IV & ILE, Free Format RPGLE, SQL, QUERY/400, Windows 2000, Microsoft Products: Word, Excel, Outlook 2000, Backup for Windows, Power Point, and Microsoft Access, Networking, VISUAL BASIC.NET, HTML, XML(Have taken classes in these; NO on the job experience), C#(Small projects with Payroll), Java, TURNOVER(change management tool), Warehouse Management System(WMS)

Linkedin URL: linkedin.com/in/debashis-bhattacharya-m-b-a-a251b19a

EDUCATION:

St. Joseph’s College, Rensselaer, Indiana

Bachelor of Science – Computer Science (B.S.)

Kellogg Graduate School of Management

Master of Business Administration (M.B.A.)

Contact this candidate