SUMMARY:

• Over 7 years of experience in development, implementation, and production support of EDI, EAI, Web services, and XML applications, Business process design, streamlining, and quality assurance.
• Experience in Retail, Supply chain, Logistics (OMS, TMS, WMS)andHealth Care industry providing Business Process Assessment, Requirements Gathering, Gap Analysis, Implementation and Testing.
• Developed Application Integration physical maps for HIPAA standards and Retail standards - 270/271, 276/277, 278, 835, 836, 837,850, 810, 820, 856, 855, 862, 814 ChangeRequest/Response for both inbound and outbound transactions for various trading partners.
• Experience in developing Business Processes (BP’s) using GPM and BPML.
• Interacting with Business users, gathering and analyzing requirements.
• Experience with Medicare, Medicaid and commercial insurances in HIPAA ANSI X12 formats including 270/271, 276/277, 834, 835, 837, 997 and SNF formats for interfaces and images to third party vendor applications.
• Experienced in EDI Mapping, ANSI X12 and Sterling Integrator (GIS) using Map Editor, Gentran Server for Windows NT, Linux andUNIX using AI Mapper, Visual Mapper.
• Experienced in setting up the basic and advanced trading partner profiles (used AS2, HTTP, HTTPS, FTP, SFTP as a communication protocols) in Sterling Integrator (sterling UI).
• Well versed with Sterling Integrator (GIS UI dashboard), created the Business process (BPML), using Graphical process modeler (GPM), Code lists, Document envelopes, scheduling, Digital Certificates.
• Worked on creating maps involving pulling data from webservices and translate into other formats.
• Implemented several customer EDI transactions, configured workflow for EDI error handling and archiving of IDOCs.
• Experienced in Sterling Integrator (SI) Map Editor,Gentran Visual Mapper and Gentran Application Integrator.
• Experienced working with EDIFECS SpecBuilder and EDISIM in creating the Implementation guideline, test data and compliance checks.
• Designed and developed technical mapping specs for various EDI transactions.
• Experience working with various data files such as ASCII files, XML files, DB tables etc.
• Well versed with Retail and HIPAA transactions.
• Performed UAT testing for HIPAA 4010 and 5010 projects including legacy testing and HIPAA requirements and compliance mandates. Unit testing documentation developed using Excel.
• WroteUNIX and Perl data extraction and automation scripts.
• Good knowledge of Oracle RDBMS with proficiency in writing SQL queries and PL/SQL Procedures.
• Excellent analytical, interpersonal and communication skills with aptitude to assimilate new technologies.
• Excellent ability to work in groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

TECHNICAL SKILLS:

EDI Standard: EDI X12 (ANSI), EDIFACT, XML, VICS, BPML

Transaction sets: X12 - 835,837,270,271,276,277,278,204,210,214,410,834,810, 814, 820, 830, 832, 850, 846, 855,856,857,862,879,875, and 997

Application Server: Gentran Server 5.3, 6.0, 6.1, Sterling Integrator 5.0/5.1/5.2 (GIS 4.2/4/3)

Mapping Tools: AI Mapper, Visual Mapper, Map Editor.

Programming Languages: SQL, PL/SQL, C, Java, Cobol, Unix Shell Scripts (Korn/Bash), XSLT

Web Technologies: XML, HTML, XSLT, Web services

Testing Tools: QTP 9.2, QualityCenter 9.0/10.0, Win Runner 7.5, Load Runner 7.8, Rational Clear Quest, Claredi

RDBMS: Oracle 8i/9i/10g, MS SQL Server 2000/2005, DB2, MySQL, Toad

Development Tools: Ab initio, Cognos Report net

Operating Systems: Windows 2003/2000/NT, MVS, UNIX, LINUX

Packages: MS Office, CVS, PVCS, adobe master collection

Communication Protocols: FTP, HTTP, SFTP, SMTP, Light weight JDBC, TCP/IP,VAN, PGP, PKI

Other Tools: PUTTY, WS FTP, UltraEdit, Telnet, control - M,EDIFECS Tools, BMC Remedy tool, DB Visualizer, AES Routing tool.

PROFESSIONAL EXPERIENCE:

Confidential, Houston TX

Sterling Integrator Consultant

Responsibilities:

• Analyzing new EDI Implementation related requirements.
• Developing maps, envelopes and communication elements to support EDI/XML Data Feeds.
• Interaction with Trading partners and Application Teams - Providing test data, coordinating test and implementation dates.
• Support system testing as requested for User Acceptance.
• Migrated Gentran Server 6.1 maps on to Sterling Integrator 5.2.
• Provide assistance that is required by the Functional Support team during testing, implementation and transition.
• Interaction with Business Analysts in understanding the scope of new developments.
• Trouble shoot data errors from the system.
• Research and resolve trading partner data quality issues.
• Build promotion packages for the purpose of implementation of new or enhanced process to the SI production environment.
• Monitor SI Production/Test Environments for day-to-day health checks, disk space, utilization monitoring etc.

Environment: Gentran Server 6.1, SI 5.1, SI 5.2, Linux, ultraedit, Win XP, UNIX, FTP, SFTP, HTTP, SMTP, XML spy,pgp encryption and decryption, HP Quality Center, PPM tool, FileZilla, PL/SQL Developer.

Confidential, Bartlesville, OK

GIS Consultant

Responsibilities:

• Interacted with the trading partners to set up new trading partner relationship and resolve the production issues related to transaction 214, 810, 820, 823, 832, 850, 852, 856, 860, 875 and 997 on daily basis.
• Created new maps for various transactions using Gentran Integration Suite/Sterling Integrator for both inbound and outbound transactions like 830, 850, 856(Pick and Pack, Standard ASN), 860, 810, 814, 820 and 865.
• Created business process for both inbound and outbound transactions to SAP and other internal applications as per business needs using Graphical Process Modeler (GPM) and BPML in Gentran Integration Suite/Sterling Integrator (Sterling UI).
• Based as per business requirements configured adapters and services. Created Code lists for various code conversions in sterling UI dashboard.
• Configured JDBC Adaptor to pull data from data base and vice versa. Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator’s Map editor.
• Analyzing the Business processes, AES Router jobs and moving them to new P66 environment making sure that all the connections are pointed to Phillips66 new environment.
• Did performance tuning and enhancement/scalability of Gentran Server.
• Performed migration of maps, BP's, service configurations, and adapters from Gentran Server to Sterling Integrator
• Configured and implemented Sterling file gateway process. Configured adapters, services, service configurations and AS2 setups as per business needs.
• Created new Router jobs which includes SSH profile setup (includes Remote profiles, Known host key, User Identity key) in Sterling Integrator dashboard and also used pgp encryption and decryption.
• Developed SQL queries to interact with the lifecycle database and provide monthly capacity reports reflecting on the utilization of EDI infrastructure.
• Created maps to translate data from X.12 format to SAP IDOC formats for Orders, Order confirmations, ASN’s, Inventory snapshots, and Inventory Transfers.
• Communication with external vendors in setting up new interfaces and also while troubleshooting.
• Creating digital certificates for the new company to import them in business process.
• Worked on creating FTP profile setup.
• Updated Code list and also Business process (BPML) using Graphical process modeler (GPM) for Inbound and Outbound flow in Sterling Integrator 4.3/5.1 (Sterling UI).
• Updated SAP suite adapters and tested connection.
• Monitoring Business processes, FTP, File system, SFTP job failures in GIS dashboard (Sterling UI).
• Providing guidance and assistance to the team members for the Requirement analysis and development.

Environment: Gentran Integration suite (GIS 4.3), Sterling Integrator 5.1, Ultraedit, Microsoft Visio, Win XP, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, XML, pgp encryption and decryption, DB visualizer, BMC Remedy tool.

Confidential, Maumee, OH

EDI Consultant

Responsibilities:

• My Primary responsibilities include creation of new maps using Sterling Integrator Map Editor in GIS and in Gentran Server using Visual Mapper.
• Migration of Gentran maps(850, 855, 856, 810, 862, 830,) to Sterling Integrator (GIS v 4.2).
• Created Code list, Envelopes and Business process (BPML) using Graphical process modeler (GPM) for Inbound and Outbound flow in Sterling Integrator 5.0/5.2.
• Monitoring of Business processes and troubleshooting.
• Developed Advanced Shipment Notification (ASN - 856) from the Less than truck load(LTL), Truck Load(TL), and Parcel shipments for standard and pick/pack ASNs.
• Configured and implemented Sterling File Gateway (SFG) for various TP transactions.
• Providing guidance and assistance to the offshore team member for the Requirement analysis and development of Maps.
• Requirement analysis, testing and modification of Paper maps.
• Migrating the UNIX maps to GIS and testing the output by comparing the results of Gentran and sterling integrator (GIS 4.2).
• Reviewed the Work packet of Team members to provide a better product to the client.
• Development of Extract map using GIS Map Editor.
• Created and modified maps in Gentran server on Unix 6.1.
• Testing of Gentran maps by creating the TP setup and running already created maps.
• Tested newly created maps with production data.
• Troubleshooting and development of Maps

Environment: Gentran Server 6.1, Sterling Integrator (GIS 4.2), Sterling File Gateway, Ultraedit, Microsoft Visio, Win XP, UNIX, FTP, SFTP, FTPS, HTTPS, SSH, SSL, XML.

Confidential, Seattle WA

EDI Consultant

Responsibilities:

• Involved in requirements analysis, Identification and documentation of required system and functional testing efforts for all test scenarios (Positive and Negative).
• Performed logical mapping changes for 834 and 835 transaction sets to-and-from claims and billing applications.
• Created and modified maps in Gentran server on Unix 6.0.
• Created and modified trading partnerships to support new entities/transactions.
• Performed on going production support for data, mapping, compliance, networking, and delivery issues.
• Setting up jobs for different transactions in batch mode, worked on Oracle for Provider remit tables to insert data and modify data and used SQL to query messages and Data retrieval.
• Extensively involved in the Creation of Test data procedures, testing the Transactions for volume and functionality both on PC and UNIX environments with data driven input and shell scripts for translations.
• Extensively worked in creating test cases and testing using the Quality Center to validate transaction based business rules.
• Extensively worked in running the UNIX scripts and windows batch jobs for both HCCR and CERR with all the 12 Claim Systems and worked on HIPAA Validation on 834 and 835 for all the 12 Claim Systems.
• Involved in Cross Functional, End to End testing for 834 and 835 in different releases logged related defects and resolved them.
• Worked with 12 Claim Systems for HIPAA validation for backfilling of Medical code sets, Non-Medical code sets and worked on BRIO error reporting to get the Claim and remit errors.
• Reviewed the approved test runs.

Environment: Gentran Server for Unix(6.0, 6.1), EDIFECS Spec builder, WinSCP, Oracle 9i, ODBC, Team track, Win XP, UNIX, Quality Center 9.0, QTP, HTML

Confidential, Tampa, FL

EDI Consultant

Responsibilities:

• Worked on 834’s Benefit Enrollment in analysis, translation of flat files to EDI formatand EDI Files to Flat files and analyzed the files through Claredi and Worked on Requirements documents and Companion documents of different states.
• Worked on 270/271 (Eligibility Request & Response) for different clients in EDI Translations, Requirements analysis in different segments and Elements that are required to send to the clients within the HIPAA regulations.
• Worked on 837(i/p) - Professional and Institutional claims, 277-Claim acknowledgement, transactions in 4010 & 4050 format.
• Extensively involved in the Creation of Test data procedures, testing the Transactions for volume and functionality both on PC and Mainframes and input data and JCL
• Extensively worked with HIPAA Analysis tool, Claredi in getting the correct data segments and elements required to send to the clients.
• Extensively worked in writing BSD’s and created test cases and test data for testing.
• Worked on FTP of files from the clients and FTP from the mainframe jobs to the LAN and sending the clients through B2B or uploading to their sites.
• Implemented 270/271 Health Care Eligibility Benefit Inquiry and Response transactions.
• Worked on Sending and receiving the files through Communication protocols like HyperTerminal, Files Encryption, Decryption, creating and sending password protected files

Environment: GIS 4.2, EDIFECS SpecBuilder, Oracle 8i, FTP, HIPAA Transactions, Claredi, ODBC, JCL, Windows NT.