Improver

Contact Details

E-mails & Phone

Sumit Bhatt

Sumit Bhatt

Solutions Architect | Technical Lead | .Net Full Stack | Cloud computing at Tata Consultancy Services

Nashville Metropolitan Area

I am Solution Architect and Technical lead at Cardinal Health's 3rd Party Logistics (3PL) Services Healthcare business.

As 3PL Software Technical Lead and Solution Architect ,
I am responsible for

Application Support and Maintenance :

• Ensure the overall integrity of software build procedures and software configuration management practices using ITIL methodology.
• Manage and support daily proactive monitoring, EDI processing, data feeds, warehouse operations and logistics.
• Adopted software industry best-practices such as Agile methodology for use in the Healthcare industry.

Application Development:

I am responsible for delivery all Cardinal Health's 3rd Party Logistics systems. I have listed few applications that have been developed and delivered successfully.

• Samples Management System – E-commerce Solution The Samples Management System (SMS) assists Cardinal Health in the pre-processing of drug sample orders requested by pharmaceutical manufacturing companies. It enables these client organizations to comply with the Prescription Drug Marketing Act (PDMA) regulations, Technologies: Angular Js, .Net programming 4.5, Javascript s, REST APIs, Microsoft SQL, Amazon Web Services – S3 buckets, EC2 instances, RDS instances, Google Cloud Platform – Load Balancers.

• Iguana Solution – The Iguana integration engine delivers a rapid, reliable, and scalable solution for the healthcare information, solution that allows to build channels move files through secure SFTP protocol. Also process XML, text files, HL7 files, perform EDI transactions – 850, 940, 810, 856, 812, 852, 867 to name a few. Technologies: Lua Programming language, EDI, XSLT, XML, SFTP


Technology Stack:

Languages: C#, .Net technologies(MVC), Angular, Lua scripting , Iguana , SQL , T-SQL, JavaScript , vbscript

Methods: Waterfall, Agile

DBMS: SQL Server 2014/2016/18, MS Access BI

Technologies: Microsoft Business Intelligence Suite (SSIS, SSRS, SSAS), Tableau

Cloud tech - AWS and PCF- GCP

Other: GIT, JIRA, Confluence, SQL Query Tuning and
Optimization, Database Space and Performance Management, Data Mining, Data Warehousing and Reporting, Data Visualization, Data Migration, Excel, Splunk, PowerShell scripting


Experience:

  • Assistant System Engineer (Tata Consultancy Services)
  • System Engineer (Tata Consultancy Services)
  • ASE-T (Tata Consultancy Services)
  • Solutions Architect (Tata Consultancy Services)
  • Technical Lead (Tata Consultancy Services)

Skills:

People also viewed these profiles