SUMMARY

• Over 9+ years experience in the design, development, and 24x7 production support of Data integration, B2B Integration, EDI, and XML Applications including analysis of business requirements, systems analysis, design, development, production support, testing, implementation, and documentation.
• Experience in XML Mapping, Business Process Development (BPML), XSLT, XPath. Excellent knowledge of using AS2, FTP and SFTP, Perl Scripts and VAN such as Sterling/INOVIS. Excellent knowledge on Sterling File Gateway (SFG). Good Exposure to work with SAP IDOCs
• B2B Integration using Sterling Integrator 5.1/5.2, Gentran Integration Suite (GIS) 3.0, 3.1, 4.0, 4.1, 4.2, Gentran Server 5.1, 6.0.
• EDI - More than 6 years of experience implementing EDI solutions using SAP R/3 IDOCs, ALE, Gentran Server in IT, Retail, Logistics, Financial and Healthcare Industries for various application areas including sales and billing
• Involved in Mapping of EDI ANSI X12 transactions 270, 271, 276, 277, 300, 301, 315, 304, 310, 810, 820, 835,846, 850, 855, 856, 860, 865,875,880,888 997, 940,943,944 and 945.
• Extensive experience in developing transaction sets in EDI and data mapping and data conversion across like Healthcare, Banking, Logistics, Distribution, Finance, Material management applications.
• Expertises in EDI X12 HIPAA transactions 837, 835, 270/271, 276/277, etc.
• Worked as a Mapper on various X12 and EDIFACT based transaction sets including 850,880,875,846,856,860,837,835,810,865,867,940,943,944,945,888 and 852.Excellent mapping skill set. Handled complicated looping in GIS/SI map editor.
• Possess development and implementation experience in EDI ANSI X12, HIPAA, VICS, UCC, EDIFACT, XML, Sterling Integrator, Sterling’s Gentran Server on UNIX, Gentran Integration Suite (GIS), GXS Application Integrator Workbench, GXS Enterprise Gateway & XML/XSLT applications.
• EDI Tools & Engines - GIS Map Editor, Visual Mapper, Application Integrator
• Nature of Expertise in Gentran: Mapping, translation, Trading Partner setup and maintenance, Server Scripting, Data Managers.
• Automating data loading, extraction, mapping, conversion, reports generation using SQL, PL/SQL & UNIX Shell scripting.
• Experience in creating Inbound and Outbound mapping and Business Process using Graphics Process Modeler and BPML ( Business Process Model language ) for EDI, ANSI X12, EDIFACT and HIPPA Standards.
• Experience in creating inbound and Outbound Web Services API/REST Business Process
• Experience in preparing Test cases, Test plans and executing Gap Analysis.
• Extensive Experience in SQL/PL SQL, Stored Procedures and Triggers.
• Extensive Experience in preparing Test Plans, Test Scenarios, Test Cases and executing them based on the Business rules and System requirements.
• Worked on XML Schema, DTD using XMLSPY. Design & development using Java, Oracle, JavaScript, XML, HTML, UML & Rational Rose
• Strong leadership, interpersonal, analytical and communication skills.
• Excellent ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS

EDI Mapping: Sterling Integrator 5.0/5.2, Gentran 5.1/5.3/6.0/GIS, Sybase EC Map, GXS AI Mapper/Workbench, GXS Enterprise Gateway, TLE Server 4.2, Cyclone, Connect: Direct.

Transaction sets: X12 - 835,837,270,271,276,277,278,204,210,214,410,834,810,820, 830,832,850,846,855,856,857,862,867,879,875,880,888,944,945,940,846,943,947 and 997

Application Server: Gentran 5.2,5.3,6.1, Sterling Integrator 5.0/5.1 (GIS 4.2/4/3)

Programming Languages: SQL, PL/SQL, C, Java, Cobol, Unix Shell Scripts (Korn/Bash), XSLT

Web Technologies: XML, HTML, XSLT, Web services

Testing Tools: QTP 9.2, Quality Center 9.0/10.0, Win Runner 7.5, Load Runner 7.8, Rational Clear Quest, Claredi

RDBMS: Oracle 8i/9i/10g, MS SQL Server 2000/2005, DB2, MySQL, Toad

Development Tools: Ab initio, Cognos Report net

Operating Systems: Windows 2007/ 2003/2000/ NT, MVS, UNIX, LINUX

Packages: MS Office, CVS, PVCS, adobe master collection

Comm Protocols: FTP, HTTP, SFTP, SMTP, Light weight JDBC, TCP/IP,VAN, PGP, PKI

Other Tools: PUTTY, WS FTP, UltraEdit, Telnet, control - M, EDIFECS Tools, and BMC Remedy tool, DB Visualizer, AES Routing tool.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Sr.EDI/Sterling Integrator Developer/Analyst

Responsibilities:

• Created maps for different transaction with different file formats XML, X12, CSV and Flat files.
• Design and Development EDI and Non EDI maps and Automated Business Processes.
• Created Code lists for various code conversions.
• Developed and updated 810,830,850,855,856,860,862,875,880, and 997 using the X12 standard and flat files Inbound and Outbound Transactions.
• Working with the Business teams for SIT and UAT testing
• Created Business Process to monitor mailboxes and generate alert notifications.
• Created New Business Process for Inbound and Outbound process.
• Worked on routing rules for mailboxes, Boot strapped Business process to read batch files, translate, and route them to internal systems.
• Created maps to translate data from X12,csv format to SQL format and SQL format to Flat File format for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers
• Created maps to translate data from X12 format to IDOC positional format for Inbound Orders, Developed from Scratch level with complicated mapping rules with Database code lists.
• Performed logical mapping changes for Retail transaction sets to-and from Orders, Material Master and Shipments. Created and modified maps in SI mapper
• Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
• Created new maps and envelopes for syncrofy data monitoring web portal based on the Business requirement.
• Developed Maps to and from trading partners to Internal Order Management applications (IDOC’s and SQL) in supporting Delivery Order, Goods Receipt, and ASN etc.
• Configured Data source for SQL/PLSQL data mapping.
• Configured Database ODBC connections for SQL data mapping.
• Developed Data Transfer Business process for loading the input data into Database table.
• Developed LWJDBC SQL Generic Adapter for data Extraction from SQL format to xml format.
• Developed Generic File System Adapter for Input Data file Collection and Output Data file Extraction.
• Developed on fault Business process for Error handling and for email notification.
• Implemented new xpath codes for retrieving data from the processdata.
• Created Database Tables and Database tables configured DB Table to Sterling Integrator map editor for SQL mapping.
• Created new properties files and deployed into SI NFS folders.
• Developed xpath to import property file information to Business process through scientific get method.
• Developed SQL and PL/SQL queries for map translation and Import data from Database tables.
• Developed PL/SQL scripts for data extraction and automation of SQL*Loader scripts.
• Wrote PL/SQL cursor processing routines, stored procedures and database triggers.
• Wrote complex SQL Scripts to develop transaction visibility across multiple downstream applications.
• Created Flat File to XML and XML to Flat file also Flat file to Flat file envelopes.
• Onboarding new trading partner setup.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Developed Business Process new BP’s from Scratch and modified/changes in existing Business process.
• Created new mailboxes and enhanced existing business process to add new mailboxes for syncrofy Transactions monitoring web portal.
• Developed new API REST Web Services for both directions Inbound and Outbound.
• Developed and Configured Java Scripts in Sterling Integrator services for JSON to xml conversion and XML to JSON conversion.
• Developed new API SOAP web services for both Inbound and Outbound directions.
• Configured AS2 connections, Templates, Channels and testing.
• Created new Actions and Setups for Inbound and Outbound file transfers with java scripts.
• Scheduled Business process in B2Bi.
• Created mailbox routing rules for Business process execution.
• Created Routing rule execution Business process using with Routing rule Evaluation service.
• Working with Tivoli Job schedules team for scheduling the jobs.
• Troubleshoot and resolved XSLT mapping issues and adapter failures/discards.
• Created new XSLTs for email notification body and message.
• Updated and enhanced existing On-fault services.
• Experience in Troubleshooting of EDI ANSI X12 and other format data issues.
• Involved in writing test cases for the EDI maps and tested using HPQC.
• Involved in various activities present in project life cycle such as Field usage Analysis, FD walk-through, Map group analysis, Map specification preparation, Map build, Unit testing, AT,FAT, Co-ordination with Business teams about defects fixing.
• Created and maintained all test cases in HP Quality center (HPQC).
• Develop and Execute the Test Cases for Functional, Integration and regression testing.
• Prepared Documentation, all activities involved in this project design and Implementation process.

Environment: Sterling Integrator 5.2.4, 6.0.2.0, Secure Transport, Oracle 11g SQL/PL SQL, EDISIM, VL Trader (Cleo Harmony 5.2), Sterling File Gateway(SFG), FileZilla, Dimensions, Ultra edit, Notepad++, Beyond Compare, Microsoft Visio, Windows7, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, AS400, GXS AI & Enterprise

Confidential

Sr.EDI Developer/Analyst

Responsibilities:

• Created maps for different transaction with different file formats XML, SPEC200, EDIFACT, X12, Flat file.
• Design and Development EDI and Non EDI maps and Automated Business Processes.
• Created Code lists for various code conversions.
• Working with the Business teams for UAT testing.
• Developed and upgraded EDI and database maps for transactions 810, 830, 850, 852, 270,2 71, 855,8 56, 862,875, 880, 944, 945, 846, 870, 888, 940, 943, and 857 using the X12 standard and flat files Inbound and Outbound Transactions.
• Created Business Process to monitor mailboxes and generate alert notifications.
• Created New Business Process for Inbound and Outbound process.
• Worked on routing rules for mailboxes, Boot strapped Business process to read batch files, translate, and route them to internal systems.
• Created maps to translate data from X12,csv format to SQL format and SQL format to Flat File format for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers
• Created maps to translate data from XML format to IDOC positional format for Inbound Orders, Developed from Scratch level with complicated mapping rules with Database code lists.
• Created maps to translate data from X.12 format to SAP IDOC and SAP IDOCS to X12 formats for Orders, Order confirmations, ASN’s, Inventory snapshots, Shipment status and Inventory Transfers.
• Performed logical mapping changes for Retail and Logistics transaction sets to-and from Orders, Material Master and Shipments. Created and modified maps in SI mapper
• Created IDOC Extension for Orders05 for Outbound.
• Worked on various kinds of SAP IDOCS ORDERS, INVOIC, MATMAS, DELVRY, DESADV etc.
• Working and Experience in 3PL (Third Party Logistics) projects.
• Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
• Developed Maps to and from trading partners to Internal Order Management applications (SAP IDOC’s and SQL) in supporting Delivery Order, Goods Receipt, and ASN etc.
• Configured Data source for SQL/PLSQL data mapping.
• Configured Database ODBC connections for SQL data mapping.
• Developed Data Transfer Business process for loading the input data into Database table.
• Developed LWJDBC SQL Generic Adapter for data Extraction from SQL format to xml format.
• Developed Generic File System Adapter for Input Data file Collection and Output Data file Extraction.
• Developed on fault Business process for Error handling and for email notification.
• Implemented new xpath codes for retrieving data from the processdata.
• Created Database Tables and Database tables configured DB Table to Sterling Integrator map editor for SQL mapping.
• Developed SQL and PL SQL queries for map translation and Import data from Database tables.
• Developed PL/SQL scripts for data extraction and automation of SQL*Loader scripts.
• Wrote PL/SQL cursor processing routines, stored procedures and database triggers.
• Wrote complex SQL Scripts to develop transaction visibility across multiple downstream applications.
• Experience in Configuring the Ports, partner profiles, RFC Destination in SAP.
• Created Flat File to XML and XML to Flat file also Flat file to Flat file envelopes.
• Onboarding new trading partner setup.
• Created Adapter utilities SAP Route-XREF channels Inbound and Outbound.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Developed Business Process new BP’s from Scratch and modified/changes in existing Business process.
• Developed new API REST Web Services for both directions Inbound and Outbound.
• Developed and Configured Java Scripts in Sterling Integrator services for JSON to xml conversion and XML to JSON conversion.
• Configured AS2 connections, Templates, Channels and testing.
• Configured Cleo Harmony Actions for managed file transfer.
• Created new Actions and Setups for Inbound and Outbound file transfers with java scripts.
• Scheduled Business process in B2Bi.
• Working with Tivoli Job schedules team for scheduling the jobs.
• Troubleshoot and resolved XSLT mapping issues and adapter failures/discards.
• Experience in Troubleshooting of IDoc Errors.
• Involved in writing test cases for the EDI maps and tested using Quality Center.
• Involved in various activities present in project life cycle such as Field usage Analysis, FD walk-through, Map group analysis, Map specification preparation, Map build, Unit testing, AT,FAT, Co-ordination with Business teams about defects fixing.
• Created and maintained all test cases in HP Quality center (HPQC).
• Develop and Execute the Test Cases for Functional, Integration and regression testing.
• Prepared Documentation, all activities involved in this project design and Implementation process.

Environment: Sterling Integrator 5.2.4, Secure Transport, Oracle 11g SQL/PL SQL, EDISIM, VL Trader (Cleo Harmony 5.2), Sterling File Gateway(SFG), FileZilla, Dimensions, Ultra edit, Notepad++, Beyond Compare, Microsoft Visio, Windows7, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, SAP IDOCS, AS400, GXS AI & Enterprise

Confidential, Buffalo Grove, IL

Sr.EDI Developer/Analyst

Responsibilities:

• Responsible for development and implementation of HIPAA 834, 835, 836 and 837 Transactions.
• Worked with various data formats like XML, SQL, Positional, Flat files, Delimited and EDI/X12
• Responsible for creating logical and physical maps inbound and outbound.
• Designed, Developed and Maintained EDI Maps with the specified business rules. HIPAA map transactions:837 v4010/5010 Health Care Claim 835 v4010/5010 Health Care Claim Payment Advise
• Created Code lists for various code conversions.
• Created Standard file layouts by using the Cobol Copy Books.
• Responsible for developing maps that checks for valid partners as preliminary check and separates the valid and invalid EDI documents
• Responsible for analyzing, implementing, testing, monitoring the changes and moving to Production support.
• Expertise in setting up migration mapping from older versions to newer versions.
• Involved in support, problem solving, data correction and map changing based upon requirements.
• Performed logical mapping changes for 834 and 835 transaction sets to-and-from claims and billing applications. Created and modified maps in SI map editor.
• Responsible for staging of EDI systems in Development, Testing and Production.
• Testing the EDI files for all EDI syntax errors.
• Developed the test scripts and test data for unit testing, system testing and integration testing
• Responsible for HIPAA Compliance & Testing of HIPAA 834, 835, 836 and 837 Transaction.
• Created test plans for all maps and coordinated with QA Team on any defects.
• Involved in Analysis, design, development and documentation of interfaces.
• Participated in designing application file layouts and EDI layouts for 837 and 835.
• Develop the test scripts and test data for unit testing, system testing and integration testing.
• Performed End to End testing in SFG to confirm the files are making through the end to end process
• Worked on CVS Caremark internal process like COLA for library names and Dimensions for document packaging and push for production.
• Experienced with AXWAY B2B environment and understanding AXWAY protocols FTP, SFTP, AS2, HTTP, HTTPs, and SMTP.
• Provided Axway mapping documents for File Transfer.
• Worked with Managed File Transfer (MFT) and Axway team and Integration teams to document Source to Target mapping and EDI Mapping.
• Involved 4010/5010 Trading partner set up, trading partner implementation process and maintenance for all trading partners, working with the ANSI X12 EDI standards, and interfacing EDI with internal business applications
• Set up Trading Partner relationship in the Production, Testing, and Development environments.
• Involved in the volume testing for SI Upgrade project form v5.2.4 to v5.2.5
• Used my file gateway and Sterling file gateway for test file upload and retrieve output results in SI upgrade volume testing.
• Developed and Implemented Perl scripts for SFTP Migration in Workhorse.
• Updated PROCID’s from ws ftp to psftp in Test Environment and ran the test files.
• Successfully test completed procid’s updated into the Production related files (data. base. Check, database.pdmtoql.csv, data.base.eligibility.csv etc.).
• Reviewed updated script with current production file, finalized for production move, and moved to production with the help of file Transfer tool IPSWITCH or FileZilla.
• Changed different Transmit sites scripts in workhorse from ws ftp to psftp such as MVS (mainframe related files), DALCDCP, Secure Transport, SI GIS 834 PROD, DMZ02 etc.
• As per requirements created new procid’s and clone procid’s for different, transmit sites.
• Created new procid’s in Internal SFTP migration project and external migration project.
• Involved in Analysis, design, development and documentation of interfaces of SFTP Migration project.
• Participated in Single thread files script changes and also changed scripts from ws ftp to movetoweb
• Developed Perl Scripts for changes of PROCID’s from ws ftp to movetoweb.
• Used Cola for required information gathering for migration process.
• Supporting production issues during the warranty period.
• Complete coordination with the team on day-day operations and ongoing projects.
• Involving in SI Security Compliance project.

Environment: Workhorse, Sterling Integrator 5.2.5,Secure Transport, Ultra edit, Notepad++,Microsoft Visio, Windows7, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, SAP IDOCS, MS SQL Server (SQL, T-SQL, SSIS),EDISIM, Sterling File Gateway(SFG), IPSWITCH,Remote Desktop, FileZilla, AS400,GXS AI & Enterprise.