SUMMARY:

• Over 7 years of experience in EDI and worked as EDI Analyst/Developer with extensive experience in multi divisional corporate EDI environments.
• Highly Experienced in Distribution, Manufacturing, Supply chain, Healthcare, Shipping and Logistics industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
• Worked on multiple systems like Oracle EBS, SAP and 3 rd party system to EDI integration with sterling EDI tool.
• Highly experienced in handling EDI Production Support.
• Responsible for the daily EDI operations, which included administration, control, scheduling and balancing of EDI documents.
• Experienced in working with FTP, FTPS, SFTP, AS1, AS2, AS3, VAN.
• Experienced in Data Mapping and Data Conversion using EDI/ HQ, Gentian, Sterling Integrator.
• Trading partner assessment as well as corporate readiness for EDI production. Industry knowledge sharing to assist in long - term goals.
• Developed several scripts for Unix Environment and Gentran Environments.
• Worked on different EDI Products like GIS, STERLING INTEGRATOR, GXS on Windows Server with SAP ERP as backend system.
• Extensive experience in B2B integration tools e.g. Sterling … Sterling file gateway 2.2.4.
• Experience with various EDI standards and translators: ANSI X12, EDIFACT, EDI/ HQ.
• Working on partners to send/receive EDI transmissions.
• Experienced in various delimited file formats and standards include ANSI X12, UN/EDIFACT.
• Expertise in New Trading Partner On-boarding.
• Proficient with different translation tools like SI Map editor, EDI HQ.
• Proficient working with Graphical Process Modeler for designing Business Processes in SI.
• In-depth knowledge of all QA Phases that include Manual, System, End-to-End testing.
• Worked with Scheduling and Performance Tuning of Business processes in GIS/SI.
• Experienced in integrating onto IBM SI/GIS.
• Had knowledge on java with EDI related.
• Experience on XML, XSD, XPATH, XSLT and other internet related technologies.
• Experienced writing SQL queries in Oracle, MySQL and IBM DB2.
• Daily checking Project tracking using tools like JIRA, MS Project.
• Worked in Mainframes, for Trading Partner data extraction.
• Experienced working with File Formats like ANSI X12, EDIFACT, IDOC, CSV, XML, and legacy specified application file formats.
• Worked on flat file, ANSI X12 EDI transactions like 834, 835, 837, 850, 855, 856, 810, 820, 816, 860, 865, 945, and 940, 204, 210, among others.
• Worked on EDIFACT EDI transactions like ORDERS, ORDRSP, DESADV, INVOIC, and REMADV among others.
• Coordinate work for and with other Business Analysts, coordinate Unit Testing tasks, work with Trading Partners for connectivity issues; liaison between customers and corporate staff or between IT and Business Units; perform system matrix testing.
• 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.

TECHNICAL SKILLS:

Languages: Core C++, Java, Visual Basic.

Markup: HTML, XML, XTHML.

Enterprise Application Integration / B2B: Sterling Integrator / Gentran Integration Suite, Sterling File Gateway, Sterling Control Center, Gentran Unix, ISeries

Application Development Suites: Net beans

Environment: s Windows, AIX, Linux

Database: Oracle, IBM DB2, Microsoft SQL, MySQL

Design/Modeling Tools: MS Visio 2002 (Unified Modeling Language (UML))

PROFESSIONAL EXPERIENCE:

Confidential, CA

Edi developer

Responsibilites:

• Completed EDI B2B Integrator training to define data mapping rule, setting up FTP connections and trading partner profiles to align all the X12 transaction sets.
• Developed EDI maps using the Windows EXTOL tool Implemented EDI maps for transactions 820, 834, 837, 835, 270 and generated functional acknowledgment 999 using the X12 standard, in versions ranging from 4010 through 5010.
• Created maps for both inbound and outbound trading partner relationships.
• Performed system wide testing on all EDI transactions and configuration of all trading partners.
• Ensured the correct translation was generated by Extol, and that the files were accepted correctly into the ERP application.
• Performed all EDI Coordinator tasks that include analyzing internal business needs as well as external trading partner needs, requirements and requests as they relate to EDI 820 Premium Payment and 834 Benefit Enrollment and Maintenance
• Designed, coded, and implemented SAS code for analytic studies to fulfill internal and external client requests, maintained, evaluated, and reported on recurring analytic studies. Perform data hygiene and created data validation program.
• Facilitated EDI testing with trading partners to implement new initiatives, transaction sets, version upgrades and alterations to current transaction sets.
• Wrote SQL queries to evaluate and update inbound data. Create SQL processing script for new data sets.
• Developed and distributed documentation of EDI specifications, information and procedures as they related to the business issuing formal announcements, notifications or acknowledgments pertinent to upgrades, trading partners, fixes changes, and enhancements etc.
• Write complex SQL queries to evaluate and update inbound data. Create SQL processing script templates for new datasets. This consists of new written work around scripts if needed to verify raw data.
• Review and correct SQL statements, create stored procedures as needed for data processing and new data sets.
• Use SQL queries to identify and analyze data anomalies.
• Experience with data quality control, data manipulation and electronic health records.
• Maintained HIPPA Compliance while conducting business with vendors, clients, and members.

Environment : MS Office, Windows, .NET, Agile, MS Visio, MS SharePoint, TFS, MS Project, MS Access 2007, Web Services, MS Visio, SQL, Oracle, SOA, HTML.

Confidential, Chicago, IL

Sterling Integrator/EDI Developer

Responsibilities:

• Communicated with Trading Partners for trading partner cross walks.
• Developed the Business process for trading partner on boarding using AS2, SFTP, FTPS, and FTP.
• Developed Business Process for both Inbound and Outbound flows to ensure proper data processing and/or when needed to resubmit data to a customer.
• Involved in the meeting with 3rd party EDI vendor SPS Commerce and Created Mapping specification documents.
• Designed and developed Inbound and Outbound maps and Maintain up-to-date EDI transaction specifications for each customer.
• Troubleshoot and follow up as required on EDI messaging translation failures and customer communication problems.
• Created the Trading partner envelopes and Responsible for all EDI testing from start to finish with customers.
• Created data tracking tables by creating customer tracking maps for different transactions.
• Worked on end to end design and development of Outbound EDI 810 Invoices to various customers in Confidential .
• Created the schedulers for the business process.
• Worked on migration project from GIS 4.2 to Sterling Integrator 4.3.
• Worked on XML data formats in GIS.
• Worked on EDI and positional data formats in Gentran Integration suite.
• Involved in mapping changes to 810, 820, 832, 850, 860 transactions for various trading partners.
• Integrated Check out process to Sterling Integrator.
• Created and executed test plans and test cases for various EDI 810, 820, 832, 850, 855 transactions in HP Quality Center.
• Created schedulers to pass values to the business process to change the behavior of the business process.
• Create and updated existing map specs using Gentran Server for Windows from IDOC to X12 and xml for multiple transactions including 810, 880, 856, 850, 860, 214 to send to GXS for mapping.
• Traced and corrected problems with transmissions (Resend) and worked with trading partners on fixing data quality issues.
• Understood the functionality of existing Gentran Maps & replicated the same in PO Maps
• Performed UAT testing with business user in pilot conference rooms and user tanning.
• Created static channel templates for EDI transactions.
• Managed master data for Material Master, Vendor Master, Customer Master, Info Records & Source Lists.
• Created MFT routes for FTP, FTPS, SFTP.
• Generated Upload programs for MDM integration with legacy EDI/SBT systems.
• Monitored SFG and SI transaction alerts for daily EDI transactions.

Environment: Sterling Integrator 5.2.3, BPML, AI Mapper, SAP, PGP, Sterling File Gateway, Oracle EBS, Oracle Database, DB2 Database.

Confidential, Sunnyvale, CA

Sterling Integrator/EDI Analyst

Responsibilities:

• Worked on Sterling Integrator for B2Bi on EDI transactions like 820, 810 etc.
• Worked on Sterling File Gateway for MFT.
• Gather business requirements with respect to enhancements and new developments of business process and create the mapping specification documents.
• Conducted meetings with trading partners to get customer specific maps, documented them and implemented in EDI mappings.
• Expertise in Trading partner configuration in Sterling Integrator (SI).
• Expertise in EDI standards. Developed and deployed the Maps - 837, 820, 811, 835, 867
• Extensively worked on Business Process Development.
• Manipulate raw EDI data for inbound/outbound transactions to ensure proper data processing and/or when needed to resubmit data to a customer.
• Create and modify EDI translation maps to support customer requirements.
• Created business process for SFTP, FTPS, and AS2 protocols.
• Created a database table for partner profiles with Mailbox, Mailbox rule, pick up paths, drop off paths etc which is called by a BP during execution.
• Worked on both EDI formats EDIFACT and X12 standards.
• Managed master data for Material Master, Vendor Master, Customer Master, Info Records & Source Lists.
• Created Static routes in SFG and configured the required channels in SFG.
• Migrated SI 5.2 to Sterling Integrator 5.2.5.
• Managing and resolving day-to-day B2B issues.
• Migrate SI objects like Business Processes, Maps, Envelopes, AS2 partner setups from GIS to SI.
• Tested end to end connectivity for Test/Development and Production.
• Analyzing failed inbound/outbound business processes within SI to determine root cause of failure and assigned to correct resource group.
• Created a framework for creating end to end partner based dynamic file archiving of all eligibility and non-eligibility files
• Understood the functionality of existing Gentran Maps & replicated the same in PO Maps
• Analyzed and worked on migration of interfaces from legacy application systems to Sterling Integrator viz. CORAM
• Generated Upload programs for MDM integration with legacy EDI/SBT systems.
• Fixing the Bugs in the programs.
• Primary On Call support personnel on 24/7 basis

Environment: Sterling Integrator 5.2.3, Sterling File Gateway 2.2, Sterling Control Center 5.3, Workhorse, GPM, AIX, Oracle Database.

Confidential

EDI Mapper

Responsibilities:

• Created inbound and outbound Maps for various transactions using AI mapper as per business needs to convert data from standard to APP and APP to standard format.
• Mapping, X.12 EDI transactions (EDIFACTS, SAP IDOCS, 810, 850, 856, 860, 852, 820, 834, 835, 837, 999 XML etc.)
• Creation of business process in GENTRAN Integration Suite 4.2.
• Involved in the separation of the company's EDI transactions after company split by implementing divisional code into EDI transaction maps.
• Administration of GENTRAN Integration Suit 4.2.
• Configuration and setup of trading partners within the GIS 4.2.
• Coordination and implementation of trading partner testing and production migration with VANS.
• Participates in the full systems life cycle and is responsible for designing, coding, testing, implementing, maintaining and supporting software solutions that are delivered on time and within budget.
• Participates in discussions with customers, business analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions.
• Provides on-call support.
• Database concepts, administration of Sterling Integrator, XSLT, working with properties files etc.
• Create map specs using Gentran Server for Windows from IDOC to X12 and xml for multiple transactions including 810, 880, 856, 850, 860, 214 to send to GXS for mapping.

Environment - Gentran Integration suite 4.2, GPM, SAP, Linux, Oracle Data base.