We provide IT Staff Augmentation Services!

Edi Analyst/ Developer, Ibm Sterling Consultant

3.00/5 (Submit Your Rating)

Summary:

  • Strong experience in the analysis, development, unit testing, trading partner testing of EDI - Integration applications that involve the complete Software Development Life cycle from Analysis, Design, Testing & Implementation.
  • Demonstrated proficiency in ANSI ASC X12, HL7, EDIFACT, VICS, UCS, TRADACOM, and RosettaNet EDI Standards.
  • Expertise in using various EDI mapping tools such as Sterling B2b Integrator, Gentran Integration Suite, Gentran, Edifecs Spec Builder, Edifecs Transaction Manager, Edifecs XEngine, Edifecs Application Manager, GXS, Web sphere Transformation Extender, BizTalk.
  • Excellent Knowledge of HIPAA (4010, 5010) Standards, OBAMACARE and HIPAA Code sets ICD-9, ICD-10 CODING, and HL7.
  • Hands-on experience in HTTP, HTTPS, FTP, FTPS, SFTP, SMTP, AS2, and VAN communication protocols.
  • Extensive Experience in the mapping of files into various formats Ex: EDI X12 Files, EDIFACT, Flat files, Positional files, Cobol Copy Book, Cxml, SAP IDoc.
  • Highly skilled in Inbound and Outbound interfaces of various transaction sets like 814, 867, 650, 810, 824, 837, 835, 820, 830, 850, 856, 860, 861, 862, 834, 999, 900, 940, 945, 990, 997, 210, 214, 270,271,276,277,104,110,160,161.
  • Experience in Automating EDI Processes using Business Process, Scripts, Routes.
  • Good Experience in onboarding Trading partners and implementing MFT Products.
  • Extensively involved in Customization and Configuration of Integrated EDI applications, Project Evaluation, Information Gathering, and Documentation.
  • Manage the requirements and selection for Trading Partners and Vendors. Schedule conferences, JAD sessions, participate in negotiations, set/create/resolve EDI TP issues and create draft points for corporate meetings.
  • Good Team Player, Strong Interpersonal, Organizational and Communicational Skills.
  • Excellent Presentation and Customer handling skills.

Technical skills:

Operating Systems: Windows 2003/2000/NT/XP, UNIX, Linux 3.0, Sun Solaris 5.8, AIX 6.1, VMSProgramming Language: C, C++, Java, JavaScript, UNIX shell scripting, Perl, SQL, PL/SQL, Visual Basic, ASP,.NET, COBOL, XSLTIndustry Standards: ANSI X12, HIPPA, EDIFACT, TRADACOM ROSETTANET, XML, VICS, BPML, SAP IDOCs, SOAPMapping Tools: SI 5.0/5.2/5.3, GIS4.3/4.2/4.0, Gentran 6.0 (UNIX), Mapping Editor 4.1, GXS, Sybase EcMap 5.1.6, EDIFECS Spec builder 7.0.7, XEngine and Transaction Manager, WTX, BizTalkTransaction sets: 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 997Application 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.Tools:: EDISIM 4.0, XMLSPY, HP Quality Center, IBM QSS, WinScp, Putty, QTP 9.2, Win Runner 7.5, Load Runner 7.8, Rational Clear Quest, ClarediNetworking: FTP, FTPS, SFTP, HTTP, HTTPS, VAN, AS2, FTP/PGP, Putty, FileZilla, WinScpDatabases: Oracle10g/9i/8i, MSSQLServer 2008/2005/2000 , MySQL 5.0, MS Access 2007, DB2Work Experience:

Role: EDI Analyst/ Developer

Responsibilities:

  • Create Mapping requirement specification documents.
  • Configured Sterling B2B Integrator Business Process to connect to downstream applications.
  • Involved in Project Estimation and Effort Evaluation.
  • Developed high-level and low-level designs for the system implementation using Microsoft Visio, UML diagram, State change, Sequence data flow, and process diagrams.
  • Worked on several Project tracking activities with the project manager such as Estimation, Change Management, and Schedule and Effort management.
  • Used MFT to securely transfer files over networks using Encrypted file transfer protocols.
  • Configured different protocols in Sterling B2b Integrator like HTTP, HTTPS, FTP, SFTP, SOAP, REST, AS2.
  • Created several mailboxes for trading partners for AS2 connections and file directories.
  • Created custom tables to store code lists.
  • Monitored Sterling B2b Integrator using external GUI and alerted appropriate teams like networking, database team, etc.
  • Worked closely with networking team and administrators to improve system performance of Sterling B2b Integrator cluster and resolved Database Performance issues.
  • Developed new business process using Graphical Process Modeler and text editor.
  • As part of best practices, configured the on-fault conditions in the business process and created email notifications for the production support team.
  • Used and configured several adapters like the JDBC, FSA, SFTP, FTP, HTTP, CLA, File System, SAP adapters in Sterling Business Processes.
  • Created Maps for transforming the files from several different formats to various other formats XML to XML, EDI to XML, XML to EDI, and EDI to EDI.
  • Created maps for transactions that include 810, 820, 824, 850, 104, 110, 204, 210, 214, 300, 301, 310, 352.
  • Created Business processes and scheduled them for automating the file transformations.
  • Worked in User acceptance and system integration testing.
  • Worked on defects that were reported in HP Quality Center.
  • Involved in code drops and maintained documentation related to it.
  • On-boarded several trading partners in Sterling integrator.
  • Created Envelopes for each trading partner.
  • Ran SQL queries to create reports out of the daily file transmissions and did an investigation on failed processes and provided solutions for those problems.
  • Worked with architectures and done performance tuning, analyzed database sizing, and addressed any capacity/database issues.
  • Worked well within a team as required. Contributed to successful testing within the application team. Worked individually for resolving issues.
  • Created the application support documentation for the support team.
  • Provided KT to the Sterling integrator application support team.
  • Supporting for the project Go – Live

Environment: IBM Sterling B2B integrator 5.2.4, BPML, Notepad++, Ultra Edit professional, SQL queries, HP Quality center, LDAP, IBM Rational clear case.

Role: IBM Sterling Consultant

Responsibilities:

  • Involved in gathering requirements for migration of back-end system.
  • Analyzed existing reports and defined business requirements and business process flow.
  • Onboarding the various partners.
  • Creating the partner setups in the Sterling file gateway.
  • Involved in file transfers which included various platforms which include Windows, Unix.
  • Used Sterling Connect Direct for file transfers.
  • AS2 setups were done for the transfer of files. Used SFTP, FTP, FTPS, AS2 for file transfers.
  • Involved in creating Trading Partner AS2 Partner profiles, imported AS2 Certificates, exchanged As2 certificates.
  • Used service desk ticket tool. Proficient in following the quality processes.
  • Involved in creating changes, incidents, tasks, tickets, etc.
  • Responsible for Trading Partner EDI SLA.
  • Deployed various business applications in DEV, QA, UAT, PRD environments as per the requirement.
  • Raising tickets and coordinating troubleshooting them.
  • Good understanding of writing the SQL queries for pulling the data from the database.
  • Working with different internal to test solutions Oracle ERP software related to Customer setups, Pricing, Cross References, and reports used for packing/shipping parts along with day-to-day EDI exceptions.
  • Acted as a contact to business and customers for EDI setups for testing and development purposes.
  • Response models for customer acquisition, up-selling, and cross-selling.
  • Profile brand preferences of customers and classify them accordingly.
  • Find customers in factory stores that are “similar” to those in the premier stores.
  • The effect, on customers and sales, of store openings/closings of nearby stores of the same chain.
  • Identification of salient traits of good managers from survey results.
  • Manage and process inbound/outbound EDI transactions such as 850, 830, 862, 810, 856,820,997,866 and 824.
  • Modify/maintain setups in Oracle Modules related to EDI. Such as Customer Standard, Trading Partner Profiles, Processing Rules, Support Oracle upgrades for the EDI department. Knowledge of multiple Oracle Modules with Super User responsibilities.
  • Migrated from SAP to Oracle E-Business Suite.
  • Acted as Service Parts liaison for Oracle implementation and EDI setups.
  • Maintained Customer Cross-reference for EDI setups in Oracle to resolve EDI failures.
  • Ran exception reports to provide to Production Sales/Customer Service groups to handle EDI errors and exceptions.
  • Monitored after-hour failures of Shipping Transactions to ASN’s and reprocessed failures for On-Time delivery of EDI to various Trading Partners.
  • Worked on IBM sterling integrator for migrating the existing FTP servers to the Gentran Integration Suite.
  • Developed Several different maps which will convert from X12 to XML, IDOC, and Application format.
  • Designed & Developed Business processes using BPML and GPM.
  • Customized protocols for transmissions with the new trading partners as per the trading partner requirements. Involved in Setting up of new Trading Partners, Creating Envelopes, and also setting up communication channels (FTP/SFTP/AS2).
  • Installed Sterling File Gateway on Different Environments.
  • Created Partners, Mailboxes, Routing channels (Static &Dynamic), Routing channel templates for the new trading partners in Sterling File Gateway. Experience in MFT solutions.
  • Created Several Different users in Sterling File Gateway and granted appropriate access.
  • Daily activities include testing the new trading partner setup.
  • SSH remote profile setup. Testing the new file transmission setup. Fixing bugs in the business process. Working on new FTP setup requirements.

Environment: IBM Sterling B2B integrator 5.2/5.3, Gentran, Sterling File gateway 2.2.2, Oracle E-Business Suite, SAP, FileZilla, Remote Desktop Connection, Sterling Connect Direct, FTP, FTPS, AS2, SFTP.

Role: EDI Consultant

Responsibilities:

  • Involved in gathering requirements for new enhancements.
  • Used Service now for change management, project management, and logging EDI Tickets.
  • Created5010 Companion guides for HIPAA EDI transaction sets 837i, 837p, 837d, 835, 270,271, 276,277, 834.
  • Createdcrosswalksby analyzing the base maps provided by the client.
  • Performed reverse engineering of maps logic into business documents.
  • PerformedGap Analysis that exists between the present system.
  • Created 270,271, 834, 835, 837 maps to step up and step down from 4010to5010 versions.
  • 270,271,835,837 these transactions are from Hospitals to Payers and vice-versa and 834 is from Providers to Payers.
  • Created map flows using EDIFECS Map Builder.
  • Created various segment levels on the map using companion guides.
  • Created both complex and simple mappings.
  • Set up a Company profile and trading partner information.
  • Created Enveloping for Trading Partners using EDIFICE.
  • Develop maps to convert from X12 to Flat files/XML formats and vice-versa.
  • Worked on troubleshooting any errors encountered during the creation of the map.
  • Resolved Translated files loading issue into FACETS system.
  • UsedEDIFECS Spec Builder to build, modify and customize the implementation guidelines as per the new business rules.
  • Created Routes for file pick and translation and validating.
  • Involved in complete Migration from GIS 4.3 to EDIFECS Server.
  • Monitored and resolved translator errors, data problems, communication issues, etc.
  • Used transaction management for monitoring the errors and exceptions and automating the error handling.
  • Moved all trading partners from GIS to EDIFICE.
  • Developed custom Unix scripts to fetch, load, and move files from one server to another.

Environment: EDIFECS 6.5 Spec Builder, EDIFECS Map Builder, Gentran Integration suite, EDIFECS Transaction Manager, XEngine, Text Pad, Unix Script, JavaScript.

Role: EDI Developer/Production Support

Responsibilities:

  • Creating Map with Trading Partners specifications.
  • Created the business processes in GPM using various services and adapters.
  • Configured and used various adapters in the business processes which includes web sphere MQ, File System, various HTTP adapters, connect direct adapters, etc.
  • Creating various setups for trading partners which includes creating the AFT partners, Configuring it to use for various custom protocols which include FTP, SFTP, FTPS, Custom processing, Connect direct.
  • Deploying components to different Property Files for onboarding various requirements.
  • According to the Trading Partners specifications working on the map with their Implementation Guidance.
  • Migrated the components to various Environments and finally responsible for deploying the components to production.
  • Analysis of defects in the Joint unit testing and fixing them very frequently used the tool Mercury QC.
  • Used Application Integrator for building various inbound and outbound Maps.
  • Mapping experience includes XMLs, Positional, CSV,EDI, Database mapping.
  • ImplementedEDITransactions like 810, 820, 850, 856, and 997's.
  • Worked very well on SFTP and FTP connections creating SSH profiles for trading partners.
  • Developed XSLTs for transforming the XML according to the requirement.
  • Having experience in data encryption and decryption deploying the public keys and using them for encryption using them in business processes and AFT mailboxes.
  • Migrated major flows from GIS 4.3 to SI 5.2 and was responsible for testing and deployments to different environments.
  • Strong analytical skills, good written and verbal communication skills. Having good experience interacting with different teams of different companies on a daily basis.
  • Making well-detailed Business communication documents for the various projects using the Microsoft Visio software.
  • The document will explain the entire process along with all the components used.
  • Interacting with different application teams for production as well as nonproduction on a daily basis for different Joint unit testing and for production-related issues.
  • Ensure delivery of quality in line with committed deadlines.
  • Ensure On-time delivery of all reporting requirements of the Client.
  • Support the team chair and provide leadership when appropriate.
  • Take active responsibility for achieving the team's mission and goals.
  • Responsible for looking after any sort of errors in the production server and fixing the errors.
  • Single point of contact for all the application teams and vendors for all the production-related things at the offshore timings.
  • Responsible for checking the major critical payment transactions run on a daily basis.
  • Weekly production server maintenance includes restarting the servers in a multi-cluster system.
  • Checking the database and File system for storage utilization and clearing the documents/logs in the File system, Perimeter server monitoring.
  • Connecting Database and network teams if any issues are found.
  • Monitoring the storage/Logs of Production and Nonprod on a daily basis for any issues.

Environment: s: GIS 4.3, SI 5.2, MS Visio, MS Outlook, Data Base and HTTP, FTPS.

Role: EDI Developer

Responsibilities:

  • Analyzed the business requirements, functional specifications, system requirements process flows, and test specification documents.
  • Tested various EDI files and made sure they are loaded to back end systems
  • Generated manual reports for missing Acknowledgments.
  • Worked with Team lead for reconciliation and preparing MIS reports
  • Prepared Trading Partner Onboarding document.
  • Involved in setting up HTTP, FTP, FTPS communication protocols.
  • Prepared EDI Test cases for the testing team.
  • Assisted Project manager in creating Project Plan.
  • Got Trained on EDI systems.
  • Loaded files from Trading Partner FTP site to Gentran EDI system.
  • Used TOAD to look up Oracle Tables for testing purposes.
  • Restarted test EDI environment server during the maintenance phase.
  • Got Trained on handling Production issues for clients.

Environment: Gentran,EDI,X12,TOAD,FTP.

We'd love your feedback!