We provide IT Staff Augmentation Services!

Edi Sterling Integrator Consultant Tcs Resume Profile

Summary of Experience

  • Over 9 years of experience in the IT industry that involves the complete Software Development Life cycle from analysis, design, coding, testing implementation of Data Integration applications.
  • Experience in Integration of HealthCare, Retail, Logistics, Supply chain management, and Insurance.
  • Possess development and implementation experience in EDI ANSI X12, HIPAA, EDIFACT, XML, Sterling Integrator, Sterling's Gentran Server on UNIX, Gentran's Integration Suite GIS XML/XSLT applications.
  • Responsible for reviewing and contributing to designs.
  • Expertise in Java based Web Services for Application Integration using messaging and adapters.
  • Proficient in Data base design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships.
  • Loading data from flat files into database tables using SQL Loader.
  • Experience in working with TIBCO with EAI/EDI applications.
  • Automating data loading, extraction, mapping, conversion, reports generation using SQL, PL/SQL, and UNIX Shell scripting.
  • Hands on expertise in using various adaptors File, Schema, XML, Database, Email, FTP etc. .
  • Developed data translation map and business processes to integrate the data.
  • Experience with EDI ANSI X12 documents including 850, 855, 856, and 810.
  • Ensured that the product developed satisfies the business requirements using through unit testing procedures
  • Strong Working experience with Transactions 830, 835/837, 845, 850, 846, 856, 862, 214, 270/271, 276/277.
  • Experience in creating maps using Application Integrator, 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.
  • Extensive Experience in SQL/PL SQL, Stored Procedures and Triggers.
  • Extensive Experience in preparing Test Plans, Test Scenarios, Test Cases and executing them based on the Business rules and System requirements.
  • Ability to do independently as well as in a team and experience in coordinating with different groups in a project.
  • Excellent Written verbal Communication, Interpersonal and Organizational Skills.
  • Manage development and migration of EDI projects in BizTalk and Gentran environments.

Technical Skills:

Mapping Tools

Sterling Integrator 5.0/5.2, Gentran 5.1/5.3/6.0/GIS, Sybase EC Map,

TLE Server 4.2, and GXS AI Mapper

Industry Standards

ANSI X12, EDIFACT, VICS and HIPAA

EDI Tools

EDISIM 4.0, EAI, XMLSPY, XSD, DTD

SQL Editors

SQL NAVIGATOR, TOAD, SQL ANALYSER

Reporting Tools

Crystal Reports, Data Reports

EDI Transactions

810, 835, 837, 850, 856, 860, 210, 214, 220, 270,271, 276, 277, 278, 940, 945.

Programming Languages

C, C , Java, Visual Basic, Shell Scripting, SQL, T-SQL, PL/SQL, BPML, XSLT, VBA.

Web Development Tools

HTML, JavaScript, Ajax, IIS 6, SharePoint Portal Server, Dream Weaver.

Databases

Oracle 10g/9i/8i, MS SQL Server 2008/2005/2000, MySQL, MS Access.

Operating Systems

Windows 2003/2000/NT, FreeBSD 4.5, Sun Solaris 5.8, AIX, Linux

Networking

FTP, HTTP, SFTP, HTTPS, FTPS VAN, AS2, TCP/IP, and SNMP.

Other Software

XML, XSLT, ClearCase, SQL Loader, ULTRAEDIT, Toad, JMeter,

CLEAR QUEST, SAP, WS-FTP

Work Experience

Confidential

EDI Sterling Integrator Consultant TCS

Responsibilities:

  • Shadowed the Installation of SI, SSP, and QSS on Production server by IBM team.
  • Attended the meetings conducted by IBM to review the Walgreen's design.
  • Currently, in the process of making changes to the Development work to come up with new business process flows with QSS.
  • Setting up connectivities in Production server which are Connect: Direct, AS2, SFTP and FTP.
  • Setting up the AS2 profiles for all the Trading Partners.
  • Creation of Certificates for AmeriSource Bergen ABC partner AS2 onboarding.
  • Tested an inbound/outbound flow for ABC partner.
  • Updating codelists and maintaining them for new trading partners.
  • Incorporating new changes in both inbound and outbound transactions maps .
  • Knowledge Transfer from IBM on the working of QSS and its impact on the current design solution provided by Walgreens.

Environment: Mainframe, Gentran, Sterling Integrator 5.2.4, UNIX, Putty server, Ultraedit, winSCP, CVS client, RAD

Confidential

EAI/EDI Developer

Responsibilities:

  • Created new wsdl for the portal web interface.
  • Developed new maps for Member Services interface for both the Find-A-Doc and Certificate of Coverage.
  • Tested and deployed to development environment and QA environment
  • Configured adapters, services, service configurations and protocol setups as per business needs.
  • Setup Trading Partners, Business agreements in Business Connect.
  • Set up various communications using Protocols FTP, HTTPS, and SFTP with trading partners.
  • Made changes in PL/SQL code embedded in the database packages.
  • Collaborated with vendors, trading partners, and internal functional teams to define EDI requirements.
  • Created the 835 schema version using Specbuilder which was used in mapping for the 835 Prep file automation.
  • Gentran tool was used to do the mapping for the 835 file.

Environment: TIBCO, Gentran Integration Suite 4.2, SpecBuilder, TOAD, PL-SQL, Ultraedit

Confidential

Sterling Integrator Developer

Responsibilities:

  • Developed/Modified EDI maps using Gentran Integration Suite/Sterling Integrator's Map editor.
  • Created business process for both inbound and outbound transactions to SAP Order to Cash OTC and other internal applications as per business needs using Graphical Process Modeler GPM and BPML in Gentran Integration Suite/Sterling Integrator.
  • Configured adapters, services, service configurations and protocol setups as per business needs.
  • Set up Trading Partner Identities, Document exchange, Packaging and Envelopes for both inbound and outbound partners.
  • Set up various communications using Protocols HTTP and AS2 for the trading partners.
  • Collaborated with MFGpro for gathering SAGE requirements.
  • Provided technical support of the EDI application, mappings, and interfaces, and testing.
  • Translating the data from ANSI Positional to IDOC for the SAP inbound process using the translator.
  • Setup new EDI trading partnerships and created Trading Partner profiles and Management of Communities in GIS 4.3/SI 5.2.
  • Developed PL/SQL packages to extract, validate and populate document tracking, auditing, and maintenance application.
  • Created and modified BPML to handle document archiving, failure notifications, acknowledgement reconciliations, and transaction metrics reporting.
  • Trouble-shooted and resolved XSLT mapping issues and adapter failures/discards.
  • Created process flow, de-enveloping and routing process for 845 Cars feed for various trading partners.
  • Created Shell scripts and database scripts to automate document tracking functionality.
  • Used Ultraedit to read the EDI input files.

Environment: Sterling Integrator Map Editor 5.2, Gentran Integration Suite 4.2, MS SQL Server, SAP, Ultra Edit.

Confidential

Integration Applications Developer

Responsibilities:

  • Created maps to translate data from X12 format to web service messages using Application Integration mapper.
  • Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator's Map editor.
  • Created business process for both inbound and outbound transactions to SAP Order to Cash OTC and other internal applications as per business needs using Graphical Process Modeler GPM and BPML in Gentran Integration Suite/Sterling Integrator.
  • Configured adapters, services, service configurations and protocol 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.
  • Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc.
  • Extensively worked with the EAI to do mapping for the transactions 810, 820, 824, 832 and 835.
  • Set up and configured the AS2 communication protocol for exchanging the EDI documents for trading partners with digital Signature.
  • Setup new EDI trading partnerships and created Trading Partner profiles and management of communities in GIS 4.3/SI 5.2.
  • Wrote UNIX shell scripts to automate FTP and SFTP process.
  • 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.
  • Created shell scripts and database scripts to automate document tracking functionality.
  • Scheduling of the scripts is done using Tidal and Crontab.

Environment: Sterling Integrator 5.1/5.2, Gentran Integration Suite GIS 4.2/4.3, Gentran server on UNIX 6.0, MS SQL Server SQL, T-SQL , Putty, SAP, Ultra Edit, Solaris KornShell scripting , Perl.

Confidential

EDI Consultant

Responsibilities:

  • Coordinated with Business users in business requirement analysis, system analysis Design and development of the Integration application that supported Purchase Orders, Inbound Receipts, Advanced Shipment Notification ASN , Inventory snapshot etc.
  • Extensively wrote UNIX shell scripts to automate Advanced Shipment Notification ASN procedures. Used AWK and SED utilities to handle trading partner files.
  • Developed FTP and HTTP file posting programs using Korn shell scripts.
  • Involved in creating PL/SQL procedures for writing the data into a flat file using UTL FILE.
  • Attained good knowledge of Supply Chain management in Logistics sector.
  • Developed web reports using ASP, VBScript, and HTML.
  • Created Excel, PDF, and HTML outputs for various operational and analytical reporting.
  • Involved in query tuning using Explain plan and TKPROF.
  • Involved in creating complex queries Using joins, sub queries and correlated sub queries.
  • Created maps to translate data from X.12 format to SAP IDOC formats for Orders, Order confirmations, ASN's, Inventory snapshots, and Inventory Transfers.
  • Created the work flows to accomplish the business process models using BPML in GIS.
  • Improved the models to overcome frequent issues.
  • Worked with GIS AS2 edition for exchanging the EDI documents for trading partners with digital signature.
  • Migrated Gentran 856asn, 810invoice, 846 Inventory Snapshot from Sybase EC Map to Gentran Visual Maps
  • Used SAP transactions BD87, WE19, W05, W02, and WE20 to process inbound and outbound IDOCS through RFC.
  • Experience in Troubleshooting of IDoc Errors.
  • Involved in Scheduling and monitoring of SAP Batch jobs Processing programs.
  • Experience in Validation and Sanity Testing of EDI X12 to SAP IDocs.
  • Performed Unit Testing to test the functionalities.
  • Used TOAD to view Database Objects, view and develop Database Scripts.

Environment: Gentran Integration Suite 4.2/4.3, Gentran Server on Unix 6.0, GIS, Unix Shell Scripting, Forms 6i, Reports 6i, TOAD, Ultra edit, EDISIM and HP UNIX, Sybase EC Map, MS SQL Server 2005.

Confidential

EDI Consultant

Responsibilities:

  • Created EDI X12 820, 821, 823, 827, 812, 828, and 829 Payment transaction maps for various trading partners.
  • Created IG's Applications Based on the customer requirements.
  • Translating the data from ANSI X12 to text format in inbound process using the translator.
  • Created maps for Application to Application
  • Sending an Acknowledgment EDI X12 997 Functional Acknowledgment to the trading partners.
  • Created new synonym table based on the customer requirements.
  • Translated the data from text to ANSI X 12 formats.
  • Receiving an Acknowledgment EDI X12 997 Functional Acknowledgment from the trading partner.
  • Creation of implementation guides to document detailed exchange requirements such as structures, timing and business rules GAP analysis documents.
  • Set up new trading partners and maintain existing partners.
  • Applied Enterprise Application Integrator EAI mapping some of the X12 transactions.
  • Involved in up gradation of Gentran server 3.2 to Gentran server 5.1
  • Developed SQL queries to interact with the lifecycle database and provided monthly capacity reports reflecting on the utilization of EDI infrastructure.
  • Developed and upgraded EDI maps for transactions 820, 810, 821, 823, 827, 828, and 812 using the X12 standard..
  • Maintenance of EDI Documents, data managers, and Gentran life cycle Database.
  • Creation of trading partner files/interfaces.
  • Developing new maps and modifying existing maps.
  • Creation of ODBC mapping guidelines.

Environment: Gentran Server for Windows, TIBCO, EAI, Gentran Integration Suite 4.3, Sterling Integrator 5.1, FTP, SFTP, AS2, SAP, Ultra edit, BizTalk, EDISIM UNIX script writing for both communicational and file handling, UNIX.

Confidential

EDI Analyst

Responsibilities:

  • My basic involvement in this project is to build maps using Application Integrator EAI and test the complete system using Enterprise.
  • Mapped various transactions from ANSI X12 format to Health Partners internal formats. 837P, 837I, 837D, 270/271, 835, 278, 276/277, 820, HCFA, UB, ADA.
  • Developed internal XML structure for processing claims and eligibility transactions.
  • Used Spec Builder for analysis of the HIPAA data.
  • Tested 270/271 transactions with various trading partners.
  • Extensively involved in unit and integration testing various programs and maps.
  • Setting up new trading partners.
  • Writing custom functions in AI's Meta language which was used by various maps.
  • Customized various standard modules.
  • Involved in unit testing and integration testing with the internal claims system.
  • Tested transactions with various trading partners.
  • HL7 mapping was also done for some pharmacy claims.
  • Setup relationships and configuring bridges in Enterprise.
  • Used CVS for version controlling maps.
  • Mapped various transactions from the standard ANSI X12 formats to XML and SAP I-Docs.
  • Involved in design, development and testing of complete integration system.
  • Created Forms for interfacing with GIS.
  • Involved in unit testing and integration testing with SAP.
  • Implemented error handling to track different errors and information like unmarshalling, connection status and errors in business rules. Worked with Alert Agents like email, pager.
  • Routing data to GXS and Sterling VAN's for various trading partners.

Environment: Perl 5.8, Oracle, XML, TIBCO, Shell Programming, GXS Enterprise 7.0, UNIX Scripting, Application Integrator AI 4.1, XML plug-in, HIPAA plug-in and Test Director, EAI, Clear Case and XML Editor, UNIX, Windows Server 2000.

Confidential

Membership/Claims System

EDI Developer

The Fresenius medical care provides healthcare products and services related to dialysis and lever support. Fresenius assists nursing homes and senior housing communities with healthcare services. The application consists of 3 major sub systems Membership, Claims and Inter-plan teleprocessing system that support Insurance business.

Responsibilities:

  • Developed conversion program to convert file EDI format to HIPAA Proprietary format.
  • Managing Membership Enrollments for corporate group accounts and Individual membership accounts and Coordinating with Claims ITS team.
  • Loading Eligibility Data for membership into system from the state, vendors using Proprietary format, ANSI 834 through EDI, and web interface.
  • Setup process schedules to automate the translation transmission of documents
  • Performed Unit and system testing on all EDI transactions both inbound and outbound.
  • Applied EAI to perform the claims transaction mapping.
  • Implemented HIPAA/EDI Transactions like 834, 835, 837, 276 and 277.
  • Developed and maintained internal reports, tools and extranet sites.
  • Converted maps from 3010 versions to new version 4010 4030 .
  • UNIX script writing for both communicational and file handling.
  • Involved in creating new Trading Partner.
  • implemented 270/271 Health Care Eligibility Benefit Inquiry and Response transactions
  • Involved in dealing with trading Partners and conveying the implementation guidelines and specifications.
  • Configured Finalist software for Membership and Claims system.
  • Worked on integration with new trading partners using GENTRAN: SERVER for UNIX 5.1v.
  • Maps were created in 3.2 version upgraded to Gentran server 5.1 version.
  • Verified data formats in new version of Gentran server.
  • Modified maps to support newer versions
  • Creation of application layout files
  • Maintenance of EDI Documents, data managers, and Gentran life cycle Database.
  • Worked with configuration of data managers.
  • Responsible to verify if all data was successfully processed and trouble-shooted any failures during translation and addressed the issues to the team.

Environment: Gentran Server, TIBCO, EDI X12 HIPAA Transactions 270/271, 276,277, 834, 835, 837 , FTP, EAI, Windows NT

Confidential

Software Developer

Responsibilities:

  • Identifying functional and non-functional requirements, analyze the system, provide suggestions, and design as per requirements and test the design.
  • Identifying database requirements and was involved in designing of database for various modules.
  • Created stored procedures, functions and packages for applying the business rules.
  • Involved in writing PL/SQL procedures, packages and triggers
  • Developing Forms using forms 4.5 and Reports using Reports 2.5
  • Developing Involved in Preparing the User Functional Requirement and detailed design.
  • Performed Unit testing for the Developed component.
  • Involved in Development and Implementation of Plant Maintenance modules.
  • Used features like PL/SQL record inserts and updates.
  • Performance tuning and optimization achieved through the management of indices, query execution plans and optimizing the SQL scripts.
  • Developed single form to run all the Reports as central point.

Environment: Oracle 7.x, SQL Plus, PL/SQL, SQL, C, UNIX, PL/SQL, Developer2000, Windows 2000/XP.

Hire Now