Resume

Sign in

Data Edi

Location:
Apex, NC
Posted:
March 23, 2020

Contact this candidate

Resume:

PRAMOD REDDY M

Tel: 919-***-**** Email: adce63@r.postjobfree.com

Summary:

Over 9+ years experience in the design, development, and 24x7 production support of Data integration, B2B Integration, EDI, and XML Applications including analysis of business requirements, systems analysis, design, development, production support, testing, implementation, and documentation. Experience in XML Mapping, Business Process Development (BPML), XSLT, XPath. Excellent knowledge of using AS2, FTP and SFTP, Perl Scripts and VAN such as Sterling/INOVIS. Excellent knowledge on Sterling File Gateway (SFG). Good Exposure to work with SAP IDOCs

B2B Integration using IBM Sterling Integrator 5.1/5.2,6.0 Gentran Integration Suite (GIS) 3.0, 3.1, 4.0, 4.1, 4.2, Gentran Server 5.1, 6.0.

EDI – More than 6 years of experience implementing EDI solutions using SAP R/3 IDOCs, ALE, Gentran Server in IT, Retail, Logistics, Financial and Healthcare Industries for various application areas including sales and billing

Involved in Mapping of EDI ANSI X12 transactions 270, 271, 276, 277, 300, 301, 315, 304, 310, 810, 820, 835,846, 850, 855, 856, 860, 865,875,880,888 997, 940,943,944 and 945.

Extensive experience in developing transaction sets in EDI and data mapping and data conversion across like Healthcare, Banking, Logistics, Distribution, Finance, Material management applications.

Expertises in EDI X12 HIPAA transactions 837, 835, 270/271, 276/277, etc.

Worked as a Mapper on various X12 and EDIFACT based transaction sets including 850,880,875,846,856,860,837,835,810,865,867,940,943,944,945,888 and 852.Excellent mapping skill set. Handled complicated looping in GIS/SI map editor.

Possess development and implementation experience in EDI ANSI X12, HIPAA, VICS, UCC, EDIFACT, XML, Sterling Integrator, Sterling’s Gentran Server on UNIX, Gentran Integration Suite (GIS), GXS Application Integrator Workbench, GXS Enterprise Gateway & XML/XSLT applications.

EDI Tools & Engines - GIS Map Editor, Visual Mapper, Application Integrator

Nature of Expertise in Gentran: Mapping, translation, Trading Partner setup and maintenance, Server Scripting, Data Managers.

Automating data loading, extraction, mapping, conversion, reports generation using SQL, PL/SQL, and UNIX Shell scripting.

Experience in creating Inbound and Outbound mapping and Business Process using Graphics Process Modeler and BPML (Business Process Model language) for EDI, ANSI X12, EDIFACT and HIPPA Standards.

Experience in creating inbound and Outbound Web Services API/REST Business Process

Experience in preparing Test cases, Test plans and executing Gap Analysis.

Extensive Experience in SQL/PL SQL, Stored Procedures and Triggers.

Extensive Experience in preparing Test Plans, Test Scenarios, Test Cases and executing them based on the Business rules and System requirements.

Worked on XML Schema, DTD using XMLSPY. Design & development using Java, Oracle, JavaScript, XML, HTML, UML & Rational Rose

Strong leadership, interpersonal, analytical and communication skills.

Excellent ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

Education:

Bachelor’s Degree in Computer Science.

Technical Skills:

EDI Mapping

IBM Sterling Integrator 5.0/5.2,6.0, Gentran 5.1/5.3/6.0/GIS, Sybase EC Map, GXS AI Mapper/Workbench, GXS Enterprise Gateway, TLE Server 4.2, Cyclone, Connect: Direct.

Transaction sets

X12 - 835,837,270,271,276,277,278,204,210,214,410,834,810,820, 830,832,850,846,855,856,857,862,867,879,875,880,888,944,945,940,846,943,947 and 997

Application Server

Gentran 5.2,5.3,6.1, Sterling Integrator 5.0/5.1 (GIS 4.2/4/3)

Programming Languages

SQL, PL/SQL, C, Java, Cobol, Unix Shell Scripts (Korn/Bash), XSLT

Web Technologies

XML, HTML, XSLT, Web services

Testing Tools

QTP 9.2, Quality Center 9.0/10.0, Win Runner 7.5, Load Runner 7.8, Rational Clear Quest, Claredi

RDBMS

Oracle 8i/9i/10g, MS SQL Server 2000/2005, DB2, MySQL, Toad

Development Tools

Ab initio, Cognos Report net

Operating Systems

Windows 2007/ 2003/2000/NT, MVS, UNIX, LINUX

Packages

MS Office, CVS, PVCS, adobe master collection

Comm Protocols

FTP, HTTP, SFTP, SMTP, Light weight JDBC, TCP/IP,VAN, PGP, PKI

Other Tools

PUTTY, WS FTP, UltraEdit, Telnet, control – M, EDIFECS Tools, and BMC Remedy tool, DB Visualizer, AES Routing tool.

Professional Experience:

Advance Auto Parts, Raleigh, NC Jul 2019 to Present

Role: - Sr.EDI/Sterling Integrator Developer/Analyst

The project is to Design, develop, implement and support Automobile and Retail EDI Integration applications on IBM Sterling Integrator 5.2 and 6.0 and Oracle11g SQL/PL SQL.

Responsibilities:

Created maps for different transaction with different file formats XML, X12, CSV and Flat files.

Design and Development EDI and Non EDI maps and Automated Business Processes.

Created Code lists for various code conversions.

Developed and updated 810,830,850,855,856,860,862,875,880, and 997 using the X12 standard and flat files Inbound and Outbound Transactions.

Working with the Business teams for SIT and UAT testing

Created Business Process to monitor mailboxes and generate alert notifications.

Created New Business Process for Inbound and Outbound process.

Worked on routing rules for mailboxes, Boot strapped Business process to read batch files, translate, and route them to internal systems.

Created maps to translate data from X12,csv format to SQL format and SQL format to Flat File format for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers

Created maps to translate data from X12 format to IDOC positional format for Inbound Orders, Developed from Scratch level with complicated mapping rules with Database code lists.

Performed logical mapping changes for Retail transaction sets to-and from Orders, Material Master and Shipments. Created and modified maps in SI mapper

Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.

Created new maps and envelopes for syncrofy data monitoring web portal based on the Business requirement.

Developed Maps to and from trading partners to Internal Order Management applications (IDOC’s and SQL) in supporting Delivery Order, Goods Receipt, and ASN etc.

Configured Data source for SQL/PLSQL data mapping.

Configured Database ODBC connections for SQL data mapping.

Developed Data Transfer Business process for loading the input data into Database table.

Developed LWJDBC SQL Generic Adapter for data Extraction from SQL format to xml format.

Developed Generic File System Adapter for Input Data file Collection and Output Data file Extraction.

Developed on fault Business process for Error handling and for email notification.

Implemented new xpath codes for retrieving data from the processdata.

Created Database Tables and Database tables configured DB Table to Sterling Integrator map editor for SQL mapping.

Created new properties files and deployed into SI NFS folders.

Developed xpath to import property file information to Business process through scientific get method.

Developed SQL and PL SQL queries for map translation and Import data from Database tables.

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.

Created Flat File to XML and XML to Flat file also Flat file to Flat file envelopes.

Onboarding new trading partner setup.

Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.

Developed Business Process new BP’s from Scratch and modified/changes in existing Business process.

Created new mailboxes and enhanced existing business process to add new mailboxes for syncrofy Transactions monitoring web portal.

Developed new API REST Web Services for both directions Inbound and Outbound.

Developed and Configured Java Scripts in Sterling Integrator services for JSON to xml conversion and XML to JSON conversion.

Developed new API SOAP web services for both Inbound and Outbound directions.

Configured AS2 connections, Templates, Channels and testing.

Created new Actions and Setups for Inbound and Outbound file transfers with java scripts.

Scheduled Business process in B2Bi.

Created mailbox routing rules for Business process execution.

Created Routing rule execution Business process using with Routing rule Evaluation service.

Working with Tivoli Job schedules team for scheduling the jobs.

Troubleshoot and resolved XSLT mapping issues and adapter failures/discards.

Created new XSLTs for email notification body and message.

Updated and enhanced existing On-fault services.

Experience in Troubleshooting of EDI ANSI X12 and other format data issues.

Involved in writing test cases for the EDI maps and tested using HPQC.

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.

Created and maintained all test cases in HP Quality center (HPQC).

Develop and Execute the Test Cases for Functional, Integration and regression testing.

Prepared Documentation, all activities involved in this project design and Implementation process.

Environment: IBM Sterling Integrator 5.2.4, 6.0.2.0, Secure Transport, Oracle 11g SQL/PL SQL, EDISIM, VL Trader (Cleo Harmony 5.2), Sterling File Gateway(SFG), FileZilla, Dimensions, Ultra edit, Notepad++, Beyond Compare, Microsoft Visio, Windows10, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, AS400, GXS AI & Enterprise

Kellogg’s Co, Oakbrook, IL Feb 2016 to Jul 2019

Role: - Sr.EDI Developer/Analyst

The project is to develop, implement and support Retail and Logistic EDI Integration applications on IBM Sterling Integrator 5.2 and Oracle11g SQL/PL SQL.

Responsibilities:

Created maps for different transaction with different file formats XML, SPEC200, EDIFACT, X12, Flat file.

Design and Development EDI and Non EDI maps and Automated Business Processes.

Developed and upgraded EDI and database maps for transactions 810,830, 850,852,270,271,855,856,862,875,880,944,945,846,870,888,940,943, and 857 using the X12 standard and flat files Inbound and Outbound Transactions.

Created Code lists for various code conversions

Working with the Business teams for UAT testing

Created Business Process to monitor mailboxes and generate alert notifications.

Created New Business Process for Inbound and Outbound process.

Worked on routing rules for mailboxes, Boot strapped Business process to read batch files, translate, and route them to internal systems.

Created maps to translate data from X12,csv format to SQL format and SQL format to Flat File format for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers

Created maps to translate data from XML format to IDOC positional format for Inbound Orders, Developed from Scratch level with complicated mapping rules with Database code lists.

Created maps to translate data from X.12 format to SAP IDOC and SAP IDOCS to X12 formats for Orders, Order confirmations, ASN’s, Inventory snapshots, Shipment status and Inventory Transfers.

Performed logical mapping changes for Retail and Logistics transaction sets to-and from Orders, Material Master and Shipments. Created and modified maps in SI mapper

Created IDOC Extension for Orders05 for Outbound.

Worked on various kinds of SAP IDOCS ORDERS, INVOIC, MATMAS, DELVRY, DESADV etc.

Working and Experience in 3PL (Third Party Logistics) projects.

Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.

Developed Maps to and from trading partners to Internal Order Management applications (SAP IDOC’s and SQL) in supporting Delivery Order, Goods Receipt, and ASN etc.

Configured Data source for SQL/PLSQL data mapping.

Configured Database ODBC connections for SQL data mapping.

Developed Data Transfer Business process for loading the input data into Database table.

Developed LWJDBC SQL Generic Adapter for data Extraction from SQL format to xml format.

Developed Generic File System Adapter for Input Data file Collection and Output Data file Extraction.

Developed on fault Business process for Error handling and for email notification.

Implemented new xpath codes for retrieving data from the processdata.

Created Database Tables and Database tables configured DB Table to Sterling Integrator map editor for SQL mapping.

Developed SQL and PL SQL queries for map translation and Import data from Database tables.

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.

Created Flat File to XML and XML to Flat file also Flat file to Flat file envelopes.

Onboarding new trading partner setup.

Created Adapter utilities SAP Route-XREF channels Inbound and Outbound.

Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.

Developed Business Process new BP’s from Scratch and modified/changes in existing Business process.

Developed new API REST Web Services for both directions Inbound and Outbound.

Developed and Configured Java Scripts in Sterling Integrator services for JSON to xml conversion and XML to JSON conversion.

Configured AS2 connections, Templates, Channels and testing.

Configured Cleo Harmony Actions for managed file transfer.

Worked on PGP Keys installation for encryption and decryption.

Created new Actions and Setups for Inbound and Outbound file transfers with java scripts.

Scheduled Business process in B2Bi.

Working with Tivoli Job schedules team for scheduling the jobs.

Troubleshoot and resolved XSLT mapping issues and adapter failures/discards.

Experience in Troubleshooting of IDoc Errors.

Involved in writing test cases for the EDI maps and tested using Quality Center.

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.

Created and maintained all test cases in HP Quality center (HPQC).

Develop and Execute the Test Cases for Functional, Integration and regression testing.

Prepared Documentation, all activities involved in this project design and Implementation process.

Environment: IBM Sterling Integrator 5.2.4, Secure Transport, Oracle 11g SQL/PL SQL, EDISIM, VL Trader (Cleo Harmony 5.2), Sterling File Gateway(SFG), FileZilla, Dimensions, Ultra edit, Notepad++, Beyond Compare, Microsoft Visio, Windows7, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, SAP IDOCS, AS400, GXS AI & Enterprise

CVS Health, Buffalo Grove, IL Nov 2014 to Jan 2016

Role: - Sr.EDI Developer/Analyst

The project is to develop, implement and support Insurance EDI and EAI Integration applications on IBM Sterling Integrator 5.2 and Migration from FTP to SFTP and Sterling Integrator Upgrade from version 5.2.4 to 5.2.5

Responsibilities:

Responsible for development and implementation of HIPAA 834, 835, 836 and 837 Transactions.

Worked with various data formats like XML, SQL, Positional, Flat files, Delimited and EDI/X12

Responsible for creating logical and physical maps inbound and outbound.

Designed, Developed and Maintained EDI Maps with the specified business rules. HIPAA map transactions:837 v4010/5010 Health Care Claim 835 v4010/5010 Health Care Claim Payment Advise

Created Code lists for various code conversions.

Created Standard file layouts by using the Cobol Copy Books.

Responsible for developing maps that checks for valid partners as preliminary check and separates the valid and invalid EDI documents

Responsible for analyzing, implementing, testing, monitoring the changes and moving to Production support.

Expertise in setting up migration mapping from older versions to newer versions.

Involved in support, problem solving, data correction and map changing based upon requirements.

Performed logical mapping changes for 834 and 835 transaction sets to-and-from claims and billing applications. Created and modified maps in SI map editor.

Responsible for staging of EDI systems in Development, Testing and Production.

Testing the EDI files for all EDI syntax errors.

Developed the test scripts and test data for unit testing, system testing and integration testing

Responsible for HIPAA Compliance & Testing of HIPAA 834, 835, 836 and 837 Transaction.

Created test plans for all maps and coordinated with QA Team on any defects.

Involved in Analysis, design, development and documentation of interfaces.

Participated in designing application file layouts and EDI layouts for 837 and 835.

Develop the test scripts and test data for unit testing, system testing and integration testing.

Performed End to End testing in SFG to confirm the files are making through the end to end process

Worked on CVS Caremark internal process like COLA for library names and Dimensions for document packaging and push for production.

Experienced with AXWAY B2B environment and understanding AXWAY protocols FTP, SFTP, AS2, HTTP, HTTPs, and SMTP.

Provided Axway mapping documents for File Transfer.

Worked with Managed File Transfer (MFT) and Axway team and Integration teams to document Source to Target mapping and EDI Mapping.

Involved 4010/5010 Trading partner set up, trading partner implementation process and maintenance for all trading partners, working with the ANSI X12 EDI standards, and interfacing EDI with internal business applications

Set up Trading Partner relationship in the Production, Testing, and Development environments.

Involved in the volume testing for SI Upgrade project form v5.2.4 to v5.2.5

Used my file gateway and Sterling file gateway for test file upload and retrieve output results in SI upgrade volume testing.

Developed and Implemented Perl scripts for SFTP Migration in Workhorse.

Updated PROCID’s from ws_ftp to psftp in Test Environment and ran the test files.

Successfully test completed procid’s updated into the Production related files (data. base. Check, database.pdmtoql.csv, data.base.eligibility.csv etc.).

Reviewed updated script with current production file, finalized for production move, and moved to production with the help of file Transfer tool IPSWITCH or FileZilla.

Changed different Transmit sites scripts in workhorse from ws_ftp to psftp such as MVS (mainframe related files), DALCDCP, Secure Transport, SI_GIS_834_PROD, DMZ02 etc.

As per requirements created new procid’s and clone procid’s for different, transmit sites.

Created new procid’s in Internal SFTP migration project and external migration project.

Involved in Analysis, design, development and documentation of interfaces of SFTP Migration project.

Participated in Single thread files script changes and also changed scripts from ws_ftp to movetoweb

Developed Perl Scripts for changes of PROCID’s from ws_ftp to movetoweb.

Used Cola for required information gathering for migration process.

Supporting production issues during the warranty period.

Complete coordination with the team on day-day operations and ongoing projects.

Involving in SI Security Compliance project.

Environment: Workhorse,IBM Sterling Integrator 5.2.5,Secure Transport, Ultra edit, Notepad++,Microsoft Visio, Windows7, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, SAP IDOCS, MS SQL Server (SQL, T-SQL, SSIS),EDISIM, Sterling File Gateway(SFG), IPSWITCH,Remote Desktop, FileZilla, AS400,GXS AI & Enterprise.

PENGUIN RANDOM HOUSE, MD Sep 2014 to Nov 2014

Role: - Sr.EDI Developer/Analyst

The project is to develop, implement and support Retail and Logistic EDI Integration applications on IBM Sterling Integrator 5.2.

Responsibilities:

Designed and developed the Mapping specifications for the New Trading partners.

Set up new trading partners and maintain existing partners

Created new maps based on the customer's requirements on the Sterling Integrator's Map editor and setting up the trading partnership and configuring the data managers.

Developed and upgraded EDI maps for transactions 810,830,850,852, 855, 856,857,860,862,864 and 880 using the X12 standard.

Used Generic map to Developed/Modify custom maps based on the client requirements.

Involved in solving IDOCs issues and implemented changes as per the business requirements.

Maintaining Code lists based on the customer requirements.

Configured envelopes for new Trading partners.

Working with Implementations team to develop, and move the maps to Production

Set up new trading partners in SAP.

Translating the data from ANSI X12 to text format in inbound process using the translator.

Created maps for Application-to-Application, Standard to Application and Application to standard.

Exchanged documents within EDI, B2B environments and Trading Partner business Integrations using GENTRAN.

Performed migration of maps, BP's, service configurations, and adapters from Gentran Server to Sterling Integrator Created new Business Process for Customer Integration Project using Graphical Process Modeler and BPML

Proficient in creation, modifications, testing of envelopes, maps, business process, service/adapters and AS2/FTP communications.

Configured and implemented Sterling file gateway process.

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.

Responsible for production support Issues.

Maintenance of EDI Documents, data managers, and Gentran life cycle Database.

Worked with configuration of data managers.

Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.

Responsible for analyzing, implementing, testing, monitoring the changes and moving to Production support.

Trouble-shooted and resolved XSLT mapping issues and adapter failures/discards.

Performed content Gap analysis and identified the necessary changes to the business rules for applicable elements.

Created Maps for the Business Failures for generating the Error Report to the Business analyst Team.

Involved in support, problem solving, data correction and map changing based upon requirements.

Responsible for staging of EDI systems in Development, Testing and Production.

Testing the EDI files for all EDI syntax errors.

Involved in Analysis, design, development and documentation of interfaces.

Environment: Sterling Integrator 5.2.4,Secure Transport, Dimensions, Ultra edit, Notepad++,Microsoft Visio, Windows7, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, SAP IDOCS, MS SQL Server (SQL, T-SQL, SSIS),EDISIM, Sterling File Gateway(SFG), FileZilla, AS400,GXS AI & Enterprise.

CVS Caremark, Buffalo Grove, IL Nov 2013 - August 2014

Role: - EDI Developer

The project is to develop, implement and support Insurance EDI and EAI Integration applications on Sterling Integrator 5.2.

Responsibilities:

Implemented 834 transactions for 4010 and 5010 compliance.

Involved in map development, testing and implementation for EDI transactions 834 and also Flat files like 1000 and 500 byte layouts in Sterling Integrator 5.2/GIS 4.3

Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator Map editor.

Responsible for staging of EDI systems in Development, Testing and Production

Implementation of Custom layout maps and multi carrier Clients.

Developed custom Data Definition File (DDF’s) for positional maps using COBOL copybook format.

Built a channel to send and receive files using SFTP protocol.

Create SFG-communities, partners, groups, routing rules, templates, static and dynamic routing channels and remove special characters from files

Created new Code Lists as per the trading partner requirements

Responsible for importing and exporting packages from development regions to PROD and vice versa.

Involved in setting up of Trading Partners Envelopes for multiple transactions in Sterling Integrator.

Worked on Dual transaction Maps for QL and Client Connect.

Configured and implemented Sterling File Gateway (SFG) for various TP transactions.

Accomplished complex business logics in the maps using User Exists, Extended rules, Standard rules and Xpath statements.

Interacted with Business team to gather requirements/ specifications.

Created test plans for all maps and coordinated with QA Team on any defects.

Responsible in Unit Testing and troubleshooting all the maps.

Performed End to End testing in SFG to confirm the files are making through the end-to-end process.

Worked on Change/Heat tickets for any required changes to support the production Environment.

Worked on COLA and Secure transport to insure the file routing.

Worked on CVS Caremark internal process like COLA for library names and Dimensions for document packaging and push for production.

Working knowledge of HP Quality Center 10.0 for defect resolution, ticket generation and management with in-house quality testing team.

Worked on PGP Script Correction, encrypt, and decrypt.

Environment: Sterling Integrator 5.2.4,COLA, Secure Transport, Dimensions, Ultra edit, Notepad++ Microsoft Visio, Windows7, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, SAP IDOCS, MS SQL Server (SQL, T-SQL, SSIS),EDISIM, Sterling File Gateway(SFG), FileZilla, AS400,GXS AI & Enterprise.

3M Corporation, Maplewood, MN Mar 2013 – Nov 2013

Role: Sr. EDI Consultant

Responsibilities:

Created new maps and Custom Maps for various transactions using Gentran Integration Suite/Sterling Integrator for both inbound and outbound transactions.

Develop/Modify EDI maps using Sterling Integrator’s Map editor. Configured and implemented Sterling file gateway process.

Mainly involved in creating maps of various transaction sets included Inbound and Outbound: 810, 820, 823, 830,832, 850, 852, 856, 860,862, 875 and 997.

Strong Mapping Experience in 4010 to 5010 Conversion.

Experience in Troubleshooting of IDoc Errors.

Worked on different IDOCS for inbound and outbound maps DELFOR, ORDERS, INVOIC, DESADV, DELJIT etc.

Installed and configured Sterling File Gateway on clustered environment in Unix

Developed Routing Templates and Routing Channels in SFG and associated Producers and Consumers

Created Regular Expressions and file Structures in SFG

Created new mailboxes and applied mailbox routing rules

Created Dynamic and Static routing templates to route files to different mailboxes.

Worked on Different communication protocols such as HTTP,HTTPS,FTP,SFTP,SMTP and AS2

Developed web services or consumed 3rd party WSDL to call web services

Experience in Validation and Sanity Testing of EDI X12 to SAP IDocs data.

Performed Unit Testing and Framework Testing to test the functionalities.

Creating Test cases, Test scripts as per the design documents (both Functional and Technical Designs) and Coordinating Quality Center with QTP as per the design documents.

Managed defects and issues with in-house issue tracking product (Team track).

Wrote test plans and test cases based on business requirements, functional document.

Reviewed the approved test runs.

Experience in Map Errors Controlling and Trouble Shooting.

Configured, tested, 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).

Interacted with trading partners and creating standard specifications for various transactions for both inbound and outbound using ANSI X12, EDIFACT (D93A, D96A) standards.

Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.

Experience in Custom MRS Creation.

Provided 24X7 production support and also involved in various knowledge transfer sessions

Provide Production Support for the maps developed in Sterling Integrator.

Environment: Sterling Integrator 5.1/5.2, Ultra edit, Microsoft Visio, Windows7, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, SAP IDOCS, DB Visualizer, MS SQL Server (SQL, T-SQL, SSIS),EDISIM, Sterling File Gateway, UNIX 6.0, Putty, FileZilla, GXS AI & Enterprise.

BASF, Piscatway, NJ Oct 2011 - Feb2013

Role: Sr. EDI Consultant

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, 850, 852, 856, 860, 875 and 997 on daily basis.

Responsible for creating logical and physical maps, business processes, adapters, 24x7 production support of EDI applications.

End to end implementation of on-boarding vendors to Vendor Portal. Including initial vendor communication to set up transfer protocol, request and review test file, document and transform vendor charge codes to portal charges, logical and physical map, testing, monitor go live process and production support.

Performed migration of maps, BP's, service configurations, and adapters from Gentran Server to Sterling Integrator Created new Business Process for Customer Integration Project using Graphical Process Modeler and BPML.

Proficient in creation, modifications,



Contact this candidate