Venkata Revanth S

• Analyzed and gathered business requirements to develop Mapping Requirement Specifications (MRS) for retail EDI transactions (850, 855, 820, 856, 810, 945, 846) mapped to XML fields for SAP S/4HANA integration. • Conducted gap analysis and developed generic MRS templates for inbound transactions such as 850, 820, 856 (from vendors) and 945 (warehouse fulfillment). • Collaborated with SAP S/4HANA teams to map trading partner data to SAP fields, ensuring seamless ERP migration. • Developed and tested inbound and outbound maps using Sterling B2B Integrator, ensuring accurate data transformation and compliance with ERP requirements. • Mapped X12 EDI transactions to XML fields, validating and refining transformation logic to align with SAP S/4HANA processing rules. • Implemented mapping rules, cross-references, and data validation logic to standardize partner data and resolve discrepancies during ERP migration. • Designed and configured Envelopes and Trading partner profiles to enhance EDI document processing and ensure secure transmission. • Set up AS2 partner profiles, Code lists, and Certificates to facilitate encrypted and authenticated EDI transactions. • Led UAT, functional, and system integration testing to validate transaction mappings and ensure ERP data consistency. • Created detailed documentation for Mapping and MRS documents to streamline future enhancements and support.

• Implemented end-to-end MFT solutions using IBM Sterling File Gateway, including setup of routing channels, communities, producers, and consumers for secure and automated file exchanges. • Designed and configured routing channel templates (static and dynamic) in Sterling File Gateway to support scalable and partner-specific file movement. • Created end-to-end file transfer flows using FTP, HTTPS, SFTP/SSH, and Connect Direct for secure and efficient partner data exchange. • Automated business processes in Sterling B2B Integrator using services such as FTP Put, FTP Get, FTP Client Delete Service, Mailbox Add Service, and Mailbox Extract Service. • Implemented PGP encryption and decryption to ensure secure EDI data exchange, maintaining compliance with industry standards. • Mapped inbound and outbound EDI transactions (850, 855, 810, 820, 856, 997) from ANSI X12 to SAP IDoc formats (ORDERS05, ORDERSP05, INVOIC01, DESADV01) using Sterling B2B Integrator. • Analyzed and optimized Business Processes (BP) using Graphical Process Modeler (GPM) and XML to streamline EDI workflows. • Tracked and verified file movements across Sterling and SFG components using Sterling dashboards and system logs. • Monitored and troubleshot production environments, resolving map failures, file transfer issues, and partner connectivity errors using Sterling File Gateway. • Resolved SFTP connectivity issues, reset accounts, and tested connections to ensure error-free file transfers. • Established alerts and issue resolution workflows in Sterling Control Center to proactively monitor file transfer and processing failures. • Updated the Sterling Integrator database with trading partner and routing details using SQL and XML files. • Collaborated with infrastructure teams to ensure high availability and performance of IBM Sterling components in Windows and Linux environments. • Wrote PowerShell and Shell scripts for automation, log analysis, and system health checks.

• Developed and maintained EDI maps for HIPAA-compliant transactions including 837 P/I/D (Claims), 835 (Claim Payment Advice), 270/271 (Eligibility Inquiry/Response), and 276/277 (Claim Status Request/Response). • Collaborated with healthcare providers and clearinghouses to ensure compliance with HIPAA 5010 standards in EDI processes. • Spearheaded the design, development, and testing of 837P/I, 835, and 834 HIPAA transactions for Medicaid and Medicare encounters, ensuring compliance with HIPAA 5010 standards. • Designed and tested mapping specifications to translate claim data from XML to HIPAA EDI formats using EDIFECS SpecBuilder. • Developed and optimized processing routes for 835, 837, and 834 transactions using EDIFECS Application Manager, improving processing speed by 15%. • Managed trading partner configurations for inbound and outbound healthcare transactions, including partner identities, envelopes, and document exchanges. • Troubleshot and resolved transmission issues for Medicaid and Medicare claims in line with HIPAA X12 guidelines. • Automated 834 enrollment workflows using Edifecs XEngine. • Configured EDIFECS Transaction Management (TM) and applied business rules to validate 270/271, 276/277, and 835 transactions. • Validated HIPAA 5010 field formats and implemented SNIP levels (1-7) to ensure compliance and prevent errors. • Conducted end-to-end testing for 837 claims, 835 remittances, and 270/271 eligibility transactions, ensuring compliance with HIPAA standards and achieving 98% pass rate. • Documented workflows, mapping guidelines, and error-handling procedures to aid team efficiency. • Performed gap analysis for HIPAA 4010-to-5010 transitions, updating maps and guidelines. • Engineered and enhanced backend workflows in Oracle SOA and Oracle B2B. • Configured SQL queries to extract, update, and analyze data from Oracle databases, supporting healthcare transaction reporting and analytics.

• Analyzed and gathered client requirements to design and develop mapping solutions, including EDI to XML, SAP IDOC, and positional formats. • Processed EDI transaction sets like 810, 820, 840, 843, 860, 850, 855, 856, 997 ensuring compliance with business rules and partner specifications. • Established trading partner connections using FTP, SFTP, HTTP/HTTPS, AS2, and PGP, ensuring successful data exchanges and improved security compliance. • Configured EDI transmission processes for VANs and direct partners, ensuring reliable transaction flow. • Managed mailbox configurations, routing channels, and trading partner profiles for smooth data exchanges. • Set up AS2 partner profiles, envelopes, code lists, and certificates to enhance EDI document processing. • Customized business processes using services like FTP PUT, SFTP GET, and HTTP Client in Sterling B2B Integrator. • Optimized Sterling File Gateway for secure and automated file transfers between internal and external systems. • Monitored B2B and MFT (Managed File Transfer) operations using Sterling Control Center, troubleshooting and providing real-time insights. • Deployed Sterling Secure Proxy and Perimeter Server for secure file transfers and external partner connections. • Provided production support by troubleshooting issues and resolving communication failures. • Managed SQL queries for data extraction and reporting from backend systems. • Tracked project tasks and progress using JIRA and MS Project, ensuring timely delivery and stakeholder updates.

• Collaborated with trading partners and internal teams to gather requirements for ocean (309, 300, 301, 310, 315, 350, 353, 355) and land transportation (204, 214, 990, 210) transactions. • Performed gap analysis on Gentran EDI maps, ensuring seamless integration of new requirements and minimizing data transmission errors. • Set up and tested communication protocols like FTP, SFTP, AS2, JDBC, VAN ensuring secure and compliant partner exchanges. • Managed AS2 configurations, implementing secure digital signatures and public/ private key encryption to ensure data integrity. • Handled EDI transactions and managed mailbox configurations for inbound and outbound data transfers. • Maintained Gentran databases and Oracle backend systems, ensuring data integrity across logistics processes. • Designed and implemented business processes and EDI maps, integrating Warehouse Management (WMS), Transportation Management (TMS), and financial systems. • Developed error-handling processes in Gentran, reducing transaction failures through efficient tracking and resubmission of failed transmissions. • Optimized SQL queries to extract logistics data, supporting EDI transaction management and reporting for better decision-making. • Compiled project documentation, including requirement analysis, workflows, and gap analysis for logistics EDI projects. • Facilitated trading partner onboarding, creating seamless data flows and enhancing communication processes. • Led migration projects from Gentran 4.2 to Dell Boomi ensuring business continuity with minimal downtime. • Provided 24x7 production support, troubleshooting EDI translation and communication issues with trading partners.