PROFESSIONAL SUMMARY

• Having 12 years plus of hands on experience in EDI using different tools like Websphere Transformation Extender formal DataStage TX/Mercator , Gentran, Ecmaps on Windows NT, UNIX, Mainframe, Implementing EDI with DB2, Oracle, and XML, SAP IDoc.
• Having 19 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.
• 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.
• Familiar with CARGO 2000, ANSI X12, EDIFACT standards.
• Familiar with UIT, SBT, Financial standards.
• HIPAA Standards: Knowledge of Electronic Data Interchange EDI X12 standards, In depth technical knowledge of 004010A1 HIPAA Transaction Sets is strongly preferred - 837, 835, 270/271, 276/277, 278, 834, NSF, UB92, HL7 and NCPDP.
• Experience in communicating with trading partners, sending documents through VAN, using FTP, etc.
• Expertise Interface programs for importing data from feeder systems to different modules using Oracle database, SQL Loader, PL/SQL, Perl and UNIX Shell scripts.
• IBM WTX, IBM WMB, WAS, JMS, WPS, WPG, and WMQ with J2EE application software to support business requirements.
• Good knowledge in WebSphere Message Broker with WTX.
• Good Analytical skills and documentation for 5010 requirements
• Translation/Mapping Tools: Websphere Translation Extender WTX 8.2 /DataStage TX/Mercator
• Extensive experience in Fine tuning systems and troubleshooting
• Design Studio: Map Designer, Integration Flow Designer, Database Interface Designer
• Resource Adaptors: File, DB2 Database, MQ Series, FTP, Web Services
• Operating Systems: In depth knowledge of AIX UNIX operating systems and shell scripting is required.
• Database: Relational database design - DB2, Oracle
• System Integration: FTP, Message queuing MQ Series, JMS, MSMQ - Websphere MQ Series is preferred

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

Professional Experience:

Confidential

Sr. Programmer/Analyst Middleware

Responsibilities:

• 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.
• Extensively used database adaptors with WTX map.
• 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.
• Modified some of the business rules to suit the development of the maps in WTX Mercator environment.
• Modifying existing maps as per MSR requirements.
• 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.
• Modifying existing maps as per defect raised by functional/QA team.
• Actively involved in Unit, System, Volume, Integration, User and Partner Testing stages supported various Zones.

Environment: IBM WTX Mercator , IBM Websphere MQ, DB2, ClearCase, NetCool, Quality Center Defects.

Confidential

Sr. WTX/Database Developer

• As a Senior Analyst worked on supporting database and WTX maps for upgrade.
• Worked with DBA to ensure database objects has proper permission to work with MQD file.
• Based on requirements creating design specifications
• Support unit test, Interaction test, system test applications.
• Involved in coding and code review upon considering IBM best practices
• Involved in support of multiple releases into production
• Design and configure applications to reach functional and technical standards
• Involved in creating huge test data for volume and system test
• Involved in installation and configuration of new WTX 8.2.
• Crated and deployed mrn, ini, mmc, msl and launcher specific configuration files.
• Involved in Designing, development and configuring applications to reach functional and technical standards.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• WTX map calling JAVA Class program
• WTX map for JMS adapter for WAS server embedded MQ
• Calling WTX map from JAVA code for real time transaction
• WTX map for socket adapter for real time transaction
• Rollup triggered with java program
• Inbound/outbound tracking maps with JMS adapter no database adapter used
• Involved in the designing tracking XSDs.
• Involved in creating upgrade 5010 map.
• Involved in installation and configuration of WTX 8.2 on UNIX.
• Created launcher on UNIX.

Environment: WTX 8.2 Mercator , AIX, WAS embedded MQ , J2EE EJB, JMS , XML and XSD, Hibernate, WebSphere App server, Portlets, Oracle, etc.

Confidential

Sr. Programmer/Analyst Middleware

Responsibilities:

• 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.
• Modified some of the business rules to suit the development of the maps in Mercator environment.
• Developed new maps/changing existing maps as per requirements.
• 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 .
• Actively involved in Unit, System, Volume, Integration, User and Partner Testing stages supported various Zones
• Extensively used database adaptors with WTX map.

Environment: IBM Datastage TX Mercator , WPG, IBM Websphere MQ, DB2, ClearCase, NetCool, Vantive Tickets.

Confidential

Sr. Programmer/Analyst

Responsibilities:

• As a Senior Mercator programmer analyst worked on NPI 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.
• 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
• Modified some of the business rules to suit the development of the maps in Mercator environment.
• Developed new maps/changing existing maps as per requirements. CSR/Workbench tickets
• Fine-tuned the maps for enhancing their performance in the mainframe environment.
• Developed the map to generate Acknowledgement 997 and Edit Reports.
• Analysis and Understanding the Cobol Copy Book structure and HCFA Structure
• Built Maps and performed Unit Testing on NT using self designed Test Cases/Test data.

Environment: Mercator 8.0/6.5, Commerce Broker, COBOL-II, JCL, VSAM, MQSeries 5.2