Publication
Social Network Analysis Using Power BI and R: A Custom Visuals Guide
https://www.toptal.com/developers/r/social-network-analysis-power-bi-r-custom-visuals
Bharat is available for hire
Hire BharatBharat Garg
Verified Expert in Engineering
Data Scientist and Developer
Delhi, India
Toptal member since June 24, 2020
Bio
Bharat is a generative AI executive with 10 years of experience building and scaling AI-first platforms. As VP of Technology and AI, he leads AI strategy, LLM architecture, and enterprise-grade deployments. He specializes in LLM and RAG systems, AI-native product design, and scalable data infrastructure. Bharat's work has generated $6 million in revenue and $10 million in cost savings for startups and Fortune 500 organizations, including Comcast, MetLife, and UnitedHealth Group (Optum)
Portfolio
Christel House International, Inc.
Data Engineering, Python, Azure, Azure SQL Databases, Data Pipelines, APIs, SQL...
Tata Group
R, Microsoft Power BI, Excel 365, SQL, ETL, Microsoft Excel
ReTarget
R, SQL, Microsoft Power BI, ETL, Data Visualization, Excel 365...
Experience
- SQL - 10 years
- Python - 10 years
- Machine Learning - 10 years
- Deep Learning - 8 years
- Data Science - 8 years
- APIs - 8 years
- Azure - 8 years
Preferred Environment
Microsoft Excel, SQL, Python, Large Language Models (LLMs), Artificial Intelligence (AI), Generative Artificial Intelligence (GenAI), Natural Language Processing (NLP)
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
Data Engineer
2022 - 2022
Christel House International, Inc.
- Architected and implemented a centralized SQL data warehouse with scalable ETL pipelines, consolidating data across eight schools in five countries from four disparate systems, supporting analytics for thousands of students.
- Designed and delivered interactive Power BI dashboards to monitor 30+ critical KPIs, enabling data-driven decision-making across leadership and operational teams.
- Led automation of recurring monthly and quarterly reports, eliminating manual processes and significantly improving accuracy, turnaround time, and stakeholder visibility.
Technologies: Data Engineering, Python, Azure, Azure SQL Databases, Data Pipelines, APIs, SQL, Microsoft Power BI
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, Natural Language Processing (NLP)
Experience
COVID-19 Simulator
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.
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.
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.
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.
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.
Education
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
Certifications
FEBRUARY 2019 - PRESENT
Deep Learning and Computer Vision A-Z: OpenCV, SSD & GANs
Udemy
Skills
Libraries/APIs
OpenCV
Tools
Microsoft Excel, Qlik Sense, Microsoft Power BI
Languages
R, Python, SQL
Frameworks
RStudio Shiny
Paradigms
ETL, Business Intelligence (BI)
Platforms
Oracle, Azure, RStudio
Storage
Microsoft SQL Server, Data Pipelines, Azure SQL Databases
Other
Machine Learning, Data Science, Process Mining, Data Analytics, Data Visualization, Data Engineering, Data Architecture, Data Warehousing, ETL Tools, APIs, Large Language Models (LLMs), Artificial Intelligence (AI), Generative Artificial Intelligence (GenAI), Natural Language Processing (NLP), Deep Learning, Celonis, Minit, Mechanical Engineering, Predictive Modeling, Image Processing, Algorithms, Computer Vision, Simulations, Excel 365, Marketing Mix, B2C Marketing, SEO Marketing, Supply Chain
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