Rishi Gupta Email and Phone Number
At McKinsey & Company, my expertise in PySpark and Databricks Products elevates our data engineering capabilities, transforming complex datasets into actionable insights. With strategic roles in healthcare, finance, and insurance sectors, I've honed my skills in data engineering, modeling, and visualization to support critical decision-making processes. My analytical acumen is rooted in a dedication to integrating diverse technologies, ensuring that my contributions to ETL processes and data solutions are both innovative and effective. Collaboratively, our team has improved data-driven strategies that resonate across varied industries, embodying a mission to leverage data for impactful change.
Mckinsey & Company
View-
Senior Analytics EngineerMckinsey & Company Aug 2022 - PresentUsBuilding the Social, Healthcare and Public Sector practice tech - Led the end-to-end design and development of databases and ETL pipelines on DataBricks for healthcare data, focusing on segmentation, retention modelling, and optimizing data workflows.- Collaborated with national payors and government agencies to enhance outreach initiatives and co-develop innovative healthcare products.- Worked as part of a Consumer team, partnering with payors to design solutions targeted at Medicare and Medicaid populations, improving care management and patient engagement.- Engaged with healthcare providers to optimize care management strategies through data-driven insights and personalized care solutions.- Deployed unsupervised ML models, such as K-nearest, on survey data to inform product design and tested efficiency using advanced methods like XGBoost.- Implemented and fine-tuned supervised ML algorithms, including Random Forest, Decision Trees, and SHAP plots, to evaluate feature importance and ensure model accuracy in predictive healthcare solutions.- Collaborated cross-functionally with internal teams and external clients to develop models for pricing, claims, and consumer engagement, driving client growth, flexibility, and market reach.- Architected scalable client data solutions, including data lakes and warehouses, with robust data wrangling, integration, and mapping processes, ensuring seamless scalability.- Built and automated interactive, analytics-driven dashboards using Tableau and PowerBI, delivering actionable insights to clients and integrating them with cloud-based infrastructure.- Developed and maintained comprehensive documentation for data pipelines, ETL processes, and BI dashboards to ensure consistent knowledge transfer and reduce onboarding time.- Provided one-on-one mentoring and coaching to junior engineers and analysts, fostering a knowledge-sharing environment. -
Strategic Data Analyst IiM&T Bank Jun 2021 - Jul 2022Buffalo, New York, Us- Product lead for Repossession Remarketing Business, creating, updating, and maintaining- Automated end to end 3rd party data import performing data cleaning and Regex Operations using SQL/Python- Creating KPIs and Tableau Dashboards to perform in-depth analysis to improve business approach- Automate existing manual processes saving over $250,000 YoY - Interact and collect business requirement from stake holder, spearheading development project from start to end -
Data Analyst / Technical Program ManagerStarr Insurance Companies Apr 2020 - Apr 2021New York, Ny, Us-Lead Project from Concept to Design to Building and Shipping-Analyzing data to provide recommendation to help increase data quality-Creating Data Mapping Diagrams from Source Input to Downstream Systems-Designing and Testing SQL Based stored procedures to perform validations based on incoming data-Creating SQL views and tables to generate SSRS, Tableau and Power BI reports-Build interactive dashboard to communicate project status to stake holders-Maintain and support data integrity and functionality across all business reporting functions.-Extensive Use of Azure Devops, Git, SQL stored Procedures and ETL Process-Collaborates with Salesforce CRM developers to maintain, create, and update user roles, security, profiles, workflow rules -
Data Specialist ConsultantPencil Oct 2019 - Mar 2020San Francisco, Us-Building a detailed analysis on competitor growth and their financials, understanding the international market-Carry out detailed Market research on competitors, demography, geography using tableau, google analytics-Engaged in designing a Marketing strategy with focus to have a unique selling point helping both teachers and students-Understanding the competitive landscape and relative position in the market, to inform the product growth strategy and design -
Data Analytics Engineer/ Team LeadHca Healthcare Sep 2019 - Mar 2020Nashville, Tn, Us- Simplifying concepts and communicating to the overseas team of developers to design and create store procedures- Understanding the current process and implemented fixes to remove the anomalies from existing and new process- Defining metrics for the overseas team to easily analyze the files generated with the business requirements- Supporting the existing process in the production making sure our clients don’t get affected - Identified core customer problem and suggested a universal package to all the solutions for uniformity- Replicated the Pervasive Repository process to SQL Stored Procedures- Creating new Jobs and Triggers for Production Server changing the Production workflow- Actively interacting with users, team lead, DBA’s and technical manager to fully understand the business requirements.- Designed, built and launched SSIS packages for performing ETL (Extract, Transform and Load) operations- Extensive Use of Azure Devops for SQL stored Procedures and Sharepoint for Reporting -
Data Analyst InternPencil Oct 2018 - May 2019San Francisco, Us- Analyzing 100,000 survey data using SPSS and Tableau -Carry out detailed Market research on competitors, demography, geography using tableau, google analytics- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables- Creating a framework to improve the application and making it user-friendly for the target market- Building a detailed analysis on competitor growth and their financials, understanding the international market- Engaged in designing a Marketing strategy with focus to have a unique selling point helping both teachers and students- Understanding the competitive landscape and relative position in the market, to inform the product growth strategy and design -
Operations SpecialistNew York University Sep 2018 - May 2019New York, Ny, Us -
Marketing Data AnalystEmeec Invest Inc (Now Bits Stock) Aug 2018 - Oct 2018- Defined KPIs based on business requirements and presented to Stakeholders- Designed & Developed Email Marketing and Social Media Campaign- Analyzed data using SPSS & Tableau to provide customers insights to make meaningful investments - Developed a Market Mix Model to allocate the marketing budget effectively, increasing marketing qualified leads by 15%.
-
Data AnalystJersey Group W.L.L. May 2017 - Aug 2017Analyzed alternative techniques for energy consumption reduction and efficiency improvement- Developed an SQL database on CAFM Explorer with respect to machinery in the factory- Carried out Energy Audit/Power Quality Analysis in AlBateel Interior, reducing the energy cost by 30% - Responsible to carry out Power Quality Analysis for all clients under the Annual maintenance contracts for chillers- Providing detailed root cause analysis and modifications that can be done to reduce cost and improve efficiency
-
Systems EngineerSwitchgear International W.L.L Jan 2016 - Apr 2017- Data Visualization, Data input and Estimation of Projects - Interacting with High profile clients and Negotiating and suppliers - Developed a database system using Microsoft SQL, sorting the projects according to their status and timeline- Involved in the website SEO with respect to location, visualization - Responsible for conducting internal ISO audit of the company and listed company into Govt. Projects vendor list- Increased turnover by $3 million by bringing in high profile clients and projects - Initiated company’s new Annual maintenance division bringing in $500,000 /year -
Electrical EngineerHbk Contracting Company W.L.L Jul 2013 - Sep 2014Doha, Qa- Sheraton Park Project ▪ Site Engineer accountable for 40+ onsite labours and foremen and all mechanical and electrical work. Executed weekly meetings between the client, main contractors and head office- Gulf Mall Project – Testing and Commissioning team ▪ Hands-on knowledge on commissioning of 22 Low Voltage (415V) Switchgear Panels. Assisted in managing testing of the Building management system consisting of Extra-low voltage systems ▪ Assisting the Mechanical testing and commissioning team -
Engineering InternDoosan Aug 2012 - Jan 2013Seoul, KrIntern in the electrical engg. commissioning dept. commissioning the new Dubai Electrical and Water Authority(DEWA) power plant. It produces about 2000MW.
Rishi Gupta Education Details
-
New York UniversityIntegrated Marketing And Data Analytics -
University Of NottinghamElectrical Engineering In Sustainable And Renewable Ener -
Birla Institute Of Technology And Science, PilaniElectrical And Electronics Engineering
Frequently Asked Questions about Rishi Gupta
What company does Rishi Gupta work for?
Rishi Gupta works for Mckinsey & Company
What is Rishi Gupta's role at the current company?
Rishi Gupta's current role is Senior Analytics Engineer @ McKinsey & Company | MS, Integrated Marketing & Analytics.
What schools did Rishi Gupta attend?
Rishi Gupta attended New York University, University Of Nottingham, Birla Institute Of Technology And Science, Pilani.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial