SUMMARY

• Technically sophisticated professional with 6+ years of Experience in Design and Development of EDI applications. Experience in working with transactions including the analysis of trading partner Requirement Gathering, Gap analysis, Implementation and testing.
• Strong experience in the Java, analysis, development, unit testing, trading partner testing of EDI - Integration applications that involves complete Software Development Life Cycle (SDLC) from Analysis, Design, Testing & Implementation.
• Experience in EDI business requirement and then prepared the MRS and developed maps for transaction sets 830,850,852,855,856,810,820,940,943,944,945,946, 947 and 997 etc.
• Extensive experience in MS SQL Server 2016/2014/2012/2008 R2Business Intelligence in SQL Server Integration Services, SQL Server Reporting Services, and SQL Server Analysis Services.
• Strong experience working with BCP, DTS, SSIS packages, creating jobs and linked servers for MS SQL Server/Sybase databases.
• Hands on experience working on EDI based Middleware tools like Tibco Designer, EDIFECS transaction manager, EDIFECS Spec builder, XEngine, Jenkins, Sterling Integrator, Sterling Gentran Integration Suite (GIS), Gentran, Sterling file gateway, Sterling Control Center,GXS, BizTalk, BizManager.
• Worked on different EDI standards like ASC X12, EDIFACT, TRADACOMS & HIPAA.
• Experienced in EDI implementations- new EDI Map development and testing, Standard upgrades, translator upgrades, conversion to new ERP systems by preforming GAP analysis for new systems and EDI re-certification testing and involved in 24x7 production support. Experience working on different File formats like ANSI X12, XML, CSV, SAP IDOC, Positional and other Client Proprietary formats.
• Excellent Knowledge of HIPAA 4010,5010 Standards, and HIPAA code sets like ICD-9, ICD-10 CODING and HL7.
• Expertise in Database Design, development of SQL Scripts, Stored Procedures, Functions, Packages, Triggers using Oracle PL/SQL, T-SQL, DB2 SQL PL, etc.
• Experience in ETL design, development and maintenance using SQL, PL/SQL on UNIX Platforms.
• Experience in analyzing and creating new EDI data file using Edifices Spec Builder. Create, edit, test and document Edifices Spec Builder guidelines and Error Severity configuration files.
• 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.
• Excellent Knowledge on HIPAA 4010, 5010 Standards, and HIPAA Code sets like ICD-9, ICD 10 CODING and HL7.
• Expertise in mapping business requirements, development, implementation, integration.
• Provided 24X7 production support and also involved in various knowledge transfer sessions.

TECHNICAL SKILLS

EDI Translators: Gentran Integration Suite (GIS) 4.1/4.2/4.3, IBM Sterling Integrator 5.2/5.1/5.0, Gentran server 4.0/5.3/6.0/6.1.

EDI Mapping Tools: GIS Map Editor, Sterling Map Editor, EDIFECS SpecBuilder

EDI Standards: EDI X12(ANSI), EDIFACT, TRADACOMS, HIPAA, ODETTE, SAP IDOCS

EDI Transactions: 810,820,832,846,850,852,855,856,860,867,870,875,940,943,945,997

Databases: SQL Server 2005/2008/R2, Oracle 9i/10g/11g, MS Access, DBMS

Programming Languages: Java, SQL, PL/SQL, JavaScript, Gentran Scripts, Shell Scripting.

Communication Protocols: AS2, FTP, FTPS, HTTP, HTTPs, SFTP via VAN (GXS, Sterling), SMTP

Operating Systems: Windows 2003/2008/NT/XP, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Thomasville, GA

SR. EDI ANALYST/Admin

Responsibilities:

• Coordinated with the client to gather the requirements and then took the responsibility of analyzing the business requirement on B2B EDI domain for the client.
• Identified the opportunities to improve the EDI HL7, 277, 276, 835 and 837 processes.
• Interacted with the trading partner and business user and then made the changes accordingly.
• Installed and maintained SQL Server Reporting Services SSRS 2008 R2/2012, 2014, 2016.
• Relational database and high performance T-SQL development methodologies, designing and building complex data warehouses and cubes from multi-data sources for business consumption.
• Created inbound maps to translate from EDI ANSI X12 format into Database tables and flat files.
• Analyzed EDI business requirement and then prepared the MRS and developed maps for transaction sets 830,850,852,855,856,810,820,940,943,944,945,946, 947 and 997 etc.
• Created the EDI implementation guide by analyzing the previous production data.
• Involved in Development, Debugging, Analysis, Deployment of Mapping and Business Process.
• Involved in maintaining and developing EDI documentation.
• Developed Business processes by using several services and Adapters in Sterling Integrator, Using SMTP, File system adapter, Light Weight JDBC Adapter, Mailbox services etc.
• Worked on EDIFACT Messages like ORDERS, ORDRSP, DESADV, INVOIC, PAYORD, DELJIT and DELFOR.
• Responsible in setting up various communication protocols like AS2, HTTPS, FTP, SFTP and SMTP with trading partner.
• Creating Partner Profile setup in SAP Environment and testing whether IDoc has been generated.
• Worked on User Administration Application, use cases and SSIS packages functional and technical design documentation.
• Used SSIS to transform and load data into SQL database via FTP from XML files, MS Excel as source data
• Created complex views by joining more than 20 tables from different SQL instances using Linked Server
• Responsible for developing Business Process using GPM and BPML and monitoring it.
• Responsible for creating inbound and outbound processes for Trading Partner using AS2 communication protocol.
• Implemented Static/Dynamic routing rules in Sterling File Gateway.
• Involved in extensive use of SQL to validate the result from the data base through the use of different SQL Queries.
• Involved in installation Sterling Connect: Direct on WINDOWS environment and troubleshooted issues.
• Performed Quality checks and SI reviews before going live into production.
• Involved in testing Client/Server based applications on multiple levels of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Responsible for monitoring of data transfer activities, adapter status and server status by using Sterling Control Center.
• Tested in a quality environment to make sure that the production system is not affected after deploying it to the production.
• Provided production support by documenting tickets and communicating with trading partners.

Environment: Sterling Integrator 5.2, Ultra Edit, Putty, Linux, Windows, SAP, Oracle, SFB, Connect Direct, Connect Enterprise, SQL, Sterling File Gateway 2.2, Sterling Control Center 5.2

Confidential, Seattle, WA

EDI Systems and Network Administrator

Responsibilities:

• Defining business process requirements and business flows and worked on Java.
• Coordinating with the client on a regular basis to gather the required business requirements.
• Created Stored Procedures, Queries, SQL Jobs and Tables in SQL for process flow of the EDI data we received in and out for our Trading Partners.
• Involved in development of maps of different transaction sets like 810,820,830,850,855,856,862,867,879,875,880 and 997.
• Involved in creating setups using HTTP, AS2, and SFTP in GIS.
• Created a process to export Commercial Invoices in XML format using for XML path in SQL.
• Use T-SQL for developing complex stored procedures, triggers, tables, user functions, relational database models and data integrity, SQL joins and query writing. Debugging existing stored procedures and database objects and solve problems
• Designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server
• Creating SSIS package to load data/information using Execute SQL Task, for each loop container, Data flow task, Send mail task.
• Created documentation for release planning and primary contact for SIT, UAT and go Live activities.
• Responsible in creating mailboxes for various trading partners and setting up communication with them.
• Design and development of Interfaces & XML reports within Oracle EBS - Including preparation of Technical design document, Installation document and test scripts.
• Setting up trading partner guide and routing information.
• Constantly monitoring and debugging the processes to maintain a steady GIS system.
• Assigned permission by creating GIS users based on their roles.
• Created detailed functional specification documents.
• Involved in mapping from one format to the other using map editor.
• Created various business processes using various services and adapters based on the client requirement.
• Involved in the implementation of certificates.
• Involved in testing and end user support at the time of monitoring.
• Responsible for creating code lists entries, routing rules.
• Supporting day to day operations.
• Involved in monitoring production by proving support to the production team and also in trouble-shooting the issues.
• Responsible for analyzing, implementing and testing all EDI process.

Environment: Sterling Map Editor, Windows Server, Linux, Quality Center, Mainframes, SAP, Gentran Integrator Suite 4.3

Confidential, Nashville, TN

EDI Admin/Production Support

Responsibilities:

• Gathering the requirements from the stakeholders
• Worked on HIPAA transactions 270, 271, 278, 276, 277, 834, 835, 837 (I, P, D).
• Analyzed maps and converted them from 4010 to 5010 version.
• Worked on PL/SQL Stored Procedures, Functions, Stored packages, Recursive PL/SQL routines, database triggers.
• Used EDIFECS spec builder to manage claim transaction and billing application requirements.
• Involved in Validation of HL7 for 837 , Institutional, Professional, Dental and COB.
• Demonstrating technical description of HL7 messages supported the HL7 segments and fields and how the HL7 messages relate to the front-end application and data base.
• Experience working with HL7 version 2.x, and 3.x, EDIFACT, ANSI X12, XML Schemas etc.
• Developed Business processes using GPM for inbound and outbound processes
• Experience in Heath information Exchange (HIE) integration projects, primarily centralized HIEs.
• Extensive experience working in a cross-functional team environment including different geographical location teams including offshore teams
• Involved in new Trading Partner setups with AS2, FTP and Sterling VAN.
• Responsible for Creating and Managing the Import and Export MAPs using Application Integrator/Map Editor.
• Assisted developing team with specs and requirements as well as mapping for new and existing Trading Partners.
• Performed sanity, system test, integration test and User Acceptance Test ( UAT ), and provided client with proper documentation.

Environment: EDIFECS, LINUX, Windows, Sterling Integrator 5.0/5.2, TOAD, QTP, Test Director.

Confidential

EDI Analyst/ Developer

Responsibilities:

• Worked on integration with Java and new trading partners using GENTRAN: SERVER for UNIX 5.1v.
• Created Maps in 5.3 version upgraded to Gentran server 6.0 version.
• Implemented other EDI Transactions like 810, 812, 820, 850, 855, 856, 940, 945 and 997’s.
• Converted maps from 3010 versions to new version (4010 & 4030).
• Maintenance of EDI Documents, data managers, and Gentran life cycle Database.
• Involved in creating test cases for the for B2B trading partners.
• Maintenance of EDI Documents, data managers, and Gentran life cycle Database.
• Used AI mapper extensively and converted maps from visual mapper to AI mapper
• Analyzed business process and studied its impact on current system.
• Involved in creating new Trading Partner.
• Resolving issue of failed SQL Agent jobs across multiple server
• SQL Enhancement/New Report by adding new data source system for production and scheduled job for the process
• UNIX script writing for both communicational and file handling.
• Responsible to verify all data was successfully processed and trouble-shoot any failures during translation and address the issues to the team.
• Worked with configuration of data managers.
• Modified maps to support newer versions
• Creation of application layout files
• Verified data formats in new version of Gentran server.

Environment: Gentran Server, Gentran Integration Suite, Application Integrator 5.0, Windows Server, UNIX, AI Map Editor.