Edi Analyst/developer Resume
Phoenix, AZ
SUMMARY:
- EDI Consultant with 10 plus years of experience in B2B EDI Development/Integration with various ERP Applications in different Industries like Healthcare/Retail/Logistics
- Experience as an EDI analyst performing analysis, verification, testing and validation of the EDI transactions.
- Worked as EDI Developer in performing Trading Partner Set ups, developing maps, business process
- Worked in EDI Production Support and resolved Tickets
- Extensive experience on several B2B Tools like Sterling B2b Integrator, Gentran Integration Suite (GIS),GXS, Gentran, Sterling File Gateway, and Sterling Connect: Direct, Sterling Control Center, EDIFECS, Innovis BizManager, and Biz Talk Server.
- Hands on experience on ANSI X12 Transactions including 810, 850, 855, 856, 860, 527, 861, 846, 862, 856, 824, 830, 870,835,834, 270, 271, 999, and 997.
- Hands on experience in EDIFACT Transactions including, DESADV, IFCSUM, IFTMAN, IFTMIN, INVOIC, INVRPT, ORDCHG, ORDERS, and ORDRSP.
- Configured various Protocols like FTP/FTPS/SFTP/HTTP/HTTPS/AS2/VAN/SMTP/POP3
- Expertise in creating s for Encryption and also used PGP etc.
- EDI experience using Inovis TLE Trusted Link software on the Windows, UNIX.
- Demonstrated expertise utilizing ETL tools, including Oracle Data, Data stage and RDBM systems like Oracle, DB2, and SQL Server.
- Very Strong Experience in developing Mapping Requirements Specifications
- Worked in close co - ordination with the testing team in developing test plan and test cases from functional and business requirements
- Worked extensively in Business Analysis including Analysis, Requirements Gathering, Requirements Analysis Documentation, Validating and Testing.
- Apply in-depth professional experience and broad knowledge of both business and technology to analyze and develop solutions to resolve moderate to complex technical or business issues.
- Experience with healthcare system, Medicaid, Medicare with focus on claims adjudication, provider, eligibility and prior authorization.
- Extensive exposure to unified modeling language (UML) tools such as MS Visio, Rational Rose and Requirement Management tools such as Rational RequisitePro.
- Experience in Software Development Life Cycle methodologies like AGILE, Water Fall, SCRUM
- In depth knowledge of SDLC and implementation of the Rational Unified Process (RUP) in all four phases of a project: Inception, Elaboration, Construction and Transition.
- Strong ability to understand and troubleshoot Production related issues
- Ability to do independently as well as in a team and experience in coordinating with different groups in a project.
- Excellent Verbal, Written, Interpersonal and Organizational skills
TECHNICAL SKILLS:
Communication Protocols: HTTP/HTTPS/FTP/SFTP/FTPS/AS2/AS1
EDIFACT TRANSACTION SETS: ORDERS, ORDRSP, INOVIC, DESADV, DELFOR ANSI X12
Transactions: 810,850,855,856,860,864,812,816,820,830,835,837,834,270,271,940,944,945,947, 210,211,214
EDI Standards: ANSI X12, HIPAA, EDIFACT, TRADACOMM, ROSETTANET
B2B Tools: Sterling B2b Integrator, GIS, Gentran, Sterling File GatewaySterling Connect Direct, Sterling Perimeter Server, Sterling QuickStart Services, EDIFECS Spec Builder, EDIFECS XengineEDIFECS Transaction Management, GXS, Innovis, CLEO
Operating Systems: Windows, UNIX, AIX, Mac OS X
Database: Oracle, SQL Server, PL/SQL, SQL
Methodologies: UML, RAD, RUP, JAD, Agile
Web Design Tools: HTML, XML, MS Front Page, Adobe Photoshop
PROFESSIONAL EXPERIENCE:
Confidential, Phoenix, AZ
EDI Analyst/Developer
Responsibilities:
- Involved in end to end testing with trading partners which includes transactions like 850,855,856,845,849,860,865,867,870,810,820
- Gathering requirements from trading partners and preparing test cases and test scenarios that needs to be tested in the test cycle.
- Template creation and validation of EDI transactions like 850,855,860,865,870,810,820,830,849,845
- Creating Validation reports on the issues found
- Hands on experience with SAP T- Codes like WE02, WE05, VA02, VA03, ME23, ME23n, WE19, SE16, SE16n etc.
- Validating functional specifications, build technical specifications and develop application documentation.
- Involved in migrating from old legacy system called Genesis to SAP.
- Perform analysis, design, development and testing of applications to solve business requirements
- Provide functional and technical analysis supporting the implementation of the project.
- Create detailed mapping specifications for 810, 820, 850, 855, 856, 860,865,870,845,849 maps
- Test and document transactions from EDI through translation to IDOC’s posting in SAP, inbound and outbound.
- Worked on different file formats like X12, SAP IDOC, Flat file and CSV.
- Perform gap Analysis of mapping specification.
- Validating the mapping specification and raise defects to related team GXS, SAP and Middleware.
- Hands on experience on SAP IDOCs
- Converted raw data from client GIS reports to GXS mapping specifications for 15 trading partners.
- Involved in end-end testing.
- Good Interaction with business users.
- Changing the mapping specification as per the requirement.
- Participate in system integration and user acceptance testing, data migration and cutover activities up to go-live on new SAP system.
- Monitoring the defects on daily basis in HP ALM
- Investigate and analyze post go-live issues and follow up with specification, testing and implementation of their resolution.
- Worked with SAP team and with GXS team to plan and execute testing.
- Preparing the documentation for internal and external use.
- Involved in project Go live and on call Production support.
- Created technical documentation for new processes and EDI system changes.
Environment: SI, SAP Logon, Web Methods, GXS, GXS Trading Grid, SharePoint, HPQC HP ALM Quality Center, FileZilla, Putty, Ultra Edit, Ultra Compare, Service Now, EDISIM, EDI message monitor
Confidential . - San Francisco, CA
EDI Analyst/Developer
Responsibilities:
- Gathered Requirements from Business users and developed specification documents.
- Responsibilities include interacting with the client for data compliance and gather requirements
- Work with the development team in generating extracts in a timely manner.
- Created documents for moving the processes to production for automation
- Actively involved in documenting change management, configuration, requirements, process flows, and data flows.
- Designed Workflows and allocated permissions within SharePoint.
- Coordinated thesetup of new trading partners, including planning, project management, testing, documentation, and implementation. Developed and maintained functional specifications for new / existing applications needed to maintain/enhanceEDIprocessing and address the requirements of new trading partners.
- Weekly meetings with WebEx sessions are scheduled to discuss the requirements concerns issues
- Develop test plans and test cases, conduct testing activities and coordinate application implementation
- Conduct End User including the preparation of documentation. Also conducted internal IT staff technical cross-functional .
- Conducted Pre Assessments, gathered business and technical requirements from the Clients, performed gap analysis and created technical documents to facilitate Clients / Business Partners
- Provided daily production support to implement new customer requirements & resolve daily production issues.
- Conduct post-implementation reviews and obtain appropriate project signoffs
- Worked on EDI ANSIX12 standards and transactions like 840,843,850,855,856,810,820, 940, 943, 944, 945,947
- Interacting with Trading Partners to get the requirements for onboarding purpose
- Setting up trading partnership using Sterling B2b Integrator and their communication
- Coordinating with the customers to analyze requirements for Implementation Guide.
- Ability to perform GAP Analysis for X12 and EDIFACT transactions.
- Implemented EDI Transactions like 850, 810, 856, 820 and 997’s.
- Analyzed and reviewed test data files and test scripts for 850, 855, 856,810 and 820
- Created Several maps from X12 to SAP IDOC and Vice Versa
- Did end to end testing from X12 file receipt till order to cash flow cycle in SAP.
- Worked on Integration issues between EDI and SAP
- Develop mapping documentation between EDI and SAP IDOCS
- Set up and configured the AS2 communication protocol for exchanging the EDI documents for trading partners with digital Signature.
- Analyzed trading partner specifications and created EDI mapping guidelines
- Analyzed Functional Specification Documents (FSDs) and prepared Test Plans and Test Cases
- Transaction processing and configured to run on iSeries
- Responsible for the complete design, development and implementation of 850, 810, 855, and 856 documents Involved in unit testing and system testing during the shift over to the production environment.
- Developed SQL Queries to access to SQL Server 2008 database to check on the data translated.
- Created Envelopes/Trading Partners as per the requirement.
- Analyzed Gentran System to migrate to Sterling B2b Integrator
- Created Excel sheet with all trading partners and related info needed for migration
- Set up Trading Partners using Sterling B2b Integrator.
- Migrated maps from Gentran to Sterling B2b Integrator
- Developed Business Process in Sterling B2b Integrator using GPM/BPML
- Performed Performance Tuning in Sterling B2b Integrator.
- Created Producers/Consumers using Sterling File Gateway
- Developed Static/Dynamic routes in Sterling File Gateway
- Enabled Sterling MyFileGateway so trading Partners can upload/download files
- Created PNODE/SNODES using Sterling Connect: Direct
- Monitored File Transmission using Sterling Connect: Direct
- Configured Alerts/Failure notification in Sterling Control Center
Environment: Sterling Integrator 5.0/5.2, Sterling File Gateway 2.2.2, Gentran, SQL Server 2008, Oracle 9i,Windows, SAP.
Confidential - Louisville, KY
EDI Developer/Analyst
Responsibilities:
- Involved in all phases of the design, development and implementation of .
- Gathered Requirements from Business users and developed specification documents.
- Creating SOP's and Process documents. Created internal documents to review for Process documentation Team.
- Coordinated thesetup of new trading partners, including planning, project management, testing, documentation, and implementation. Developed and maintained functional specifications for new / existing applications needed to maintain/enhanceEDIprocessing and address the requirements of new trading partners.
- Created new maps and Setting up of trading partners as per the requirements for the company.
- Analyzed Functional Specification Documents (FSDs) and prepared Test Plans and Test Cases
- Participation in all phases of testing. Perform testing and thoroughly documenting issues.
- Created Implementation guides specific to transactions and trading partners using EDIFECS spec builder.
- Worked with the technical and development team to resolve identified issues in a timely manner
- Analyzed and reviewed the data files and developed the business processes with their requirements.
- Experience with EDI files 834, 835, 270,271, 276,277 file formats
- Extensively participated in verification of EDI file formats against Standards.
- Migrated from EDIFECS to Sterling B2b Integrator.
- Developed ne COBOL DB2 programs
- Analyzed and migrated documents from 4010 version to 5010 using EDIFECS spec builder.
- Created maps using EDIFECS spec builder for different transactions (837, 270,271, and 276,277).
- Installed and configured sterling B2B integrator.
- Configured Sterling file gateway for managed file transfer.
- Involved in development of Business and Technical Requirements in preparation of Design and Functional Specifications for Business Needs and Processes.
- Worked with EDI HIPAA transactions like 834,835 and 837
- Created and developed the maps for HIPAA transactions of 834,835 and 837 and converted them to XML/SQL/SAP IDOC
- Set up Trading Partners in the mapping tool.
- Modified Several Different Business Process and created new one to implement end to end flow.
- Compliance has taken for HIPAA with regulatory circumstances
- Participated in team meetings, involved with group discussions in resolving the issues.
- Configured the appropriate services and utilized all the services in creating the inbound and outbound processes
- Guided my team in implementing the new processes to meet the further requirements.
- Created the test cases and performed to ran the script in maintaining the files in particular type
- Attended the client seminars and participated in different projects to gain knowledge and made some progress accordingly in related research type.
- Documented the entire EDI Process
Environment: Sterling Integrator 5.2, Oracle 11i,DB2, Windows, XEngine, XEServer, AIX, EDIFECS
Confidential - Cranberry Twp., PA
EDI Developer/Analyst
Responsibilities:
- Gathered the configurations and involved in setting up of Trading Partners for Inbound and Outbound communication in SI 5.0
- Created new maps for transactions like 940, 945, 943, 944, 856, 810, 832, 947, 888, 315, 214, 317, and 850.
- Created XML Schemas for 810, 315, 850, 317, 832 transaction sets using XML Spy and Ultra Edit / Ultra Compare
- Set up Trading Partners in the mapping tool.
- Set up and approve TP relationship in the VAN.
- 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.
- Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
- Created Oracle Procedures to validate the Inbound data and populate it into live tables
- Created Lookup and Cross table for convert Port code, Country code etc.
- Developed Oracle forms to correct and re-process the failed inbound messages
- Created Trading Partner setup for Outbound and Inbound messages
- Create new maps for onboarding new trading partners
- TroubleshootEDIissues, restore/resend data while monitoring daily business processes.
- Develop newEDImaps and perform integration testing with distributors and 3PL’s.
- Work and build working relationship with other IT staff and department managers to gather requirements.
- Implement maps and envelopes for new trading partners.
- Created Oracle reports to monitor Inbound and Outbound messages
- Developed programs for processing EDI messages
- Involved in migrating Gentran: Windows maps into Sterling Integrator 5.1 maps.
- Translated incoming ANSI X12 files into X12/text files/xml, delimited files and various other formats.
- Responsible for developing maps that checks for valid partners as preliminary check and separates the valid and invalid EDI documents.
- Analyzed trading partner specifications and created EDI mapping guidelines
- Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
- Rendered support to staff and affiliates towards the completion of the project as per the Deadlines
- Developed several functional maps to implement the business rules and validations.
- Modified some of the business rules to suit the development of the maps in Gentran environment.
- Developed various Business Process using GPM and BPML as per the business requirements.
- Transferred files through FTP to customer for Data verification using PGP encryption.
- Performed Installation of Sterling File Gateway and Sterling Control Center.
- Created Producers/Consumers in Sterling File Gateway
- Developed Static/Dynamic Routing Channel templates in Sterling File Gateway.
- Developed Custom File Types in Sterling File Gateway
- Based on roles, created several users to allow them to upload/download files using myFilegateway.
Environment: GIS 4.3, Sterling B2b Integrator Oracle 9i, SAP, .NET, COBOL DB2, Gentran, IBM iSeries, GXS, SFG, SCC
Confidential - Danville, IL
EDI Analyst/Developer
Responsibilities:
- Created IG’s & Application descriptions documents as per business needs using EDIFECS Spec Builder 7.0 and 8.0
- Analyzed and migrated documents from 4010 version to 5010 using EDIFECS Spec builder.
- Created maps using EDIFECS Map builder for different transactions (837,834, 835, 270/271, and 276/277).
- Designed and developed testing procedures for HIPAA Health care 837,276/277 transactions, and ensured that they are properly analyzed.
- Analyzed and reviewed test data files and test scripts for the HIPAA /277, 834, 835 and 837 transactions.
- Worked with creating companion guides for HIPAA 837, 834, 835 and 276/277
- Tested HIPAA EDI Transaction validation using Quality Center tool. Entering defects during bugs found during UAT testing and assigning it to the appropriate developer.
- Created custom EDI split rules and Error Severity Files specific to the trading partner requirement including monitoring data quality for SNIP edits.
- Involved in the online screen design for navigating between the different DB2 tables and the report was written in the flat file with header and trailer details. Also Involved in designing test plans
- Created Agreements to setup different Trading Partner and created Relationships using EDIFECS Trading Partner Manager
- Optimized DB2 SQL queries
- ExperienceinTrizetto's Facetsproduct used in Healthcare payer industry
- Used EDIFECS X-Engine to split bad data and good data.
- Implementation of EDIFECS X-Engine is used to provide validation, splitting, routing, monitoring and reporting for applicable transactions received.
- Used X-Engine to test files for SNIP error types 1-7.
- Mainly Data-base selector and XML selector are used in EDIFECS X-Engine.
- Scheduled batch jobs in JCL for processing huge amount of claims data.
- Created Routes in EDIFECS Application Manager based on the requirements.
- Validating the defects based on mapping logic provided by the BA and making sure the fields are accurately mapped in the system.
- Having strong skills in using Java script
- Worked on testing of ICD9/ICD10 disease codes.
- Created the WTX maps to upgrade current International Classification of Diseases (ICD 9) codes standards for diagnosis and inpatient procedures codes to the new ICD 10 standards.
- Used various TPs to bypass HIPAA edits during the submission of claims.
- Created new Inbound, Outbound, FTP, SFTP and many Business processes which are required to automate the whole EDI process.
- Set up and configured the AS2 communication protocol for exchanging the EDI documents for trading partners with digital signature.
- Developed Severity files using EDIFECS application manager
- Monitored all transactions using EDIFECS Transaction Manager
- Migrated from EDIFECS to Sterling B2B Integrator.
- Involved in creating the envelopes and set up acknowledgements.
- Deployed Maps into Sterling integrator 5.2.
- Comfortable with installation of Sterling file Gateway in Test environment.
- Tested all Types of SNIP Testing for HIPAA including integrity testing, requirement testing, balancing testing, situational testing, code set testing, product or services testing, and guide-specific testing.
- Hands-on Experience in performing integrated quality testing using HP quality center.
- Monitored and resolved translator errors, data problems, communication issues etc.
Environment: Sterling Integrator 5.2, EDIFECS Spec Builder, XEServer, DB2, EDIFECS TM, X-Engine, Sterling File Gateway 2.2, Ultra Edit, DB2
Confidential - Menomonee Falls, WI
EDI Analyst/Developer
Responsibilities:
- Involved in gathering requirements, conducting JAD sessions to collect requirements from system users and prepared business requirement documents
- Worked with SME, end users, analysts from end-users, and analysts and developed requirements document
- Gathered Requirement from the Client to fulfill the Application need for FACET Implementation.
- Created and maintained the Requirements Traceability Matrix, Software Requirement Specifications (SRS), and Functional Specification Document (FSD).
- Working with developers, business team and customers analyzing sources of data discrepancies and improving processes to prevent potential risks and issues
- Was responsible for tracking issues that are detected and updating the status of existing issues based on the daily meetings with the off-shore team.
- Reporting project progress to business team and customers on daily basis.
- Identified and analyzed the data requirements for the various site teams and made sure that the required data is available in the testing environment.
- Used EDIFECS Spec Builder to develop companion guides, testing the files, developing maps
- Migrated from GIS to EDIFECS System
- Performed Analysis for migration and worked till go-live
- Updated EDI documentation and system flowcharts related to EDI Communications.
- Managed conversion from Kohl’s Gentran UNIX platform to Global GIS platform.
- Maintained and troubleshot EDI production system for Kohl’s
- Implemented new trading partners and EDI processes to enhance company productivity.
- Created maps and conducted mapping changes and modifications on Gentran
- Assisted in all upgrades of the Sterling Gentran Server 5.0 to GIS.
- Conducted EDI software versions and EDI Document version upgrades by changing EDI User Files and maps and testing to assure data integrity, followed by updating documentation and flowcharts.
- Conducted upgrade changes/modifications to the EDI environment for SAP upgrades.
- Directed tasks and projects for the EDI team.
- Responsible in developing test plans, test cases, test execution, test reports, opening and verifying work requests/defect (bug) reports, and helping resolve customer issues.
- Worked closely in setting VAN communication.
- Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
- Reconfigured and maintained flows for the EDI system.
- Assisted in upgrading Sterling Gentran Server 4.0 to 5.0 from UNIX to Windows platform.
- Modified/ created SAP programs to correct EDI issues to better suit business user needs.
- Completed changes/modifications to the EDI environment for SAP upgrades.
Environment: Sterling Gentran Server 5.0, GIS, Oracle, Linux, SAP, UNIX, Windows, Rational Rose and Requisite Pro, MS Visio
Confidential - Menlo Park, CA
EDI Analyst/Developer
Responsibilities:
- Implemented various EDI transactions like 810,820,840,843,850,855,856
- Established and supported communication with product users and suppliers to share information.
- Identified and recognized opportunities and resolved problems related to EDI.
- Prioritized customer requirements and maintained continuous improvement through customer feedback.
- Provides day-to-day support including problem resolution and coordination of operational activity relative to job scheduling, etc.
- Acted effectively as point-of-contact on status of EDI transactions from internal and external customers.
- Developed and prepared EDI documentation for internal and external use.
- Provide technical support of the EDI application, mappings, and interfaces, and testing.
- Translating the data from EDI standards like ANSI X12 to XML format and vice versa using the translator
- Followed the UML based methods using Rational rose to create Use Cases, Activity Diagram, Sequence Diagram, Collaboration Diagram that include Functional and Non-Functional specifications to hand off to development teams.
- Gathered requirements for MRS and requirement documents
- Executed full-cycle implementation including: trading partner and communications setups, data mapping, UAT and regression testing, version upgrades, system migrations, and deployment
- Client meetings for understanding the business requirements
- Modify and develop maps according to trading partner needs
- Experienced in Gentran Map editors.
- Document existing EDI Gentran maps and iSeries programs for conversion
- Experience in analyzing the system specifications and business requirements.
- Excellent troubleshooting and issue resolution skills.
- Prepared test cases and developed test data to test EDI maps.
- Involved in Unit and Integration Testing.
- Responsible for creating MRS.
- Communicated with stakeholders including trading partners, VANs, internal support teams, and business users to validate all ongoing requirements were met
- Monitored and tracked project timelines, progress, and issue resolution for documenting lessons learned
- Performed daily audits for 60+ trading partners verifying that transactions were completed successfully and arrived at the end users on time and error free
- Responsible for logical implementation, validation and verification of map.
- Liaising directly with managed service providers, VAN providers.
- Daily Monitoring of Gentran Production data
- Development of EDI maps using Gentran
- End to end testing of EDI maps which involves the transactions 850,810,856,997
- 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.
Environment: Gentran, UNIX 5.1, Connect-Direct, IBM iSeries, UML, Clear Quest, MS Visio, Sterling VAN
Confidential
EDI Trainee/Developer
Responsibilities:
- Got Trained on EDI Process.
- Worked with internal users and trading partners to define EDI requirements and opportunities. Analyze and implement trading partner mapping, work flow and processing procedures.
- Prepared test cases and develop test data to test EDI maps
- Modify and develop maps according to trading partner needs and monitoring production jobs and provide on call support
- Created 810, 820, 850, 856, 997 maps to translate EDI to SAP IDOCs and IDOCs to EDI
- Ensure delivery of quality concat in line with committed deadlines.
- Optimized DB2 SQL queries
- Worked on 837I and 837P HIPAA standards for claims. Developed test data to maps.
- Participate in all system tests and analyze all data Analyze and resolve all EDI issues in processes and maintain accuracy in all inbound and outbound documents and perform troubleshoot on processes and analyze all errors.
- Involved in unit testing and system testing during the shift over to the production environment.
Environment: Gentran, Oracle, UNIX, SQL SERVER, MS Office, .NET, FTP, SFTP
