Edi Developer/ Production Suppt Analyst Resume
OR
SUMMARY
- Over 9 years of IT experience in developing, implementing and supporting transactions in EDI ANSI X12, Sterling’s Gentran Server on UNIX, Gentran for iSeries(IBM AS400),Gentran Integration Suite (GIS) & XML/XSLT applications.
- Well versed in complete software development life cycles which include design, development, testing and production.
- Demonstrated success in implementing EDI ANSI X12, X12N/HIPAA & EDIFACT standards.
- Experienced in HIPAA (Health Insurance Portability and Accountability Act), Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing. Well versed with EDI and HIPAA transactions.
- Hands on experience in HTTP, FTP, FTPS, SFTP, MQ, SMTP, AS2, AS3 and VAN communication protocols.
- Managed a large number of partners and protocols efficiently using Sterling File Gateway Application.
- Created Routing Channel Templates and Routing Channels between Consumer and Producer.
- Expertise in creating and configuring Business Processes using GPM and BPML.
- Experienced in EDI Transactions 110, 114, 204, 214, 270, 271, 276, 277, 278, 810, 820, 823, 830, 834, 835, 837, 846, 850, 852, 855, 860, 861, 867, 870, 875, 940, 943, 944, 945, 947, 990, and 997.
- Expertise in mapping application format to standard format and vice - versa.
- Provided analysis design and development of uploads received from a third party system in which we were given .CSV formatted files, uploaded them to the iSeries via FTP, arranged the data into arrays, and processed the data via RPG Programming.
- 2+ years of experience in Business-to-Business Integration (B2B) and Enterprise Application Integration (EAI) using various webMethods tools and technologies.
- Expertise in Database Management, Data Analysis, System Integration.
- Expertise in setting up migration mapping from older versions to newer versions.
- Working Knowledge on upgrading from TLE to Gentran on Unix 6.0 and SI 5.2.
- Expertise on EDIFECS, EDISIM & MQ series as Middleware tools.
- Experience in creating maps using Gentran Server on UNIX and Windows configuring & interacting with trading partners in laying standard specifications for various transactions for both Inbound & Outbound Mapping using EDI / HIPAA ANSI X12 standards.
- Experience in support and development of B2B EDI Application’s on UNIX environment as well as Mainframe environment and also knowledge on SAP IDOCS and SAP EDI.
- Experienced in configuring Shared Service Providers, configuring SharePoint security and backup and restore of the portal.
- Ability to communicate effectively with customers to eliminate disruptive situations.
- Good proficiency using Microsoft Excel, Microsoft Word & MSVISIO.
- Proven strength in problem solving, coordination and analysis.
- Strong experience in multi-tasking and meeting deadlines in time.
- Achievement oriented with excellent people management skills and an ability to manage change with ease.
- Highly appreciated by clients for problem solving skills during critical situations.
- Strong communication, interpersonal, learning and organizing skills matched with the ability to manage stress, time and people effectively.
TECHNICAL SKILLS
EDI Standards: ANSI X12, TRADACOMS,UCS, VICS, Rosettanet(PIP), and EDIFACT
Specialization: Electronic Data Interchange (EDI) X12 and EDIFACT transactions 204,210,220,214,810,820,823,830,846,850, 852, 856,860,861,867,870, 945,990,835,837, 276/277, SAP IDOCS
EDI Tools: Sterling Integrator 5.2, Gentran for iSeries (IBM AS400) Sterling file Gateway 2.2, Sybase (ECMAP), EDIFECS Spec builder, X-Engine Gentran integration suite 4.3, SAP R/3, SAP-EDI interface JDE, GXS AI Mapper, Inovis(Harbinger)TrustedLinkEnterprise etc.
Data: HTML, XML, DTD, Schemas, ASCII, CSV, Reports, Notifications
Languages: Java, COBOL, Unix Shell Scripting, XSLT, Javascript, Perl, and ABAP/4
Software: SQL, PL/SQL, Oracle 10g/8i, SAP R/3, Web Logic Server.
Databases: MS Access 2003/Jet, Oracle 10g/8i, MS SQL Server 2005/2008, DB2.
O.S.: Windows Server 2003, Unix (SCO UNIX, Sun Solaris, AIX), Linux.
Hardware: IBM Compatible PCs, Pentium, HCL, Wipro and HP Servers
Others: DB-Artisan, Erwin, Toad, EDISIM, EDIFECS Spec Builder
Applications: SAP ECC 6.0, Sales, Financials, Order, warehouse and Inventory System
Comm Protocols: FTP, HTTP, SFTP, FTPS,OFTP, HTTPS, AS2, TCP/IP, PPP, SNMP, IMAP, PKI PGP, Sterling File Gateway, Advanced File Transfer, SSH, SSL.
PROFESSIONAL EXPERIENCE
Confidential, OR
EDI Developer/ Production Support Analyst
Responsibilities:
- Created maps for retail transactions 850, 810, 856, 860, 832, 846 using Sterling Gentran for iSeries (IBM AS400).
- Responsible in setting up Trading partner Identities, Envelopes, File system, Rule Groups and communication profiles using Sterling Gentran for iSeries (IBM AS400).
- Acted as EDI Co-ordinator with clients to on board trading partners.
- Evaluated and monitored various transactions in JD Edwards Order management system.
- Monitor inbound and outbound transmissions for errors. Communicate status of errors and conduct follow-up resolution with internal and external customers.
- Document EDI activities, schedules and maintain the EDI database of customers and status.
- Internal and External testing of EDI documents that include coordination of information from Customer Service, Distribution, Information Systems, Customers, VAN’s and AS2.
- Developed various Business Process using GPM and BPML as per the business requirements.
- Coordinate with Integration Support Operations and Technical services team on communication issues related to customer and third party vendor connectivity.
- Transferred files through FTP to customer for Data verification using PGP encryption.
- Experience with Invois BizManager for trading partner community management, tracking and auditing.
- Involved in migration of maps from Gentran iSeries to Gentran integration suite 4.3(GIS).
- Created XML Schemas for 810, 850, 860, 832, 846 transactions sets using XMLSpy and Ultra Edit / Ultra Compare.
- Worked on XSLT for extracting desired data from interim XML files.
- Involved in developing and modifying existing maps as per the business requirement.
- Performed Unit Testing on Developed Maps.
- Provided efficient technical support during and after implementation for EDI configurations and setup.
- Acted effectively as point-of-contact on status of EDI transactions from internal and external customers.
- Performed Unit Testing on Developed Maps.
- Educated and trained staff of assigned business areas on EDI applications.
- Developed and prepared EDI documentation for internal and external use.
Environment: GIS 4.3, Gentran 5.2, Sterling Integrator 5.1, Inovis Bizmanager, Sterling File Gateway 2.2.2, XML, XSLT, XMLSpy, HTML.
Confidential, CT
EDI Developer/ Analyst
Responsibilities:
- Created ASN (Advance Shipping Notice EDI X12 856) that comes in ANSI X12 format from trading partners.
- Created Warehouse ASN Standard and Pick & Pack transactions from the scratch.
- Created IG’s & Applications based on the customer requirements.
- Translated the data from ANSI X12 to text format in inbound process using the translator.
- Created Trading Partner profiles and Management of Communities in Sterling Integrator 5.1.
- Created the Business Process Models as per the business requirements using Graphical Process Modeler.
- Managed all B2B inbound 850 rejections and any invoice rejections.
- Developed maps for following transaction sets: 810, 820, 830, 832, 850, 852, 855, 856, 857, 864, 867, 875, 879, 880, 940, 945 and 997 using Sterling Integrator 5.1 map editor.
- Provide Production Support for the maps developed in Sterling Integrator and Involved in fine-tuning the maps to increase the performance.
- Used Standard and Extended rules as a part of mapping various transactions and created the Envelopes for trading partner transactions.
- Setting up the Business Process and configuring the BPML’s.
- Updated and resolved tickets and worked with users to correct the invoice and resend.
- Sending an acknowledgment (EDI X12 997 Functional Acknowledgment) to the trading partners.
- Created new Code lists based on the customer requirements.
- Translated the data from XML to ANSI X12 format and vice versa.
- Developed UNIX shell scripts to automate file discards due to data errors. Also wrote notification mechanisms.
- Developed UNIX based FTP routines to successfully deliver data to destinations providing Guaranteed Delivery Layer.
- Created the Enveloping for trading partners.
- Managed ecommerce email queues.
- Created the workflows to accomplish the Business models in the Business process Models using the BPML in SI 5.1.
- Developed Maps to and fro from trading partners to Internal Order Management applications in supporting Delivery Order, Goods Receipt, and ASN etc.
- Responsible for trouble shooting the Business Process models in application connectivity.
- Created XML maps and configured the corresponding adaptors as per the business requirements.
- Worked with Sterling Gentran AS2 edition for exchanging the EDI documents for trading partners with digital signature.
- Created AS400 RPG and PC programs that would electronically transmit current month’s account receivables to a major bank for funds processing. When the invoices matured and funds transferred, a file would be electronically received and processed on the AS400 to create transaction history records and update A/R files for invoices paid.
- Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
- Experience in EDI Auditing and Maintenance of EDI Documents and Sterling Integrator life cycle Database.
- Creation of trading partner files/interfaces.
- Developed new maps and modifying existing maps. Developed maps for following transaction sets: 810, 850, 855, 856, 940, 945, 947 and 997.
Environment: Windows 2008/XP, SI 5.1, EDIFECS Spec builder, Sterling File Gateway 2.2.2, XML, XSLT, HTML, Oracle 11i,Ultra Edit, FTP, XSL, MS Access.
Confidential, Bowie, MD
EDI Developer
Responsibilities:
- Involved in migrating the Maps from GXS to GIS Maps. Also, Involved in Migration the communication Channel from GXS to GIS in Migration project.
- Created Move it jobs to automate the production using Move it Central.
- Assisted business groups to successfully transition into production environment.
- Administered the DMZ server to facilitate external FTP accounts.
- Developed Business Processes for FTP and SFTP communications
- Created and modified business processes using GPM and BPML as per the business requirements.
- Configured FTP Server Adapter using Sterling File Gateway. Created the Communities and Groups to associate the Trading Partners into a Group.
- Configured Sterling File Gateway in the Dev/Test environments
- Responsible for creating producers/consumers
- Created producers/consumers and developed Static/Dynamic Routing channel templates
- Responsible for suggesting Communities/Groups Architecture.
- Created Mailboxes for the Trading Partners, Transferring files throughFTPfor data verification.
- Wrote Perl scripts to augment trading partner specific transaction batching/splitting requirements.
- Extensively worked with Network team to resolve production critical problems.
- Involved in creating and installing certificates in order to secure connections using Open SSL and WebMethods.
- Created Trading Partner profiles and Management of Communities in Edifecs TM 7.0.7
- Created SNIP error reports for vendors on a weekly basis.
- Extensively interacted with trading partners to define business rules and convey the implementation guidelines.
- Created new trading partners and EDI implementations using Business Connect and set error severities/ SNIP levels using Spec Builder 7.0.5.
- Established HIPAA field validation procedure and executed formatting and mapping successfully.
- Developed maps for different X12 transactions such as 835 Health Care Claim Payment/Advice, 837 Professional and Dental Health care claims, 834 Benefit Enrollment / Maintenance, 270/271 Health care Benefit Inquiry and Response and involved in setting up Trading partner profiles for the clients and sending them Functional Acknowledgement 997.
- Setting up AS2 connections with customers via BIZCONNECT and testing the integrity of connection and flow of data.
- Managed all 4010 encounters UAT using Edifecs TM by creating trade relationships.
- Updated and resolved tickets and worked with users to administer production control.
- Sending an acknowledgment (EDI X12 997 Functional Acknowledgment) to the trading partners.
- Defined and administered production control for business groups.
- Responsible for trouble shooting the application connectivity for various Business Process models.
- Created and administered various secure connectivity protocols like VPN point-point, FTPS protocols with client certificate authentication for secured file transfers as per business requirements (NY POS).
- Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
Environment: Windows servers 2008, Edifices TM, GXS AI Mapper, BIZCONNECT, Ultra Edit, Ftp over SSL, SFG 2.2.2, SI 5.2, SSH, PGP encryption, FileZilla Client 3.5.3, WinSCP 4.7.3, Toad for oracle, Windows SharePoint Services 3.0
Confidential, NC
EDI Developer/Production control Analyst
Responsibilities:
- Worked on integration with new trading partners using GIS 4.3
- Setup process schedules to automate the translation & transmission of documents.
- Performed Installation of GIS 4.3 on Windows 2007.
- Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets.
- Involved in HIPAA 4010A1 to 5010 conversion, gap and impact and business rule validation for all X12 and HIPAA standards.
- Setting up trading partners and worked with internal and external trading partners in determining requirements.
- Configured services and adapterssuch asFSA, SAP Suite Adapter, JDBC, FTP, SMTP and HTTPto send and receive various transactions.
- Used Sterling File Gateway for creating the Service Adapters. Created the Routing channels and Routing channel Templates for new trading partners and associated them into Groups for easy communication with them.
- Successful testing for TLE upgrade. This included testing of new TLE Mapping Tool and SAP system interface.
- UNIX script writing for both communicational and file handling.
- Wrote Perl scripts to augment trading partner specific transaction batching/splitting requirements.
- Responsible for the complete design, development and implementation of 834, 835, 837, 270, 271 using Gentran ODBC functionality.
- Extensively wrote SQL queries to support translation, cross references, testing etc.
- Include claims and enrollment testing as well as NPI and medical coding and ICD-9 EDI testing.
- Used EDIFECS spec builder to manage claim transaction and billing application requirements.
- Involved in regular contact with trading Partners and conveying the implementation guidelines and specifications.
- Monitored and resolved translator errors, data problems, communication issues etc.
- Performed trading partner testing for bi-directional for 834, 835 and Outbound 837 transactions.
Environment: Windows Server 2007, GIS 4.3, EDIFECS Spec builder, Inovis TLE, SFG, XML, XSLT, HTML, MQ, WebSphere Portal, Oracle 11i, EDISIM, Share point server 2003.
Confidential, TX
EDI Programmer/Analyst
Responsibilities:
- Developed design documents and mapping specification for the maps.
- Gather business requirements and carry out data analysis
- Perform Gap Analysis on the requirements.
- Implemented 820, 834, 835 transactions based business requirement.
- Loading Eligibility Data for membership into system from the state, vendors using Proprietary format, ANSI 834 through EDI, and web interface.
- Developed Business processes using GPM for inbound and outbound processes
- Involved in new Trading Partner setups with AS2, FTP and Sterling VAN.
- Involved in applying to latest Patches to Gentran Integration Suite.
- Migration from GIS 3.1 to GIS 4.1, updated envelopes and service configurations
- Understanding of the business rules and needs.
- Created test plans for load and performance tests with twice the daily EDI volume
- Involved in production support, trouble-shooting the day-to-day issues of the application.
- Analyzed business case scenario and applied trading partner rules for the transaction flows.
- Validated electronic medical records including: Clinical Pathways, ICD-9 Codes, billing codes (CPT, HPCS, etc.), ANSI 835, HIPAA Standards.
- Creation and execution of test data and test plans.
- Tested the Maps for migration.
- Installed GIS 4.1 on Development/Production, updated to latest patches, carried out system tuning
- Created documentation, transferred knowledge to employees about the architecture
- Involved in Unit, functional and Integration Testing.
Environment: GIS 4.1, SQL Manager, TOAD, Ultra edit.
Confidential
EDI Programmer/Analyst
Responsibilities:
- Setup Trading partners, created standard to application and application to standard and pass-thru maps.
- Created maps to translate data from X.12 format to SAP IDOC formats for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers.
- Created Scripts to automated error handling process to send corresponding reports to the respective users.
- Created/modified trading partner setup in SAP using WE20 transaction.
- Troubleshooter and reprocessed IDOCS. Handled discards using BD87 transactions.
- Wrote UNIX shell scripts to automate handling of data discards, data errors, compliance errors etc.
- Converted all the maps from Visual Mapper to Application Integration Mapper.
- Provide Production Support for the maps developed in Gentran.
- Involved in fine-tuning the maps to increase the performance.
- Used Standard and Extended rules as a part of mapping various transactions.
- Created the Envelopes for trading partner transactions.
- Responsible for creating and managing the Import and Export MAPs using Application Integrator.
- Developed maps for following transaction sets: 810, 820, 830, 832, 850, 852, 855, 856, 857, 864, 867, 875, 879, 880, 940, 945 and 997.
- Developed Maps to and fro from trading partners to Internal Order Management applications (SAP IDOC’s) in supporting Delivery Order, Goods Receipt, ASN etc.
- Improve the models to overcome frequent issues.
- Migrated Gentran 856 ASN, 810 invoice, 846 Inventory Snapshot from Sybase EC Map to Gentran Visual Maps.
- Tested maps and test data to be used for new ASN tracking system application.
- Involved in Scheduling and monitoring of SAP Batch jobs Processing programs.
- Experience in Validation and Sanity Testing of EDI X12 to SAP Idoc data.
- Performed Unit Testing to test the functionalities.
- Used TOAD to view Database Objects, view and develop Database Scripts.
Environment: Oracle 9i, Gentran Server on UNIX (AI/VM Mapper), TOAD, SAP IDOCs, Ultra edit, FTP, HTTP, PGP, EDIFECS