Sales System

Location:

King of Prussia, PA, 19206

Posted:

June 13, 2013

Contact this candidate

Resume:

Summary: Seasoned information systems professional with more than twenty

years of diversified Analytical, Design, Programming, and

Consulting experience in Pharmaceutical, Publishing and

Information Technology industries. Specializing in Order

Processing, Distribution, Sales, Marketing, Inventory,

Production Management, Accounting

Objective: To obtain a challenging programmer/analyst position in the

progressive data processing

environment, utilizing proven technical skills and extensive

experience in analysis, design,

maintenance, and implementation of various business applications

Hardware: IBM AS/400 (iSeries), IBM SYSTEM 38, PC

Software: OS-400, SYS-38, RPG400, RPG4, ILE, DB2, CL, SQL400, Programming

Tools, SQL,

x-Analysys, TestBench, JDA MMS, BPCS, Mapics, AS/SET, ACS, JBA,

LogPro, WebSphere

Work History:

02/06 - Present QBS Corporation, Stamford, CT

Position: Consultant

V 5/2012 - Present - Tier 1 Food Manufacturer, New York

Supporting legacy Mapics application during company's

transition to SAP based manufacturing and distribution

modules. Resolving day-to-day production issues with

inventory control, shipping, and receiving. Performing

business analysis for other subsystems. All program

modifications and enhancements are completed using ILE

modularity, Free RPG and imbedded SQL functionality.

V 7/2011 - 4/2012 - MBI Inc, Connecticut

Participating in complex process of merging of several

companies. Normalizing existing database. Optimizing

queries. Writing menu security allowing function level

security access. Writing executive reports. All code is

writing using RPG free. Utilizing ILE concepts for

modular application approach. Using imbedded SQL and

modern code to enhance existing application.

V 7/2010 - 7/2011 - GCC Executive Travel, Massachusetts

Rewriting reservation system using ILE and RPG Free.

This is a complex application with multiple subfile

screens. Using MVC approach in architecting work flow.

Using IBM written model components to access data without

having files defined in RPG program. Writing external

procedures for business logic. Application is written so

it can be easily implemented in phase 2 when web

components will be calling new procedures. Using x-

Analysy, TestBench and other tools for rapid application

development and testing.

V 5/2008 - 7/2010 - Tauck Tours, Connecticut

In the effort to ensure database integrity between

various platforms participating in Data Consolidation

Project. Rewriting existing code using modern free

format RPG

within ILE framework. Using x-Analysy to identify

business rules and various levels of objects

relationships. Replacing existing file access logic with

the calls to Data Access Layers written with free RPG and

SQL based stored procedures for data validation, access

control and business logic centralization. Adjusting

existing RPG programs for access by Java based Web

Services.

V 3/2007 - 5/2008 - Duane Reade, New York

V Participated in new development and implementation of

Store Labor Planning system. JDA MMS add-on allows

stores manage labor recourses more productively. System

is seamlessly integrated with MMS and BlueCube database.

Robust forecasting functions allow streamline new store

opening procedures and planning. Creating multiple

reporting tools for sales analysis, replenishment, and

inventory control subsystems. Supporting JDA to WMS

LogPro 7.0 interfaces.

V 09/2006 - 03/2007 Mervyns, Tier 1, 200 stores apparel

retailer in California

Participated in new development and implementation of

Supply Chain Management system. Application is

implemented under JDA MMS510 umbrella. It provides an

ability to track ASN's and map it to the original PO's.

Created centralized repository for EDI errors to provide

client with ability create Vendor Compliance Requests.

V 02/2006 - 09/2006 Taro Pharmaceutical Industries,

Westchester, NY

Creating financial reports based on BPCS, PKMS and

Lawson data bases

01/01 - 02/06 Taro Pharmaceutical Industries, Westchester, NY

Position: Sr. Programmer/Analyst

V Day-to-day production support. Conducting meetings with

power users

V Conceptual and Technical design for development and

modification of BPCS by AS/SET and RPG IV

V Create test script and perform unit and system test

V System integration between PC based system and AS/400 by

trigger, FTP and MS ACCESS

V BPCS migration from Version 6.1 to 8.0

V Hands on development and system customizations using

variety of iSeries utilities and languages

Partial list of projects:

.For sales division designed and developed Sales Roll-

forward subsystem. That included Invoice to Order

reconciliation, Order re-pricing, Order cancellation,

Journaling, and roll-forward summary process and enquiry.

.Auto data reformatting into Excel format

. Sales reports with visibility into re-order point, quality, and

inventory levels

11/99 - 01/01 Davidoff of Geneva, Inc., Stamford, CT

Position: Sr. Programmer/Analyst

Main responsibilities - maintenance, support and troubleshooting of

JBA 3.5.2 System

V Performing custom modifications and new development

including modifications to the Order Entry System to

create an automatic batch invoice generation application;