Edi Consultant Resume Profile
NY
Summary:
- Broad knowledge of Oracle 10g, ODBC, SQL Database Knowledge
- Experienced in the EDI sub-systems Gentran-Server, and GIS for Windows, Unix
- Proven skills in relationship building, customer-focus, decision-making, and accountability
- Proficiency in Software Development Life Cycle SDLC processes like Waterfall, Agile methodologies.
- Strong Leader/Contributor for test plan automation in Oracle Applications eBusiness Suite 11i EDI Gentran area.
- Experience working with trading/business partners to research and resolve problems.
- Experience in working with trading/business partners to onboard them to EDI.
- Knowledge of B2B Integration Standards X12, XML etc .
- Experience with communication options VANS value-added networks and FTP.
- Ability to research, identify and resolve EDI technical problems within needed time frames
- Extensive experience in various Business Applications like Logistics, Healthcare, Finance, Telecommunication, Distribution,
- Around 10 years of experience as Integration Developer/Analyst in analysis, design, configuration and development of EDI software applications. Extensive Gentran experience and can perform any EDI related tasks, including mapping and translation, testing and quality control, standards development, risk assessment, development of work flow and scripts Batch or UNIX , designing backup and recovery procedures, creating EDI Guidelines related to EDI implementation.
- Very strong background in various DBMS technologies like Oracle, MS SQL Server
- Strong experience in GENTRAN, EDI, EDIFACT, SAP IDOC, XML and UNIX scripting
- Experience with Interface and IDOC extension development, partner profiles, and output determination
- Highly 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.
- Experienced in analyzing Application requirements through Functional Requirement Specifications FRS and System Design Specifications SDS and translating them in to application code.
- In-depth knowledge of all QA Phases that include Manual, Functional, System, Unit, Integration, End-to-end, Business Process testing.
- Performed Data-Driven Testing, Parameterized Data, created compiled Modules and worked towards synchronizing the test run.
- Proficient in the use of Automation tools such as Mercury Testing Tools.
Technical Skills:
EDI Packages: | GENTRAN: Server 4.0/5.3/6.0/Gentran Integration Suite GIS , Gentran: Connect Direct, ANSIX12, ANSIX12N, EDIFACT, Visual/AI Mappers GIS, Map Editor |
Retail transactions: HIPPA transactions: | ANSI X12: 204, 210, 240, 211, 810, 811, 815, 820, 824, 830, 832, 844,845, 846, 849, 850, 855, 856 ASN , 858, 860, 861, 862, 864, 865, 867, 940, 941, 943, 944, 945, 947, 997 270, 271, 276, 277, 834, 835, 837 |
EDI Standards: | ANSI X12 2030, 2040, 3030, 3040, 3050, 3060, 4010,4030 4010A1, 5010 |
Protocols | TCP/IP, HTTP, FTP, SOAP, AS1, AS2 Cyclone Interchange |
Data Bases | Oracle 8i/9i/10g, SQL Server 7.0/2000/2005 |
Web/App Servers | Apache, IIS, WebLogic, Websphere |
Other Tools | Toad, Oracle Applications 11i /ERP, OMS, WMS |
Operating Systems | Windows NT/XP, MS DOS, UNIX |
Defect tracking tools | Team track, Bugzilla |
Professional Experience:
Confidential
EDI Consultant
Responsibilities:
- Created new 850 Purchase Order , 810 Invoice , 997 Acknowledgement etc mappings using Mapping Workbench for new EDI customers to bring them on to EDI.
- Also created the 855 PO Acknowledgement and 856 Advance Ship Notice documents for the customers.
- Created 820 Payment order/Remittance Advice and 823 Lockbox documents for internal finance end users.
- Involved in taking care of all the EDI transaction documents and have done the production support for EDI jobs.
- Acted as a team lead for the development of EDI automation.
- Arranged the weekly meetings for the update of the assigned work.
- Monitored the day-to-day transmissions of EDI documents with our trading partners.
- Changed the EDI mappings every time the customer requests for a change in the mapping EDI document.
- Upgraded the version of TLE to 6.1.0 using the benchmark process. Done the installation of both Operations center and the Mapping Workbench.
- Created Documentation Guidelines to send to our trading partners.
- Involved in the customization at EDI gateway level in oracle to send the kick outs of items in Purchase orders as automated Emails to the customer service.
- Involved in the Development of a system to monitor electronic functional acknowledgements to help easily recognize problems occurred during the exchange of EDI documents.
- Maintained and have also done modifications in the EDI Gateway set up in Oracle.
- Involved in the PCM Product Content Management project to load all the items into 1Sync for Lowes.
- Involved in the migration of TLE Mappings into Gentran Sterling Integrator Map Editor.
- Created some new application to application mappings to take the point of sale data from some of our big customers.
- Scheduled the EDI to receive this monthly point of sale data from the customers and process them to populate into the oracle data warehouse.
- Involved in the successful transition of EDI from Oracle to SAP environment.
Environment: GIS3.0, BPML, XML, Sterling Integrator, Gentran, Oracle, Pl/SQL, WindowsXP
Confidential
EDI Developer
Responsibilities:
- Developed implementation guides to document detailed exchange requirements such as structures, timing and business rules
- Configured new trading partners and maintain existing partners
- Designed and created Maps for the below listed EDI transaction sets in Gentran Visual Mapper.
- Strong knowledge with the translation of Inbound/Outbound documents into any to any format translation.
- Created the Business process Models as per the business requirements Using HIPAA.
- Created the work flows to accomplish the the Business process Models using Business Engine Rules in Gentran Broker.
- Tuning the work flows to the standard layout's both Inbound and Outbound transactions.
- The transaction maps that were developed are ANSI X12 version 4010 270/271, 276/277, 834,835, 837 Institutional, Dental and Professional .
- Expertise in end to end in depth usage of Technical and Functional background in Gentran 5.3/6.0 irrespective of the Inbound or Outbound format.
- Extensively Involved in Production Support using Vantive Client 5.1.
- Monitored the Vantives Tickets on a shift basis and resolved the issues, modifications, back-up files.
- Migrated Gentran maps and associated RPG programs to Gentran on UNIX ver 6.0.
- Created i-series based image overlays to transmit images with the EDI transactions.
- Performed Impact analysis for readiness of ICD-10 conversion
- Extensively worked on Connectivity methods FTP, HTTPs
- Expertise in writing UNIX Shell script writing for both communicational and file handling.
Environment: Windows NT, Gentran 5.3/6.0, Connect Direct, RPG, CL, PGP, ODBC, UNIX AIX, FTP, HTTPS, SMTP,VantiveClient 5.1.
Confidential
EDI Consultant/ B2B Engineer
Responsibilities:
- Creating new maps for various transactions using GENTRAN for both inbound and outbound transactions like 810,820,823, 850,855.
- Created DNS Names resolution for all customers.
- Changed EDI Outbound UNIX Scripts.
- Interacted with client to gather specifications to set up a Trading Partner.
- Involved in writing test cases for the EDI maps and tested using Quality Center.
- Created comma delimiter script for the SQL Database and run the script using TOAD.
- For quotation, 855 purchase Order Acknowledgement Inbound .
- Invoice Outbound , 850 Purchase Order Inbound , 843 Response to Request
- Mainly involved in creating maps of various transaction sets include:810
- Created Envelopes for existing Trading Partners.
- Configured partner profiles for both inbound and outbound for various partners Wal-Mart, Sam's, Costco, Staples .
- Involved in Requirement analysis, Identification and documentation of required system and functional testing efforts for all test scenarios Positive and negative tests
- Analyzed various requirement documents and developed test plans and traceability matrices.
- Developed Test Plan as per IEEE Standards.
- 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.
- Wrote SQL statements and PL/SQL Procedures.
- Developed test cases and test scripts for new product development activities.
Environment: GIS, Map Editor,, SQL, PL/SQL, ODBC, Team track, WinXP, UNIX, Quality Center 9.0, QTP, Java, JavaScript, HTML, Oracle Applications 11i / ERP
Confidential
EDI Consultant /B2B Analyst
Responsibilities:
- Worked on integration and up-gradation of existing GENTRAN: SERVER on UNIX to Sterling Integrator.
- Implemented SDLC which included requirements, specifications, design, analysis and testing utilizing Waterfall methodology.
- Responsible for the day to day production support 24/7 , configuration and monitoring daily error reports and coordinate/perform error resolution.
- Debugged program errors and modifying production systems to support findings as well as providing customer support for business logic and workflow as it relates to applicable systems.
- Worked with customers and Internal Application teams to understand the existing business processes and documented business requirements, functional and technical specifications, test plans, test cases, and consolidated project plans.
- Created Business flow diagrams and Implementation guidelines using Visio and EDISIM.
- Created business process for both inbound and outbound transactions to SAP and other internal applications as per business needs using Graphical Process Modeler.
- Configured adapters, services and AS2 setups as per business needs.
- Responsible for the complete design, development and implementation of Ware House Transactions.
- Performed GAP analysis and converted maps from one version to another as per customer/business requirements.
- Migrated all the maps from Visual Mapper to Map Editor.
- Converted FTP UNIX shell scripts to use AFT functionality and automated the process in SI.
- Created Standard to APP/XML and vice versa maps as per business needs.
- Responsible for creating transaction/volume statistics Reports out of SI to higher management.
- Involved in Unit Testing, Integration Testing, Regression Testing and performance Testing.
- Responsible for creating output determination, partner profiles and port definitions in SAP.
- Triggered IDOC's using SAP Transactions and testing the flow form SAP to Gentran/SI.
Environment: Gentran Server on UNIX 5.3, SI 5.0, SAP R/3 V4.5c IDOC, RFC , Oracle 9I/10g.
Confidential
EDI Analyst / Tester
Responsibilities:
- Analyzing the existing policies and procedures and providing the inputs to Executive Management Team to fit into the compass project goals.
- Identifying the impacts and training the users on new policies /procedures changes.
- Developed Use cases, Test Cases for the Business users and QA team.
- Identifying the Security Risks in the application that being built and address them in the requirement document to avoid the security breaches.
- Improved the new revenue cycle management and Electronic Medical Record EMR for PARTNERS.
- Developed an implementation guide for Partners for EDI X12 transactions such as 834, 835,837,270 and 271.
- Designed the flexible solution for patient treatment plan and patient care plan.
- Designed the tight user authentication and application security.
- Modified Existing policies and procedures for patient access such as Enterprise
- Scheduling, Patient Check-in/Out and Encounter automation.
- Supporting the Business Users after go live.
Environment: MS Project, MS Visio, RUP, Rational Suite RequisitePro, ClearQuest, Clearcase , Blueprint, SQL, ETS and EDI ANSI X12/HIPAA.
Confidential
Hipaa EDI Tester
Responsibilities:
- Reviewed manual testing strategies and performed extensive manual testing before automation testing.
- Involved in Processing claims and verifying whether it's delivered to DIAMOND System or not.
- Involved in testing the efficiency of healthcare delivery by using HIPAA.
- Involved in testing HIPAA EDI Transactions and mainly focused on 837 and 835.
- Involved in processing claims in Diamond and validating the full cycle process to make sure the checks are generated and 835's are generated.
- Involved in writing SQL queries to validate the payment files.
- Followed the Mapping documents and HIPAA implementation guides for HIPAA Transaction Mapping.
- Conducted compatibility tests with multiple operating systems, browsers, and network environments.
- Reported bugs using Test Director and Interacted with developers to resolve defects.
- Participated actively in the team meetings with the developers for bug reviews.
- Involved in Regression Testing with Win Runner.
Environment:.NET, Oracle, Win Runner, Test Director, UNIX, Load Runner, Windows NT/2000, MS-Excel, Clear Quest.
.