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.
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.
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.
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/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.
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.