SUMMARY:

• Around 7+years of experience in the design, development, integration, B2B Integration, EDI, XML applications including analysis of business requirements, system analysis, design, development, production support, testing, implementation and documentation.
• Experience in E - Commerce, Retail, HealthCare, Insurance and Automotive sectors.
• Demonstrated proficiency in EDI ANSI X12, HIPAA, EDIFACT, VICS, TRADACOM standards.
• Strong working experience with transactions 810, 850, 855, 856, 824, 860, 861, 865, 832, 837, 835, 834, 270, 271, 940, 943, 944, 945, 997, 999, 210, 213 and 214.
• Experience working on different file formats like ANSI X12, XML, CSV, SAP IDOC, Positional and other client proprietary formats.
• Implemented different Communication protocols like IBM VAN, FTP, SFTP, HTTP, HTTPS AS1, AS2.
• Hands on experience working on EDI based Middleware tools like Sterling Integrator, Sterling Gentran Integration Suite (GIS), Gentran, EDIFECS Spec builder, Transaction Manager Sterling file gateway, Sterling Control Center, XEngine, GXS, BizTalk, BizManager.
• Hands on expertise in using various Mercator adaptors (File, Schema, XML, Database, Email, FTP etc.).
• Experience in creating maps using Gentran Server on UNIX and Windows configuring & interacting with trading partners in laying standard specifications for various transactions for both Inbound & Outbound Mapping using EDI / HIPAA ANSI X12 standards.
• Excellent Knowledge of HIPAA 4010,5010 Standards, and HIPAA code sets like ICD-9, ICD-10 CODING and HL7.
• Creating maps for converting from X12 to Application, Application to X12, Application to Application, X12 to XML, Positional, Oracle ERP files, SAP IDOC, FLAT Files, Database Formats.
• Involved in creation of Mailbox, Virtual roots, Communication setups and development of business process in Sterling Integrator and Monitoring System level errors and maintained EDI support mailbox for FTP/AS2/VAN failures, incomplete files alerts and investigated FTP/AS2/VAN transmission failures and retransmitted files.
• Very good experience in creating Business Processes in BPML and GPM using various services and adapters which includes web sphere MQ, File System, ODBC, JDBC.
• Experience in interacting directly with Trading partners/Business user and back end teams to analyze the business process and transforming requirements into detail designed documents and mapping specifications.
• Highly experience in handling EDI production support and interacted with clients to resolve production issues.
• Worked closely with different legacy systems like Oracle EBS, SAP for issues resolving PO/Shipping orders.
• Hands on experience writing SQL Queries, Stored procedures, Functions, Triggers in database.
• Hands on experience in loading data from flat files using external tables.
• Good knowledge of RDBMS like Oracle database, SQL Server, DB2 etc.
• Good understanding of UNIX commands, Shell Scripting and PGP Encryption.
• Ability to do independently as well as in a team and experience in coordinating with different groups in a project.
• Develop, implement, and maintain Customer and Supplier EDI/XML trading partner implementations from translator/mapping to ERP setup and configuration. Ability to define specific application related data issues versus mapping issues and provide the necessary resolution.
• Ability to communicate with the Trading Partner and implement Trading Partner Certification for all inbound and outbound transaction types
• Excellent testing, troubleshooting and reprocessing skills.
• Expert in working with various UNIX flavors like Solaris, AIX and HP-UX with Strong Shell Scripting.
• Implemented the HIPAA EDI solution for the Healthcare clients and in-depth knowledge of health care including Medicare/Medicaid, HIPAA, EDI transactions.
• Excellent Written & verbal Communication, Interpersonal and Organizational Skills.

TECHNICAL SKILLS:

EDI Tools: Sterling Integrator 5.0/5.2/5.3, Gentran 6.0 (UNIX), GIS 4.2/4.3, BizTalk, Mapping Editor 4.1, Sybase EC Map, EC Gateway, Sterling File Gateway, XEngine, EDIFECS spec builder 8.0

Industry Standards: ANSI X12, EDIFACT, HIPAA, VICS, TRADACOMS.

Networking Tools: AS1, FTP, HTTP/S, AS2, VAN

EDI Transactions: 210,214,220,270,271,276,277,278,810,812,820, 824, 830, 832,835,837, 846, 850, 852, 855, 856, 860, 865, 869, 870, 875, 880, 879, 888, 889, 940, 943, 944, 945, 947, 997, INVOIC, ORDERS, CONTR and ORDRSP, FINTSA, PAYMUL, CREMUL.

Languages: C, C++, Unix Shell Scripting, AS/400, SQL, Oracle PL/SQL, BPML, XSLT

Web Tools: HML, MS Front Page, Dream Weaver, Web logic, Web sphere

Databases: Oracle 12c/11g/10g/9i, SQL Server 2000/2008, DB2

ERP: SAP 4.6 &SAP ECC 6.0

SQL Editors: SQL Plus, TOAD, SQL developer

Reporting Tools: Crystal Reports, Data Reports, SQL server Reporting Services (SSRS)

Operating Systems: Windows, Sun Solaris, AIX, Unix

Other Software: XML, DTD, XSD, XSLT, XMLSPY, Clear Case, ULTRAEDIT, SMART DB, CLEAR QUEST, Remedy Ticketing, WS-FTP, Oracle E-Business Suite (EBS), MS Word, Visio, Project, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Virginia Beach, VA

EDI Specialist/B2B Analyst

Responsibilities:

• Involved in setting up of Trading Partners Envelopes for multiple transactions in Sterling Integrator.
• Implemented and troubleshooting of B2B connectivity for integrations using IBM sterling B2B integrator.
• Developed and modified maps using Sterling Integrator’s Map editor.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Created inbound maps to translate from EDI ANSI X12 format into Database tables and flat files.
• Set up various communications using Protocols FTP, HTTP, SMTP and AS2 with trading partners.
• Involved in map development, testing and implementation for HIPAA Transactions sets like (837, 270/271, 276/277, 834, 835, 278 and 997). in Sterling Integrator 5.2/GIS 4.2(Application Integration mapper, Map editor)
• Worked with Edifecs Specbuilder to create test files, analyzed all EDI test files with 5010 implementation guides and gap analysis of EDI transactions.
• Migrated maps, business processes, services, envelopes from GIS 4.3 to Sterling Integrator 5.2.3.
• Involved in support, problem solving, data correction and map changing based upon requirements.
• Set up and configured the AS2 communication protocol for exchanging the EDI documents for trading partners with digital signature.
• Responsible for staging of EDI systems in Development, Testing and Production.
• Worked with Sterling Commerce GIS (Gentran Integration Suite), BPML and the GIS BP Modeler, DB connectivity JDBC.
• Created business process for both inbound and outbound transactions to Oracle EBS and other internal applications as per business needs using Graphical Process Modeler (GPM) and BPML in Gentran Integration Suite/Sterling Integrator.
• Developed different maps to convert from ANSI X12 to .CSV, XML, Oracle, Flat files and vice versa.
• Developed and maintained Structured Query Language (SQL) tables using Open Database Connectivity (ODBC)connections to third party custom databases managing secure and accurate data transfer between multiple systems.
• Configured ODBC Adaptor to pull data from database and vice versa. Created Code lists for various code conversions.
• Involved in full-life cycle software development for mid-size to complex projects by performing requirement analysis & testing.
• Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc.
• Creation of transformation profiles based on trading partners.
• Created outbound transactions from application file to EDI using Map Editor.
• Performed Gap Analysis to determine how the data will move from input side of the map to the output side of the map.
• Deploying the maps to Dev & Stage environment’s and coordinating in promoting to production.
• Involved in communicating with trading partners and added new trading partner setup to the workflow.
• Responsible for Creating and Managing the Import and Export MAPs using Application Integrator/Map Editor.
• Assist with upgrading transaction to the most current EDI version as well as managing testing activities with trading partners.
• Worked on improving the performance (Performance tuning) of old maps which are taking longer duration for execution.
• Reviewing the maps, documents and testing (Including the test cases and test results) done by other team members.

Environment: Sterling B2B integrator 5.2.3, Edifecs Spec Builder, Map Editor, GIS 4.3, Oracle 12c/11g/10g/9i, Putty, FileZilla, Windows XP, UNIX.

Confidential, Houston, TX

EDI Consultant

Responsibilities:

• Created maps to translate data from X12 format to AS/400 using Application Integration mapper.
• Deploy, setup & administer trading partner envelope profiles, certificates, business processes, code list, services, schedule and maps in GIS.
• Experience on configuring Inbound & Outbound File system adapters.
• Wrote UNIX shells scripts to automate FTP and SFTP process.
• Converted and tested maps generated in Visual mapper to Application Integration mapper.
• Analyzed maps and converted them from version.
• Created maps to convert data from XML to ANSI X12 and vice versa.
• Troubleshoot and resolved XSLT mapping issues and adapter failures/discards.
• Created and modified BPML to handle document archiving, failure notifications, acknowledgement reconciliations, and transaction metrics reporting.
• Configured ODBC Adaptor to pull data from data base and vice versa. Created Code lists for various code conversions.
• Created process flow, de-enveloping and routing process for Advanced Shipment Notification (856) transactions for various trading partners.
• Created Trading Partner profiles and Management of Communities in GIS 4.2.
• Involved in Migration the communication Channel from GXS to GIS in Migration project.
• Involved in upgradation of GIS 4.2 to SI 5.0.
• Created new synonym table and code list based on the customer requirements.
• Involved in loading data from flat files using external tables.
• Configured and implemented AS2 communication process for various transactions.
• Tested various EDI files and made sure they are loaded to Oracle System.
• Created business process for both inbound and outbound transactions to Oracle and other internal applications as per business needs using Graphical Process Modeler (GPM) and BPML in Gentran Integration Suite/Sterling Integrator.
• Involved in creating Inbound/Outbound maps in Gentran for 850,810 and 997 transactions.
• Successfully upgraded GIS from version 4.2 to version 4.3. Tested and validated all communication protocols, adapters, BP’s, services, and archiving mechanisms.
• Configured and tested AS/1/2/3, FTP/SSL Client services, SSH Client Services, FTP/SSL Server, SSH Server, HTTP Server, HTTP client service, Webdav, Connect: Direct Adapter, Web file upload interfaces in GIS Ver. 4.3.
• Created and executed sql queries and stored procedure in oracle using TOAD.
• Implemented Ver. 4.3’s fact schema (dimensional and fact tables) to capture and report EDI transactional information and enhanced the document lifecycle tracking mechanism.
• Wrote UNIX shell scripts to augment trading partner specific transaction batching/splitting requirements.
• Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
• Created Shell scripts and database scripts to automate document tracking functionality.
• Setup Trading partners and Wrote Gentran scripts to support EDI application.

Environment: Gentran server on UNIX 6.0, GIS Ver. 4.2 and 4.3, GXS, SI 5.0, Oracle 9i/10g/11g (SQL, PL/SQL), AIX, AS/400, Putty, Solaris.

Confidential, NYC, NY

EDI Application Developer

Responsibilities:

• Discussing needs of clients, collecting specifications of trading partners as well as information pertaining to connectivity and configurations.
• Involved in setting up of Trading Partners Envelopes for multiple transactions in Sterling Integrator.
• Configured and used ODBC/JDBC bridges to support Uniform Transaction identifier process to track Transaction across applications.
• Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator Map editor.
• Configured SAP, XML adapters to support the business requirements.
• Created business process for both inbound and outbound transactions to SAP and other internal applications as per business needs using Graphical Process Modeler (GPM) and BPML in Gentran Integration Suite/Sterling Integrator.
• Configured and implemented Sterling file gateway process.
• Configured adapters, services, service configurations and AS2 setups as per business needs.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Set up various communications using Protocols FTP, HTTP, SMTP and AS2 with trading partners.
• Written AS/400 scripts in (i-Series) arena using Inovis Trusted Link EDI/400, EXTOL, and Gentran
• Configured and build complex workflows with other analysts to automate and streamline the MX supply chain processes using Sterling OMS.
• Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc.
• Responsible for the complete design, development and implementation of 850, 810, 855, 856 documents using Gentran ODBC functionality.
• Worked on creating business process to automate EDI system for inbound (850, 940) and outbound (856, 846, 810) maps.
• Involved in map development, testing and implementation for transactions 850, 846, 856, 940, 810, 814, 820, and 856 in Sterling Integrator 5.0/GIS 4.2(Application Integration mapper, Map editor).
• Created maps to translate data from X.12 format to SAP IDOC formats for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers.
• Responsible for setting up the trading partner profiles with appropriate Message types in SAP and processing IDOCS.
• Created/modified trading partner setup in SAP using WE20 transaction.
• Troubleshoot and reprocessed IDOCS using WE19 and BD87 and Handled discards.
• Migrated maps, business processes, services, envelopes from GIS 4.2 to Sterling Integrator 5.0
• Involved in support, problem solving, data correction and map changing based upon requirements.
• Configured GIS Needs to understand the data tables in SAP.
• Responsible for staging of EDI systems in Development, Testing and Production.
• Worked with Sterling Commerce GIS (Gentran Integration Suite), BPML and the GIS BP Modeler, DB connectivity JDBC.
• Scheduled and monitored of SAP Batch jobs processing programs using SM36 and SM37.
• Experience in Validation and Sanity Testing of EDI X12 to SAP IDocs data.
• Performed Unit and system testing on all EDI transactions both inbound and outbound.
• Responsible for monitoring and troubleshooting overall B2B inbound/outbound flow through VAN, cyclone and SFTP gate.
• Detect Validation errors and provide input/resolution to the core services team.

Environment: Oracle 9i/10g/11g Sterling Integrator 5.0, Sterling OMS, BP Modeler, DB connectivity JDBC, Windows XP, SAP, SQL Server 2005.

Confidential, Overland Park, KS

EDI Analyst

Responsibilities:

• Gather, analyzes, and documents business requirements to support the design and development of technology and/or process solutions.
• Involved in EDI Transactions like 810, 850, 855,888, 879.
• Use the EDI Price Maintenance program to review and/or correct any prices, then updated to the database.
• Debugged trading partner order and shipping related issues with Oracle EBS team.
• Created the work flows to accomplish the Business models in the Business Process Models using the BPML in GIS
• Act as a primary support for customer inquiries of EDI orders and monitoring of error queues during EDI processing.
• Involved in Scheduling and monitoring of Business processes.
• Developed PL/SQL packages to extract, validate and populate document tracking, auditing, and maintenance application.
• Worked closely with both internal and external customers to analyze and resolve EDI transmission or data processing problems and exceptions.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Maintain AS1/AS2 customer certificates.
• Verified and translated both the Inbound and outbound Invoice transactions sets.
• Involved in creating Inbound/Outbound maps in Gentran for 850,810 and 997 transactions.
• Analyzed business case scenario and applied trading partner rules for the transaction flows.
• Involved in validating the EDI transaction maps and debugged the errors and corrected then according to the respective EDI implementations.
• Worked on writing/fine tuning the SQL Queries in order to increase the performance of the maps which access data from Oracle 10g.
• Install, implement and train customers to use EDI to receive purchase orders send invoices and advance ship notices electronically.

Environment: Gentran Server, Sterling B2B integrator, Windows xp/2000, Oracle 10g/9i.

Confidential, Portland, OR

EDI Analyst

Responsibilities:

• Developed In/Outbound business processes, setup trading partner envelopes.
• Analyze the EDI format received from trading partners and maintained/created new translation setups using Ec-map tool.
• Involved in HIPAA Transactions sets like (837, 270/271, 276/277, 834, 835, 278 and 997).
• Involved in validating the EDI transaction maps and debugged the errors and corrected according to the respective EDI implementations.
• Created test scripts and test data files for the EDI 812 transactions based on the ANSI X12N EDI standards.
• Involved in writing SQL queries in SQL developer to validate whether member has coverage.
• Created, Tested and verified the EDI Transactions and modules Created Transactions and the EDI Tested the Internal applications for HIPPA compliance.
• Involved in testing and implementing all required documents for ANSI/EDI standards.
• Accounted for validation of test and production EDI files, setting up testing, and analysis of test results.
• Developed EDIFECS route routes for FTP and SFTP communications.
• Used TOAD to look up at Oracle Tables for testing purpose.
• Created 270, 276 test cases to generate X12 as expected for 271 and 276 responses.
• Used to create datasets on mainframe and FTP files using run commands.
• Identified areas for improvements email notifications from Business Process failures, translation errors and created reports for error control.
• Performed test script walkthroughs with developers and Business Analysts.
• Developed Training and EDI specifications documentation, transferred knowledge to employees about the architecture.

Environment: Gentran Server, Sterling Integrator, EDIFECS Specbuilder, Windows xp/2000, XML, oracle, SAP.