Sales Management
Resume:
DEV SUMAN
Fullerton, CA
Mobile: *** - *** - ****; Email: ********@*******.***;
[pic]
* ********* ****** ***** *********** such as Sr Developer / Technical Lead/
Senior IT Manager with a growth-oriented organization that welcomes fresh
ideas, initiative & dedication
[pic]
Amcor Sunclipse NA " Hamilton Sundstrand " Gateway Computers Inc " Murata
Electronics " JDS Uniphase
. Commendable experience of 15 years in Software (IT) industry.
Instrumental part played in ERP-JDE Projects implementation.
. Excellent Project Managerial, Analytical, Technical & Functional
Experience on Oracle-Peoplesoft-Enterprise One (JD Edwards) ERP XE, E810,
E811 & 7.3; ideal for any ERP and its interface implementation.
. Pivotal in JDE Manufacturing, Distribution/Logistics and Financial
Modules. Veteran in gathering requirements, development, testing,
performance tuning, customization, interface, conversion and production
support on JDE World & One World environment.
. Functional experience in JDE Common Foundation, CNC Foundation, Report
Writing, and System Administration.
. Capable of leading the team in developing various interfaces for JDE
World & One World to systems viz. Siebel, Mesa, EDI, Formscape, CFORIA,
Transform AP, RF Smart, Vertex and Web applications.
. Dexterous in identifying correct resource and their management,
estimation and adherence to schedules of Projects. Spearheaded the
efforts on both technical and non-technical audience.
. Acknowledged by users as well as IT department for the smooth transition
of Projects by leading, creating and maintaining a creative, fair and
productive work environment.
Technical Skills
o ERP Modules: Product Data Management, Shop Floor Control, Forecasting,
Capacity Requirement Planning, Data Collection. Sales Order Management,
Inventory Management, Purchase Management, EDI/Electronic Commerce, and
Requirements Planning General Accounting, Account Payable, Account
Receivable, Address Book and Payroll
o One World Tools: OMW, Data Dictionary, Table Design, Form Design, Report
Design, Business Views, NER Business Function Design, C Business
Function, Table/ Data Conversion, Debugger, UTB, Event Rules, Processing,
Options, Menu
o JDE World: CASE tool, SVR, Data Dictionary, World Writer, Dream Writer,
VO, UDC, Screen Design Aid (SDA), Report Design Aid (RDA), Menus, File
Design Aid, J.D. Edwards Programming Standards, File Server and
Functional Server, User Space and User Index, Programming Modifications,
Source Debugger, Applying SARs
o AS/400 Tools: SQL, Forms 400 / Create Print, T.L. Ashford - Bar Code
Label Printing, CGI Programming, Query400, DBU & Quest View - for
Database Viewing, MKS Implementer for Software promotions, Client Access
Other Technical Skills
o OS: IBM-AIX, OS/400, DOS 6.22, HP-UNIX, Windows 95/98/XP/2000, Windows NT
o Languages: RPG/400, ILERPG, CL/400, SQL, COBOL/400, C, C++, Java Script
o RDBMS: DB2/400, DB2UDB (AIX), SQL Server 7.0, MS Access, Oracle
o ERP: Peoplesoft One World Xe, E810, E811, JD Edwards 7.3and MESA
o Data Ware: BRIO Reporting Tool
o Hardware: IBM AS/400, IBM-AIX, IBM PC's and compatibles
o PC Tools: Plan View, Action Request System - Remedy User, Lotus Notes,
Microsoft Outlook, Microsoft Word, Excel, PowerPoint, Access, Siebel Call
Center, Show Case
[pic]
PROFESSIONAL EXPERIENCE
Amcor Sunclipse NA (AMCOR Australia), Buena Park, California, USA
since August 2005
JDE World 7.3 / One World E810 Support and Enhancements
(Manufacturing, Sales, Distribution, Logistics, Financial)
Environment: JD Edwards E810, 7.3 on AIX & AS400
DATA CONVERSION
. Involve in functional / technical analysis of existing system/ testing of
data integration and applications while administering outside consulting
resources and resolving upcoming issues by giving appropriate solutions.
. Adept at extracting data from existing AS400 and applying CUM Level 15 on
AS/400 Database to bring it up to the level of E810.
. Developing and operating Table Conversion on E810 environment to migrate
data from existing JDE on AS400 to E810. Handled Data synchronization
between World and One World Common Master Tables using Table Conversions.
. Incorporating customized functionally into New One World Environment
ECOMMERCE WEBSITE INTERFACE TO JDE WORLD AND ONE WORLD
To enhance the business, Amcor Sunclipse is in a process of creating B to B
and B to C Web interface with JDE 7.3 and Peoplesoft One World E810. The
role required doing Functional/ Technical Analysis/ Testing of Data
Integration and Reports and interface Applications created.
. Collating Data from existing JDE System and sending it to Web.
. Creating Interface to receive Web Orders via Web Services and generating
JDE Order. Forwarding status update of each Order as soon as it is
processed in JDE System.
IT ARCHITECT
. Assisted in implementing IT architecture restructuring required to make
the ERP and their interfacing Systems Run more efficiently.
. Scrutinizing Systems JAS Server Log, Debug logs, JDE logs along with the
recognition of the issue and resolving it either by Logic/ Functionality
Change and/ or by Hardware/ Database configuration Management.
PRODUCTION SUPPORT
. Deft in providing Production Support on E810 and AS400 including all
interfaces viz. SIM, Formscape, RF Smart, CFORIA, troubleshooting and
resolving various day-to-day issues.
. Lead role in augmenting the performance of various UBE jobs in E1 and
enhanced their efficiency. Guided Analysts/ Super Users in resolving
Queries and providing visionary solutions.
. Undertook Performance tuning for scores of Programs running for several
Hours. Evaluated query and designed modifications as per the need.
APPLICATIONS, INTERFACES & REPORTS DESIGNED
. Designed, modified and enhanced numerous reports (ERW) and applications
on existing E1 System. For instance, Rebate Contract Entry, Credit Card
Processing, Transform AP.
. Involved in Design & Implementation various custom Modules need for the
Business as: Rebate Claim, Purge Programs, Auto Purchasing, Item Word
Search, Sales Reports - Invoices, Order Status and so on.
. Administered and implemented Formscape Interface with E810 for various
existing Environments.
. Created interface with WEB Orders involving Triggers and Batch Scheduler
jobs.
Hamilton Sundstrand (United Technologies Company), Connecticut, USA
August 2004 - August 2005
Consulting Company: Perot Systems Inc
JDE World 7.3 to One World Xe Conversion (Manufacturing, Sales,
Distribution, General Accounting)
Environment: One World XE, AS400, RPG/400, CL/400, DB2/400, JD Edwards ver.
7.3
SHOP FLOOR CONVERSION
. Carried out functional analysis of their ERP System and developed one
world functional and technical specification for all of their existing
custom modifications in JDE World.
. Skilled in reverse engineering, created functional & Technical One World
Specifications for various Custom Manufacturing programs of Shop Floor
Control, Product Data Management, Work Orders, Address Book etc. The
development work is done offshore at India. Managed Functional testing of
One World Applications and fine-tuning the programs. Worked as a team
lead for offshore developers and interface with client business managers.
. Drafted Blue Print and converted the programs for Work Order Entry,
Release, Inventory Issue, Movement and Kanbans, Work Order Reallocation,
Dispatch List, Hours and Quantity Update, Completions etc.
Gateway Computers Inc. North Sioux City, SD, USA
July 2002 - July 2004
Consulting Company: Keane Inc
JDE Development and Maintenance (Manufacturing, Sales Distribution, General
Accounting, EDI)
Environment: One World XE, AS400, RPG/400, CL/400, DB2/400, JD Edwards ver.
7.3
COMBINED ORDER ENTRY (COE)
. The company wanted to enhance the existing Sales Order entry application
to allow combined order entry at the country stores. The new order entry
application will allow entering C & C, BTO orders, and COE orders as a
single order type at the country stores.
. Carried out modifications to the Sales Order Entry - Header Detail
programs to display order flag screen for all order types and fulfillment
Type detail lines, to Freight Revisions program to display freight codes
for the order.
. Assigned with the task of modifying discount revisions program to allow
both '%' and '$' discounts and allow Advance Price adjustments
capabilities.
. Successfully modified the Sales Configurator program to show few items
instead of all the items available for selection for a given product.
UPS NETWORKING
J.D Edwards Interface to various EDI Transactions
. Approximately 15000 items required to be added to JDE and setup so that
they will be fulfilled through third party distributors. The Purchase
Orders for these items will be communicated to Vcommerce using Electronic
Data Interchange (EDI/XML) standard transaction 832/846/180. Receive and
Process combined 832/846 transaction from Gentran (EDI Translator on NT)
. It involved writing of new RPG, CL JDE standard Programs for creating
interface files on JDE side, Purge Programs for purging Interface files
and carrying out of FTP to send those interface files to NT server.
J.D Edwards to WEB Sales Order Interface
. The company wanted to design and implement an interface to receive Sales
Order from WEB. The interface should be capable of receiving the orders,
creating Address Book entries and of creating the corresponding Sales
orders for the Orders entered through Gateway.com (web).
. It required new development and changes in existing JDE RPG/CL programs,
Change/Create UDC, Change DW version for Sales Order Entry - Detail and
Change Menu, Support Users and regression testing, Pre/Post
Implementation support.
Murata Electronics, Atlanta, GA, USA
December 2001 - June 2002
J.D Edwards Interface to Advance Planning and Production Scheduling
Packages
(Manufacturing, Sales Distribution)
Environment: AS400, RPG/400, CL/400, DB2/400, JD Edwards ver. 7.3.
JDE PS-P INTERFACE
. The basic flow of operation is to utilize PS-P, the Production Scheduling
module of the APS Software (used to be called Numetrix) to calculate the
production schedule. It involved use of CASE Tools, Dream Writer, World
Writer and Query Programs, creation of custom J.D. Edwards standard
RPG/CL Programs and development of the interface files. Once created the
tab delimited files are sent to another server using FTP as batch job
where P-SP runs.
. Accountable for developing Global FTP Tool run in Batch for Data Transfer
between various AS400 machines located all over the Globe.
. Instrumental in writing Dynamic SQL using STRQMQRY in CL for updating
correct Library in FTP input source.
. Performed Data migration of Address Book, Item Cross-Reference, Lot
master and Distribution System Data by writing various Dream Writer
Programs, Uploading/Downloading Excel Files to AS400.
JDS Uniphase, Santa Clara, CA, USA
August 1999 - November 2001
J.D Edwards 7.3 / MESA Maintenance
(Manufacturing, Sales Distribution, HR, Payroll, A/R, A/P, GL)
Environment: AS400, RPG/400, CL/400, DB2/400, ILERPG, SQL Server 7.0, JD
Edwards ver. 7.3, MESA, OS/400, BRIO
JDE MESA INTERFACE
. Created interface between JDE and MESA - Manufacturing Package on AS400
applications to start a lot on MESA side when there is an issue of item
from JDE. Involved understanding of JDE and MESA files system and
manufacturing transactions
REPORTS, BAR CODE, FORMS
. The project required generation of various reports to meet Distribution,
Payroll, Manufacturing, and Finance user's requirement using World
Writer, Dream Writer, AS400 Query or Custom CL, RPG/RPGLE Program.
Involved in extensive RPG, CL coding for reporting and data conversion
needs. Key role in RPG, CL coding for reporting and data conversion
needs.
. Worked extensively on MESA - Manufacturing Package on AS400.
. Engaged in enhancements writing custom ILERPG programs using user exits,
generation of various reports using Create Print Tool for enhanced Output
involving Cycle time, Yield for lots at various operations, writing of
extract programs, Bar Code Label Printing Programs using T.L Ashford and
interface with other applications viz. JDE (JDE to MESA Lot Start), NWA
etc.
. Led the efforts on uploading and downloading AS400 files using send
receive, sending data to remote AS400 systems using FTP
. Managed Data Base Design of various work files needed for various jobs
and reports. Understood SDLC; involved in writing IRS, SRS and
implemented various projects
WEB INTERFACE
. Created WEB interface to J.D.E using CGI Programming for Returned
Material Acquisition (RMA) using HTML, VB Script CL and RPGLE programs
DATAWARE HOUSING
. Responsible for creating work files for Dataware Housing needs at AS400
end to allow access of those files on SQL Server for generating various
reports using BRIO as front end.
. Used Brio as Reporting Tool for generating various Labor Efficiency,
Resource Utilization, Yield Validation, and Lot Status Reports.
. Used EIS section for user interface and wrote Java scripts behind the
scene to support it. Included pivot section in the reports so as to
provide drill up and drilldown facilities to the users.
SUNBEAM INC, Boston, Cleveland, Chicago, USA
January 1999 - August 1999
Consulting Company Ernest & Young (E&Y)
(Manufacturing, Sales Distribution, General Accounting)
Environment: AS/400, RPG/400, CL/400, DB2/400, SQL, JD Edwards ver. 7.3
J.D Edwards 7.3 Implementation
. The project was undertaken to developing custom batch and interactive
J.D. Edwards's CL, RPG standard programs to enhance the functionality of
manufacturing and distribution modules.
. Developed programs for Carrier & Print Message Update, Manifest Creation,
Freight Term Update & Labor Variance Report using the J.D. Edwards CASE
tools.
. Generated extraction reports using World Writer and RPG programs for
NACM, Dun & Bradstreet, and Demand Solution etc.
. Generated various reports to meet Distribution, Payroll, Manufacturing,
and Finance user's requirement using World Writer, Dream Writer, AS400
Query or Custom CL, RPG/RPGLE Program.
. Involved in extensive RPG, CL coding for reporting and data conversion
needs viz. Data conversion, Uploading & Downloading Excel Spreadsheet to
AS/400, creating physical files, generating reports etc.
NEW HOLLAND NORTH AMERICA INC, New Holland, PA, USA
September 98 - December 98
(Manufacturing, Sales Distribution, General Accounting)
Environment: AS/400, RPG/400, CL/400, DB2/400, COBOL/400, J.D Edwards ver.
7.3/6.2
LOGNET - JD Edwards Upgrade from ver. 6. 2 to ver. 7.3
. Developed the project to retrofit the custom CL, RPG and COBOL programs
from JDE 6.2 version to 7.3 version.
. The modules that required custom modification in the program were:
Address Book, Inventory Management, Work Order Management, Forecasting,
Transportation Order Management, and Sales Order Management.
. The upgrading process involved examining the programs, making the
necessary changes required to fit the new version, and unit testing of
the programs.
. Assisted in the development of the programs Y2K compliant before being
retrofitted into the new version.
DEPOSITORY TRUST COMPANY (D.T.C) U.S.A
June 1997 - August 1998
IIS Infotech Ltd Offshore project, New Delhi, India
Environment: AS/400 V3-R7, RPG/400, DB2/400, and CL
CHANGE MODE OF PAYMENT (CMOP)
. The application is used for maintaining the Stock Exchange System.
. The current Interactive Change Mode of Payment consisted of various views
and screens used for calculating the premium amount to be paid to the
customer, exchange of shares- calculating net amount to be paid and
generation of reports either online or in batch mode.
. The current system was replaced by OCMOP, where calculations can be done
at hourly, weekly, or monthly basis.
CAMPBELL EWALD, USA
January 1997
- May 1997
IIS Infotech Ltd Offshore project, New Delhi, India
Environment: AS/400, RPG/400, COBOL/400, CL/400, DB2/400
Year 2000 changes for GM parts
. The major function of the GM Parts CO-OP Advertising System is to audit
dealer-advertising claims in order to reimburse them for their
advertising costs. Claims are submitted via mail and electronically. The
mailed claims are scanned into an imaging system and an auditor pulls
these claims up to audit and enters them into the AS/400 database.
SVAM SOFTWARE LTD, New Delhi, India
January 1995 - December 1996
Environment: MF COBOL, Windows 3.1
Inventory Control System & Library Management System
. Responsible for Analysis, Design, Coding, Debugging, testing Programs.
[pic]
EDUCATIONAL QUALIFICATION
Bachelor of Engineering (B.E/B.S) - Computer Science 1994
[pic][pic]
Contact this candidate