SUMMARY:

Strong IT Professional with about 7+ years of IT experience in B2B EDI Integration with ERP applications by using Sterling Integration Suite, GIS & Gentran 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. Extensive experience in developing transaction sets in EDI and data mapping and data conversion across like Manufacturing, Healthcare, Banking, Logistics, Distribution, Finance, Material management applications.

CORE COMPENTENCIES:

• Business Process Development (BPML)
• B2B Trading Partner /Vendors On - boarding
• Map Development
• Services and Adaptors Configuration
• Communication Protocols
• HIPAA 5010 Compliance
• Mailbox Configurations, Security Encryptions
• Sterling File Gateway, MFT, AFT
• Sterling Integrator 5.2 /5.0 Sterling File Gateway EDIFECS Spec builder
• Gentran: Server for Windows BizTalk Mapping & Orchestrations EDI ANSI X12, XEngine
• Gentran: Server on Unix 5.3/6.0 Services & Adaptors Configuration MQ Series
• Gentran: Server Workstation PGP & FTP Encryption/Decryptions Web Services
• EDI Map Development GXS AI, Mapper (Workbench) Java, J2EE, Struts, JSP
• BPML, GPM & BPEL XML, XSLT, XSD, WSDL, HTML True Commerce
• AS2, FTP, VAN, HTTP, HTTPS, SFTP Sybase EC Map, Connect: Direct Troubleshooting
• GIS Map Editor, Visual Mapper, Performance Tuning
• EC Map Production Support
• EC Gateway

EDI TRANSACTIONS:

ANSI X12 & VICS: 180, 211, 214, 810, 811, 812, 816, 820, 821, 822, 823, 824, 828, 830, 831, 832, 846, 850, 852, 855, 856, 857, 860, 861, 865, 869, 870, 996, 997.

EDIFACT: ORDERS, ORDCHG, ORDRSP, RECADV, DESADV, INVOIC, APERAK, DELFOR, DELJIT

HIPAA: 837 Claims (Institutional, Dental, Professional), 835 (Claim Payment/Remittance), 834 (Benefit Enrolment), 276 & 277 (Claim Status), 270 & 271 (Patient Eligibility), 278, 999, TA1.

IDOC: ORDERS01, INVOIC01, DESADV01, PEXR2001, SYSSTAT01, YCHKEXTR, TXTRAW01; IDOC message types ORDERS, ORDRSP, ORDCHG, INVOIC, SAP Status Message (EDI DS).

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, AR

Sr. EDI Developer /Analyst

• Created new maps for various transactions using Gentran Integration Suite/Sterling Integrator for both inbound and outbound transactions like 830, 850, 856(Pick and Pack, Standard ASN), 860, 810, 814, 820 and 865.
• Created translation objects (maps) using Sterling Commerce, Gentran Integration Suite versions 5.0 Map Editor which includes EDI to XML; EDI to Application File; Application File to Application File, EDI to/from Database, XML to/from Database, and rules utilizing User Exits.
• Involved in migrating TP’s from FTP to SFTP, SSH, AS2, AS3, HTTP, HTTP/s protocols. TP set up, onboarding new partners, development and QA testing, monitoring business processes and troubleshooting failed processes.
• Responsible for making database connections using Java Database Connectivity (JDBC).
• Extensively used Java IO for reading and writing XML files, logs and error logs.
• Configured partner profiles for both inbound and outbound for various partners.
• Configured and mapped inbound and outbound documents, which included 810, 850, 860 and 832 using Sterling Integrator/Gentran Integration Suite BPs.
• Did performance tuning and enhancement/scalability of Gentran Server.
• Responsible to fix the Production Problems in EDI MAPs by making necessary changes.
• Coordinated protocols AS2, FTP, SFTP).
• Involved in mapping development in various formats like X12, XML, CSV, SQL and Flat File.
• Based on the reports developed around 100 maps. Grabbed test data from the internal applications to test the Application Integrator (AI) maps. Compared NT/Main frame files.
• Created IDOC Extension for Orders05 for Outbound.
• Developed Maps from trading partners to Internal Order Management applications (SAP IDOC’s) in supporting Delivery Order, Goods Receipt, ASN etc.
• Developed PL/SQL scripts for data extraction and automation of SQL*Loader scripts.
• Wrote PL/SQL cursor processing routines, stored procedures and database triggers.
• Wrote complex SQL Scripts to develop transaction visibility across multiple downstream applications.
• Experience in Configuring the Ports, partner profiles, RFC Destination in SAP.
• Implemented SFG (Sterling File gateway) for Various Partners
• Created routing channel templates in File gateway, extensively used static & dynamic routing in sterling file gateway
• Troubleshoot issues within the components of SFG including Integrator, SSP, SFG, and any perimeter servers involved
• Experience in Validation, Testing & Troubleshooting of EDI IDoc Errors.
• Involved in Scheduling and monitoring of SAP Batch Jobs Processing Programs Develop EDI maps and setup relationships using IBM Sterling Integrator 5.2
• Involved in mapping for 850,864,810,820,856,210,214,990,997 Transactions for various trading partners.
• Testing the EDI files for all EDI syntax errors.
• Propose the best solution, get approval from business, plan, develop, test and train users

Confidential, Tampa, FL

SR. EDI ANALYST/ DEVELOPER

• Created new maps for various transactions using EC Map for both inbound and outbound transactions like 834, 837P, 837I, 835, 820.
• Involved in migrating TP’s from FTP to SFTP, SSH protocols. TP set up, on boarding new partners, development and QA testing, monitoring business processes and troubleshooting failed processes.
• Upgraded 834 MAP to translate Month end Membership File received from state.
• Developed the Shell Scripts to Automate the EC Gateway Processes Scripts in UNIX Server.
• Ran QNXT 834 files and moved them to Trading Partners.
• Upgraded 834 MAP to translate Month end Membership Files sent to Plan Partners.
• Created no of 834 maps under various projects
• Translates the X12 Files to Flat file and Load the data into Production and QA Databases.
• Updated the existing maps for various transactions using EC Map for both inbound and outbound for new rules.
• Involved in writing and updating Unix scripts for file movements and delivery from Server to FTP/SFTP servers.
• Involved in Unit Testing of EDI files for all EDI syntax errors.
• Developed maps for different X12 transactions such as 835 Health Care Claim Payment/Advice, 837 Health care claims, 834 Benefit Enrollment / Maintenance, setting up Trading partner profiles for the clients and sending them Functional Acknowledgement 999.
• Involved in migrating TP’s from FTP to SFTP, SSH, AS2, AS3, HTTP, HTTP/s protocols. TP set up, on boarding new partners, development and QA testing, monitoring business processes and troubleshooting failed processes.
• Propose the best solution, get approval from business, plan, develop, test and train users
• Responsible for implementing new EDI transactions and moving into production environment.
• Set up various communication-Protocols FTP, HTTP, SMTP and AS2 with trading partners for exchanging the EDI documents with digital Signature.
• Validated X12 Files using OPTUM/OTVM tool, created .CSV files and created Lookup Lists and Exclusion Lists in OPTUM.
• Created and Managed Input Queues and Output Queues for all TP in OPTUM/OTVM tool.
• Created and managed Routing Queues, Response Queues, Report Queues for all TP in OPTUM/OTVM tool.

Confidential

EDI Consultant

• Involved in Design Business Process in GIS and Sterling B2B Integrator 5.2
• Involved in Upgrade project from GIS 4.3 to Sterling B2B Integrator 5.2
• Created trading partner profiles, envelope setups and communication setups like (using in Production Support activities and Trouble-shooting the day to day issue of the application providing a root cause and fixing it.
• Responsible all phases of EDI operations in a Gentran: Server NT environment, including communications (Sterling VAN, AS2), X12 and EDIFACT mapping, trading partner setup, and coordinating testing and production schedules.
• Setting up new Trading Partner profiles/agreements to facilitate desired EDI flow and pass-through interfaces as well
• Create Communities, Partners, Groups, Routing Rules, Templates, Static and Dynamic Routing Channels and remove special characters from files
• Create PGP Community & process to encrypt outbound documents for some consumers/partner
• Doc-Extract Map to read and remove header records from files and customized file-name/rename
• Create business process to send files directly to partners using SFTP
• Involved in Unit, functional and Integration Testing.
• Converted double mapping processing for the 810, 850 and 856 to a single process cutting total transactions and processing time by 50%.
• Responsible to fix the Production Problems in EDI MAPs by making necessary changes.
• Coordinated protocols AS2, FTP, SFTP).
• Involved in mapping development in various formats like X12, XML, CSV, SQL and Flat File.
• Developed documents of design and mapping specification for the maps.
• Created both inbound and outbound EDI business flows.
• Involved in mapping for 850,864,810,820,856,210,214,990,997 Transactions for various trading partners.
• Testing the EDI files for all EDI syntax errors.
• Propose the best solution, get approval from business, plan, develop, test and train users
• Involved with the customers to analyze requirements for implementation guides.
• Responsible for implementing new EDI transactions and moving into production environment.

Confidential

EDI Analyst

• Mapped X12 transactions 270, 271, 276, 277, 278, 820, 834, 835, 837i, 837p, and 837d and unsolicited transactions (271U, 277U)
• Developed maps for different X12 transactions such as 835 Health Care Claim Payment/Advice, 837 Health care claims, 834 Benefit Enrollment / Maintenance, 270/271 Health care Benefit Inquiry and Response and involved in setting up Trading partner profiles for the clients and sending them Functional Acknowledgement 997.
• Implementation of 5 key aspects of HIPAA - Transactions, Identifiers, Codes, Privacy and Security, Non-Compliance issues and penalties
• Developed Schemas of EDI ANSI X12 Version 4010 Claims (837), Claims Remittance (835), and Eligibility forms in XML.
• Experienced with Map Builder: analyze, develop and make changes to various 5010 maps.
• Experienced with Analyzer: verify data integrity against various guidelines.
• Experienced with Transaction Management (TM) and Trading Partner Management tools to configure and modify Trading Partner relationships and transaction relationships.
• Implementing Managed File Transfer (MFT) applications to support FTP/SFTP, HTTP, and AS2 file transfer protocols, especially with AS 2 Gateway for decrypt and Encrypt for AS2 Partners.
• Collaborate with vendors, trading partners, and internal functional teams to define EDI requirements.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Setup new EDI trading partnerships and created Trading Partner profiles and Management of Communities in GIS 4.3/SI 5.2.
• Set up various communication-Protocols FTP, HTTP, SMTP and AS2 with trading partners for exchanging the EDI documents with digital Signature.
• Prepared test cases based on the signed off Consolidated Requirements Specification (CRS) and Requirements Traceability Matrix (RTM). I will also conduct quality review sessions with the Customer, the Business Leads and BAs to ensure the test cases cover all the requirements.
• Created the EDI test files for different formats (837P, 837I, 837Host, 837 Home).
• According to HIPAA, all files should be submitted in X12 format, so I prepared 837 for Local, Host and Home files in X12 format following the HIPAA implementation guidelines.
• Submitted files without IG errors for system testing.
• Tracked all HIPAA errors using Blue-chip adjudication system for 837 Institutional and professional claims.
• Validation of 835 files and responses.
• Submitted all the test claims through FTP system and validate the test results in different interfaces.
• Performed all stages of testing (Systems integration testing, Functional/Cycle Testing, User Acceptance Testing, Regression testing).