SUMMARY:

• Strong IT Professional with about 8 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.
• Domain Expertise: Extensive experience in developing transaction sets in EDI and data mapping and data conversion across industries like Healthcare, Banking, Logistics, Distribution, Finance, Material management applications.
• Sterling Integrator: configuration, BPML, Mapping, XPath manipulation, GIS Adapters. Deploy numerous GIS 2.X, 3.X, and 4.X versions, and SI 5.x. Expert in variety of EDI - EAI tool. Specializes in Sterling Commerce GIS/ Gentran products such as Sterling Integrator 5.2, 5.0 GIS 4.3, 4.2, 4.1, SFG, on Unix/Windows, Gentran Server on UNIX 6.0, Gentran Server NT/Windows, Gentran Director, GXS (Global Exchange Services).
• EDI Mapping: Created maps & layouts for HIPAA as imposed during Electronic Data Interchange (EDI): 850 - Purchase order, 810 - Invoice, 997 - Functional Acknowledgement, 856 - Advanced shipment notice, 940 - Warehouse Order, 945 - Warehouse Shipping Advice, Response, 204 - Motor Carrier load tender, 210- Motor Carrier Invoice, 214 - Motor carrier shipment status.
• Business Process Management: Worked extensively in creating Business Processes using Business Process Modeling Language (BPML), mapping various file formats for Spec 2000, X12, SAP IDOCS, EDIFACT, XML, TRADCOM, etc. Used Edifices for creating EDI Specs.
• Designed and coded business processes for inbound and outbound EDI, Flat File, XML and MFT flows using BPML and GIS modeler. ANSI X12 transactions included 214, 810, 820, 850, 855, 856, 940, 945, 837/835, and 276/277.
• Trading Partner Management: Manage the requirements and selection for Trading Partners and Vendors. Experience in Migrating Trading Partner setups with Communication setups to Sterling Integrator 5.1 (GIS) from Gentran Server for Windows.
• Mail Box Configuration: Created new mail boxes for various Trading Partners and set the communication for different Trading Partners. Work with vendors to set up electronic communications and clearinghouse communications, including protocols.
• Tools & Technology: Very strong and diverse technology understanding, specifically with C, C++, Java, J2SE, J2EE, JBOSS, Oracle EBS, PL/SQL, Visual Basic, Cobol, JCL, XML, HTML, Crystal Report, Unix, Windows, TCP/IP, DNS, SQL Net, and firewall, AS2, SI Lightwell Framework, secure FTP (SFTP), SMTP, HTTP/HTTPS, Sterling File Gateway (SFG)
• HIPAA 5010: Implementation of EDI migration Project from HIPAA 4010 version to HIPAA 5010 version. Created

PROFESSIONAL EXPERIENCE:

Confidential, Peoria, IL

Sr. EDI Developer /Analyst

Roles and Responsibilities:

• 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.
• Partner Configuration in SI Lightwell frameworks
• Created route rules, send rules in SI Lightwell frameworks
• 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 to and from trading partner’s to Internal Order Management applications (SAP IDOC’s) in supporting Delivery Order, Goods Receipt, ASN etc.
• Responsible for the complete design, development and Implementation of 850, 846, 204, 990, 214, 210, 997, 940, 810, 820, and 856 transaction sets.
• Creation of implementation guides to document detailed exchange requirements such as structures, timing and business rules (GAP analysis documents.) Creation of application layout files
• Used SAP transactions BD87, WE19, W05, W02, WE20 to process inbound and outbound IDOCS through RFC
• 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

Biogen, Cambridge, MA

EDI Developer / Analyst

Roles and Responsibilities:

• Worked on integration with new trading partners using Gentran Server for 6.0v.
• Extensively worked on proprietary mapping tool maintained in the organization and participated in implementation of GIS server upon migrating the maps.
• Worked directly with transportation providers, Medicare and Medicaid clients in delivering effective communication.
• This includes HIPAA gap, impact and business rule validation for all 12 standard HIPAA 4010 transactions: 270/271, 276/277, 278/278, 820, 832, 834, 999,835, 837 (IPD). Involved in preparing the Methodology document for the HIPAA implementation
• Implementation of 5 key aspects of HIPAA - Transactions, Identifiers, Codes, Privacy and Security, Non-Compliance issues and penalties
• Structured new Schemas of EDI ANSI X12 Claims (837) and Eligibility forms to support in new environment.
• Created Maps between the native and HIPAA formats using proprietary mapper tool, with embedded business rules.
• Responsible for the complete design, development and implementation of 834,999, 835,837,270,271 using Gentran ODBC functionality.
• Setup trading partners and managed file transfers in new Sterling Integrator and Connect Enterprise file transfer systems
• Tuned SI/SFG to increase performance and throughput of file transfers
• Provide 24 x 7 on call support for all Managed file transfer issues as well as connect direct issues for both Connect
• Enterprise File Transfer System and Sterling Integrator/Sterling File Gateway
• Patched Sterling Integrator /Sterling File Gateway
• Installed the latest version of 5.2.4 of Sterling Integrator and Sterling File Gateway
• Created some custom BP (Business Process) to handle SFTP, FTP, and HTTP file transfers
• Created custom BP/Adapters to handle SFTP/FTP/ZIP/UNZIP. Worked on the architect, setup, configuration of Sterling Secure Proxy.
• Extensively wrote SQL queries to support translation, cross references, testing etc.
• Used EDIFECS spec builder to manage claim transaction and billing application requirements.
• Performed various kinds of testings on 835 and Outbound 837 (PID) transactions.
• Responsible for the 24/7 production support, configuration and monitoring daily error reports and coordinate/perform error resolution.

Confidential, Houston, TX

EDI Developer

Roles and Responsibilities:

• Primarily involved in onboarding trading partners. Support Confidential 's B2B relationships with existing and new trading partners: customers, transportation carriers, railroads, and various third parties.
• Interact with trading partners and internal Confidential corporate and field units on a day-to-day basis to support and resolve B2B transaction flow issues
• Manage trading partner support issues including analysis, mapping, testing, implementation, and documentation
• Created maps to translate data from X12, XML, cXML, Delimited format to Oracle Tables using Sterling Integrator Map Editor.
• Support of Sterling Integrator, Sterling File Gateway, and Connect Enterprise. Setup Connect Direct file agent to monitor and pickup files from windows platform to transfer to other platforms
• Work with connect direct scripts to transfer files and execute additional steps after the transfer.
• Support/configuration of Connect Direct and Connect Enterprise
• Trouble shoot connect direct file transfer problems between mainframe, Unix, iSeries, and windows.
• Develop maps, set up communications, designed business processes and configure Trading Partners on SI
• Conduct end-to-end testing to ensure set up and monitor data flow in production for new on-boarding’s.
• Involved in development, coding, compiling, testing and migrating inbound and outbound processes for various transactions such as 204, 210,214,322, 404, 410, 820, 824, 835,850, 856, 860, 990, 996, 997.
• Use Graphical Process Modeler (GPM) and BPML Editor to design business processes to send and receive file via VAN, FTP, HTTP, HTTPS and AS2 protocols.
• Created the work flows to accomplish the Business process models using BPML in Sterling Integrator.
• Implemented PGP encryption to encrypt outbound documents for some the customer NEXEO.
• 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, Email Error Notification, Alert Notification and On-Fault Business Processes
• Worked with ANSI X12/EDIFACT and Value-Added Networks (VAN).
• Worked in following XML documents: Purchase Order, Order Confirmation, Shipment Notification, Shipments, Invoices, and other documents involved in Intermodal and Over the Road Business.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Experienced/Proficient in IBM/Sterling Integrator (SI). Worked on Data management - Performing simple SQL queries
• In charge of maps related to extensible Markup Language (XML)
• Created the business process to automate email flow when message arrives in mailbox for the project NEXUS.
• Implemented multi sign on for the on boarding timeline work tracker. Implemented SFTP data flow for migration project Open-Scan.
• Onboarded Carriers, Customers, Vendors, Accounting for all Customers niche needs for the Team "Unyson".
• Worked on IBM iSeries / AS 400 System to retrieve/Modify data.
• Used Microsoft Access to establish ODBC connection and used access as Central EDI Management system.
• Worked on Positional File Format adjusting and troubleshooting errors due to wrong positioning/ invalid data format as part of Production Support.
• Trained team members on Development guidelines and maintaining mapping practices.
• Participate in the maintenance and improvement of best-practice guidelines for B2B Integration processes and procedures.

Confidential

EDI Analyst

Roles and Responsibilities:

• Worked on Sterling SI 5.x(Unix) tools and processes, Mapping, Business Process development (BPML or Graphical Modeler)
• Implemented the following transactions 276/277, 270/271, 278-13/278-11, 820, 834,999, 837D for 4010A, 5010 and 5010A compliance.
• Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator’s Map editor.
• Design and development of business processes to meet business requirements - BPML code development
• Performed migration of maps, BP's, service configurations, and adapters from Gentran Server to Sterling Integrator
• Study and analyze existing production business processes - troubleshoot business process and make suitable changes to in corporate new business needs/requirements.
• Configured and implemented Sterling file gateway process, adapters, services, service configurations and protocol setups as per business needs.
• Implemented Sterling File Gateway for the MQ File Transfer and Managed file transfer to move files for back-end applications.
• Monitored file transfer activity in Sterling File Gateway on an exception basis built on notification of file transfer activities.
• Automated the replay, reprocess, and resend with failed file transfers in Sterling File Gateway.
• Collaborate with vendors, trading partners, and internal functional teams to define EDI requirements.
• Created Shell scripts and database scripts to automate document tracking functionality. Application Integration Mapping (EDIFACT, SAP IDOCS, XML), SQL Mapping, AS2 Communication.
• 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.
• Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc.
• 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.
• Provide technical support of the EDI application, mappings, and interfaces, and testing.
• Designed and implemented clustered node for fail-over and load-balancing support over Linux and VMware environments.
• Developed PL/SQL packages to extract, validate and populate document tracking, auditing, and maintenance application.
• Trouble-shouted and resolved XSLT mapping issues and adapter failures/discards.
• Created and modified BPML to handle document archiving, failure notifications, acknowledgement reconciliations, and transaction metrics reporting.
• Configured JDBC Adaptor to pull data from data base and vice versa. Created Code lists for various code conversions.
• New EDI implementations for EDI X12 documents such as (850, 855. 810, 856 etc.), test case Execution, Build deployment, Post production. Enhancing existing EDI documents based on customer requirements.
• Special expertise lies in problem solving and workflow systems analysis. Experience in conducting design and code reviews, mentoring, and training.
• Study and review properties file - Tuning Properties file, Custom Properties files - understanding queues & threads to handle
• On-call 24/7 production support – AS2 failures, SFTP/FTP communication process failures, system down issues, troubleshoot and fix processes to meet SLAs.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Involved extensively in Implementing QA, Testing, Verification and Validation to ensure compliance with business needs
• Production Map changes to comply EDI document standard and company proprietary standard.
• Provide technical support of the EDI application, mappings, and interfaces, and testing.

Confidential

EDI Consultant

Roles and Responsibilities:

• Worked on EDI Implementation with new trading partners using Gentran Server on Windows
• Worked on Setting up new trading partner partnerships in the EDI systems including gateway server configuration, AS2 and FTP connectivity, network and system security, trading partner requirements gathering, mapping, testing, implementation, initial production support, and documentation.
• Manage and support Client’s Electronic Commerce relationships with existing and new trading partners: Customers, transportation carriers, railroads and various third parties.
• Worked on Migrating Communication setups (AS2, FTP), Envelopes and Maps from GIS 4.3 to SI 5.1.
• Worked on Sterling File Gateway Application for transferring files between partners using different protocols and file formats.
• Outlined the Business Process flow of different Trading Partners in Visio
• Migrated Trading partners from Gentran Server (GIS 4.3) to Sterling Integrator 5.1.
• Proficient in using data translation tools GIS 4.3 Version and GIS 5.1 for Windows.
• Responsible for the complete design, development and Implementation of 850, 846, 204, 990, 214, 210, 997, 940, 810, 820, and 856 transaction sets.
• Proficient in creation, modifications, testing of envelopes, maps, business process, service/adapters and AS2/FTP communications.
• Wrote various SQL Queries, PL SQL Procedures.
• Worked on 3020, 3030, 3040, 3050, 4010, 4030 and 5010 X12 Conversions.
• Experience with EDI concepts, standards, architectures (ANSI ASC X12, UN/EDIFACT) and Value-added Networks (VAN).
• Knowledge on iSeries AS/400 Application for setting up TP codes, business rules, checking on orders, event status and Invoices relating Transportation mode.
• Experience with Microsoft Office Tools and iSeries Navigation concepts and green screen applications in the Transportation Industry.
• Responsible for analyzing, designing, implementing, testing, monitoring the changes and moving to Production support.
• Distribute instructions, documentation, specifications, and questionnaires for EDI-related processes and procedures to client’s personnel and/or external trading Partners. Interact with trading partners and internal corporate and field units on a day-to-day basis to support and resolve issues relative to EDI transaction flow