Integration Analyst

Cell: 832-***-****

yjq5qt@r.postjobfree.com

SUNIL K SACHDEV

SUMMARY

• More than 10 years of IT experience with 6+ years of working with eCommerce tools and XML & EDI translator products and Middleware products.

• Experience includes multiple file formats such as XML/IDOC/EDI/Flat File (9 years), analyzing and working with electronic payment processing (credit card; 2 years), writing use cases (2+ years), webMethods, DataPower XI 50 Contivo mapping technologies (7 years), SQL (6 years), MS Office (9 years), Incident/Problem/Change tools (9 years), CVS (1 year), and Clearcase (6 months).

• Worked with WebMethods7.1 and its components viz. Integration Server Admin, Trading Networks, Developer, BrokerAdmin Document Tracker and TIBCO3.6 Rendezvous & Message Broker.

• EDI/IDOC implementation coupled with strong SAP R/3 background including functional analysis, configuration, and implementation of Materials Management and configuration for EDI.

• Detailed knowledge of EDI ANSI X12 4010 and EDIFACT D98A standards and transaction sets e.g. 810, 850, 855, 860, 870, 835,837,820, 270/271 etc. etc. and XML based standards and business documents e.g. xCBL, cXML, CIDX, PIDX, HIPPA, RosettaNet, PapiNet, ACORD, UCCNet and ERP related interfaces e.g. IDOCS & Oracle Apps interfaces.

• Working knowledge of Java and Oracle & DB2 Database and TOAD & SQLNav4 database management tools.

PROFESSIONAL EXPERIENCE

• Amazon.com Seattle, WA 4/10 - Now

Support Engineer – Volume Listing Applications

• Amazon Sellers use Excel (flat-file) and XML Feeds and Reports to manage a high volume of listings and sales on Amazon. Worked as support engineer with strong XML skills.

• Worked with engineering teams on the delivery of new templates to support ongoing category expansions. The work involved generating the new templates, creating the appropriate Contivo mappings and ensuring automated testing created and any issues discovered by such testing is addressed.

• Worked having good familiarity with XML and Excel with solid communication skills with internal stakeholders for clarifying requirements.

• The VLA team is part of Merchant Technologies, responsible for the development and operation of Amazon’s selling platform and used by more than a million sellers worldwide.

• Worked well in a fast-moving team environment and was able to juggled with many tasks and projects.

• Experienced working with Contivo for data transformation and VB skills.Worked with XML, XSD and XSLT Excel skills.

• Wells Fargo Bank N.A. Phoenix, AZ 5/09 to 3/10

webMethods7.1 Developer

• Responsibilities

• This project aims at integrating the Business documents (EDI, XML) with the mainframe system and also Partner data using Trading networks to exchange between partners.

• Defined Trading Partner Profiles, Document Types, Processing Rules and Trading Partner Agreements (TPA) in Trading Networks.

• Developing Flow Services with necessary Mappings, Validations, and Business Rules for Inbound and Outbound Interfaces.

• Defined mappings for various EDI Transactions like 850, 855, 810 and 997.

• Involved in implementing AS2 communications setup with Trading partner for EDIINT.

• Developed mapping routines to Map incoming XML to a canonical document and deliver it to a queue and to map from a canonical document to outbound XML and deliver it to the customer.

• Involved in transformation and representation of XML files using XPath and XSLT.

• Involved in configuring the setup for cXML PunchOut Sessions via webMethods.

• Developed process models to implement the flow of the order in order fulfillment process using webMethods Modeler.

• Configured and Developed SAP Communicaitons for the R/3 system.

• Managed packages and services, which includes tasks such as activating/deactivating services, copying packages, and updating services and/or packages as necessary.

• Checked for expiration of client certificates and importing new client certificates and mapping it to users.

• Suggested and used X server to connect from Unix Box to configure GUI Adapter an Development box.

• Developed services to process incoming IDoc’s from SAP, mapping services to translate from IDoc to XML format and also configured routing rules.

• Configured MQ Adapter for connecting with MQ Series instances and listening notifications using webMethods Administrator.

• Developed services to process messages put on MQ queues by applications like OrderMax, Broadvision.

• Actively participated in migration of code and files from webMethods6.1 to webMethods7.1 server and assisted in testing the functionality on the new platform.

• Environment: SAP R/3 4.6 Adapter, WebMethods Product Suite 7.1( Integration Server, Broker, Developer ,Monitor, Modeler, Trading Networks Console), MainFrame, Gentran, WebSphere MQ Adapter 3.0, XML, cXML, xCBL, deXML, INOVIS, GXS, Sterling commerce, Commerce One, Unix.

• Wright Express, Portland, ME 11/08 to 5/09

Data Integration Designer/XML Schema Designer

• Responsibilities:

• Designed and developed XML Canonical Data Model for the Enterprise.

• Created XML Schemas for Batch Process using FTP Protocol for consolidating data between legacy GSA database and new Oracle SORs and Web Services for B2B integration using HTTP/ HTTPS Protocols between Siebel application and ODS/DW SORs.

• Interacted with Business and created the XML Schemas for message based services including electronic payment processing, with credit cards.

• Validated Schemas and the WSDLs by the W3 standards and ensured their suitability for consuming into the SOA environment.

• Created XML test data and validated it with corresponding schemas.

• Environment: XML Schemas, XML Canonical Data Model, SOA, WSDL

• AT&T Mobility, Dallas, TX 5/08 to 10/08

Data Integration Designer/Contivo Analyst

• Responsibilities:

• Created the project related High Level Design document and Detail Design Document and uploaded them into SharePoint Server location for the corporate designers and developers

• Attended conference meetings for business requirements and Solution Approach documentations.

• Performed release level tasks of moving forward the existing Version Proxy Maps and upgraded the maps by running the script and changing the map titles to new version.

• Created process flow diagrams using TIBCO Business Studio for integrating the WalMart retail application SOR with the Device Activation and Billing servicing system SORs.

• Worked in a Service Oriented Architecture (SOA) environment and developed data mapping for business process using interfaces from multiple systems of records for consolidating the data by using the enterprise level Canonical Data Models.

• Maintained and updated Data model according to the naming standards and grouping by the functions.

• Created XML schemas, WSDL and validated using XMLSpy and created mapping for request/response schemas using HTTP Protocol, and generated corresponding java transforms using Contivo Analyst 3.11.2.1.6 and checked them Into CVS which is the version control server for storing the code files.

• Created TIBCO Business Process Models for business cases using TIBCO Business Studio and created XPDL files for deployment into TIBCO iProcess Engine Environment to provide the technical workflow solutions for business.

• Attended meetings and interacted with the business and IT team members for successfully implementing the Business Process Models into automated workflow solution.

• Created Interface Specification document for corporate developers.

• Created many new Web Services related entries in the preexisting WSDL file.

• Created business use cases for the testing team.

• Participated in interface impact sessions to identify affected data elements and systems.

• Participated in requirements sessions to study/analyze the interfaces impact.

• Environment: SharePoint, XSD schemas, WSDL, Contivo Analyst, TIBCO iProcess, CVS

• SprintNextel Communications, Reston, VA 7/07 to 4/08

Data Integration webMethods6.1

• Responsibilities:

• Worked in a Service Oriented Architecture SOA environment and developed data mapping for interface requirements with corporate standard Canonical Data Model for AMDOCS customer facing SOR to Subscriber Profile System (SPS) Servicing Systems SOR.

• Created DataPower XI 50 compliant services using Contivo Analyst and deployed and tested them on DataPower XI 50 Environment.

• Generated application design document for interface developers using DataPower XI 50.

• Maintained and updated Data model according to the naming standards and grouping by the functions.

• Created XSD schemas, WSDLs and validated using XMLSpy and MapForce and created mapping for request/response schemas using HTTP/REST Style Protocols, XSLT using Contivo Analyst 3.11.2.1.6.

• Participated in interface impact sessions to identify affected data elements and systems.

• Participated in requirements sessions to study/analyze the interfaces impact.

• Environment: SOA, XSD schemas, WSDLs, XMLSpy, MapForce, WebMethods 6.1, DataPower XI 50

• Wells Fargo Bank N.A. Des Moines, IA 1/07 to 6/07

Lead Webmethods Developer / Contivo Mapping Analyst

• Responsibilities:

• Worked with webMethods6.1 components in a middleware environment and created the flow services using the WebMethods Developer for integrating the canonical Service Information Model (SIMs) based business documents for mortgage industry with the back end Oracle9.0 database for EnterpriseOrigination (EO)SOR and front end Customer Facing store level application i.e. Store Portal.

• Tested the new created integration webMethods packages using the WebManager and Integration Server components and the sample XML files for the Mortgage industry.

• Configured and activated JDBC Adapter for DB2 database within webMethods environment for pulling out and updating the data based on the search criteria.

• Created the documents for data mapping and transformation work done between the SIM services XSD schemas and the database format documents.

• Supported Service Oriented Architecture (SOA) Solutions within the Wells Fargo Lending Business Technology platform, using Contivo3.10 Mapping Studio, Contivo Interface Modeler, Contivo EIM Server Repository & Semantic Dictionary, IBM Rational Clear Case Source Safe and Altova XMLSpy2007 applications and wfXML2.1 and MISMO2.3.1 Industry standard Documents for the Mortgage Industry.

• Assisted in SIM services data analysis and content data analysis tasks such as data mapping, gap analysis, mapping document conversion, XML Schema (XSD) updating, XML Schema conversion to Excel spreadsheet formats.

• Created Contivo Analyst based Maps, Concepts and Synonyms for the mortgage industry based services (MISMO Standard derived) for integrating the Arrow, Shaw, FDR and Fidelity Servicing Systems SORs with the origination System (EO) SOR and AOW to LIS SOR.

• Environment: WeMethods6.1, WebManager,DB2,IDOC, Contivo3.11.x Mapping Studio, Contivo Interface Modeler, Contivo EIM Server Repository & Semantic Dictionary, IBM Rational Clear Case Source Safe, Altova XMLSpy2007 applications and wfXML2.1

• Washington Area Metro Transit Authority, Washington, DC 3/06 to 12/06

WebMethods6.1 Production Support

• Responsibilities:

• Created the weMethods6.1 integration package in webMethods Developer for consolidating the VRS vendor registration system data with the PeopleSoft ERP central Information system.

• Resolved the defects in the existing integration code for integration between the web hosted Vendor RFQ submitting application and the PeopleSoft ERP. The web application was also a webMethods server and this was a B2B integration.

• Provided overall technical leadership for webMehods6.1 as a Lead webMethods Developer, in the development of new and support (including production support) of existing integrations. Also worked as a member of the development team serving as technical expert in flow services implementation and testing.

• Performed configuration management activities for the project including testing, component migration, staging plans, and sign off for component migration (Debug/Development to QA to production).

• Maintained expertise in the business systems and integration interactions. Completed estimates and impact analyses for business requirements.

• Participated in technical reviews with the systems integration Manager. Managed defects, issues, design changes, etc.

• Environment: Webmethods 6.1

• Avnet Inc, Phoenix, AZ 6/05 to 2/06

WebMethods6.1 Developer

• Responsibilities:

• Designed the Integration architecture for integrating and synchronizing the databases using the Canonical udms with OAG7.21 Open Application Group Integration Specification standard for publish/Subscribe technique with webMethods Brokers and RosettaNet_V02_02 XML based standard for transporting the business messages over the Internet using the Trading Networks6.1 components for B2B partner integration.

• Migrated the existing packages to new platform and Created New integration packages and Flow services in webMethods6.1 and enhanced the existing packages to meet the specific integration requirements between the Oracle9i ERP application and the legacy databases for Avnet Inc. Corporate Office and at other distributed locations.

• End to end testing for the packages using the PL/SQL for insert, update and delete commands on source database tables and verification for changes to corresponding target database tables was conducted. In this process, the logical mapping compliance and data definition documents guidelines were also confirmed.

• Environment: Webmethods, Trading Networks6.1 components, PL/SQL, IDOC

• Ethicon Endo Surgery Cincinnati, Ohio 12/04 to 4/05

• (Johnson & Johnson company),

WebMethods6.1 Developer

• Responsibilities:

• Developed new integration packages in webMethods6.1 and enhanced the existing packages to meet the specific integration requirements between the JDEdwards EnterpriseOne ERP application and the Common Data Location CDL Oracle database for consolidating the data at Ethicon Endo Surgery.

• Interface development was done by using the Wm Message Broker and publish/subscribe technique and by mapping to canonical document types.

• Performed end to end testing for the packages using the PL/SQL for insert, update and delete commands on source database tables and changes to corresponding target database tables was confirmed .In this process, the logical mapping compliance and data definition documents guidelines were also verified.

• Wm Document Tracker tool was used for the documents published through the Broker.

• Using the wMAdministrator the Integration Server and the Broker configurations were updated. The new packages were enabled and reloaded. The adapter services and Notification services were enabled. The JDBC connections to the databases were created. The xpi adapter for PeopleSoft EnterpriseOne was installed and enabled.

• The updated and new packages were published using wM Administrator in the Development Environment and migrated to Test, Acceptance and Production environments.

• The stress test and performance test was done for Integration server by using the large file sizes.

• Logging and error handling feature was tested for reporting errors and messages. The error log database was queried using the SQL statements and verified for expected loggings.

• Analyzed the Logical design documents and Technical requirements documents and created the corresponding physical design documents for the above integration initiatives.

• The new and updated packages were checked into PVCS for source control and maintaining the version.

• Environment: WebMethods6.1, JDEdwards EnterpriseOne, Oracle

• Cap Gemini Ernst & Young, Chicago, Illinois 9/04 to 11/04

Contivo Integration Specialist

• Responsibilities:

• Performed defect correction to Contivo maps and webMethods6.1 maps for business documents from the X12 4010, UNEDIFACT D98A, TranXML client based document standards to FEDEX owned ecommerce HUB standard (A xml based proprietary standard known as CommonView) And from CommonView To Order Management application known as Yantra And another application for Transportation Management known as gLog (A logistics management web hosted tool).

• Similar Maps updating was done using the webMethods Developer6.1 and Contivo3.8.4 MappingStudio environments for business documents originated from the Yantra OMS and gLog Logistics management applications which were using their own proprietary XML standards and sent to FEDEX ecommerce HUB and from the hub to client systems using the FTP and HTTPS communication protocols over the TCP/IP layers.

• Enhanced the Specifications defined for use with the FEDEX Ecommerce hub and corrected the sample data files.

• These specifications are mostly based on EDI X12 4010 standard and the UNEDIFACT D98A standard.

• Created business use cases.

End to End Testing of corrected maps was done by sending the sample files to weMethods6.1 Trading Networks using the XML file submitter and EDI file submitter forms and documentation was done for the updates and the new source files were stored into PVCS source code/version management systems.

• Worked with the Rational ClearQuest to track and resolve the defects reported by the functional and QA Team members.

• Created new Build Requests and maintained the version sequence for promoting the new webMethods packages to the TEST environment after the development was completed in the Dev environment with the updates for defect resolution.

• Used the EDIFECS SpecBuilder5.2 for standard references and its data Analyzer 5.2 for testing the data files for compliance to the standards guidelines and processes.

• Used SQLNav4 for accessing the database records for locating the webMethods

• Document Types

• And maps used in particular transactions in webMethods6.1 Trading Networks.

• Worked closely with the team members to assist in providing the problem resolution.

• Environment: WebMethods6.1, XML, EDI X12 4010, Contivo, Rational ClearQuest

• TradeRanger Inc., Houston, TX 9/02 to 4/04

Contivo Integration Analyst

• Responsibilities:

• Performed data mapping for business documents (PO, POR, INV, GR, ASN) between the three industry standards type.

• Developed and enhanced the Specifications to deploy amongst the three standards and developed, tested and deployed the XSDS for all abovementioned documents for these three standards.

• Created business use cases for tests.

• Performed testing and documented the new platform functionality for TradeRanger trading exchange using the WebMethods 4.6 and Contivo 3.5 tools including electronic payment processing, with credit cards.

• Created XQuery based validation configurations for business partners and document types within the webMethods B2B integration platform.

• Assisting new integrated business members with establishing and testing connectivity and Document transmission to and from the TradeRanger exchange.

• Worked with the Integration Engineering Team Lead to test and deliver new functionality within the trading platform.

• Provided integration assistance during testing with the business members according to the detailed project plan. Performed production support.

• Working with the business members to execute and review the results of integration testing efforts to ensure the integrity of the testing guidelines and processes.

• Worked with team members to provide problem resolution.

• Environment: WebMethods 4.6, Contivo 3.5 tools

• Contivo Inc., Mountain View, CA 11/00 to 4/02

Contivo Business Content, XML/XSD mapping Analyst

• Responsibilities:

• Development and customization of interfaces (business document formats) between the enterprise applications viz. SAP and Oracle Apps to the interface formats cXML, OAG, xCBL, CIDX, HIPPA, RosettaNet, EDI ANSI X12 4010, ACORD mappings for various interfaces and EDIFACT D98A documents.

• Definition of test data for the B2B transactions in procurement, requisition, payment and supplychain.

• Testing of interface definitions within the WebMethods B2B server and TIBCO Message Broker.

• Created maps using Contivo Analyst and Mercator tools.

• Testing of Contivo eService and Contivo Analyst.

• Creation of documentation and user guides

• Use Contivo Analyst tool created translation maps and business content in the company’s data repository for clients. The tool was also used to create data modeling objects.

• The Analyst would generate transform plugins for WebMethods and TIBCO publishing applications.

• Customer support for Hitachi America Ltd was provided for some duration by deploying WebMethods B2Bintegrator in conjunction with Contivo Analyst similar support was provided at Agilent Technologies facility with TIBCO Message Broker.

• Environment: WebMethods B2B server, TIBCO Message Broker, Contivo, cXML, IDOC, OAG, UNIX (use), xCBL, CIDX, RosettaNet

• Nestle USA, Glendale, CA 7/00 to 10/00

EDI / Mercator Consultant

• Responsibilities:

• Primary responsibilities included mapping business documents using Mercator translator tool and configuring SAP R/3 for EDI.

• Imported the IDO files from SAP to Mercator for creating the IDOC Type Tree using the Type Tree Importer Tool.

• The legacy system COBOL copybook files were imported within Mercator software for creating the COBOL copybook type tree.

• Mapped the IDOC to COBOL copybook and created mapping document using Mercator.

• Developed two new types in Copybook tree as per the desired outbound data layout for the Nestlé Solon plant and mapped the extended IDOC.

• Compilation and test runs for the map were conducted using the test scenario data files.

• Prepared mapped documents in consultation with the trading partner.

• Main IAC map was incorporated with the sub map for EDI data transmission.

• Many test scenarios were run for unit test and functional test using MQSeries.

• Provided technical support during the endtoend testing of passing the data successfully.

• Environment: Mercator translator, SAP R/3, EDI, IDOC, COBOL, IDOC

• Eli Lilly & Co 12/99 to 6/00

SAP EDI/Mercator Consultant, Java Developer

• Responsibilities:

• Mapped the IDOCs to X12 standards and created the mapping document using Mercator.

• Developed and implemented outbound 850 (PO) and inbound 855 (PO ACK) maps for translation of data between SAP IDOCs and ANSI X12. Mapped inbound 810 (invoice) to translate into SAP IDOC using Mercator

• Configured MM & SD modules for EDI in SAP R/3 system. Created ports in SAP system to interact with Mercator translator.

• Configured partner specific profiles, which include creating parameters for inbound and outbound IDOCs for different, message types.

• Studied legacy data structures, mapped that to SAP interface structures, used conversion of data from legacy to SAP for vendors and customers.

• Teamed up for creation of a JAVA based goods hiring system.

• Environment: SAP, EDI, IDOC, Mercator

• GroupOne, MD 10/99 to 11/99

EDI Consultant

• Responsibilities:

• Created/Configured Trading partner relationship/ profiles for generating inbound and outbound IDOCs. Created Port Definition/Profiles, TCP/IP configuration.

• Message type process codes, helped out in writing user exits for the respective functional modules to satisfy the standard IDOCs. Extended IDOCs (DESADV01 and ORDERS01).

• Supported in configuring the output types. Responsible for the installation configuration of Connect: direct system.

• Responsible for mapping the IDOCs to standard interfaces

• Configured various SAP EDI tables for setup of trading partners, Units of Measure, G/L posting.

• Environment: SAP, EDI, IDOCs

• Envoy Corp 8/98 to 5/99

SAP Consultant

• Responsibilities:

• Project Analyst for mission critical project to design and implement an electronic eligibility and dental enrollment system for participating client groups in national and state health/dental plans.

• New enrollments and updates sent via ANSI X12 EDI 834 transaction sets and worked with reviewing the data for ANSI X12 EDI 835,837,820,270/271, 276/277, 278.

• Also designed and implemented electronics dental claim submission and processing system for processing providers in National and State health/dental plans.

• Claims acknowledgement was sent using ANSI X12 EDI 855 transaction sets.

• Mercator was used as EDI translator tool.

• Environment: SAP, ANSI X12 EDI 834/855 transaction sets

EDUCATION

• Master of Engineering (Microwave Comm. Technology), India

• Bachelor of Engineering (Electronics and Telecom), India

CERTIFICATIONS & TRAINING

• WebMethods B2B Developer

• Contivo Integration Analyst Developer

• SAP BW3.5/BI7.0 Reporting

• SAP MM/SD Functional

Contact this candidate