EDI Sr. Programmer/Analyst Resume

Title
EDI Sr. Programmer/Analyst

Primary Skills
TI, EDI

Location
US-GA-Atlanta (will consider relocating)

Posted
Jan-21-09


Having 17 years plus of experience in the IT industry Expertise in System Analysis, Design, Development and Implementation of software applications. Having good communication skills, and motivation to work with teams and also individual.
Having 10 years plus of Hands on Experience in EDI using Datastage TX (Mercator), GENTRAN, SYBASE (ECMAPS), on Windows NT, UNIX, Mainframe. Implementing EDI with DB2, Oracle, and XML, SAP IDoc.
* Experienced in EDI Transactions 110, 114, 204, 214, 270, 271, 278, 810, 820, 823, 830, 834, 846, 850, 855, 860, 861, 867, 870, 990, 997, 270, 271, 276, 277, 835, and 837.
* Expertise Interface programs for importing data from feeder systems to different modules using SQL*Loader, PL/SQL and UNIX Shell scripts.
* Familiar with CARGO 2000, ANSI X12, EDIFACT standards.
* Familiar with UIT, SBT, Financial standards.
* Experience in communicating with trading partners, sending documents through VAN, using FTP, etc.
* Integration Flow Designer, Design Studio, command Server, Event Server, Commerce Broker, and Message Broker.
* Excellent experience with IDocs and good working knowledge in SAP/3 (ABAP/4) environment.
* Good experience in HIPAA transaction sets (270, 271, 276, 277, 278RQ, 278RP, 835, and 837) , NSF, UB92, and HL7
Technical Skills:
EDI Standards: ANSI X12, UCS, VICS, and EDIFACT
Specialization: Electronic Data Interchange (EDI) transactions, ETL
204,214,810,820,823,830,846,850, 856,860,861,867,870,990,997
Data: html, XML, DTD, Schemas, FWB, FHL, Reports, Notifications
Languages: BASIC, COBOL, FORTRAN, PASCAL, and ABAP/4
Software: SQL, PL/SQL, Oracle 7.x/8i, SAP R/3
Databases: MS Access, Oracle, SQL Server, MySQL, SQL Base.
O.S.: Windows NT 4.0, Windows 95/98/2000, Windows 3.x,
MS-DOS, SCO UNIX 5.x. Sun Solaris 2.x
Hardware: IBM Compatible PCs, Pentium, HCL, Wipro and HP Servers
EDI Tools: Mercator, Gentran, Sybase (ECMAPS) etc.,
Others: DB-Artisan, Erwin, Toad, EDISIM, SpecBuilder
Applications: Sales, Financials, and Inventory System
Education Qualifications:
B.S. from Nagarjuna University, India.
P.G. Diploma in Computer Science. India.
Professional Experience:



Client: Home Depot.
Duration: Aug '07 to Till todate
Role: EDI Sr. Programmer/Analyst (Middleware)

Project Description: This project includes supporting first and second level support for the production WMS EAI Application in the IT Supply Chain Organization. Perform Analysis, Design, Development and Implementation and upgrade of Non EDI maps by using Mercator Software.


Responsibility:

Home Depot, Atlanta, GA.

* As a Senior Mercator programmer analyst worked on Supporting WMS EAI Production system and also upgrading, performance, tuning the same system.
* Implement solutions on assigned moderately complex projects.
* Taking business requirements and develop the total technical design on moderately complex projects.
* Apply thorough understanding of WMS, EAI, POR database, and Data modeling in order to ensure proper usage of these methodologies as part of the design efforts in building a system to be put into production.
* Conduct appropriate test reviews for assigned projects and present to architecture review boards as necessary.
* Promoting and follow the established processes policies, standards and procedures to assure compliance with corporate and regulatory policies and standards.
* Provide technical direction to associate business developers.
* Worked on a project for WMS EAI Messages. This project required mapping to and from the database from PO2DC/POWMS/WMSPO/POIDC/OMPUR/PXPUR/Store PO of Non-EDI Messages, also required mapping to and from the Non EDI Messages to common canonical XML messages.
* Worked in developing new maps/changing existing maps as per requirements (defect/Vantive tickets).

Skills: Mercator/Datastage TX, IBM Websphere MQ, DB2, ClearCase, NetCool, Vantive Tickets.
Operating System(s): Windows, IBM.



Client: ACS EDI Gateway Services, Inc.,
Duration: Aug '06 to Aug '07
Role: EDI Sr. Programmer/Analyst

Project: - ACS EDI Gateway is a clearinghouse: HIPAA Implementation (276, 277, 278, 837, 835, 270,271, IRL, proprietary formats, etc.,) Mercator is used for Data Transformation between the EDI subsystem and the Mainframe. Mercator is used for processing ANSI X12N 837 Claims document. Whenever an EDI 837 Claim file comes from the Provider, Mercator validates that file and transforms the data into their proprietary (HCFA) format.

Mercator /Datastage TX 8.0 mapping and upgrades

Developing/Modifying Mercator map for both inbound and outbound scenarios. Responsible for developing maps that checks for valid partners as preliminary check and separates the valid and invalid EDI documents.
Generated legacy transactions and read transactions for all internal Maps and working with other internal teams. Working in developing new maps/changing existing maps as per requirements. (CSR/Workbench tickets)

Responsibilities:

ACS EDI Gateway Services, Inc., FL, USA

* As a Senior Mercator programmer analyst worked on HIPAA implementation for following states Iowa, Georgia, Colorado, Mississippi, etc.,
* Perform Analysis, Design, Development and Implementation of X12 EDI maps by using Mercator Software.
* Created Maps for Out Bound Routing System to FTP the Information to the Remote Queues
* Created Maps for Volume Reporting of the Transactions Inbound and Outbound of the Clearing House Cycle.
* Extensively worked with Integration Broker, Message Manager and Commerce manager modules
* Extensive experience with IFD, Message manager, Launcher and Partner manager
* Created Maps for Error Handling System to Store the Log Information created by the Maps that are failed in the process.
* Created Maps for the Business Failures for generating the Error Report to the Business analyst Team.
* Designed and developed the process of tracking inbound and outbound transactions within the Mercator maps using db2 database
* Develop the test scripts and test data for unit testing, system testing and integration testing
* Involved in Analysis, design, development and documentation of interfaces
* Created Type Trees by using the Cobol Copy Books.
* Developed Mercator Map(s) for both inbound and outbound scenarios.
* Responsible for developing maps that checks for valid partners as preliminary check and separates the valid and invalid EDI documents.
* 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 Mercator environment.
* Fine-tuned the maps for enhancing their performance in the mainframe environment.
* Developed the map to generate Acknowledgement 997 and Edit Reports.
* Involved in Developer documentation, Hand Off document and Test Plan/Test Scripts and Test Results Documents.
* Analysis and Understanding the Cobol Copy Book structure and HCFA Structure
* Customization of Cobol Copy Book Type Tree to be compatible with X12 835 structure
* Understand Mapping rules and incorporate in Mercator Map using various Functions
* Built Maps and performed Unit Testing on NT using self designed Test Cases/Test data.
Environment: Mercator 6.5, Commerce Broker, COBOL-II, JCL, VSAM, MQSeries 5.2

Mercator /Datastage TX 8.0 mapping and upgrades.
Upgrade swift 2005 type trees to swift 2006 type trees.
Job Description: Analysis, design, map development, unit testing, system testing and implementation and supporting customers also moving maps into production. Productions: on call secondary support.

Developing Mercator map for both inbound and outbound scenarios. Responsible for developing maps that checks for valid partners as preliminary check and separates the valid and invalid EDI documents.
Generated legacy transactions and read transactions for all internal Maps and working with other internal teams. Working in developing new maps/changing existing maps as per requirements. (SPR)

Responsible for all stages of development including coding, testing, documentation, design, and installation of new and existing applications and products. Prepare supporting documentation as needed, including but not limited to Technical Specifications, Status Reports, and User Documentation



Client: Preferred Care - Rochester, NY
Duration: Aug '05 to June '06.
Role: EDI Systems Analyst

SUMMARY: Under the general direction of the Project Leader analysis, designs, programs, test, documents, and implements and maintains solutions for the Preferred Care's Health Care EDI applications. Normally works with minimal supervision, may guide Systems Analyst I and Programmer Analysts in the completion of projects.

PRINCIPAL ACTIVITIES

* Designs, programs, tests, documents, implements, and maintains software solutions in support of Preferred Care's EDI processes.
* Participates in analytical and design sessions aimed at developing or enhancing major systems on an as-needed basis.
* Maintains awareness of state-of-the-art development tools, programming techniques and problem solving techniques.
* Assumes responsibilities for special projects as requested by Project Leader.
* May coordinate efforts of Programmer Analysts and System Analyst I on specific projects.
* Develops EDI maps using an EDI translator.
* Assists with vendor/systems testing OR maintains EDI test environment.
* Oracle SQL development.
* Working with EDI HIPAA transaction (270, 271)
* Expert in the SYBASE Translation Products
* Good Experience with EC Map and EC Gateway products

KEY CHALLENGES OF THE POSITION

* Ability to comprehend ANSI ASC XI2N standards and HIPAA EDI implementation guidelines applied to the ANSI ASC X12N standards.
* Ability to handle multiple assignments and switch direction quickly.
* Ability to work independently.

Environment: Toad, Sybase ECMaps/ECGateway Integration product suite, Oracle, PL/SQL, SQL Loader, Shell scripts, Windows, and UNIX.


Client: Mutual of Omaha - Omaha, NE
Duration: Sep '04 to Aug '05.
Role: Sr. Systems Analyst

HIPAA EDI Project. HIPAA 3.01, Mercator 6.7, Proprietary Mainframe Flat files, Cobol copybook type tree generator, IBM MQ Series, ORACLE, DB Definition Version 5.11, Mercator (Ascential DataStage TX) Integration product suite, COMMAND/EVENT SERVER, UNIX.

Responsibilities:
* Worked on developing an inbound splitter Map for the 837 to split claims based on Providers and regrouping the files for processing.
* Actively involved in Unit, System, Volume, Integration, User and Partner Testing stages supported various Zones - Development, User Acceptance Testing,
Partner Testing and Production Zones.
* Oracle SQL queries, and PL/SQL development and testing with maps.
* Worked on design and Mercator mapping of clearinghouse Inbound/outbound reports.
* Worked on creating and make changes to the resource registry for the SYSTEST, CAT, PROD servers. Created a new map to convert MRN file to text file and used this single text file in all the environments by avoiding runparm files.
* Worked on the outbound Bundle and inbound unbundled maps
* Worked on daily product support.
* Worked on the complete end-to-end processing of the 837 Claims Information also helped debug and change Mercator maps for 837 processing. Was responsible for the production processing and daily support for the 837 HIPAA transactions
* Worked on the legacy NSF/UB92 Medicare claims processing. Was successful in changing and implementing for easy maintenance.
* Worked on changes to the maps for the new architectural design with Mercator professional services team
* Worked and refreshing and reprocessing failed and stuck data on the MQ series Qs using tools like PQEDIT/Queue Tool.
* Developed Archiving, Clean-up Procedures.
* Developed and validated all inbound EDI and outbound EDI data using Various Validate Tools and reporting Issues.
* Generated legacy transactions and read transactions for all internal Maps and working with other internal teams
* Working in developing new maps/changing existing maps as per BA's requirements (PR and Logs)
* Primarily involve in developing 837 Medicare clearinghouse modules.

Client: CapGemini (S&P), NY
Duration: Nov '03 to Oct '04.
Role: EDI/ETL Sr. Systems Analyst

Project: - EDI Implementation (Feeds, SBT, DTF, STP, Reports, proprietary formats, etc.,) Mercator is used for Data Transformation between the UIT system and SBT system. Mercator is also used for processing EDI inbound and outbound document with Oracle database.
Responsibilities:

* Involved in Analysis, design, development and documentation of interfaces
* Created Type Trees based on Fortran Program.
* Created map based on the selection of raw data in the flat file the outbound file structure is modified.
* Developed Mercator Map(s) for both inbound and outbound scenarios.
* Responsible for developing maps that checks for valid partners as preliminary check and separates the valid and invalid EDI documents.
* 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 Mercator environment.
* Fine-tuned the maps for enhancing their performance in the Unix environment.
* Creating Oracle objects and developing queries.
* Involved in Developer documentation, Hand Off document and Test Plan/Test Scripts and Test Results Documents.
* Analysis and Understanding the existing structure and developed STP/SBT/DTF Structure.
* Extensively used database adaptors inside map.
* Created mdq file, and also generated type trees for the stored procedures, tables, queries from which or to which want to map using Database Interface Designer.
* The database is used as an output, set keys and designated columns for performed SQL updates.
* Created maps to specify the logic necessary to transform the input data to the desired output data.
* Specified and build the output data according to the map rules.
* Understand Mapping rules and incorporate in Mercator Map using various Functions.
* Built Maps and performed Unit Testing on NT using self designed Test Cases/Test data and deployed to Unix server using IFD.

Environment: Toad, Erwin, Mercator (Ascential DataStage TX) Integration product suite, Oracle, PL/SQL, SQL Loader, Shell scripts, Windows, Unix.

Client Harmen, NY
Duration: June '03 to Oct '03.
Role: EDI Sr. Programmer/Analyst
Responsibilities:

ANSI X12 850/856 transaction set
Gap Analysis
o Analysis on business mapping of segments/fields from ANSI X12 850 EDI message to SAP ORDERS02 IDoc and preparation of mapping document
GENTRAN configuration will involve -
o Trading partner setup in GENTRAN as per specifications from Client.
o A GENTRAN Export map for parsing the ANSI X12 850 document to ORDERS02 IDoc segments.
o A GENTRAN Export map for parsing the ANSI X12 856 document to IDoc segments.
o Trading Partner Setup for 997 Functional Acknowledgment to Customer.

ANSI X12 855 transaction set
Gap Analysis
o Analysis on business mapping of segments/fields from SAP ORDERS02 IDoc to ANSI X12 855 document, preparation of mapping document
GENTRAN configuration will involve -
o Trading partner setup in GENTRAN as per specifications from Client.
o An Import Map for parsing the ORDERS02 IDoc and generating the X12 855 document, as per the specification mentioned for Test.
o Created System Import map for Trading Partner to parse outbounds documents.
o Supports new and existing products to plan and execute tests,
develop detail Test Plan, Test Cases to ensure quality of EDI transactions
o Working knowledge of mapping tools: Gentran for Unix


Client: ACS Healthcare Clearing House, Tallahassee, FL.
Duration: Dec '02 to May '03.
Role: EDI Sr. Programmer/Analyst

Project: - ACS EDI Gateway is a clearinghouse: HIPAA Implementation (276, 277, 278, 837, 835, 270,271, IRL, proprietary formats, etc.,) Mercator is used for Data Transformation between the EDI subsystem and the Mainframe. Mercator is used for processing ANSI X12N 837 Claims document. Whenever an EDI 837 Claim file comes from the Provider, Mercator validates that file and transforms the data into their proprietary (HCFA) format.

Responsibilities:

ACS State Healthcare Clearing House, FL, USA June 2003 - till date


* As a Senior Mercator programmer analyst worked on HIPAA implementation for following states Iowa, Georgia, Colorado, Mississippi, etc.,
* Perform Analysis, Design, Development and Implementation of X12 EDI maps by using Mercator Software.
* Created Maps for Out Bound Routing System to FTP the Information to the Remote Queues
* Created Maps for Volume Reporting of the Transactions Inbound and Outbound of the Clearing House Cycle.
* Extensively worked with Integration Broker, Message Manager and Commerce manager modules
* Extensive experience with IFD, Message manager, Launcher and Partner manager
* Created Maps for Error Handling System to Store the Log Information created by the Maps that are failed in the process.
* Created Maps for the Business Failures for generating the Error Report to the Business analyst Team.
* Designed and developed the process of tracking inbound and outbound transactions within the Mercator maps using db2 database
* Develop the test scripts and test data for unit testing, system testing and integration testing
* Involved in Analysis, design, development and documentation of interfaces
* Created Type Trees by using the Cobol Copy Books.
* Developed Mercator Map(s) for both inbound and outbound scenarios.
* Responsible for developing maps that checks for valid partners as preliminary check and separates the valid and invalid EDI documents.
* 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 Mercator environment.
* Fine-tuned the maps for enhancing their performance in the mainframe environment.
* Developed the map to generate Acknowledgement 997 and Edit Reports.
* Involved in Developer documentation, Hand Off document and Test Plan/Test Scripts and Test Results Documents.
* Analysis and Understanding the Cobol Copy Book structure and HCFA Structure
* Customization of Cobol Copy Book Type Tree to be compatible with X12 835 structure
* Understand Mapping rules and incorporate in Mercator Map using various Functions
* Built Maps and performed Unit Testing on NT using self designed Test Cases/Test data.
Environment: Mercator 6.5, Commerce Broker, COBOL-II, JCL, VSAM, MQSeries 5.2

Client: Kintetsu Global I.T., Dallas, TX
Duration: Nov '01 to Nov '02.
Role: EDI Sr. Programmer/Analyst
Facilitating customer access to shipping data while improving timeliness and accuracy of information is a primary goal of KWE. Providing our customers with the tools to monitor shipments, notifying them of any changes or disruption of service in a timely manner, and making all tracking, EDI and report histories available are just a part of what KWE offers
A multi-partner interchange of data provides KWE the capability to expedite input of shipment information, document transfers and overall communication among all involved parties. A centralized EDI gateway is maintained for database update capabilities.
Migration of Accounts Payable from manual, paper-based system to automated, electronic system: Sony, Japan: Automated the receipt of invoice-related information from client's trading partner. Benefits of this automation included reduced monthly invoice-processing cycle time, reduced errors and better utilization of staff resources. Evaluated XML and ETL tools to determine best approach.
My Responsibilities
Coordinating with the customers to analyze requirements for Implementation Guide.
* Worked on a project for Cargo 2000 Messages. This project required mapping from the database to SWB/FWB/FHL Messages.
* Created and tested new Maps in test region and FTP to production Box.
* Upgrading the maps for transaction sets include 214,810,856,110.
* Developed and upgraded EDI maps for transactions 810, 820, 830, 850, 856, 857
* Performed system testing on all EDI transactions both inbound and outbound.
* Setting up the new trading partners and maintained existing trading partners Profiles.
* Upgrading Maps from Mercator 2.1.5.0 to 5.0 with ECXpert 2.0 to 3.0
* Worked on "Customer Proprietary Format" like Manifest, Notify, Etc.

Following is a list of transaction sets currently KWE traded:
ID Transaction
810 Invoice
856 Ship Notice / Manifest
861 Receiving Advice/Acceptance Certificate
110 Air Freight Details and Invoice
214 Transportation Carrier Shipment Status Message
216 Motor Carrier Shipment Pick-up Notification
304 Shipping Instructions
359 Freight Invoice
114 Air Shipment Status Message
IFTMFR International Forwarding
INVOIC Invoice
IFTMCS Instruction Contract Status Message
@ Customer Proprietary Format, Notifications, and Print Files

Client: Collabria Inc. CA
Duration: Feb '00 to Oct '01.
Role: EDI Sr. Programmer/Analyst
Collabria is the creator of the Intelligent Print Workplace, a comprehensive set of Internet-based solutions that streamline print management and print purchasing. From job creation to job production, Collabria offers the only complete solution for handling enterprise-wide printing and addressing its inherent inefficiencies. The Print Commerce collection enables print buyers to collaborate with their preferred print providers to more efficiently create, order, track, archive, and manage print projects.
Developed software to process CMEP, MV90, and MDEF formatted data and EDI 810,867. Defined database structures for California Print data and New England Print data. Developed PL/SQL ETL loader for California Print Data to read and parse the EDI X12 document directly. Implemented solutions using Oracle 7.3.3, 8.05, 8i, PL/SQL, Web Toolkit, and Oracle Application Server.
Responsibilities:
* Mapped EDI transaction sets 810, 511, 855, 850, 840, 836, 856, 865, 843 to and from flat files. Integrated maps into a Mercator for EC environment on NT.
* Coordinating with the customers to analyze requirements for Implementation Guide.
* Created and tested new Maps in test region and FTP to production Box.
* Created job schedules using scripts.
* Developed and upgraded EDI maps for transactions 210,810, 820, 830
* Performed system testing on all EDI transactions both inbound and outbound.
* Setting up the new trading partners and maintained existing trading partners Profiles.
* Working with SAP IDocs
* Interacted with application developers to develop the application file as per customer requirements.
* Mapped the system data to various X12 transaction sets, which were in development at the time. Used TSI's Mercator mapping tool to come up with mappings between EDI documents and our database schema.
* Good Experience with Mercator and Trading Partner PC/32.
* Built automated testing routines for the EDI system.
* Experience with Routers/Launchers
Company: SITA CORP, NJ
Duration: Jan '98 to Jan '00
Role: EDI Programmer
My Responsibilities as a EDI Gentran Programmer.
* Developed and Upgraded EDI maps for transactions 810,820,824,830,850, 856,860,866
* Maps created were for both Inbound and Outbound trading partner relationships.
* EDI subsystem and maps were upgraded from Gentran Server on an NT platform.
* Performed system testing on all EDI transactions both inbound and outbound.
* Involved in Creation, Integration and maintenance of a relational database and a handheld data collection device to gather the necessary information to send Advance Ship Notices (ASN) to the necessary trading partners.
* Setting up the Trading Partner. Worked with SAP IDOCS.
* Mapped the system data to various X12 transaction sets.
* Configured the existing Legacy system to integrate with the EDI subsystem.
Company: NM Compusys (India) PVT. LTD.
Duration: July '97 to Dec '97
Role: DBA/Programmer
Environment: ORACLE 7.x with SAP
Responsibilities:
Involved in configure, maintain and control access of Oracle databases, under layer for SAP objects; allocation and monitoring of database storage utilization; monitor, collect statistics and provide sizing and performance. Creation users and setting up privileges for the protection of data. Performed system testing on all EDI transactions both inbound and outbound
Company: SRIVEN COMPUTER SERVICES, India.
Duration: April '91 - June '97
Role: DBA/Programmer/developer
Environment: Oracle 6/7.x
Responsibilities:
* Take care of the Database design and implementation
* Creation and management of Databases Objects
* Estimate space requirements to management of user accounts
* Creation users and setting up privileges for the protection of data.
* Installation, configuration and upgrading of Oracle server software and related products

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Atlanta, GA | Resumes in Georgia

View other EDI Sr. Programmer/Analyst resumes, Programmer / Developer resumes