SUMMARY

• Over Seven Years of Experience in analysis, design, development, testing and maintenance of Sterling Gentran EDI Applications.
• Extensive experience in various Business Domains such as Retail, Logistics, Manufacturing, Distribution & Healthcare.
• Expertise in B2B standards, implementation of Integrated EDI applications and Enterprise Application Integration (EAI) for business processes across applications.
• Extensive experience in Business Analysis to Translate EDI Requirements into Functional Specifications and Develop Logical Mapping for Gentran/GIS - SAP/Mainframe/XML.
• Experience in Design, Development and Implementation of Integrated SAP EDI, BAAN EDI, XML EDI applications.
• Expertise in designing data definition structures, developing maps and its components for B2B integration using Gentran Server 6.0 and GIS 4.3 and Sterling Integrator 5.2.
• Expertise in complete EDI process cycle that includes Gap Analysis, extensive mapping experience using AI Mapper/Gentran Map Editor, and translation using XSLTs
• Experienced in design and development of Business Processes for B2B integration using BPML and GPM (Graphical process modeler).
• Experienced in HIPAA, Health Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing..
• Expertise in XML, XPATH, XML Schema, XSLT, DOS Programming and UNIX Shell Scripting.
• Expertise in IBM Websphere MQ, and integration of MQ to Sterling Integrator for real time processing.
• Experience in design, development of internet/intranet sites using, J2EE, JavaScript, HTML. Good knowledge of RDBMS (Oracle 8i/9i/10g, MS SQL Server 2005).
• Experience in Automating data loading, extraction, mapping, conversion, reports generation using SQL, PL/SQL, and UNIX Shell scripting.
• Expertise in Database Management, Data Analysis, System Integration, Quality Management System, and Project Migration.

TECHNICAL SKILLS

EDI Standards: EDI X12(ANSI), EDIFACT, HIPAA, NCPDP, HL-7, Rosetta Net, X12 Transaction sets

Healthcare: 834, 835,837,270,271,276,277, 278

Retail & Mfg: 810, 812, 820, 824, 830, 832, 834, 837, 845, 846, 850, 852, 855, 856, 857, 860, 861, 865, 875, 879, 880, 997

Logistics: 110, 180, 204, 210, 211, 214, 301, 310, 601, 753, 754, 856, 940, 945, 990

Operating Systems: Linux, UNIX, Windows NT/XP, 2003 Server

Databases: Oracle, SQL Server, DB2, MS Access

Languages: Java, Spring, Hibernate, PL/SQL, COBOL, UNIX Shell Script, JCL, C++

Web Technologies: ASP, JSP, HTML, XML, XSLT, Java, JDBC, ODBC

Application Servers: Gentran Server 5.1/5.3/6.0/6.1 , GIS 4.3, Sterling Integrator 5.2, EC Work Bench 5.1, EC Gateway, Mercator, WTX

Quality Control: Remedy, HP Quality Control, Nagios

PM Methodologies: Agile (Kanban/Scrum), Six Sigma, Waterfall

MFT: Sterling File Gateway (SFG), IBM Sterling Secure Proxy (SSP), Sterling Connect Direct (C D) for platforms Windows/UNIX

PROFESSIONAL EXPERIENCE

Confidential, Naugatuck, CT

EDI Integration Analyst

Responsibilities:

• Create EDI maps to exchange data with suppliers and vendors (purchase order, ship notice, invoice, remittance advice, credit claim, etc.)
• Configure trading partner interconnects for exchanging files (AS2, VAN, FTP, etc.)
• Continuously monitor and troubleshoot performance of EDI translator, partner file exchange, Oracle jobs, SQL servers, and file servers
• Create SQL queries for extracting and importing data, and reporting transaction status and errors
• Create DOS and Linux scripts for automation of manual tasks
• Worked extensively on Stylus Studio and developed more than 1000 interfaces.
• Analyzing XSD and changing with respect to the customer specification.
• Using of different adaptors in CVS for the different formats in inputs.
• Specifying different LPARS for new and old interfaces
• Extensively worked on different EDI formats and converting them into different formats.
• Responsible for analyzing, designing, implementing, testing, and maintaining EDI processes and connectivity in different environment of Sterling Integrator
• Establish CVS Adapters for different instances and testing connections for connectivity.
• Dealing with the Customer regarding the requirement and change requests.
• Created XML transformation scripts using XSLT for mapping, formatting, and validation routines.
• Worked on server side CVS for deploying in test as well as production.
• Used LINUX for interacting between local and severe side changes.
• Used Etrack as the monitoring tool for observing outputs and communications.
• Developed new maps for X12 transactions like 110,315,310,810,110, 820, 830, 850, 855, 856, 860, & 862.
• Created Mailbox’s, Routing Rules, and User Permissions for different SAP Groups.
• Configured Envelopes and Framework setups for the Inbound and Outbound maps.
• Updated/customized the existing Business Processes and XSLTs to achieve high performance requirements.
• Testing the Maps and Process Flow for implementation.
• Monitoring of system health, including disk space and failed processes, checking system level errors, Translation error logs etc.
• Documented the Business Processes and developed Visio diagrams for support purposes.

Environment: IBROCKER, Sterling Integrator, XML, XSLT, SAP, IBM MQ, and SIMON Framework.

Confidential, Plano, TX

EDI Developer

Responsibilities:

• Interviewed users to review and generate business requirements, functional and technical specifications, test plans, test cases and consolidated project plans.
• Responsible for analyzing, designing, implementing, testing, and maintaining EDI processes and relationships in the environment.
• Created new maps based on the customer’s requirements on the AI and VI Mapper and setting up the trading partnership and configuring the data managers.
• Created maps for transactions like 810, 820, 830, 832, 846, 850, 855, 856, 860, 875, 880, 940, 944, 945 and 947.
• Created Application and Implementation Guides for all transactions and trading partners.
• Setting up the SAP Routes and Configuring the RFC connections in SAP and testing each connection for connectivity.
• Configuring the SAP Adapter in GIS and updating SAP route changes in Gentran 6.0.
• Configuring the Gentran EC Workbench for Trading Partner Melding process for the Inbound and Outbound flow of data.
• Testing the maps and the melding flow configuration.
• Setting up the Business Process and configuring the BPML’s.
• Triggering IDoc’s using SAP Transactions and testing the flow form SAP to Gentran and then to VAN.
• Checking the Sterling Van if the files are being sent and received.
• Configured the SFTP and FTP using Routing Solutions and Sterling Integrator
• Generating IDoc’s for testing, processing and debugging errors in the EDI X12.
• Setting up the Generic synonym tables as per the Business requirement.
• Cobol programming and running Cobol batch system.
• Tweaking existing old maps as per customer requirements and doing a version upgrade as per the customer requirement.
• Maintaining partner profiles in SAP as per the customer requirements.
• Setting up connections in GSX and testing with partner for data connectivity.
• Moving test files, Maps, Apps in UNIX form Dev to QA and QA to Prod server.
• Transferring files through FTP to customer for Data verification.
• PGP encrypting for data encryption. EC Mapper and EC Gateway for some specific partners.

Environment: Gentran Server, Sterling Integrator, EC Work Bench 6.0, XML, XSLT, SAP ALE/EDI.

Confidential, Pittsburgh, PA

EDI Analyst

Responsibilities:

• Responsible for analyzing, designing, implementing, testing, and maintaining all EDI processes and relationships in the environment.
• Creating business processes using BPML as per the customer requirements.
• Created maps for transactions like 180, 278, 812, 824, 834, 937, 844, 845, 846, 849, 850, 852, 856, 864, 867, 940, 943, 944, 945 and HIPPA transactions 270, 271, 834, 835, and 837
• Created Application and Implementation Guides for all transactions and trading partners.
• Configuring the Gentran EC Workbench for Trading Partner Melding process for the Inbound and Outbound flow of data.
• Testing the maps and the melding flow configuration.
• Setting up the Business Process and configuring the BPML’s.
• Triggering IDoc’s using SAP Transactions and testing the flow form SAP to Gentran and then to VAN.
• Processing the CARS transaction documents both inbound and outbound.
• Checking the Sterling Van if the files are being sent and received.
• Value Centric processing in order management and processing, Inventory tracking, Product transfers, Chargeback’s and returns.
• Generating IDoc’s for testing, Processing and debugging errors in the EDI X12.
• Setting up the Generic synonym tables as per the Business requirement.
• Set up new trading partners from the Berlex system to the Confidential system and maintain existing partners.
• Tweaking existing old maps as per customer requirements and doing a version upgrade as per the customer requirement.
• Maintaining partner profiles in SAP as per the customer requirements.
• Moving test files, Maps, Apps in UNIX form Dev to QA and QA to Prod server.
• Transferring files through FTP to customer for Data verification.

Environment: Gentran Server, XML, XSLT, SAP ALE/EDI.

Confidential

EDI Developer

Responsibilities:

• Created ASN (Advance Shipping Notice EDI X12 856) which comes in ANSI X12 format from trading partners.
• Created 940 (Warehouse ASN) from the scratch.
• Created IG’s & Applications Based on the customer requirements.
• Translating the data from ANSI X12 to text format in inbound process using the translator.
• Created maps for Application to Application
• Sending an Acknowledgment (EDI X12 997 Functional Acknowledgment) to the trading partners.
• Created new synonym table based on the customer requirements.
• Translated the data from text to ANSI X12 Format.
• Receiving an Acknowledgment (EDI X12 997 Functional Acknowledgment) from the trading partner.
• Creation of implementation guides to document detailed exchange requirements such as structures, timing and business rules (GAP analysis documents.)
• Set up new trading partners and maintain existing partners
• Involved in up gradation of Gentran server 3.2 to Gentran server 5.1
• Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
• Developed and upgraded EDI maps for transactions 810, 830, 850, 852, 855, 856 and 857 using the X12 standard.
• UNIX script writing for both communicational and file handling
• Maintenance of EDI Documents, data managers, and Gentran life cycle Database.
• Cobol programming and running batch systems.
• Creation of trading partner files/interfaces.
• Solving mapping issues with the Mercator.
• Developing new maps and modifying existing maps.
• Creation of ODBC mapping guidelines.
• Developed maps for following transaction sets: 810, 820, 830, 832, 850, 852, 855, 856, 857, 864, 867, 875, 879, 880, 940, and 997.

Environment: Gentran Server, XML, XSLT, Oracle 10g, (SQL, PL/SQL), UNIX.