Uploaded File
add photo
Walter
wjbishop317@comcast.net
215-906-2800
1276 Stump Hall Rd
Collegeville, PA 19426
Sterling Integrator Support / Development Analyst
37 years experience W2
0
Recommendations
Average rating
13
Profile views
Summary

Experienced in EC, EDI, XML, working with many applications and ERP systems. Multiple years experience in project implementations at all levels including development, integrations, and quality. Over 20 years of experience working with Fortune 500 companies. Respected leadership, integrity, and team building.

Experience
Sterling Integrator Support / Development Analyst
Information Technology
Oct 2013 - present
  • Maintain daily alerts and functions of IBM Sterling Integrator 5.23, Sterling File Gateway, Unix through interfaces to JDA and Sterling OMS within a B2B retail environment. Wrote complex SQL queries using complex joins, grouping, aggregation, nested subqueries, cursors, etc.
  • Possess development and implementation experience in EDI ANSI X12, EDIFACT, XML, Sterling's Gentran Server on UNIX, XML/XSLT applications.
  • Maintained / Developed / Upgrade SI Feeds connecting to Retailers (TRU, Estee Lauder, Pet Smart, Dick’s Sporting Goods etc.), 3PL, Drop Ship suppliers via Vendornet / Store-net.
  • Communication protocols:
  • AS2, FTP/SFTP, Web Service Soap-HTTP Calls, MQ and JMS Sonic MQ.
  • On-boarded new Trading Partners and Maintained while developing new / existing xpath-BPML, EDI, XML, EDIFACT maps and XSLT, Mailboxing.
Sterling EDI Sterling OMS SQL IBM Websphere MQ XML XSLT UNIX Trading
Remove Skill
Maintain daily alerts and functions of IBM Sterling Integrator 5.23
Jun 2000 - Oct 2013
Unix through interfaces to JDA and Sterling OMS within a B2B retail environment. Wrote complex SQL queries using complex joins, grouping, aggregation, nested subqueries, cursors, etc.
  • Possess development and implementation experience in EDI ANSI X 12, EDIFACT, XML, Sterling's Gentran Server on UNIX, XML/XSLT applications.
  • Maintained / Developed / Upgrade SI Feeds connecting to Retailers (TRU, Estee Lauder, Pet Smart, Dick's Sporting Goods etc.), 3PL, Drop Ship suppliers via Vendornet / Store-net.
  • Communication protocols:
  • AS2, FTP/SFTP, Web Service Soap-HTTP Calls, MQ and JMS Sonic MQ.
  • On-boarded new Trading Partners and Maintained while developing new / existing xpath-BPML, EDI, XML, EDIFACT maps and XSLT, Mailboxing.
IBM Websphere MQ Sterling Sterling OMS SQL EDI Trading XML XSLT
Remove Skill
EDI Business Analyst
Information Technology
Aug 1999 - Jun 2000
Media 19063
  • Maintain daily operations and functions of IBM Sterling Integrator 5.23, Lightwell B2B Framework in a Gentran HP UX Env with Advance Data Distribution, Trusted Link and EDI 1 Source EDI Software in a Automotive Manufacturing Environment.
  • SAP IDOC/ALE, EDPAR EDI configuration and Maintenance.
  • Resolve daily mapping, EDI, communications (FTP, AS2) and Application business issues with over 200 trading partners and plants.
  • Maintain and develop new EDI transactions, Implementation guides and Application Interface Programs written in Business Basic.
  • Setup and roll out of new IBM Sterling EDI software from multiple EDI Software to include migration of EDI maps, communication scripts and Application Interface Programs.
  • Gap Analysis and testing and implementation
  • Developed VPN Tunnel between customer and VAN to Include workaround for passive ports.
  • Maintain and develop HP/UX scripts to interface between EDI systems and their applications.
  • Proficient in EDI X 12, EDIFACT and XML Standards.
  • Managed multiple EDI projects while maintaining daily operations to 100% service levels.
  • Transaction Sets: 204, 210, 211, 214, 810, 816, 820, 823, 824, 830, 846, 850, 852, 855, 856, 860, 997, Deljit, Delfor, Desadv.
Business Analysis EDI IDOC Sterling Database Maintenance Automotive Trading XML
Remove Skill
EDI Administrator
Feb 1992 - Aug 1999
Supervised and maintain trading partner relationships with customers and suppliers in an EDI environment includes mapping of transaction sets established by customers. Created and analyzed EDI implementation guides and coordinated, tested and implemented EDI transactions, communication Protocols and application interfaces. Facilitated the growth of EDI and B2B initiatives for all elements within the organization, especially in the area of E-commerce on the Web with suppliers. Utilize and maintain translation software Gentran 2.0 Server on an AS400 to include scheduling of communications.
EDI Trading AS/400
Remove Skill
EDI/VMI Manager
Aug 1989 - Jul 1991
Evaluated, developed, and implemented EDI/VMI/EC systems in the retail industry utilizing ANSI X 12 standards. Utilized application tools to support transaction mapping of a customer based on standards and customer requirements. Gentran Server 2.11 to translate EDI transactions in data file formats. Implemented and supported VMI functions with major customers utilizing Supply Chain Solutions, Inc. application Score 5.2 on an AS400 and Unix platform that enabled the company to generate orders based on three years of history and interfaced EDI 852 POS data that reduced lead times and increased sales by 20%. Coordinated EDI relationships with existing customers and new customers and setup over 75 new trading partners on Gentran Server and the roll-out of new EDI transaction sets. Work with other IS staff to support interfaces between applications systems and EDI/VMI applications. Generated reports for upper management were used in making decisions for production, inventory control and performance of customer's accounts using Excel, SQL and Crystal reports.
EDI Microsoft Excel SQL Crystal Reports AS/400 Inventory Control
Remove Skill
Installation Technician
Information Technology
Mar 1985 - Mar 1988
Installation of all peripherals in a token ring Ethernet network that included remote branch communications. Also included in these token ring networks was programming of T1 multiplexers, central/bridge routers, digital modems, and audio response systems.
Routers Network Programming Ethernet
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Computer Information Systems Management
Delaware Valley College
Application of computers and information systems currently used
Delaware Valley College
Minor: business environments
Certifications
Gentran Server version 5.2, Unix scripting, Open Basic programming, Microsoft Excel, Microsoft Acces
Skills
EDI
2021
30
Trading
2021
29
SQL
2021
22
Sterling
2021
21
XML
2021
21
IBM Websphere MQ
2021
20
Sterling OMS
2021
20
XSLT
2021
20
AS/400
1999
9
UNIX
2021
7
Ethernet
1988
3
Network Programming
1988
3
Routers
1988
3
Crystal Reports
1991
1
Inventory Control
1991
1
Microsoft Excel
1991
1
Automotive
2000
1
Business Analysis
2000
1
Database Maintenance
2000
1
IDOC
2000
1