Test Cases Data

Divya G

SAP EDI Developer/Mapper/Analyst - KRAFT HEINZ

Fairfax, VA

*.*********@*****.*** - 703-***-****

Willing to relocate: Anywhere

Authorized to work in the US for any employer

WORK EXPERIENCE

SAP EDI Developer/Mapper/Analyst

KRAFT HEINZ - PA - July 2013 to Present

Responsibilities:

• Designed, developed different inbound and outbound ANSI X12 Order, Invoice, ASN maps and few XML maps to from scratch and also changed some existing maps.

• Created Specs (MRF's) from scratch consulting customers on what they need and what Kraft Heinz will send them using implementation guidelines.

• Build, test and deploy new maps into Sterling integrator production environment. Developed 850,856,810,880's, 940, 846, 944, 204, 210 and 875 maps, implemented changes to existing maps like 824,856,888,214's.

• Acted as liaison between client and its trading partners for new EDI setups, as well as existing AS2 and VAN connections,

• Written extended rules and different logics on maps for both Purchase orders, Invoices, Logistics (Supply chain) and Purchase Order acknowledgements to IDOC format and vice-versa.

• Working on migration of all EDI trading partners, all maps and BPML's from BPCS (AS400) to SAP.

• Created inbound and outbound flow for all TP's using AS2 and sterling communications, and configured envelopes.

• Processing IDOCs in SAP ECC 6.0 Order to Cash and Warehouse management.

• Responsible in GAP analysis, Unit testing of all maps and internal testing, User acceptance testing and BAT.

• Processing SAP IDOCs such as ORDERS, ORDRSP and INVOIC on SAP ECC 6.0.

• Working on AS2, FTP and VAN different adapters and communication protocols.

• Performing end-to-end customer testing and if needed analyzing of EDI documents.

• Responsible for deployment of maps into test and production environments.

• Worked with clients off-site via email and phone in providing EDI data issues resolution.

• Fixing production errors like invoice rejections or SI data errors, troubleshooting any slowdown processes of Sterling integration if any Bp's are placed in queue.

• Maintained SAP EDI configuration to support production after go-live and support processes: EDPAR table entries, WE20 Partner Profiles, Customer Accounts, output conditions, and custom table data entries.

• Performed SD and MM functional tasks using transactions including VA03, VF02, VD52, AOL1, MM03 and many more.

• Designed new maps of EDI to IDOC, IDOC to XML and few more for specific 3PL trading partners as required per Kraft specifications.

• Performed gap analysis and data analysis on different applications and gathered required key details for the migration of interfaces.

• Created and loaded new maps into production environment after end to end testing with the new trading partners.

• Involved in moving to new HP database servers from existing ATOS database servers.

• Currently working on UAT testing with all 3PLs on EDI warehouse transactions, carrier shipment details.

• Working with new web URLs on the AS2 setups with all trading partners and Suppliers with the migration of new database servers.

Environment: Sterling Integrator 5.0, SAP GUI (ECC) for Windows, File zilla, UNIX PUTTY, FTP, SFTP, AS2. EDI Developer (SI)

UNITED STATIONERS - IL - January 2013 to June 2013 Responsibilities:

• Performed as an EDI developer in Supply chain logistics life cycle.

• Migrated Gentran mainframe maps 850, 855, 856asn, 810invoice, 846 Inventory Snapshot to Sterling Integrator 5.0 map editor.

• Developed maps from X12 to XML and vice-versa according to trading partner requirements.

• Used Sterling Integrator 5.0 & Business processes to translate the data from XML to Flat file, Flat File to XML & XML to XML.

• Involved in most of the XML mapping and flat-file conversions.

• Performed unit testing and developed test cases depending on the technical aspect.

• Involved in building SI maps from scratch and also involved with Order Management System.

• Worked with SI AS2 edition for exchanging the EDI documents for trading partners with digital signature.

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

• 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.

• Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc.

• Also used generic business process models for work flow.

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

• Created process flow, de-enveloping and routing process for Advanced Shipment notification (856) transactions for various trading partners.

• Developed standard ASN (Advance Shipping Notice)'s according to the customer requirements.

• Familiarity with mapping and SI mapping tool, SQL server and TSQL Environment: Gentran Mainframes AS400, Sterling Integrator, XML, X12 Secure CRT, Secure FX, FTP, MS Excel.

EDI Developer/Data Analyst II

KANSAS HEALTH SOLUTIONS - July 2012 to November 2012 Responsibilities:

• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets. This includes HIPAA 4010A1 to 5010 conversion, gap and impact and business rule validation for all 12 standard HIPAA 5010 transactions: 270/271, 276/277, 278/278, 820, 834, 835, 837 (IPD).

• Designed test strategies and test plans for HIPAA 5010 276/277, 837IB, 837OB Healthcare transactions as per the client's requirement specification.

• Designed and developed testing procedures for HIPAA Health care 276/277 transactions, and ensured that they are properly analyzed.

• Analyzed and reviewed test data files and test scripts for the HIPAA 5010 276/277 PEND, RFAI and 837 transactions.

• Tested HIPAA EDI Transaction validation using Quality Center tool, entering defects during bugs found during UAT testing and assigning it to the appropriate developer.

• Validating the defects based on mapping logic provided by the BA and making sure the fields are accurately mapped in the system.

• Used various Trading partners to bypass HIPAA edits during the submission of claims.

• Analyzed the requirements and created mapping specifications based on HIPAA implementation guidelines.

• Created inbound and outbound maps from EDI ANSI X12 format into Database tables and flat files and vice- versa.

• Configured and used ODBC/JDBC bridges to support Uniform Transaction identifier process to track Transaction across application.

• Developing SQL query scripts to check the database automatically and checking the data integrity in accordance with business standards of the company.

• Developed test cases and test scripts for the functional testing of HIPAA transactions.

• Planned and developed test cases using Quality center defect tracking tool.

• Participated in business requirements, user requests and defect analysis meetings.

• Extensively used SQL to perform Data integrity testing

• Performed unit testing and resolved issues with maps.

• Adjudicated claims in processing and ran in test environment.

• Designed, developed and tested HIPAA transaction sets in batch applications.

• Designed and developed applications to convert various paper-based medical records to HIPAA-compliant, secure EDI transactions.

• Involved in compliance testing using Claredi.

• Analyzed EDI translation errors that failed in the inbound and re-processed the EDI's without losing the information.

Environment: Gentran on windows NT/XP, SQL server 2005, 2008, SFTP, MS Access. EDI Programmer Analyst

Maganti IT Solutions - January 2012 to June 2012

Responsibilities:

• Worked extensively in the field of SQL programming, EDI data analysis and designs of functions.

• Developed data queries using SQL from scratch for data retrieval and use them in EDI platform especially in the maps and business processes.

• Performed gap analysis and involved in documenting new procedures for gathering EDI requirements from trading partners with development team.

• Involved in testing and debugging EDI maps for healthcare transactions.

• Gathered requirements and provided specifications to development teams for development of new EDI maps and business processes according to client requirement.

• Created new CSV to EDI, EDI to XML, XML to XML and EDI to EDI maps according to the customer and company requirements.

• Modified changes to existing maps, corrected them as per client requirement and performed unit testing for the changed maps.

• Worked as a key technical member for the development team for data gathering and analyzing.

• Supported database team and testing teams to perform end to end testing for existing and new trading partners.

• Performed testing and data analysis on EDI maps and business process structures and corrected if needed any changes.

• Involved in all levels of testing like unit testing, BAU, UAT and end to end application testing. Environment: SQL TOAD, SQL Analyzer, EDI retail and healthcare transactions, Gentran Sterling Integrator 4.9, EDI data reports.

EDI Analyst/Tester

Computer Science Corporation - May 2009 to December 2010 Responsibilities:

• Analyzed and reviewed Business & Functional Requirement Documents and the technical specification for the HIPAA EDI transactions.

• Developed and documented Test Cases related to the requirement specifications and business rules.

• Analyzed User requirements attended Change Request meetings to document changes and implemented procedures to test changes.

• Prepared Requirements Traceability Matrix and Test Summary Reports.

• Analyzed system documentation like Requirements document, User Interface Specifications to develop and Execute Test scripts.

• Developing SQL query scripts to check the database automatically and checking the data integrity in accordance with business standards of the company.

• Developed test cases and test scripts for the functional testing of HIPAA transactions.

• Planned and developed test cases using Quality center defect tracking tool.

• Participated in business requirements, user requests and defect analysis meetings.

• Extensively used SQL to perform Data integrity testing

• Developed and executed automated test scripts for Functional and Regression testing using Quick test pro.

• Created EDI Testing process, documentation, and performance matrices.

• Manually tested End-to-End applications.

• Closely worked with Developers and System Engineers to nail down the technical problems.

• Tested the functionality of the applications and tested its compatibility on Windows XP/2003 on different versions of Internet Explorer, Netscape, and Firefox. Environment: XML, X12, Oracle 10i, MS Excel and Windows NT 4.0, PGP, FTP, Gentran Server on UNIX(AI/ VI Mapper).

Research Assistant in IT department

Wright State University - May 2008 to March 2009

• Self-taught HTML source code.

• Worked on a mini HTML project on adding new functionalities to existing single page HTML codes. JNTUK University

• Worked on a Technical presentation in Digital Image processing technology. EDUCATION

Masters of Science in Engineering

Wright State University

Bachelors in Engineering

Jawaharlal Nehru Technological University Kakinada ADDITIONAL INFORMATION

• Around 7 years of IT experience as an EDI Developer /Mapper/Analyst with diverse knowledge in analysis, design, implementation, development and validation of client/server and web based applications.

• Excellent understanding and thorough hands on experience in Software Development Life Cycle (SDLC) and Software Development Test Cycle (STLC).

• Development, testing and support experience in Health care and Retail domains.

• Hands on experience with transactions: 270, 271, 276, 277, 278, 834, 835, 837(P, I, D), 997/999, 850, 855, 856, 810, 880's, 940, 846, 944, 947, 204, 210, 888. Also have a strong knowledge of HL7, NCPDP transactions.

• Experience in B2B and EDI Integration applications using Gentran Integration Suite and Sterling Integrator.

• Experience in developing, implementing and monitoring end to end EDI ANSI X12, EDIFECS Spec Builder, Sterling's Gentran Server on UNIX, Gentran Integration Suite (GIS) & XML/XSLT applications.

• Hands on experience working with AS1, AS2, HTTP, FTP, SFTP and SNMP protocols.

• Hands on experience working in SAP ECC 6.0 and all kinds of SAP IDOC transactions for Order to Cash, Warehouse and Procurement to Pay.

• Extensive exposure to SAP SD, MM, WM and BI reports modules.

• Hands on experience with XPATHs, XML standards and UNIX scripts.

• Hands on experience using defect tracking tools like HP Quality Center, REMEDY.

• Experience in conducting Business Functional Testing, Unit testing, Integration Testing, System Testing, Performance Testing, Regression Testing, Adhoc Testing, User Acceptance testing (UAT) and End to End Testing.

• Strong experience in performing Gap Analysis and additional side by side changes to the crosswalk.

• Ability to develop database queries using SQL and PL/SQL to assist in testing effort.

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

• Strong B2B knowledge, ability to work under pressure and good interpersonal skills.

• Strong written and communication skills.

TECHNICAL SKILLS

Scripting Languages: TSL, JavaScript, HTML CSS, Shell Script Industry standards: ANSI X12, EDIFACT and HIPAA

Operating systems: UNIX (Secure CRT), Windows NT/XP, 2003 Server Application Servers: ECMap 4.1.7/5.1.6, Gentran Server 5.1/5.3/6.0/6.1, GIS 4.2/4.3,,Sterling Integrator 5.0, Sterling file gateway

EDI Transactions: 204, 214, 210, 810, 820, 830, 832, 846, 850, 856, 860, 852, 867, 835, 837, 270, 271, 276, 277, 834, 940, 944, 947, 888, 864 and 997

Languages: PL/SQL, COBOL, C++, VB script, C#, ASP.NET Databases: Oracle 10g/11g, SQL server, MS Access 2003

Contact this candidate