Team Lead for a Data Warehousing Solution
Piedmont Healthcare
مجموع سنوات الخبرة :12 years, 1 أشهر
1/2012 - Current: Team Lead for a Data Warehousing and Business Intelligence solution for a large multi facility hospital - Piedmont Healthcare, Atlanta, GA
• Solution design and enhancements. Design and develop ETLs to load data from Electronic medical Recode system (EPIC, NextGen), Hospital Billing Systems, EDI 837 claim files, and third party provider review systems. Troubleshoot and enhance existing ETLs and SQL for performance tuning and standardization. Design and develop dashboards for population health studies and Provider Quality Reporting (PQRS)
• Help peers in development and troubleshooting.
• My role was to architect, develop a complete solution, identify tools needed for development, create a proof of concept, develop key components (HL7 message listener, message parser, web services and outgoing results message generator), guide junior programmer to develop a user interface. I created the database components, the middle tier mapping engine to parse ORM messages into our database, created WCF web services to output data elements, mapped into the outgoing ORU messages. Tools used: ASP.Net 3.5, C#, WCF Web Services, XML, HL7 2.5, MSSQL Server 2008, Visual Studio 2010, Altova Mission Kit 2011.
• Worked on enhancing, debugging and troubleshooting the current LIMS and client portal for the company. Created statistics reports using SSRS.
• Worked on automating lab related tasks like report delivery to clients by creating windows services. Tools used: Visual Studio 2010, MSSQL Server 2008, SSRS, ASP.Net 4.0, C#, Windows services, java script, AJAX
5/2010 - 7/2011: Developer, CSI Laboratories, Alpharetta, GA
• Designed and developed a complete HL7 interface that automates the accession HL7 messages for cancer diagnostic orders (ORM) into the lab information system (LIMS) used by the company, and also sends the results back in the form of HL7 message (ORU) to the ordering client.
Tools used for all the above: Visual studio 2008, MS SQL Server 2008, SSIS, SSRS; Standards used: MMR, MOR, RAPS
2000 - 2002: Senior Internet Programmer, Melstar Inc. New York
• Team leader / coordinator for offsite projects. It included determining the scope of work, developing project prototype, customer relationship management and coordinating offsite work, and remote project monitoring.
• Designing and developing several e-commerce websites using IBM Websphere Commerce Suite, C++ programming, scripting language and DB2 database.
• Websphere Commerce customization using MVC model, Java, J2EE, EJBs and JSP programming, with DB2 Database Server.
• Enhancing internet application for document/image sharing and reporting, using ASP and MS SQL Server and Microsoft Internet Information Server (IIS)
1998 - 2000: Senior Internet Programmer, Melstar Information Technologies, India
• Designing and developing several e-commerce websites using IBM Websphere Commerce Suite, using MVC model, C++ programming, scripting language and DB2 database.
• Intranet for internal office information, file sharing and reporting, updating projects status using ASP and MS Access
• Designing office automation software for a shipping company. This included automating document management, automating order process for parts and labor and automating breakage reports and status check. Implementation using ASP and MS Access.
1994 - 1995: Software programmer, Comomar Maritime services, India
• Developed a ticketing system for managing and tracking repairs, recruiting and supplies on the ship.
Education and Contact Details
Master of Science (concentration Bioinformatics), Georgia State University, Atlanta, GA
-Diploma in Systems Management, National Institute of Information Technology (NIIT), Mumbai, India