Venkata Challa

EDI ANALYST (EDI –IBM GENTRAN/GIS/Sterling Integrator)

Email : adihce@r.postjobfree.com

Contact : 617-***-****

Profile

15+ years of application integration experience with various EDI implementations in GENTRAN: Basic 6.0, Gentran Integration Suite (versions 3.0, 4.1 and 4.3), Sterling Integrator 5.2 IBM products, EDI HQ and TIBCO Suite of Products (TIBCO BW 5.8 and EMS 5.2). Proficient in handling integration system, which is based on Sterling Integrator, Gentran Integration Suite and TIBCO Suite of products. Have sound knowledge of protocols like FTP, SFTP, AS2 and UNIX Shell Scripting, Well-versed in ANSI ASC X12 transactions for HIPAA (837 I/P, 270/271), EDIFACT, Supply-Chain management and Transportation systems transactions.

Summary

•Well-versed in EDIFACT and ANSI X12 transactions 810, 812, 832, 837 I/P, 850, 852, 855, 856 and 997.

•Worked on Transportation Management system related EDI transactions (824, 204, 990, 210, 214 and 997) for major retailers.

•Worked on X12, Flat file, Positional, SQL and CSV format translations in GIS AI mapper.

•Excellent Mapping skill set. Handled complicated looping in Gentran Integration Suite Map Editor and Trading Partners setup such as Involving Documents Envelopes and AS2 Partnership Set-ups.

•Expertise in GENTRAN Basic 6.0. Created transactional maps, application maps, partner setups through mapping maintenance and partner maintenance screens.

•Good exposure on XML technologies for data exchange, presentation, configuration using XML, XSLT, XPATH, CSS, and HTML

•Hands on experience in using File System, Command Line, Lightweight JDBC, JDBC and FTP, SMTP, HTTP adapters, DocToDOM, DOMtoDoc, Translation, XML Encoder, XSLT, Doc Extraction etc.,

•Proficiency in using Gentran Integration Suite (GIS 3.0,4.1 and 4.3) and Sterling Integrator 5.2

•Expertise in Cleo Harmony 5.3 to configure AS2, FTP and SFTP file transmissions with internal systems and external suppliers.

•Proficient in Project Management activities like estimation, resource allocation, time management and RCA.

•Excellent interaction with all levels of management, customers, development team, business teams and vendors.

•Hands on experience in warehouse and transportation transactions 940/945, 943/944, 204/990, 210, 214 …etc.

•Quick to learn new industry standards, different Integration tools and models. Ability to successfully work and lead under tight deadlines.

•Excellent analytical, communication skills and a good team player.

Education

•B.Tech in Electronics and Instrumentation from Acharya Nagarjuna University.

Certifications

•Understanding and Implementing Rosetta Net Business Process Standards (from GS1)

•Certified Agile Program Management -SAFe 4.0 SP

•Trained on IBM WebSphere Transformation Extender V8.4.1.2

Work Experience

•Worked as an EDI Developer in INTEQ Solutions since from Dec 2004 to Jan 2006.

•Worked as a Software engineer in HCL Technologies since from Jan 2006 to Sept 2006.

•Worked as a Technical Consultant in WIPRO Technologies from Oct 2006 to Apr 2013.

•Worked as a Technology Specialist in Cognizant Technology Solutions from Apr 2013 to Mar 2018.

•Working as Sr. Integration/EDI developer in Supplypike from Mar 2018 to till date.

Technical Skills

Databases: Oracle 11g, MS-SQL Server 2000, PL/SQL

E-Com Frameworks/Web Tech: BPML, XML, XSLT

EDI Standards & Formats: EDI X12 (ANSI), EDIFACT, Rosetta Net, HIPAA

XML, FLAT, CSV, EDISIM

EDI Tools: Gentran Integration Suite (GIS) 4.1, 4.3, Sterling Integrator 5.2, GENTRAN Basic 6.0, GXS AI 5.0

GENTRAN Server for Windows/Unix 6.0, EDI HQ, Cleo Clarify, Cleo Harmony, SpecBuilder and EDISIM

Integration Tools: TIBCO Suite of products TIBCO BW, EMS, Admin, Hawk

Functional Areas: Retail, Manufacturing, Health Care, Supply chain& Logistics

Methodologies: Full Life Cycle Development

Operating Systems: MS-DOS, UNIX, Windows NT/2000/XP

Experience

Supplypike, Fayetteville, AR Mar 2018 – till date

ROLE: EDI Technical Lead

Project Description:

SupplyPike is a fast-growing, well-funded startup with a big mission: building the platform for collaborative supply chain. I am the part of Integration space where we Integrate and build end to end EDI solutions for manufactures. Retailers and logistics companies.

Responsibilities:

•Captured new requirements from customers and converted into EDI technical components.

•Created new translation process and maps for common Inbound and Outbound documents.

•Integrating with trading partners via REST, SOAP and EDI.

•Configured new trading partner communication setup through SFTP or AS2.

•Monitor and benchmark existing integrations for speed and error rates.

•Coordinate with the vendor in setting up and testing multiple transaction sets for CPG’s, 3PL’s and Retailers.

Transactions: 940/945, 943/944, 850/810/864, 856, 997, 204, 990, 214, 210

Wal-Mart, Bentonville, AR Apr 2013 – Mar 2018

ROLE: Sr. EDI Developer

RESPONSIBILITIES:

Wal-Mart is the major retailer in the world and complex EDI environment has been build up to support multiple applications. I worked on different programs like WEBEDI Rearchitecture, Annual Enrolment, McLane ASN Flow, Sam’s Liquor, Transportation and many other Projects

The WebEDI system is an online EDI system to manage the Purchase Order, Invoice for Wal-Mart vendors. Vendors share the PO’s through a standardized document called EDI. This is an international standard followed to exchange data between the external party and the retailer. Each country has its own standard name and versions. Wal-Mart works along countries like United States, Mexico, Canada, China and Japan. Transactions: 850, 810, 864 and 997

In the Annual Enrolment 2014 project, we worked on 834 transaction and handled multiple HIPAA vendors. Here Inbound and Outbound flows have been designed between Wal-Mart and HIPAA vendors and communication part has been handled with AS2 protocol.

Coming to McLane project, currently Advance Shipment Notification document (856) is handling manually. We have enabled the 856 EDI flow and developed the Map as per the defined implementation guide and setup the end to end flow to handle these 856 documents electronically.

Due to various regulations, Alcohol suppliers must be paid within a certain time frame that Wal-Mart cannot meet at the corporate level. We are handling Invoices with the third-party system Fintech for alcohol suppliers. We enabled claims (812), Text message (864) for alcohol suppliers and established two different flows for Sam’s and Wal-Mart separately.

Transportation (Global Transportation Project – GTS) involves the upgrade of existing maps from flat file format to XML to enhance and improve the application performance. Here all the existing flat file to EDI maps will be replaced by XML to EDI and vice versa.

Transactions: 824, 204, 210, 212, 214, 990 and 997

RESPONSIBILITIES:

•Created new translation maps in positional format, XML, X12, EDIFACT for both Inbound and Outbound flows in the Wal-Mart EDI environment.

•Created database maps to insert/update the multiple records into database.

•Created new BP’s for new WEBEDI Outbound 850, 864, Inbound 810 and tested the end to end flow in SI 5.2.

•Given the estimates for EDI work [mapping tasks, setting up the complete end to end flow and BP creation/changes] for multiple EDI collaboration projects.

•Reviewed the data maps, BP changes and flow setups developed by offshore team.

•Support the System Integration Testing, UAT and Production Implementation.

•Worked on FTP, SFTP, AS2 protocols, mailboxes and Code lists features in IBM Sterling Integrator.

•Installed the maps, Business Processes (BPML) and other setups as part of new development projects and provided the warranty support.

ENVIRONMENT: Sterling Integrator 5.2, BPML, XML, XSLT, TERADATA SQL Assistant.

EDI Transactions: 810, 812, 850, 855, 834, 864 and 856, 824, 204, 210, 212, 250, 990 and 997.

AHOLD, Canton, MA Sept 2010 – Apr 2013

ROLE: Integration Lead

Project Description A major grocery chain has undertaken a transformation initiative to replace several legacy retail applications with several modules of Oracle Retail. These modules include RPM, ReSA, RMS, ReIM, Foundation data, and RDW. Oracle Retail suite of applications will help the retailer overcome challenges they have with the existing system. Wipro has been selected to migrate the legacy application with several ORACLE Retail Modules.

RESPONSIBILITIES:

•Coordinate with functional team and prepared technical chapters for different Oracle streams Foundation Data, Price and Promo, Finance and Replenishment.

•Involved in requirement gathering phase and captured the EDI requirements for Invoice, Purchase Orders, Advance Shipment Notifications (ASN’’s), Product Activity Report, Invoice adjustments and Cost Changes transactions

•Given the estimates for Integration (Tibco/EDI) work and defined the standard time for mapping, coding, deployment and SIT activities.

•Developed and reviewed the data maps from X12 to XML and XML to X12 for Inbound and Outbound X12 transactions.

•Analyze, Design and Developed the Finance Stream Integration for ORACLE Retail

Implementation Program.

•Support the System Integration Testing, UAT and Production Implementation.

ENVIRONMENT: Gentran Integration Suite (GIS 4.2), XML, TIBCO Business Works 5.8, EMS 5.2, Oracle 11g, Linux, SQL Developer, WINDOWS and AIX. EDI Transactions: 810, 812, 880, 888, 889, 837, 850, 852 and 856.

3M, St. Paul, MN Aug 2008 – Aug 2010

ROLE: EDI Tech Lead

3M EDI System handles most of the inbound/outbound X12 transactions, which are related to Supply Chain Management. Some of the EDIFACT transactions were also developed and deployed.

RESPONSIBILITIES:

•Provided enhancements and production support/maintenance for inbound/outbound EDI

transactions related to supply chain management system.

•The ANSI ASC X12 transactions include 217, 810, 816, 820, 850, 855, 867, 880, and 940.

•Developed application / transaction maps and also provided enhancements for existing maps.

•Well versed with all the screens of Partner Maintenance, Mapping Maintenance and

Databank Maintenance of GENTRAN: Basic 6.0 on IBMMVS system.

ENVIRONMENT: Gentran Basic 6.0 on Mainframe, IBM MVS Standards: X12 and EDIFACT

Cardinal Health, Dublin, OH Apr 2007 – July 2008

ROLE: Sr. Technical Member

Cardinal Health – Pharmaceutical Distribution (PD) IT employs GXS gateway as the messaging gateway for managing its EDI document exchange, with 3500+ Customers. Accurate and timely, reporting and exchange of EDI business documents with its Customers is crucial for Cardinal Health’s PD IT Group’s success. The EDI Infrastructure at Cardinal integrates the AS400 based distrack – Order Management System with the Customer’s Order Management Infrastructure via EDI document exchange automation. This integration of Cardinal’s IT Information Systems with Customer’s Information Systems using EDI is critical for Cardinal’s PD Group to gain the benefits of Supply Chain Integration and Collaborative Commerce Inbound Documents: 850, 180, 997 Outbound Documents: 810, 832, 855, 856, 997, and 858.

RESPONSIBILITIES:

•Provided enhancements and production support/maintenance for inbound/outbound EDI

•Worked on development as well as non-development cases (Production Issues) for different Trading partners as per the request.

•Prepared HLD’s (High level design documents) for the new trading partners for future reference

•Involved in Case assignment to the team members as per the priority and organized the DPM (Defect Preventive Meetings) and new learning meetings.

•Participation in TeleCons and discussions seeking clarifications on requirements.

•Handled tickets based on the priority and informed the issues to the customer within stipulated SLA’s.

ENVIRONMENT: GXS AI, Clarify, Oracle and WINDOWS 2000. Standards: ANSI X12

Sanmina-SCI, CA, USA Oct 2006 – Mar 2007

ROLE: EDI/EAI Programmer Analyst

The project involved the migration work from Gentran server to GIS for a leading electronics manufacturing company. The evaluation process is followed by new implementations and enhancements with support and development.

RESPONSIBILITIES:

•EDI team member for map development and production support and performing every possible function related to Gentran that includes the following:

Setting up and maintaining Trading Partner Relationships. Comm.viaVAN, FTP

Map Development for both inbound and outbound Transactions using Visual Mapper & AI. Modified UNIX shell scripts as and when needed.

•Developing interfaces for both inbound and outbound Transactions.

•Played a major role in developing and testing the entire EDI system.

•Developed Maps from Positional data format to EDI and vice versa for ANSI X12 Standard.

•Created functional specifications documents as per the client requirements.

•Involved in unit testing, system testing, defect logging.

•Customer Communication and co-ordination with onsite offshore teams

ENVIRONMENT: Gentran Integration Suite (GIS 4.2, 4.3), BPML, JDBC, XML, JavaScript, JSP, Oracle, PL/SQL, Java Beans, Gentran Visual Mapper, UNIX and Windows.

LexisNexis, Gurgaon, India Jan 2006 – Sept 2006

ROLE: Programmer

LexisNexis Group operates on a global basis and provides authoritative legal, news, public records and business information and regulatory publications online in CD-ROM formats. A Vista unites innovative technologies and authoritative content to create solutions to support critical decisions. Its tools go beyond research to help increase its customers' productivity. Author2reader is a unique applications framework from VISTA that is designed to accommodate a comprehensive set of publishing solutions and the associated information required to provide publishers continued competitive advantage.

RESPONSIBILITIES:

•Analyzing frequently occurring production support issues and hosting them as a Webstar.

•Created guidelines to resolve the production support issues and documented the same for quick reference.

•Providing Support to enhancement activities as per the guidelines.

•Creating Test cases and performs Unit Testing.

•Participate in Internal code review and provide inputs on the same.

ENVIRONMENT: VISTA 4GL, VMS, MYSQL

ETFS, Canada Dec 2004 – Jan 2006

ROLE: EDI Developer

ETFS Financial Group and its subsidiary Global Excel Management Inc., GEM, is one of Canada's leading health services companies. Before the development of this project, claims were entered manually into CAI for processing. The routing of the paper claims from Payers to other PPO's for re-pricing was done manually. The project was conceived as an EAI driven project to leverage the existing system. The Gentran Integration Suite from Sterling commerce was chosen as EAI hub. All clients and Payers now will be sending claims in either X12 HIPAA compliant or custom formatted EDI. These claims are validated saved into the database and transformed into a format accepted by the existing claim processing systems. The processed claims are then retrieved by the Hub from the existing systems and transmitted back to the Clients/ Payers / PPO's in the respective EDI formats

RESPONSIBILITIES:

•Developed Maps, which translate HIPAA compliant Professional and Institutional data from EDI ANSI X12 data format to XML data format and XML data format to EDI ANSI X12 data format

•Also developed maps, which translate Custom formatted EDI files to XML for storing in e-Repricing database and XML to Custom Formatted EDI file using GIS Sterling Integrator Map Editor.

•Creating Business Processes and archiving it based on the Design Document.

•Developing XSLT’s for generation of report to be sent as attachment with Email

•Added new Trading partners and did the Trading partners setup.

ENVIRONMENT: Health Insurance, GIS 4.0, GIS 4.0, SQL Server 2000, EDI, HIPAA, XML, XSLT, X-Path, BPML, MySQL, FTP and OS: Windows 2000 and UNIX. Transactions: 837I, 837P

Contact this candidate