SUMMARY:

• Over 7+ yrs of experience in EDI and worked as Senior EDI Analyst / Developer with extensive experience in multi divisional corporate EDI environments.
• Highly Experienced in HealthCare, Distribution, Manufacturing, Supply chain, Shipping and Logistics industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
• Experienced with FISGlobal Connexion.
• Have knowledge on XSLT.
• Highly experienced with cXML and xCBL standards.
• Expertise in New trading Partner On - boarding.
• Experience with WTX mapping
• Good knowledge EDI HQ.
• Worked with IBM Sterling Integrator Dashboard.
• Highly Experienced in handling EDI Production Support on 24/7 basis.
• Have very strong analytical and problem-solving skills for the reported EDI Issues.
• Experienced in Data Mapping and Data Conversion using Gentran, GIS, Sterling Integrator, SEEBURGER tools.
• Experienced in data mapping.
• Proficient in Microsoft Excel and Access, including the ability to create and manipulate reports, macros, and pivot tables.
• Hands-on experience in writing complex SQL queries, stored procedures in MS SQL Server Management Studio and Oracle.
• Worked with MFT
• Proficient with different translation tools like SI Map editor, SEEBURGER BIC MD.
• Proficient working with Graphical Process Modeler for designing Business Processes in GIS & SI.
• Worked with Edifecs GBD repository, Edifecs XEngine, Edifecs Spec Builder.
• Experienced in working with AS2, SFTP and FTP communication protocols.
• Experienced in integrating SAP - IBM SI/GIS.
• Experienced with B2B Framework.
• Experienced in migrating data, maps, mailboxes and exception processes while upgrading Gentran.
• Also experienced in the webMethods Trading Networks for automation of B2B transactions, consolidation of B2B integration infrastructure.
• Experienced in various testing phases like Functional, Assembly, Regression and Partner Testing.
• Worked with Business Process Monitoring in GIS, SI and SEEBURGER Frontend.
• Used JIRA in the projects.
• Worked with Scheduling and Performance Tuning of Business processes in GIS/SI.
• Experienced writing SQL queries in Oracle, MySQL and IBM DB2.
• Worked with SAP-ALE Extensions in Gentran Server 6.1.
• Worked with SAP transactions like WE02, WE05, WE19, WE20, BD87, VD53, ZMNU, VL03N, VF03 and ME23N.
• Created Partner Profiles in SAP.
• Worked with COBOL to run JCL for pulling mapping report and partner sample data from Gentran.
• Worked in Mainframes, for Trading Partner data extraction.
• Experienced working with File Formats like ANSI X12, EDIFACT, IDOC, CSV, XML, and legacy specified application file formats.
• Worked with Database mapping in GIS, SI and SEEBURGER.
• Worked on ANSI X12 EDI transactions like 834, 835, 837, 850, 855, 856, 810, 820, 816, 860, 865, 945, and 940, 204, 210, 404, 410 among others.
• Worked on EDIFACT EDI transactions like ORDERS, ORDRSP, DESADV, INVOIC, and REMADV among others.
• Worked with IDOC Structures like ZORDERS, ZORDRSP, ZNVOICE, and ZORDCHG among others.
• Coordinate work for and with other Business Analysts, coordinate Unit Testing tasks, work with Trading Partners for connectivity issues; liaison between customers and corporate staff or between IT and Business Units; perform system matrix testing.
• Involved in various activities present in project life cycle such as Field usage Analysis, FD walk-through, Map group analysis, Map specification preparation, Map build, Unit testing, AT,FAT, Co-ordination with Business teams about defects fixing.

TECHNICAL SKILLS:

Mapping Tools: Sterling Integrator (5.0/5.2.4), Gentran Integration Server (4.2), Gentran Server for windows (3.0), SEEBURGER (6.3.5), BIS 6

Industry standards: ANSI X12, EDIFACT, VICS

EDI Tools: EDISIM 4.0

SQL Editors: MS SQL Server Management Studio 2005/2008 R2/2012, IBM DB2

EDI Transactions: 830, 834, 835, 837, 850, 855, 860, 856, 810, 846,862, 867, 997, 999, 270, 271, ORDERS, ORDRSP, INVRPT, DESADV, INVOIC, SLSRPT, CONTRL, 214, 300, 301, 310, 309,350, 353, 355, 824 and 311

Programming Languages: Basic JAVA, SQL

Databases Access: Oracle 10g, MS SQL server

Operating Systems: Windows 2003/2000/NT, Unix

Communication Protocol: AS1, AS2, HTTPS, FTP and SFTP

Other Software: TEXT PAD, ULTRA EDIT, EDI NOTEPAD, Confidential COMPARE, PEOPLE SOFT, REMEDY TOOL.

PROFESSIONAL EXPERIENCE:

Confidential, HEBRON, KY

EDI Specialist

Responsibilities:

• Define and document EDI business process requirements.
• Work with communication channels like SFTP and FTP.
• Work with ANSI X12 with 850, 855, 856, and 810.
• Monitor business processes for AS2 send/receive errors.
• Onboarding new broker clients and coordinate implementation and testing of new business processes and scheduling with customers.
• Setup the EDI File Layout, defining/enabling Trading Partners within EDI for these various Trading Partners. In addition, enabling the different Transaction Types that the Trading Partners would be using within EDI such as Purchase Orders or Invoices
• Onboard trading partner to AS2 and SFTP.
• Test the end to end connectivity from Test/Development and Production.
• Tested Oracle functionality and reported on progress to Oracle team
• Monitor the flow of data through EDI applications to ensure all operational systems are functioning properly when needed.

Environment: Sterling Integrator 5.2.4, GPM, SAP, UNIX, MS SQL server 2008 R2/ 2012, IBM DB2,Oracle E-Business Suite, DB Script generator, UltraEdit32, MS Excel and MS Word.

Confidential, SHERMAN, TX

Sr. EDI Consultant

Responsibilities:

• Single point of contact for all sterling activities.
• Onboarding new broker clients and coordinate implementation and testing of new business processes and scheduling with customers.
• Supporting existing business processes by monitoring system activities and initiating appropriate corrective action when needed.
• Define and document EDI business process requirements.
• Monitor the flow of data through EDI applications to ensure all operational systems are functioning properly when needed.
• Work with ANSI X12 HIPAA transactions like 834, 835, 837 and 270/271 and 997.
• Work with various Services and Adapters to develop/modify and test Business Processes in SI 5.2.4.
• Implementing changes in existing system and documenting the changes.
• Onboard trading partner to AS2 and SFTP.
• Worked with test translation maps using EDIHQ
• Worked with Typing service and Typing maps to handle partners with flat file processing.
• Develop SQL scripts (queries, stored procedures) in MS SQL server 2008 R2/ 2012.
• Work with communication channels like SFTP and FTP.
• Test the end to end connectivity from Test/Development and Production.
• Monitor business processes for AS2 send/receive errors.
• Primary OnCall support personnel on 24/7 basis.

Environment: - Sterling Integrator 5.2.4, Oxford framework, GPM, SAP, UNIX, MS SQL server 2008 R2/ 2012, IBM DB2, LogistiCAD Import/Export tool, DB Script generator, UltraEdit32, MS Excel and MS Word.

Confidential, JACKSONVILLE, FL

SR. B2B/EDI OPERATIONS TECHNICAL CONSULTANT

Responsibilities:

• Coordinate end to end implementation and testing of new business processes and scheduling with customers.
• Develop & maintain system documentation and workflow materials for various GIS/EDI applications
• Support of existing business processes by monitoring system activities and initiating appropriate corrective action when needed.
• Define and document EDI business process requirements.
• Monitor the flow of data through EDI applications to ensure all operational systems are functioning properly when needed.
• Onboard new customers to EDI.
• Work with ANSI X12 transactions like 214 and 210.
• Worked with creation and translated maps using EDIHQ
• Work with various Services and Adapters to develop/modify and test Business Processes in SI 5.2.
• Gather business requirements with respect to enhancements and new developments.
• Build automation for on- boarding new trading partners.
• Onboard trading partner to Sterling File Gateway.
• Onboard trading partner to AS2.
• Worked with Typing service and Typing maps to handle partners with flat file processing.
• Migrate MS SQL Server table data from SQL Server R2/2012 and migrate SI objects like Business Processes, Maps, Envelopes, AS2 partner setups from GIS to SI
• Develop SQL scripts (queries, stored procedures) in MS SQL server 2008 R2/ 2012
• Work with communication channels like SFTP and FTP.
• Work with the .properties files in SI 5.2.
• Test the end to end connectivity from Test/Development and Production.
• Monitor business processes for AS2 send/receive errors.
• Primary OnCall support personnel on 24/7 basis.

Environment: Gentran Integration suite 4.0, Sterling Integrator 5.2, GPM, SAP, UNIX, MS SQL server 2008 R2/ 2012 and Oracle.

Confidential, PACIFIC, MO

E-COMMERCE & INTEGRATION SERVICES, EDI ANALYST

Responsibilities:

• Participate with applications and functional users in refining business requirements and developing test scenarios.
• GIS System (administration, maintenance, installation, configuration, tuning, and programming)
• Identify appropriate data formats or transactions, as well as communications method, to exchange with trading partners.
• Worked with cXML used in the procurement punch out.
• Work closely with internal business teams to facilitate project completion.
• Provide functional specifications and documentation for business solutions.
• Perform project planning, coordination and management on projects.
• Communicate with managers and business stake holders on project statuses.
• Designed and developed EDI interfaces.
• Led Sterling VAN cost reduction initiative. Migrating high volume trading partners to direct AS2 connections. Saving Ingram Micro $550K annually in VAN charges.
• Designed and developed EDI interfaces with the follow EDI documents, 850, 855, 856, 810, 846, 997, ORDERS, ORDRSP, INVRPT, DESADV, INVOIC, SLSRPT, CONTRL, IDoc, Flat File, CSV, XML.
• Worked with WTX.
• Worked with COBOL to run JCL for pulling mapping report and partner sample data from Gentran.
• Managed the migration of 1600 Trading Partner maps during Migration.
• Conduct hands-on development and testing for EDI mappings
• Provide business rules and process interpretation and documentation for assigned applications and systems.
• Develop file formats in conjunction with the application team or trading partner.
• Perform data communication setup between applications and trading partners.
• Liaison between the client’s internal cross functional teams and new B2B E-commerce partners
• Create detailed mapping specifications between the application format and the trading partner format.
• Provide project turnover documentation to the development team, including data mapping specifications
• Provide Post Production Support.

Environment: Gentran Server for windows (3.0), SEEBURBER (6.3.5), BIS6, GXS VAN, SAP IDOC, EDISIM, EDIINT, EDI NOTEPAD, EDI Transactions (EDI documents, 850, 855, 856, 810, 846, 997, ORDERS, ORDRSP, INVRPT, DESADV, INVOIC, SLSRPT, CONTRL), IBM Mainframe JCL, COBOL, Unix and Java, MS SQL server 2008.

Confidential, OAKHURST, CA

B2B & E-Commerce - EDI Technical Analyst

Responsibilities:

• Analyze and understand the business flow involved in the integrations.
• Responsible for developing technical & functional documentation.
• Developed simple / complex code using flow language for all the interfaces
• Define test scenarios/scripts from business requirements and system requirements.
• Developed the Integrations.
• Worked with EDIFECS and WTX.
• Involved in Unit and Integration testing.
• Analyzed the existing maps for data input and output requirements and created detailed logical map documents (mapping guides.)
• Developed Sterling integrator maps using the mapping guides prepared by me.
• Performed Unit Testing and Regression Testing with 4 months of production data.
• Created Packages for deployment in Production.
• Co-ordinate with the Core Team on the Go-live date.
• On-boarding of New Trading Partners.
• Expertise in END to END testing with suppliers.
• VAN setup.
• VAN checking for our mailboxes.
• Handled 24/7 production support teams L1/L2.
• Responding to the queries from the Business users, Suppliers and Customers.

Environment: Gentran Server for windows (3.0), Sterling integrator 5.2, Inovis, GXS VAN, EDISIM, EDI TEXTPAD, EDI Transactions (EDI documents, 850,860, 855, 856, 810, 846, 867, 888, 997, 940, 943, 944, 944, 945, 947, ORDERS, ORDRSP, INVRPT, DESADV, INVOIC, SLSRPT, CONTRL), Oracle 10g, Toad, SOA front-end and PeopleSoft.

Confidential, LOUISVILLE, KY

B2B & Supply Chain Management - EDI Developer

Responsibilities:

• Developed mapping guides for all the suppliers.
• Developed the maps in GIS.
• Trading Partner setups in GIS.
• Developed SQL queries.
• Deploying of the Maps in Quality environment.
• Performing Unit Testing and Regression testing.
• Re-Testing with all the suppliers in GIS.
• Post Production Support.
• Co-ordination with the Business Teams during the entire project
• Expertise in END to END testing with suppliers.
• Expertise in SMI Testing.
• Sending Test Data such as 830e, 862, 850, and 860 to Trading partner.
• Reviewing the Test Data 810, 846, 856, and 855 received from trading partner.
• Developing Maps in GIS according to the Trading partner specifications.
• Quality and Unit Testing for Maps in GIS Development environment.
• Deploying Maps in GIS Production.
• Trading Partner Setup.
• Monitoring the Maps in Live Environment.
• VAN setup.
• VAN checking for mailboxes.
• Working on Overdue transactions and Rejected 997s.
• Monitoring of Inbound and outbound supplier and customer Transactions.
• Monitoring Error data folder for purged documents at VAN.

Environment: Gentran Server for windows (3.0), GIS (4.0 and 4.2), GXS VAN, EDISIM, EDI TEXTPAD, EDI Transactions (EDI documents, 830, 850,860, 855, 856, 810, 846, 867, 997, ORDERS, ORDRSP, INVRPT, DESADV, INVOIC, SLSRPT, CONTRL), MS SQL server, Toad, PL/SQL, Confidential Compare

Confidential

DATA ANALYST

Responsibilities:

• Developed mapping guides for all the suppliers.
• Coordinate end to end implementation and testing of new business processes and scheduling with customers.
• Define and document EDI business process requirements.
• Monitor the flow of data through EDI applications to e nsure all operational systems are functioning properly when needed.
• Work with ANSI X12 HIPAA transactions like 835, 837, 500.
• Work with various Services and Adapters to develop/modify and test Business Processes in SI 5.2.
• Build automation for on- boarding new trading partners with respect to Pharmacy payments 835.
• Worked with EDIFECS.
• Onboard trading partner to Sterling File Gateway.
• Onboard trading partner to AS2.
• Worked with Typing service and Typing maps to handle partners with flat file processing.
• Migrate MS SQL Server table data from SQL Server R2/2012 and migrate SI objects like Business Processes, Maps, Envelopes, AS2 partner setups from GIS to SI
• Develop SQL scripts (queries, stored procedures) in MS SQL server 2008 R2/ 2012
• Work with communication channels like SFTP and FTP.
• Work with the .properties files in SI 5.2.
• Test the end to end connectivity from Test/Development and Production.
• Monitor business processes for AS2 send/receive errors.
• Primary OnCall support personnel on 24/7 basis.

Environment: Gentran Integration suite 4.3, Sterling Integrator 5.2, AS2, SAP, UNIX, MS SQL server 2008 R2/ 2012 and Oracle.