We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

TN

EXPERIENCE

Over 17 years of Experience in Software Industry. Worked in various types of industry Healthcare,Utilities,Manufacturing. He has been involved in a wide range of strategy, architecture design and integrated enterprise solutions.Most recently Sunder has been assisting CHI,CO for their migration from Datagate/Monk /SRE,JCAPS6.x and 5.1.x to Rhapsody5.x. Earlier Sunder has been assisting organizations at developing Health Care Solutions including HL7 2.4/3.0 ,HIPAA PROVIDERS, PAYERS, and EXCHANGES .He is responsible for architecting integrated HL7 Solutions .Over the previous ten years, he has consulted with numerous organizations on business, process and architectural re-engineering engagements. Sunder has extensive experience consulting to various industry segments including Energy Oil and Gas , Health Care, Manufacturing and Process organizations in the United States.Most recently Sunder has been assisting organizations at architecting HL7,X12 PROVIDERS,CLINICS , Health Care Solutions, Supply Chain initiatives. Knowledge of IIB,Broker,Spring Batch,XML,SQL,UNIX,JAVA,JAVASCRIPT.Team Lead/player with excellent communication skills.

PROFESSIONAL AND BUSINESS EXPERIENCE:

Confidential

SQL Developer

Environment: Rhapsody 3.x,5.x,Meditech 5.x,6.x,JCAPS 6.x,5.1.x,JMS, SRE/ICAN 505,egate monk,datagate,RHAPSODY,5.5.1 ID files SRE Edesigner,Connectivity Map,Logicalhost,JMS Connection Point,Collab Rules ,Oracle 10g/9i, PL-SQL,Xml,UNIX

  • Designed/Developed interfaces to send/receive X12/HL7 ADT,RAD,ORU,OBX,ORM,ORD,DOC,DFT etc in monk/jcaps/Rhapsody 5.5.x from Meditech,McKesson,Cerner Soarian etc to different facilities across nation.
  • PACS,Sorian,IDX, ChartMaxx,Meditech,Mirth,Tide,EMPI,Hyland,MedQuist,Softmed,Salar,eDischarge,Teleresults,Escript,Onbase,DOCSITE,IMAGECAST IRIS . etc were some systems : Egate/Rhapsody 5.5.x was interacting apart from hospitals and clinics.
  • Worked in all flavours of Rhapsody 1.3,3.x and 5.x .
  • Used enterprise manager/monitor,web management console Rhapsody and Interface Explorer as HL7 IDE to design,develop,test/receive HL7 msgs.
  • Designed and deployed in Rhapsody 5.5.x using templates for INITS,TRX and DELIV.
  • Development/Migration was done in java,javascript,Creation of Routes,wiretaps,bridge to communicate data from old systems to new systems.Journal files captured all the incoming as well as outgoing msg from Rhapsody 5.5.x which are archived.
  • RLC files were created in SVN for gatekeepers to migrate to different env test and prod.
  • Did X12 transformation,processing migration for 270/271,837 P,I D and 835 remits in monk/jcaps/Rhapsody.
  • Installed the Rhapsody 5.5.x,web management console for monitoring and retriggering msgs on Windows/Linux boxes.
  • PGP Encryption,keys was used for sftp connection.
  • Trading partner setup was done eXchange.
  • CSF/common framework/unix script for error handling was used to trap error in prod like eways going down,disk space etc.
  • Involved in production support and on call 24/7 and documentation trimap .
  • Used Remedy HD tkts software and HP quality center to monitor status of tkts.

Confidential

Environment: JCAPS 6.x,5.1.x,JMS Grid, ICAN 505,egate monk,datagate,RHAPSODY ID files SRE Edesigner,Connectivity Map,Logicalhost,JMS Connection Point,Collab Rules ,Oracle 10g/9i, PL-SQL,Xml,UNIX

  • Developed interfaces to send/receive ADT,ORU,OBX,ORM,ORD,DOC,DFT etc ,Orders,Results. in JCAPS 6.0,5.1.x and SRE,4.5.3. from open link for Sorian Financial and Sorian Clinicals go live.
  • Sorian,IDX,Meditech,Mirth,Tide,EMPI,Hyland,MedQuist,Softmed,Salar,eDischarge,Teleresults,Escript,Onbase,DOCSITE,IMAGECAST IRIS . etc were some systems egate was interacting.
  • Used Interface Explorer as HL7 IDE to test HL7 msg and receive HL7 msg.
  • Developed a unix script to send email alerts to support prod interface monitoring.
  • EAR file was made and deployed in JCAPS 6.x,5.1.2 and SRE using script.
  • Development/Migration was done in monk and java ,Creation of bridge to communicate data from old systems to new systems.Journal files captured all the incoming as well as outgoing msg from egate.
  • Installed the JCAPS 6.0,5.1.x,edesigner,domain,emanager on Windows/AIX boxes.
  • Involved in production support and on call 24/7 and documentation trimap .
  • Used Remedy HD tkts software and HP quality center to monitor status of tkts.

Confidential

Environment: JCAPS 6.x,5.1.x,JMS Grid, ICAN 505,egate monk SRE Edesigner,Connectivity Map,Logicalhost,JMS Connection Point,Collab Rules ,Oracle 10g/9i, PL-SQL,Xml,UNIX

  • Developed interfaces to send/receive ADT,ORU,OBX etc ,Orders,Results. in JCAPS 6.0,5.1.x and SRE,4.5.3.
  • Invoved in supply chain interfaces to send the data to health ministries from Symphony.
  • CERNER,Imagecast,IDX,Mirth,Tide,EMPI,Hyland,MedQuist,Softmed,Salar,eDischarge,Teleresults,Escript,Onbase. etc were systems egate was interacting.
  • Developed a GUI monitor for error,alerting and logging.
  • Used Interface Explorer as HL7 IDE to test hl7 msg and receive msg.
  • Developed a single monitor to support 15 registry hosts running 15 schemas.
  • EAR file was made and deployed in JCAPS 6.x,5.1.2 and SRE using script.
  • Migration was done from monk,SRE to Jcaps.
  • Installed the JCAPS 6.0,5.1.x,edesigner,domain,emanager on Windows/AIX boxes.
  • Involved in production support.

Sr. Java CAPS Consultant

Confidential

Environment: Monk,JCAPS 6.x,5.1.x,JMS Grid, ICAN 505,egate 4.5.3 Edesigner,Connectivity Map,Logicalhost,JMS Connection Point,Collab Rules ,Oracle 10g/9i, PL-SQL,Xml,UNIX

  • Involved in development, Testing, implementation and maintenance of the integration solution for Hendricks Regional Health, Meditech to electronic Clinical Works and transcription to ChartMaxx. My efforts include methodologies and middleware components necessary for successful integration using SeeBeyond's Java CAPS product set. Was involved in creating the interfaces which facilitate the patient records data gathering from Meditech servers to process them thru the JCAPS engine, and sending the patient records into various other systems eCW, Tripractix, Mid America, Nevicare, INPC, ChartMaxx .
  • Migration work from Datagate/Monk 4.5.1/ICAN to Java CAPS.
  • Formatting various HL7 Message Segments like MSH, EVN, MSA, NTE, OBR, OBX, ORC, PID, PV1, and NK1 etc.
  • Formatting data in Patient Admission, Discharge and Transfer ADT module e.g. ADT A01, A02, A03, A04, A05, A06.
  • Developed custom OTD and data parsing to handle vendor specific requirement.
  • Converting HL7.2.4 messages to HL7 2.3.1 message.
  • My responsibilities include creating the various application specific e Way adaptors like TCP/IP e Ways, TCP/IP HL7 e Ways, LDAP, HTTP e Ways
  • Created Java Collaborations for interface integration process with disparate systems.
  • Involved in analysis and design of the Inbound and Outbound e Ways for various Java CAPS connection types to facilitate the data flow among applications.
  • Created standard logging functions designed to handle Transaction Activity Logging, Collaboration Error Logging, Application Errors.
  • Created the periodic backup and purge routines for the JCAPS system logs and as well as for the errors/journals.
  • Responsible for preparing the Tech Spec by analyzing the Functional Spec. Care was taken to ensure not only functionality but also scalability.
  • Assisted in the High Availability, Failover Design document, discussions and planning using JMS Grid.
  • Implementing JMS Grid/CSF Common Services Framework

Confidential

Environment: JCAPS 5.1.x,JMS Grid, ICAN 505,egate 4.5.3 Edesigner,Connectivity Map,Logicalhost,JMS Connection Point,Collab Rules ,Oracle 10g/9i, PL-SQL,Xml,UNIX

  • Architecture/Developed interfaces to send/receive ADT Admissions,Discharges Transfers ,Orders,Results. in JCAPS 5.1.2.
  • Developed common services for error,alerting and logging.
  • Installed and clustered the JCAPS 5.1.2 application.
  • EAR file was made and deployed in JCAPS 5.1.2 using script.
  • Performance tuning was done by increasing of threads and modifications in the code.
  • Installed the JCAPS 5.1.x,edesigner,domain,emanager on Windows/AIX boxes.

Confidential

Environment: ICAN 505,egate 4.5.3 Edesigner,Connectivity Map,Logicalhost,JMS Connection Point,Collab Rules ,Oracle 10g/9i, PL-SQL,Xml,UNIX

  • Architecture/Developed interfaces to send/receive ADT Admissions,Discharges Transfers ,Orders,Results. in ICAN.
  • Developed common services for error,alerting and logging.
  • Installed and clustered the ICAN application.
  • EAR file was made and deployed in ICAN using script.
  • Performance tuning was done by increasing of threads and modifications in the code.
  • Installed the ICAN ,edesigner,domain,emanager on Windows/AIX boxes.

Confidential

Environment: e Gate 4.5.3 IQ, BOB, Collab Rules ,SQL Server, TCP-IP and Batch e Ways, MONK, JAVA and e Way Connections.

  • e Gate 4.5.3 SME and Interface Lead for a Hospital System Seebeyond implementation.
  • Architecture and Workflow definitions, HL7 interfaces design and development for
  • ADT Admissions, Discharges Transfers , Orders, Results.
  • Maintained and enhance an effective Error Handling services and Alert
  • mechanism design. Production support and monitoring activities.

Confidential

Environment: e Gate 4.5.3 IQ, BOB, Collab Rules ,SQL Server, TCP-IP and Batch e Ways, MONK, JAVA and e Way

  • Unity hospital, an subsidiary affiliate under Blue Cross Blue Shield, Ca, had a Datagate 3.6.2 environment which they wanted to upgrade to SeeBeyond's e Gate 4.5.3. They had 20 existing interfaces in their system of which there were 50 RealTime and 5 Batch interfaces. The existing Datagate translation rules were developed in Route Table mode. The CMC wanted to use the Monk as the translation rules in the new e Gate environment as e Gate no more supported the Route Table mode. So the volume of work increased to make the analysis of the
  • Datagate Route Table translation codes. Then the corresponding Monk development textual analysis was made to prepare the migration strategy. Those interfaces were sending HL7 ADT, Pathology results/orders, and Financial data back and forth from the main HBOC McKesson Series HIS Healthcare Information System system to various ancillary systems like Pyxis, Orsos, Eds, EmStat, Tamtron, SunQuest, Clinivision, TQ etc.I created 50 more interfaces.
  • At the same time we started developing the monk translation codes for the interfaces. Then we started migrating the interfaces to e Gate environment and take out the Datagate from the system. Then we did the user training also post go-live support. The work involved installation of e Gate 4.5.0 product in NT 4.0 environment. Created the test as well as production environment for e Gate. First we tried to do passthru the data from the Main HBOC McKesson Series HIS system to e Gate and then Datagate so that it allowed us to test the e Gate system was stable.

Confidential

Environment: e Gate 4.5.2 IQ, BOB, Collab Rules , PL-SQL, Java, e Insight, e Xchange, e Gate Monitor, UNIX

  • Involved in this strategy project for assessing HIPAA administrative simplifications/privacy/security compliance.
  • Reviewed current data integration proposals and provided input required to design needed interfaces.
  • Involved in analysis, designs, architecture, define security for HIPAA Gap Analysis, assessment and Compliance.
  • Extensive knowledge of high availability HA , auditing, monitoring and recovery relating to EAI and SeeBeyond.
  • Involved in analysis, development, testing and implementation of HIPAAWARE e GATE, e BPM, e PM, e Insight, e Xchange project for HeW using MONK, JAVA, e Way's CICS, FTP, ODBC , BOB, IQ's etc.
  • Implemented HIPAA transactions, in sync with SeeBeyond solutions, which was integrating with TIBCO engine.
  • All transactions are made compliance to X12N standards to talk with various Legacy system OS 390 , and ADABAS - NATURAL . Transactions captured and re-engineered are Enrollment Transaction 834 / Health Plan Premium 820 / Eligibility Transaction 270/271 / Referral/Authorization 278 /Claims 837 Claim Attachments 276/277 .
  • Detail workflow with A2A architecture, with event and process flow.
  • Worked on the ADT and Vaccination details. Converted the Monk to Java ETD for Vaccination. Inbound and Outbound
  • Responsible for integrating e way adapters for database access, retrieval and update MMIS, Legacy applications CICS/IMS/DB2,JCL .
  • Transaction and standard effected for modification was X12N, HL7.etc
  • Messaging Standards or Format Support: XML, X12, SWIFT, HL7, AL3, EDIFACT, X409, ASTM, ASN.1, HTML, DICOM, SGML, NCPDP, proprietary fixed and delimited.
  • Defining and maintaining trading partner profiles. Creating and responding to action items. Generating reports that have been predefined in crystal reports.
  • Implemented the Testing Methodology defined during the test strategy definition.
  • Lead the team in building the user acceptance test plan, including test scenarios and test scripts for the H I PAA transactions and privacy development projects.
  • Operating System Support: NT, Solaris, AIX, HP-UX, XP and OS390
  • Messaging Standards or Format Support: XML, X12,HL7, AL3, EDIFACT, X409, ASTM, ASN.1, HTML, DICOM, SGML, NCPDP, proprietary fixed and delimited.
  • All total 25 stored procedures incl Indexes,views were written for each Schema in PL/SQL.
  • Database connectivity Support: Oracle, Sybase, SQL Server, Informix, and ODBC.
  • Communication Protocol Support: TCP/IP, Batch local transfer, COM/DCOM, CORBA, EJB, IP Multicast, DECnet, IPX/SPX, FTP, SNA LU0, 1, 2, 3, 6.2 , Asynch, UDP, Telnet, HTTP S , SMTP, 3270, 5250, MQ, MSMQ, Netware, SNMP, NFS, TAPI, Tuxedo, X.25, and various forms of screen emulation.

Confidential

  • Involved in architect and implementation of the integration solution for twenty-three Quest Diagnostic LIS Laboratory Information Systems to the eMaxx Internet Portal. My efforts include integration architecture, methodologies, and middleware components necessary for successful integration using SeeBeyond's e Gate product set. I was involved in creating the interfaces which facilitate the patient records data gathering from region specific servers to process them thru the e Gate engine, and putting the patient records into the centralized eMaxx server
  • Responsible for preparing the Tech Spec by analyzing the Functional Spec. Care was taken to ensure not only functionality but also scalability
  • The use of eMaxx to view Laboratory results allows the physician to view results from his/her own computer which permits him/her to get the Lab results more efficiently and timely manner
  • The e Gate interface engine formats data and transfers it to the eMaxx application for storage
  • Formatting various HL7 Message Segments like MSH, EVN, MSA, NTE, OBR, OBX, ORC, PID, PV1, TXA etc.
  • My responsibilities include creating the various application specific e Way adaptors like TCP/IP e Ways, TCP/IP HL7 e Ways, DART e Ways, FTP/Batch e Ways, HTTP e Ways, Multi-Mode e Ways, e Way Connections
  • Created the Monk as well as Java Collaborations for interface integration process with disparate systems
  • Involved in analysis and design of the Inbound and Outbound e Ways for various e Gate connection types to facilitate the data flow among applications
  • Defining and calling Sub-Collaborations
  • Used DART Converter, DTD Converter and HTML Converter to build the ETDs for the database structure, XML data, HTML forms respectively
  • Prepared the mapping strategy of XML message structure with HL7 data stream and mapping the same in the e Gate Enterprise Manager's Collaboration Rules editor
  • Import and export of Schemas and Components, Using IQ Viewer, Advance publication techniques such as publishing multiple Event Types and suppressing default publication
  • Implementation of notification channels through modification of the Notification Routing Script
  • Created standard logging functions designed to handle Transaction Activity Logging, Collaboration Error Logging, Application Errors
  • As part of the Security/Authorization process data passed from the source systems to the eMaxx ASP has 128 bit encryption by a dedicated T1 pipe which is not exposed to the public internet. The eMaxx ASP provides a safe, secure environment. Also the processes provide high data availability in the event of a hardware failure
  • Created the periodic backup and purge routines for the e Gate system logs and as well as for the errors/journals
  • Assisted in the Nationwide Rollout project planning and delivery, providing a complete Integration Solution for MedPlus in its national e-health initiative

Environment: e Gate 4.1.2/4.5.x Integrator Suite, e Insight, e Xchange, Monk Java Collaborations, Multi-Mode e Ways, e Way Connections, TCP/IP e Way Adaptors, TCP/IP HL7 e Way Adaptors, DART e Way Adaptors, FTP/Batch e Way Adaptors, HTTP e Way Adaptors, HL7 2.1 thru 2.3, HP UX-11, Windows 2000/NT,ASP,VB 4.0, Oracle 8i, TOAD 7.0, MS Visio 2000, XML SPY 4.2

Confidential

  • Involved in analysis, development, testing and implementation of E-Commerce Project for AT T, USA using Java 1.2,J2EE, EJB, Web Logic Server 5.0,Servlets, JSP,Visual Basic 4.0 Oracle7.1 Creation of table with views,stored procedures,indexes , CORBA, Visual Caf etc.

Confidential

PROMIS is a WEB enabled utility tool that enables Information Flow in a hierarchy for people at all levels in the Management. It also facilitates Report Generation for billing and matrix generation, viewing of Employee wise, project wise and Activity wise timesheet. It includes two Components, which are:

Process Management - Provides Real-time information about the Project Status, Issues and resources utilized. Team members used the tool to track their time, report issues and in general stay in touch with each other.

Project Management - Tool to manage a Project in an optimized way.

Using Java1.2, Servlets, Tomcat,Visual Basic 3.0 and Oracle 7.1, J Builder etc.

Hire Now