Sales Accounts Payable

objective

Lead, Manage and be a part of a team that develops the best

enterprise software.

Technical skills

Languages/Tools

RPG, ILE RPG(including Free Format), ILE, Binding, Service

Programs, RPG procedures, System APIs, IFS, FTP, SQL (design,

normalize and optimize DB2/400), Embedded SQL, Stored procedures,

User defined functions, Websphere MQ, Java, JDBC, CL, C, HTML,

JavaScript, Eclipse, WDSCi, Hawkeye, MS Office, MKS Implementer,

SourceJammer.

Packages

BPCS, MAC-PAC, SAP, Enterprise Material Order(proprietary ERP

application at Mount Vernon).

Experience

2000-Current

Mount Vernon Mills, Inc. Greenville, SC

Technical Leader

Technical Programming

Responsible for creation and maintenance of Report Template - a

group of objects that comprised of DDS for a display file and a

printer file, RPG ILE source for a screen handler & report

generating program and SQL statement(s) used in IFS. When a new

report is to be written, these template objects were copied and

modified as necessary by developers. The templates contained code

for validation of input parameters, generating a report,

scheduling report, conversion of reports to PDF/XML, some standard

error handling, etc. This provided a consistent approach for all

report generating programs. SQL used for the reports used UNION to

generate summary and detail data in a single result set.

Responsible for CRUD Template - a group of objects that comprised

of DDS for a display file and an ILE RPG program. Standard code

for error handling, validation and Create/Read/Update/Delete

functions for a given DB table was built into this template.

Developers would copy the template and modify as necessary.

Designed and co-developed UI system - a system that gave users a

powerful way to filter/sort/select and store data views. Column

definitions, SQL FROM clause, actions for various options, user

preferences, etc. were stored in tables. SQL statements were

constructed at run-time and data was presented to users.

Developers used the same tool to define what columns users can

select/sort/filter. This system provided all the subfile

functionality that was needed. This system used SQL Descriptor

Area extensively. This system provided - both 24X80 and 27X132

screens, scheduled generation of listing as a report in various

formats, provided output of actual SQL used into IFS to aid

developers to see problems, etc.

Responsible for enhancements and maintenance of NETWRITER - A

complex and completely automated system that handled reports and

their routing/faxing. This application monitored an output queue,

converted reports as necessary (including changing overlays for

AFPDS documents) to various formats and routed them accordingly.

The routing included sending documents like invoices/order

acknowledgements/Bills of Lading, to business partners and

internal users.

Designed and developed other tools that included: an application

to show DB Relationships, an application to show DB locks, an

application to generate SQL whose input is a basic SQL Statement

and would generate an SQL statement that contained both summary

and detail in a single result set, etc.

Designed and developed a custom job scheduler to support

non-standard time periods. The custom job scheduler provided

interfaces so applications could schedule various jobs. It also

provided other options to specify various job specifications

including submitting the job in a held state so a developer could

debug.

Responsible for installation and maintenance of SourceJammer - an

open source source control system. Developed an application that

would generate a report to show if any corruption of

SourceJammers's files.

Cross-platform applications.

CHEMPAX interface - Developed Java applications that would extract

data related to accounts receivable, accounts payable, sales tax,

etc., from a PROGRESS DB, transform and insert into DB2 for System

i.

Java Charts - Developed applications that generated charts. These

applications ran on System i, generated charts into the IFS which

were later accessed by users via a browser.

MS SQL Server interface - Consisted of ILE RPG functions enclosed

in a service program that enabled accessing MS SQL Server.

System Maintenance.

Function as the technical contact for IBM for all software related

issues on the iSeries.

Responsible for evaluating PTFs, OS Upgrades, system values and

their maintenance, Query optimizer file (QAQQINI), etc.

Developed applications to support expired OS releases.

Business Applications

Developed applications in various modules for proprietary ERP

system. Business modules included : Business Partner, Customer

Order, Shipments, Purchase Order, Manufacturing Order, Inventory,

Products, Monetary settlement, Product Structure, etc.

Developed applications that would send MQ messages to move

inventory from Distribution center to shipping docks.

Developed applications that would receive messages from

distribution center and update inventory status.

Developed applications to retrieve inventory shade attributes,

production data, inventory defects, etc.

Developed various service programs that contained functions to

support business processes.

Redesigned and optimized job streams that were complex and took

too long to complete.

Managed developers.

Developed applications to interface with UPS and FedEx shipment

software

Worked with and trained Offshore developers

Optimized complex SQL queries that were used to generate

Re-Ordering Parts data, Shipments, etc.

1996-2000

Computer Discoveries, Inc. Oak Brook, IL

Systems Analyst

Designed and developed interface systems between HP and

AS/400(running MACPAC) for International Rectifier in California.

This resulted in consolidation of the Accounts Payable function

and huge reduction of costs.

Designed and developed applications to generate GL entries based

on a set of user defined complex conditions.

Designed an developed various costing reports.

Designed and developed PO Entry and matching system that matched

POs against vendor invoices.

Managed 4 developers.

Enhanced MRP and MPS modules of MACPAC package for Sigma

Diagnostics in Missouri.

Enhanced functionality of Customer Order and shipping modules of

MAC-PAC package for Watlow Electric in Missouri. This enabled the

client to ship partial inventory based on customer preferences.

This also allowed inventory to be partially allocated to the

customer order and partially backorder.

Designed and enhanced the Accounts payable functions of MAC-PAC

package for Cooper Automotive in Missouri. This enabled client to

save invoices that did not have matching receipts and POs. These

invoices would be automatically matched to receipts and POs based

on a 3-way matching algorithm by a batch process. This batch

process generated all GL entries automatically.

Helped a client in MA convert from SAP to BPCS to reduce costs.

Enhanced and maintained homegrown sales analysis and credit return

systems for Cooper Bussmann in Missouri, worked on

Manufacturing/Sales/Financial modules in MACPAC.

1995-1996

Index Computing Pvt. Ltd, Bangalore, India.

Analyst Programmer

As a team member of Y2K Project, responsible for making all

programs Y2K compliant for Esanda Finance, an ANZ Grindlays

Banking group company in Australia. Wrote tools to speed up the

process of eyeballing each program.

Converted various loan application programs for MIDANZ from S/36

to AS/400. MIDANZ was also an ANZ Grindlays Banking group company

in Australia.

Also responsible for converting from a D45 AS/400 to an AS20.

Managed a team of 6 developers.

1994-1995

ICI India Ltd, Hyderabad, India.

Analyst Programmer

Was a member of a team responsible for installation,

implementation and maintenance of BPCS software at 2 different

locations.

Was responsible for maintenance of General Ledger, Accounts

Payable, MRP, Shop Floor Control and Purchase Order Modules.

Worked with Chief Financial Controller to re-design and develop GL

module.

Was also responsible for training other programmers in RPG and CL

on the AS/400.

Managed a team of 4 developers.

1992-1994

Leading Edge Technologies, Hyderabad, India.

Analyst Programmer

Responsible for training programmers on AS/400 in RPG and CL, CICS

and IMS.

Was a member of a team that designed and developed an inventory

interface system for a client in the US.

1988-1990

Comp-U-Teach, Visakhapatnam, India.

Instructor

Responsible for preparing training schedules for training people

on basics of computers.

Taught Basic, COBOL, MS-DOS, CP/M etc. on Apple IIe and PC.

Also responsible for teaching high school students about computers

and programming.

Developed new business.

Education

1990-1994 Institution of Electronics and Telecommunication

Engineers,

New Delhi, India.

Bachelor's degree in Electronics and telecommunications with

computer science as a major.

1985-1988 Sri Varalakshmi Polytechnic

Machilipatnam, India.

Diploma in Electronics and Telecommunications engineering.

Contact this candidate