Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic
Diptanshu Gautam

Diptanshu Gautam

Data Scientist
Bangalore/Bengaluru

Summary

Meticulous Data Scientist accomplished in compiling, transforming and analyzing complex information while communicating it to Stakeholder. Experienced in Stakeholder Management. Expert in machine learning and large dataset management. Demonstrated success in identifying relationships and building solutions to business problems.

Overview

6
6
years of professional experience
6
6
years of post-secondary education

Work History

Data Scientist

VMware India
Bangalore
05.2021 - Current
  • Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
  • Worked on large datasets to create complex and scalable models for finance and survey data which reduced effort of team by over 8-10 hours per week.
  • Worked on HIVE, Python, Presto to create data pipelines for curated datasets
  • Worked on E2E projects, dashboards with Stakeholder to deliver projects related to Survey Analytics which includes but not limited to Word Cloud Analytics, Sentiment Analysis
  • Created logic to calculated overall renewal rates of recurring revenue accounts, which is still being used across multiple team as standard definition and logic. This reduced over 8-10 additional man hours across APJ region
  • Helped in creating standard hierarchical structure for Geo level to standardize way data is being shown across globe for business
  • Worked with Analytics and Data Engineering team to doing multi layered UAT testing and brought many data tables to common platform
  • Mentored new joiners towards data understanding and data models and helped them design new solutions for business
  • Worked with telemetry for specific products and helped team design solution with bench marking capabilities.

Research Executive

Nielsen
Bangalore
02.2020 - 05.2021
  • Build and execute multiple forecasting time series models such as ARIMA using R and Python.
  • Creating Excel based Simulator for clients for various forecasting models which increased recurring customers by 10%
  • Worked with multiple offshore teams closely to create weekly time series ARIMA forecasting during pandemic period and delivered to clients on time which improved revenue of forecasting team by 16%
  • Work with team in anticipating key client issues and regularly offers suggestions on how our data can help.
  • Ensure deliverables required are delivered on time and on quality for all assigned projects
  • Multitasking and attention to details. Being able to manage 7 client projects at the same time.
  • Deliver insights, outcomes and added value to clients, whilst working closely with senior members of team. Having ability to form strong internal relationships and network in order to have more opportunities to collaborate.
  • Develops deep product and application which included multi single model and multi variate multi models for at least 10 clients, which resulted in revenue generation of close to ~$1mn.
  • Understand strengths and weaknesses opportunities and threats faced by key market players. Proactively seeking opportunities for improvements, working with other market analytics contacts to bring in best in class practices from other markets.
  • Working closely with senior members of teams in defining service level and analytical
    priorities.

Financial Planning Analyst

Ameriprise Financials
Gurgaon
06.2017 - 07.2019
  • Prepared comprehensive financial reports by collecting, formatting and analyzing key data points.
  • Used cost and schedule analysis to measure program performance trends and forecast delivery.
  • Maintained robust technical knowledge by regularly attending educational workshops and reviewing industry publications.
  • Recommended financial actions by assessing options in relation to company goals increasing ROI.
  • Developed monthly variance reports to highlight significant variances in cash flow and capital expenditures.
  • Monitored KPI to identify cause of unexpected variances.
  • Doing case analysis of financial plans and understanding the patterns within.
  • Creating financial plans for the clients to save their taxes and optimize their investments.
  • Worked on various retirement products such as IRA, 401(k), 403(b), SEP IRA.
  • Understanding tax structure of the clients by analyzing their 1040 statements and implementing them in the plan.
  • Understanding the strategies such as Roth Conversion, debt modification and debt consolidations and using them when required in the planning.
  • Understanding the various tax benefits, a client is eligible to avail at his present age and give suitable recommendations to save taxes and create wealth in long term

Education

Master of Science - Data Analytics

Christ University
Bangalore
07.2022 - Current

MBA - Finance

Christ University
Delhi
06.2015 - 07.2017

Bachelor of Science - Physics

Banaras Hindu University
Varanasi
08.2012 - 07.2015

Skills

    Machine learning

undefined

Interests

Trekking

Reading

Adventure

Dedicated

Disciplined

Timeline

Master of Science - Data Analytics

Christ University
07.2022 - Current

Data Scientist

VMware India
05.2021 - Current

Research Executive

Nielsen
02.2020 - 05.2021

Financial Planning Analyst

Ameriprise Financials
06.2017 - 07.2019

MBA - Finance

Christ University
06.2015 - 07.2017

Bachelor of Science - Physics

Banaras Hindu University
08.2012 - 07.2015
Diptanshu GautamData Scientist