Edi Consultant Resume
MI
SUMMARY:
- EDI consultant with 9+ years of experience in Telecommunication, Auto Mobile, Banking, and Financial domains.
- Worked as a Mapper on various X12 and EDIFACT based transaction sets including 850, 810, 855, 856, 820, 823, 862, 830, 214, 837/835, 276/277, 997.
- Experienced with EDI implementation which includes project scoping, requirements definition, gap analysis, business process re - engineering, B2B and EAI protocols, issue resolution, configuration, performance & tuning, training, mapping, go-live assistance and post implementation support.
- Extensive experience in Business Analysis to Translate Edi requirements into functional specifications, create companion guides using Edifecs Spec builder, and develop logical mapping for Gentran/ ECMap/ GIS-SAP Idoc/ Mainframes
- Designed and implemented numerous systems that have helped clients in a variety of industries to communicate with customers and increase their efficiency and effectiveness.
- Assist clients, through advisory services like business process reviews, systems selections, and IT planning, in determining which business processes can and should be automated and how these automated functions may be integrated into the rest of the business and infa-structure environment.
- 9 Years of overall experience in S/W development and maintenance. 6 Years of experience in implementing in Mercator, Assencial data stage TX,WTX 8.3, WTX 8.4 tools.
- 5+ years of experience in EDI ANSI X12, EDIFACT, XML in Transportation and logistics domain obtained by working with leading shipping company ( Confidential client.
TECHNICAL SKILLS:
EDI Standards & Formats: EDI X12 (ANSI), EDIFACT, TRADACOMS, HIPAA XML, SAP IDOC, FLAT, CSV, SWIFT
EDI TRANSFORMATION Tools: Mercator, DatastageTX 8.0(DSTx),WTX 8.3,WTX 8.4
EDI TRANSMISSION Tool: Axway B2B transmission/interchange tool(Cyclone)
Testing tool: HP quality center 10
Web Technologies: HTML 5, CSS 3, SASS, Bootstrap, JavaScript, JQuery, AngularJS1 and Angular 2/4, ES6, ReactJs, PHP, XML, JSON and AJAX
Database: Sql and Pl/Sql for Oracle, sybase
SCM Tools: Clearcase.Harvest,SVN
Other tools: IBM Requisite Pro,Remedy,Kintana,IBM B2BTrading Partner manager (commerce manager)
Languages: C, C++, Java, Python
Operating systems: Windows, Mac, Linux, UNIX
Others: MS Office
Bug Tracking Tolls: JIRA, Bugzilla
PROFESSIONAL EXPERIENCE:
Confidential, MI
Edi Consultant
Responsibilities:
- Involved in developing specifications that fulfill client required certifications and approvals from majority stake-holders.
- Enhanced fulfilled specifications to improve performance.
- Analyzing new change request, proposing solutions and estimating the changes related to implementation of WIFT MX and SWIFT MT standards.
- Development of new maps, type trees fixing change request in maps using mapping logic in WTX 8.4.
- Analyzed and developed interfaces for converting legacy ERP systems to a global SAP while to remaining seamless to the trading partner.
- Performed Project Management activities such Identifying, managing & controlling changes, Planning work according to the objectives, Analysis and design of objectives Tracking and reporting progress coordinating implementation
- Acted as a mediator between internal/external business community and IT (SAP) organization to provide technical solution to meet stack-holder’s needs.
- Extensively worked on developing and testing the Transportation management system documents like 204, 214, 219, 220, 990 and 858 for the carriers.
- Tested the documents internally with the SAP and EAI layer to make sure the documents are passing to the B2B with all the mandatory values in it.
- Converted the XML files into X12 and X12 to XML files on GIS for sending and receiving the EDI files.
- 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.
- Fixed the defects which occurred during testing by changing the mappings in Gentran and GIS.
- Created and executed queries and Stored Procedure in ORACLE (via Toad)
- Created mapping specifications and performed Gap analysis
- Set up and executed test scripts (documented on MQC)
- Set up various communication-Protocols FTP, HTTP, SMTP and AS2 with trading partners for exchanging the EDI documents with digital Signature.
- Set 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.
- Wrote UNIX shell scripts for automation of FTP process, monitoring of data errors, compliance errors, Data discards etc.
Confidential, Dearborn, MI
Edi Consultant
Responsibilities:
- Developed and executed corporate cost reducing EDI strategy for Duane Reade resulting in the elimination of over 98% of the company's paper Purchase Orders and Invoices (prior to recruitment by Duane Reade in 2003).
- Interacting with Business to understand the enhancements and Requirements.
- Sterling Control Center (SCC) Integration, monitoring, SI/Sterling File Gateway (SFG) instance sending notification via SMTP email server.
- Responsible for SI4.1 to SI 5.2. Migrations of all User/System Maps, Setups in new environment. Trouble-Shooting in retrofitting the older version and making new 5.2 compatible.
- Involved in mapping development in various different formats like X12, EDIFACT, CSV, SQL and SAP Idocs.
- Designed and developed more than 150 Maps in ANSI X12,EDIFACT,XML and SAP Idocs
- Extensive use of SFTP, FTP, HTTP, Mailbox, File system, Web services, Command Line, JDBC, SOAP, Translation and system Adapters
- Importing and exporting IDOC layouts from SAP to Gentran. Wrote Unix shell scripts to automate FTP Process
- Migrated current trading partners and transactions from the Invoice TLE Server 5 to the new Invoice TLE Version 6.
- Interacted with the trading partners to set up new trading partner relationship and resolve the production issues related to transaction 214, 810, 820, 823, 832, 850, 852, 856, 860, 875 and 997 on daily basis.
- Gained good functional knowledge in Logistics, Purchasing and Account Payable and Account Receivable.
- Interacted with trading partners and creating standard specifications for various transactions for both inbound and outbound using ANSI X12, EDIFACT (D93A, D96A), and SAP IDOC standards.
- Configured, tested, and implemented Sterling File gateway’s (SFG) consumer file structures (CFS), Data flows, events, delivery channel, and routing rules to enable and automate Managed file transfer (MFT).
- 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 maps for transactions (834) using Sybase ECMap, HIPAA Toolkit, and eGate. Expanded ECMap’s functionality by developing a dll with custom functions
- Migrated Trading Partners from FTP to AS2, AS3, SFTP, SSH, HTTP, HTTP/s protocols. Experiences in Trading Partner set up, onboarding new partners, development and QA testing, Continuous monitoring business processes and troubleshooting failed processes.
- Developed (BP) Business process for all inbound and outbound transactions to SAP and internal applications as per business requirements using GPM and BPML in Gentran Integration Suite/Sterling Integrator.
- Configured and implemented Sterling file gateway process, adapters, services, service configurations and protocol setups as per business needs.
- Coordinate with all vendors, trading partners, and internal Business Functional teams to define EDI business requirements.
Confidential , Charlotte, NC
EDI Analyst
Responsibilities:
- Design and create NPI de-duping process. Responsible for MCC/MCO flat file validation and testing. Define 837 I/P/D errors for all MCC / MCO entities.
- Create compliant HIPAA 837 EDI Transactions for Technical Vendor Testing Purposes:
- Encounter transmissions, 837 institutional and professional.
- COBA transmissions, 837 institutional and professional.
- Standard 837 transactions for professional and institutional EDI validation.
- Develop data importing processes for EDI files.
- Create reporting and custom applications for analyzing flat files as well as HIPAA EDI files.
- Maintain NPI and NPPES database.
- Was responsible for the SAP testing included the movement of the IDOC from the Harbinger TLE EDI subsystem into SAP through the normal Harbinger TLE SAP Remote Function Call interface (RFC).
- Work on NCPDP files and compliance requirements.
- Produce EDI Testing environments for HIPAA EDI transactions.
- Business Analyst Functions: Produce and maintain all vendor performance matrices and reporting, including details numerical analysis. Create project documentation. Define and suggest needed improvements to management.
- Develop Mapping rules, Design specifications, and Test Case / Use Cases for the HIPAA 837i/p/d; 270/271, 276/277, 835, 824, 275 and others.
- Worked on multiple 837s and multiple Eligibility (270/271) and healthcare claim status (276/277). Create EOB systems (835). While “in-house”, help with development.
- While on-site, work as a business analyst. These projects span several Insurance Payers, Carriers, and providers, working with and for each of these, typically in an EDI Business Analyst roll.
Confidential
EDI Consultant
Responsibilities:
- Perform initial installation and configuration of the Windows Gentran Server and Gentran Integration Suite in a Windows 2003 clustered environment
- Developed customized maps for application-to-application file layouts
- Create maps for both inbound and outbound trading partner relationships
- Responsible for testing which included that the correct translation was generated by Gentran and that the files were accepted correctly into the ERP application
- Reviewing and documenting the RPS operations manual and Functional Specifications, Skills used - SQL, Unix
- Developed EDI Application Integration maps using Windows Gentran Server NT
- Implemented transactions 210, 810, 820, 832, 850, 875, 856, 940, 945 and 997 using the X12 standard, in version 4010 and 4030
- Created maps for both inbound and outbound trading partner relationships
- Tested all maps, data managers and configuration with trading partner data in conjunction with downstream applications.
- Coordinate with all vendors, trading partners, and internal Business Functional teams to define EDI business requirements
Confidential, Chicago, IL
EDI Consultant
Responsibilities:
- Developed Maps, which translate HIPAA compliant Professional and Institutional data from EDI ANSI X12 data format to XML data format and XML data format to EDI ANSI X12 data format
- Also developed maps, which translate Custom formatted EDI files to XML for storing in e-Repricing database and XML to Custom Formatted EDI file using GIS Sterling Integrator Map Editor.
- Prepared design documents for business processes and creating business processes
- Developing XSLT’s for generation of report to be sent as attachment with Email
- Development of (positional-sql) maps. (i.e., Inbound/Outbound) design document for the business flow
- Preparing functional specifications and test with production data
- Trading partners setup
- Configuring business processes