PROFESSIONAL SUMMARY:

• An IT professional with a cut - to-the-chase approach and extensive experience as a Sterling Business Integration Suite specialist with a background in analysis, design, development and implementation on different EDI technologies like Sterling Integrator, Gentran Integration Suite, Gentran Server (Windows and Unix). Extensive Knowledge on B2B integration, production support, testing, implementation, and documentation of information systems
• Domain Expertise: Extensive experience in developing transaction sets in EDI and data mapping and data conversion across industries like Healthcare, Banking, Logistics, Distribution, Finance, Material management applications.
• Sterling Integrator: Professional in installation, configuration, BPML, Mapping, XPath manipulation, GIS Adapters. Design, architect, and deploy numerous GIS 2.X, 3.X, and 4.X versions, and SI 5.x. Expert in variety of EDI-EAI tool. Specializes in Sterling Commerce GIS/ Gentran products such as Sterling Integrator 5.2, 5.0 GIS 4.3, 4.2, 4.1, SFG, on Unix/Windows, Gentran Server on UNIX 6.0, Gentran Server NT/Windows, Gentran Director, GXS (Global Exchange Services).
• EDI Mapping: Created maps & layouts for HIPAA as imposed during Electronic Data Interchange (EDI): 837 - Claims and Encounters, 834 - Benefit Enrollment and Maintenance, 999 - Implementation Acknowledgement, 835 - Claim Payment/Advice, 270/271 - Eligibility Benefit Inquiry and Response, 277/275 - Claim Request for additional Information and Response, 276/277 - Claim Status Request / Response.
• Business Process Management: Worked extensively in creating Business Processes using Business Process Modeling Language (BPML), mapping various file formats for Spec 2000, X12, EDIFACT, XML, TRADCOM, etc. Used Edifices for creating EDI Specs.
• Designed and coded business processes for inbound and outbound EDI, Flat File, XML and MFT flows using BPML and GIS modeler. ANSI X12 transactions included 214, 810, 820, 850, 855, 856, 940, 945, 837/835, and 276/277.
• Sterling File Gateway and Sterling Control Center: Setup trading partners and managed file transfers in new Sterling Integrator and Connect Enterprise file transfer systems. Patched Sterling Integrator /Sterling File Gateway. Installed the latest version of 5.2.4 of Sterling Integrator and Sterling File Gateway. Created some custom BP (Business Process) to handle SFTP, FTP, and HTTP for MFT and AFT file transfers.
• Trading Partner Management: Manage the requirements and selection for Trading Partners and Vendors. Experience in Migrating Trading Partner setups with Communication setups to Sterling Integrator 5.1 (GIS) from Gentran Server for Windows.
• Mailbox Configuration: Created new mailboxes for various Trading Partners and set the communication for different Trading Partners. Work with vendors to set up electronic communications and clearinghouse communications, including protocols.
• Tools & Technology: Very strong and diverse technology understanding, specifically with C, C++, Java, J2SE, J2EE, JBOSS, Oracle EBS, PL/SQL, Visual Basic, Cobol, JCL, XML, HTML, Crystal Report, Unix, Windows, TCP/IP, DNS, SQL Net, and firewall, AS2, secure FTP (SFTP), SMTP, HTTP/HTTPS, Sterling File Gateway (SFG), Synchrony Transfer (Managed File Transfer service from Axway), Cyclone Interchange, Trusted Link, Web Sphere Transformation extender.
• HIPAA 5010: Implementation of EDI migration Project from HIPAA 4010 version to HIPAA 5010 version. Created 5010 companion guides to the state by using the Mapping Documents. Created maps & layouts for HIPAA as imposed during Electronic Data Interchange (EDI): 837 - Claims and Encounters, 834 - Benefit Enrollment and Maintenance, 999 - Implementation Acknowledgement, 835 - Claim Payment/Advice, 270/271 - Eligibility Benefit Inquiry and Response, 277/275 - Claim Request for additional Information and Response, 276/277 - Claim Status Request / Response.

TECHNICAL SKILLS:

EDI Standards: EDI X12 (ANSI), EDIFACT, XML, VICS, BPML, SAP IDOCS and RosettaNet standards.

X12: 835,837,270,271,276,277,278,204,210,214,410,834,810,820, 830, 832, 850, 846, 855,856,857,862,879,875, and 997

Application Server: Sterling Integrator 5.0/5.2 (GIS 4.2/4/3), Sybase EC Map, EC Gateway, Gentran on Unix 5.2, 5.3, 6.1, MFT (AFT, SFG), MQ Series, Tibco and Axway

Programming Languages: PL/SQL, SQL, Java, XML, C++, XSLT

Testing Tools: QTP 9.2, Quality Center 9.0/Test Director, 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

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

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

Network Protocols: FTP, FTP(S), OFTP, HTTP, SFTP, SMTP, AS2, Connect: Direct, HTTPS, Cyclone, VAN

PUTTY, WS FTP, UltraEdit, Telnet, control: M, Autosys Tools, Cognos, Crystal Reports, SSRS.

ERP and Integration tool: SAP IDOC, Oracle EBS, OMS, WMS, TMS, Web-methods, SOA, Cleo, MuleSoft and SaaS.

PROFESSIONAL EXPERIENCE:

Confidential, Winston Salem, NC

B2B Business Analyst/ Project Manager

Responsibilities:

• Assisted EDI Migration project from legacy Extol Integrator to Cleo B2B integration.
• Involved in analysis, migration, development and testing in all phases of the project.
• Performed extensive EDI requirements analysis including data analysis and gap analysis.
• Leading team to revamp EDI Interfaces.
• EDI Development using Extol and Cleo VL Trader.
• Contacted customers and managed the EDI Implementation process.
• Worked on EDI X12 transactions 810,850,820,823,824,856,864,846 and 204.
• Involved in communication testing with trading partners using FTP, AS2, SFTP, HTTP and Managed file transfer technologies.
• AS2 communications in using Cleo Trader.
• Onboarded new trading partners using Cleo Integrator.
• Supporting EDI operations/ helpdesk/resolving L1 and L2 issues for all KK sites in USA and Overseas.
• Worked on integration scope in different phases of the project.

Confidential, Winston Salem, NC

EDI Business Analyst/Project lead /SME

Responsibilities:

• Monitored inbound EDI communications troubleshoot EDI failures from customers and or requests by business partners in order to resubmit EDI data timely.
• Worked directly with trading partners, third party EDI companies in setting up the EDI transaction sets.
• Understand typical EDI guidelines and interpret EDI specifications.
• Collaborate with EDI Technical Team to deliver customers EDI requirements, ensuring proper setup of EDI Transactions with Customer Specifics.
• Developing requirements and working on Oracle e Business Suite.
• Provide support to all EDI production processes and develop and modify all maps for trading partners and coordinate with end users to expand all e businesses.
• Provide an effective EDI interface and coordinate with all external trading partners and facilitate expansion for all international division and monitor all existing communication systems.
• Design and maintain all EDI maps to ensure compliance to all business requirements and analyze all EDI implementations and recommend improvements to processes and coordinate with trading partners to resolve all issues effectively.
• Prepare and maintain test data and perform various tests on all EDI maps and prepare all required documents and evaluate reports and design everyday logs on everyday basis and document all failed translation processes.
• Monitor and documents all EDI requests and track all applications and participate in IT meetings on weekly basis and monitor progress for same in coordination with IT director and plan effective solutions.
• Document all EDI solutions for system development life cycle and maintain all documents specifications and develop various transaction specifications as per requirement.
• Monitor all EDI files 810, 850, 855, 856, 865 and 894 processing and perform troubleshoot on processes to resolve all transaction file issues and perform tests on same and provide support to all client issues and maintain documents for all operational procedures according to data requirements.
• Coordinate with EDI trading partners to resolve all production issues and perform transaction tests and resolve all EDI issues according to specification and maintain all transaction sets appropriately.
• Prepare all documents according to required guidelines and manage all communication with customers and assist to develop all EDI applications.
• Involved in regressions testing, Parallel testing, System testing and Performance testing.
• Conducted and managed meetings with customers in getting the business requirements to development teams.
• Evaluate all business processes and monitor transactions to resolve all lost transactions and perform tests on EDI maps.
• Providing recommendations for resolution of production problems.
• Evaluated the AR process in Oracle ERP R12 environments for Invoices validations.
• Created new statement Profile BR100’s for new trading partners in Oracle ERP environment.
• Monitored IRSS invoice imaging tool, Arc tree, PLM applications internally for effective business analysis.
• Participate in all system tests and analyze all data and processes and recommend improvements to same and manage all communication with individuals and internal and external stakeholders and ensure compliance to all policies and procedures.
• Worked on Communication protocols FTP, VAN, SFTP and AS2 in assisting the trading partner’s exchanges.
• Worked as Business lead and communication channel between development teams and Support teams.
• Analyze all routine processes of EDI and administer all system performance and data mapping processes and prepare reports on every day and weekly basis to present same to management and participate in various meetings.
• Worked with TP’s on integrating the EDI Invoicing and ordering channels.
• Analyze and resolve all EDI issues in processes and maintain accuracy in all inbound and outbound documents and perform troubleshoot on processes and analyze all errors.
• Prepare required documentation before implementing software applications
• Understand and create the process flows which relates to the business system
• Developing and executing various test plans which would further demonstrate the proficient usage of project life cycle
• Providing on-call technical support. Conduct business according to the defined standards and policies.

Confidential, Lisle, IL

Business System Consultant

Responsibilities:

• Primary focus on design and development of order-to-cash (OTC) systems, Logistic Execution (LE), Resource-Related Billing and EDI with a strong understanding of cross functional integration with SCM: MM, PP, WM, IM, CRM, APO, QM and FI modules.
• Interacted with Subject Matter Experts (SMEs), Business Process Owners (BPOs), Business Champions, Project Management Office (PMO), Change Management and Compliance to design Business Blueprints, As-Is and To-Be documents, and formulate Fit-GAP Analysis in order to build a workable and a regulatory compliant SD Solution.
• Extensively worked on EDI IDOC (inbound, outbound, mapping with third party logistics service providers’ WM system, message type, segment extension, IDoc monitoring, posting)/ ALE (distribution model maintenance, logical system, ports, partner profiles.
• Manipulated data in Idocs, Analyzed and Solved IDoc errors.
• Migration experience of SD master data from legacy to SAP system using conversion programs- LSMW/CATT
• Worked on standard reporting tools such as Sales Information Systems (SIS)/ Logistic Information System (LIS)
• Developed the Mapping specification documents with the help of the business team.
• Worked on migration project called One sap where company migrating the all zones of customers into one platform.
• Extensively worked on EDI transactions 850,855,856,810,820,860,865,867,870,832,834,846,997,999 etc.
• Worked on inbound and outbound SAP SD IDOCS for various transactions.
• Validating the new maps and outputs generated and verified if they are according to the standards using EDISIM
• Responsible for preparing Mapping Requirement Specification (MRS), documentation, trouble shooting, problem resolution and internal vendor/customer data issue resolution.
• Experienced in SAP SD EDI configuration including IDOC workflow. Proficient in SAP IDOC formats, troubleshooting various issues related to status codes and data in SAP using various T-codes like WE02/3/4, WE19, SE16n, VA02/3, VF02/03, and ME23n.
• Gathering business requirements and articulating them into EDI Mapping Spec for integration with SAP.
• Coordinated with the Business team for the proper development of the functional specifications and worked closely with super users in Unit testing, IT testing, Business Testing and UAT once the development is completed.
• Extensively worked on developing and testing the EDI system documents like 850,810,880,855 and 945 for the carriers.
• Worked on orders, order responses validation for customers and brokers for regression testing. (volume -200 per day)
• Created and maintained the partner profiles and the necessary EDPAR and EDSDC tables in SAP.
• Helped in the creation of Business requirement documents (BRD), systems requirement specifications (Technical specifications documents) and X12 mapping specification documents.
• Created the documentation for one to one mapping from the internal layer to the X12 specifications.
• Implemented one to one mapping from data file to EDI file by Map analysis.
• Extended the standard IDOC’s and created the custom IDOC’s in SAP.
• Developed testing strategies for Inbound and Outbound processes using IDOC’s.
• Configured IDOC extensions and ALE Functionality for outbound processes using SAP SD ECC Versions.
• Maintained EDI Partners, Message control parameters, Partner profiles, Ports, Output conditions for outbound messages.
• Tested the documents internally with the SAP and EAI layer to make sure the documents are passing to the B2B (Gentran) with all the mandatory values in it.
• Used FTP and AS2 to transfer the files from one place to another. Also, setup AS2 communications with customers and suppliers.
• Created generic business processes to zip/unzip, PGP encrypt/decrypt files.
• Created Shell scripts and database scripts to automate document tracking functionality. Application Integration Mapping (EDIFACT, SAP IDOCS, XML), SQL Mapping, AS2 Communication.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Setup new EDI trading partnerships and created Trading Partner profiles and Management of Communities in GIS 4.3/SI 5.2.
• Set up various communication-Protocols FTP, HTTP, SMTP and AS2 with trading partners for exchanging the EDI documents with digital Signature.
• Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc.
• Created maps to translate data from X12 format to web service messages using Application Integration mapper.
• Converted and tested maps generated in Visual mapper to Application Integration Mapper.
• Provide technical support of the EDI application, mappings, and interfaces, and testing.
• Designed and implemented clustered node for fail-over and load-balancing support over Linux and VMware environments.
• Developed PL/SQL packages to extract, validate and populate document tracking, auditing, and maintenance application.
• Trouble-shooted 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 JDBC Adaptor to pull data from data base and vice versa. Created Code lists for various code conversions.
• New EDI implementations for EDI X12 documents such as (850, 855. 810, 856 etc.), test case Execution, Build deployment, Postproduction. Enhancing existing EDI documents based on customer requirements.
• Special expertise lies in problem solving and workflow systems analysis. Experience in conducting design and code reviews, mentoring, and training.
• Study and review properties file - Tuning Properties file, Custom Properties files - understanding queues & threads to handle
• Converted the XML files into X12 and X12 to XML files on GIS for sending and receiving the EDI files.
• Also created EDIFACT format files from Flat files and vice versa.
• Modified the existing mappings for ORDERS, INVOICE and DESADV in EDIFACT format.
• Identified the gaps while in the process of internal testing and performed Gap Analysis.
• Fixed the defects which occurred during testing by changing the mappings in Gentran and GIS.
• Coordinated with the business team to analyze and develop different scenarios to test the documents according to those scenarios.
• Also responsible for training and transfer of knowledge to the process owner (Client/Operations side), as well as documentation of SD Issues/Resolution, Alternative Solutions and Training Materials for end users and preparation of Configuration Scripts.
• Proactively supported as a functional supplier to improve process quality, reduce and resolve open tickets and improve overall cycle time.
• Created Sales orders, Created Deliveries, Created Billing and Created Deliveries from IDoc.
• Conducted End to End testing with the partners for all the scenarios.
• Created Trading partner profiles, new maps and modified existing maps using sterling integrator Map editor and deployed the maps on to GIS.
• Extensive experience in all phases of testing from integration, Unit, User acceptance and Regression Testing.
• Provided production support and monitored the flow of documents daily.

Confidential, Lincolnshire, IL

EDI Developer

Responsibilities:

• Worked on complete life cycle of on boarding new trading partners, migration of new trading partners to SAP IDOCS.
• Responsible for the complete design, development and Implementation of 850, 855, 830, 846, 204, 990, 214, 210, 997, 940, 810, 820, and 856 transaction sets.
• Creating Maps for Purchase Orders (850), Advanced ship notices (856), Invoices (810), Application Advice (824), Inventory inquiry (846), Text Message (864), Reports for Test results (863), PO change Req Acknowledgement (865), Purchase Order Acknowledge (855), and Order Status inquiry/response (869/870), 940, 943, 945, (Advice Transaction Set), 997 (Functional Acknowledgement)
• Developed maps using complex extended rules and standard rules.
• Worked in teams with Business analysts to understand the requirement and develop relevant mapping requirement specifications.
• Responsible for Set up the new trading partners (communities, AS2, Code Lists etc.) in Sterling Integrator. Created Application Integrator maps for 850, 810, 856, 846 and 852 etc.
• Tested maps with unit testing, regression testing in development, quality before turning it to production.
• During onboarding process worked in teams to resolve critical issues.
• Created business processes using Graphical Process Modeler/BPML and configured adapters and services as per business needs.
• Configured JDBC Adaptor to pull data from data base and vice versa. Created Code lists for various code conversions.
• Development and modification of various EDI maps using Gentran Integration Suite/Sterling Integrator’s Map editor.
• 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.
• Configuring services and adapters such as FSA, SAP Suite Adapter, JDBC, FTP and HTTP to send and receive various transactions.
• 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 communications using different Protocols FTP, HTTP, HTTPS, SFTP, SMTP and AS2 with trading partners.
• Worked with Business Analyst for UAT testing, FUT testing, PIT1, PIT2 testing and Framework testing.
• Tested workflow scenarios in Sterling Integrated Dev environment, SI QA Environment and turned into Production environment.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Modified business processes to replace retiring services and adapters with new services and adapters.
• Involved in 24x7 Production Support using ITSM tool after Go Live.

Confidential, Springfield, MA

Axway EDI B2B Analyst

Responsibilities:

• Worked on integration with new trading partners using Axway Secure transport 5.2 MFT.
• Worked directly with transportation providers, Medicare and Medicaid clients in delivering effective communication.
• Working experience on AXWAY products (Gateway Interchange, Secure Transport, Sentinel, Passport and B2B Mapper).
• Involved in upgrade and maintenance activities in the project.
• Tuned MFT to increase performance and throughput of file transfers.
• Participated in migration of communication protocols FTP and identify AS2 AND SFTP clients.
• Setup VAN and Axway Secure Transport communication channels with Client Trading Partners send/receive EDI documents.
• Troubleshoot production issues related to Axway Secure Transport applications.
• Developed new interfaces with extensive transfers routing using MFT Procedures.
• Involved working on different trading partners in successful file transfers.
• Actively participated in new Business clients in developing the MFT solutions.
• Worked on different kinds of incidents on a rotational basis with offshore clients.
• Provide 24 x 7 on call support for all Managed file transfer issues as well as connect direct issues for both File Transfer System and Sterling Integrator/Sterling File Gateway.
• Setup process schedules to automate the translation& transmission of documents
• Production support for daily EDI, including monitoring and troubleshooting of transmissions and processing.
• Coordinated and performed transactional testing with trading partner.
• Monitored large volume of file transfer activities with different partners.
• Worked with offshore support team in resolving the file transfer issues.
• Monitored and resolved translator errors, data problems, communication issues etc...
• Developed and integrated the trading partner migration into MFT procedures.
• Worked on enhancements, migrations and upgrades of the Axway MFT Solutions.
• Worked on B2B managed services for onboarding new customers, suppliers and distributors.
• Actively participated on integration with legacy and existing systems in environment.
• Worked on tracking and identifying transactions easily with our document tracking service.
• Created some custom BP (Business Process) to handle SFTP, FTP, and HTTP file transfers.
• Responsible for the 24/7 production support, configuration and monitoring daily error reports and coordinate/perform error resolution.

Confidential, Gainesville, FL

Business System Analyst

Responsibilities:

• Worked on integration with new trading partners using Gentran Server for 6.0v.
• Extensively worked on proprietary mapping tool maintained in the organization and participated in implementation of GIS maps.
• This includes HIPAA gap, impact and business rule validation for all 12 standard HIPAA 4010 transactions: 270/271, 276/277, 278/278, 820, 832, 834, 999,835, and 837.
• Involved in preparing the Methodology document for the HIPAA implementation
• Implementation of 5 key aspects of HIPAA - Transactions, Identifiers, Codes, Privacy and Security, Non-Compliance issues and penalties
• Establish messaging communication channels between client and their trading partners using GXS VAN, Axway products (Gateway Interchange and Secure Transport) with AS1, AS2, HTTP/s, SFTP, FTPS, FTP protocols etc.
• Structured new Schemas of EDI ANSI X12 Claims (837) and Eligibility forms to support in new environment.
• Created Maps between the native and HIPAA formats using proprietary mapper tool, with embedded business rules.
• Responsible for the complete design, development and implementation of 834,999, 835,837,270,271 using Gentran ODBC functionality.
• Setup trading partners and managed file transfers in new Sterling Integrator and Connect Enterprise file transfer systems
• Tuned SI/SFG to increase performance and throughput of file transfers
• Enterprise File Transfer System and Sterling Integrator/Sterling File Gateway
• Patched Sterling Integrator /Sterling File Gateway
• Installed the latest version of 5.2.4 of Sterling Integrator and Sterling File Gateway
• Extensively wrote SQL queries to support translation, cross references, testing etc.
• Used EDIFECS spec builder to manage claim transaction and billing application requirements.
• On-call 24/7 production support - AS2 failures, SFTP/FTP communication process failures, system down issues, troubleshoot and fix processes to meet SLAs.
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
• Involved extensively in Implementing QA, Testing, Verification and Validation to ensure compliance with business needs
• Production Map changes to EDI document standard and company proprietary standard.
• Provide technical support of the EDI application, mappings, and interfaces, and testing.
• Worked on EDI Implementation with new trading partners using Gentran Server on Windows
• Worked on Setting up new trading partner partnerships in the EDI systems including gateway server configuration, AS2 and FTP connectivity, network and system security, trading partner requirements gathering, mapping, testing, implementation, initial production support, and documentation.
• Worked on Migrating Communication setups (AS2, FTP), Envelopes and Maps from GIS 4.3 to SI 5.1.
• Worked on Sterling File Gateway Application for transferring files between partners using different protocols and file formats.
• Outlined the Business Process flow of different Trading Partners in Visio
• Migrated Trading partners from Gentran Server (GIS 4.3) to Sterling Integrator 5.1.
• Proficient in using data translation tools GIS 4.3 Version and GIS 5.1 for Windows.
• Responsible for the complete design, development and Implementation of 850, 846, 204, 990, 214, 210, 997, 940, 810, 820, and 856 transaction sets.
• Worked on 3020, 3030, 3040, 3050, 4010, 4030 and 5010 X12 Conversions.
• Performed various kinds of testing on 835 and Outbound 837 (PID) transactions.
• Responsible for the 24/7 production support, configuration and monitoring daily error reports and coordinate/perform error resolution.

Confidential, Philadelphia, PA

EDI System Analyst

Responsibilities:

• Primarily involved in onboarding trading partners. Support B2B relationships with existing and new trading partners: customers, transportation carriers, railroads, and various third parties.
• Interact with trading partners and internal corporate and field units on a day-to-day basis to support and resolve B2B transaction flow issues
• Worked on inbound and outbound SAP IDOCS for various transactions.
• Validating the new maps and outputs generated and verified if they are according to the standards using EDISIM
• Responsible for preparing Mapping Requirement Specification (MRS), documentation, trouble shooting, problem resolution and internal vendor/customer data issue resolution.
• Experienced in SAP SD EDI configuration including IDOC workflow. Proficient in SAP IDOC formats, troubleshooting various issues related to status codes and data in SAP using various T-codes like WE02, WE19, SE16n, and ME23n
• Gathering business requirements and articulating them into EDI Mapping Spec for integration with SAP.
• Coordinated with the Business team for the proper development of the functional specifications and worked closely with super users in Unit testing, IT testing, Business Testing and UAT once the development is completed.
• Manage trading partner support issues including analysis, mapping, testing, implementation, and documentation
• Created maps to translate data from X12, XML, cXML, Delimited format to Oracle Tables using Sterling Integrator Map Editor.
• Support of Sterling Integrator, Sterling File Gateway, and Connect Enterprise. Setup Connect Direct file agent to monitor and pickup files from windows platform to transfer to other platforms
• Work with connect direct scripts to transfer files and execute additional steps after the transfer.
• Support/configuration of Connect Direct and Connect Enterprise.
• Used SAP SD transactions BD87, WE19, W05, W02, WE20 to process inbound and outbound IDOCS through RFC
• Trouble shoot connect direct file transfer problems between mainframe, UNIX, iSeries, and windows.
• Develop maps, set up communications, designed business processes and configure Trading Partners on SI
• Conduct end-to-end testing to ensure set up and monitor data flow in production for new on-boarding.
• Involved in development, coding, compiling, testing and migrating inbound and outbound processes for various transactions such as 204, 210,214,322, 404, 410, 820, 824, 835,850, 856, 860, 990, 996, 997.
• Use Graphical Process Modeler (GPM) and BPML Editor to design business processes to send and receive file via VAN, FTP, HTTP, HTTPS and AS2 protocols.
• Worked on ISERIES AS/400 and Netezza databases for web applications development.
• Worked with the third party Transportation Management System (i2) to plan all the Shipment and Transportation Planning in the TMS and interfaced the same with the SAP with the help of the Messaging (RFC), so that once the planning is done in the TMS the Shipment is sent back to SAP to carry on with the Transportation process in SAP.
• Worked extensively with the Inbound and Outbound Interfaces to fit in the Logistics Design.
• Tested the Functional Specifications to carry out the development works so that proper interface is developed between the TMS and SAP for ORDERS05, SHIPMT05, EDI 204, 214 and EDI 990, Invoice 810, ASN 856.
• Monitored all inbound and outbound EDI transaction processing. Analyzed, identified and tracked all exceptions and errors processing
• Resolution of EDI/IDOC for the inbound and outbound interfaces.
• Worked on integration with oracle EBS concepts in supporting the supple chain activities.
• Doc-Extract Map to read and remove header records from files and customized rename
• Create business process to send files directly to partners using SFTP, Email Error Notification, Alert Notification and On-Fault business processes
• Worked in following XML documents: Purchase Order, Order Confirmation, Shipment Notification, Shipments, Invoices, and other documents involved in Intermodal and Over the Road Business.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Experienced/Proficient in IBM/Sterling Integrator (SI). Worked on Data management - Performing simple SQL queries
• In charge of maps related to extensible Markup Language (XML)
• Created the business process to automate email flow when message arrives in mailbox for the project NEXUS.
• Implemented multi sign on for the on boarding timeline work tracker. Implemented SFTP data flow for migration project Open-Scan.
• Worked on IBM iSeries / AS 400 System to retrieve/Modify data.
• Used Microsoft Access to establish ODBC connection and used access as Central EDI Management system.
• Worked on Positional File Format adjusting and troubleshooting errors due to wrong positioning/ invalid data format as part of Production Support.
• Trained team members on Development guidelines and maintaining mapping practices.
• Participate in the maintenance and improvement of best-practice guidelines for B2B Integration processes and procedures.
• Worked on Sterling SI 5.x(Unix) tools and processes, Mapping, Business Process development (BPML or Graphical Modeler)
• Implemented the following transactions 276/277, 270/271, 278-13/278-11 , 820, 834,999, 837D for 4010A, 5010 and 5010A compliance.
• Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator’s Map editor.
• Design and development of business processes to meet business requirements - BPML code development
• Performed migration of maps, BP's, service configurations, and adapters from Gentran Server to Sterling Integrator.
• Study and analyze existing production business processes - troubleshoot business process and make suitable changes to in corporate new business needs/requirements.
• Configured and implemented Sterling file gateway process, adapters, services, service configurations and protocol setups as per business needs.
• Implemented Sterling File Gateway for the MQ File Transfer and Managed file transfer to move files for back-end applications.
• Monitored file transfer activity in Sterling File Gateway on an exception basis built on notification of file transfer activities.
• Automated the replay, reprocess, and resend with failed file transfers in Sterling File Gateway.
• Collaborate with vendors, trading partners, and internal functional teams to define EDI requirements.

Confidential

Process Developer

Responsibilities:

• Analyzed the existing system for AS-IS study, gathered Functional Requirements through user workshops, GAP Analysis and participated in process improvement teams.
• Worked on New G/L and configured the Parallel accounting, Document splitting, multiple currencies, segment reporting, Master Data, ledger configuration and Real time integration of controlling with the FI.
• In Accounts Payable, Configured Automatic Payment Processing for Outgoing Payments, Vendor and Inter-company Payment using In-House Cash, Payment using Direct Debit, Check, ACH and Wire payments, Interface with bank through EDI, Employee Down Payments, Vendor Down Payments, Partial Payments
• Account Receivables: Configuration of customer master and vendor master data in FI, number ranges, posting keys and document types for posting and validation of business transactions. Creation of dunning program for reminder to customers with different dunning levels Automatic payment configurations.
• Worked on creating a centralized treasury operation, improving operational efficiencies through a new global cash pool and In-house Cash (IHC) banking structure, and integrating them both with SC’s shared service centers.
• Adapted SAP Lockbox functionality to process AR payments for automatic cash application against customer invoices.
• Lockbox: Supported lockbox processing which involved issues related to customer payments, formatting issues, clearing of appropriate accounts, manual entry of incomplete or unprocessed documents and month end closing. Configured and Tested the Lock Box program for Accounts Receivables payments in BAI2 Format.
• Configured and Tested the Lock Box program for Accounts Receivables payments in BAI2 Format and EDI setup for inbound and outbound IDOC’s, BAI2, and ACH
• Configured Foreign business unit's current financial transactions and configuration for multiple and parallel currencies and Exchange rate Differences.
• Worked with offshore teams Poland, France and Portugal teams for client "Delphi" in setting up the vendors and customers
• Configuring vat procedures for the European client "DELPHI" from defining tax procedures, tax codes for sales and purchases, creating GL account vat payable and finally assignment of tax calculations to the account.
• Worked with Business validations, mass changes, integrated workflow, and check-in/check-out mechanisms.
• Closing: Defining financial statement version, reports using financial information system. periodic processing configured dunning program to remind customers of net due date Dunning levels and dunning notices were configured for making sure of consistency.
• Responsible for Month End closing process for AP and AR. Involved in Reconciling cash, AR/AP roll forward summary reports, running Month End reports.