Edi Specialist / B2b Sterling Integration Consultant Resume
Dublin, OH
PROFESSIONAL SUMMARY:
- 6+ years of experience in EDI and worked as EDI Analyst / Developer with extensive experience in multi divisional corporate EDI environments.
- Highly Experienced in Distribution, Manufacturing, Supply chain, Healthcare, Shipping and Logistics industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
- Highly experienced in handling EDI Production Support.
- Responsible for the daily EDI operations, which included administration, control, scheduling and balancing of EDI documents.
- Knowledge on creating Net maps and Adapters in Sterling Secure Proxy.
- Experienced in working with FTP, FTPS, SFTP, AS1, AS2, AS3, VAN.
- Experienced in Data Mapping and Data Conversion using EDI/ HQ, Gentran, Sterling Integrator.
- Trading partner assessment as well as corporate readiness for EDI production. Industry knowledge sharing to assist in long - term goals.
- Extensive experience in B2B integration tools e.g. Sterling Integrator (5.1/5.2.X), Sterling file gateway 2.2.4 and 2.2.5.
- Knowledge on creating Cognos reporting in Sterling Control Center to generate reports for file transfer based on protocol and total file counts for any period of time.
- Monitor the certificates configured in Sterling Integrator and renew them on timely basis before expiration and coordinating with trading partners.
- Applying fix packs and performing upgrades for Sterling Integrator, Sterling File Gateway, Sterling Secure Proxy, Sterling Control Center and keeping the system up to date.
- Knowledge on creating SLCs and rules in Sterling Control Center.
- Knowledge in creation of Mailbox, Virtual roots, Communication setups and development of BP (Business Process) in Sterling Integrator &Monitoring System level errors and maintained EDI Support mailbox for FTP/AS2/VAN failure, incomplete files alerts and investigated FTP/AS2/VAN Transmission failures and retransmitted files.
- Created Static and Dynamic Routing Channel Templates and Routing Channels between Consumer and Producer in Sterling File Gateway.
- Monitor the security vulnerabilities and apply patching to all the applications and keep the system with the updated version.
- Experience with various EDI standards and translators: ANSI X12, EDIFACT, EDI/ HQ.
- Working on partners to send/receive EDI transmissions.
- Experienced in various delimited file formats and standards include ANSI X12, UN/EDIFACT.
- Proficient with different translation tools like SI Map editor, EDI HQ.
- Proficient working with Graphical Process Modeler for designing Business Processes in SI.
- Worked with Scheduling and Performance Tuning of Business processes in GIS/SI.
- Experienced in integrating onto IBM SI/GIS.
- Setup packet captures to troubleshoot the file transfer issues to Customers servers.
- Experience on XML, XSD, XPATH, XSLT and other internet related technologies.
- Experienced writing SQL queries in Oracle, MySQL and IBM DB2.
- Daily checking Project tracking using tools like JIRA, MS Project.
- Worked in Mainframes, for Trading Partner data extraction.
- Experienced working with File Formats like ANSI X12, EDIFACT, IDOC, CSV, XML, and legacy specified application file formats.
- Worked on flat file, ANSI X12 EDI transactions like 834, 835, 837, 850, 855, 856, 810, 820, 816,860, 865, 945, and 940, 204, 210, among others.
- Worked on EDIFACT EDI transactions like ORDERS, ORDRSP, DESADV, INVOIC, and REMADV among others.
- Coordinate work for and with other Business Analysts, coordinate Unit Testing tasks, work with Trading Partners for connectivity issues; liaison between customers and corporate staff or between IT and Business Units; perform system matrix testing.
- Involved in various activities present in project life cycle such as Field usage Analysis, FD walkthrough, Map group analysis, Map specification preparation, Map build, Unit testing, AT, FAT, Coordination with Business teams about defects fixing.
TECHNICAL SKILLS:
Mapping Tools: EDI/ HQ, Sterling Integrator (5.0/5.2.X), Gentran Integration Server (4.2), GXS, Gentran Server for windows (3.0).
Industry standards: ANSI X12, EDIFACT, FLAT FILE, DELIMITER FILE, IDOCs
SQL Editors: TOAD
EDI Transactions: 830, 850, 855, 860, 856, 810, 846,862, 867, 997, ORDERS, ORDRSP, INVRPT, DESADV, INVOIC, SLSRPT, CONTRL, 300, 301, 310, 309,350, 353, 355, 824 and 311.
Programming Languages: VB, SQL
Databases Access: JDE, Oracle
Operating Systems: Windows 2003/2007/2010 , Unix
Communication Protocol: AS1, AS2, HTTPS, FTP and SFTP, VAN
Other Software: TEXT PAD, ULTRA EDIT, EDI NOTEPAD, BEYOND COMPARE, REMEDY TOOL.
EXPERIENCE:
Confidential, Dublin, OH
EDI Specialist / B2B sterling Integration consultant
Responsibilities:
- Worked as Consultant for the EDI E-Commerce team.
- Involved in full-life cycle software development for mid-size to complex projects by performing requirements analysis and testing.
- Gather, analyzes, and documents business requirements to support the design and development of technology and/or process solutions.
- Leverage relevant process and technology expertise to propose appropriate solution options.
- Translated business requirements into technology solutions. Clearly defining and communicating targeted functional solution via functional design specifications and verify technical designs satisfying functional requirements.
- Assist with upgrading transactions to the most current EDI verses well as managing testing activities with Trading Partners.
- Responsible for trouble shooting EDI documents with data errors.
- Responsible for Unit testing for Map’s created for the new partners and Production Turnover.
- Responsible for Trouble shooting Mapping errors.
- Coordinated with the customers to analyze requirements for implementation guide.
- Experience on end to end customer testing for all the EDI documents.
- Involved in Scheduling and monitoring of SAP Batch Jobs Processing programs.
- Responsible for setting up the trading partner profiles with appropriate Message types in SAP and processing IDOCS.
- Deploy, set up and administer trading partner envelope profiles, AS2 profiles, certificates, business processes, code lists, services, schedules and maps in GIS.
- Responsible for creating basic and Advanced Trading Partner profiles in the communities and Management of communities in GIS 4.2.
- Responsible for creating the Business Process Models as per the business requirements Using Graphical process modular.
- Configured envelops for new Trading partners.
- Created the work flows to accomplish the Business models in the Business Process Models using the BPML in GIS.
- Experience on Configuring Inbound and Outbound File systems Adapters.
- Responsible for trouble shooting the Business Process models in application connectivity.
- Created XML maps and configured the corresponding adaptors as per the business requirements.
- Responsible for Monitoring the Business processes and Tracking documents.
- Set up and configured the AS2 communication protocol for exchanging the EDI documents for trading partners with digital signature.
Environment: Gentran server 6.0 on UNIX, GIS 4.2, UNIX, SAP R/3, AS2, VAN, FTP, SFTP, ANSI X12.
Confidential, Minneapolis, MN
EDI Consultant / B2B sterling Integration consultant
Responsibilities:
- Attending meetings with respect to new implementation with the customer.
- Working daily EDI operations, which included administration, control, scheduling and balancing of EDI documents.
- Implementation and troubleshooting of B2B connectivity for integrations using IBM Sterling B2B Integrator.
- Works closely with Enterprise Architecture and business analysts to insure high quality implementations.
- Performed EDI mapping, testing administration on EDI/ HQ 3.2 on Windows 2008 with JDE server.
- Implementation of B2B sterling Integration, design, develop, maintain and troubleshoot IBM Sterling B2B Integrator custom business processes, Services.
- Accountable for the stability, integrity and efficient operations of the EDI information systems to support admin EDI functions.
- Analysis, design and implementation of complex work including mergers and acquisitions procure to pay, source to pay, order to cash.
- Work involved with developing flow and Java services using developer to automate and filter the process of exchanging various EDI Business Documents with Trading Partners.
- Worked on multiple client integrations with a focus on detail orientation and regular status updates with client facing teams as well as IT Management.
- Designed and developed business processes and maps for the identification, capture, processing, formatting, and dissemination of EDI information using ANSI ASC X12 and EDIFACT Standards.
- Provide functional specifications and documentation for business solutions.
- Developed business processes to connect to VANs & trading partners to send/receive EDI transmissions.
- Working on communication protocols like FTP, FTPS, SFTP, AS1, AS2, AS3, and VAN.
- Working on transforming data between formats: XML, delimited or fixed- format files.
- Communicate with managers and business stake holders on project statuses.
- Designed and developed EDI interfaces with the follow EDI documents, 850,860, 855, 856, 810, 846, 867, 997, ORDERS, ORDRSP, INVRPT, DESADV, INVOIC, SLSRPT, CONTRL, IDoc, Flat File, CSV, XML.
- Daily checking Project tracking using tools like JIRA, MS Project.
- Analyzed the existing maps for data input and output requirements and created detailed logical map documents (mapping guides).
- Provide project turnover documentation to the development team, including data mapping specifications.
- Preparing requirements documents and influences business decisions that lead to the right solutions.
Confidential, IL
EDI Analyst / B2B & Supply Chain Management
Responsibilities:
- Involved in full-life cycle software development for mid-size to complex projects by performing requirements analysis and testing.
- Gather, analyzes, and documents business requirements to support the design and development of technology and/or process solutions.
- Responsible for creating basic and Advanced Trading Partner profiles and Management of communities.
- Migrated maps from Gentran on Linux to GIS on Linux.
- Worked with Visual mapper.
- Worked with Data Managers and patterns in Gentran Server.
- Developed the maps in GIS.
- Trading Partner setups in GIS.
- Reviewing the Test Data 810, 846, 856, and 855 received from trading partner.
- Sending Test Data such as 830e, 862, 850, and 860 to Trading partner.
- Co-ordination with the Business Teams during the entire project.
- Performing Unit Testing and Regression testing.
- Developed mapping guides for all the suppliers.
- Re-Testing with all the suppliers in GIS.
- Monitoring Error data folder for purged documents at VAN.
- Post Production Support.
- Expertise in SMI Testing.
- Expertise in END to END testing with suppliers.
- Developing Maps in GIS according to the Trading partner specifications.
- Quality and Unit Testing for Maps in GIS Development environment.
- Deploying of the Maps in Quality environment.
- Deploying Maps in GIS Production.
- Trading Partner Setup.
- Monitoring the Maps in Live Environment.
- Working on Overdue transactions and Rejected 997s.
- Monitoring of Inbound and outbound supplier and customer Transactions.
- Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
Environment: Gentran Server Linux (6.0), EDI TEXTPAD, EDI Transactions (EDI documents, 830, 850,860, 855, 856, 810, 846, 867, 997, ORDERS, ORDRSP, INVRPT, DESADV, INVOIC, SLSRPT, CONTRL), Oracle, Toad, PL/SQL, Beyond Compare.
Confidential, WA
EDI Systems Analyst/Developer
Responsibilities:
- Responsible for setting up of new Trading partners and configuration.
- Responsible for developing new maps according to the customer requirement and perform end-to-end testing.
- Created new Code List based on the customer requirements.
- Responsible for Trouble shooting Mapping errors.
- Coordinated with the customers to analyze requirements for implementation guide. Analyzed the business requirements, functional specifications, system requirements process flows and test specification documents.
- Analyzed, designed and developed Inbound and Outbound Interfaces for various transactions.
- Responsible for Unit testing for Map’s created for the new partners in Map Editor.
- Tested various EDI files and made sure they are loaded to Oracle System.
- Generated manual reports for missing Acknowledgments.
- Prepared Trading Partner Onboarding document.
- Involved in setting up HTTP, FTP, FTPS communication protocols.
- Prepared EDI Test cases for testing team.
- Assisted Project manager in creating Project Plan.
- Got Trained on EDI systems.
- Loaded files from Trading Partner FTP site to Gentran EDI system.
- Used TOAD to look up at Oracle Tables for testing purpose.
- Restarted test EDI environment server during maintenance phase.
- Got Trained on handling Production issues for client.
- Documented each interface with detailed design documents, which include interface Architecture description, Interface flow diagram, Interface description, Mapping specifications, Mapping rules, File formats and Test conditions.
Environment: Gentran Server for Windows v5.1, Oracle, TOAD, FileZilla, Putty, Red Hat Linux, GIS 4.0, UNIX, AS2, VAN, FTP, SFTP, ANSI X12.
Confidential, NC
Jr. EDI Programmer / B2B sterling Integration consultant
Responsibilities:
- Onboard trading partner to EDI and AS2.
- Develop complex maps based on customer specifications.
- Work with ANSI X12 HIPAA transactions like 834, 835, and 837.
- Worked with Database and xml mappings.
- Created flat file definitions and transforms to test maps.
- Worked with Typing maps to handle partners with flat file processing.
- Work with SI Resource manager to export/import maps from test to production after successful end-end testing.
- Experience with various EDI standards and translators: ANSI X12, EDIFACT.
- Working on SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
- Implementation of B2B (EDI) Integration.
- Monitor business processes for AS2 send/receive errors.
- Work in EDI/GIS/SI support on rotational basis.
- Participating in meetings with respect to new implementation with the customer.
- Perform system health check once every day.
Environment: Gentran Integration suite 4.3, Sterling Integrator 5.2, JIRA, HIPAA 5010, Sterling, Connect Direct, GPM, SAP, UNIX, Oracle