Jagdish Lokhande

Experience

• 

  Elcome International LLC

  Jan 1993 - Jan 1997

  Software Engineer
• 

  CMGI

  Jan 1998 - Dec 2000

  Database Lead, Web applications development

  Contributed to the Development of Myway.com website, supporting database modeling, deployment and maintenance.Developed Java application framework to send alerts, text, and email messages to website users.Developed Phone applications using Phone applications suits (SDK).

• 

  Philips

  Jan 2001 - now

  •Currently working on upgrading existing monolithic healthcare applications to new platform using web/cloud applications, micro-services, docker containers, kubernetes, PostgreSQL, HL7v2/FHIR messages, SNOMED terminology, asp.net core, c#, VS2019, Git Repos.•Worked on Intellispace Console B.0 applications using technologies like VS2015, SQL Server 2014, AngularJS, SignalR, Web/cloud Applications, Amazon AWS RDS for SQL Server, etc.•Developed SNOMED CT Mapping applications using WPF, XAML, C#, MVVM design pattern. These applications released internationally for use of mapping SNOMED CT codes with third party medical reference codes for drugs/formulations/allergies/routes med order validations.•Developing Healthcare Applications (Patient Info Dashboards) using WPF, .NET/C#, VS2015, SQL Server 2016, Windows Server 2012.•Successfully migrated ICCA Healthcare Applications from 2-tier client-server to 3-tier/n-tier by decoupling database layer. Also upgraded same applications from 32-bit to 64-bit.•Implemented Disaster recovery solutions using log shipping and failover/failback process. Working on implementing AlwaysOn.•Performance tuning applications for every release using SQL tuning, index tuning, removing RBAR wherever possible, reducing SQL connection leaks, etc. Monitored IO, CPU, and memory usage using SQL tools, Perfmon, and Confio Ignite 8.•Data modeling using Power designer, E/R Studio, Erwin. Implemented partitioning, logical and physical data designs, DE-normalization, etc.•Completed .NET/C# development of following applications: Configuration changes activation process, anonymizing patient data to support HIPPA regulations, implemented ICD-10, SNOMED terminology.•Implemented data transformation engine, analysis cubes, and reporting solutions using SSIS/SSAS/SSRS. Show less

  • Database Engineer / MDX Database Architect

    Jan 2002 - now

  • MDX Database Architect

    Jan 2001 - Jun 2003