Manager Project
Resume:
Vijay Kumar
Sr. EDI//WTX/DSTX Consultant
SUMMARY
. Over 7+ years of experience exclusively in
Mercator/Assential/DSTX7.5/DSTX8.0,8.1/WTX8.2 mapping tools
. Experience on EDI ANSI ASC X12, EDIFACT, HIPAA,HL7 Rosetta
Net and XML (DTD/XSD Schemas) based implementations and
knowledge on ATA SPEC 2000, SWIFT industry standards
. Extensively worked on Mercator Design Studio Type Designer
(.mtt) and Map Designer (.mms)
. Worked on Integration Flow Designer (IFD) to create System
Definition File (.msd) and Event Server System File (.msl)
. Worked on the Event Server Administration - Management
Console to view the process that is running, Event Server
Monitor to view watches and Snapshot Viewer
. Extensively worked on the deployment of the maps to
different flavors of UNIX boxes
. Developed and implemented policy and procedures for all
facets of Technical Operations and Information Systems
. Implemented Mercator Mapping Tool for EDI applications in
Retail, Utility, Telecommunications and HealthCare(HIPAA)
Industries
. Worked on the Mercator Resource Name (.mrn) and Mercator
Resource Configuration (.mrc) files by using Mercator
Resource Registry
. Created Mercator Database Query (.mdq) files by using
Mercator Database Interface Designer
. System Administrator for all B2B communications methods
(AS1, AS2, FTP, and PGP)
. Extensively worked on Mercator for SAP R/3 (XI, SD, IDOC,
ALE and BDC) and EDI.
. General experience in J2EE, with skills in such open-source
technologies as Jython, Hibernate and spring. Experience in
Business Process Integration using Web Sphere Server
Foundation / Process Choreographer 5.1..
. Extensively used MQseries and NDM with Mercator for high
volume Inbound and Outbound transactions
. Worked on the different kinds of Adapters like File, E-
Mail, FTP,SFTP,FTPS,HTTP, MQ, XML etc
. Worked on Mercator Commerce Manager - Message Manager and
Partner Manager
Education
Bachelor of Engineering In Computer Science
TECHNICAL SKILLS
Mapping Tools: Mercator v5.0, 6.0, 6.5, 6.7, DSTX v7.5,
v8.0, WTX v8.1, 8.2
EDI Standards: ANSI X12, ASC X12, EDIFACT, HIPAAv4010, v5010,
SWIFT, HL7
EDI Transactions: 210,270,271,278,834,835,
837,867,810,820,824,850,855,860,865,997
Languages: RPG II, III, IV & ILE C, C++, COBOL, Java, Html, Cgi, Perl, XML
(OAG), XSLT.
Databases: Oracle, MS-Access, MS-SQL Server, DB2
Technology adapters DB2, IBM MQ Series, FTP, HTTP, oracle, File, web
services (WSDL/SOAP)
GUI Tools: Oracle Developer/2000
Communication Protocols: AS2, FTP, HTTP, RUMBA, VAN, FDQ
ERP/CRM: SAP ABAP, SD, MM, FICO, Siebel Sales, Siebel
HealthCare, ePharma,.
Platforms: UNIX (BSD, HP, SCO, SUN, AIX), OS/390,
Windows (2000, NT)
PROFESSIONAL EXPERIENCE
Kaiser Permanente, Pasadena, CA
Jun09 - Till Date
Sr. WTX/ EDI Developer
Project Title: KPEG EDI Implementation
Tools: WTX v8.2.0.4, 8.1.0.3 HIPAAv4010, v5010 ANSI X12, Foresight,
EDSIM,IBM Message Broker v 6.0,MQ SERIES, Mainframes, Ultra Edit
v3.2, ClarEDI, PVCS, XML, Java, IBM MQ Series, SQL.
Environment: UNIX and Windows XP.
Description:
Working in Kaiser Permanente as Sr. Mercator/ EDI Analyst for EDI
implementation project for inbound and outbound 837I/P, 834,835,270,271,276-
277transactions processed through WTX 8.2
Responsibilities
. Involved in requirements gathering and attended design
meetings.
. Perform Analysis, Design, Development and Implementation of X12 EDI maps
by using WTX Software.
. Develop and customized WTX Type Trees and Maps for 837I/P,835,276-277
based on the client requirement
. Developed new 837 I/P and 835 WTX versions 8.2 map based on new copybook
and combined logic from several existing maps.
. Wraps each claim into mini 837 interchages and each mini 837 messages is
re-packaged into a XML formatted messages.
. Developed map to split 835 in the proprietary format based on vendor and
convert them into 835 ANSI X 12 formats.
. Involved in
. Used ORACLE database adapter to call the stored procedure to couple the
835 payment with the 837 claim.
. Involved in unit testing the maps and compared the output from the
existing system to new systems.
. Involved in writing the Tech Spec of the all the interfaces developed and
used Microsoft Visio to elucidate the Process flow and Business Flow
Diagram and update the same whenever there is design changes.
. Evaluated data to find errors in X12 EDI transaction sets.
Aetna, MI
Date: Mar08 - May09
Sr. WTX/ EDI Developer
Project Title: National Provider Identification (NPI) HIPAA
Implementation
Tools: WTX v8.1, HIPAAv4010, v5010 ANSI X12, IBM
Mainframes,JCL,CICS,Ultra Edit v3.2, EDISIM v5.0, ClarEDI, PVCS,
XML, Java, IBM MQ Series, SQL.
Environment: UNIX and Windows NT/2000
Description:
Working in Aetna as Sr. Mercator/ EDI Analyst for EDI NPI (National
Provider Identification) Crosswalk implementation project for inbound
837I/P/, 834,835,270,271 transactions processed through WTX.
Responsibilities
. Involved in requirements gathering and attended design meetings.
. Creating the Technical Design Document for NPI Crosswalk map and attended
the walk through meetings for design review..
. Developed NPI CrossWalk 837 Institutional, 834 and 835 and Medicare A
maps (.mms) by using map designer WTX v8.0.
. Developed and Deployed the Mercator Systems (.msd, and .msl) by using
Mercator Integration Flow Designer (IFD) on to the UNIX box and tested.
. Prepared resource name (.mrn) and resource configuration (.mrc) files for
Crosswalk maps with Mercator Resource Registry.
. Extensively used MQseries and NDM with Mercator for high volume Inbound
and Outbound transactions.
. Configured the communications server to send the mapped EDI files by FTP,
AS2, SMTP, HTTP Email and MQ series.
. Extensive knowledge on proprietary formats like NSF and UB92 Prepared the
mdq for getting NPI values from NPI Crosswalk.
. Understand Mapping rules and incorporate in Mercator Map using various
Functions
. Prepared the test data for Unit testing and string testing by using the
UltraEdit and validated data with ClarEDI and EDISIM.
. Monitor and communicate all EDI mapping and processing changes to the
appropriate departments to ensure timely implementation and compliance.
. Utilized CLAREDI tool in working with Trading Partners to establish HIPAA
certification for both inbound and outbound transactions.
ACS EDI GATEWAY, FL
Mar 07- Feb08
Sr. EDI Developer
Tools : WTX V8.0, DSTX v8.0, 7.5, HIPAAv4010, v5010 ANSI X12, Java,
Ultra Edit v3.2, EDISIM v5.0, ClarEDI,EXTOL, XML, MQ Series, SQL.
Environment: Windows, UNIX, NT
Description:
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,835 and 834 Claims document.
Responsibilities:
. Analyzed requirements, developed, deployed and maintained dozens of maps,
for both command and event servers.
. Perform Analysis, Design, Development and Implementation of X12 EDI maps
by using Mercator Software.
. Implemented Websphere Message Broker for creation and testing of message
flows that interact with oracle tables.
. Developed maps for edi transactions 837 Institutional/ Professional, 835
and 834 HIPAA EDI transactions.
. Websphere MQ v6.0 utilizing Websphere Transformation Extender and
Websphere Message Broker to write and extract data to and from Queues,
allowing flows to and from FTP from oracle tables
. Created Maps for Volume Reporting of the Transactions Inbound and
Outbound of the Clearing House Cycle
. Developed and Implemented several functional maps to implement the
business rules and validations
. Extensively used MQseries and NDM with Mercator for high volume Inbound
and Outbound transactions.
. Designed and developed the process of tracking inbound and outbound
transactions within the Mercator maps using MY SQL databases.
. Perform Analysis, Design, Development and Implementation of X12 EDI maps
by using Mercator Software.
. Extensive experience with IFD, Message manager, Launcher and Partner
manager.
. Understand Mapping rules and incorporate in Mercator Map using various
Functions
. Wrote technical specifications for mapping between HIPAA compliant X12N
transaction sets and legacy system
UPS Supply Chain Solutions, Atlanta, GA
Jan 06- Feb07
DSTX/Mercator/ EDI Developer.
Project Title: Global Warehouse System (GWS)
Tools: DSTX v7.5.1, v8.0, EDIFACT, ANSI X12, ASC X12, Ultra Edit v3.2,
SAP R/3, Idocs, Oracle Financial, EDISIM v5.0, Java, XML
Spy, MQ Series.
Environment: UNIX, AIX and Windows NT/2000.
Description
Worked with UPS - SCS B2B team on Global Warehouse System (GWS) project
which is to define the architecture design, rollout strategy and costs
associated with deployment of Manhattan Associate's WM for Open Systems
enterprise-wide. SCS GIC systems are required to provide the integration
between existing potential GWS customers and GWS system through SIP. WLS
SIP routing engine will be used to route message to the target system based
on the SIP configuration information in the SIP Configuration database. SCS
GIC DataStage TX provides mapping functionality between the customer
interfaces and GWS interfaces.
Responsibilities
. Attended the design meetings, conference calls with Manhattan Associate's
teams for WMS GWS project to implement and identify any road-blocks.
. Prepared the Data Mapping Analysis (DMA's) documents for DataStage TX map
development.
. Mapping ANSI X12 standard document to SAP R/3 Idocs format and vice
versa.
. Create new maps and business logic for existing and new trading partners
. Created DMA's for Inbound and Outbound transactions for different data
formats like ANSI ASC X12-XML, XML-XML, XML- ANSI ASC X12 for Customer to
UPS Canonicals, Canonicals to GWS standards and vice versa.
. Worked on the Inbound and Outbound map (.mms) development of EDI 850 Ship
Order for Customer Karcher, Ship Order canonical to GWS PickticketBridge,
ItemMaster canonical to GWS ItemMaster Bridge, PO canonical to GWS
POBridge, ASN canonical to GWS ASNBridge, GWS PIXBridge to Receipt
Confirm and Ship Confirm canonical to EDI 856 Ship Confirm.
. Designed and developed Mercator maps for transactions
850,854,855,856,820,997 where the data comes in through web converted XML
to X12 and transported back to the web server through the MQ series.
. Developed and Deployed the Mercator Systems (.msd, and .msl) by using
Mercator Integration Flow Designer (IFD) on to the UNIX box and tested.
. Set up Commerce Manager (cmgr/mmgr) tasks - AddressBook, TradeLinks,
Put/Get post office etc.
. Extensively used MQseries and NDM with Mercator for high volume Inbound
and Outbound transactions
. Updated Customer profile database SIP config table entries for GWS
project.
Suraksha Solutions Ltd, India
Aug 04 - Nov 05
Sr. Software Engineer
Company: Suraksha Solutions Ltd.
Role: Database & Internet Applications.
Environment: Oracle, Java, Struts, Windows and UNIX.
Responsibilities
. Developed JFTP project using Java for Suraksha.
. Developed WEB Equator using Java/ HTML with CGI scripts.
. Developed Management Information System (MIS) using Oracle 7.1 as a back-
end.
. Internet Server configuration on BSD UNIX platform including setting DNS,
WWW server, FTP Server.
. Developed Network information System using C language under BSD/386 UNIX
OS. The package is basically meant to ease the job of the UUCP Network
Administrator.
. Configuration of UUCP & Mailers for clients of UUnet on various UNIX
flavors (i.e.: SUN, BSD, SCO, HP, AT&T etc). UUPC for DOS and Winupc for
Windows machines.
Contact this candidate