SUMMARY

• 7+ years of experience as an IT Analyst and Developer with a background in analysis, design, development and implementation of EDI, B2B integration, production support, testing, implementation, and documentation of information systems
• EDI - More than 6 years of experience implementing EDI solutions using SAP R/3 IDOCs, ALE, Gentran Server in IT, Retail, Logistics, Financial and Healthcare(HIPAA) Industries for various application areas including sales and billing
• Set up and configuration of communication protocols such as VAN, AS2, SFTP, FTPS, for data transmission between client and trading partners.
• Extensive experience in Business Analysis to Translate EDI requirements into functional specifications, create companion guides using Edifecs Specbuilder, and develop logical mapping for Gentran/ ECMap/ GIS-SAP Idoc/ Mainframes
• B2B Integration using Sterling Integrator 5.0, GIS 4.0, 4.1, 4.2, Gentran Server 5.1, 6.0, Sybase ECMap. knowledge in EDI X12 and EDIFACT standards. Worked with Translation tool (WebSphere Data Interchange,SI Map editor ) and mapping.
• Experience in Sterling File Gateway (SFG) Managed File Transfer (MFT) applications to support file transfer protocols i.e. FTP/SFTP, HTTP, and AS2
• Extensive experience in mapping/translation using GIS (Gentran Integration Suite) Application Integrator. The ANSI X12 transactions included 810, 820, 850, 855, 856, 940, 945, 837/835, and 276/277
• Extensive experience in SQL*PLUS, PL/SQL, SQL*LOADER, Stored procedures, Functions, Triggers and packages.
• Experienced in Data Mapping and Data Conversion using Gentran, GIS/SI and EDIFECS tools.
• Developed different types of maps (Inbound, Outbound, Flat to Flat, EDI to EDI, XML).
• Expertise in setting up migration mapping from older versions to newer versions.
• Experience with SAP IDOCS, XML and Internet based EDI.
• More than 5 years of successful, progressive QA Test experience in HealthCare Testing using FACETS
• Expert in Health Care testing, FACETS product, EDI transactions.
• Working Knowledge of different communication protocol such as AS2, HTTP, HTTPS, FTP, and IBM VAN.
• Hands on Experience using various Mercator Adaptors (File, Schema, XML, Database, Email, FTP, etc.)
• Helped in Design & development of ETL processes using Informatica to extract and load data to Operational Data Store, Tactical Data store
• Developed ETL processes using SSIS and SQL scripts to load data
• Helped in migration of legacy OMS/IMS application to sterling OMS application
• Have done configuration, customization, design and development on OMS and IMS Experienced working with File Formats like ANSI X12, EDIFACT, XML, XSL.
• Experience in installation and upgrade of IBM Sterling Commerce OMS, SIM COM
• Good experience in using RDBMS includes Oracle 9i, DB2 UDB, MS-Access and MY-SQL.
• Used regular expressions, UNIX Utilities and shell programming for successful implementation.
• Assisted in enhancing existing business processes, created new ones and managing the promotion through SDLC.
• Strong knowledge of SDLC methodologies such as Waterfall and Agile.
• Very good experience in - trading partner setup / on-boarding, mapping specifications and documentation, troubleshooting, problem resolution, customer / vendor / internal customer data issue resolution.
• Hardworking, enthusiastic, Self-starter, result-oriented team player with an ability to manage multiple tasks simultaneously and efficiently.

TECHNICAL SKILLS

EDI Tools: Sterling Integrator 5.2/5.0, Gentran Integration Suite 4.2/4.3, Gentran Server on UNIX 5.2, 5.3, 6.0 EDIFECS X-Engine, Spec builder, Gentran NT, Connect Direct, AFT, SFG.

EDI Standards Generator: EDISIM 5.0, EDIFECS 6.8

Industry Standards: ANSI X12, EDIFACT, HIPAA, IDOCS and XML

Languages: UNIX Shell Scripts, COBOL, JCL, CL, RPGLE, CLIST, SQL and PL/SQL.

GUI Tools: Visual Basic 6.0. VLTrader.

Database Systems: DB2, Oracle 7.X, Oracle 8, Oracle 8i & Oracle 9i/10g and TOAD, SQL Developer.

Operating Systems: HP-UX 11.0, Windows NT, Windows XP and Linux (Red hat)

Other Applications: ULTRA EDIT, SAP R/3 - 4.6C,Microsoft SQLServer Integration Services ( SSIS )

Protocols: FTP, HTTP, HTTPS, AS2, VAN

PROFESSIONAL EXPERIENCE

Confidential, IL

EDI Analyst/Developer

Responsibilities:

• Created maps to translate data from X.12 format to SAP IDOC formats for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers.
• Set up various communications using Protocols FTP, HTTP, SMTP and AS2 with trading partners.
• Provide functional and technical expertise on the OMS application.
• Involved in Project Planning, coordinating, scheduling and monitoring activities of assigned projects to develop and implement procedures, processes and system
• Worked extensively with SAP IDOCS for all transactions and been a part of full cycle SAP implementation.
• Translating the data from ANSI X12 to text format in inbound process using the translator
• Supported the sterling OMS, COM and SOM application especially the payments/auth/settlement/refund and DSV fulfilment.
• Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
• Understand Business requirements and established EDI Connectivity to various Trading partners.
• Developed XSLT to handle special requirement needing XML translation
• Interpret business requirements and produce technical specifications for map development
• Responsible in providing consulting services to customer on business application requirements needed to support trading partner EDI / Electronic Commerce requirements.
• Coordinated with developers to add custom XSLT and XQuery functions using file imports from RCM application, managed updates to XSLT files
• Sending an Acknowledgment (EDI X12 997 Functional Acknowledgment) to the trading partners.
• Assist in identifying and resolving issues during unit and customer acceptance testing
• Responsible for developing data mapping, data transformation rules, data formatting, and validations using EDI Mapping application.
• Worked with Informatica Analyst tool for setting up Reference table manager for capturing business input for reference lookup tables
• Review project team deliverables for technical consistency and approves prior to client review
• Provide leadership to the mapping and analyst team on best practices and implementation methodologies
• Creating maps in AI mapper and reviewing the code/logic written by the team prior to delivery to the Client.
• Used file transmission tools to ensure files are delivered as expected.
• Working with EDIFACT, X12 standards and SAP IDOC, CSV format s.

Confidential, Rockville MD

EDI Developer/Analyst

Responsibilities:

• Worked on EDI interface testing project involving HIPAA 4010/5010 claims transactions set
• Gathered detailed business and technical requirements and participated in the definitions of business rules and data standards
• Developed EDIFECS mapping, routes, and Test Case/ Use Case for the HIPAA 270/271,276/277
• Facilitated SME interviews and assisted in identifying and analyzing the possible technical solutions
• Developed and upgraded EDI maps for transactions 810, 830, 850,852,270,271,855,856 and 857 using the X12 standard
• Good experience on FACETS CTP (Claims Test Pro) and FACETS Testing .
• Assisted data analyst in analyzing existing reports and identifying iteration metrics
• Migrated partners and maps form GIS to EDIFECS
• Performed unit and system testing on all EDI transactions both inbound and outbound.
• Creation of application layout files.
• Implemented HIPAA/EDI transactions like 834,835,837,276,277.
• Developed routes using EDIFECS Application Manager
• Reviewed all Transactions using EDIFECS Transaction Manager.
• Implemented 270/271 Health Care Eligibility Benefit Inquiry and Response transactions.
• Implemented other EDI transactions like 810, 850, 855, 856, and 997’s
• Involved in migration of 4010 to 5010.
• Good experience in Legacy to FACETS migration and FACETS upgrade testing
• Involved in creating new trading partner.
• Directly worked with Trading Partners is resolving file transmission issues.
• Primary Point of Contact for Clearing houses to ensure daily files are received
• Provide support and maintenance to live interfaces.
• Go-live support for the partners in production
• Worked in production support in fixing the issues and closing the tickets.

Confidential, Round Rock TX

EDI Developer/Analyst

Responsibilities:

• Created Business Process in SCG using BPML, services, and adapters such as FTP, SFTP, Connect Direct, Connect Direct+, and MQ Connectivity.
• Worked on deployments like, creating Mailboxes, Routing Rules, Virtual Roots and FTP Accounts.
• Created setups in MFT (Managed File Transfer) in Axway.
• Provide new features of Sterling OMS and communicate the client on its advantages
• Created the Envelopes on SCG and deployed them into production.
• Configured Active Directory for New User Creation both on UAT and production.
• Created the implementation guides for different file formats (X12, XML, CSV, Delimiter, Fixed ASCII, Database)
• Provided on call production support and work closely with the business and the trading partners and help middleware support team to meet daily needs of all the issues on all levels of priorities by analyzing and giving better solution.
• Did the deployments like import the Maps and Envelopes from QA server to the Production server.
• Did the UNIX application server maintenance the system performance for the daily transaction between the Trading Partner servers.
• Work with the storage team on daily basis and add all the production servers to meet the NFS mounts both on production and non-production servers.
• Resolved issues on daily basis for all the documents, example, 850,860,997,810,832,867,855…etc.
• Worked on Map related issues and suggest the other support teams how rectified the errors by changing the extended rules and also adjusted the input and output values accordingly.
• Created new Maps and did the Deployment of maps into QA server followed by Productions servers respectively.
• Created rules in SCG and worked with open text setups and on the requirement basis changed the rules.
• Monitored and maintained the Data Base Usage, Archive, Index, and Purge and also work with the UNIX team to run the Shell scripts to clean the folders.
• Created and Maintained the FTP, SFTP, AS2 accounts and also used these to route the documents for sending and receiving files and also at times fix the AS2 issues when the interaction between trading partners fails and retrigger all the failed processes from our side and work with the Trading Partner to send and receive the files.
• Created SHH Authorized keys and after creating the SHH Authorized Keys we need to assign them to the FTP accounts in SCG and then deploy them into Production and work with the Trading Partner and make them add the SHH Authorized Keys and do the testing on the Trading Partner server.
• Actively worked with the EDI Development and support teams on the deployments and fixing the issues.
• Monitor the file transfer and check the logs on a daily basis and provide the reports to business and the trading partners on the requirement basis.
• Created and modified the BP’s and deployed them first into QA and then to Production servers on a daily basis.

Confidential

EDI Developer

Responsibilities:

• Involved in map development, testing and implementation for EDI transactions 834 and also Flat files 1000 and 500 byte layouts in Sterling Integrator 5.2/GIS 4.3
• Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator Map editor.
• Implemented Migration project of Enrollments (834’s) from RxCalim to QL systems.
• Responsible for staging of EDI systems in Development, Testing and Production
• Responsible for writing correlation documents for the transactions and creating test files.
• Dealt with implementation of Custom layout maps and multi carrier Clients.
• Responsible for importing and exporting packages from development regions to PROD and vice versa.
• Responsible in Unit Testing and troubleshooting all the maps.
• Extensively worked on ACA project to meet the project goals and requirements.
• Implemented large number correlation documents and maps for the ACA project in short time span and met the timelines successfully.
• Developed test scripts for web services using SOAP UI and worked with XPATH.
• Created UNIX shell scripts to automate the FTP process, handling of data discards, data errors, compliance errors etc..
• Performed End to End testing in SFG to confirm the files are making through the end to end process.
• Involved in setting up of Trading Partners Envelopes for multiple transactions in Sterling Integrator.
• Configured and implemented Sterling File Gateway (SFG) for various TP transactions.
• Created test plans for all maps and coordinated with QA Team on any defects.
• Worked on Change/Heat tickets for any required changes to support the production Environment.
• Create SFG-communities, partners, groups, routing rules, and templates, static and dynamic routing channels and remove special characters from files.