Sr. Edi-sap Analyst Resume
Phoenix, AZ
SUMMARY
- Over 7 years of experience in business analysis, planning, design, implementation, testing and maintenance of EDI applications. Highly familiar with understanding all phases of project development life cycle using standard methodologies including business and logical analysis, design, and development of software applications.
- Designed, developed new different inbound and outbound ANSI X12 Order, Invoice, ASN maps and few XML maps from scratch and also changed some existing maps.
- Created Specs (MRF's) from scratch consulting customers on what they need and implementation guidelines
- Build, test and deploy new maps intoSterlingintegratorproduction environment. Developed 850,856,810,880's, 940,846,944,204,210 and 875 maps, implemented changes to existing maps like 824,856,888,214's.
- Written extended rules and different logics on maps for both Purchase orders, Invoices, Logistics (Supply chain) and Purchase Order acknowledgements to IDOC format and vice - versa.
- Worked on EDI Upgrades and Migration Project.
- Created inbound and outbound flow for all TP's using AS2 andsterlingcommunications, and configured envelopes.Extensive Knowledge on B2B integration, production support, testing, implementation, and documentation of information systems. B2B Integration using Sterling Integrator 5.0,5,1,5.2, GIS 3.0, 3.1, 4.0, 4.1, 4.2, Gentran Server 5.1, 6.0, 6.1.
- Good experience in - trading partner setup / on-boarding, mapping specifications and documentation, troubleshooting, problem resolution, customer / vendor / internal customer data issue resolution, interface development for import / export of EDI data.
- Strong experience in developing transaction sets in EDI, data mapping and data conversion across like Healthcare, Banking, Logistics, Distribution, Finance, Material management applications.
- Demonstrated proficiency in EDI ANSI X12, X12N/HIPAA & EDIFACT standards. Experienced in HIPAA -Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
- Experience in defect tracking tools like HP Quality Center, Service now and TIBCO Edisim, FileZilla
- Extensive knowledge on different transaction codes used in SAP
- Experience IN GXS TG/EG, WebMethods, SAP R3, Putty,
- Experienced in Data Mapping and Data Conversion using Gentran, GIS/SI and EDIFECS tools.
- Experience in Sterling File Gateway (SFG), file transfer protocols i.e. FTP/SFTP, HTTP, and AS2.
- In depth knowledge of mapping SAP and non-SAP applications to a variety of EDI layouts
- Strong Knowledge of different communication protocol such as AS2, HTTP, HTTPS, FTP, and IBM VAN.
- Implementation of new software, upgrades and the regression testing before migration to production.
- Good knowledge in Oracle RDBMS with proficiency in writing SQL queries and PL/SQL procedures.
- Extensive experience in SDLC, Business Application Infrastructure Support, Release Coordination, Project Planning & Implementation from Gap Analysis till Cut-over Support
- Excellent business knowledge, ability to work under pressure and good interpersonal skills, result-oriented team player with an ability to manage multiple tasks simultaneously
TECHNICAL SKILLS
EDI Translators/BP Engines: Gentran Integration Suite 4.2/4.3, Gentran Server 5.3, Sterling B2B Integrator 5.0/5.2, 6.0,6.1, Business Plugins), EDIFECS Specbuilder, Transaction Manager, Sybase EC Map/EC Gateway, Sterling File Gateway (SFG), GXS AI Mapper(Workbench), Web Methods
EDI Standards: EDI X12(ANSI), EDIFACT, HIPAA, XML, Rosettanet, HL7, ICD 9/10
Communication Protocols: FTP, HTTP, SFTP, HTTPS, AS2, VAN, TCP/IP, PGP, SMTP, SNMP, IMAP, JMS, SAP Suite Adapter, SQL*Plus, SQL Loader, MS Visio 2000.
EDI Transaction Sets: ANSI X12 810, 812, 820, 824, 830, 831, 832, 834, 835, 837,204,214, 270/271, 276/277, 210, 214, 220, 323,850, 852, 855, 856, 844, 845, 846, 857,860,861,864, 865, 867, 870,990 and 997
Databases: Oracle 8i/9i/10g/11g, DB2, MS SQL Server 2000/2005, MS Access, MySQL, TOADSAP ECC6.0, SAP R3
Programming Languages: JAVA, SQL, PL/SQL, T-SQL, XSLT, CXML, COBOL, RPG ILE, CL, UNIX Shell Scripting, ABAP, Perl, UML, XML
PROFESSIONAL EXPERIENCE
Confidential, Phoenix, AZ
Sr. EDI-SAP Analyst
Responsibilities:
- Worked on migration project called EVOLVE where company migrated its legacy system called Genesis to SAP.
- Extensively worked on EDI transactions 850,855,856,810,820,860,865,867,870,832,834,846,997,999 etc.
- Worked on inbound and outbound SAP IDOCS for various transactions.
- Validating the new maps and outputs generated and verified if they are according to the standards using EDISIM
- Responsible for preparing Mapping Requirement Specification (MRS), documentation, trouble shooting, problem resolution and internal vendor/customer data issue resolution.
- Experienced in SAP EDI configuration including IDOC workflow. Proficient in SAP IDOC formats, troubleshooting various issues related to status codes and data in SAP using various T-codes like WE02, WE19, SE16n, and ME23n
- Gathering business requirements and articulating them into EDI Mapping Spec for integration with SAP.
- Coordinated with the Business team for the proper development of the functional specifications and worked closely with super users in Unit testing, IT testing, Business Testing and UAT once the development is completed.
- Analysis and Resolution of various GXS TG-EG/WebMethods/SAP issues and assisting the super users in fixing those issues on a timely basis.
- Testing EDI data from GXS in comparison with WebMethods UDM and SAP IDOC, raising defects on HP Quality Center to fix them.
- Understanding B2B concepts and other document standards like Rosettanet and EDIFACT.
- Responsible for hyper care support activities resolving the maintenance issues
- Providing Post Production Support on a daily basis, monitored the flow of documents and EDI file processing
Environment: GXS TG/EG 3.1, WebMethods, SAP R/3, oracle 11g, UNIX, FileZilla, EDISIM, Putty
Confidential, Herndon, VA
Sr. Edi Developer/Analyst
Responsibilities:
- Developed data models to implement electronic data interchange using ANSI X12, EDIFACT, XML and positional file formats. Performed GAP analysis for EDI mapping;
- Transformed flat files to ANSI X12 and EDIFACT files using IBMSterlingmap editor, designed and developed inbound and outbound data maps.
- Assisted trading partners to track business transactions. Implemented business process using BPML to alert trading partners regarding the success/failure of EDI transactions.
- Configured and implemented Sterling file gateway process, adapters, services, service configurations and protocol setups as per business needs.
- Implemented Sterling File Gateway for the MQ File Transfer and Managed file transfer to move files for back-end applications.
- Worked on 810, 820, 824, 997 and 999 transactions.
- Developed technical specifications for systems development, design and implementation. Met with clients, technical stakeholders and management to analyze and document detailed B2B statement of requirements. Planned, executed, and controlled the project. Involved in identifying scope, time and risk.
- Set up various communication-Protocols FTP, HTTP, SMTP and AS2 with trading partners for exchanging the EDI documents with digital Signature.
- Created maps to translate data from X12 format to web service messages using Application Integration mapper.
- Converted and tested maps generated in Visual mapper to Application Integration Mapper.
- Provide technical support of the EDI application, mappings, and interfaces, and testing.
Confidential, Linthicum heights, MD
Edi Developer/Analyst
Responsibilities:
- Performed data analysis, application file format validation, formatting, Trading Partner setup and mapping.
- Created the implementation guides for different file formats (X12, XML, CSV, Delimiter, Fixed ASCII, Database)
- Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners for multiple transactions inSterlingIntegrator.
- Develop/Modify EDI maps using Gentran Integration Suite/SterlingIntegratorsMap editor.
- Set up various communications using Protocols FTP, HTTP, SMTP and AS2 with trading partners.
- Set up and configured the AS2 communication protocol for exchanging the EDI documents for trading partners with digital Signature.
- Worked on Migrating Communication setups (AS2, FTP), Envelopes and Maps from GIS 4.3 to SI 5.2.
- Translating the data from ANSI X12 to text format in inbound process using the translator.
- Created and modified BPML to handle document archiving, failure notifications, acknowledgement reconciliations, and transaction metrics reporting.
- Developed various maps for both EDI transactions and non EDI interfaces.
- Created various routing rules and mailboxes for both inbound and outbound transaction sets.
- Converted and tested maps generated in Visual mapper to Application Integration Mapper (AI Mapper).
- Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc.
- Created test plans for load and performance tests with twice the daily EDI volume
- Responsible for analyzing, designing, implementing, testing, monitoring the changes and moving those changes to Production.
- Involved in production support, trouble-shooting the day to day issues of the application.
Confidential, Bloomington, IL
EDI Developer/Analyst
Responsibilities:
- Developed the Mapping specification documents with the help of the business team.
- Extensively worked on developing and testing the Transportation management system documents like 204, 214, 210, 990 and 864 for the carriers.
- Created and maintained the partner profiles and the necessary EDPAR and EDSDC tables in SAP.
- Helped in the creation of Business requirement documents (BRD), systems requirement specifications (Technical specifications documents) and X12 mapping specification documents.
- Created the documentation for one to one mapping from the internal layer to the X12 specifications.
- Implemented one to one mapping from data file to EDI file by Map analysis.
- Extended the standard IDOC’s and created the custom IDOC’s in SAP.
- Tested the documents internally with the SAP and EAI layer to make sure the documents are passing to the B2B (Gentran) with all the mandatory values in it.
- Used FTP and AS2 to transfer the files from one place to another. Also setup AS2 communications with customers and suppliers.
- Created generic business processes to zip/unzip, PGP encrypt/decrypt files.
- Configured FTP, SFTP, FTPS adapters.
- Converted the XML files into X12 and X12 to XML files on GIS for sending and receiving the EDI files.
- Also created EDIFACT format files from Flat files and vice versa.
- Modified the existing mappings for ORDERS, INVOICE, DESADV in EDIFACT format.
- Identified the gaps while in the process of internal testing and performed Gap Analysis.
- Fixed the defects which occurred during testing by changing the mappings in Gentran and GIS.
- Coordinated with the business team to analyze and develop different scenarios to test the documents according to those scenarios.
- Done End to End testing with the partners for all the scenarios we have.
- Created Trading partner profiles, new maps and modified existing maps using sterling integrator Map editor and deployed the maps on to GIS.
- Provided production support and monitored the flow of documents on a daily basis.
Confidential, Nashville, TN
EDI Developer
Responsibilities:
- Created inbound and outbound Maps for various transactions using AI mapper as per business needs to convert data from standard internal format to different formats
- Performed data analysis and created Business Process Flow Diagrams Using Visio.
- Responsible for creating technical and functional mapping specs and converting the maps from Sybase EC mapper to AI mapper using Map Editor.
- Experience in Troubleshooting of EDI and IDOC related Errors and creating pride tickets and re-processed the IDOC’s in SAP.
- Involved in the separation of the company’s EDI transactions after company split by implementing divisional code into EDI transaction maps.
- Created and tested break maps for splitting Inbound X12 and ensure that data goes to right departments.
- Also interacted with company’s SAP, WMS and TMS teams for their interaction with Gentran.
- Developed maps for transactions between trading partners and Transportation Management system (TMS) like X12 to OTM Trans orders, planned shipments, shipment status etc.
- Developed maps and processes for transactions involved for Customers interface: Inbound WO ACCEPT (X12 990),Outbound WO CREATE/CANCEL/AMEND (X12 204), Inbound O AMEND ACCEPT/REJECT (X12 990), Inbound APPOINTMENT SCHEDULE/ACTUAL (X12 214), Inbound WO AMEND (X12 204), Outbound WO AMEND ACCEPT/REJECT ACKNOWLEDGEMENT (X12 990)
- ASN (856 EDI document) - Created a process that generates an ASN (856 EDI document) to Customer for a Direct Ship Orders with information from the third party Vendors (facilitated by a Consolidator/Broker/3PL).
Confidential, Saint Paul, MN
EDI Analyst
Responsibilities:
- Implemented HIPAA/EDI Transactions like 834, 835, 837, 276, and 277. Implemented 270/271 Health Care Eligibility Benefit Inquiry and Response transactions.
- Used Edifecs Spec Builder to build, edit and customize the implementation guidelines.
- Managing Membership Enrollments for corporate group accounts and Individual membership accounts and Coordinating with Claims & ITS team.
- Performed Unit and system testing on all EDI transactions both inbound and outbound.
- Involved in dealing with trading Partners and conveying the implementation guidelines and specifications.
- Worked on 270/271 (Eligibility Request & Response) for different clients in EDI Translations, Requirements analysis in different segments and Elements that are required to send to the clients within the HIPAA regulations.
- Created specs with EDIFECS spec builder for all the trading partners.
- Worked on integration with new trading partners using Gentran server for UNIX 5.3.
- Modified maps to support newer versions and upgraded from Gentran 3.2 version to Gentran 5.3 version.
- Created/modified trading partner setup.
- Provided Production Support for the maps developed in Gentran.
- Maintenance of EDI Documents, data managers, and Gentran life cycle Database.
- Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
- Worked on Sending and receiving the files through Communication protocols like HyperTerminal, Files Encryption, Decryption, creating and sending password protected files.