We provide IT Staff Augmentation Services!

Edi/sterling Integrator Consultant Resume

3.00/5 (Submit Your Rating)

Framingham, MA

SUMMARY

  • Over 8 years of experience in Information Technology Industry wif 5 years of strong technical experience as EDI Developer wif a background in analysis, design, development and implementation on different EDI technologies like Sterling Integrator, Gentran Integration Server.
  • Well versed in complete software development life cycles which include design, development, testing and production
  • Excellent knowledge on various communication protocols like VAN, FTP, SFTP, AS1, AS2 and HTTP/S and hands on experience on implementation of AS2, FTP, SFTP.
  • Experience in various domains like Healthcare, Logistics, Supply Chain, Retail, Transportation and Manufacturing.
  • Strong technical knowledge, wif hands - on experience developing EDI maps wif IBM Sterling Integrator 5.2.x.
  • Excellent understanding about EDI standards including: ANSI X12, EDIFACT, RosettaNet, Odette, VDA & TRADACOMS.
  • Experience in creating new maps using X12, EDIFACT, SAP IDOCs, Delimited (CSV), XML and Flat File formats in SI/GIS.
  • Thorough understanding of IBM Sterling File Gateway, IBM Control Center, Sterling Secure Proxy, IBM Perimeter Server.
  • Experience wif XML, xCBL, cXML, XSLT, and XPath, XSD/DTD.
  • Experience in using B2B Frameworks like FMI and DMI tools.
  • Good understanding and development experience in Sterling Graphical Process Modeler (GPM), Business Process Modeling Language (BPML) and knowledge on adapters and services.
  • Strong experience into SI Map development & debugging
  • Experience in ANSI X12 EDI Transactions like 204,214,210,990,810, 820, 824, 840,843,850, 855, 856, 860,867,997,834,835, 837 and UN/EDIFACT Transactions like ORDERS, INVOIC, CONTRL, ORDRSP etc.
  • Extensive Experience in integrating Trading Partners into SI (Deployment of Maps and Trading Partner Setups).
  • Experience in working wif web services in sterling integrator.
  • Hands on experience in maps - EDI-EDI, EDI-XML, Flat-file-XML maps, cXML-Flat-file maps, xCBL-Flat-File maps, XML-IDOCs, JDBC Map (SQL Maps).
  • Developed Trading partner profiles for teh application, inbound and outbound translation objects.
  • Created Trading partner envelopes for inbound and outbound maps for all EDI standards.
  • Daily checking Project tracking using tools like JIRA, MS Project
  • Experienced writing SQL queries in Oracle, SQL Server, MySQL and IBM DB2.
  • Good experience on troubleshooting Business Process and map translation failures.

TECHNICAL SKILLS

Mapping Tools: Sterling Integrator (5.2.x), Gentran Integration Server (4.2), EDI/HQ

EDI Standards: ANSI X12, EDIFACT, RosettaNet, Odette, VDA & TRADACOMS

EDI Transaction Sets: 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.

Communication Protocols: VAN, FTP, SFTP, AS1, AS2 and HTTP/S

Other Software: Text pad, Ultra edit, EDI Notepad, Beyond Compare, Remedy Tool, FileZilla

Operating Systems: Windows 98/2000/XP/, Windows 7/10, Linux

Configuration Tools: VSS, SVN, GitHub

Web Technologies: Web Services, XML, HTML

Databases: Oracle 9g/10i/12c, SQL Server, DB2, DB/400

Project/Test Management Tools: ALM, JIRA, RTC, Test Link

Programming Languages: C, C++, C#, Java, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential

EDI/Sterling Integrator Consultant

Responsibilities:

  • Involved in onboarding new customers
  • Translated teh data from ANSI X12 to text format in inbound process using teh SI Mapper
  • Created Trading Partner profiles and Management of Communities in SI 5.2
  • Created end to end trading partner set up using SI
  • Developed Maps for several customers which include 204,990,997,214,210.
  • Involved in creation of envelopes in Sterling B2b Integrator for different customers based on Set up documents.
  • Worked wif business and different team in resolving missing ASN, incorrect Invoices.
  • Created new Code lists based on teh customer requirements.
  • Worked on different maps to convert from X12 to CSV, XML, Positional
  • Created teh Enveloping for trading partners using Quick Start Service (QSS) in Sterling.
  • Developed Generic and Trading Partner Specific business process.
  • Responsible for trouble shooting teh Business Process models in application connectivity.
  • Worked wif Sterling B2b AS2 related issues like certificate expiry, connectivity issues
  • Creation of trading partner files/interfaces.
  • Worked on testing end to end trading partners.
  • Monitoring teh GIS/SI (Sterling integrator) Dashboard to ensure teh Processing is normal and involved in trouble shooting teh issues.
  • Involved in supporting production issues
  • Checking teh connection issues using FileZilla.
  • Created and modified code lists on server side as well as in GIS Map Editor

Environment: Windows7, Sterling Integrator 5.2.x, Sterling Order Management, Sterling File Gateway, FTP, AS2, VAN, Sterling Connect Direct, SAP, Map editor 8.0

Confidential, Framingham, MA

EDI/Sterling Integrator Consultant

Responsibilities:

  • Interacting wif clients to get teh requirements and analyzed them and documented them.
  • Conducted meetings wif Business users, SME's, Technical Experts and developers to gather, document and clarify requirements.
  • Worked on EDI ANSIX12 standards and Transactions like 810,820,834,850,855,856,997,999
  • Involved in talking to customers and on-boarding them using different protocols
  • Performed Communication set ups for Trading Partners using Protocols like FTP/HTTP/AS2.
  • Developed maps to convert from X12 to XML, SAP IDOC, Flat files format.
  • Executed several SAP Transactions like WE07, WE20, WE21, WE47, WE60, SM59 and SM58
  • Prepared Mapping Requirements Specification Documents.
  • Prepared System Requirements Specification, Technical specification, Gap Analysis and Test plans.
  • Preparation of Test case documents for testing Maps.
  • Created Dummy data for testing maps.
  • Developed Guidelines using TIBCO EDISIM
  • Worked wif different trading partners in setting up Orders, Invoice, Advance Ship Notice,
  • Created Inbound/Outbound Business Process wifin Sterling B2B Integrator using GPM and BPML
  • Developed several maps to load teh files into Transport Management, Order Management, Ware house management Systems.
  • Developed SQL queries to generate reports from SI Database to end management users.
  • Created new Code lists based on teh customer requirements in EDI and SAP
  • Setting up AS2 connections wif customers via BIZCONNECT and worked on testing teh connectivity
  • Responsible for trouble shooting teh Business Process models in application connectivity.
  • Involved in configuring different services and adapters in Sterling B2b Integrator
  • Used different Services and Adapters like CLA/FTP/File System/Mailbox/SAP etc.
  • Performed end to end testing of EDI process
  • Worked closely in migration of Legacy system testing
  • Created mailboxes and routing rules for Trading Partners.
  • Involved in setting up of Producers and Consumers in Sterling File Gateway
  • Developed Static and Dynamic Routing Channel Template in Sterling File Gateway
  • Monitored file transfers in Sterling Connect Direct.

Environment: Sterling Integrator 5.2, Sterling File Gateway 2.2, Sterling Connect Direct, SAP, Map editor 8.0, FTPS, AS2, HTTP, VAN, PGP

Confidential, Eagan, MN

EDI/Sterling Integrator Consultant

Responsibilities:

  • Created FTP, AS2, connections /configurations using IBM sterling wif teh trading partners based on their requirements.
  • Create teh connection setups in test environments and perform end to end testing to get teh files transferred successfully.
  • Communicate wif teh business users and perform end to end testing wif teh clients
  • Migrate all teh changes to teh Production on successful completion of end to end testing in test Environment.
  • Involved in coordinating and resolving teh issues/tickets from mailbox team raised by teh end clients during their transfer process.
  • Implement SSL certificates required for teh secure transfer communication.
  • Analyzed and reviewed test data files and test scripts for teh HIPAA 4010 /277 PEND, RFAI, 837,835 and 834 transactions.
  • Worked wif creating companion guides for HIPAA 837, 834, 835 and 276/277 HIPAA 5010 transaction.
  • Used EDIFECS spec builder to manage claim transaction and billing application requirements. Mapping teh requirements onto teh implementation guide development and development of test cases for each transaction.
  • Translated teh data from XML to X12, text and excel formats in outbound process for 266 and 820 using teh Sterling B2B Integrator Map Editor
  • Validated teh 824 and 811 files received in response to teh 266 processes.
  • Created Trading Partner profiles and Management of Communities in SI 5.2
  • Involved in on boarding Trading Partners into Sterling File Gateway
  • Sending an acknowledgment (EDI X12 997 Functional Acknowledgment) to teh trading partners.
  • Worked closely wif EFT(FTP) Network team to resolve connectivity set up issues and file transfer issues
  • Created new Code lists based on teh customer requirements
  • Created teh envelopes for different trading partner transactions.
  • Responsible for trouble shooting teh Business Process models in application connectivity
  • Provide Production Support for teh maps developed in Sterling Integrator and Involved in fine-tuning teh maps to increase teh performance.
  • Worked wif QA team to get validate teh test files dat processed through SI.
  • Interact wif clients, Business and EDI team on weekly status meetings to define business rules and convey teh Implementation guidelines.
  • Created mailboxes and routing rules for Trading Partners.
  • Worked wif EDI Portal team for teh system generated test files.
  • Involved in automation of business processes to get teh files processed in production and transmit to connect Direct.
  • Created Dummy XML data for testing maps and Performed end to end testing of EDI process

Environment: Sterling Integrator 5.2.4, EDIFECS Spec builder, Sterling Connect Direct, Map editor 8.0, FTP, SMTP, AS2, HTTP, VAN, PGP, Windows XP/2007, BPML, XML, Xpath, VB Script, Ultra Edit, XML Notepad 2007, PGP encryption, EDI Portal, MS Office

Confidential

Software Test Engineer

Responsibilities:

  • Identified teh requirements for accommodating HIPAA 5010 standards for 837P transactions and captured these requirements to develop new GUI for teh internet based application.
  • Participated in setting up testing environment.
  • Involved in preparing Test Cases based on business requirements.
  • Tested HIPAA Transactions and Code Sets Standards such as 837/835, 270/271, 276/277 transactions.
  • Tested 837/ 835, 270/271, 276/277 transactions wif File Aid.
  • Responsible to check whether teh interfaces and teh extensions properly integrate wif teh Facets application.
  • Involved in testing HIPAA EDI Transactions.
  • Authored and executed Test cases for Claims and Customer Service Workflow by manually.
  • Responsible for writing teh Test Cases and Test Scenarios based on teh Functional Specification and technical Specification and documented in Quality Center.
  • Performed Manual Testing and regression testing after new feature was added.
  • Migrated data from DB2 environment to SQL Server
  • Created test scenarios and tested HIPAA Transactions and Code Sets Standards such as EDI 837/834/835, 270/271, 276/277.
  • Responsible for Back-End Testing Using SQL Commands using TOAD.
  • Perform functional, exception and scenario testing.
  • Logged teh errors, reported defects, determined repair priorities and tracked teh defects until resolution using Mercury Quality Center.
  • Extensively used SQL statements to query teh Oracle Database for Data Validation and Data Integrity.
  • Executing SQL commands performed back-end testing.
  • Executed SQL statements to check if teh data integrity has been maintained.
  • Created SQL queries for data validation.
  • Responsible for performing System and integration testing for release.
  • Identified, analyzed and documented defects, error and inconsistencies in teh application using Quality Center.
  • Created and maintained Test Matrix and Requirement Traceability Matrix and performed GAP Analysis.

Environment: MS Visio, Word, Excel, CMMI, TFS, Facets, Clarity, SQL, DB2, Oracle, J2EE, Java, EDI, Quality center.

We'd love your feedback!