Skip Stein
B*B/EDI Consultant/The EDIGUY
I specialize in Electronic Data Interchange (EDI), B2B Transactions, ETL
systems, Enterprise Application Integration (EAI) and Electronic Business
Flow Management (EBFM) systems that involve many different aspects of
computer technology, including Project Management, Change Management,
Conversion/Migration, ERP implementation and Strategic Planning. I am a
business professional dealing with issues and solutions to problems in the
areas of Information Lifecycle Data Management, electronic business
transaction flow and business intelligence data storage & retrieval. With
a focus on enterprise-wide business analytics I address the institutional
challenges to reform the business processes across the board. I am a
leader in the organizational challenge to move from a siloed approach to
more inclusive information management programs that work across the entire
company.
I provide a complete skill set coupled with a professional business sense
that provides me with the ability to understand complex business situations
and 'pare' them down to achievable action steps. I have the ability to
bounce from technical discussions with engineers to business analytical
reviews with senior management. My drive, enthusiasm and team work skills
allow me to define, develop and implement business process solutions to
complex business problems.
I have worked with most prevalent transaction sets, including ANSI X12,
X12N (HIPAA), Tradacoms (UK), EDIFACT (EU), XML (various) and other
variations. I have applied these transactions in transportation,
pharmaceutical, manufacturing, wholesale/retail, shipping & distribution,
healthcare, electronics and other industries around the world. Please
visit the web site for a list of trading partners and clients!
http://www.erp-edi.net.
As an experienced computer systems professional, I have gained valuable
skills and knowledge by working in a wide range of industries and applying
a varied set of technology solutions to complete project tasks and resolve
client problems. Our employment and consulting history includes such
businesses as Manufacturing/Distribution, Pharmaceuticals, Oil & Gas,
Petrochemical, Telecommunications, Public Accounting, Banking and Finance,
Resort and Hotel Management, and Retail Sales and Distribution. Within
these organizations, I have performed in positions as Programmer Analyst,
Project Manager, Operations Director, Director of Development and Chief
Information & Technology Officer.
I work with ERP/CRM systems with an emphasis on Order-to-Cash, Procure-to-
Pay and the deployment of the EDI interface transactions and third party
systems interfaces. Conversion, migration and integration to third party
systems (shipping, transportation, etc.) are functional areas where I
excel. As experienced Data Architects, I have designed interfaces and
conversion requirements for several company implementations. As a
Certified Information Systems Auditor (CISA, I also function as an Internal
Controls and Sarbanes-Oxley compliance consultant.
My skills include the ability to take charge of projects and complete them
in a timely manner. Since each task of a successful Project depends on
all previous and subsequent tasks, I have developed Project Management
skills utilizing Precedence and Critical Path Method management
techniques. My experience with various computational frameworks, including
Client Server, Distributed Data Warehousing, and Centralized Mainframe,
provide a basis for the constant learning processes. Most recently I have
worked with Electronic Business Flow Management (EBFM) systems utilizing
EDI and Web Commerce tools to implement business-to-business communications
solutions.
Citizenship: United States of America
Education: B. S. Management
University of Houston, Houston Texas
Certification: CISA - Certified Information Systems Auditor
CDP - Certificate in Data Processing
Spoken Languages: Fluent: English (USA), Light: Spanish, German &
French.
Computer Languages: HTML, XML, COBOL, Assembler, FORTRAN, PL/I, C++,
Visual Basic, VISIO, and RPG
EDI Standards: ANSI X.12, EDIFACT, VICS, UCS, ODETTE, TRADACOMS, PIDX
and HIPAA X12N; AS2 Security including Secure FTP,
Softshare, Trailblazer, Boomi, Inovis/QRS, and others.
Computer Software: MVS/XA, SNA/VTAM, UNIX, OS/400, IBM i 6.1, PICK OS,
Oracle, DB2, MS/SQL, MySQL, MS/Access, Open Office Suites,
Windows 2003/2000 Server, Windows Vista/XP/2000,
Microsoft Sharepoint, MS Office,MS Project, Access,
Internet TCP/IP, MS SQL, Oracle, Informix, Novell, Sterling
Software's Connect: Direct (NDM), Sterling Gentran,
Inovis/Harbinger/TLE/Premenos, IPNet, Boomi, Softshare,
1EDI Source, TrueCommerce, and other EDI Transaction
Mapping Systems,
Computer Hardware: Intel based Servers, DEC, HP, IBM System Z, IBM
Power Systems, iSeries (AS/400), 3090, Intel and compatible
PC's, SUN Microsystems, Point of Sale Systems, CBX Systems
ERP & Other Systems: Oracle, JD Edwards Enterprise One (JD Edwards
(XE/World 9.1/ERP 7.3 - 8.12), Peoplesoft HR, JDA, Oracle,
Ross (Gembase), SAP, Cimcase/MTMS, Lawson, TriZetto Erisco,
FreightDATA, AccuPlus
Business-to-Business Electronic Commerce
Project Summary
Full service, USA based and staffed EDI remote support service.
Implemented and automated the Procure to Pay Purchasing Department EDI
integration with key suppliers for a Mid-South Refinery. Designed
electronic commerce (EDI) transaction specification, standards and business
processing procedures. Worked directly with suppliers to coordinate and
test full purchase functionality for blanket ordering, stock and non-stock
items controlled by the JD Edwards ERP system.
JD Edwards 8.12 integration remediation. Coordinate business process
enhancements across all business units. Revise and implement new business
practices to deal with newly installed JD Edwards ERP system. Plan
integration process and electronic transaction processing for Order to
Cash, Procure to Pay and banking/financial integration.
Managed the establishment of EDI Services for a West Coast transportation
company; establishing EDI operations with both in-house (Boomi) and
outsourced transaction management companies. Integrated accounting and
transportation systems to third party billing and transportation scheduling
companies using PowerTrack, FreightDATA, and other systems.
Design and implement inbound EDI three way invoice matching processing for
a large distribution company. Worked the procure to pay business cycle and
re-engineered procurement and invoice payment processing. Establish
electronic payment processing to replace 'paper checks' to expedite payment
processing. Set up JD Edwards to accept inbound EDI invoices for documents
EDI 110, 210 and 810. Initiated remittance advice transmission to
suppliers (EDI 820) for invoice payments.
Conducted an analytical review and developed a requirements plan to migrate
a national manufacturing company from a heavily modified JD Edwards XE
system to Oracle Enterprise One 8.12 (JDE). In addition the electronic
processing interface was analyzed and the immediate production failures
were temporarily remediated; with a plan for a more permanent solution to
be implemented with the migration to E1 8.12.
Coordinate and manage the conversion of EDI resources and Order to Cash
processing from a JD Edwards World to Oracle Enterprise One ERP system.
Worked with deployment team to configure all E1 options and configurations
for manufacturing, distribution and finance. Developed comprehensive data
analysis and mapping for all transaction processing. Configured shipping
and labeling systems in conjunction with Data Systems International (DSI)
programs.
Developed an internal Accounts Receivable (A/R) processes to enable the
receipt of ANSI X.12 EDI remittance advice transactions (RA820) into the JD
Edwards OneWorld Accounts Receivable system for a leading manufacturer of
windows, doors and molding products. The project included building
interfaces to J D Edwards (JDE) OneWorld Enterprise Resource Planning (ERP)
A/R system for trade customer payments and remittance data, implementing
automated cash application processes for JDE OneWorld A/R and training
internal resources for executing the necessary manual A/R cash application
activities. The EDI interface was implemented utilizing INOVIS/IPNet
Solutions data communications tools and Mercator transaction set mapping.
Deployed a trading partner system for a major electronics company that
electronically supplies a comprehensive set of data and information to the
Strategic Supplier/Partners. The Strategic Supplier/Partner utilizes this
data to establish an optimized supply chain and replenishment strategy for
each item to be supplied to the electronics company. The model is based on
a mutually beneficial "partnership". The Supplier/Partner is allowed
certain latitudes in setting up the strategic and tactical deployment
methodologies and is measured on the overall success of the model versus
the more traditional customer/supplier methods and metrics. The two prime
objectives of the business model are increased inventory turns while
increasing the Customers' schedule flexibility in a zero stock-out, and
Supplier managed MRP environment utilizing EDI and electronic commerce. The
overall program objective is to share vital information with the
Supplier/Partner to allow for the transitioning of the decision-making
process from within the electronics company to the supply chain link with
the greatest degree of control and flexibility; the electronics
distribution channel. The system was implemented utilizing Inovis/IPNet
eBizness( Transact for NT and Inovis/IPNet eBizness( Map in conjunction
with Oracle 8.16 and MTMS E.R.P.
Managed the deployment of a food service company's implementation of Server
Based SAP EDI for the application interface to a wholesale distribution
chain. Coordinated the IDOC interface with Inovis TLE, EDI translation
software, for Purchase Order, Order Confirmation and Invoicing. Managed
the application and user dialog interface to ensure accurate translation
and subsequent order processing and distribution. Also coordinated the EDI
processing for inter-company order fulfillment and distribution on a linked
AS/400
Developed internal Accounts Receivable processes for an international
household appliance manufacturer and distributor encompassing activities
currently provided by a third party service. Implemented Inovis TLE EDI
interfaces to A/R for trade customer payments and remittance data;
established trade customer lockboxes, built an automated cash application
process for A/R, and staffed/trained internal resources for executing the
necessary manual A/R cash application activities. Project included banking
lock box interfaces be developed with electronic funds transfer processing
and automated remittance advice processing utilizing EDI X.12 standard
transaction sets (820 & 823) with adjustment activity reported on EDI X.12
(812) transactions.
Completed a migration to Oracle based ROSS ERP systems and full
implementation of Sterling Gentran NT Server EDI interfaces to national
retail chains for processing purchase orders and invoicing. The project
required setup and testing with multiple large national retail chain store
operations and order entry systems for the manufacturing, shipment and
delivery of drug and pharmacological products.
Implemented EDI capabilities and training in Europe for an International
Pharmaceutical company on AS/400 platform and EDI translation software via
a value added network and corporate WAN. Interfaced ERP software systems
to European based warehouse operations and locally developed warehouse
management systems. Trained project team in EDI functionality and
interface standards and assisted in the development and deployment of the
bridging application systems implementation. Acted as liaison project
manager to USA based EDI support and development team throughout the
deployment process.
Install, configure and implement Gentran Server for a large East Coast
Pharmaceutical wholesale drug manufacturing company with interfaces to
Oracle EDI Gateway. Established value added network (VAN) connectivity and
completed trading partner mapping and processing for Oracle ERP/Financial
System processing. Trained the staff in usage of Gentran mapping
components and requirements to upgrade maps to X.12 4010 standards.
Implement Gentran Server for a large beverage bottling company. Manage the
migration from AS/400 Inovis to Gentran in preparation for ERP
implementation of SAP R3. Develop mapping interfaces utilizing current
versions of X.12 and VICS standards to major retail outlets. Train local
personal in utilization, mapping and management of the system. Assist in
the development of application systems interfaces to legacy systems for
interim processing with a planned migration path to SAP IDOC format.
Established full Electronic Data Interchange (EDI) services for an
International Pharmaceutical company using Inovis EDI/400 and TrustedLink
Enterprise (TLE) services. This included the interface to existing AS/400
distribution systems and the Financial and Distribution systems at multiple
international locations. EDI services were established in support of both
intra-company and external trading partner relationships. Full sales
order, purchase order, receipt and manifesting processes were supported as
well as shipping and delivery interfaces with international freight
forwarders. Both ANSI X.12 and EDIFACTS standards were utilized.
Analyzed the accounting and sales order entry system for a national
manufacturing and distribution company of petroleum-based products to
establish trading partner electronic interfaces. Selected and installed
electronic data exchange (EDI) software to interface to DEC/VAX based
accounting systems to map order entry and sales information to standard
ANSI X.12 EDI transaction sets. Developed the necessary programs and
procedures to map the trading partner transaction sets to acceptable input
data formats for input into the company's accounting systems.