SUMMARY

• 8 years of experience in design, analysis, development & testing of EDI solutions using Sterling’s Gentran and GIS/SI.
• Experienced in various applications of the business which includes Logistics, HealthCare, Retail and Distribution.
• Technical Expertise in B2B integration using Gentran Server, Gentran Integration Suite, Sterling Integrator.
• Strong Knowledge of GIS’s Graphical Process Modeler (GPM) and Business Process Modeling Language (BPML) in building customized business processes for various clients.
• Strong experience in mapping various data formats such as EDI, XML, IDOCS, CSV, SQL and flat files using GIS Map Editor.
• Expertise in XML, XPATH and UNIX Shell Scripting.
• In depth knowledge of mapping SAP and non - SAP applications to a variety of EDI layouts.
• Excellent business knowledge, analytical and communication skills to understand both business and technical needs from the clients and customers.
• Worked on SI Map Editor to develop Maps for various Trading Partners in various file formats such as X12-IDOC, IDOC-X12, APP-X12, EDIFACT-IDOC, FLATFILE-X12 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 Gentran Integration Suite/Sterling Integrator.
• Strong understanding of EDIFACT transactions ORDERS, INVOICE, PRICAT, DESADV and
• IDOC structures like DELVRY01, INVOIC01, SHPMNT04, ORDERS05.
• Proficient in setting up mailboxes, AS2, HTTP, FTP, SMTP, SFTP protocols to create connectivity &creation of Certificates using SI.
• Experience in Sterling Secure Proxy, configuring Perimeter Servers and multi node configuration setup.
• Worked on maintenance and support for Sterling File Gateway including configuration, problem resolution, and application support.
• Experience on On-Call Production Support projects and interacted with clients to resolve production issues.
• Ability to successfully work and lead under tight deadlines.
• Excellent analytical, communication skills and a good team player.

TECHNICAL SKILLS

Software Knowledge: Sterling Integrator 5.x/4.x, Gentran Server (Unix &Windows), EC-Gateway, Gentran Integration Suite 4.3/4.2/4.1, GXS AI Mapper, WTX 8.x,ECMap 4.1.7/5.1.6, Gentran NT/Windows, Web Methods, EDIFECS SpecBuilder, Transaction Manager, EDISIM, EAM

EDI Standards: ANSI X12, EDIFACT, HIPAA, HL 7 messaging

File Transfer Tools & Protocols: SFG(Sterling File Gateway), MFT (Managed File Transfer), Advanced File Transfer (AFT), Connect Direct, Cleo VL Trader, Harmony, Cyclone

FTP, FTPS, SFTP, HTTP, HTTPS, AS2, SSL, VAN, TCP/IP, PGP, SMTP, SNMP, IMAP, WINSCP:

Transaction sets: 110,214,204, 210, 240, 211,276/277,270/271,278-13/278-11, 601,814, 810, 811, 815, 820, 824, 830, 832, 834,835,837D,837, 844,845, 846, 849, 850, 855, 856, 858, 860, 861, 862, 864, 865, 867, 940, 943, 944, 945, 947, 997 and 999

Database: Microsoft SQL Server 7.0/2005, Oracle 11g/10g/9i

Operating Systems: Windows 95/98/2000/NT/XP, UNIX/LINUX, AIX

Languages: C, SQL, PL/SQL, XSLT, UNIX Shell Scripting

ERP: SAP R/3, Oracle Applications 11i/ERP, SAP, SAP ECC, SAP IDOCS

Other tools: SQL*Plus, Putty, TOAD, Control - M, Ultra Edit, MS Office (Excel, Access, Project, Visio, Word, Outlook)

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

EDI Developer

• Worked mainly on Inbound and Outbound transactions like 810, 820, 832, 844, 850, 855, 856, 860, 865, 870, 875 and 997.
• Worked on different file formats like X12, SAP IDOC, Flat file and CSV.
• Interacted with trading partners and creating standard specifications for various transactions for both inbound and outbound using ANSI X12, EDIFACT (D93A, D96A), SAP IDOC standards.
• Performed Gap Analysis and made necessary changes to the mapping specifications.
• Created mapping specs for new trading partners using Tibco- EDISIM.
• Responsible for Communication AS2, FTP and SFTP setups, involved in the resolving any errors, researching files for Inbound and Outbound EDI documents
• Monitored daily incoming EDI transactions, verified errors, maintained logs, troubleshoot issues.
• Validated mapping specifications and raised defects using HP ALM.
• Modified existing maps in GXS Application Integration mapper (AI Mapper).
• Coordinated with the GXS team, SAP team and business operations team to analyze, fix, test and retransmit the SAP IDocs on a daily basis.
• Worked on different T-codes in SAP like WE05, SE16, ME23n, WE09.
• Created new Business Process for Customer Integration.
• Co-ordinated with offshore teams and participated in Scrum meetings.
• Updated mapping specs for trading partners based on the volume and percentage of successful and failed transactions.
• On-boarded new partners using Cleo VLTrader and Harmony and setup new connections using SFTP, HTTPS, AS2, FTP etc. and monitored business processes and troubleshoot failed processes.
• Worked with SAP team and with GXS team to plan and execute testing. Responsible for Unit and Integration testing.
• Preparing the documentation for internal and external use.

Confidential,South Deerfield, MA

EDI Developer

• Performed user requirements gathering, system architecture, detailed design, installation, map and business process development, mentoring development and production support teams, enforcing standards and best practices, tuning system performance
• Developed new maps and business processes for an SAP implementation project using Sterling Integrator/ Gentran Integration Suite.
• Setup Trading partners, created standard to application and application to standard and pass-thru maps.
• Coordinated with Customers to create Implementation Guidelines.
• Created maps to translate data from X12 format to SAP IDOC formats for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers.
• Created/modified trading partner setup in SAP using WE20 transaction.
• Troubleshoot and reprocessed IDOCS using WE19 and BD87 and Handled discards.
• Wrote shell scripts to automate handling of data discards, data errors, compliance errors etc.
• Provide Production Support for the maps developed in GIS.
• Configured and supported data Managers.
• Created SEF files, Implementation guides and logical maps using EDISIM.
• Configured and used ODBC/JDBC bridges to support Uniform Transaction identifier process to track Transaction across applications.
• Configured SAP, XML adapters to support the business requirements.
• Involved in fine-tuning the maps to increase the performance.
• Created Trading Partner profiles and Management of Communities in Sterling Integrator.
• Used Database Interface Designer to develop type trees based on SQL queries and stored procedures.
• Creating the Business Process Models as per the business requirements Using Graphical Process Modeler.
• Created new mail boxes for various Trading Partners and set the communication workflows.
• Created the work flows to accomplish the Business Process Models using BPML in GIS.
• Migrated Sybase EC Gateway maps onto SI. Validated the maps after testing in Sybase EC Map, EC Gateway and SI correspondingly.
• Improve the models to overcome frequent issues.
• Worked with GIS AS2 edition for exchanging the EDI documents for trading partners with digital signature.
• Configured GIS Needs to understand the data tables in SAP.
• Experience in Troubleshooting of IDoc Errors.
• Scheduled and monitoredSAP Batch jobs processing programs using SM36 and SM37.
• Experience in Validation and Sanity Testing of EDI X12 to SAP IDocs data.
• Performed Unit Testing to test the functionalities.
• Used TOAD to view and develop Database Objects and Scripts.

Confidential,Milwaukee, WI

EDI Developer

• Implemented the following transactions 276/277, 270/271, 278-13/278-11, 820, 834, 837D, 999 for 4010A, 5010 and 5010A compliance.
• 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, adapters, services, service configurations and protocol setups as per business needs.
• Implemented Managed File Transfer (MFT) applications to support FTP/SFTP, HTTP, and AS2 file transfer protocols, especially with AS2 Gateway for decrypt and encrypt for AS2 Partners.
• Collaborate with vendors, trading partners, and internal functional teams to define EDI requirements.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Setup new EDI trading partners 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.
• Used GXS to simplify and enhance business process integration.
• 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.
• Troubleshoot 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 database and vice versa. Created Code lists for various code conversions.
• Created Shell scripts and database scripts to automate document tracking functionality.

Confidential,Albany, NY

EDI Consultant

• Involved in preparing the BRD for the HIPAA implementation by consulting trading partners.
• Involved in Analysis and Implementation of Extranet portal to implement Health Care Management System of HIPAA/EDI.
• Implemented 270/271 Health Care Eligibility Benefit Inquiry and Response transactions.
• The transaction maps developed were ANSI X12 version 4010 270/271, 276/277, 834, 835, 837 and 999.
• Worked on 3040, 4010, 4010A1 and familiarity with 5010 versions.
• Developed Schemas of EDI X12 Claims (837) and Eligibility forms in XML.
• HIPAA Gateway was used for inbound/outbound transactions and code sets complying HIPAA/EDIstandards.
• Created maps for both Inbound and Outbound transactions in Specbuilder.
• Created users in Transaction Manager for new users as per the requested roles.
• Configured Gateway allows using multiple repositories for document management in Oracle 10g and SQL Server 2005 based on the trading partners.
• Worked with SQL statements to extract data from tables and verify the output data of the report on the browser page.
• Used HL7 messaging for the exchange of clinical data. ACK, BAR, ORM, QRY and MDM are the most common used messaging types.
• Used VSS for change control managements of documents by creating versions.
• Executed tests and participated actively in system testing and regression testing.
• Prepared and executed test cases manually for different streams/modules.
• Extensively Tested Extraction, Transformation, and Loading (ETL) processes, data mart table populations, and Analysis and Business Intelligence report generations.
• Perform unit testing on Database access and system testing on Applications by defining use cases in UCD.
• Performed Load testing on the application to adhere to web standards and is always available using Load Runner.
• Coordinated with the developers to develop and modify Design Specification as per the modifications in the BD.
• Positive and negative test cases are written for each features using Quality Center.
• Documented bugs in the process for review and correction in future release.
• Used Scrum to prepare logs and report data to Scrum Master.
• Involve in scrum meetings daily on progress achieved.
• Involved in Project planning, monitoring activities using MS Project and MS Visio extensively.

Confidential,Oklahoma City,OK

EDI Consultant

• Responsible for supporting Oracle Applications Order Entry, Purchasing, Accounts Payable, Cash Management, and Accounts Receivable modules; supporting, troubleshooting, and maintaining a company-wide Electronic Data Interchange (EDI) system; designing, developing, and maintaining custom Oracle Applications queries and programs; and authoring technical documentation including "Feasibility Study", "Functional Specifications", "Design Specifications", and "Test Plan" documents.
• Deployed Maps and Business Processes into GIS.
• Designed, developed, and deployed customizations to Oracle Applications modules using Oracle SQL*Plus, PL/SQL, and Oracle Reports following company coding and development standards.
• Implemented and managed an EDI solution interfacing Trading Partners with legacy systems and Oracle Applications, and managing data to support Order Entry, Purchasing, Accounts Payable, Cash Management, Shipping, and Accounts Receivable departments.
• Assisted in deploying several Oracle Applications modules to replace legacy systems increasing capabilities and streamlining the overall system architecture.
• Design and Implementation of the Web Services using SOAP over HTTP and SOAP over JMS.
• Implemented SOA using Web Services (SOAP over HTTP and SOAP over JMS).
• Conducted various training sessions to familiarize end users with applications and processes.
• Learned the functionality of the Oracle Applications Purchasing, Accounts Payable, Cash Management, Accounts Receivable, and Systems Administration modules to support the end users.
• Developed EDI inbound and outbound routing process using WTX Router map and to route the messages based on Sender ID, Receiver ID, Version and transaction type.
• Developed WTX interfaces to transform EDI data into database and flat file data into EDI data.
• Specified, deployed, and managed a FAX solution to automate Faxing of business-critical documents including Order Acknowledgments, Purchase Orders, Supplier Planning Schedules, Open Purchase Order reports, Advanced Shipping Notices, and Invoices.

Confidential,ST.Louis,MO

EDI Consultant

• Performing GAP Analysis on various transactions like 810, 814, 820, 822, 824, 850, 855,856.
• Created ISA, GS and ST envelopes for trading partners.
• Mapping of various transactions like 810, 814, 820, 822, 824, 850, 855 using AI Mapper.
• Involved in mapping developing in various formats like X12, XML, CSV, SQL and Flat File.
• Created Various Business Processes.
• Created EDI relationship with new Trading Partner.
• Review requirements and created new maps and tested EDI transactions.
• Setting up of FTP, SFTP, AS2 and VAN communications and automate them.
• Testing of various Business Processes.
• Tested EDI files for all EDI syntax errors.
• Data gathering for various transactions.
• SAP Adapter configuration.
• Troubleshooting of Envelopes, Business Processes and Maps.
• Provided Production Support.