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:

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.