SUMMARY

• Over 9 years of experience in teh IT industry dat involves teh complete Software Development Life cycle from analysis, design, coding, testing & implementation.
• 5 years of development and implementation experience in EDI ANSI X12, Sterling Integrator, Sterling’s Gentran Server on UNIX, Gentran Integration Suite (GIS), SAP & XML/XSLT applications.
• Hands on expertise in using various Mercator adaptors (File, Schema, XML, Database, Email, FTP etc.).
• Demonstrated proficiency in EDI ANSI X12, X12N/HIPAA & EDIFACT standards.
• Strong Working experience with Transactions 810,814,820,850,856,862,867,945,214, 837/835, 276/277/844/838/845.
• Experience in creating maps using 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.
• Experience in E - Commerce, Retail, HealthCare, Insurance and Automotive sectors.
• Expertise in B2B standards, Implementation of Integrated EDI applications and Enterprise Application Integration (EAI) for business processes across applications.
• Extensive noledge in Energy Transactions including Enrollment and Historical usage request (814E), change request (814C), Drop request (814D).
• Extensive Experience in SQL/PL SQL, Stored Procedures and Triggers.
• 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.

TECHNICAL SKILLS

Mapping Tools: Sterling Integrator 5.0/5.2, Gentran 5.1/5.3/6.0, GIS 4.2/4.3, BizTalk, Sybase EC Map, EC Gateway, Sterling File Gateway, AFT

Industry Standards: ANSI X12, EDIFACT and HIPAA

EDI Tools: EDISIM 4.0, XMLSPY, FTP, HTTP/S, AS2, VAN

SQL Editors: SQL NAVIGATOR, TOAD, SQL ANALYSER

Reporting Tools: Crystal Reports, Data Reports, SQL server Reporting Services(SSRS)

EDI Transactions: 810, 850, 856, 860, 210, 214, 220, 270,271, 865, 276, 277, 278, 835, 837, 940, 945

Languages: C, C++, Unix Shell Scripting, AS/400, SQL, PL/SQL, BPML, XSLT

Web Tools: HML, MS Front Page, Dream Weaver

Databases: Oracle 8i/9i/10g, SQL Server 2000/2008

Operating Systems: Windows 9x/NT/2000,Sun Solaris 5.8,AIX

Other Software: XML, DTD, XSD, XSLT, XMLSPY, Clear Case, ULTRAEDIT, SMART DB, CLEAR QUEST, REFLEXION GUI TOOL, WS-FTP, SQL Loader, Oracle E-Business Suite (EBS), MS Word, Visio, Project, Excel

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. EDI Application Developer

Responsibilities:

• Involved in setting up of Trading Partners Envelopes for multiple transactions in Sterling Integrator.
• Created business processes using Graphical Process Modeler/BPML and configured adapters and services as per business needs.
• Configured JDBC Adaptor to pull data from data base and vice versa. Created Code lists for various code conversions.
• Develop/Modify EDI maps using Gentran Integration Suite/Sterling Integrator’s Map editor.
• 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.
• Configured and implemented Sterling file gateway process.
• Configured adapters, services, service configurations and AS2 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.
• Written AS/400 scripts in (i-Series) arenausing Inovis Trusted Link Enterprise TLE EDI/400, EXTOL, and Gentran
• Configured and build complex workflows with other analysts to automate and streamline teh Confidential supply chain processes using Sterling OMS
• Created UNIX shell scripts to automate teh FTP process, handling of data discards, data errors, compliance errors etc.
• Worked on creating business process to automate EDI system for inbound (850, 940) and outbound (856, 846, 810) maps.
• Involved in map development, testing and implementation for transactions 850, 846, 856, 940, 810, 814, 820, and 856 in Sterling Integrator 5.0/GIS 4.2(Application Integration mapper, Map editor) in .Net enviornment.
• Migrated maps, business processes, services, envelopes from GIS 4.2 to Sterling Integrator 5.0
• Involved in support, problem solving, data correction and map changing based upon requirements.
• Responsible for staging of EDI systems in Development, Testing and Production.
• Worked with Sterling Commerce GIS (Gentran Integration Suite), BPML and teh GIS BP Modeler, DB connectivity JDBC.
• Familiarity with mapping and GIS mapping tool, SQL server and TSQL.
• Testing of functional and branching elements (Unit Testing).
• Creation of transformation profiles based on trading partners.

Environment: Sterling Integrator 5.0, Sterling OMS, BPML, BP Modeler, DB connectivity JDBC, Windows XP, SAP iDoc, .Net, SQL Server 2005

Confidential, Southborough MA

Sr. EDI Application Developer

Responsibilities:

• Created maps to translate data from X12 format to AS/400 using Application Integration mapper.
• Wrote UNIX shells scripts to automate FTP and SFTP process.
• Converted and tested maps generated in Visual mapper to Application Integration Mapper.
• Analyzed maps and converted them from version.
• Created maps to convert data from XML to ANSI X12 and vice versa.
• Troubleshoot and resolved XSLT mapping issues and adapter failures/discards.
• Created and modified BPML to handle document archiving, failure notifications, acnoledgement reconciliations, and transaction metrics reporting.
• Created process flow, de-enveloping and routing process for Advanced Shipment Notification (856) transactions for various trading partners.
• Created Trading Partner profiles and Management of Communities in GIS 4.2.
• Involved in migrating teh Maps from GXS to GIS Maps. Also Involved in Migration teh communication Channel from GXS to GIS in Migration project.
• Involved in up gradation of GIS 4.2 to SI 5.0
• Configured and implemented AS2 communication process for various transactions. Implemented MDN based reconciliation procedure.
• Successfully upgraded GIS from version 4.2 to version 4.3. Tested and validated all communication protocols, adapters, BP’s, services, and archiving mechanisms.
• Configured and tested AS/1/2/3,FTP/SSL Client services, SSH Client Services, FTP/SSL Server, SSH Server, HTTP Server, HTTP client service, Webdav, Connect: Direct Adapter, Web file upload interfaces in GIS Ver. 4.3.
• Implemented Ver. 4.3’s fact schema (dimensional and fact tables) to capture and report EDI transactional information and enhanced teh document lifecycle tracking mechanism..
• Wrote UNIX shell scripts to augment trading partner specific transaction batching/splitting requirements.
• Created Shell scripts and database scripts to automate document tracking functionality.
• Scheduling of teh scripts is done using Tidal and crontab.
• Setup Trading partners and Wrote Gentran scripts to support EDI application.

Environment: Oracle 9i/10g(SQL, PL/SQL), Gentran server on UNIX 6.0, GIS Ver. 4.2 and 4.3, GXS,SI 5.0,IBM AIX,AS/400, Tidal, Putty, Ultra Edit, Solaris (Korn Shell scripting),FTP/SFTP.

Confidential, Portland, OR

Programmer Analyst (Sr. EDI Consultant)

Responsibilities:

• Setup Trading partners, created standard to application and application to standard and pass-thru maps.
• Coordinated with Customers to create Implementation Guidelines.
• 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/modified trading partner setup in SAP using WE20 transaction.
• Troubleshoot and reprocessed IDOCS using WE19 and BD87 and Handled discards.
• Wrote UNIX shell scripts to automate handling of data discards, data errors, compliance errors etc.
• Provide Production Support for teh maps developed in Gentran.
• Configured and supported data Managers.
• Created SEF files, Implementation guides and logical maps using EDISIM.
• Configured and used ODBC/JDBC bridges to support Uniform Transaction identifier process to track Transaction across applications.
• Configured SAP, XML adapters to support teh business requirements.
• Involved in fine-tuning teh maps to increase teh performance.
• Created Trading Partner profiles and Management of Communities in GIS 4.2.
• Creating teh Business process Models as per teh business requirements Using Graphical process modeler.
• Created teh work flows to accomplish teh Business process Models using BPML in GIS.
• Migrated Sybase EC Gateway maps onto GIS. Validated teh maps after testing in Sybase EC Map, EC Gateway and GIS correspondingly.
• Improve teh models to overcome frequent issues.
• Worked with GIS AS2 edition for exchanging teh EDI documents for trading partners with digital signature.
• Configured GIS Needs to understand teh data tables in SAP.
• Migrated Gentran 856asn, 810invoice, 846 Inventory Snapshot from Sybase EC Map to Gentran Visual Maps
• Experience in Troubleshooting of IDoc Errors.
• Scheduled and monitored of SAP Batch jobs processing programs using SM36 and SM37.
• Experience in Validation and Sanity Testing of EDI X12 to SAP IDocs data.
• Performed Unit Testing to test teh functionalities.
• Used TOAD to view Database Objects, view and develop Database Scripts.

Environment: Oracle 9i/10g, Gentran Server on Unix 6.0, GIS 4.2, TOAD, SAP IDocs, Ultra edit, AS2, EDISIM and HP UNIX,Sybase EC Map

Confidential, Bloomington, MN

EDI Consultant

Responsibilities:

• Analyzed teh requirements and created mapping specifications based on HIPAA implementation guidelines.
• Used Database Interface Designer to develop type trees based on SQL queries and stored procedures.
• Created and maintained type trees from COBOL copybook’s using COBOL Copybook importer available in Mercator Type Designer.
• Created inbound maps from EDI ANSI X12 format into Database tables and flat files.
• Created outbound maps from application files and COBOL copy books to ANSI X12.
• Implemented business rules in teh maps to check for input errors before generating teh output in EDI format.
• Used built-in functions to perform data conversions.
• Debugged Mercator maps using TRACE, AUDIT files.
• Coordinated with teh trading partners to resolve Inbound and Outbound EDI errors.
• Analyzed EDI translation errors dat failed in teh inbound and re-processed teh EDI’s without losing teh information.
• Created test plans, test data in EDI, Flat files to test Mercator maps.

Environment: Mercator 6.7, Windows NT, MVS and DB2, XML and DTD.

Confidential

Jr.EDI Programmer

Responsibilities:

• Creation of implementation guides to document detailed exchange requirements such a structures, timing and business rules (GAP analysis documents.)
• Set up new trading partners and maintain existing partners
• Developed SQL queries to interact with teh lifecycle database and provide monthly capacity reports reflecting on teh utilization of EDI infrastructure.
• Production Support to LOA application (EDI is a part of Loop order automation) and updating teh logs and EDI files.
• Developed and upgraded EDI maps for transactions 810, 830, 850,852,855,856 and 857 using teh X12 standard. Maps created were for both inbound and outbound trading partner relationships.
• Performed Unit and system testing on all EDI transactions both inbound and outbound.

Environment: Gentran Server 5.2, EC Work Bench 5.2, Windows NT.