Project Developer
Resume:
Abhishek Kumar
********@*********.***
PROFESSIONAL SUMMARY:
Over seven years of experience in the requirements analysis, design, development, testing,
deployment and post production support for software applications in Enterprise Application
Integration, Business to Business (B2B) and EDI Implementations
• Over eight years of experience as an interface designer and developer in EAI, B2B/ EDI
implementations using WebSphere Transformation Extender/WTX (Previously known as
Ascential DataStage TX & Mercator Integration Broker) MessageWay Translator, Gentran AI,
Gentran Server,GIS and SeeBurger. WebSphere MQ (WMQ, MQ Series), XML, relational
databases, SAP R/3 ERP and various flat file formats.
• Expertise in using various WebSphere TX resource adapters such as file, database, Sink,
Email, SAP R/3 (ALE and BAPI) and FTP as source and destination in data transformations
involving XML, IDocs, Cobol Copy Books and various other flat file formats.
• Worked with MessageWay Translator, Gentran AI and Visual Mapper for various kind of data
transformation such as XML to Standard, Standard to XML. Application to application and
other standard formats.
• Worked with Migration of Gentran's (both AI and Gentran Server) and MessageWay
Translator maps to SeeBurger.
• Extensive experience with EDI ANSI X12, XML, EDIFACT, HIPAA, ACORD, IDocs, HL7 and
other XML based standards.
• Over two years of database programming experience primarily involving Oracle and DB2
UDB database
• Ability to work in team environment and also independently with very good interpersonal
skills.
EDI/Integration SKILLS:
• Design Studio Versions: 6.x, 7.x, 8.x including Type Designer, Map Designer, Database
Interface Designer and Integration Flow Designer
• GIS 4.1, Gentran 6.0 and 6.1 including Application Integrator and Visual Mapper. Also worked
with AI for GXS.
• SeeBurger BICMD & and 6.2. Inovis Biz Mapper and BizLink
• Experience in: B2B integration using EDI ANSI X12 and EDIFACT & EAI using WebSphere
TX, XML and WebSphere MQ
• Command Server and Launcher / Event server based deployment and maintenance
• WTX upgrade, remote development and support
• Trading partner setup in Gentran, deploying maps on server, transferring Gentran project
from Test to Production.
OTHER TECHNICAL SKILLS:
Page 1 of 8
Mapping Tools: Mercator / DataStage TX / WebSphere TX (WTX) 6.x, 7.x,
8.x,MessageWay Translator,GXS, Gentran Sever, GIS, Web
methods,SeeBurger BICMD & BIS 6.1 and 6.2, Inovis TLE 6.0x and
Biz mapper.
Languages / Scripting: PHP, ABAP/4, C++, PL/SQL
Web Tools / Technologies: HTML, JavaScript, JSP, XML
ERP: SAP R/3 4.7 (ALE/IDocs, BAPI, SAP Scripts, Reports)
Standards: ANSI X12 EDI, EDIFACT, HIPAA, HL7, Rosetta net, SWIFT
Operating Systems: Windows XP/2000/98, MS DOS, Linux, Unix (Solaris),AIX 5.3
Additional Software: MS Office Applications, XML SPY, Edit Plus, Ultra Edit, CVS, VSS
Databases: DB2 7.x / 8.2, Oracle 8i / 9i / 10G, mySQL
Messaging Tools: WebSphere MQ 6.0, MQ Series 5.3
TRAINING AND CERTIFICATIONS:
• Attended SeeBurger BIS & BICMD 6.1 and 6.2 training in HP
• Corporate delta training in Ascential DataStage TX 6.7 and adapters 2004
• Delta training in 7.5 and 8.1 versions of the Design Studio – 2006/2007
• Attended hands on workshops and bootcamps on the following tools and standards:
WebSphere MQ, EDI ANSI X12, EDIFACT and XML.
EDUCATION:
• Masters in Engineering, University of South Florida, Tampa
• Bachelors in Technology, Institute of Technology, Banaras Hindu University (IT BHU),
Varanasi, India
WORK EXPERIENCE:
Exel Logistics, Columbus, OH
Sep 2012 – Present
Role: Integration Analyst
I have worked to integrate various transactions for Katz Group Canada. We are involved in
data integration from Warehouse, Data Management and Financial team for the company.
Transaction sets involved are 810, 856,850,870,820 on X12, ORDER, ORDRSP,INVOIC on
EDIFACT. There are conversions involved from XML to flat file and vice versa. There are some
Abhishek Kumar
********@*********.***
transaction from bank partners which are in Swift standard and I am involved in writing maps
for those transactions also
Hewlett Packard, Austin, TX
June 2011 – Aug 2012
Role: B2B Analyst and Developer
I have Worked with B2B team in HP for many of ongoing projects, transforming files from one format
to other. Configuration of new trading partners setup in both Test and Production environment.
Making changes in existing map as per partner requirement and moving them to production. I have
involved in UAT and SIT testing. Migration of WTX map to SeeBurger, Configuration of partner
connectivity using Cyclone(Axway) and Webmethods.
Major Projects in HP
Digital Retirement Project
As per scope of this project Digital Legacy Retirement is shutting down 60+ applications
(including EESY, FOCUS, BOSS, OMNI, PRIME, etc) and needs all the mapping migrated
over to the go forward systems. Completed Maps Development for INBOUND USPS 850,
Ontario Power 850, Chrysler 850,860,820. OUTBOUND maps completed 855, 857, and 870
for USPS. These maps involved conversion from standard to XML, standard to application
and XML to standard. Also worked on to complete the connectivity from HP back end
application to different partner using HPSB(HP internal software),Cyclone and VAN
connection.
Business Connector Project
This project is replacement of Business Connector project. Business connector is a web
methods application that connects SAP system, is replaced by SAP XI. In this project I
worked on Rosettanet PIP's 3A6, 3C3 and 3B2. Completed the map from XML to XML and
get an overview of Web methods in this project. Maps are written using Web methods.
MADO Project
This project is related with integration work of Merger and Acquisition of Neoware and
EYP by HP. For this project completed the 850 map for Ingram, Tech data and Synnex in
Mercator environment and 823 map for BOA in WTX server and 820 for Citibank in
DataStage 7.1 environment. Also, worked on connectivity from HP’s back end application to
these partners using VAN and cyclone.
On boarding Project
This involved working with different partners for their EDI setup. Worked with Canada
Railways on 850 and 810, with Samsung Electronics for 3A4MG1, 3A4MG2, 3A8MG1,
3A8MG2 and 3A7MG1, with Highly info for EDIFACT ORDER and ORDRSP, and with Ingram
for 810, 850, 856 and 870 implementation. These maps involve conversion of standard to
various form such as XML, IDOC and vice versa. Also involved Rosetta net conversion. Maps
are written using WTX Design Studio.
Page 3 of 8
Next Gen Project
HP is switching to Seeburger for B2B integration. Worked with NextGen team to complete
the migration of maps from WTX to SeeBurger. Completed migration of maps which include
X12 transactions such as 820, 850, 856 and Orders, PAYMUL for EDIFACT. Maps are both
inbound as well as outbound and structure is idoc, xml, delimited file apart from standard
structure such as X12 and EDIFACT. Also worked on BIS environment for repository and
Trading Partner setup.
Apart from these projects I am involved in modification of various maps in WTX environment, setting
of trading partners using HP's web application as well as using Unix. Also worked on to provide
production support to fix the map and submit request to move the maps to production
Environment: Datastage7.1,SeeBurger 6.2, Cyclone, HPSB,, Window XP, AS/400, Commerce
Manager 7.7 version, MS SQL server 2000, BIS 6x, Cyclone, Web Methods, MessageWay Translator
Inovis, Dallas,
TX
November 2009 – May 2011
Role : Web methods/TLE Integration Analyst
I have worked in the Managed Service team of Inovis for Dell Migration project. Scope of the project is
to migrate all B2B application of Dell to Inovis environment. All the Dell's application are using
MessageWayTranslator, we have to first complete the mapping specs for those maps and then write
those map using Inovis TLE and Biz mapper. It also involves migration of trading partner to Inovis
environment using AI and BizLink.
Type of maps involved is EDI to XML, XML to EDI, XML to XML, XML to flat file etc. Transaction set
involved are 210,214,850,810,855,856, 860, 870 etc for ANSI X12, INVOIC, ORDRS for EDIFACT.
Some XML transformation also involved SOAP enveloping.
Worked on conversion of 200 maps from MessageWay to Inovis environment which include TLE and
BizLink
Apria Healthcare, Lakeforest, CA
Oct 2006 – Oct 2007
Role: WebSphere TX Developer/ Analyst
Worked with TRADE (Transaction Routing And Data Exchange), a division of the IT at Apria
Healthcare, a leading provider of integrated home healthcare products and services. Responsibility of
this team was mainly to implement and support Apria’s EDI transaction processing. Worked on:
HIPAA / ANSI X12 EDI 835, 837, 820, 823, 276 and 277 transactions
Abhishek Kumar
********@*********.***
Auto Claim Status Project: This project involved automation of the process of Claim status request
and status response between Provider (Apria Healthcare) and Payer (through a Clearing House like
PNC bank etc).
Responsibilities
• Design and develop a mechanism to Pick up ACIS/CSI (276 Proprietary format) Claim Status
Inquiry generate X12 276, transmit it to PNC and receive PNC/997
• Receive PNC/X12 277, translate to proprietary format: ACIS/CSR and upload to AS/400 Apria
system.
• After receiving PNC/X12 277, generate Apria/997 through Commerce Manager, and transmit
to PNC
Cash Management Imitative (CMI) Project: Implemented a new Cash Reconciliation application,
and modified the existing system to meet business requirement and objectives.
Responsibilities
• Developed Interface to receive 820, 821,823,835 EDI files from bank server, and log details in
control table.
• Performed Basic file validation(duplicate file, control total checking) and translated the valid
file into 823 and 835 fixed file format and deliver to Cash reconciliation application for
processing.
• Received 835 fixed file format and translated into 835 X12 format.
• Routed all the files to financial server for Journal entry.
Environment: Ascential DataStage TX 8.0 design studio component, HIPAA EDI ANSI X12, Window
XP, AS/400, Commerce Manager 7.7 version, MS SQL server 2000.
Boehringer Ingelheim, Ridgefield, CT Jan 2009 –
Sep 2009
Role: WebSphere TX Developer/ Analyst
Worked on new design, development and upgrade of various existing WTX interfaces including EDI
ANSI X12 and EDIFACT, which are in Mercator version 6.5 and 6.7 to WTX version 8.1, tested and
coordinated deployment into Unix based Launcher.
Responsibilities:
• Used R/3 (ALE, BAPI), FTP, email and database adapters with maps communicate between
SAP and legacy systems.
• Extensively used the EDI pack for interfaces for SAP inbound and outbound scenarios.
Page 5 of 8
• Implemented Resource Registry in all the interfaces.
• Traced and fixed the issues in type tree properties while upgrading to WebSphere TX 8.1
• Enhanced various stored procedures invoked by maps in Oracle database for better
performance
• Generated type trees for all IDOCs and BAPI structures during the upgrade to version 8.1
• Deployed and tested all the upgraded maps in launcher using the Integration Flow Designer.
• Used the map profiler utility in launcher to identify bottle necks and performance tuning of
various maps
• Documentation on various issue resolutions and break fixes
Environment: WTX ver 8.1 Design Studio (Type Designer, Map Designer, DID and
IFD), Oracle 9i, WebSphere Transformation Extender 8.1, Launcher, SAP 4.6 B,
Windows 2000, HP Unix
RR Donnelley, Chicago, IL
Dec 2007 – Nov 2008
Role: Gentran GIS / EAI Developer
RR Donnelley designs, manages and produces words and images, and brings them to life on paper
and in digital form for customers in the publishing, healthcare, advertising, retail, technology, financial
services, manufacturing and many other industries. RRD embarked on SAP R/3 and EDI Integration
projects using Gentran AI and GXS as a part of the EAI and B2B integration initiatives
Responsibilities
• Worked as a technical analyst on the business integration team focusing on interfaces and
business processes involving Gentran AI, GXS, EDI ANSI X12 and SAP R/3.
• Determined requirements for configuration changes required in SAP R/3 to interface with the
DataStage TX maps and exchange EDI ANSI X12 data (850/855/856/810) required by various
trading partners and customers of RRD.
• Provided technical support for all Gentran maps in test and production servers using Cyclone
AX gateway as a transportation media.
• Working with DBA to maintain all Sybase Database objects (Tables, SQL Objects) associated
with the Gentran based interfaces.
• Set up and documented Partner profiles and integration testing results
• General troubleshooting of various production issues
Environment: SAP R/3 3.1H, Gentran AI, GXS, PVCS, WebSphere MQ 6.0, AIX 5.3.
Abhishek Kumar
********@*********.***
Century Tel, Monroe, LA
Aug 2006 – Nov 2007
Role: Mercator Developer
I worked as a developer on on ongoing Project Envision which is a company wide strategic business
initiative for business process improvement and adoption of state of the art hardware and software
tools and technologies. One of them is to establish EDI communication between their partners.
Responsibilities:
• Requirements collection and analysis for various customers of Century Tel and
documentation of the business specifications for each map.
• Design and development of a parser map which takes a file containing multiple EDI
documents from the UNIX box using FTP adapter and separate and place each business
document in different file folders. Possible incoming files include EDI ANSI X12
856,855,997,810.
• Designed and developed maps to accept an inbound EDI documents 855 and 856 (Advance
Shipping Notice) and send the data to an SAP R/3 ERP using ALE adapter.
• Created a map for sending Functional Acknowledgement 997 for the documents received.
• Enhanced existing Outbound 850(Purchase Order), 860(Purchase Order Change Request)
maps to handle multiple partners. When data from SAP has multiple partners, map
differentiates the partners and creates separate ISA IEA segments for each of the unique
partners.
• Created map, which reads PO data in XML format from MQ Series queue and updates into
the SAP system as well as in Oracle where data is stored for auditing purposes.
• Created unit test documents and test cases all the maps and interfaces developed
• Conducted knowledge transfer sessions to full time employees for maintenance of the maps.
Environment: Mercator Design Studio 6.5, IDOC Importer Utility, Event Server, System Editor, SAP
4.6B, MQ Series, XML, Oracle 8.x, Windows and Unix.
Panasonic Electronics, Secaucus, NJ Aug 2005 –
Jul 2006
Role: Mercator/Database Developer
Work on an EDI Integration project involving automation of sales orders and order
integration into the Oracle ERP as per the ILEC EDI guidelines. Worked on various
maps involving data transformation from XML to EDI, database to EDI and vice versa.
Responsibilities:
• Analyze the ILEC EDI specifications and create mapping specification documents.
• Developed Inbound maps for EDI ANSI X12 855, 865 and Outbound maps for 850, 860.
• Mapped various formats of data using Map Designer. Mapped XML to EDI and EDI to
database, EDI to flat files
Page 7 of 8
• Extensively used various resource adapters and the database interface designer
• Created system files using Integration Flow Designer and deployed onto Event Server.
• Mapped incorrect EDI data onto a file using Mercator error handling functions to report the
errors.
• Create test files for various scenarios as per the ILEC EDI guidelines.
• Perform Unit and integration testing of the maps.
• Communicate with trading partners to discuss the mapping requirements and variations as
per companion guides and various issues related to EDI files.
Environment: EDI ANSI X12, Mercator 5.0 (Mercator Design Studio, Command Server), Event
Server, Oracle, SQL, PL/SQL, Windows 2000, Event Server on Unix (Sun Solaris)
A&P Supermarkets, Montvale, NJ
Jan 2004 – May 2005
Role: Oracle PL/SQL Developer
I worked for the IT division of A&P Supermarkets in Chennai on their retail distribution
applications. This application was designed to monitor the purchase, storage and
distribution of general merchandise among a chain of retail sales outlets and
accounting of all sales.
Responsibilities
• Involved in back end development involving PL/SQL programming using TOAD for Oracle
database.
• Creating Tables, indexes constraints and improved database performance.
• Wrote PL/SQL procedures, functions and triggers for insert, update, and delete transactions.
• Created the indexes to optimize the performance of the data retrieval process.
• Created and ran the shell scripts to run the Processes at time schedule according to business
rules.
• Performed exceptions handling and tuned stored procedures and triggers identified for better
performance.
• Used SQL*Loaders to upload the data into database from the text files and spread sheets.
• Involved in complete documentation using MS Office.
• Involved in testing and fixing bugs on test and on line data.
Environment: SQL *Plus, Oracle, PL/SQL, TOAD, Shell Scripting, Sun Solaris 5.9, HTML
Contact this candidate