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;

similar to post-ship billing in BPCS.

V Created Sales vs. Budget reports to give sales

performance by salesman and state level

V Providing user training for JBA 3.5.2 system

V As part of system upgrade to version 3.5.2 retrofitted

all custom modifications to new release of the software

V Supporting BPCS to WMS LogPro 7.0 interfaces

All coding was done according to the latest structured

programming requirements using RPG400, RPG4, ILE, CL, SQL

07/98 - 11/99 QBS Corporation, Stamford, CT

Consultant

For Mervyns supported implementation of ACS Apparel Control

System. The system is designed to control the manufacturing

cycle from Order Entry through Production, Shipping, and

Billing. Implemented complicated subfile processing, lookup

windows, and message subfiles techniques to write the

following programs:

V Style master maintenance enhancements

V Raw material master maintenance

V Mass order maintenance

V Extension files creation and maintenance

V Bill of Materials selection screen and reports

For Warantech participated in Phase 1 of the Y2K conversion

project. Was using Search2000 utility to locate all files

and programs with the date field reference. Once program is

located, modifying it according to Y2K requirements.

For United Distillers NA participated in design, coding and

maintenance of Demand Planning System for UK branch.

Specific responsibilities included:

V Design and coding of the complicated production control

reports that allow client to analyze see-through data,

ability to compare current production numbers with

planning data

V Created timing members add-on to the Merchandise System

to increase screen response time and process efficiency.

All transactions are written to the separate data member

and processed at the pre-set time interval

V Writing remote data base interfaces to allow client to

write queries over the data from the remote AS/400

V Heavy interactive (subfiles, message subfiles), batch and

DB2/400 programming experience

06/97 - 07/98 RCG Consulting Services

Position: Sr. Programmer/Analyst

V Responsible for BPCS 4.0 system Maintenance and Support.

Applications: Order Entry, Billing, Inventory control,

AP, AR, GL, Purchasing. For RPG programs utilizing

RPG400, CL in compliance with structured programming

requirements. Subfiles processing, Message subfiles,

Windows. Using UIM panel groups to support intensive on-

line help.

V Utilizing Client/Access transfer function to

upload/download data from and to AS/400 to support Lotus

123 and Excel users

V Writing design specifications for the programming staff

V Production support. Troubleshooting.

06/93 - 06/97 PUBLICITAS ADVERTISING SERVICES, Inc., Connecticut

Position: Programmer/Analyst

For company needs participating in full project cycle for

AS/400 to EDI Transit Interface system. Identifying user's

needs by attending project steering committee. Writing

narrative documentation. Writing interactive and batch

application programs. All programs are written using RPG400

in compliance with structured programming requirements.

Responsibilities also include the complete System AS/400

operational support, production support, and

troubleshooting.

08/91- 06/93 LECHTEK CONSULTING Co., New Jersey

Position: Programmer/Analyst

For Whitestone Product Inc. participated in development and

maintenance of Material Requirements Planing System. All

Programs were written using structured RPG400, utilizing

System AS/400 techniques, databases, subfiles, message

handling. Used SDA to create display files. Wrote CL

programs to control the modules execution. The System was

implemented in cooperative environment of AS/400 and PC-LAN

V For Gibbs & Cox Inc. participated in maintenance of the

Miscellaneous Cash Receipts System. Responsibility

included analyzing the problems, coding and testing of

the programs to update on-line transaction parameters,

enter and correct cash receipts, print cash receipts

report, display or print historical data. The programs

where written utilizing Cobol and RPG400

1987-1990 CITY DATA CENTER, Riga

Position: Programmer/Analyst

V Participated in full project-cycle development: analysis,

design, development, maintenance and implementation for

Company-Wide Payroll System. Was involved in coding and

testing using OS/MVS and COBOL, implementation,

production support. Wrote Program and System narratives.

Education: QBS UNIVERSITY, Stamford, CT

Advanced Java for iSeries

Introduction to Java for iSeries

Introduction to Websphere

WebSphere Development Studio for iSeries

LATVIA STATE UNIVERSITY, Riga

BS Degree in Computer Science.

References: Furnished upon request

Contact this candidate