Bharat Garg, Developer in Delhi, India
Bharat is available for hire
Hire Bharat

Bharat Garg

Verified Expert  in Engineering

Data Scientist and Developer

Location
Delhi, India
Toptal Member Since
June 24, 2020

Bharat is a data scientist and developer with five years of experience analyzing data, building predictive machine learning models, and designing and developing interactive reports and tools to facilitate decision-making. He has worked with small startups and large corporations, such as Comcast, MetLife, UnitedHealth Group/Optum, and Jefferson Health. One of Bharat's projects delivered $6 million in revenue and another delivered $10 million in savings.

Portfolio

Tata Group
R, Microsoft Power BI, Excel 365, SQL, ETL, Microsoft Excel
ReTarget
R, SQL, Microsoft Power BI, ETL, Data Visualization, Excel 365...
Optum, Inc. (A UnitedHealth Group Company)
RStudio Shiny, SQL, Python, R, Predictive Modeling, Image Processing...

Experience

Availability

Part-time

Preferred Environment

Microsoft Excel, RStudio Shiny, SQL, Python, R

The most amazing...

...predictive model I developed generated $10+ million in savings for the organization by identifying members with high digital propensity and digital attrition.

Work Experience

Administrative Services Intern

2021 - 2021
Tata Group
  • Developed data analytics roadmap for Jal Jeevan Mission; led end-to-end POC development on Power BI.
  • Identified stakeholders and their pain points; implemented three solutions (six conceptualized) for nine POC sites.
  • Developed SLA management module to be used for 75l+ sensors in 6l+ villages costing over 15,000crs.
Technologies: R, Microsoft Power BI, Excel 365, SQL, ETL, Microsoft Excel

Freelancer

2021 - 2021
ReTarget
  • Developed an end-to-end automated ETL pipeline to extract data using API calls and report data in Power BI.
  • Designed three new Power BI extensions from scratch to populate interactive social maps and timeline views.
  • Integrated data from six social media platforms from multiple search keywords and projects.
Technologies: R, SQL, Microsoft Power BI, ETL, Data Visualization, Excel 365, Microsoft SQL Server, Azure, RStudio, Data Engineering, Data Architecture, Data Warehousing, Data Pipelines, ETL Tools

Data Analyst

2019 - 2020
Optum, Inc. (A UnitedHealth Group Company)
  • Developed a predictive model to measure 33+ million members' propensity to engage on a digital platform based on their demographics, claims, and order history.
  • Created a tool to extract tabular information from various images and PDF documents, using image processing and optical character recognition (OCR) techniques. Generated over $50 million in revenue.
  • Developed a deep learning model to generate synthetic data sets based on any data input, ensuring complete anonymity in data sharing to third-party vendors.
Technologies: RStudio Shiny, SQL, Python, R, Predictive Modeling, Image Processing, Deep Learning, Data Analytics, Data Science, Machine Learning, Data Visualization, Excel 365, Microsoft SQL Server, Azure, Computer Vision, Process Mining, ETL, Microsoft Excel, RStudio

Senior Analyst

2016 - 2019
Cognitio Analytics
  • Developed a record linkage algorithm and identified 55,000+ true pairs out of 500 billion possible pairs, with an accuracy of 99.9% and recall of over 90%.
  • Analyzed 3.5 million renewal journeys with 15 million events as input for data analytics and process mining. Identified members with cross-selling and up-selling opportunities and root causes for high attrition, generating $6+ million in revenues.
  • Redesigned and developed automated reports, reducing load times by around 90% and maintenance effort from 15 FTEs per week to 0.5 FTE per week.
Technologies: Oracle, Business Intelligence (BI), Qlik Sense, RStudio Shiny, SQL, Python, R, Algorithms, Data Analytics, Process Mining, Data Science, Excel 365, Microsoft SQL Server, Azure, Minit, Celonis, ETL, Microsoft Excel, RStudio, Data Engineering, Data Architecture, Data Warehousing, Data Pipelines, ETL Tools

COVID-19 Simulator

https://bharatgarg.shinyapps.io/covid19/
Developed an RStudio Shiny-based COVID-19 spread simulator to study how various parameters, such as population density, social distancing, and recovery time, would impact the spread of the virus over time.

Ranking Members Based on Their Propensity to Register on Digital Platforms

Developed a random forest model to measure member digital propensity and scored 33 million data entries.
Successfully modeled ranking mechanism basis 172 parameters from demographic, Rx, claims, and orders.
Supervised a team of two, responsible for deliverables, and single-handedly managed all client communications.
Generated key insights and identified the top five positive and negative factors driving digital adoption.
Successfully modeled attrition and achieved a recall of 90% in the top decile with a high digital propensity.

Identifying Digital Utilizers with High Attrition Propensity

Led a team of three, creating a boosted tree model to measure member propensity to attrite in the next three months. Processed 200 million records from five data sources for 1.5 million members and defined 486 features for modeling.
Achieved a 12% reduction in attrition rate in high propensity group and overall attrition reduced by 3%. Also, I accomplished an increase in response rate by 18% by sending retention campaigns after six months of inactivity.

Developing an Inhouse Process Mining Tool

Developed a tailored inhouse process mining tool using open-source tools and libraries in R and Shiny BI.
Built process discovery, variant explorer, root cause analysis, executive summary all in a single package.

Developing New and Optimizing Existing Healthcare Reports

Identified bottlenecks in the existing report design process, established best practices for reporting in Infor BI.
Developed 18 reports using best practices, minimized maintenance time by automating 15+ quality checks.
Achieved a load time reduction of 90% on average and reduced maintenance work full-time equivalent (FTE) from 2 to 0.2.

Languages

R, Python, SQL

Frameworks

RStudio Shiny

Tools

Microsoft Excel, Qlik Sense, Microsoft Power BI

Paradigms

Data Science, ETL, Business Intelligence (BI)

Platforms

Oracle, RStudio, Azure

Storage

Microsoft SQL Server, Data Pipelines

Other

Machine Learning, Process Mining, Data Analytics, Data Visualization, Data Engineering, Data Architecture, Data Warehousing, ETL Tools, Deep Learning, Celonis, Minit, Mechanical Engineering, Predictive Modeling, Image Processing, Algorithms, Computer Vision, Simulations, Excel 365, Marketing Mix, B2C Marketing, SEO Marketing, Supply Chain

Libraries/APIs

OpenCV

2020 - 2022

Master's Degree in Business Administration

Faculty of Management Studies - Delhi University - Delhi, IN

2012 - 2016

Bachelor of Technology Degree in Mechanical Engineering

Delhi Technological University - Delhi, India

FEBRUARY 2019 - PRESENT

Deep Learning and Computer Vision A-Z: OpenCV, SSD & GANs

Udemy

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring