SUMMARY

• Total experience of 6 years in IT industry.
• Over FIVE years of experience in the HealthCare vertical, working in product development of multiple (Electronic Health Records) and HIE (Healthcare Information Exchange) systems.
• Followed Agile SCRUM methodology for product development.
• Over TWO years of onsite experience working exclusively at client sites.
• Proficient in DB technologies like SQL Server 2005, Oracle 8i (and above).
• Expertized in ETL development, used in loading data from discrete source applications to integrated health data repository.
• Expertise in query optimization and tuning using query hints, bulk concepts, types and dynamic SQL.
• Designed OLTP data repository, complying with functional specifications of complete hospital enterprise.
• Created OLAP data model comprising SDC (Slowly Changing Dimensions).
• Excellent knowledge and thorough understanding of OHMPI and HIE concepts.
• Performed data migration activity from SQL Server 2005 to Oracle 10g.
• Experienced in implementation and configuration of integration engines
• Complete knowledge of HL7 v2.5 message types and trigger events.
• In depth knowledge of HL7 v3.0 RIM model concepts.
• Knowledge of HTB APIs used for persisting data in to HTB repository.
• Clear understanding and working knowledge of HTB schema.
• Proven proficiency in SQL performance, trouble shooting and support services.
• Have a good working knowledge of Health Information System workflows.
• Have performed implementations at multiple sites and well versed with implementation methodologies and implementation life cycles.

Core Competencies

• ETL Development
• Integration / Interface
• Technical Support
• Performance Tuning
• Offshore / Onsite /Offsite Model
• Business Analysis
• Technical Implementation

TECHNICAL SKILLS

Databases: SQL Server 2000/2005, Oracle 8x and above.

Interface Standard: HL7 2.x and HL7 3.0, Sentillion bridges.

Operating System: Windows NT/2000, Windows Server 2003 and Windows XP

RAD Tools: Visual Basic 6.0, Basic knowledge on C# and ASP.Net

Web Technology: HTML, Java Script, ASP, Scripts, IIS and knowledge in XML

Design Tool: Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential

Senior Systems Analyst/Database Developer

Responsibilities:

• Profound experience in optimization of queries used in retrieving data from HTB repository.
• Developed reusable ETL package used to extract data from HTB for specific business use cases.
• Experienced in using bulk concepts, query hints and Types for enhanced performance.
• Detailed knowledge and working experience of health data integration following HL7 compliant interface standards.
• Developed code to cater to the requirement of procuring patient readmission data list for user dashboard.
• Developed extraction methodology for data complying to emergency related Clinical quality measures.
• Created complex scripts and queries to encrypt patient health information.
• Functional mapping of HL7V2 to HL7V3 RIM model.
• Technical analysis of disparate source applications for data mapping.

Environment: Oracle HTB, Oracle 11g.

Confidential

ETL lead and Integration expert

Responsibilities:

• Lead a team of 3 to a successful and on time product delivery
• Successfully implemented indigenous BI solution at multiple client sites and also handled post production issues.
• Designed OLTP schema (using ERWIN) based on HL7 standards to make the repository more generic and to accept messages from heterogeneous data sources.
• Design and Analysis of the star based schema based on OLAP methodologies.
• Configured interface engines and set it as the foundation for the business intelligence tool.
• Created cursors, triggers, stored procedures, user defined functions, collections, materialized views and complex data retrieval queries.
• Developed a reusable ETL solution to extract data existing in HL7 format and populate into the data repository.
• Successfully completed data migration from legacy source systems
• Developed and implemented interface concepts for Health Information Exchange (HIE) solution.

Environment: Interface engine, Oracle, SQL Server.

Confidential

Senior Developer

Responsibilities:

• Provided an optimal design for the application based on the specifications and documented the same.
• Developed important components related to 3 modules of the application viz. resource utilization, resource sharing and resource availability management.
• Created stored procedures, user defined functions, triggers and complex data retrieval queries.
• Delivered ready to ship components after a thorough unit testing and ensuring compliance with the specifications\ requirements
• Successfully set up and implemented the solution and also handled post production issues.

Environment: ASP.Net, C#.Net, SQL Server 2005.

Confidential

Senior Developer

Responsibilities:

• Developed, tested and implemented SQL stored procedures to automate identification of financial data corruption to reduce\ eliminate errors introduced by manual checking
• Performed pro - active and reactive financial data monitoring and fixed data corruptions well before time to keep in line with the SLA’s.
• Developed procedures and queries to calculate the Goods Received and matching the financial data with other hospital related expenditures.
• Set up weekly calls with clients and set up a process to share the status with all clients on a daily basis to understand user pains and sort them proactively, acting as the SPOC for all clients
• Lead a team of 3 members to perform critical implementations in UK&I.

Environment: SQL Server 2000 and 2005.

Confidential

Senior Developer

Responsibilities:

• Developed bridged application for Single Sign On and patient link flow
• Upgraded Single sign on bridges for new functionality.
• Implemented bridges for Great Olmond Hospital, UK&I
• Single handedly managed implementation and support for the client onsite and solved all issues raised by the customer.

Environment: Java Script, HTML

Confidential

Developer and Support Engineer

Responsibilities:

• Performed investigation on the calls raised on the fault logging system, in accordance with the quality procedures, and tracked it till issue resolution.
• Resolved all issues raised by customer within the SLA period.
• Kept an up to date record on the fault logging system, in accordance with the quality process, thus ensuring effective tracking and resolution of calls.
• Analyzed and Documented Root Cause Analysis for frequently raised issues to ensure that same issues were not re-investigated thus saving on time and effort.
• Provided suitable workaround solutions to clients while investigating the issues with primary workflow to ensure business continuity.
• Designed backup strategies for live databases to ensure high availability of the data.
• Designed and developed internal automation tools for various maintenance activities

Confidential

Technical Support Engineer

Responsibilities:

• Ensured that issues raised by the clients were resolved within the SLA period.
• Performed investigation in accordance with the quality procedures.
• Performed Root Cause Analysis for frequently raised issues and advice a workaround to the client to maintain business continuity
• Single handedly implemented the software in multiple sites and handled post production issues.

Environment: SQL Server 2000/2005.