PROFESSIONAL SUMMARY:

• Over nine years of experience as Business Application Programmer Analyst in analysis, design, configuration and development of 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.
• Strong hands on experience developing EDI maps in Gentran Server for Windows, UNIX involving (210,211,214,270,271,810,812,820,835,837,850,855,856,860,940,943,944,945,997) transactions, Inventory management and Chargebacks.
• Strong knowledge of the Business Processes in GIS.
• Strong Oracle DB experience and SQL.
• Ability to research, identify and resolve EDI technical problems within needed time frame.
• Experience with communication options VANS (value - added networks) and FTP.
• Knowledge of B2B Integration Standards (X12, XML etc).
• Experience in working with trading/business partners to onboard them to EDI.
• Experience in working with trading/business partners to research and resolve problems.
• Proficiency in Software Development Life Cycle (SDLC) processes like - Waterfall, Agile methodologies.
• Excellent ability to meet commitments (Time bound and goal oriented).
• Self-motivated and dedicated fast learner with good communication and interpersonal skills.
• Dynamic and assertive team player with a strong inclination to improve and optimize process development and implementation.
• Strong interpersonal skills and ability of working with multiple teams.
• Excellent presentation and meeting facilitation skills.
• Proven skills in relationship building, customer-focus, decision-making, and accountability.
• Experienced in the EDI sub-systems Gentran-Server, GIS for Windows and Seeburger Suite.
• Broad knowledge of Oracle, ODBC, SQL Database Knowledge.
• Very strong background in various DBMS technologies like Oracle, MS SQL Server.
• Good understanding of XML DTDs and Style Sheets.
• Strong experience in GENTRAN, EDI, EDIFACT, SAP IDOC, XML and UNIX scripting.
• Experience with Interface and IDOC extension development, partner profiles, and output determination.
• Ability to learn and adapt new technologies.
• Experienced and working knowledge of HTML, JavaScript and XML/XSLT.
• 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.
• Passionate about creating the flawless quality E2E (end-to-end) customer solutions.
• Performed Data-Driven Testing, Parameterized Data, created compiled Modules and worked towards synchronizing the test run.

TECHNICAL SKILLS:

EDI Packages: Seebeyond, Seeburger, GENTRAN: Server 4.0/5.3/6.0/Gentran Integration Suite (GIS), Gentran: Connect Direct, Mercator 6.0, ANSIX12, ANSIX12N, EDIFACT, Visual/AI Mappers GIS, Map Editor, Informatica (Data Transformation Studio)

EDI transactions: ANSI X12: 204, 210, 240, 211, 810, 811, 815, 820, 824, 830, 832, 835,837,844,845, 846, 849, 850, 855, 856(ASN), 858, 860, 861, 862, 864, 865, 867, 940, 941, 943, 944, 945, 947, 997

EDI Standards: ANSI X12 2030, 2040, 3030, 3040, 3050, 3060, 4010,4030,5010

Applications: SAP ALE/EDI IDOCS, WebMethods 6&7.1SeeBeyond Manager, Busniess Connector, Seeburger

Protocols: TCP/IP, HTTP, FTP, SOAP, AS1, AS2

Languages: C, C++, Java/J2EE, SQL, and PL/SQL

Data Bases: Oracle 8i/9i/10g, SQL Server 7.0/2000/2005

Web Technologies: ASP, HTML, DHTML, XML, XSLT, .NET, VBScript, Java Script

Web/App Servers: Apache, IIS, WebLogic, Websphere

Other Tools: Toad, Kintana, Oracle Applications 11i /ERP

Operating Systems: Windows NT/XP, MS DOS, UNIX, Mainframes CNX

Defect tracking tools: Quality Center Team Track, Bugzilla

Version control tools: CVS, PVCS, Clear Quest.

PROFESSIONAL EXPERIENCE:

Confidential, Scottsdale, AZ

EDI Production Support Specialist / EDI Consultant

Responsibilities:

• Monitoring EDI X12 file processing in production system.
• Managed Business call flow and responded to technical support needs of customers.
• Reviewed logs for all networking devices for unresolved abnormalities and problems.
• Played a key role in handling various critical issues when our AS2 servers are down due to connectivity issues between VAN and AS2.
• Troubleshoot on processes to resolve business transaction file issues.
• Performed tests to provide support to all client related issues, and prepared documents according to customer required guidelines.
• Handling the production support by fixing errors in EDI X12 data / Oracle database by using tools like SQL Navigator and managed communications with customer service representatives to resolve all ERP related issues successfully.
• Maintaining an effective EDI interfaces, facilitate expansion to all internal divisions like logistics, transportation, Claims, Account Payable and enhanced communication systems.
• Coordinating with EDI trading partners to resolve all production issues.
• Managed customer calls effectively and efficiently in a complex, fast-paced and challenging ERP Business Sales Environment.
• Perform transaction tests and resolved all EDI issues according to customers Implementation guides.
• Used GXS (INOVIS Biz manager/Biz connect) to setup new TP, and maintain the existingTrading Partner profiles for transmission of Transactions through AS2, VAN, FTP, etc.
• Monitored various EDI transactions like PO, Invoices, ASNs, Load tender and transportation appropriately.
• Participating in IT meetings to monitor daily business progress and addressed our production related concerns to IT Director and Business Managers to plan effective solutions for supporting ongoing business process.

Environment: SQL (Oracle),Seeburger, SeeBeyond Manager, GXS, Business Connector, UNIX, EDI transaction processing (e.g.831,850/875,810/880,856,940/945,867,812,820,852 etc.), and Communication Protocols (VANs, AS2, FTP,SFTP).

Confidential, Phoneix, AZ

Technical Data Analyst & Data Translation Mapping Specialist

Responsibilities:

• Involved in working on organic-Existing Trading Partner setups and validating the customer production files.
• Involved in gathering analysis of data on Migration project like finding the Gaps between the two different systems at Confidential & Wachovia.
• On a day to day activity took the responsibility to gather the specs for 820 ANSI X12 Integrated Payables to Payment Manager Application.
• Responsible in developing the code in Information Item field for mapping the Flat File specs for customers as per the DSD s provided by the analysis team.
• Responsible to run the maps in WebMethods to process the acknowledgements for all the trading partners and validate the XML output files.
• Responsible for updating, deleting the account numbers as per the product request on DSD s and made the required mapping code change on Informatica Item Field mapping tool.
• Responsible for developing the maps for various payments types like( ACH- Domestic and International ACH, Check, Wires, PMP, FDM) and process these files with customer production files.
• Responsible to convert the 820 (EDI and Flat Files) to Middle XML in WebMethods B2B tool.
• Created the Envelope service for all the 600 customers in migration project and generated the Unique CEO ID for Wachovia Ace Forms.
• Analyzed the data on Mainframes CNX and production files of the trading partners to create the ACE forms as per the Go-Live Install Dates.
• Involved in reviewing the XML generated files from Payment Manager Application.
• Developed the parser for mapping Current amount and Date Format Standard as per the 820 and 997 Implementation Guide.
• Involved in writing the testing cases for various payment types and tested the EDI and Flat Files in Dev and SIT as per the payments types for the customers.
• Trained the other team members for developing the custom maps for the trading partners.
• Monitored the team with production issues.
• Involved in meetings to review the mapping specs, Gap issues and DSD s.
• Involved in team meetings with System Analysts, Key Engineers and Draft Review committee to resolve the issues mentioned on the Gap List.
• Monitored the ACE form Review Committee and advised the team for better approach to have a successful Migration.

Environment: Mainframes, WebMethods7.1, Informatica Data Transformation 8.6.1, Clear Quest, CVS Repository, File Validation Tool, UNIX, WinSCP, UltraEdit, Compare It.

Confidential, CA

Sr. EDI Consultant/ Project Analyst

Responsibilities:

• The EDI Claims that comes from Providers are translated through ANSI 834 map in 4010 & 3051 format into flat files on UNIX. The Claims are split into messages and send to IntelliClaim ODS. The Claim in the ODS is Used to backfill non-medical code set translations and medical code steps to HIPAA Complaints.
• Involved in requirements analysis, Identification and documentation of required system and functional testing efforts for all test scenarios (Positive and Negative).
• The Adjudicated files from the Claim Systems is sent to the IntelliClaim ODS for back filling with non-medical code sets and Medical sets and clearinghouses and
• Converted to 835 XML from Cross Worlds. 835 XML data is picked up by Gentran using an adapter.
• Performed logical mapping changes for 834 and 835 transaction sets to-and-from claims and billing applications.
• Created and modified maps in Gentran server for Windows 4.0.02.
• Created and modified trading partnerships to support new entities/transactions.
• Responsible for analysis, design, development and maintenance EDI system using GENTAN.
• Performed on going production support for data, mapping, compliance, networking, and delivery issues.
• Setting up jobs for different transactions in batch mode, worked on Oracle for Provider remit tables to insert data and modify data and used SQL to query messages and Data retrieval.
• Extensively involved in the Creation of Test data procedures, testing the Transactions for volume and functionality both on PC and UNIX environments with data driven input and shell scripts for translations.
• Extensively worked in writing BSD’s and created test cases and testing using the Quality Center.
• Extensively worked in running the UNIX scripts and windows batch jobs for both HCCR and CERR with all the 12 Claim Systems and worked on HIPAA Validation on 834 and 835 for all the 12 Claim Systems.
• Involved in Cross Functional, End to End testing for 834 and 835 in different releases, logged related defects and resolved them.
• Worked with 12 Claim Systems for HIPAA validation for backfilling of Medical code sets, Non - Medical code sets and worked on BRIO error reporting to get the Claim and remit errors.
• Developed Maps to and fro from trading partners to Internal Order Management applications (SAP IDOC’s) in supporting Delivery Order, Goods Receipt, ASN etc.
• Involved in Scheduling and monitoring of SAP Batch jobs Processing programs.
• Experience in Troubleshooting of IDoc Errors.
• Generated Data Driven Scripts that access the backend database and unsed SQL queries to verify the integrity of the database and also synchronization points helps to solve key problems.

Environment: Gentran Server 4.0.02, Oracle 9i, ODBC, Windows NT, UNIX (Solaris), WinSCP, Quality Center 9.0, FTP, Ultra Edit.

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 for all customers.
• Changed EDI Outbound UNIX Scripts.
• Developed UNIX shell scripts to handle transaction splitting/ consolidating by
• Shipment bill of lading number or purchase order number.
• Developed UNIX shell scripts to automate file discards due to data errors.
• Developed UNIX based FTP routines to successfully deliver data destinations
• Providing Guaranteed Delivery Layer. Mainly involved in creating maps of various transaction sets include: 810 Invoice (Outbound), 850 Purchase Order (Inbound), 843 Response to Request, For quotation, 855 purchase Order Acknowledgement (Inbound).
• Involved in the business process of the organization like interacting with various customers.
• Generated daily reports for production support.
• Created 810 Invoice weekly reports for Confidential Customers.
• Integrated Confidential Payment process with JP Morgan on different payment types like ACH, Wire Transfer, and Check Printing.
• Created comma delimiter script for the SQL Database and run the script using TOAD.
• Involved in writing test cases for the EDI maps and tested using Quality Center.
• Worked on various Inbound and Outbound Processes for transaction list that include 850,856,810,844,845,849,855,860.
• Worked on IDoc Filtering, Segment Filtering, and IDoc Reduction and extended basic IDoc type.
• Involved in IDoc monitoring, analysis and error handling in Production system.
• Worked extensively in the configuration of XI with SAP and non-SAP systems.
• Interacted with client to gather specifications to set up a Trading Partner.
• 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, Cyclone, WinSCP, SAP,IDOC, Oracle 9i, ODBC, Team trackWinXP, SQL,UNIX, Quality Center 9.0, QTP, Java, JavaScript, HTML, Oracle Applications 11i / ERP

Confidential, TX

EDI Consultant/ B2B Analyst

Responsibilities:

• Excellent experience with the Warehouse & Logistics business cycle of creating Advance-shipping notice, Shipment Creation, Delivery, Picking, Shipping, Goods Issue, and Billing through EDI.
• Participation in the Business Process of the organization.
• My Responsibilities include gathering the specs for Characterization System module and Agents Module.
• Involved in analysis, Design and development of few agents such as E-Signature, Inbox, Message Handler and User Maintenance.
• Involved in writing PL/SQL code for Procedures, Functions and Packages to insert the data & retrieve the data into Message Handler, E-Signature, and User Maintenance forms various Forms across the application and from interfaces (Backend) by calling the Procedures.
• Created UNIX shell scripts and invoke them using crontab to automate daily batch processes of ETL for Customer Sales database.
• Involved In Creating EDI ANSI X12 Standards.
• Created various Maps depending on Trading partners Requirements.
• Involved in GAP ANALYSIS.
• Involved in Trading Partner Setup.
• Created DATA MANAGERS and UNIX Scripts.
• Wrote SQL Statements for selecting the Data and Testing.
• Provided user training and production support.

Environment: Gentran Server, AI Mapper, FTP, Oracle 9i, ODBC, Team track, Windows NT/2000UNIX (Solaris)

Confidential

B2B Consultant/ Tester

Responsibilities:

• Created ASN (Advance Shipping Notice EDI X12 856) which comes in ANSI X12 format from trading partners.
• Validated NCPDP transactions prior to moving into production
• Created IG’s & Application descriptions Based on the customer requirements.
• Implemented NCPDP v5.1 Pharmacy EDI Transactions(Real time and Batch)
• Translating the data from ANSI X12 to text format in inbound process using the translator.
• Setup process schedules to automate the translation & transmission of documents
• Sending an Acknowledgment (997 Functional Acknowledgment) to the trading partners.
• Involved in creating new Trading Partner.

Environment: Gentran Server, Oracle 8i, UNIX and Windows NT, QTP Test Director.