Umang Kumar Email & Phone Number

New York, Ny, Us

Princeton, Nj, Us

Product : Florida Blue (BCBS) Commercial Analytics Shared ServiceDescription : Commercial analytics Shared Service deal with the Commercial Market segment of Florida Blue. This initiative focuses on analytics Infrastructure, Population Health, Network Transformation and Risk Adjustment deliverables to enable and enhance commercial analytics support to the organization. Technologies Used : Netezza database, NZSQL, NZPLSQL, Sailfish, S3, EC2, shell Script, GitlabResponsibilities : Gathered new change Request for existing Product from data StewardsCreated the technical design document and unit test cases based on Business Requirement or change requestDeveloped Stored Procedure for data transformation and data mappingDeveloped Shell script to automate stored procedure execution Developed data Pipeline to pull data from S3 to On-premise environment

Princeton, Nj, Us

Product : Genomic Data PipelineDescription : Project involved in designing and development of genomic data analysis pipeline for exome data on cloud platform. Targeted therapeutic area is breast cancer. Customer can use this pipeline to analyze NGS data and generate a report to understand clinical significance of identified variations. This pipeline will enable researcher and scientist to convert FASTQ/BAM file into VCF, annotate, interpret and identify individual health risk by studying the genetic makeup of an individual.Technologies Used : Python 3.6, AWS S3, EC2, Git, Docker 19.03, IGV, GATK, Picard, BWA aligner, QualityQC, Samtools Responsibilities : Identified and gathered software dependencies required for GATK exome pipeline and custom genomic pipelineCreated python wrapper for custom data pipelineGathered public sample data FASTQ file from NCBI portal using gsutil, SRA toolkitIntegrated FastQC quality check of FASTQ file in custom pipelineCreated performance metric utility to identify performance stats of intermediate steps of custom genomic pipelineCreated docker container for both GATK exome pipeline and genomic custom data pipelineCreated Simple PDF Report of gene mutation and Hosted it on S3 as static websiteHands-on experience on AWS EC2, RDS, S3, CloudWatch, EBS Services, ECS

Princeton, Nj, Us

Product : MIPS-QPP (MIPS- Quality Payment Program) Description : Project entailed the Quality Payment Program (QPP) that is a new payment system that was designed to reward clinicians for the quality of care they provided to Medicare patients, instead of the quantity of care.Technologies Used : Java 8, Spring Framework, AWS S3, EC2, CLI, Netezza, WildFly 10, Maven, SVN, Git, Quartz, Hibernate validatorResponsibilities :Gathered business requirement from CMS quality payment portalCreated the design document and unit test cases based on business requirementDesigned and developed ETL process to import data from various sources such as flat file, Excel, and relational databaseDeveloped AWS CLI utility to push and pull data from on-premise to S3 bucket Created data pipeline shell script using AWS CLI to dump report from EBS to S3 bucket and S3 bucket to on-premises databaseDeveloped and designed Spring RESTful service of data submissionCreated data masking for PHI and PII data as per HIPAA compliancePrepared validation annotation for validating XML and JSON filesProduct : HEDIS (Healthcare Effectiveness Data and Information Set) Data SubmissionDescription : Project involved developing the Healthcare Effectiveness Data and Information Set that is a widely used set of performance measures in the managed care industry, developed and maintained by the National Committee for Quality Assurance. Responsibilities : Gathered new changes for product from the healthcare regulatory bodies, namely, NCQA and CMS Worked as lead architect for HEDIS state-level submission workflow Created the design document and unit test cases based on business requirementCreated and updated data mapping for pulling data from source/partner database into HEDIS on a regular basisMigrated data from On-premise SQL Server to SQL Server deployed on EC2 and archival of data on S3Developed Spring RESTful service of data submission

Princeton, Nj, Us

Product : BI-Clinical Data Submission FrameworkDescription : CitiusTech’s data submission framework is an industry-leading platform for healthcare analytics and reporting. It is a one stop shop solution for reporting on multiple regulatory, contractual, financial, and operational initiatives. Submission framework integration occurs with client’s existing system and further processing healthcare data to show provider or hospital the compliance result. Data mapping activity of source databases to consume in data submission framework. Implementation of user interface to view quality report.Data submission framework was implemented as a black box that will accept healthcare data, and generate processed healthcare data. Aided with data submission to CMS.Technologies Used : Netezza, PostgreSQL, Java 8, NZPLSQL, Shell Scripting, Redshift, JBoss, Spring, JAXB, JSONResponsibilities : Understood requirements of meaningful measuresMigrated Stored Procedure and other objects from Netezza to Redshift Understood client requirements for CMS incentive initiativePerformed data gap analysis to meet MU measure compliance requirementAnalyzed change requests/enhancements in productTuned Netezza SQL query as well NZPLSQL stored procedure Provided support to the Client implementation team

Armonk, New York, Ny, Us

Client HDFC BankProject : HDFC DWH AUGMENTATION :Project Description : This system is used in HDFC Bank for migration from old databases to Netezza DWH and for the management, approval, tracking and report generation of the projects which are undertaken by the company This include both ALM and Fincon.Technology Used : Informatica Powercenter, Netezza, Unix, Core Java, Oracle 12c, Shell ScriptResponsibilities Gathered the business requirement from clientCreated the design document based on Business RequirementDeveloped System from scratch in Informatica power centerNetezza Administration Tuned Netezza SQL query Created Java code for Java transformation to implement business logic

Bachelor'S Degree, Computer Science

Senior Secondary School, Mathematics And Computer Science

High School, All