Raghu Vamsi

Experience

• 

  Electronics Corporation of India Limited (ECIL)

  May 2018 - Aug 2018

  Summer Internship

  • Collected and analyzed electricity consumption data using Power BI and SQL, creating insightful reports for business goals.• Maintained high-quality curated datasets, applying data governance principles for improved data quality across functions.• Collaborated with cross-functional teams to enhance analytics capabilities and improve overall data quality for informed decision-making.

• 

  EIDIKO Systems Integrators Private Limited

  Jun 2020 - Feb 2021

  Electronic Data Interchange Analyst

  • Designed, implemented, and maintained EDI solutions tailored for e-commerce transactions, specializing in 850,856, and 810 transactions.• Configured partner profiles, message types, port definitions, and communication channels in SAPPI/PO to support EDI transactions and message routing.• Implemented secure data exchange protocols using tools like Axway Secure Transport and Cleoclarify, safeguarding sensitive customer information during electronic transactions.• Developed comprehensive EDI reports with tools such as Tableau and Power BI, providinginsights into order fulfillment, inventory levels, and KPIs for data-driven decision-makingreducing manual intervention by 30% and decreasing order processing time by 25%.• Utilized SQL and Python to analyze EDI data, identifying patterns, trends, and discrepancies toinform decision-making.• Created mappings to integrate EDI data with ERP systems, enhancing the interoperability of business processes and optimizing resource planning. Implemented IBM Sterling B2B Integrator for automating order processing (850, 855) and inventory management (856) in retail and supply chain operations.• Designed and developed EDI maps and workflows in IBM Sterling B2B Integrator to facilitate real-time data exchange between retail partners and ERP systems.• Orchestrated EDI workflows for transaction sets such as 850 Purchase Order, 856 Advanced Shipping Notice (ASN), and 810 Invoice to optimize supply chain operations.• Configured IBM Sterling B2B Integrator adapters and pipelines to support EDI protocols (AS2, FTPS) and ensure secure data transmission.• Conducted system upgrades and patches for IBM Sterling B2B Integrator to improve scalability and performance in retail distribution networks.• Provided technical support and troubleshooting for EDI map errors and connectivity issues in IBM Sterling B2B Integrator, ensuring uninterrupted data flow. Show less

• 

  Tata Consultancy Services

  Mar 2021 - Dec 2022

  Electronic Data Interchange Developer

  • Created Maps for Confidential trading partners for transactions 810, 850, 852, 855, 856 and 860.• Worked on mapping EDI to XML, EDI to CSV, EDI to Positional and vice versa.• Created 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 Sterling Integrator.• Worked on XSLT for extracting desired data from XML files.• Modified business processes with GPM and BPML to provide routing channels for file flow within internal systems.• Developed and maintained business procedures in IBM Sterling Integrator and Sterling File Gateway to ensure smooth and effective operations.• Used the IBM map editor to create and alter maps, and created business procedures to satisfy unique business needs.• Employed Pl/Sql queries and Unix scripting were used for data processing and automation, which improved overall system efficiency and dependability.• Processed and validated test purchase orders (POs) and invoices for new vendor onboarding to ensure seamless integration into the EDI system.• Monitored and edited EFT payment files to ensure that transactions were accurate and on time.• Validated daily POs, invoices, and EFT reports, detecting and rectifying any anomalies to ensure data integrity.• Created XML Schemas for 810, 850 and 855 transaction sets using XML Spy and Ultra Edit.• Created business processes for FTP and SFTP file transfers with several partners using Graphical Process Modeler and BPML code.• Coordinated and gathered requirements from clients, manufacturing suppliers, and third-party vendors (GXS), ensuring clear communication and alignment.• Tracked all schedule and forecast communications from clients to suppliers, ensuring EDI messages were delivered on time and accurately.• Developed Routing Templates and Routing Channels in SFG and associated Producers and consumers. Show less

• 

  Humana

  Feb 2023 - Jan 2024

  EDIFECS Specalist

  • Worked together with the clients to gather and freeze the requirements for the elements of different transactions in the design document and used these documents for development purpose.• Understanding Functional spec and coordinating with India Team.• Analyzing Validation Edits for all transactions of HIPAA.• Analyzing Loading business rules and coordinating with inbound & outbound teams.• Analyzing both 4010 and 5010 version in X12 standards and their difference.• Analyzing and freezing the Tag names for intermediate file.• Analyzing and Freezing Design documents for 837P/I/D, 270, 276, 278, 820, 834, 835 X12 Healthcare transactions.• Worked mainly on Inbound and Outbound transactions like 810, 820, 832, 844, 850, 855, 856, 860, 865, 870, 875 and 997.• Analyzing the HCFA 1500, UB-92 and ADA paper formats and design the standard guidelines for the paper formats according to the client requirements using the delimited guideline format.• Developing maps using Netbeans in JCAPS 6.0.• Worked on 837, 835, 276 and 277 Institutional and Professional, EDI Gateway.• Creating test-cases and test-data using data dictionaries.• Worked with different functional groups to arrive at the common business and technical specifications.• Designed and delivered HIPAA training material regarding information security and best practices• Worked to build extensions for FACETS Members, Claims, Billing and enrollment applications.• Deploying translation projects and ECS files in the UNIX server.• Worked together with the clients to gather and freeze the requirements for the elements of different transactions in the design document and used these documents for development purpose. Show less

• 

  MetroPlusHealth

  Feb 2024 - now

  Electronic Data Interchange Developer

  • Managed 834 enrollment scenarios (initial enrollment, termination, cancellations, changes, CIC).• Experience in working with EDI HIPAA standards like 834,835,837PID,270/271,820 transactions.• Experience in working on Affordable Care Act project and expertise in implementation of EDI modules like 834 enrollment, reconciliation and 820 payment transactions.• Orchestrated EDI workflows in Cleo Integration Cloud to integrate claims processing (837) and payment advice (835), optimizing administrative processes for insurance companies.• Designed custom dashboards in Cleo Integration Cloud to provide real-time visibility into EDI transaction volumes and performance metrics, facilitating data-driven decision-making.• Conducted performance testing and optimization of Cleo Integration Cloud configurations to support high-volume healthcare EDI transaction processing and meet SLA requirements.• Collaborated with IT teams to troubleshoot connectivity issues and EDI map errors in Cleo Integration Cloud, ensuring continuous data flow and business continuity.• Integrated Cleo Integration Cloud with healthcare ERP systems to automate financial transactions (837, 835) and improve operational efficiency.• Orchestrated end-to-end integration solutions using Cleo Integration Cloud for EDI transactions (837, 835) within healthcare, ensuring compliance with HIPAA regulations.• Configured Cleo Clarify for real-time monitoring and alerting of EDI transaction statuses, minimizing operational disruptions for healthcare providers.• Worked on installing and configuring Edifecs Product Suite – X engine X Engine Server, Transaction Management, Map Builder, and Spec Builder in DEV/SIT, BIT/QA, and UAT boxesWorked on upgrading Edifecs Product Suite with new patches as and when required.• Created inbound maps from EDI ANSI X12 format into Database tables and flat files.• Involved insetting up trading partners, agreements, and relationships in Transaction Management. Show less