SUMMARY:

• Over 11 years of experience in Design, Architecture, Analysis, Performance Engineering, Developing, Coding, Testing & integrating EDI applications in different sectors like Sales & Distribution, Supply Chain, Health Care, Logistics, and Energy & Utility.
• Extensive Knowledge on SaaS integration, B2B integration, Build, Deploy, Implementation, Production support, testing, and documentation of information systems for SaaS integration using Dell Boomi AtomSphere and B2B Integration using IBM Sterling B2B Integrator 5.0,5,1,5.2, GIS 3.0, 3.1, 4.0, 4.1, 4.2, Gentran Server 5.1, 6.0, 6.1, Sybase ECMap.
• Working as Dell Boomi EDI developer to Build, Deploy and Manage.
• Lead representative for EDI across the organization - Order management and Warehouse Management.
• Lead for EDI upgrade and maintenance. Acted as a lead for migrating EDI to Dell Boomi AtomSphere server.
• Experience in Database Administration & Production Support, Business Intelligence including design, development and implementation of Microsoft SQL Server 2016/2014/2008/ 2005.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSRS and SSIS services.
• Experience in designing and developing GUI (Graphical User Interfaces) using C# Client/Server (Win Forms) and Web based (Web Forms, ASP.Net) application development with CSS, JavaScript, jQuery, AJAX, and HTML.
• Hands-on experience in deploying Web Applications on IIS Web Server.

STRONG EXPERTISE IN:

• EDI Mapping and Business Process Development
• Dell Boomi Build, Deploy and Manage activities
• Dell Boomi Web Service, SOA and related technologies REST, SOAP, WSDL, XML, JSON, HTTP APIs, XSD.
• File Transfer: Sterling File Gateway, Sterling Control Center, SSP(Integration & Monitoring), MFT, AFT
• Sterling OMS - Order Management System- Design, Development and Deployment
• Trading Partner Setup, Vendor Management Set up, Mail Box, Service and Adapter Configuration
• Communication Network Protocol and Security Configuration
• PGP & FTP Encryptions and Decryptions & Performance Tuning

HIGHLY EXPERIENCED IN EDI TRANSACTIONS:

ANSI X12: 180, 204, 211, 214, 810, 811, 812, 816, 820, 821, 822, 823, 824, 828, 830, 831, 832, 846, 844,845,846,849,850, 852, 855, 856, 857, 860, 861, 864,865, 869, 870, 875, 880, 888, 940, 943,944,945,947, 996, 997.

IDOC: ORDERS01, INVOIC01, DESADV01, PEXR2001, SYSSTAT01, YCHKEXTR TXTRAW01; IDOC message types ORDERS, ORDRSP, ORDCHG, INVOIC, SAP Status Message (EDI DS).

EDIFACT: ORDERS, ORDCHG, ORDRSP, RECADV, DESADV, INVOIC, APERAK, DELFOR, DELJIT

HIPAA: 270 & 271 (Patient Eligibility), 276 claim status request, 277 Status Notification, 278 Service Review, 834 Benefit enrollment, 835 Payment Advice, 837 Claims (Institutional, Dental, Professional),997, 999. Good understanding of 5010 upgrades to support ICD-10 code Compliance.

Dell Boomi AtomSphere: Gentran Integration Suite 4.2/4.3, Gentran Server 5.3, IBM Sterling B2B Integrator 5.0/5.2, 6.0,6.1, Business Plugins), Altova MapForce, EDIFECS Specbuilder, X-Engine, Transaction Manager, Sybase EC Map/EC Gateway, Sterling File Gateway (SFG), Oracle E-Commerce Gateway, GXS AI Mapper(Workbench), Seeburger BIS 5.5 / BIC5, IPSwitch MoveIT Central, Web Methods, MQ Series.

Very strong and diverse technology understanding: specifically with C, C++, C# 4.0, ASP.NET 4.0, MVC, Java, J2SE, J2EE, SQL Server, PL/SQL, SQL Server Management Studio, Microsoft Visual Studio, PL/SQL, Visual Basic, Cobol, JCL, XML, XPath, XSLT, XML schemas, 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.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Dell Boomi Developer

Responsibilities:

• Lead representative for EDI across the organization.
• Build, Deploy and Manage activities in Dell Boomi EDI. Manage Production atom, Deployed processes and Certificates in Dell Boomi .
• Implemented Extension Activity to use separate databases for development and test.
• Experienced in configuring Web Services, SOAP, REST and HTTP APIs.
• Experienced in connecting Salesforce and NetSuite.
• Worked with SOA architecture and Web Service and related technologies REST, SOAP, WSDL, JSON, XML over HTTP APIs.
• Extensive knowledge on Dell Boomi API management.
• Verify Startup properties and install Java versions in Dell Boomi Mage tab. Verify Atom, Molecule or Atom Clod selected in the list, whether it is online or offline in Dell Boomi Manage tab.
• Designed, Developed and deployed of integration solutions for local and cloud atoms.
• Acted as a lead for migrating EDI to Dell Boomi AtomSphere server.
• Work with the business team to identify and document all requirements relating to EDI.
• EDI implementations for EDI X12 documents such as (850, 812, 856, 864, 880 etc), test case Execution, Build deployment, Post production. Enhancing existing EDI documents based on customer requirements.
• Migration of Business processes, Maps to Cloud-based EDI using Dell Boomi AtomSphere.
• Cloud based EDI implementation for EDI X12 documents such as (204, 816, 850, 856, 875, 880, 888, 940, 943, 997, 824, 846, 861, 944, 945 and 947).
• Analysis of new requirements from client and implement it on Dell Boomi such as EDI 861 Production Reversal process to send negative 861’s and 947AG to move inventory back from and 861 Missing Production.
• Worked on Migrating Communication setups (AS2, FTP), Envelopes and Maps from to Dell Boomi AtomSphere.
• Created Trading Partner profiles in Boomi AtomSphere.
• Designed Boomi process to pull the Sales Order details from iMake and inject them into MAS500. Configured email notifications to send various types of validations/messages.
• Responsible for all error issues with inbound (204, 816, 850, 856, 875, 888, 940, 943, 812, 864) and outbound (810, 824, 846, 856, 861, 880, 944, 945, 947) ANSI X12 EDI transactions.
• Use Boomi AtomSphere to design business processes to send and receive file via VAN, FTP and AS2 protocols.
• Use Boomi atmosphere and implemented Sales Order MAS500/ iMake integration to integrate iMake ales order into MAS500.
• Managed maps for the transactions 204, 816, 850, 856, 875, 880, 888, 940, 943, 997, 824, 846, 861, 944, 945 and 997 in SI and development of XML to application and application to XML maps.
• 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.
• Develop/Modify EDI maps using IBM Sterling B2B Integrator map editor.
• Created business process for both inbound and outbound transactions to database and other internal applications as per business needs using Graphical Process Modeler (GPM) and BPML in IBM Sterling B2B Integrator.
• Developed EDI Transaction set upgrade requirements as updated from X12 versions .
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners for multiple transactions in IBM Sterling B2B Integrator.
• Managed to send large volume of files to trading partners using Sterling File Gateway(SFT).
• Involved in SQL Server Administration & Production Support, Business Intelligence including design, development and implementation of Microsoft SQL server 2016/2014/2008/2005.
• Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSRS and SSIS services.
• Using SQL Profiler, SQL Server Management Studio and Execution plans as part of trouble shooting and performance tuning.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures, Creation and maintenance of Databases, creating Roles and managing user permissions.
• Involved in T-SQL programming for writing DDL & DML queries and creating SQL objects like tables, stored procedures, views, Indexes, Rules, user-defined functions, Triggers, Cursors.
• Developed Material Balance, Storeroom Inventory, PMYields, GL Transaction and PO Status reports on SSRS 2016 and 2008.
• Worked on SQL Server 2014 migration from SQL Server .
• Using Redgate tool to store the SQL backups in Amazon Web Service (AWS) storage.
• Working as a team member in development of web based applications and involved in Requirement analysis, Design, Coding and Testing.
• Effectively used Model-View-Controller (MVC) Architectural pattern to develop the application.
• Implemented business logic using Code behind files in C#.
• Deployed web application on Internet Information Server(IIS) for production and used Team Foundation Server(TFS) for version control.
• For front end development actively used ASP.Net, CSS, JavaScript, AJAX control and Telerik Controls.
• Worked with business teams to identify MAS sales order integration process and developed business processes to transform sales order from iMake to MAS500.
• Implemented various SQL views and stored procedures to inject sales order details into MAS500 server.
• Analyzed EDI translation errors that failed in the inbound and re-processed the EDI’s without losing the information.
• Analyzing business process schedules and running status, Certificate Expiration status, discrepancies in inbound and outbound EDI documents.
• Coordinated with the trading partners to resolve Inbound and Outbound EDI errors.
• Replicating and verifying all issues pertaining to client’s business process, trading partner setup, EDI maps in development/ test servers and deploying appropriate fix in production environment.
• Creating and updating the databases basing on new requirements with the help of the SQL server management studio.
• Setting up various kind of communication channels like FTP, AS2 and email notifications.
• Involved in production support, trouble-shooting the day to day issues of the application.

Confidential, Cincinnati, OH

Sr. EDI Developer

Responsibilities:

• New EDI implementations for EDI X12 documents such as (850, 855. 810, 856 etc), test case Execution, Build deployment, Post production. Enhancing existing EDI documents based on customer requirements.
• Implemented the OMS Project at Confidential Aviation where GIS was used as an integration tool between Sterling (OMS) and other interfaces as a lead for EDI.
• Worked on the design, development and implementation of all the non EDI interfaces and EDI transactions for OMS.
• Worked on several maps for various X12, EDIFACT, SAP IDOCS and TRADACOM based transaction sets. Excellent Mapping skills. Handled complicated looping in development of various transaction mappings.
• Completed Installation, Configuration of Sterling Integrator 5.2 on AIX. Completed following configurations such as Perimeter servers, FTP/SFTP adapters, MQ, PGP, AFT mailboxes.
• Migration of Business processes, Maps and AFT mailboxes from GIS 4.3 to SI 5.2.
• Analysis of new requirements from client and implement it on SI such as Adapter Configurations.
• Experience in migration of data from Gentran Server to IBM Sterling B2B Integrator.
• Responsible for all error issues with inbound (850, 860, 940, 943, 856) and outbound (856, 943, 945, 810, 820) ANSI X12 EDI transactions and EDI EDIFACT transactions.
• Monitored business processes on client’s system and generated real time solutions for halted transactions resulting in reduced response time, thus expediting business process by 80%.
• Analyzing business process schedules and running status, certificate Expiration status, discrepancies in inbound and outbound EDI documents, keeping business informed of SI system health.
• 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.
• Performed EDI mapping from/to both SAP/R3 IDOCs and other Flat File Formats. Developed maps for the transactions 210, 214, 248, 315, 810, 814, 824, 852, 856, 860, 864 and 997 in GIS and development of XML to application and application to XML maps.
• Process owner for trading partner setup, migration of trading partner using the code list in GIS. Developed CSV to XML map to generate the trading partner codelists. Setup communication codelist to load all 800 trading partners in one go. Developed process for 997 message reconciliation in GIS.
• Performed EDI mapping for 814(Enrollment, Change, Reinstatement), 867, 248 and 824 transactions.
• Replicating and verifying all issues pertaining to client’s business process, trading partner setup, EDI maps in development/ test servers and deploying appropriate fix in production environment.
• Setup and customized Trading partners Communication and creating various work flows for the transfer of data between partners.
• Configured Mailbox setup for various trading partners. Configured SAP Adapter, AS2 connectivity, SMTP adapter
• Creating the customer mailboxes and configuring them for different flows.
• Worked on IBM iSeries / AS 400 System to retrieve/Modify data.
• Created all EDI mapping documents from Sterling Integrator to/from WebSphere and P which were included in all EDI Technical Specifications.
• Creating and updating the databases basing on new customer on-boarding with the help of the SQL manager.
• Setting up various kind of communication channels like SFTP, FTP, AS2 and mailboxes.
• Develop/Modify EDI maps using Gentran Integration Suite/IBM Sterling B2B Integrator map editor.
• Involved in production support, trouble-shooting the day to day issues of the application.
• Set up DMS documents for various trading partners and extensive development of DMS maps for various X12,EDIFACT and TRADACOM transaction.
• Worked on setting up the performance tuning parameters to increase the performance as SI was used as a live tool for their OMS.
• Part of Go-Live for the OMS implementation and addressed all the production issues.
• Managed the purging of data in DMS from time to time by generating various rules. Created map and Trading partner set ups using Map and Rename managers.
• Converted EDI files to XML using JAVA.
• Special expertise lies in problem solving and workflow systems analysis. Experience in conducting design and code reviews, mentoring, and training.

Confidential, Deerfield, IL

Sr. Edi Developer

Responsibilities:

• Created maps to translate data from X12 format to SAP IDOC formats for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers.
• Created Trading Partner profiles and Management of Communities in GIS 4.2.
• Experience in implementing Managed File Transfer (MFT) applications to support FTP/SFTP, HTTP, and AS2 file transfer protocols.
• Managed to send large volume of files to trading partners using Sterling File Gateway(SFT).
• 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, tested, and implemented Sterling File gateway’s (SFG) consumer file structures(CFS), Data flows, events, delivery channel, and routing rules to enable and automate Managed file transfer(MFT).
• Developed EDI Transaction set upgrade requirements as updated from X12 versions .
• Create maps for IDOC to flat file, EDI to IDOC and IDOC to EDI mapping (850, 810, 820, 824, 831,944, 945, 947, 856 ).
• Responsible for AI4.1 to AI 5.2. Migrations of all User/System Maps, Setups in new environment. Trouble-Shooting in retrofitting the older version and making new 5.2 compatible
• Design managed file transfer (MFT) solution using Sterling File Gateway(SFG) to support data exchange in AS2, PGP, SNMP/SMTP, FTP, SFTP, JDBC, FSA, SAP ALE and SAP File based protocols.
• 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.
• Collaborate with vendors, trading partners, and internal functional teams to define EDI requirements.
• Provide technical support of the EDI application, mappings, and interfaces, and testing.
• Translating the data from ANSI X12 to text format in inbound process using the translator
• Performed Integrated Testing and Performance Testing based on the Test Scripts and Test Cases for the requirements.
• Worked with application development team to identify bottlenecks that could hinder progress of development.
• Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing efforts on their applications.

Confidential, Phoenix, AZ

Sr. Edi Developer

Responsibilities:

• Performed data analysis, application file format validation, formatting, Trading Partner setup and mapping.
• Setup Trading partners, created standard to application and application to standard and pass-thru maps.
• Created the implementation guides for different file formats (X12, XML, CSV, Delimiter, Fixed ASCII, Database)
• Responsible in setting up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners for multiple transactions in Sterling Integrator.
• Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrators Map editor.
• Set up various communications using Protocols FTP, HTTP, SMTP and AS2 with trading partners.
• Set up and configured the AS2 communication protocol for exchanging the EDI documents for trading partners with digital Signature.
• 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.
• Worked on Migrating Communication setups (AS2, FTP), Envelopes and Maps from GIS 4.3 to SI 5.2.
• Translating the data from ANSI X12 to text format in inbound process using the translator.
• Created and modified BPML to handle document archiving, failure notifications, acknowledgement reconciliations, and transaction metrics reporting.
• Developed various business processes and maps for both EDI transactions and non EDI interfaces.
• Created various routing rules and mailboxes for both inbound and outbound transaction sets.
• Created maps to translate data from X12 format to AS/400 using Application Integration mapper.
• Wrote UNIX shells scripts to automate FTP and SFTP process.
• Converted and tested maps generated in Visual mapper to Application Integration Mapper (AI Mapper).
• Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc.
• Worked with business teams to identify integration points and develop business processes to transform messages using XSLT
• Created test plans for load and performance tests with twice the daily EDI volume
• Responsible for analyzing, designing, implementing, testing, monitoring the changes and moving to Production support.
• Involved in production support, trouble-shooting the day to day issues of the application.

Confidential, Baton Rouge, LA

EDI Developer

Responsibilities:

• Perform Analysis, Design, Development and Implementation of X12 EDI maps by using Gentran Server and EDIFECS Specbuilder.
• Create 5010 Companion guides for HIPAA EDI transaction sets, including the HIPAA i, 837p, 837d, 835, 270/271, 276/277, 278.
• Installed and configured Sterling Integrator 5.0.3. Migrated objects and maps from GIS 4.3 to SI environment. Modified business processes to replace retiring services and adapters with new services and adapters.
• Developed, customized and maintained Java scripts and Java actions using Spec Builder.
• Responsible for the complete design, development and implementation of 834, 835,837,270,271 using Gentran ODBC functionality. Implemented HIPAA/EDI Transactions like 834,835,837,270,271,276,277.
• Implemented the following transactions 837P, 837I, 835, 27x and Acknowledgements for 5010 and 5010A compliance.
• Worked on integration with new trading partners using EDIFECS on UNIX using XEngine and Transaction Manager.
• Full compliance checking against all HIPAA Implementation guideline rules, as well as trading partner-specific requirements is done using EDIFECS XENGINE.
• Performed trading partner testing for bi-directional for 834, 835 and Outbound 837 transactions
• Developed ANSI X12 to XML translation for delivery to internal validation, data warehouse and reporting systems.
• Performed logical mapping changes for 834 and 835 transaction sets to and from claims and billing applications.
• Defined Test Cases for HIPPA transactions, created EDI files based on functional scenario. Executed test script in both manual and auto mode
• Loading Eligibility Data for membership into system from the state, vendors using Proprietary format, ANSI 834 through EDI, and web interface.
• Participated in designing application file layouts and EDI layouts for 837 and 835.
• Involved in support, problem solving, data correction and map changing based upon requirements.
• Responsible for HIPAA Compliance & Testing of HIPAA 834, 835, 836 and 837 Transaction.
• Created Business Processes using Sterling Integrator with BPML and the GIS BP Modeler, DB connectivity JDBC, FTP, and AS2 adapters.
• Developed ANSI X12 to XML translation for delivery to internal validation, data warehouse and reporting systems.
• Defined Test Cases for HIPPA transactions, created EDI files based on functional scenario. Executed test script in both manual and auto mode.
• Coordinated with the trading partners to resolve Inbound and Outbound EDI errors.
• Analyzed EDI translation errors that failed in the inbound and re-processed the EDI’s without losing the information.

Confidential, Nashville, TN

EDI Developer

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.
• Performed analysis and created Business Process Flow Diagrams Using Visio.
• Responsible for creating technical and functional mapping specs and converting the maps from Sybase EC mapper to AI mapper using Map Editor.
• Experience in Troubleshooting of EDI and IDOC related Errors and creating pride tickets and re-processed the IDOC’s in SAP.
• Involved in the separation of the company’s EDI transactions after company split by implementing divisional code into EDI transaction maps.
• Created and tested break maps for splitting Inbound X12 and ensure that data goes to right departments.
• Also interacted with company’s SAP, WMS and TMS teams for their interaction with Gentran.
• Developed maps and business processes for transactions between trading partners and Transportation Management system (TMS) like X12 to OTM Trans orders, planned shipments, shipment status etc.
• Developed maps and processes for transactions involved for Customers interface: Inbound WO ACCEPT (X12 990),Outbound WO CREATE/CANCEL/AMEND (X12 204), Inbound O AMEND ACCEPT/REJECT (X12 990), Inbound APPOINTMENT SCHEDULE/ACTUAL (X12 214), Inbound WO AMEND (X12 204), Outbound WO AMEND ACCEPT/REJECT ACKNOWLEDGEMENT (X12 990)
• ASN (856 EDI document) - Created a process that generates an ASN (856 EDI document) to Customer for a Direct Ship Orders with information from the third party Vendors (facilitated by a Consolidator/Broker/3PL such as EXEL).

Confidential, Hartford, CT

EDI Developer

Responsibilities:

• Implemented HIPAA/EDI Transactions like 834, 835, 837, 276, and 277. Implemented 270/271 Health Care Eligibility Benefit Inquiry and Response transactions.
• Provided Production Support to LOA application (EDI is a part of Loop order automation) and updating the logs and EDI files.
• Used Edifecs Spec Builder to build, edit and customize the implementation guidelines.
• Managing Membership Enrollments for corporate group accounts and Individual membership accounts and Coordinating with Claims & ITS team.
• Performed Unit and system testing on all EDI transactions both inbound and outbound.
• Involved in dealing with trading Partners and conveying the implementation guidelines and specifications.
• Worked on 270/271 (Eligibility Request & Response) for different clients in EDI Translations, Requirements analysis in different segments and Elements that are required to send to the clients within the HIPAA regulations.
• Worked on 834’s Benefit Enrollment in analysis, translation of flat files to EDI format and EDI Files to Flat files and analyzed the files through Claredi and Worked on Requirements documents and Companion documents of different states.
• Created specs with EDIFECS spec builder for all the trading partners.
• Worked on integration with new trading partners using Gentran server for UNIX 5.3.
• Modified maps to support newer versions and upgraded from Gentran 3.2 version to Gentran 5.3 version.
• Created/modified trading partner setup. Provided Production Support for the maps developed in Gentran.
• Configured and supported data Managers. Maintenance of EDI Documents, data managers, and Gentran life cycle Database.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Worked on Sending and receiving the files through Communication protocols like HyperTerminal, Files Encryption, Decryption, creating and sending password protected files.