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 six years of experience as an interface designer and developer in EAI, B2B/ EDI implementations using Gentran AI, Gentran Server, GIS and SeeBurger. WebSphere MQ (WMQ, MQ Series), XML, relational databases, SAP R/3 ERP and various flat file formats. .
• Worked with 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) maps to SeeBurger and GIS.
• Worked with Trading Partner setup, new Business Process development in GIS 4x environment.
• 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:

• GIS 4.3, Gentran 6.0 and 6.1 including Application Integrator and Visual Mapper. Also worked with AI for GXS.
• Design Studio Versions: 6.x, 7.x, 8.x including Type Designer, Map Designer, Database Interface Designer and Integration Flow Designer
• SeeBurger BICMD & and 6.2
• 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:
Mapping Tools: 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.
• Bachelors in Technology.

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH Mar 2009 - Present
Role: B2B/GIS Analyst

Involved in migration of B2B application from Gentran Server for Windows to GIS 4.3 from day one. Responsibility include :

• Installation of GIS application on Dev, QA and Production Linux Environment.
• Converting all the existing Gentran maps to GIS 4.3 environment. Nature of Maps is flat file to EDI, EDI to flat file, XML to flat file and vice versa. Maps involve are all the important transaction of EDI X12(810,855,856,856,855 etc) and EDIFACT(DESADV, INVOIC, ORDER , ORDRSP etc)
• Configuration of existing BP\'s (supplied by Sterling Commerce) to suit the requirement of Business have supplied. Also involve in writing new BP\'s that have not been supplied by Sterling and have been required for our company\'s need.
• Creating New Envelopes for all existing Trading partner in GIS environment.
• Outline the procedure for migration from QA to production environment.
• Created a PL/SQL script for test file comparison, it had helped a lot during migration process.
• Supported and created new communication setup on Inovis Biz Link and Inovis Van gateway.

Environment: GIS 4.3,Gentran 6.0, BizLink,, Linux, Window XP, AOM, QAD

Confidential, Chicago, IL Apr2008 -Mar 2009
Role: EDI Developer

Worked on a migration from Gentran Unix 5.3 to GIS 4.1. Migration duties include converting maps, building maps from scratch, setting up new GIS envelopes, setting up GIS code lists, and full life cycle testing. Data mapped includes X12, Edifact, proprietary data and flat files. Integrated EDI with SAP R/3 via various IDoc messages. Worked heavily in SAP regenerating outbound files and loading incoming data. Fully implemented global EDI partners and their associated GIS envelopes. Also assisted in day to day production issues in both Gentran 5.3 and GIS 4.1. Also performed EDI integration tests on hundreds of maps and partner configurations for Wrigley’s world-wide trading partners.

Environment: GIS 4.1, Gentran 5.3, SAP R/3, Linux, Window XP

Confidential, Louisville, KY Dec 2006-March 2008
Role: EDI Analyst

Worked in a GIS 4.1 environment with an Oracle backend. Performed daily maintenance on the system as well as development. Constructed multiple maps including ODBC maps that pulled invoice information directly from the Oracle tables. Also developed maps that loaded information directly into the Oracle Database. Generated specs using SpecBuilder. Performed trading partner setup in GIS (Enveloping) and also wrote multiple Business Processes. Mapped all types of data including XML, Delimited and proprietary positional data. Assisted in writing SOAP calls to retrieve data from trading partners. Also worked with FTP and multiple VANS. Developed an invoice from scratch including what information we would pull from the Oracle tables, what data we would be sending and in which segments we would deliver that data. Wrote the spec, did all testing and delivered the project on time. Performed triage daily while developing these maps

Environment: GIS 4.1, Oracle, Linux, Window XP

Confidential, Houston , TX Jan 2006 - November 2006
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 Gentran 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 GXS AI environment and 823 map for BOA in Gentran server and 820 for Citibank in GXS AI 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 Gentran Server and GXS AI.
• Next Gen Project
  HP is switching to Seeburger for B2B integration. Worked with NextGen team to complete the migration of maps from Gentran to SeeBurger. Maps are in GXS AI as well as Gentran Server. 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 both Gentran Server and GXS AI, 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: GIS 4.1,Gentran 6.0,SeeBurger 6.2, Cyclone, HPSB,, Window XP, AS/400, Commerce Manager 7.7 version, MS SQL server 2000, BIS 6x, Cyclone, Web Methods

Confidential, Chicago, IL May 2005 - Nov 2006
Role: Gentran-GIS / EAI Developer

Confidential 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. Confidential 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.

Confidential, Monroe, LA Aug 2004 - Apr 2005
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.

Confidential, Secaucus, NJ Aug 2003 - Jul 2004
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
• 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)

Confidential, Montvale, NJ Jan 2002 - May 2003
Role: Oracle PL/SQL Developer

I worked for the IT division of Confidential 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