DEBASHIS BHATTACHARYA

****

ARCADIA DRIVE

LAFAYETTE, INDIANA 47905

765-***-****

CELL NUMBER: 765-***-****

abm74m@r.postjobfree.com

OBJECTIVE: Seeking a challenging and rewarding position as a

Database Administrator,

Programmer/Analyst, Systems/Analyst with a progressive

organization.

QUALIFICATIONS: Senior Programmer and Project Management on AS/400

Reliable, dependable,and a quick learner.

Good public relations and communications skills.

U.S. Citizen.

EXPERIENCE:

Senior Programmer/Analyst

11/6/06 - 11/06/09

Great Dane Limited Partership Corporation

Chicago, IL

o Write new reports for Production System in ILE RPG on JDEdwards.

o 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.

o Maintain EDI Maintenance between customers. Upgrade EDI Software on the

AS/400, and installed the mapping for all trading partners.

o Responsible for rewriting Trailer Tracking System on the AS/400 based

upon one system.

o Modify programs daily for user issues, user requests.

o Monitoring Help Line Calls for Production Issues for other facilities,

other plants, on JDEdwards

o Rewrite of Trailer Tracking Module Programs with ILE Version

o Implemented and Maintained SQL Server 2005 on daily basis and also

implemented SQL Server 2007

Senior Programmer/Analyst

3/1/05 - 09/08/06

Packaging Dynamics Corporation

Chicago, IL

o Write new reports for Vanilla Production System in ILE RPG

o 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.

o Maintain helpline calls from various users from the various plants

associated to PaperCon/Packaging Dynamics.

o Maintain Formtastic Software and output queues for various users. Modify

Formtastic user authority, security, addition of users .

o Modify Programs in RPG, ILE RPG in PRMS for invoicing, pack list, pick

list, Sales History

o Maintain Peregrine EDI Package, including import and export of data.

Documents supported: 820,824, 830, 856, 862,997

Systems Analyst

Contract Position

2/9/04 - 11/19/04

ATF, Inc.

Lincolnwood, IL

o 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.

o 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.

o Troubleshooting any problems that develop with user's terminals,

printers. Daily troubleshooting of reports not printing, redirecting

output to correct output queue. Creating, modifying, and updating user

profiles and passwords on CMS. Distribution of daily reports for account

managers and department heads.

o Updating documentation for Bar Code Label manuals, EDI manuals. Writing

simple queries for department needs.

o Daily troubleshooting of user needs and problems. Helping users with

their needs within ERP System. Troublshooting of printer problems for

users.

o 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.

Senior Programmer/Analyst - Consultant

Contract Position

7/03 - 11/03

Schwab Corporation

Lafayette, IN

o 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.

o 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.

o 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.

o Installed, configured Network PCs on the network at the Lafayette

Location and at our plant.

o 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.

o Installation, and testing of all PCs including of network cards,

motherboards, software, and upgrades of all hardware installed on PCs.

Senior Programmer/Analyst

9/98 - 12/02 Fansteel/Intercast

Corporation

Addison, IL

o 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

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

o Redesigned production control system on AS/400 that was originally on

System/36 in ILE RPG

o Developed menus within existing in-house internal menus. Programmed all

necessary shipping reports needed from original System/36 in ILE RPG

o Designed and programmed Shipping Bar Code Labels and Shipping Quick

Receive Labels, Finished Goods Shelf Labels, Shipping Master Labels.

o 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

o Redesigned old System/36 Manufacturing Cost Estimation application on the

AS/400 using ILE RPG. Transferred all System/36 files from tape to AS/400

and rewrote applications.

o Responsible for system backups, system upgrades, installed all program

temporary fixes (PTF)

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

o 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.

o Setup & responsible for daily maintenance of users on the system,

responsible for full maintenance of AS/400 System Security.

Programmer/Analyst

5/96 - 8/98

Castwell

Industries_________________________________________________________Skokie,

IL

o Responsible for conversion from company's existing computer system to new

computer system. Conversion benefited the whole corporation including

corporation's 60 computer system users. All programming done in ILE RPG.

o Wrote programs in ILE RPG and embedded SQL for system conversion from

existing JD EDWARDS system to the BLIS system

o Programmed all code for the transfer of the data from old system to new

system using ILE RPG.

o Wrote Production Control Reports, Purchasing Reports, Inventory Control

Reports, Accounting and Payroll Applications.

o Setup System Users and maintained system storage pools, hardware,

software system capacities

Programmer/Analyst

10/92 - 5/96

Solar Corporation

Libertyville, IL

o Maintained and supported existing BPCS programs to meet system and user

requests to allow the company's users to better utilize their

applications and do their job more productively.

o Programmed and configured Windows NT, 97,98 Operating system to meet user

requests.

o Implemented and fully maintained Peregrine EDI Software Package on the

AS/400.

o Wrote report applications in RPG III for users such as Invoice Backlogs,

Audit trails and Purchase Order Error Reports.

o Maintained company's backup system and performed daily backups.

o Setup and established new user profiles as well as maintained existing

user profiles.

o Prepared and generated all purchase orders, invoices and acknowledgments

of company product forms.

HARDWARE/SOFTWARE SUMMARY:

o 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

o Software: MAPICS, BPCS, BLIS, JD EDWARDS, PRMS, T.L. ASHFORD, SOFTWARE

PLUS, SDA, Data Description Specifications, CL/400, DBU5.0, DATA FILE

UTILITY, RPG I, II, III& IV & ILE, SQL, QUERY/400, JAVA, VISUAL BASIC,

DBU, WINDOWS 95, WINDOWS 98, WINDOWS 2000, MICROSOFT PRODUCTS: WORD,

EXCEL, OUTLOOK2000, BACKUP FOR WINDOWS, POWER POINT, AND MICROSOFT

ACCESS, NETWORKING, VISUAL BASIC.NET, JAVA, ROBOT(JOB SCHEDULER)

EDUCATION: ST. JOSEPH'S COLLEGE; Rensselaer, Indiana

Bachelor of Science - Computer

Science (B.S.)

KELLER GRADUATE SCHOOL OF

MANAGEMENT

Master of Business

Administration (M.B.A.)

SOLID COMPUTER DECISIONS, INC.

Certified Web Design

TECHSKILLS, INC.

Currently Enrolled in

ASP.NET, .NET using C# Certification.

Contact this candidate