SUMMARY

• Over 7 plus years of Strong technical Experience in developing applications for B2B integration using different EDI technologies like Sterling Integrator, Gentran Integration Suite, Gentran Server (Windows & UNIX), Sybase EC Map.
• Experience in Sterling Commerce Products in Conversion of Gentran UNIX, Gentran NT, Gentran Basic (Mainframes) implementing maps into GIS/SI 3.1/4.1/4.2/4.3/5.0/5.1 GIS Administration (Gentran Integration Suite - Configuration of adapters, services and Business process development) and testing.
• Extensive experience in Business analysis, Development & creating of EDI Implementation Guidelines and Mapping Specifications.
• Extensive Knowledge on B2B integration, production support, testing, implementation, and documentation of information systems. B2B Integration using Sterling Integrator 5.0,5,1,5.2, GIS 3.0, 3.1, 4.0, 4.1, 4.2, Gentran Server 5.1, 6.0, 6.1, Sybase ECMap.
• Expert level experience in design, develop new Business processes for inbound and outbound transactions, good knowledge in BPML, XML to write the BPs.
• Analysis the Business Mapping Requirement involving EDI standards such as ANSI X-12, EDIFACT, TRADACOM, XML Rosettanet, SAP- IDOC, CSV, SWIFT, RFW international standard.
• Worked on 837 and 835 projects, including syntax and business rules for X12 HIPAA 4010 and 5010 validation for loops, segments, elements, qualifiers and code sets.
• Experience in working with EDI Transactions X12 - 835, 837, 270, 271, 276, 277, 278, 204, 210, 214, 404, 410, 834, 810, 820, 830, 832, 850, 846, 855, 856, 857, 940, 943, 945, and 997.
• Health Care Industry experience with HIPPA Compliance EDI documents including EDI transaction sets: 270 Benefits inquiry, 271 Benefit info, 276 claim status request, 277 Status Notification, 278 Service Review, 834 Benefit enrollment, 835 Payment Advice, 837 Claim form. Good understanding of 5010 upgrades to support ICD-10 code Compliance.
• Extensive experience in using Edifecs Products like Edifecs Spec builder 6.8, Edifecs Transaction Manager 7.0.3, Edifecs Application Manager, XEngine and XES.
• Understanding of EDIFACT transaction ORDERS, INVOICE, PRICAT, DESADV and ANSI X12.
• Creating Trading partner setups, setting up mailboxes.
• Establishment of different VAN’s, FTP, SFTP, HTTP & HTTPs and good understanding on securities (SSL, Digital Signature and Encryption).
• Excellent understanding about ANSI X12 EDI compliancy mandates for ANSI X12 EDI.
• Integrating with transaction sets like 850, 860, 856, 810, 820 and 997 etc.
• Have good Knowledge in IDOC structures like DELVRY01, INVOIC01, SHPMNT04 and ORDERS05.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Ability to work in a fast paced environment focusing on multiple projects at the same time.
• Lead & train team members with a focus on improving manual/redundant processes.

TECHNICAL SKILLS

Operating Systems: Windows 2003/2008, Solaris, Unix, Linux, MVS, i-Series and VMS

Languages: PL/SQL, SQL, C, Java, Perl, Unix Confidential scripting, XSLT, Cobol, JCL, RPG (free form and fixed).

Databases: Oracle 10g/9i/8i, DB2, Informix & MS-SQL Server 2005, MySQL

GUI: Developer 2000(Forms& Reports6i) and Forms& Reports9i

Tools: & Utilities: Reflection, Toad, SCP, SSH, HP Quality Center, Bugzilla, Ultraedit

Version Control Tools: WinCVS, PVCS, CVS

Domain Knowledge: Supply Chain Management-Procurement and Accounts Payable, Order management system, Shipping system and Logistics, Transport Management System

EDI Mapping Tools: Lawson 8.1.xto 9.0.1.x, GHX, Sterling Integrator 5.0/5.2, Gentran Server 6.1/6.0/5.3/4.0 (Unix & Windows), GIS(4.2) Sybase EC-Map, EC-Gateway, SFG(Sterling File Gateway), MFT (Managed File Transfer), Advanced File Transfer (AFT)

ERP: SAP ECC6.0, IDOCS, OMS, TMS, WMS, Punch-out.

PROFESSIONAL EXPERIENCE

Confidential, Portland, ME

EDI Coordinator

Responsibilities:

• Creating maps for various transactions including 810, 850,855, 856 and 997.
• Involved in Business Analysis in the entire SDLC of Lawson Supply Chain.
• Configured Trading partner profiles for both inbound and outbound for various partners.
• Created business process for both inbound and outbound transactions to Lawson and other internal applications as per business needs using Graphical Process Modeler (GPM).
• Gained good knowledge in Procurement, Purchasing, and Account Payable.
• On Boarded Meta Trade vendors to EDI through GHX and interacted with the trading partners to set up the Business Processes.
• On boarded suppliers using Fax integrator and Email to EDI through GHX and involved in testing and provided documentation to the results.
• Enabled the trading partner profiles for the inbound and outbound transactions.
• Configured ED10.1 trading partner setup for both Outbound and Inbound documents in Lawson.
• Created Data Substitution tables (ED40) to take the values that are setup in Lawson and translated them into a code to receive/ send data in raw EDI.
• Ran reports for PO120 which extracts purchase order data from Lawson purchase order application and loaded it to flat file.
• Ran ED502 to bring all the inbound documents from GHX.
• Involved in resolving the PO orders failures by validating the reports and boarded them in GHX.
• Worked with Procurement and Accounts Payable teams in resolving issues for 850, 855, 856 and 810’s.
• Established business process for the existing trading partner’s profiles in the GHX.
• Responsible for generating reports out of EDI production life cycle database automated reporting to support daily operations.
• Ran reports and validated the accounts present in the GHX for each trading partners.
• Involved in monitoring Batch jobs and troubleshooting errors.

Environment: Lawson EDI 9.0.1.x, GHX, GHX Connect Plus, SQL, PL/SQL, UNIX.

Confidential, Rockville, MD

Sr. EDI Developer

Responsibilities:

• 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, 834, 850, 852, 856, 860, 875 and 997 on daily basis. .
• 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.
• 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.
• 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.
• Performed migration of maps, BP's, service configurations, and adapters from Gentran Server to Sterling Integrator.
• 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 fro from trading partners to Internal Order Management applications (SAP IDOC’s) in supporting Delivery Order, Goods Receipt, ASN etc.
• 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.
• Experience in Troubleshooting of IDoc Errors.
• Involved in Scheduling and monitoring of SAP Batch jobs Processing programs.
• Involved in Gap Analysis for EDI X12 834 between state based exchange and federal.
• Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
• Assistance in-migrating to a new EDI X12 850,856, 810 maps in version 4030.
• Created new mail boxes for various Trading Partners and set the communication for different Trading Partners using different VAN like GEIS, USOrderNet and UKATT.
• Interacted with different Trading partners to create new specs for setting up the transactions.
• Communicated with trading partners, sending documents through VAN, using FTP and GEIS Networks etc.
• Created new events in the test region and testing the transaction.

Environment: Sterling Integrator 5.0/5.2, XML, MFT(AFT), GIS 4.3, SQL, PL/SQL, MQ Series, EDIFACT, Oracle APPS, 11.5.10, UNIX (SUNOS) and Windows NT, AS/400, Mercator 6.7.1, Connect: Direct, SoapUI, CruiseControl

Confidential, New York

EDI Programmer

Responsibilities:

• Created and edited maps for various retail transactions including 810, 820, 880, 850, 856, 855, 846, 940, 944, 945, 888, 947 and 856.
• Interacted with trading partners to gather business requirements and also responsible for creating test cases and test scenarios.
• Interacted with trading partners and creating standard specifications for various retail and logistic transaction sets for both inbound and outbound using ANSI X12, EDIFACT (D93A, D96A) standards.
• Created new maps for various transactions using Gentran Integration Suite/Sterling Integrator for both inbound and outbound transactions.
• Created new Business Process for Customer Integration Project using Graphical Process Modeler and BPML
• Analyzed the requirements and created mapping specifications based on Transportation and Logistics implementation guidelines.
• Created customized flat file maps like standard shipment document, Buyer Reference Document, Participant Location which are X12 858, 250, 101 etc.
• Modified EDI ANSI X12 856 Advanced Shipping Notice type tree to match the Integration criterion of the Staging Tables
• Developed and implemented managed file transfer (MFT) partner communities, routing rule set, route provisioning using Sterling File gateway (SFG).
• Created configurations for mailboxes, users, profiles, and auditing for Managed file transfer (MFT) using SFG.
• Configured and mapped inbound and outbound documents, which included 810, 850, 860 and 832 using Gentran Integration Suite BPs (GPM and BPML).
• Based on the reports developed around 100 maps. Grabbed test data from the internal applications to test the Application Integrator (AI) maps. Compared NT/MF files.
• Assistance in-migrating to a new EDI X12 850,810 maps in version 4030.
• Created new mail boxes for various Trading Partners and set the communication for different Trading Partners using different VAN like GEIS, USOrderNet and UKATT and Walmartsplit.
• Created implementation guide lines for all the warehouse transactions using EDISIM.
• Created test data using EDISIM Test data generator for various retail transactions.
• Involved with various teams (order fulfillment, Revenue Management etc.) in creating test scripts for Integration and String testing.
• Equalized the trading partnerships for the client to trade electronically as one.
• Importing and exporting IDOC layouts from SAP to Gentran.
• Wrote UNIX Confidential scripts to automate FTP Process.
• Responsible for generating reports out of EDI production life cycle database automated reporting to support daily operations.
• Provided 24X7 production support and also involved in various knowledge transfer sessions.

Environment: Sterling Integration Suite 5.2, Gentran Server 6.0, SAP 5.0, EDISIM, Unix Confidential scripting, PL/SQL, SQL, Oracle9i, 10g, Oracle Forms and Reports 9

Confidential, NJ

EDI Analyst/Programmer

Responsibilities:

• Creating maps for various transactions including 810, 850,855, 846, 820, 856 and 997.
• Involving in Business Analysis in the entire SDLC of the Supply Chain Apparel Transaction sets.
• Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator’s Map editor.
• 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 Gentran Integration Suite/Sterling Integrator.
• Configured and implemented Sterling file gateway process.
• Configured adapters, services, service configurations and AS2 setups as per business needs.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Set up various communications using Protocols FTP, HTTP, SMTP and AS2 with trading partners.
• Modifying and developing maps according to trading partner needs and monitoring production jobs and provide on call support.
• Creating new mailboxes for various trading partners, and set the communication for different trading partners.
• RPG, RPGILE, RPG FREE, CLP, programming on AS 400, Binding Directories, Service Programs, Activation Groups, SQL, Embedded SQL / CURSORS and Store procedures.
• Strong background in RPGLE, RPG FREE, CLLE, AS/400,
• Experience in SQL query creation and creating tools in AS400 to reduce manual effort.
• Using AI mapper extensively and converting maps from visual mapper to AI mapper.
• Preparing test cases and developing test data to test EDI maps.
• Designing and developing Interfaces between SCM (Supply Chain Management) and HOST systems
• Migrated managed file transfer (MFT) from automated file transfer (AFT) to Sterling File Gateway (SFG) with AFT routing rules, mailboxes, PGP profiles, etc.
• Importing and exporting IDOC layouts from SAP to Gentran.
• Using SAP Suite Adapter to connect to SAP.
• Configuring services and adapters such as FSA, SAP Suite Adapter, JDBC, FTP and HTTP to send and receive various transactions.
• Writing SQL Queries and automated reporting to support daily operations.
• Providing 24X7 production support.

Environment: PL/SQL, SQL, Oracle9i, 10g, AS/400, Oracle Forms and Reports 9i, Java, Windows, Unix, Linux, Sterling Integrator, Gentran Integration Suite 4.3, Gentran Server 6.0, SAP 6.4.

Confidential, Houston, TX

EDI-AS/400 Consultant

Responsibilities:

• Configuring SAP R/3 EDI components including system-wide settings, output tables, and partner profiles for both inbound and outbound transactions and message control.
• Implementing (EDPAR) internal-external trading partner number conversions.
• Creating EDI map specifications for transactions 810, 816, 820, 844, 845, 849 and 850 using the X12 standard for both inbound and outbound trading partner relationships.
• Creating SAP XI adapter module to modify Gentran Data Manager for use with SAP XI JMS Adapter.
• Coded a CSV parser module for uploading XL sheet data in CSV format from PC to AS/400 and parsing required data for generating various reports
• The customer of Rosetta Stone can place their order through websites, EDI, E-mail, Fax and AS/400 menu screens
• Implementation of customized SAP/EDI to process all the transaction Sets.
• Set up SAP/EDI system including work flow for error notification, configuration, batch scheduling, and automatic FTP processing and mail messages
• Analysis of EDI transactions both inbound and outbound. SAP testing included the movement of the IDoc from the EDI subsystem into SAP through the normal Remote Function Call.

Environment: PL/SQL, SQL, RPG, Oracle9i, AS/400, Oracle Forms and Reports 9i, Windows, Unix, Gentran 5.3, SAP R/3, Ascendant, Toad.

Confidential, NC

EDI Analyst

Responsibilities:

• Analysis, Design, Development and Maintenance of EDI system using Gentran.
• Using Edifecs Spec Builder to edit and customize an implementation guideline.
• Coordinating with the customers to analyze requirements for Implementation Guide.
• Creating Application Type Tree by using Database Interface Designer.
• Interaction, creating maps, resolving mapper’s issues, Q.A, interactions with clients and their Trading partners.
• Various Inbound and Outbound Procedures include 820, 834, 835, 837, 275/277, 270/271 using X12 HIPAA Standards.
• Implementation and Post-Implementation of these transactions with various Partners.
• Working on Volume and functionality testing and fixing the errors.
• Performed GAP analysis between the present status of the system and the HIPAA changes.
• Generated reports upon the successful completion of the GAP analysis.

Environment: PL/SQL, SQL, Oracle10g, Informix, Oracle Forms and Reports 10g, Sun Solaris, Gentran Server 5.3, Flat-files.