SUMMARY

• Over 9 years of experience in creating maps using Websphere TX (MERCATOR 6.5/ 6.7/8.2), configuring & interacting with trading partners in laying standard specifications for various transactions for both Inbound & Outbound Mapping using ACORD/EDI / HIPAA and ANSI X12 standards.
• Experience in E - Commerce, Human resources, HealthCare, Telecommunications, Insurance and Logistics 3PL /Supply Chain.
• Experienced in EDI Transactions, good experience in HIPAA transaction sets (270, 271, 276, 277, 278RQ, 278RP, 835, and 837)
• Expertise Interface programs for importing data from feeder systems to different modules using SQL Loader, PL/SQL and UNIX Shell scripts.
• Hands on expertise in using various WTX adaptors (File, Schema, XML, Database, COBOL, CICS etc.).
• Experience in communicating with trading partners, sending documents through VAN, using SFTP, etc.
• Worked on Datapower SOA Appliance XI50 to create WS-Proxy policies and created WTX maps compatible with Datapower.
• Worked on proof of concept for customer using IBM SOA technology stack including (Datapower/WTX8.2/WMB 8.0)
• Demonstrated proficiency in EDI ANSI X12, HIPAA & EDIFACT, Rosettanet and IDOC standards and file formats.
• Configured Active Database Adapter for Oracle database applications
• Developed stored procedures, cursors and triggers for accessing the database
• Hands on Experience in database fundamentals Entity Relationship Modeling, Normalization, Referential Integrity, and SQL and SQL optimization.
• Ability to do independently as well as in a team and experience in coordinating with different groups in a project.
• Excellent Written & verbal Communication, Interpersonal and Organizational Skills.

TECHNICAL SKILLS

Application and Tools: Mercator 6.5/6.7, WTX 8.2/8.3/8.4, Datapower Xi50, IBM MQ Websphere Message Broker 8.0Industry Standards ANSI X12, EDIFACT and HIPAA, Rosettanet, EU-GS1, SAP IDOC

EDI Tools: EDISIM 4.0, XMLSPY

Reporting Tools: Crystal Reports, Oracle Discoverer 10g

Programming Languages: C, Java, VB, Shell Scripting, SQL, PL/SQL, XSLT, ESQL

Messaging Protocols: IBM MQ Series, Message Broker, AS2, VAN, FTPS, JMS, LDAPebXML

ERP: SAP R3 Oracle Financials 10G and 11i, PKMS, Manhattan WMS, SPLUS, EXCEED.

Data Formats: XML, XSD, DTD, & HTML, COBOL Copybooks, X.12, UCC-128. HIPAA (837, 270, 271, 276, 277, 824, 278), SWIFT (535, 536, 537, 950, 541, 543), RosettaNet, EDIFACT, RFID

PROFESSIONAL EXPERIENCE

Confidential, GA

Integration Developer

Responsibilities:

• Analyzed all business functionality and developed technical specifications for interface modules for many customer integrations with UPS WMS and Logistics application
• Provided data analysis to support and fix gaps in bussiness requirement and application capabilities.
• Worked with complex XML structures like GS1, RosettaNet standards, IDOC layouts (MATMAS/CLFMAS/RESADV )etc.
• Responsible for migration effort from WTX 8.1 to WTX 8.3 and Trading Partner Manager upgrades.
• Responsible for migration of customers from legacy application to UPS strategic WMS systtem
• Worked with solution architects and data architects to resolve data related and interface related issues.
• Worked on variety of EDI Transaction sets for ANSI X12, UCS, VICS & EDIFACT standards including 214, 810, 850, 855, 856, 860, 940, 945, and 947, ORDERS, DESADV, and INVOIC with specialty on ASNs, POs, Invoices
• Worked with warehouse professional setting up middleware/interface solution in process automation.

Environment: WebSphere Transformation Extender 8.2, XML, DTD, IBM MQ Series, Manhattan WMOS, PKMS, SAP IDOC, DB2, Sql Server.

Confidential, Worcester, MA

Integration Developer

Responsibilities:

• Analyzed all business functionality and developed technical specifications for various interface modules from business requirements.
• Designed WTX mappings to convert ACORD XML to Hanover canonical data model, created many reusable interface.
• Worked with solution architects and data architects to resolve data related and interface related issues.
• Worked on Datapower SOA Appliance XI50 to create WTX - Datapower compatible Maps
• Created WS-Proxy rules for client to server and server to client workflows.
• Worked with WTX-Launcher environment to run various maps, and configured HTTP, SOAP adapters to accept incoming XML payload.
• Create maps from XML to COBOL copybooks segments.
• Configured various resource adapters for RDBMS, FTP, and HTTP, SOAP in WTX.
• Create router maps as per the design requirements to call other maps using RUN functions.
• Worked with vendors to resolve connectivity issues with various services orchestrated in WPS.
• 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.

Environment: WebSphere Transformation Extender 8.2, Datapower Xi50, XML, DTD, IBM MQ Series DB2, Sql Server.

Confidential, Westborough, MA

Integration Consultant

Responsibilities:

• Analyzed all business functionality and developed technical specifications for various back end interface modules from business requirements.
• Key member in techno-functional discussion for implementing business logic changes to existing and developing new interfaces and applications.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating, Managing/ Archiving tables, indexes, tablespaces, triggers, db links and privileges
• Developed back end interfaces / conversions and tuned existing interfaces to implement key business functionality e.g. orders, inventory management, customer creation and replication using PL/SQL stored procedures.
• Configuring & interacting with trading partners in laying standard specifications for various transactions for both Inbound & Outbound Mapping Using WTX8.1.
• Involved in the migration of Mercator maps to WTX 8.1
• Configured various resource adapters for RDBMS, using email, FTP, and HTTP in WTX.
• Perform Analysis, Design, Development and Implementation of X12 EDI maps.
• 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.
• 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 maps using oracle database.

Environment: Datastage TX 8.0, WebSphere Transformation Extender 8.1, XML, DTDOracle 8i, Oracle 11i/11.03 ERP, SQL, PL/SQL

Confidential, MA

Integration Developer

Responsibilities:

• Analyze the ILEC EDI specifications and create mapping documents.
• Create Gap Analysis documents for different versions of ILEC EDI specification documents.
• Create type trees from DTD’s using DTD importer tool from Type Designer.
• Developed Inbound maps for 855, 865 and Outbound maps for 850, 860.
• Mapped various formats of data using Map Designer. Mapped XML to EDI and EDI to database, Database to EDI, EDI to flat files using Database Adapters, Database Interface.
• Involved in creating trading Partner Relationships using the Mercator Commerce Broker.
• Created system files using Integration Flow Designer and deployed onto server.
• Worked in the whole life cycle of software development: Requirement collection, analyze, design, implementation, code review and test.
• Developed applications and projects for enterprise customers.
• Intensively used database Interface Designer to populate the preexisting tables following the referential Integrity rules.
• Integration project to insert customer data sent in Rosettanet XML into Oracle database.
• Implemented batch scripts to pull data from Oracle database via Mercator and convert to XML format.
• Mapped incorrect EDI data onto a file using Mercator error handling functions and report the errors.
• Create test files for various scenarios as per the ILEC EDI guidelines.
• Communicate with trading partners to discuss the mapping requirements and various issues related to EDI files.

Environment: Datastage TX 8.0, Mercator (Mercator Design Studio, Mercator Integration Flow Designer) XML, DTD, XML SPY, Oracle 9i, SQL, PL/SQL, Sun-Solaris, SQL Navigator and Toad.

Confidential - Rochester, NY

EDI Systems Analyst

Responsibilities:

• Worked on developing an inbound splitter Map for the 837 to split claims based on Providers and regrouping the files for processing.
• 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
• Actively involved in Unit, System, Volume, Integration, User and Partner Testing stages supported various Zones - Development, User Acceptance Testing,
• Oracle SQL queries, and PL/SQL development and testing with maps.
• Worked on design and Mercator mapping of clearinghouse Inbound/outbound reports.
• Worked on daily product support.
• 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 requirements, primarily involve in developing 837 Medicare clearinghouse modules.

Environment: HIPAA, Mercator6.7, IBM MQ Series, DTD, UNIX, PL/SQL

Confidential

Database Developer

Responsibilities:

• Converted the Functional requirement to technical design document, wrote utility release notes and install documents.
• Sql Loader was used to convert the data from the Excel to oracle tables.
• Wrote Stored Procedures for effective insertions and updations of the data to the tables when the application is online reducing the network traffic.
• Sub-queries and joins were extensively used in stored procedures.
• Created Shell scripts to automate the load of data from Text files to Oracle Tables.
• Created Packages to automate transactions from the Oracle Forms.
• Involved in extensive coding using Oracle PL/SQL.
• Created database triggers to automate the transactions that take place online.
• Subversion technology used to maintain the source code.
• Extensively worked with table partitioning and tablespace creation etc.
• Used Oracle Forms to design and develop the interface for the system.
• Created matrix reports using oracle reports
• Created Object Groups to create to screen templates with Forms
• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.

Environment: Oracle8i, PL/SQL (Stored Procedures, Packages, Triggers), HRMS/Payroll, Forms & Reports, Shell scripting, SQL*Plus, Toad.