OBJECTIVE:

A challenging position as system analyst utilizing vast experience in Healthcare/HIPAA, EDI, Medical Billing, RDBMS and Client Server applications experience.

TECHNICAL SKILLS:

Database: SQL Server, Progress, MS Access

Prog. Languages: VB.NET, C#, VB Scripts, ASP.NET, XML, T - SQL, Progress 4GL

Operating Sys: Unix (IBM RS6000/AIX, HP/UX, Sun Solaris 5.6), .NET

ERP: Prophet 21,Dispatch-1, Publishers VISTA,

E-Business: ANSI X12 EDI, EDIFACT, HIPAA, NSF,UB92,SWIFT,Web Services

Trans. Protocols: HTTP, FTP-SSH/SSL, AS2, EDI-INT, PGP encryption, etc.,

Applications: Healthcare, Distribution/Logistics, Medical Billing, De-regulated Electric and Gas.

EDI Map Tools: BizTalk Sever 2002-2010, Emanio, EDIFACT, Mercator / Websphere DataStage TX / WTX Ver 5.0, 7.5 & 8.01, Paper Free-WinMap/EcMap, EDISIM 4.0,

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, 856, 857, 820, 824, 832, 844

VANs: Advantis, Inovis, ICC, PUBNET, GXS, Walmart’s Retail-Link,SPS Commerce etc.,

Major Retailer: Walmart/Sam’s Club, Kohls, Burlington Coat Factory, Linens N’ Things, Barnes & Noble, Amazon, Federated Stores, Staples, West Marine, JC Penney, BJ’s Wholesale Club

EMPLOYMENT:

Confidential

SQL Developer

Responsibilities:

• Design & Develop front end for EDI application using ASP.NET for querying, sidetracking, sales reporting
• and for various administrative controls.
• 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.
• 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.
• Setup Trading Partner profiles for all inbound and outbound transactions for each trading partners.
• Setup, define and configure system, Event server administration and configure various data adapters, including Database, File and Messaging 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 Mercator/DataStage TX and database interface designer, SQL Server, and .NET technologies.
• Configure and Set up EDI-INT, AS2, and FTP-SSH for real-time and batch processing of EDI transactions.

Tools used: BizTalk 2009/2010, 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, VB.NET/C#, ASP.NET, SQL Server, VB Scripts, IIS, SmartTerm, MS- Projects.

Confidential

SQL Developer

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 CGI, 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, VB Scripts, IIS, MS Projects.

Confidential, New York, NY

SQL Developer

Responsibilities:

• Design, Analyze and assist business to create Logical and Functional Maps from IGs
• 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

SQL 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

SQL Developer

Responsibilities:

• 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 environments.
• 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

SQL Developer

Responsibilities:

• 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//CGI 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.

Confidential

SQL Developer

Responsibilities:

• Architect, Design, analyze core business logic for medical billing application.
• Design, create, modify new and existing management reporting tools consisting of Monthly Productivity
• and Accounts Receivable, Complete Activities on Accounts, Collections Analysis and custom reports.
• Architect and create and modify new and existing batch claims processing system via electronic
• commerce (EDI) applications, including Electronic Patient Registrations (EREGI), Electronic
• Claims(EMC) and Electronic Payment Remittance (ERA/EPR) using industry standard HCFA/NSF,
• ANSI X12, NEIC, HL7, UB92 and proprietary formats for Medicare and Medicaid applications through
• commercial carriers.
• Design and create custom programs to print claims on pre-formatted HCFA 1500 and UB92 forms.
• Perform monitoring of day-to-day operations of billing system activities and related networks.

Tools used: Progress 4GL Ver 7.0, Results-reporting tool, Unix Shell Scripts, Windows NT & AIX

Confidential

SQL Developer

Responsibilities:

• Analyze and translate user/business requirements into detailed processes and system specifications, design applications for Distribution Logistics (Customer Orders, Purchase Orders, Inventory
• Management, Requisition, In-Transits, Shipping and Receiving), Service Management (Work Orders,
• Depot Repairs and Return Authorization), Contract Administration, Logistic Management(Planning and
• Forecasting) and EDI integration.
• Code detailed programs to meet specifications and design requirements, perform schema changes, customize, system integration, data loads and conversions
• Performance tuning of applications and writing detailed test plans
• Trouble shoot and perform unit testing.

Tools used: Progress 4GL, Unix shell Script, Windows NT and AIX

Confidential

SQL Developer

• Develop EDI programs, Install EDI standards.
• Establish ANSI X12, UCS, TDCC, EDIFACT, NSF and HL7 translation formats and interchange information.
• Build and map EDI Hierarchy, maintain looping EDI segments
• Build and Maintain data dictionary, user interfaces and flat file hierarchy.
• Configure, establish communications sessions to VANs (Value added networks)
• Establish and maintain trading partner profiles.
• Customize and perform unit testing of EDI systems.

Tools used : FREDI, Visual EDI, batch scripts and Windows