Edi/sterling Integrator Consultant Resume
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.