SUMMARY

• Around 7 Years of IT experience in analysis, design, development, Client/Server and maintenance of EDI Applications.
• Proficiency in EDI ANSI X12, X12N/HIPAA & EDIFACT standards.
• Experienced in Design, Development and Implementation of Integrating SAP, iWay, OTM applications.
• Strong experience in 4010 to 5010 conversion of X12 docs
• Experience in configuring & interacting with trading partners in laying standard specifications for various transactions for both Inbound & Outbound Mapping using EDI / HIPAA ANSI X12 standards.
• Expertise in Functional and Technical areas of EDI implementations.
• Extensive Experience in SQL/PL SQL, Stored Procedures and Triggers.
• Having experience using GIT and SVN for Source Control and Jenkins for CI & CD.
• Ability to work independently as well as in a team and experience in coordinating with different groups in a project.
• Knowledge of IBM iSeries system administration and troubleshooting.
• Experience with RPG programming language on an AS400 platform and DB2i concepts.
• Conducted knowledge transfer sessions and trained team members perform mapping using AI mapper.
• Excellent Written & verbal Communication, Interpersonal and Organizational Skills.

TECHNICAL SKILLS

Mapping Tools: Gentran 5.1/5.3/6.0/GIS, Sybase EC Map, WTX 8.2/8.1/8.0, Mercator 6.7, IIT, IDE

Industry Standards: ANSI X12, UCS, VICS, EDIFACT and HIPAA

EDI Tools: EDISIM 4.0, XMLSPY, EDIFECS Spec - builder

SQL Editors: SQL NAVIGATOR, TOAD, SQL ANALYSER, SQL DEVELOPER

EDI Transaction Sets: 204,214,270,271,276,277,278,810,820,824,827,832,830,834,835,837,846,850,855,856, 860,875,880,888,940,943,944,945,947,990,997 and 999.DESADV, ORDERS, INVOIC, ORDRSP, ORDCHG and RECADV.

Programming Languages: C, Java, Unix Shell Scripting, SQL, XSLT, Python

Databases: MS Access, Oracle 9i/10g/12c, SQL Server, DB2

Operating Systems: Windows, AIX / HP UNIX, OS/400, IBM I

Other Software: XML, DTD, XSD, XSLT, XPATH, ClearCase, Ultraedit, FileZilla, WS-FTP, Putty, Gpg4win and Quality Center 10.0

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Sr. EDI Consultant

Responsibilities:

• Provide EDI development, testing, maintenance, and troubleshooting support for the migration project to ensure proper functioning of EDI software applications and business processes
• Wrote FTP scripts to push and pull data from customers and validate the accuracy of transmission.
• Creating Maps for both inbound and outbound transactions in GXS/opentext software and linking SAP IDOC’s with X12 transactions.
• Manage configurations in SAP which includes setting up EDI partner profiles for all types of Inbound and Outbound EDI transactions.
• Responsible for managing standard communication protocols and configuration of Services, Transports and Integration Agents.
• Coordinates between trading partners and networks to ensure mapping compliance.
• Develop guidelines, checklists, procedures and training documentation. Often involved with a variety of client/server platforms.
• Created connected and Un-Connected transformations to lookup the data from Source and Target Tables
• Analyze EDI translation errors that failed in the inbound and re-processed the EDI’s without losing the information.
• Implemented business rules in the maps to check for input errors before generating the output in EDI format.
• Extensively worked on flat files and involved in creation of Batch shell scripts using different Batch scripts for FTP, generating list files for loading multiple files and in archiving the files after the completion of loads
• Working closely with middleware team to make sure data is not missing.

Environment: SQL, PL/SQL, SAP, Korn Shell, Ultra edit, UNIX, OpenText, Mapping workbench, OCC,, MY SQL, Apache camel

Confidential

Sr. EDI Consultant

Responsibilities:

• Working on integration and up-gradation of existing system to Iway.
• Extensively worked on XML technologies like XSL, XSD and DTD, also worked with XML parsers like SAX, DOM, JDOM, XML Beans and JAXP.
• Wrote flow services and java services for Converting EDI, CSV, FLAT, CEDEX documents into JSON format and passing to internal teams using web services and HTTP protocol as per the mapping and business requirements.
• Worked closely with the Business Analyst, Data Modeler and Database Architect during the design and development of ETL technical specification document.
• Used Bearer Token for authentication and security between two systems
• Used the web service in creating SOAP and RESTful web service interfaces for consumers and providers.
• Designed and developed JDBC adapter services to execute SQL queries and stored procedures.
• Used Informatica PowerCenter as an ETL to extract data from source like MS SQL Server, Flat files, Oracle, DB2 and Teradata and loaded to target.
• Analyzing the existing communication profiles of trading partners and moving them to new environment.
• Using communication methods like FTP, SFTP, AS2 for trading partners on new environment.
• Using PGP for encryption of financial data to ERP internal applications.
• Using ELK stack for log management and data Analysis, Jenkins for automated deployments
• Developed Error handling mechanism to process the error emails from the external systems to the business users
• Implemented extracting, cleansing, transformation, integration and loading into Data marts using Informatica.
• Interacted with internal business teams and customers to gather requirements and created technical and functional specs, test scripts, test cases.
• Performed GAP analysis, created mapping technical specs and built maps in iWay Integration Tool per customer/business requirements.
• Creating process flows for both inbound and outbound transactions to integrate with internal applications in iWay Service Manager.
• Responsible for managing and prioritizing support tickets using Jira, Service now, Monthly system reboots and patch installations.
• Responsible for daily monitoring of Iway Service Manager and resolving system, communication and data issues.

Environment: iWay Service manager, iWay Data Quality suite, Trading Partner Management, Business Activity Monitor, IIT 7.0.2/7.0.7 and Serv - U, SQL, PL/SQL, Oracle, Informatica Power Center 9.5.1.

Confidential, Brentwood, TN

Sr. EDI Consultant

Responsibilities:

• Worked on integration and up-gradation of existing Transportation Management system from OTM to Mercury Gate.
• Interacted with internal business teams and customers to gather requirements and created technical and functional specs, test scripts, test cases.
• Performed GAP analysis, created mapping technical specs and built maps per customer/business requirements.
• Created business process for both inbound and outbound transactions to integrate with Mercury gate as well as other internal applications using Graphical Process Modeler and BPML.
• Configured Command Line and file system adapters, services per business needs.
• Created Implementation guidelines, Test Data and analyzed test data using EDIFECS Spec Builder, Test data generator and analyzer components.
• Created trading partners and envelopes as per business needs in Sterling Integrator.
• Worked on analyzing the existing communication profiles of trading partners and moving them to new environment (BizManager to Sterling Integrator).
• Developed new QSS routing rules and documents for integration.
• Work closely with architecture team for setting up Sterling Integrator
• Created XSLT’s to split large XML documents into small XML’s, format reports etc.
• Configure services and adapters such as FSA, SAP Suite, JDBC, FTP, and HTTP adapters
• Responsible for managing and prioritizing support tickets, Monthly system reboots and patch installations.
• Responsible for daily monitoring of Sterling Integrator and resolving system, communication and data issues.
• Provided 24/7 production support during project go live and cutover.

Environment: Gentran Server 5.3, Sterling Integrator 5.1/5.2.4, BizManager, Mercury Gate, BizManager, EDIFECS, OTM and Business Objects, SQL.