Edi Developer/analyst Resume
Philadelphia, PA
SUMMARY:
- Around 7 years of experience in EDI and worked as EDI Developer/Analyst with comprehensive experience in Multi divisional corporate EDI Environments.
- Experienced in Retail, Healthcare, Logistics, Manufacturing, and Supply chain industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Production Support.
- Experience in B2B standards, Implementation of Integrated EDI applications and Enterprise Application Integration (EAI) for Business process across applications.
- Expertise in various Mapping transaction sets like EDI, Positional, IDOC, CSV, Flat File, Variable - Length-Delimited, XML and SQL.
- Strong experience in Migrating Trading Partner setups with Communications setups to Sterling B2B Integrator (GIS), Gentran Server for Windows.
- Extensive experience in development of maps with various EDI standards like ANSI X12, EDIFACT, IDOCs, HIPPA, ROSETTANET and TRADACOMMS.
- Expertise in EAI tools WebSphere Transformation extender (WTX) 8.1 & 8.2 and IBM WebSphere Message Broker (WMB) 7.0.
- Proficient with different translation tools like SI Map editor, SEEBURGER BIC MD and WTX Editor.
- Strong hands on ANSI X12 EDI transactions like 834, 835, 837, 850, 855, 856, 810, 820, 816, 860, 865, 875, 880, 945, 940, 997, 204,210, 404, 410 including others.
- Worked on EDIFACT EDI transactions like ORDERS, ORDRSP, DESADV, INVOIC and REMADV among others.
- Expertise in working on SI applications component IBM sterling B2B file gateway, Sterling B2B Control Centre and Sterling Connect: Direct.
- Hands on experience in using various adapters like File schema, XML, Database, Email, FTP etc.
- Experience on Inbound and Outbound transaction sets with both 4010A and 5010A HIPPA versions.
- Expertise in business process for both Inbound and Outbound transactions to SAP and other internal applications as per business needs using Graphical Process Modeler (GPM) and BPML in Gentran Integration Suite/Sterling Integrator.
- Good Knowledge on B2B integration, production support, testing, implementation and documentation of information systems. B2B Integration using Sterling Integrator 5.2.
- Hands on XML, XSD, XPATH, XSLT and other internet related technologies.
- Experienced writing SQL queries in Oracle, MySQL and IBM DB2.
- Worked on Production Support team and resolved Production issues.
- Extensive experience with Object Oriented Design and SDLC and AGILE methodologies.
- Daily checking Project tracking using tools like JIRA, MS Project.
- Excellent communication skills and written skills.
TECHNICAL SKILLS:
EDI Tools: Gentran, Gentran Integration Suite, Sterling B2B Integrator, Sterling File Gateway, Sterling Connect Direct, Sterling Control Center, Globalscape, MFT, Lightwell, GXS, EDIFECS SpecBuilder, EDIFECS TM, EDIFECS XEngine, XE server, BizTalk, Invois, TLE Products.
EDI Standards: ANSI X12, EDIFACT, HIPPA, TRADACOMS, NCPDP, ODETTA, ROSTTANET.
Data Formats: X12, XML, HIPPA, FLAT FILES, EDIFACT, .CSV.
ERP: SAP, Oracle EBS, IBM Mainframes, JD Edwards, Lightwell.
Database: MS SQL Server2000, 2005, 2008, IBM DB2 9.5, 9.7, Oracle 9i, MS Access 07, 10, 13.
Operating Systems: Windows (XP, 7), AIX, Red Hat Linux, SuSE, HP-UX
Protocols: FTP, SFTP, SMTP, HTTP/S, AS2, VAN.
PROFESSIONAL EXPERIENCE:
Confidential, Philadelphia, PA
EDI Developer/Analyst
Responsibilities:
- Analyzed Business data of the Trading Partners and developed a common specification for inbound and outbound transactions.
- Interacted with trading partners and creating standard specifications for various transactions for both inbound and outbound using ANSI X12
- Created new maps and Custom Maps for various transactions using Sterling Integrator/WTX for both inbound and outbound transactions.
- Migrated from Legacy maps to advanced vision maps.
- Predominantly involved in creating maps of various transaction sets including Inbound and Outbound: 810, 820, 830, 832, 850, 855, 856, 860, 862, 875, 940, 944, 945, 947 and 997.
- Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound.
- Created Dynamic and Static routing templates to route files to different Mailboxes.
- Created new mailboxes and applied mailbox routing rules.
- Experience in Validation and Sanity Testing of EDI X12 to XML data.
- Worked on different communication protocols such as HTTPS, HTTP, FTP, SFTP, IBM VAN and AS2.
- Installed and configured Sterling File Gateway and Sterling Connect: Direct in all environments. Created partner profiles, routing templates and routing channels in SFG.
- On boarded new partners using SFG (Sterling File Gateway).
- File Transfer connectivity testing between OMS and MFT servers.
- Management of MFT automation jobs including maintenance and patching.
- Performed Unit Testing and Framework Testing to test the functionalities.
- Experience in Map Errors Controlling and Trouble Shooting.
- Proficiency in Troubleshooting of XML Errors.
- End to end regression testing and migration testing of Envelopes, Maps, Business Process, XSLT codes, EAI infrastructure and Trading Partner communication protocol setup.
- Work on technical architecture requirements definition, design, migration and deployment to test and production environment for User Acceptance Testing (UAT).
- Provide Production Support for the maps developed in Sterling Integrator.
- Creation an execution of test data and test plans. Involved in unit, functional and integration testing.
Environment: s: IBM Sterling Integrator, WTX, Windows 7, FTP, SFTP, HTTPS, SSH, SSL, XML, Sterling File Gateway, MS SQL Server, EDISM, IBM OMS, FileZilla, Ultra edit
Confidential, Deerfield, IL
EDI Analyst/Developer
Responsibilities:
- Analyzed Business data of the Trading Partners and developed a common specification for inbound and outbound transactions.
- Interacted with trading partners and creating standard specifications for various transactions for both inbound and outbound using ANSI X12, EDIFACT standards.
- Created new maps and Custom Maps for various transactions using Gentran Integration Suite/Sterling Integrator for both inbound and outbound transactions.
- Worked on data mapping and data conversion using GXS and Sterling Integrator.
- Migrated from GXS to Sterling Integrator.
- Predominantly involved in creating maps of various transaction sets including Inbound and Outbound: 810, 820, 830, 832, 850, 855, 856, 860, 862, 875 and 997.
- Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound.
- Created Dynamic and Static routing templates to route files to different Mailboxes.
- Created new mailboxes and applied mailbox routing rules.
- Experience in Validation and Sanity Testing of EDI X12 to XML data.
- Created Business Process for both inbound and outbound transactions routing to Sterling OMS as per customer requirements.
- Worked on different communication protocols such as HTTPS, HTTP, FTP, SFTP, GXS VAN and AS2.
- Installed and configured Sterling File Gateway and Sterling Connect: Direct in all environments.
- Developed Routing Templates and Routing Channels in Sterling File Gateway and associated Procedures and Consumers.
- File Transfer connectivity testing between OMS and MFT servers.
- Management of MFT automation jobs including maintenance and patching.
- Created Test cases, Test scripts as per the design documents (both Functional and Technical Designs) and Coordinating Quality Center with QTP as per the design document.
- Performed Unit Testing and Framework Testing to test the functionalities.
- Experience in Map Errors Controlling and Trouble Shooting.
- Proficiency in Troubleshooting of XML Errors.
- End to end regression testing and migration testing of Envelopes, Maps, Business Process, XSLT codes, EAI infrastructure and Trading Partner communication protocol setup.
- Work on technical architecture requirements definition, design, migration and deployment to test and production environment for User Acceptance Testing (UAT).
- Developing SQL query scripts to check the database automatically and checking the data integrity in accordance with business standards of the company.
- Provide Production Support for the maps developed in Sterling Integrator.
Environment: Sterling Integrator 5.2/5.4, Ultra edit, Microsoft Visio, Windows 7, FTP, SFTP, HTTPS, SSH, SSL, XML, GXS, Sterling File Gateway, Sterling Connect: Direct, MS SQL Server, EDISM, IBM OMS, FileZilla.
Confidential, Norwood, MA
Sr. Business Analyst/ EDI Developer
Responsibilities:
- Analyzing Functional Specifications and mapping sheets and creating maps in Sterling Map Editor based on the specifications according to Project standards.
- Developed the IBM WTX Software using the Map Designer, Integration Flow Designer and Type Tree builder.
- Hands on experience of integrating IBM WTX.
- Analyzed the existing Gentran maps.
- Worked on EDI ANSIX12 standards and Transactions like 840,843,850,855,856,810,820.
- Developed several different maps to convert from ANSI X12 to .CSV, XML, SAP IDOC, Flat files and vice versa.
- Developed EDI maps using Sterling Integrator’s Map editor.
- Developed several different business processes using different Services and Adapters using both GPM and BPML.
- Implementation of File Transfer Processes.
- Migrated existing AS2, SFTP partner’s communications to SFG.
- Created trading partner profiles, envelope setups and communication setups like (using protocols FTP, SFTP).
- Worked with Trading Partners in suggesting the best method of File Transfer mechanism and configured them.
- Created partner profiles, routing templates and routing channels in SFG.
- On boarded new partners using SFG (Sterling File Gateway).
- Customized generic SFG business process to enhance the functionality to meet different partner requirements.
- Complete understanding of Managed File Transfer.
- Worked on Sterling Connect: Direct for securely transferring of files.
- Imported Certificates from Trading Partners in Sterling Secure Proxy.
- Created Pnodes/Snodes in Sterling Connect: Direct.
- Worked with functional users and user groups to gather, refine and document system requirement to enhance IBM Mainframes.
- Involved in Production Support monitoring daily transactions, notifying appropriate team and troubleshooting them.
- Reviewed Database lock as part of SI Tuning.
Environment: IBM WTX, Gentran, Sterling B2B Integrator, Sterling File Gateway (SFG 2.2), Sterling Connect Direct, Sterling Secure Proxy, IBM Mainframes, FTP, MFT, Sterling Control Center, ANSI X12 and IDOC
Confidential
Sr. Business Analyst/ EDI Developer
Responsibilities:
- Mentored team members on preparing implementation guides standardization and maintaining mapping practices.
- Followed the Agile Methodology Process throughout the project and all artifacts are generated for each discipline.
- Loaded 837 into the database system for the auditing purposes.
- Day to day activities were to monitor claim submissions, provide guidance on 999s/TA1 errors.
- Created 5010 Companion guides for HIPPA EDI transaction sets up and step down from versions.
- Created various segment levels in the map using companion guides.
- Analyzed and reviewed test data files and test scripts for the HIPAA 5010 276,277, 837,835,834, TA1 transactions.
- 837 encounter reconciliation/ audit report to the CMS.
- Have a created 837 encounter for the 835-claim payment sent to TP.
- Creating and executing test cases for 277, 834, 835, 837 transactions using HP Quality Center 10.0
- Worked with creating companion guides for HIPAA 837, 834, 835 and 276,277 HIPAA 5010 transactions.
- Translated incoming ANSI X12 files into X12, Text files, Xml files and various other formats.
- Used EDIFECS Spec Builder to manage claim transaction and billing application requirements.
- Involved in creating and the customization of the test data by using the EDIFECS Spec Builder.
- Involved in setting up Company profile and trading partner information.
- Developed EDIFECS Routes for FTP and SFTP communication to automate EDI process.
- Monitored UNIX scripts to make sure files are pulled from FTP.
- Creating reports that can be auto-generated and delivered directly to internal users and external partners by using EDIFECS Transaction Manager.
- Involved in downloading the new versions of Patches, Hotfixes and new standard versions of EDIFECS and updating it to all environments.
- Involved in loading the translated files to FACETS systems.
- Involved in debugging and maintaining EDI process through X Engine Server (XES).
- Developed SQL Queries to access Oracle database to make sure data.
- Proficiency in use of HP quality center for performing integrated quality testing.
Environment: EDIFECS 6.5 Spec Builder, SQL, Agile methodology, FTP, SFTP, AS2, EDIFECS Transaction Manager, Facets, HP Quality Center, Oracle, EDIFEC XEngine.
Confidential
EDI Analyst
Responsibilities:
- Gathered Business Requirements interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes.
- Participated in various testing related review meetings
- Propose and develop enhancements to existing systems to improve efficiency.
- Responsible for writing user requirement documents and test scripts.
- Responsible for generating XML Schemas, complex maps and designing orchestrations
- Major tasks involved are setting up the Trading/Partner relationships, creation of User File Definitions, Translation Formats.
- Created maps using MAP EDITOR to convert data from ANSI X12 to XML, SQL, FLAT File, SAP IDoc formats and vice versa as per business needs for 810,850,855,856
- Developed test data to test EDI maps.
- Set up and configured the AS2 communication protocol for exchanging the EDI documents for trading partners with digital Signature.
- Coordinating with the customers to analyze requirements for Implementation Guide.
- Involved in creating documentation, using Microsoft Excel, of all existing maps to facilitate future changes.
- Involved in unit testing and system testing during the shift over to the production environment.
- Created and documented test plan & detailed test procedures for the application
Environment: Gentran, SAP, EDI ANSI X12, EC-Gateway, MS Visio, MS Outlook.