Edi System Analyst Resume
SUMMARY:
A challenging position as EDI Analyst/System Integrator utilizing vast experience in Healthcare/HIPAA, EDI, Medical Billing, ERP and Supply Change applications experience.
TECHNICAL SKILLS:
Database: SQL Server, Progress v6.0/7.3, MS Access
Prog. Languages: VB.NET, C#, VB Scripts, ASP.NET, XML, T - SQL, Progress 4GL,CSS,AJAX,JavaScript
Operating Sys: Unix (IBM RS6000/AIX, HP/UX, Sun Solaris 5.6), Windows,.NET
E-Business/ERP: ANSI X12 EDI (v3050, 4010,5010), EDIFACT, HIPAA, NSF,UB92,HL7
Trans. Protocols: HTTP, FTP-SSH/SSL, SMTP, AS2, B2B, X12, XML, SOAP, Flat-File, EDI-INT PGP encryption, etc. Applications Healthcare, Distribution/Logistics, Medical Billing, De-regulated Electric and Gas.
Reporting Tools: Cognos, SSRS, Actuate, Crystal Reports
EDI Map Tools: BizTalk Sever 2002-2013, Emanio, EDIFACT, Mercator /IBM WTX Paper Free-WinMap/EcMap, EDISIM, GIS
EDI Code Sets: HIPAA compliant - 834, 835, 837, 270, 271, 276, 277, 278
De-reg Energy: 814, 810, 824, 820, 867, 568
Retail/Supply chain: 810, 850,860, 856, 857, 820, 824, 832, 844
VANs: Advantis, Inovis (Inovisworks), ICC, PUBNET, GXS, Walmart’s Retail-Link etc. Retailer Exp Walmart/Sam’s Club, Kohls, Burlington Coat Factory, Linens N’ Things, Staples Barnes & Noble, Amazon, Federated Stores, West Marine, JC Penney, BJ’s Wholesale
EMPLOYMENT:
EDI System Analyst
Confidential
Responsibilities:
- Design and develop web enabled applications to manage EDI transactions including viewing raw EDI data formats, reporting, scheduling and automation using mapping tools, ASP.NET, C#, AJAX, CSS.
- Design and develop applications that automate extraction of data format from legacy application, transform and exchange data with external trading partners.
- Design and develop translation maps to transform proprietary data structure to standard ANSI X12 complaint formats including Invoices (810), Purchase Orders (850), Shipping Advice Notification (856), Purchase Order Acknowledgements (855), Remittance Advice (820) and various other transactions for major retailers.
- Monitor daily EDI activities including reviewing and conforming to customer specific implementation guidelines and requirements.
- Generate daily, Weekly and monthly sales and inventory reports to management.
- Coordinate with Sales, Warehouse and accounting teams regarding Order processing, Charge backs, Stock offers, Promotions, Fill - rates and
- Design and develop applications to generate UCC-128 complaint bar-codes and ASN shipping labels that using custom ActiveX controls and Dlls.
- Develop custom configuration scripts to automate import and export of data from various Value Added Networks (VANs) by using FTP/FTP-SSL protocols and data encryption using WSFTP PRO and third party tools.
- Partner with internal business managers and external trading partner, gather implementation guidelines
- Setup new and maintain existing trading Partner profiles
- Setup, define and configure system, Event server administration and configure various data adapters.
- Test various data formats for compliance and obtain certifications from the each Trading Partners.
- Create EDI Transaction logging application to track Inbound and Outbound interchanges using BizTalk and Mercator/DataStage TX, SQL Server, and .NET technologies.
- Configure and Set up EDI-INT, AS2, Windows Services, Web Services and FTP-SSH for real-time and batch processing of EDI transactions.
- Created models using Framework Manager and designed various drill down and drill through reports using Cognos Report Studio.
Tools: used: BizTalk 2009/2013, IBM WebSphere Transformation Extender-WTX Design Studio (Type Tree Designer, Map Designer, Database Interface Designer Integration Flow Designer, Event Server and Command Server) 7.5/8.01, Trading Partner PC, ASP.NET,XML.XSLT, VB.NET/C#, SQL Server, Java Scripts, IIS, SmartTerm, MS- Project, Cognos BI Reports.
Project Manager
Confidential
Responsibilities:
- Design and Create BizTalk messaging architecture to integrate internal applications using BizTalk s distribution lists and dynamic routing techniques.
- Created BizTalk configuration scripts to install BizTalk objects in development and deploy in production and User Acceptance Testing (UAT) environments.
- Created utility scripts to extract messages from suspended queues due to Parse and/or Document
- Validation errors using BizTalk Interchange objects and re - queue messages in batch mode.
- Create Maps and Specifications to map messages from/to Hub and Spoke formats.
- Create Web Service client application to import various messages in XML format from specific vendor
- Web Services, validate messages and publish to Hub Listener (internal Web Service) to be processed by BizTalk server.
- Create Poll and Publish service to monitor transaction tables, extract messages that needs to be processed by creating strongly typed datasets and stored procedures, publish messages to Hub Listener
- Create/Modify AIC Component to process messages from BizTalk service and publish messages to Web-Listener (Web service)
- Create and Implement SQL job agents to archive BizTalk tracking database.
- Create SQL scripts and stored procedures to query multiple databases and tables.
- Production support and maintenance of various applications including Confidential, Web and internal Core applications, using MSMQ, VB6, VB.NET, C#, SQL Query analyzer and Enterprise manager.
- Extensively used Microsoft application blocks for Configuration management and Exception handling
Tools: used: BizTalk Server 2002/2004, MSMQ, XML, VB.NET, C#, XSD, XPATH, SQL Server 2000, VB Scripts, IIS, MS Projects.
Confidential
Architect
Responsibilities:
- Create Process flow diagrams and Transaction Routing documents using Visio Create Project schedules and Project Time-lines and Resource allocation using MS Project Design and Create HIPAA compliant transactions including 834 Enrollments 837(Professional/Institutional/Dental) Claims using BizTalk Server 2002 from XML and proprietary data-sources. Create XLANG Schedules using Orchestration Designer.
- Create and Configure Ports and Channels using Messaging Manager for EDI transactions.
- Create and Implement HTTP Receive, MSMQ Receive and File Receive functions using BizTalk Admin. Configure Trading Partner Profiles, Implement Organization parameters and Document Definitions
- Used VB.NET and VB Scripts to create custom functoids and scriptoids used in BizTalk Mapper. Design and Create ASP scripts to send/receive data to/from private message queues.
- Extract and Load data into SQL Server database using ADO. NET
- Designed and developed COM+ objects using VB.NET. Participated in design and development of business specify Implementation Guides (IG)
- Performed Unit test, Integration test, validity checks, regression testing, conformance analysis of transaction sets using EDISIM and CLAREDI portal.
- Co-ordinate End-To-End testing with Trading Partners and obtaining Certification.
- Fluent with BizTalk Editor, Mapper, Fuctoids, Xlang Schedules, channels, Message Ports, AIC COM+, Message Queuing, Orchestration etc.
Tools: used: BizTalk Server 2002, MSMQ, XML,VB.NET, ASP.NET, VS.NET, XSD, XPATH, EDISIM SQL Server, 2000, VB Scripts, IIS, MS Projects .
Confidential, Ft. Washington, PA
Data Architect and Mercator Developer
Responsibilities:
- Design, Architect and develop EDI-sub system for a HIPAA compliant EDI Sub-system using Mercator Integration Broker
- Design, Create and map physical data using Mercator design studio.
- Upgrade existing ANSI X-12 Maps from version 3050 to 4010.
- Deployed maps and systems to AIX/6000 environment using communication protocols/tools.
- Design, Architect and Create Hub/routers that invoke translation maps and utility maps using Integration flow designer to design and create mapping systems, generate system files(.msl) and used of Event server. Used MQ Adapter, DB Adapter, E-Mail adapter and EXIT calls to external programs.
- Design, Architect and Create repositories for reporting and archiving data. Created Mercator type trees for XML documents from DTDs to parse inbound Patient Enrollment Transactions
- Performed Unit test, Integration test, validity checks, regression testing, conformance analysis of transaction sets and production support activities. Performed upgrade of EDI subsystems for performance enhancements.
Tools: used: Mercator/ IBMDataStage TX - (Design Studio, Mapping Engine, Commerce Broker, Integration flow designer, Event Server), MQ Series, XML, EDISIM, Visual SourceSafe, Visio, Exceed/Hummingbird, PL/SQL, UNIX Sell Scripts.
Confidential, Edison, NJ
Architect
Responsibilities:
- Architect and Design of database tables and dataflow diagrams.
- Develop stored procedures to process EDI data into database tables.
- Develop EDI transaction maps using ODBC to translate data into oracle tables.
- Develop and maintain ANSI X12 maps for various EDI transaction sets for inbound and outbound transactions.
- Co - ordinate testing with Trading partners (EDC- Electric Distributing Companies) and production environment: s.
- Conformance Testing of EDI documents using EDISIM 4.0
- Setup trading partner profiles and maintaining TP profiles on VAN.
- Participate in the design of EDI Implementation guidelines.
- Automation scripts for transmission of EDI documents via EC/EDI gateway server to VAN on a scheduled basis.
Tools: used: Paper-Free - (WinMap/EC Map/EC Gateway), EDISIM, Windows NT, Oracle 7.3-PL/SQL, Stored procedures, Unix Shell Scripts, Visio.
Confidential, PA
Data Architect and Mercator DeveloperResponsibilities:
- Development of Application Interface Design Document Development of Transaction Routing Design Document Development of Business Unit specific implementation Guide Design of Functional requirement calculations and structures Implementation of Functional requirements and Business process Investigation Architect and Develop infrastructure around EDI application using Netscape's EcXpert/Mercator)
- Design of database tables and dataflow diagrams.
- Develop EDI transaction maps using ODBC to translate data into oracle tables.
- Develop GISB proto-type using HTTP-post and PGP encryption protocol.
- Design & develop Test Data generator using HTML/XML// Confidential scripts (Perl and Java-Servlet).
- Design & develop Viewers to view in/out bound flat file data. Perform daily production activities, Create/test new ANSI-X12 transaction sets.
- Setup/Create new and maintain existing trading partner relationships.
Tools: used: MERCATOR/ IBM DataStage TX, EDISIM, Windows NT, Perl, Java, EcXpert/iPLanet, Oracle7.3, PL/SQL, STORED Procedures, Unix Shell Script.
